<html>
<head>
</head>
<body style="margin-left: 4px; margin-top: 4px; margin-bottom: 1px; font-variant: normal; margin-right: 4px; line-height: normal">
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">All,</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">I have this sequence:</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">CREATE SEQUENCE cmdstpinfo_cmdrecid_seq</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> INCREMENT 1</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> MINVALUE 1</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> MAXVALUE 9223372036854775807</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> START 132894</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> CACHE 1;</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">ALTER TABLE cmdstpinfo_cmdrecid_seq</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> OWNER TO gismo;</font><font size="3" face="Comic Sans MS"></font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">and I'm trying to create this table:</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">CREATE TABLE cmdstpinfo</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">(</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> cmdrecid bigint NOT NULL DEFAULT nextval('cmdstpinfo_cmdrecid_seq'::regclass),</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> updsw smallint,</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> rxtime timestamp without time zone DEFAULT now(),</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> cmd text,</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> CONSTRAINT cmdstpinfo_pkey PRIMARY KEY (cmdrecid)</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">)</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">WITH (</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> OIDS=FALSE</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">);</font><font size="3" face="Comic Sans MS"></font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">but get the following error, if I remove the "cmdrecid" column creation line, I get the same error but for the smallint on "updsw" on the next line down :</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">ERROR: syntax error at or near "bigint"</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">LINE 3: cmdrecid bigint NOT NULL DEFAULT nextval('cmdstpinfo_cmdre...</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New"> ^</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">********** Error **********</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">ERROR: syntax error at or near "bigint"</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">SQL state: 42601</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Courier New">Character: 38</font><font size="3" face="Comic Sans MS"></font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">What am I doing wrong, Is this a permissions error of some sort?</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">Thanks</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">bobb</font> </p>
<br> <br>
</body>
</html>