Postgres - ERROR: 42601: cannot insert multiple commands into a prepared statement

[wibber]

NH-2267 updated NpgsqlDriver to use prepared statements.
Unfortunately, this means that I can't get the identity generator to
work. Anybody got a good work-around for this yet? I'm thinking
about extending the postgres dialect to use the "returning [id]". I'm
not sure where to get the "id" inside the IdentitySelectString method.

Exception:
NHibernate.Exceptions.GenericADOException: could not insert:
[Entity.Test][SQL: INSERT INTO public."Test" ("Name") VALUES (?);
select lastval()] ---> Npgsql.NpgsqlException: ERROR: 42601: cannot
insert multiple commands into a prepared statement

Mapping File (truncated):
<class name="Test,Entity2" table="`Test`" >
<id name="Id" column="`BigId`" unsaved-value="0">
<generator class="identity" />
</id>
<property column="`Name`" type="String" name="Name" />
</class>

[Filip Zawada]

On 2011-02-22 21:39, wibber wrote:
> NH-2267 updated NpgsqlDriver to use prepared statements.
> Unfortunately, this means that I can't get the identity generator to
> work. Anybody got a good work-around for this yet? I'm thinking
> about extending the postgres dialect to use the "returning [id]". I'm
> not sure where to get the "id" inside the IdentitySelectString method.

As a work around: Consider using HiLo generator.
Unless for some reason you really have to use DB-generated keys, HiLo is
the best choice for integer PKs. You might want to stick with it even
after the issue gets resolved.

Filip Zawada

[wibber]

Would love to, but DBAs won't budge. If someone can tell me how to
get the name of the identity column from inside the
IdentitySelectString method, then I can solve the identity problem.
That's the last piece of the puzzle and I'll have an updated Postgres
dialect that works.