Re: BUG #6489: Alter table with composite type/table

On 28.2.2012. 15:01, Marti Raudsepp wrote:
> On Sat, Feb 25, 2012 at 15:23, <rikard(dot)pavelic(at)zg(dot)htnet(dot)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