On 28.2.2012. 15:01, Marti Raudsepp wrote:
> On Sat, Feb 25, 2012 at 15:23, <rikard.pavelic@zg.htnet.hr> wrote:
>> This works:
>> alter table t1 add x float not null;
> Peeking at the code, currently any modifications that cause a rewrite
> of the original table are disallowed.
>
> Adding a nullable column without a default is allowed since it can be
> done without a rewrite -- all rows magically get the value NULL.
As shown in example above, I was adding not null column
(but table was empty so query passed)
> I'm not sure whether it's worth complicating code for this. If you
> want to store composite types in tables, I think you're better off
> using CREATE TYPE/ALTER TYPE.
I guess this falls under advanced type usage
(like recursive types - which can be used for lists)
which are not even recognized as important ;(
Regards,
Rikard
