-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
I tried to use Zend_Db with PDO_PGSQL. After inserting a new row to
database i try to get last insert id by lastInsertId() method but I even
get bool(false). My tables create statement:
CREATE SEQUENCE seq_article_id;
CREATE TABLE article (
article_id integer NOT NULL DEFAULT nextval('seq_article_id')
PRIMARY KEY
...
);
PostgreSQL's manual says, that SERIAL is an autoincrementing integer,
but i read that is the same as above (~helper).
So, what i have todo to get a valid last insert id from lastInsertId()?
Could it be that the sequence name must have a specific name? In
Example: <table_name>_<column_name>_seq? I actually define the sequence
name by myself.
- -- Jan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
iD8DBQFHdPCdd3s9o1H9MZ4RA42tAJ9DGYzn0HD3ec4udDLiOql9dU6erACgjK26
cVk+M0YVmAruY7Zbm1EDk1c=
=PJQn
-----END PGP SIGNATURE-----
