Re: Truncate - Mailing list pgsql-patches

From Tom Lane
Subject Re: Truncate
Date
Msg-id 5577.1029853310@sss.pgh.pa.us
Whole thread Raw
In response to Truncate  (Rod Taylor <rbt@zort.ca>)
Responses Re: Truncate  (Rod Taylor <rbt@zort.ca>)
List pgsql-patches
Rod Taylor <rbt@zort.ca> writes:
> The issue with finding and removing foreign key constraints is no longer
> an issue, so please apply the attached.

I do not like adding a system-table index just for the convenience of
this one not-very-time-critical function.  Please rewrite the patch
without that.

BTW, if you are only reading the table and not writing it, the correct
lock type to get is AccessShareLock, not RowExclusiveLock.

            regards, tom lane

pgsql-patches by date:

Previous
From: Jan Wieck
Date:
Subject: Re: first cut at PL/PgSQL table functions
Next
From: Rod Taylor
Date:
Subject: Re: Truncate