Re: Database vs bestanden?

Article View: be.comp.programming

Article #2898

Back to be.comp.programming Previous Next

#2898

From: Erik Hensema
Date: Thu, 04 Mar 2004 11:05

31 lines
2353 bytes

robert ({n.c.p}@allyourbass.org.invalid) wrote:
> Erik Hensema <usenet@smac.hensema.net>:
> > Ik vind van niet. Probleem is dat foreign keys opeens niet meer werken
> > als je object georienteerd gaat werken in postgres:
> >
> > CREATE TABLE cities (
> >      name            text,
> >      population      float,
> >      altitude        int     -- (in ft)
> >  );
> >
> >  CREATE TABLE capitals (
> >      state           char(2)
> >  ) INHERITS (cities);
> >
> > Dat komt gewoon uit de manual van postgres.
> >
> > Voeg aan de table cities een primaire sleutel toe. Bijvoorbeeld:
> > IDcity serial PRIMARY KEY
> 
> 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 ;-)

-- 
Erik Hensema (erik@hensema.net)                             ICQ# 8280101
Quoting-HOWTO: http://www.leerquoten.nl

Technical Details

Message-ID: <slrnc4e3cb.1ml.usenet@bender.home.hensema.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news2.telebyte.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>

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 03:05:49 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news2.telebyte.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 11:05:47 +0000 (UTC)
Organization: Hensema
Lines: 31
Message-ID: <slrnc4e3cb.1ml.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>
Reply-To: erik@hensema.net
NNTP-Posting-Host: bender.ipv6.hensema.net
X-Trace: dexter.hensema.net 1078398347 9349 2001:888:10a1:0:202:44ff:fe69:60f5 (4 Mar 2004 11:05:47 GMT)
X-Complaints-To: news@hensema.net
NNTP-Posting-Date: Thu, 4 Mar 2004 11:05:47 +0000 (UTC)
User-Agent: slrn/0.9.7.4 (Linux)

Reply to Parent Message