Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements

<div dir="ltr">On Mon, Jun 17, 2013 at 11:33 PM, Peter Eisentraut <<a
href="mailto:peter_e@gmx.net">peter_e@gmx.net</a>>wrote:<br />><br />> Replace/alter the object if it already
exists,but fail if it does not<br /> > exist.<br />><br />> The complete set of variants is:<br />><br
/>>- object does not exist:<br />><br />>     - proceed (normal CREATE)<br />>     - error (my above
description)<br/>><br />> - object exists:<br /> ><br />>     - replace (CREATE OR REPLACE)<br />>     -
skip(CREATE IF NOT EXISTS)<br />>     - error (normal CREATE)<br />><br /><br />I understood. <br /><br />The
syntaxcan be like that?<br />- CREATE [ OR REPLACE | IF NOT EXISTS ] AGGREGATE ...<br /> - CREATE [ OR REPLACE | IF NOT
EXISTS] OPERATOR ...<br />- CREATE [ OR REPLACE | IF NOT EXISTS ] FUNCTION ...<br /><br />I can add this features too,
butIMHO it is more prudent at this CF we just implement the IF NOT EXISTS according the initial proposal.<br /><br
/>I'mplanning another patch do next CF to add support to "IF NOT EXISTS" to others "CREATE" statements. See my planning
[1].<br/><br />Regards,<br /><br />[1] <a
href="https://docs.google.com/spreadsheet/ccc?key=0Ai7oCVcVQiKFdEctQUxNNlR1R2xRTUpJNFNDcFo4MUE&usp=sharing">https://docs.google.com/spreadsheet/ccc?key=0Ai7oCVcVQiKFdEctQUxNNlR1R2xRTUpJNFNDcFo4MUE&usp=sharing</a><br
/><br/>--<br />Fabrízio de Royes Mello<br />Consultoria/Coaching PostgreSQL<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><br/></div>