Article View: be.comp.programming
Article #2930Re: Database vs bestanden?
From: Sjoerd A. Schreuder
Date: Fri, 05 Mar 2004 00:40
Date: Fri, 05 Mar 2004 00:40
18 lines
2275 bytes
2275 bytes
Theo wrote:
> "Sjoerd A. Schreuder" <sa_schreuder@wanadoo.nl> wrote in message
> news:40474818.6EFC2982@wanadoo.nl...
>
>>Erik Hensema wrote:
>>[Over ProgreSQL]
>>
>>>alter table cities alter IDcity set default nextval('cities_idcity_seq');
>
>>Hoe vaak ik al niet gewenst heb dat dit in Oracle mogelijk zou zijn...
>
> Dat is toch met 1 klein triggertje gepiept?
> Kleine moeite, lijkt me.
Dacht ik ook. Totdat bleek dat je vanuit een 'before insert' trigger
geen nextval op sequences mag aanroepen. :-(
Sjoerd Schreuder
Technical Details
Message-ID:
<4047cc7d$0$2414$4a441750@news.euronet.nl>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news.osn.de!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!news2.euro.net!postnews1.euro.net!news.euronet.nl!not-for-mailReferences:
<_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> <40474818.6EFC2982@wanadoo.nl> <c2824f$1fji$1@nl-news.euro.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 16:40:38 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news.osn.de!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!news2.euro.net!postnews1.euro.net!news.euronet.nl!not-for-mail Date: Fri, 05 Mar 2004 01:40:30 +0100 From: "Sjoerd A. Schreuder" <sa_schreuder@wanadoo.nl> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: be.comp.programming,nl.comp.programmeren Subject: Re: Database vs bestanden? 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> <40474818.6EFC2982@wanadoo.nl> <c2824f$1fji$1@nl-news.euro.net> In-Reply-To: <c2824f$1fji$1@nl-news.euro.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 19 Message-ID: <4047cc7d$0$2414$4a441750@news.euronet.nl> Organization: EuroNet Internet NNTP-Posting-Date: 05 Mar 2004 00:40:29 GMT NNTP-Posting-Host: cd511329e.cable.wanadoo.nl X-Trace: 1078447229 news.euronet.nl 2414 213.17.50.158:3402 X-Complaints-To: abuse@euronet.nl