ZF-10296: Invalid sequence name with postgres

Issue Type: Bug Created: 2010-08-11T13:41:46.000+0000 Last Updated: 2010-08-11T13:49:47.000+0000 Status: Resolved Fix version(s): - 1.10.8 (25/Aug/10)

Reporter: Marek Fiala (marrra) Assignee: Ramon Henrique Ornelas (ramon) Tags: - Zend_Db_Table

Related issues: Attachments:



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


Posted by Ramon Henrique Ornelas (ramon) on 2010-08-11T13:49:46.000+0000

Fixed in ZF-10257.

Thanks by your report.

Have you found an issue?

See the Overview section for more details.


© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.