[Zope] Cannot create Primary Key

Thu, 30 Nov 2000 12:17:29 +0800

This is a multi-part message in MIME format.

------=_NextPart_000_0009_01C05AC7.81FFF180
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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)

------=_NextPart_000_0009_01C05AC7.81FFF180
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I'm using the Z Gadfly Database as my =
database=20
adapter, and i using Z SQL Method to create my table, but it is not =
allow for me=20
to create Primary Key for the my sequence integer field, beside that it =
also not=20
allow me to create a 'date' data type field.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>my SQL will be:-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>CREATE TABLE customer<BR>(custno SERIAL =
PRIMARY=20
KEY,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>custactdate =
DATE)</FONT></DIV></BODY></HTML>

------=_NextPart_000_0009_01C05AC7.81FFF180--