Re: [HACKERS] [GENERAL] plpgsql constraint checked data fails to restore

2005-06-23 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > I think pg_dump should add the check constraints in the same manner as > it does triggers. > Bruce, do we have a TODO item for this? No, because that idea has been proposed and rejected before --- it adds overhead (extra table scans) and reduces readability

Re: [HACKERS] [GENERAL] plpgsql constraint checked data fails to restore

2005-06-23 Thread Jan Wieck
Added pgsql-hackers Added Bruce Momjian On 6/23/2005 12:19 PM, Michael Fuhr wrote: The question I have is how exactly you manage to get the trigger fired when restoring the dump. By default, the dump created by pg_dump will create the table, fill in the data and create the trigger(s) only afte