More problems with 7.2 & functions

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема More problems with 7.2 & functions
Дата
Msg-id web-695879@davinci.ethosmedia.com
обсуждение исходный текст
Ответы Re: More problems with 7.2 & functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: More problems with 7.2 & functions  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-sql
Tom:

Thanks for the answer on Readline.

Now, more trouble upgrading ...
I'm getting this error:

ERROR: replace_vars_with_subplan_refs: variable not in subplan targetlist

It happens whenever I try to execute a function that worked perfectlyunder 7.1.3.  The function builds a query out of
VARCHARstrings andthen EXECUTES it. 
 

I've tried running VACUUM ANALYZE on the database, and re-building therfunction.  No effect. 

Sorry for e-mailing you directly, but I promised the client they'd havethe machine back at 8am on monday ...

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


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

Предыдущее
От: knut.suebert@web.de
Дата:
Сообщение: Re: synchronise 2 db pgsql ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: More problems with 7.2 & functions