Re: [Slashcode-development] PgSql no LAST_INSERT_ID()

[Brian A. <br...@ta...>]

Alessio Bragadini wrote:
> It's SELECT currval('templates_tpid_seq'), i.e. the latest sequence
> number assigned to templates.tpid, which is a SERIAL (auto-increments).
> 
> In the createTemplate subroutine has to be used as
> 
> return $self->sqlSelect('currval(\'templates_tpid_seq\')';
> 
> I would provide a patch, but PostgreSQL.pm has much less code than
> MySql.pm! :-( Means most of the routines are still to be written?
Pg inherits from MySQL. The patch would be to copy the method from MySQL
to the Pg file and fix it to work with PostgreSQL.
	-Brian