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