pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Postgres El Mejor <postgres99@hotmail.com>
To: pgsql-interfaces@postgresql.org
Subject: FOR UPDATE is not allowed in this context
Date: Tue, 20 Feb 2001 19:16:46 -0500
Message-ID: <F76sa7qEqlehFvHkQFY00003779@hotmail.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,


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


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




view thread (8+ messages)  latest in thread

Message-ID: <F76sa7qEqlehFvHkQFY00003779@hotmail.com>
Permalink:  ../F76sa7qEqlehFvHkQFY00003779@hotmail.com/
Also on:    postgresql.org/message-id/F76sa7qEqlehFvHkQFY00003779@hotmail.com

 · 

reply

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: postgres99@hotmail.com
  Subject: Re: FOR UPDATE is not allowed in this context
  In-Reply-To: <F76sa7qEqlehFvHkQFY00003779@hotmail.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