sequences in schemas

From: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
To: pgsql-general(at)postgresql(dot)org
Subject: sequences in schemas
Date: 2004-08-31 15:09:07
Message-ID: 41349493.60307@webehosting.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message McDougall, Marshall (FSH) 2004-08-31 15:20:57 Change config of running PGSQL
Previous Message Tom Lane 2004-08-31 15:08:48 Re: Overloading '<' operator