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

[Alessio B. <al...@al...>]

James Edward Marca wrote:

> seems like Slash/DB/MySql.pm, line 3068, is calling a sql_select
> for LAST_INSERT_ID(), a MySQL extension that I can't find an
> analog for in PostgreSQL.  But I don't have much experience with
> either database.

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?

-- 
Alessio F. Bragadini		al...@al...
APL Financial Services		http://village.albourne.com
Nicosia, Cyprus		 	phone: +357-2-755750

"It is more complicated than you think"
		-- The Eighth Networking Truth from RFC 1925