Re: [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Marti Raudsepp <marti(at)juffo(dot)org>, KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements.
Date: 2011-01-17 14:41:42
Message-ID: 1295275302.1455.18.camel@fsopti579.F-Secure.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On fre, 2011-01-14 at 18:45 -0500, Robert Haas wrote:
> On Fri, Jan 14, 2011 at 3:45 PM, Marti Raudsepp <marti(at)juffo(dot)org>
> wrote:
> > There's a similar case with CREATE TABLE IF NOT EXISTS, maybe this
> is
> > worth covering in an updated patch too?
> > And if I change that, people might expect the same from DROP X IF
> EXISTS too?
>
> It's far less clear what you'd change those cases to say, and they
> already emit a NOTICE, so it seems unnecessary.

Maybe instead of the proposed patch, a notice could be added:

NOTICE: existing object was replaced

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-01-17 15:03:46 Re: Replication logging
Previous Message David Fetter 2011-01-17 14:37:42 Re: psql: Add \dL to show languages