syntax error wehen creating sequence - Mailing list pgadmin-support

From Andreas Moroder
Subject syntax error wehen creating sequence
Date
Msg-id 42062F78.6020601@tin.it
Whole thread Raw
Responses Re: syntax error wehen creating sequence  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-support
Hello,

when I create a sequence pgadmin has the tablespace listbox enable.
When I chose a tablespace then it creates the folowing command.

CREATE SEQUENCE wtb.test  INCREMENT 1  START 1  TABLESPACE pg_default;
ALTER TABLE wtb.test OWNER TO wtb;


postgres gives back a syntax error because "create sequence" does not 
allow the tablespace parameter

CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ]   [ MINVALUE minvalue | NO MINVALUE ] [
MAXVALUEmaxvalue | NO MAXVALUE ]   [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
 


Bye
Andreas


pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Export funtion
Next
From: Ivan
Date:
Subject: feature request