FOR UPDATE is not allowed in this context

Поиск
Список
Период
Сортировка
От Postgres El Mejor
Тема FOR UPDATE is not allowed in this context
Дата
Msg-id F76sa7qEqlehFvHkQFY00003779@hotmail.com
обсуждение исходный текст
Ответы Re: FOR UPDATE is not allowed in this context  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-interfaces
Greetings:

When precompiling the following sentence the precompiler shows the message
"FOR UPDATE is not allowed in this context".

EXEC SQL SELECT camp_1 INTO :n1 WHERE llave = :var_llave FOR UPDATE;

It seems to be a problem with the host variables because it precompiles
well
the following sentence:

EXEC SQL SELECT camp_1 INTO :n1 WHERE llave = 'abcd' FOR UPDATE;

Thanks in advance for your help,


-------------------------------------------------------------------------
Jhon Orellana
Quito - Ecuador
South America


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



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

Предыдущее
От: Adam Haberlach
Дата:
Сообщение: Re: First-time JDBC setup with Jakarta! Whee!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: FOR UPDATE is not allowed in this context