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

Re: Truncate

From: Rod Taylor <rbt(at)zort(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Truncate
Date: 2002-08-20 15:31:43
Message-ID: 1029857504.99470.18.camel@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
On Tue, 2002-08-20 at 10:21, Tom Lane wrote:
> 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.

Corrected both of the above.

Attachment: truncate.patch
Description: text/plain (3.1 KB)
Attachment: truncate.sql
Description: text/x-sql (483 bytes)
Attachment: truncate.out
Description: text/plain (879 bytes)

In response to


pgsql-patches by date

Next:From: Tom LaneDate: 2002-08-20 15:34:41
Subject: Re: Truncate
Previous:From: Tom LaneDate: 2002-08-20 14:21:50
Subject: Re: Truncate

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