Thread: syntax error wehen creating sequence

syntax error wehen creating sequence

From
Andreas Moroder
Date:
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


Re: syntax error wehen creating sequence

From
Andreas Pflug
Date:
Andreas Moroder wrote:
> 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

Hm,

obviously a reminder from 7.5/8.0beta stages. Will be removed in 1.2.1 
and 1.3, thanks for reporting.

Regards,
Andreas