Resultset problem or BUG !

[Elie Nacache]

Hi All,

A data writed in a table but not commited is not accessible in modification by the resultset. The error returned is "Cannot move to index of 0".

BTW in SQL a sequence of INSERT, UPDATE and then COMMIT work fine.
I'm using the same code with oracle and it's working well.

Is it a BUG !?

I'm using psql 7.4.3 on Linux 9.0
Any help !

Elie

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Richard Huxton]

Elie Nacache wrote:

Hi All,
Hi Elie, I'm afraid we'll need more details before we can help.
A data writed in a table but not commited is not accessible in
modification by the resultset. The error returned is "Cannot move to
index of 0".
Is this an ODBC or JDBC error? There are specific lists for both of those.
BTW in SQL a sequence of INSERT, UPDATE and then COMMIT work fine. I'm using the same code with oracle and it's working well.
What code?
Is it a BUG !?
Can't say.
I'm using psql 7.4.3 on Linux 9.0

psql is the command-line tool, so I'm guessing you mean PostgreSQL (or
pgsql) 7.4.3. Likewise, there is no Linux 9.0 - I'm assuming you mean
RedHat, SuSE or Mandrake.

If you can provide details on how you are accessing the database and a
short example of your code, I'm sure someone will be able to help.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Kris Jurka]

On Wed, 11 Aug 2004, Elie Nacache wrote:

A data writed in a table but not commited is not accessible in
modification by the resultset. The error returned is "Cannot move to
index of 0".

It is entirely unclear what you are actually doing here. Are you using
JDBC? Could you show us some sample code that demonstrates the problem?

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org