Re: Database vs bestanden?

Article View: be.comp.programming

Article #2894

Back to be.comp.programming Previous Next

#2894

From: robert
Date: Thu, 04 Mar 2004 10:44

25 lines
2077 bytes

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.

-- 
                                                                   robert

Technical Details

Message-ID: <slrnc4e23g.ch4.robert@home.allyourbass.org>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!pop-news-1.colt-telecom.nl!newsgate.cistron.nl!news.cistron.nl!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>

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 02:44:01 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!pop-news-1.colt-telecom.nl!newsgate.cistron.nl!news.cistron.nl!not-for-mail
From: {n.c.p}@allyourbass.org.invalid (robert)
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: Database vs bestanden?
Date: Thu, 4 Mar 2004 10:44:00 +0000 (UTC)
Organization: All Your Bass Are Belong To Us
Lines: 25
Message-ID: <slrnc4e23g.ch4.robert@home.allyourbass.org>
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>
NNTP-Posting-Host: cust.91.90.adsl.cistron.nl
X-Trace: ncc1701.cistron.net 1078397040 6349 195.64.91.90 (4 Mar 2004 10:44:00 GMT)
X-Complaints-To: abuse@cistron.nl
NNTP-Posting-Date: Thu, 4 Mar 2004 10:44:00 +0000 (UTC)
User-Agent: slrn/0.9.7.4 (Darwin)

Reply to Parent Message