Re: Database vs bestanden?

Article View: be.comp.programming

Article #2903

Back to be.comp.programming Previous Next

#2903

From: Erik Hensema
Date: Thu, 04 Mar 2004 12:31

39 lines
3237 bytes

robert ({n.c.p}@allyourbass.org.invalid) wrote:
> Erik Hensema <usenet@smac.hensema.net>:
> > robert ({n.c.p}@allyourbass.org.invalid) wrote:
> >> Erik Hensema <usenet@smac.hensema.net>:
> >> > robert ({n.c.p}@allyourbass.org.invalid) wrote:
> >> >> Met ALTER TABLE krijg ik die niet toegevoegd:
> >> >> ERROR:  Adding columns with defaults is not implemented.
> >> >>         Add the column, then use ALTER TABLE SET DEFAULT.
> >> >
> >> > Nee, inderdaad, dat is niet echt prettig in postgres :-( In dit geval
> >> > kun je beter de tabel droppen en opnieuw maken ;-)
> >>
> >> Maar ik kan cities niet droppen zonder eerst capitals te droppen,
> >> vanwege de afhankelijkheid. En als ik daarna de zaak opnieuw aanmaak,
> >> met aangepaste cities tabel, werkt het vast wel :)
> >
> > In dat geval:
> >
> > alter table cities add IDcity integer;
> > create sequence cities_idcity_seq;
> > alter table cities alter IDcity set default nextval('cities_idcity_seq');
> > alter table cities alter IDcity set not null;
> > alter table cities add primary key (IDcity);
> 
> Daarna bevat capitals bij mij het volgende:
> 
>  idcity    | integer | not null default nextval('cities_idcity_seq'::text)

Dat klopt, en ook nog:

Indexes: cities_pkey primary key btree (idcity)

Probleem is dat die primary key niet in de child tables zit en je
er dus ook geen foreign keys naartoe kunt laten verwijzen.
-- 
Erik Hensema (erik@hensema.net)                             ICQ# 8280101
[Prime Minister Joseph] Chamberlain loves the working man -- he loves
to see him work.
		-- Winston Churchill

Technical Details

Message-ID: <slrnc4e8d4.2fl.usenet@bender.home.hensema.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!news-out.visi.com!green.octanews.net!news-out.octanews.net!news.glorb.com!newsgate.cistron.nl!transit.news.xs4all.nl!humbolt.nl.linux.org!news.nl.linux.org!news.hensema.net!not-for-mail

References:

<_et1c.22284$SL3.1605761@phobos.telenet-ops.be> <o7pc40515um0omqo4hnb2aqc2bb62d8028@4ax.com> <40467a4c$0$565$e4fe514c@news.xs4all.nl> <sjsd401e9mfd1r1hlo06rosdpg94gh3cv4@4ax.com> <c2722m.1fg.1@news.isolution.nl> <slrnc4e0tg.1ml.usenet@bender.home.hensema.net> <slrnc4e23g.ch4.robert@home.allyourbass.org> <slrnc4e3cb.1ml.usenet@bender.home.hensema.net> <slrnc4e4eb.ch4.robert@home.allyourbass.org> <slrnc4e6f3.2a2.usenet@bender.home.hensema.net> <slrnc4e7p4.ch4.robert@home.allyourbass.org>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,7a8fc8eaa24f5371
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,7a8fc8eaa24f5371
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2004-03-04 04:31:33 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!news-out.visi.com!green.octanews.net!news-out.octanews.net!news.glorb.com!newsgate.cistron.nl!transit.news.xs4all.nl!humbolt.nl.linux.org!news.nl.linux.org!news.hensema.net!not-for-mail
From: Erik Hensema <usenet@smac.hensema.net>
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: Database vs bestanden?
Date: Thu, 4 Mar 2004 12:31:33 +0000 (UTC)
Organization: Hensema
Lines: 39
Message-ID: <slrnc4e8d4.2fl.usenet@bender.home.hensema.net>
References: <_et1c.22284$SL3.1605761@phobos.telenet-ops.be> <o7pc40515um0omqo4hnb2aqc2bb62d8028@4ax.com> <40467a4c$0$565$e4fe514c@news.xs4all.nl> <sjsd401e9mfd1r1hlo06rosdpg94gh3cv4@4ax.com> <c2722m.1fg.1@news.isolution.nl> <slrnc4e0tg.1ml.usenet@bender.home.hensema.net> <slrnc4e23g.ch4.robert@home.allyourbass.org> <slrnc4e3cb.1ml.usenet@bender.home.hensema.net> <slrnc4e4eb.ch4.robert@home.allyourbass.org> <slrnc4e6f3.2a2.usenet@bender.home.hensema.net> <slrnc4e7p4.ch4.robert@home.allyourbass.org>
Reply-To: erik@hensema.net
NNTP-Posting-Host: bender.ipv6.hensema.net
X-Trace: dexter.hensema.net 1078403493 20182 2001:888:10a1:0:202:44ff:fe69:60f5 (4 Mar 2004 12:31:33 GMT)
X-Complaints-To: news@hensema.net
NNTP-Posting-Date: Thu, 4 Mar 2004 12:31:33 +0000 (UTC)
User-Agent: slrn/0.9.7.4 (Linux)

Reply to Parent Message