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:

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.

• Overview
• ZF2 Issue Archive
• ZF1 Issue Archive

See the Overview section for more details.