FOR UPDATE is not allowed in this context - Mailing list pgsql-interfaces

From Postgres El Mejor
Subject FOR UPDATE is not allowed in this context
Date
Msg-id F76sa7qEqlehFvHkQFY00003779@hotmail.com
Whole thread Raw
Responses Re: FOR UPDATE is not allowed in this context  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Adam Haberlach
Date:
Subject: Re: First-time JDBC setup with Jakarta! Whee!
Next
From: Tom Lane
Date:
Subject: Re: FOR UPDATE is not allowed in this context