Skip site navigation (1) Skip section navigation (2)

Re: [7.4.2] Still "variable not found in subplan target lists"

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 (view raw or flat)
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


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-04-16 14:09:28
Subject: Re: [7.4.2] Still "variable not found in subplan target lists"
Previous:From: PostgreSQL Bugs ListDate: 2004-04-16 08:08:39
Subject: BUG #1133: initdb fails when using Turkish locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group