Re: ecpg 'set' failure using host vars

Поиск
Список
Период
Сортировка
От Bosco Rama
Тема Re: ecpg 'set' failure using host vars
Дата
Msg-id 48AC4A41.40204@boscorama.com
обсуждение исходный текст
Ответ на Re: ecpg 'set' failure using host vars  (Michael Meskes <meskes@postgresql.org>)
Ответы Re: ecpg 'set' failure using host vars  (Michael Meskes <meskes@postgresql.org>)
Список pgsql-interfaces
Hi Michael,

Michael Meskes wrote:
> On Fri, Aug 15, 2008 at 08:47:49PM -0700, Bosco Rama wrote:
>>   exec sql char *sm;
>>   ...
>>   sm = "myschema";    // This may not always be constant
>>   ...
>>   exec sql set search_path to :sm;
> 
> Could you please try the attached patch and tell me whether it works
> for you? I will then check this in into 8.3 so that the next stable
> release works again as it should.

Thanks for working on this.

Unfortunately I'm just an applications person and our systems use the
FC9 distribution's pre-compiled packages only (it's a sysadmin thing).
I asked them about it and they said (and I quote):  "When it becomes
part of the FC9 distribution they will 'consider' (my emphasis)
upgrading the packages."  *sigh*

I really appreciate the effort and the fix but for now I have to be
satisfied with the work-around you guys suggested previously. :-(

Bosco.


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

Предыдущее
От: Bosco Rama
Дата:
Сообщение: Re: schema name in the SQL statement.
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: ecpg 'set' failure using host vars