Re: patch: ALTER TABLE IF EXISTS - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: patch: ALTER TABLE IF EXISTS
Date
Msg-id 0390cf80a919431190f5e23710388a60.squirrel@sq.gransy.com
Whole thread Raw
In response to patch: ALTER TABLE IF EXISTS  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: patch: ALTER TABLE IF EXISTS  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On 2 Leden 2012, 14:11, Pavel Stehule wrote:
> Hello
>
> this is relative simple patch that add possibility to skip noexisting
> tables. It is necessary for silent cleaning when dump is loaded.

Just a curious question - what use case is solved by this? Under what
circumstances you get an ALTER TABLE without a preceding CREATE TABLE? I
can't think of such scenario ...

Or is this meant for scripts written manually so that it's possible to do
alter if the table already exists and create if it does not exist?

Tomas



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: patch: ALTER TABLE IF EXISTS
Next
From: Pavel Stehule
Date:
Subject: Re: patch: ALTER TABLE IF EXISTS