From: | Björn Häuser <bjoernhaeuser(at)gmail(dot)com> |
---|---|
To: | Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br> |
Cc: | "'pgsql'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Alter column...using failure under 9.0.4 |
Date: | 2011-09-25 15:43:15 |
Message-ID: | 4D57E612-6569-4817-ACC1-E55049AE4F1B@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hello,
you could check for indices or something like that.
Björn
Am 25.09.2011 um 17:17 schrieb Edson Carlos Ericksson Richter:
> Dear list,
>
> I’ve a strange issue here. I’ve a table that I’m sure the column type is boolean. I can see the datatype is boolean on PgAdmin.
>
> Nevertheless, when I issue this command
> --------------------------------------------------------------------------------
> alter table usuario alter column ativo type smallint using (case when ativo then 1 else 0 end);
> --------------------------------------------------------------------------------
>
> I get the following error:
> --------------------------------------------------------------------------------
> ERROR: argument of IS FALSE must be type boolean, not type smallint
>
> ********** Error **********
>
> ERROR: argument of IS FALSE must be type boolean, not type smallint
> SQL state: 42804
> --------------------------------------------------------------------------------
>
> I already run Vacuum just to be sure, but still not working.
>
> I have a script with hundred similar lines (for other tables) without any error, just this table.
>
> Any hints?
>
>
> Edson Carlos Ericksson Richter
> SimKorp Infomática Ltda
> Fone:
> (51) 3366-7964
> Celular:
> (51) 8585-0796
> <image001.jpg>
> www.simkorp.com.br
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2011-09-25 15:52:13 | Re: (another ;-)) PostgreSQL-derived project ... |
Previous Message | Scott Ribe | 2011-09-25 15:22:23 | Re: (another ;-)) PostgreSQL-derived project ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-09-25 15:52:47 | Re: [v9.2] Fix Leaky View Problem |
Previous Message | Edson Carlos Ericksson Richter | 2011-09-25 15:17:28 | Alter column...using failure under 9.0.4 |