Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Using ctid in delete statement - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Using ctid in delete statement
Date
Msg-id CAKFQuwZrtza0DNzj+UnHg++46WywcQUTvPoRmWDX-s-WWV6xcQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Using ctid in delete statement  (pinker <pinker@onet.eu>)
List pgsql-general
Tree view
On Thu, Feb 16, 2017 at 7:52 AM, pinker <pinker@onet.eu> wrote:
Adrian Klaver-4 wrote
> https://www.postgresql.org/docs/9.6/static/sql-truncate.html
>
> https://www.postgresql.org/docs/9.6/static/sql-delete.html

There is nothing about FOR UPDATE clause on those pages...

​Both truncate and delete are commands the inherently update tables - there is no need to have a separate FOR UPDATE clause.

Dave
​

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Using ctid in delete statement
Next
From: Steve Crawford
Date:
Subject: Re: [GENERAL] postgresql how to duplicate rows in result.