ZF-10296: Invalid sequence name with postgres
Description
Hi,
I've found bug in class Zend_Db_Table_Abstract in build sequence name with non-public schema.
When I try insert row to table pages in schema admin, I've got exception:
- Zend_Db_Statement_Exception
- SQLSTATE[3F000]: Invalid schema name: 7 ERROR: schema "admin"" does not exist
Exception occour on this query: "SELECT NEXTVAL('"admin"""."""pages_pid_seq"')"
When I removed quoting it works. Line 907-909 in Zend_Db_Table_Abstract: $this->sequence = $this->_name . '' . $pkIdentity . '_seq'; if ($this->_schema) { $this->_sequence = $this->_schema . '.' . $this->_sequence; }
Comments
Posted by Ramon Henrique Ornelas (ramon) on 2010-08-11T13:49:46.000+0000
Fixed in ZF-10257.
Thanks by your report.