Postgres Pro
Downloads
Home   >   mailing lists

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

From Fabrízio de Royes Mello
Subject Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
Date
Msg-id CAFcNs+qpDGu-jFoNk1oBKDBG3W=NTC3tc0CXwGC1h-kg3cHzgQ@mail.gmail.com
Whole thread Raw
In response to Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
List pgsql-hackers
Tree view 
<div dir="ltr"><div class="gmail_extra"><br />On Mon, Mar 31, 2014 at 5:00 PM, Stephen Frost <<a
href="mailto:sfrost@snowman.net">sfrost@snowman.net</a>>wrote:<br />><br />> * Fabrízio de Royes Mello (<a
href="mailto:fabriziomello@gmail.com">fabriziomello@gmail.com</a>)wrote:<br /> > > On Mon, Mar 31, 2014 at 4:52
PM,Stephen Frost <<a href="mailto:sfrost@snowman.net">sfrost@snowman.net</a>> wrote:<br />> > ><br
/>>> > * Fabrízio de Royes Mello (<a href="mailto:fabriziomello@gmail.com">fabriziomello@gmail.com</a>)
wrote:<br/> > > > > - CREATE SEQUENCE [ IF NOT EXISTS ]<br />> > > > - CREATE DOMAIN [ IF NOT
EXISTS]<br />> > > > - CREATE EVENT TRIGGER [ IF NOT EXISTS ]<br />> > > > - CREATE ROLE [ IF
NOTEXISTS ]<br /> > > > ><br />> > > > Seems that no one reviewed this part or was rejected
withothers?<br />> > ><br />> > > Why don't those fall into the same concern, specifically that what
we<br/> > > > really want is 'CREATE-OR-REPLACE' semantics for them instead?<br />> > ><br />>
><br/>> > Ok, but I think this semantics is desirable just to "CREATE DOMAIN" and<br />> > "CREATE EVENT
TRIGGER".<br/> > ><br />> > Isn't desirable add CINE to SEQUENCEs and ROLEs?<br />><br />> Why would
itbe difficult to have COR for sequences..?  Or roles?<br />><br /><br />Because they maintain user data?<br /><br
/>--<br/>Fabrízio de Royes Mello<br /> Consultoria/Coaching PostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/>>> Blog sobre TI: <a
href="http://fabriziomello.blogspot.com">http://fabriziomello.blogspot.com</a><br/> >> Perfil Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/>>> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a></div></div>

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: B-Tree support function number 3 (strxfrm() optimization)
Next
From: Christoph Berg
Date:
Subject: Re: Securing "make check" (CVE-2014-0067)