On Sun, Nov 17, 2013 at 6:05 PM, David E. Wheeler <da...@justatheory.com>wrote:
> On Nov 16, 2013, at 4:40 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > >> Co-worker asked a question I could not answer: Why is IF NOT EXISTS not > supported by CREATE TABLE AS? > > > > That's an even worse idea than plain CREATE IF NOT EXISTS (which was > > put in over vocal objections from me and some other people). Not only > > would you not have the faintest clue as to the properties of the table > > afterwards, but no clue as to its contents either. > > You mean that, after running it, one cannot tell whether or not a new > table was created or not without looking at it? I guess that makes sense, > though sometimes I like to tell the system to assume that I know what I’m > doing -- e.g., that either outcome works for me. > > Not essential as a core feature, mind you; I can use DO to accomplish the > same thing. It’s just a bit more work that way. And perhaps that’s for the > best. > > I'm planning to implement it for the next commit fest (2014-01)... Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Timbira: http://www.timbira.com.br >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello