Re: Truncate

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Truncate
Date: 2002-08-20 14:21:50
Message-ID: 5577.1029853310@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Rod Taylor <rbt(at)zort(dot)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

In response to

  • Truncate at 2002-08-20 03:45:52 from Rod Taylor

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Rod Taylor 2002-08-20 15:31:43 Re: Truncate
Previous Message Jan Wieck 2002-08-20 14:10:22 Re: first cut at PL/PgSQL table functions