Unexpected collation error in 9.1.1

From: Christian Ullrich <chris(at)chrullrich(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Unexpected collation error in 9.1.1
Date: 2011-10-03 11:05:53
Message-ID: j6c4uh$7nm$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 collatable type citext
TIP: Use the COLLATE clause to set the collation explicitly.

itd=> \d livedata
Table "public.livedata"
Column | Type | Modifiers
--------------+-----------------------------+-----------------------------------------
accessid | integer | not null
sp_b | double precision | default 0
csh_b | double precision | default 0
sp_a | double precision | default 0
csh_a | double precision | default 0
asw_b | double precision | default 0
asw_a | double precision | default 0
amount | character varying(25) | default ' '::character varying
bench | character varying(25) | default NULL::character varying
updated_b | date |
updated_a | date |
whois_b | citext | default ' '::character varying
whois_a | citext | default ' '::character varying
b_orig | double precision | default 0
a_orig | double precision | default 0
lcontrol | integer | not null default 0
rcontrol | integer | not null default 0
hlcleared | boolean | not null default false
yield_b | double precision | default 0
yield_a | double precision | default 0

itd=> alter table livedata add column pricechanged timestamp;
ALTER TABLE
itd=> alter table livedata alter column pricechanged set default current_timestamp;
ALTER TABLE
itd=> update livedata set pricechanged = default;
UPDATE 6000
itd=> alter table livedata alter column pricechanged set not null;
ALTER TABLE

--
Christian

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Royce Ausburn 2011-10-03 13:17:54 Re: [PATCH] Unremovable tuple monitoring (was: Addition of some trivial auto vacuum logging)
Previous Message Amit Khandekar 2011-10-03 10:20:30 Re: Re: [COMMITTERS] pgsql: Force strings passed to and from plperl to be in UTF8 encoding.