From: Jimmy Román R. <jroman@eljuri.com>
To: pgsql-interfaces@postgresql.org
Subject: select for update error during precompilation
Date: Wed, 27 Oct 1999 09:20:22 -0600
Message-ID: <001601bf208e$cf696920$58010a0a@eljuri.com> (raw)
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,
-------------------------------------------------------------------------------------------------
Jimmy Roman R.
Guayaquil - Ecuador
South America
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jroman@eljuri.com
Subject: Re: select for update error during precompilation
In-Reply-To: <001601bf208e$cf696920$58010a0a@eljuri.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox