Michael Shulman wrote:
> I want to be able to do INSERTs on "studentinfo" and have rows created
> in both "person" and "student". This requires first inserting into
> "person", capturing the "person_id" of the resulting row, and using it
> to insert into "student". This seems as though it must be a common
> situation.
Have you considered using table inheritance to solve this?
It has some limitations, and I've never seen the need myself, but it
sounds like it might fit your needs.
http://www.postgresql.org/docs/8.3/static/ddl-inherit.html
--
Craig Ringer