On Thu, 10 Jan 2019 at 12:13, Tom Lane wrote:
> For indivisible database objects such as functions, IMV the "or replace"
> semantics (COR) is better than the "if not exists" semantics (CINE)...
>
> For tables, though, the tradeoffs seem pretty different...
Thanks Tom, your explanation makes a lot
Aidan Samuel writes:
> How come table creation doesn't allow [ OR REPLACE ], and view creation
> doesn't allow [ IF NOT EXISTS ]? Is this just how the SQL spec defines
> things?
I think all that stuff is our own fault rather than something you can
find in the SQL spec.
For indivisible database o