| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "veramente(at)libero(dot)it" <veramente(at)libero(dot)it>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: [7.4.2] Still "variable not found in subplan target lists" |
| Date: | 2004-04-16 09:08:28 |
| Message-ID: | 407FA28C.9020603@pse-consulting.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Tom Lane wrote:
>"veramente(at)libero(dot)it" <veramente(at)libero(dot)it> writes:
>
>
>>Today after changing (with pgadmin III) the datatype of
>>qrydorders.docomment from varchar(255) to varchar(2500) i got the
>>error "variable not found in subplan target lists" [ from a view
>>dependent on the table ]
>>
>>
>
>This is an unsupported operation. You should perhaps complain to the
>pgadmin guys that they are not correctly updating the system catalogs.
>
>
UPDATE pg_attribute
SET atttypmod=2504
WHERE attrelid=25574::oid AND attnum=2;
This is what pgAdmin3 will generate to change a varchar to 2500 bytes.
Please let me know what's wrong with that.
Regards,
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-16 14:09:28 | Re: [7.4.2] Still "variable not found in subplan target lists" |
| Previous Message | PostgreSQL Bugs List | 2004-04-16 08:08:39 | BUG #1133: initdb fails when using Turkish locale |