| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| tbl_ins_test.sct | application/octet-stream | 1.5 KB |
| ins_rule_test.sql | application/octet-stream | 439 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-02-16 16:19:56 | Re: create table bug with reserved words? |
| Previous Message | Chris Storah | 2001-02-16 09:27:43 | RE: create table bug with reserved words? |