| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Alter column...using failure under 9.0.4 |
| Date: | 2011-09-25 16:04:29 |
| Message-ID: | 1191.1316966669@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
=?iso-8859-1?Q?Bj=F6rn_H=E4user?= <bjoernhaeuser(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-09-25 16:08:46 | Re: New feature: accumulative functions. |
| Previous Message | Martijn van Oosterhout | 2011-09-25 15:52:13 | Re: (another ;-)) PostgreSQL-derived project ... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Carlos Ericksson Richter | 2011-09-25 16:19:19 | RES: Alter column...using failure under 9.0.4 |
| Previous Message | Kevin Grittner | 2011-09-25 16:02:46 | Re: Inserting heap tuples in bulk in COPY |