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 ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
Bye
Andreas