| Date: | Sun, 19 Sep 2004 23:07:58 +0100 |
| From: | Martin Ling <martin-rt-cpan [...] earth.li> |
| To: | bug-Alzabo [...] rt.cpan.org |
| Subject: | Column defaults not set for sequenced PostgreSQL columns |
Alzabo 0.83 does not correctly set up sequenced columns with PostgreSQL.
The sequence is created but the column default is not set appropriately.
The attached patch rectifies the problem.
Before:
CREATE TABLE "Test" (
"foo" INTEGER NOT NULL,
PRIMARY KEY ("foo")
)
;
CREATE SEQUENCE "Test___foo";
;
After:
CREATE TABLE "Test" (
"foo" INTEGER DEFAULT NEXTVAL('"Test___foo"') NOT NULL,
PRIMARY KEY ("foo")
)
;
CREATE SEQUENCE "Test___foo";
;
Martin
Message body is not shown because sender requested not to inline it.