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