On Tue, Jun 17, 2008 at 7:56 AM, Philippe Grégoire
<[EMAIL PROTECTED]> wrote:
> CREATE RULE studentinro_insert AS ON INSERT TO studentinfo
> DO INSTEAD
> (
> INSERT INTO person ...;
> INSERT INTO student(person_id,...) VALUES
> (currval('person_person_id_seq'),...);
> );I initially thought of this, but discounted it because if the original insert query tried to set person_id directly (instead of getting it from the default sequence) the supplied value would have to be discarded. I have any plans to do anything of the sort, though, and I suppose the user has little right to expect to be able to do such a thing safely anyway. So perhaps this is the simplest solution; thanks. Mike -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
