Search Postgresql Archives

Re: How to get schema name which violates fk constraint

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux