sequences in schemas

[Joe Maldonado]

Hello,
How come within a create schema block I cannot create a sequence?
I have entered in:

CREATE SCHEMA joe
CREATE SEQUENCE joe_seq start 1
CREATE TABLE joe_table (int id, varchar name)
;

and I get a syntax error for SEQUENCE. though if it is just tables I do not

-Joe

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Pierre-Frédéric Caillaud]

You forgot the ";"

CREATE SCHEMA joe;
CREATE SEQUENCE joe.joe_seq start 1;
CREATE TABLE joe.joe_table (int id, varchar name);
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Manfred Koizar]

On Tue, 31 Aug 2004 11:09:07 -0400, Joe Maldonado
<jm********@web ehosting.biz> wrote:

CREATE SCHEMA joe
CREATE SEQUENCE joe_seq start 1
CREATE TABLE joe_table (int id, varchar name)
;

and I get a syntax error for SEQUENCE.

This will work in 8.0.

http://www.postgresql.org/docs/7.4/s...teschema.html:
schema_element
An SQL statement defining an object to be created within the schema.
Currently, only CREATE TABLE, CREATE VIEW, and GRANT are accepted as
clauses within CREATE SCHEMA.

http://developer.postgresql.org/docs...teschema.html:
schema_element
An SQL statement defining an object to be created within the schema.
Currently, only CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE
SEQUENCE, CREATE TRIGGER and GRANT are accepted as clauses within CREATE
SCHEMA.

In the meantime "Other kinds of objects may be created in separate
commands after the schema is created."

Servus
Manfred

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

http://archives.postgresql.org