Postgres Pro
Downloads
Home   >   mailing lists

Re: WARNING: foreign key constraint will require costly sequential scans during pg_restore - Mailing list pgsql-admin

From Tom Lane
Subject Re: WARNING: foreign key constraint will require costly sequential scans during pg_restore
Date
Msg-id 11982.1140622237@sss.pgh.pa.us
Whole thread Raw
In response to WARNING: foreign key constraint will require costly sequential scans during pg_restore  (CG <cgg007@yahoo.com>)
List pgsql-admin
Tree view 
CG <cgg007@yahoo.com> writes:
> pg_restore: WARNING:  foreign key constraint "luuid_fkey" will require costly
> sequential scans
> DETAIL:  Key columns "luuid" and "luuid" are of different types:
> public.uniqueidentifier and public.uniqueidentifier.

That seems a bit odd.  Would you provide a test case?

            regards, tom lane

pgsql-admin by date:

Previous
From: CG
Date:
Subject: WARNING: foreign key constraint will require costly sequential scans during pg_restore
Next
From: Andy Shellam
Date:
Subject: WAL recovery