Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group