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

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: [7.4.2] Still "variable not found in subplan target lists"
Дата
Msg-id 407FA28C.9020603@pse-consulting.de
обсуждение исходный текст
Ответ на Re: [7.4.2] Still "variable not found in subplan target lists"  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [7.4.2] Still "variable not found in subplan target lists"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Tom Lane wrote:

>"veramente@libero.it" <veramente@libero.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "PostgreSQL Bugs List"
Дата:
Сообщение: BUG #1133: initdb fails when using Turkish locale
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [7.4.2] Still "variable not found in subplan target lists"