[Helma-user] Support for PostgreSQL sequences

[Julian Tree]

oh I see now,

I am using postgresql-8.1-407, and last night I tried using the
lastest helma checkedout from csv. I am not getting the "the SELECT
'company_company_id_seq'.nextval FROM dual" error anymore,

I still get the following ERROR: column "company_id" is of type
integer but expression is of
type character varying
sql Log: INSERT INTO company ( company_id, company_type, creator,
modifier, contact_name, company_name, email, phone_main, phone_fax,
phone_mobile, phone_other, web_site, comments ) VALUES ( ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ? )


Thanks

On 8/8/06, Hannes Wallnoefer <hannesw at gmail.com> wrote:
> 2006/8/8, Julian Tree <julian.tree at gmail.com>:
> >
> > Since postgresql is already managing the incrementing of the id, there
> > is really no need to put the id in the INSERT statement.
>
> Nope, automatic ID generation is not going to work with Helma. We do
> not support this with any db, neither MySQL nor Oracle. You'll simply
> have to define the primary key as integer column, and than let Helma
> get the id via nextval(). Sorry for not seeing this right away.
>
> > > What is the class name of the JDBC driver you're using? Are you using
> > > the latest Helma 1.5 CVS snapshot?
>
> Could you still answere these two questions, please?
>
> hannes
> _______________________________________________
> Helma-user mailing list
> Helma-user at helma.org
> http://helma.org/mailman/listinfo/helma-user
>