=?iso-8859-1?Q?Bj=F6rn_H=E4user?= <bjoernhaeu...@gmail.com> writes:
> Am 25.09.2011 um 17:17 schrieb Edson Carlos Ericksson Richter:
>> alter table usuario alter column ativo type smallint using (case when ativo
>> then 1 else 0 end);
>> ERROR: argument of IS FALSE must be type boolean, not type smallint
> you could check for indices or something like that.
Yeah, looks like expression index or CHECK constraint or something
similar that includes "ativo IS FALSE".
Note to hackers: I wonder whether we could make this a bit more
user-friendly by providing a CONTEXT line that shows which table
property we're trying to convert.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
