[Zope] Cannot create Primary Key

Farrell, Troy troy.farrell@wilcom.com
Thu, 7 Dec 2000 12:32:56 -0600


See this question from the gadfly faq:

http://www.chordate.com/kwParsing/gffaq.html#key

-----Original Message-----
From: Angietel [mailto:angietel@hotmail.com]
Sent: Wednesday, November 29, 2000 10:17 PM
To: zope@zope.org
Subject: [Zope] Cannot create Primary Key


I'm using the Z Gadfly Database as my database adapter, and i using Z SQL
Method to create my table, but it is not allow for me to create Primary Key
for the my sequence integer field, beside that it also not allow me to
create a 'date' data type field.
 
my SQL will be:-
CREATE TABLE customer
(custno SERIAL PRIMARY KEY,
custactdate DATE)