[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] sequences in schemas
From:       Joe Maldonado <jmaldonado () webehosting ! biz>
Date:       2004-08-31 15:09:07
Message-ID: 41349493.60307 () webehosting ! biz
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]