From: | Bo Lorentsen <bl(at)netgroup(dot)dk> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Insert rule and seqences |
Date: | 2001-09-03 10:39:41 |
Message-ID: | 3B935DED.3DF47C00@netgroup.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi ...
I would be very happy if someone could please give me a hint on this
subject, as PosgreSQL confuses me on this matter.
I have been trying to make a simple rule upon a insert statement to a
table that refers to a sequence, but I keep getting this strange error
every time i use this rule, saying :
ERROR: entity_seq.currval is not yet defined in this session
The idea is that I have two tables I like to bind on a insert to one of
them, like this :
CREATE SEQUENCE entity_seq;
CREATE TABLE A (
id INTEGER DEFAULT nextval( 'entity_seq' ),
name TEXT
);
CREATE TABLE B (
name TEXT,
a_ref INTEGER NOT NULL -- REFERENCES A( id )
);
CREATE RULE insert_on_a
AS ON INSERT
TO A (
INSERT INTO B name, a_ref VALUES( name, currval( 'entity_seq'
));
);
Is this all wrong, or is the another way to get the new 'id' value from
the A table ?
Im looking forward to be enlightened :-)
/BL
From | Date | Subject | |
---|---|---|---|
Next Message | Jochem van Dieten | 2001-09-03 19:18:33 | Re: Insert rule and seqences |
Previous Message | Robert Kleemann | 2001-09-03 03:28:38 | how to easily reduce permissions? |