Skip site navigation (1) Skip section navigation (2)

FOR UPDATE is not allowed in this context

From: "Postgres El Mejor" <postgres99(at)hotmail(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: FOR UPDATE is not allowed in this context
Date: 2001-02-21 00:16:46
Message-ID: F76sa7qEqlehFvHkQFY00003779@hotmail.com (view raw or flat)
Thread:
Lists: 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.


Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2001-02-21 00:58:58
Subject: Re: FOR UPDATE is not allowed in this context
Previous:From: Postgres El MejorDate: 2001-02-21 00:01:14
Subject: FOR UPDATE is not allowed in this context

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group