[Helma-user] Support for PostgreSQL sequences

[Hannes Wallnoefer]

Finally some Postgresql testing! Great!

2006/8/8, Julian Tree <julian.tree at gmail.com>:
>
> I get following error
> java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR:
> relation "dual" does not exist
> (/helma-1.5.0/apps/filepress/Root/temp.hac#10)
> the sql Log gives me this :  SELECT 'company_company_id_seq'.nextval FROM dual

That's weird, because this is the Oracle syntax. What you should get
is "SELECT nextval('sequence_name')".

What is the class name of the JDBC driver you're using? Are you using
the latest Helma 1.5 CVS snapshot?

> if I comment out the _idgen line I get this error
> ERROR: column "company_id" is of type integer but expression is of
> type character varying
>

OK, this is to be expected, I'm fixing it now.

hannes