Hi, On Wed, 02 Jul 2008, Tom Lane <[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. Temporarily 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
