Re: CREATE SCHEMA IF NOT EXISTS - Mailing list pgsql-hackers

From Volker Grabsch
Subject Re: CREATE SCHEMA IF NOT EXISTS
Date
Msg-id 20120929093213.GE16144@vlap
Whole thread Raw
In response to Re: CREATE SCHEMA IF NOT EXISTS  ("Dickson S. Guedes" <listas@guedesoft.net>)
Responses Re: CREATE SCHEMA IF NOT EXISTS
List pgsql-hackers
Dickson S. Guedes schrieb:
> - https://commitfest.postgresql.org/action/patch_view?id=907
> 
> The patch is small and implements a new syntax to CREATE SCHEMA
> that allow the creation of a schema be skipped when IF NOT EXISTS is
> used.
>
> [...]
>
> - Should this patch implements others INEs like ADD COLUMN IF NOT EXISTS?

If there's still a chance to improve the patch, I'd love to see
the following INEs implemented. Several real-world database
upgrade scripts would benefit from those:

1)
CREATE [ TEMPORARY | TEMP ] SEQUENCE [ IF NOT EXISTS ] name ...

2)
ALTER TABLE ... ADD [ COLUMN ] [ IF NOT EXISTS ] column_name ...

3)
CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ IF NOT EXISTS ] [ name ] ON ...


Regards,
Volker

-- 
Volker Grabsch
---<<(())>>---



pgsql-hackers by date:

Previous
From: Misa Simic
Date:
Subject: Re: data to json enhancements
Next
From: Andrew Dunstan
Date:
Subject: pg_upgrade tests vs alter generic changes