Actually this sounds like a TODO to me. I imagine the db knows the schema and it's just not reporting it in the error message. Bruce? Tom? On Tue, Oct 14, 2008 at 9:43 AM, Andrus <kobruleht2@xxxxxx> wrote: > FK violation erroro is displayed as > > 7/23503:ERROR: insert or update on table "summak" violates foreign key > constraint "summak_kontonr_fkey1" > Key (kontonr)=(2421 ) is not present in table "konto". > > I have large numbers of schemas all containing tables with same name. > > How to determine schema name where error occurs? > > Andrus. > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- When fascism comes to America, it will be draped in a flag and carrying a cross - Sinclair Lewis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general