ZF-10296: Invalid sequence name with postgres



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; }


Fixed in ZF-10257.

Thanks by your report.