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
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. |