[postgis-users] Cant create a BIGINT column that worked under another login at one point . . .

[Bob Basques]

All, 

I have this sequence: 

CREATE SEQUENCE cmdstpinfo_cmdrecid_seq 
  INCREMENT 1 
  MINVALUE 1 
  MAXVALUE 9223372036854775807 
  START 132894 
  CACHE 1; 
ALTER TABLE cmdstpinfo_cmdrecid_seq 
  OWNER TO gismo; 

and I'm trying to create this table: 

CREATE TABLE cmdstpinfo 
( 
  cmdrecid bigint NOT NULL DEFAULT nextval('cmdstpinfo_cmdrecid_seq'::regclass), 
  updsw smallint, 
  rxtime timestamp without time zone DEFAULT now(), 
  cmd text, 
  CONSTRAINT cmdstpinfo_pkey PRIMARY KEY (cmdrecid) 
) 
WITH ( 
  OIDS=FALSE 
); 

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 : 

ERROR:  syntax error at or near "bigint" 
LINE 3:   cmdrecid bigint NOT NULL DEFAULT nextval('cmdstpinfo_cmdre... 
                   ^ 
********** Error ********** 

ERROR: syntax error at or near "bigint" 
SQL state: 42601 
Character: 38 

What am I doing wrong, Is this a permissions error of some sort? 

Thanks 

bobb 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120315/c659d367/attachment.html>