U++ forum: Welcome to the forum

Re: Postgres and CurrVal [message #23043 is a reply to message #23025]

Thu, 10 September 2009 12:01

mirek
Messages: 14267
Registered: November 2005

Ultimate Member

Zbych wrote on Tue, 08 September 2009 10:18

Hi,

CurrVal doesn't seem to work correctly with Postgres right now.
When I use it like this:

	sql & Insert(TABLE1)(COLUMN1, "test")(COLUMN2, CurrVal(TABLE2_COLUMN1_SEQ));

Sql string looks like this:

insert into TABLE1 (COLUMN1, COLUMN2) values ('test',currval('TABLE2_COLUMN1_SEQ')TABLE2_COLUMN1_SEQ.CURRVAL))

It looks like SqlCase is not "compiled". Any ideas how to fix it?

This is really strange, I have tried with PGSQL reference example:

and got a crash (correct one: uncaught exception) and this in log:

SQL* insert into TESTPARTNER(TESTPARTNER_NAME, TESTPARTNER_ADDRESS) values ('test', currval('TESTPARTNER'))
SQL* insert into TESTPARTNER(TESTPARTNER_NAME) values (currval('TESTPARTNER'))

which IMO is correct.

I would need a more complete testcase to investigate the issue...

Mirek

Report message to a moderator