| Subject: | last_insert_id() breaks when using table inheritance |
Pg.pm +321
I've only confirmed this in 2.8.7; but, it appears as if when you're
using Table Inherit's within pgsql, the function last_insert_id() breaks
and doesn't find the NEXTVAL (since the seq doesn't appear in the table
itself when inherited). Testing with Class::DBI I can manually
work-around the issue by setting the inherited sequence, but might wanna
see if there's a way to do this cleanly in the last_insert_id() fctn. I
dunno if that's possible using the catalog or not. Figured it was at
least worth documenting.