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

Elie Nacache wrote:[color=blue]
> Hi All,[/color]

Hi Elie, I'm afraid we'll need more details before we can help.
[color=blue]
> 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".[/color]

Is this an ODBC or JDBC error? There are specific lists for both of those.
[color=blue]
> BTW in SQL a sequence of INSERT, UPDATE and then COMMIT work fine.[/color]
[color=blue]
> I'm using the same code with oracle and it's working well.[/color]

What code?
[color=blue]
> Is it a BUG !?[/color]

Can't say.
[color=blue]
> I'm using psql 7.4.3 on Linux 9.0[/color]

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 majordomo@postgresql.org

On Wed, 11 Aug 2004, Elie Nacache wrote:
[color=blue]
> 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".
>[/color]

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 majordomo@postgresql.org