SEO

#1 (**permalink**) 04-17-2008, 06:57 PM

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

#2 (**permalink**) 04-17-2008, 06:57 PM

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

syntax error wehen creating sequence