Skip site navigation (1) Skip section navigation (2)

Rules for Inserting Serials

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Rules for Inserting Serials
Date: 2001-02-16 15:33:48
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E017CB7DD@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-bugs
I'm running the 7.1Beta4 (rpm binary) version on Mandrake 7.1. Rules that
insert serials from the new object into another table don't give the same
value as those inserted in the actual table. This looks to have been covered
b4 here:
http://www.postgresql.org/mhonarc/pgsql-bugs/2000-04/msg00060.html
If this is indeed to remain the case I think it should be clearly documented
in the rules section (I guess it would affect all defaults that use
functions).
Any way heres my script and stuff:
 <<tbl_ins_test.sct>>  <<ins_rule_test.sql>> 
- Stuart

Attachment: ins_rule_test.sql
Description: application/octet-stream (439 bytes)
Attachment: tbl_ins_test.sct
Description: application/octet-stream (1.5 KB)

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-02-16 16:19:56
Subject: Re: create table bug with reserved words?
Previous:From: Chris StorahDate: 2001-02-16 09:27:43
Subject: RE: create table bug with reserved words?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group