Re: patch: ALTER TABLE IF EXISTS

From: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: patch: ALTER TABLE IF EXISTS
Date: 2012-01-02 13:59:24
Message-ID: 0390cf80a919431190f5e23710388a60.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2012-01-02 14:14:57 Re: patch: ALTER TABLE IF EXISTS
Previous Message Simon Riggs 2012-01-02 13:47:36 Re: patch: ALTER TABLE IF EXISTS