On 11/20/2013 03:41 PM, Pavel Stehule wrote: > > It'd be great if there was a sane way to implement "CREATE OR REPLACE > TABLE" - since that's what people really want a lot of the time. "Ensure > that at the end of this command the table looks like this". There's just > no sane way to do that for a non-empty table. > > > I disagree - CREATE OR REPLACE FUNCTION has sense, because new function > can has same interface (and will be overwriten) or different (and there > will be two functions). So with CREATE OR REPLACE TABLE there are two > new questions - has to new table respect original interface and what > about content? I don't think so CREATE OR REPLACE TABLE is good idea.
Er, that's what I was saying. It'd be great if it were possible to do it sanely, but it isn't. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers