Hi,
On Wed, 02 Jul 2008, Tom Lane <tgl@[EMAIL PROTECTED]
> writes:
> Are there any foreign keys referencing this table? If so, you're
> probably running out of memory for the list of pending trigger events
> (to verify that the FK constraint isn't violated by the delete).
>
> Allowing the triggers to fire individually would take forever anyway,
> so it might be best to drop the foreign key constraint(s) and then
> re-establish them after the delete.
Thanks for the warning. Tem****arily disabling FKs did the job. I knew
the problem about triggers, but didn't expect same applies for FKs
also. I'm very suprised FKs cause memory exhaustion too.
Regards.
--
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
