I have a table using schema - cd (i don't use public scheme):
Code:
CREATE TABLE cd.album ( 
    id    	int4 NOT NULL DEFAULT nextval('cd.album_id_seq'::regclass),
    artist	varchar(100) NULL,
    title 	varchar(100) NULL,
    PRIMARY KEY(id)
)
as you see I have a siquence cd.album_id_seq using it for autoincrementing primary key id in the same schema as well.

In ZF Model I create class:
[PHP]
<?php
class Album extends Zend_Db_Table
{
protected $_name = 'cd.album';
protected $_sequence = 'cd.album_id_seq';
}
[/PHP]

When I try to insert record:
[PHP]
$data = array(
'artist' => $artist,
'title' => $title,
);
$album = new Album();
$album->insert($data);
[/PHP]
it's error had place:
Apache Log:
Code:
[Fri Aug 24 00:50:58 2007] [error] [client 127.0.0.1] PHP Fatal error:  Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42P01]: Undefined table: 7 ERROR:  \xd0\xbe\xd1\x82\xd0\xbd\xd0\xbe\xd1\x88\xd0\xb5\xd0\xbd\xd0\xb8\xd0\xb5 "album" \xd0\xbd\xd0\xb5 \xd1\x81\xd1\x83\xd1\x89\xd0\xb5\xd1\x81\xd1\x82\xd0\xb2\xd1\x83\xd0\xb5\xd1\x82' in /var/www/html/library/Zend/Db/Statement/Pdo.php:227\nStack trace:\n#0 /var/www/html/library/Zend/Db/Statement.php(298): Zend_Db_Statement_Pdo->_execute(Array)\n#1 /var/www/html/library/Zend/Db/Adapter/Abstract.php(279): Zend_Db_Statement->execute(Array)\n#2 /var/www/html/library/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query('INSERT INTO "al...', Array)\n#3 /var/www/html/library/Zend/Db/Adapter/Abstract.php(357): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO "al...', Array)\n#4 /var/www/html/library/Zend/Db/Table/Abstract.php(765): Zend_Db_Adapter_Abstract->insert('album', Array)\n#5 /var/www/html/application/controllers/IndexController.php(32): Zend_Db_Table_Abstract->insert(Array)\n#6 /var/www/html/library/Zend/Controller/Action.php(497): IndexController->addAction()\n#7 /var/www/html/library/Zend/Controller/Dispatcher/Standard. in /var/www/html/library/Zend/Db/Statement/Pdo.php on line 227, referer: http://127.0.0.1/index/add
Is it bug, or I do somthing wrong?

PS: I was try to define _schema="cd" result was the same. Select work fine.