Re: [HACKERS] Unexpected collation error in 9.1.1

2011-10-03 Thread Christian Ullrich
* Tom Lane wrote: Christian Ullrich writes: I tried adding a not-null column in one step and got a collation error for a different column. itd=> alter table livedata add column pricechanged timestamp not null default current_timestamp; ERROR: no collation was derived for column "whois_

Re: [HACKERS] Unexpected collation error in 9.1.1

2011-10-03 Thread Tom Lane
Christian Ullrich writes: > I tried adding a not-null column in one step and got a collation > error for a different column. > itd=> alter table livedata add column pricechanged timestamp not null default > current_timestamp; > ERROR: no collation was derived for column "whois_b" with collatabl

[HACKERS] Unexpected collation error in 9.1.1

2011-10-03 Thread Christian Ullrich
I tried adding a not-null column in one step and got a collation error for a different column. Adding the column in several steps works: itd=> alter table livedata add column pricechanged timestamp not null default current_timestamp; ERROR: no collation was derived for column "whois_b" with co