On 28.2.2012. 15:01, Marti Raudsepp wrote: > On Sat, Feb 25, 2012 at 15:23, <rikard.pave...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs