Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
Date
Msg-id 20140331200049.GZ4582@tamriel.snowman.net
Whole thread Raw
In response to Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Responses Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
List pgsql-hackers
* Fabrízio de Royes Mello (fabriziomello@gmail.com) wrote:
> On Mon, Mar 31, 2014 at 4:52 PM, Stephen Frost <sfrost@snowman.net> wrote:
> >
> > * Fabrízio de Royes Mello (fabriziomello@gmail.com) wrote:
> > > - CREATE SEQUENCE [ IF NOT EXISTS ]
> > > - CREATE DOMAIN [ IF NOT EXISTS ]
> > > - CREATE EVENT TRIGGER [ IF NOT EXISTS ]
> > > - CREATE ROLE [ IF NOT EXISTS ]
> > >
> > > Seems that no one reviewed this part or was rejected with others?
> >
> > Why don't those fall into the same concern, specifically that what we
> > really want is 'CREATE-OR-REPLACE' semantics for them instead?
> >
>
> Ok, but I think this semantics is desirable just to "CREATE DOMAIN" and
> "CREATE EVENT TRIGGER".
>
> Isn't desirable add CINE to SEQUENCEs and ROLEs?

Why would it be difficult to have COR for sequences..?  Or roles?
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
Next
From: steve k
Date:
Subject: Re: PQputCopyData dont signal error