trigger that needs a PK

Поиск
Список
Период
Сортировка
Искать
От
johnf
Тема
trigger that needs a PK
Дата
Msg-id
200802122320.46356.jfabiani@yolo.com
Список
Дерево обсуждения
trigger that needs a PK johnf <jfabiani@yolo.com>
Re: trigger that needs a PK "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: trigger that needs a PK Tom Lane <tgl@sss.pgh.pa.us>
Re: trigger that needs a PK johnf <jfabiani@yolo.com>
Re: trigger that needs a PK johnf <jfabiani@yolo.com>
Re: trigger that needs a PK "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: trigger that needs a PK johnf <jfabiani@yolo.com>
SQL LEFT JOIN and WHERE Rai Developer <coder@montx.com>
Re: SQL LEFT JOIN and WHERE Shane Ambler <pgsql@Sheeky.Biz>
Re: SQL LEFT JOIN and WHERE Rai Developer <coder@montx.com>
Re: SQL LEFT JOIN and WHERE Shane Ambler <pgsql@Sheeky.Biz>
Re: SQL LEFT JOIN and WHERE Rai Developer <coder@montx.com>
Re: SQL LEFT JOIN and WHERE Rai Developer <coder@montx.com>
Re: SQL LEFT JOIN and WHERE Rai Developer <coder@montx.com>
Re: SQL LEFT JOIN and WHERE Stephan Szabo <sszabo@megazone.bigpanda.com>
Hi,
I'm sure this question has been ask before but I could not find anything on 
google.  I most likely did not enter the right text into the google search.

I have a parent table that requires that an insert into a child table happen.  
The problem is I can not determine what the parent pk is for the insert into 
the child because it hasn't happen yet - if I set the trigger to before 
insert.  So I guess I need something that works with after insert into the 
parent so the pkid can be created.

The parent has:
pkid serial
lot varchar 30

the child:
pkid serial
fk_parent int
other fields....

The question is how can I get the pk and insert it into the child.  Of course 
I'm new so if I missed something just provide the link or tutorial.  

Thanks in advance!


-- 
John Fabiani
В списке pgsql-novice по дате отправления
От: Greg Cocks
Дата:
От: A. Kretschmer
Дата:
Сообщение: Re: trigger that needs a PK
FAQ