Odd syntax

I noticed a couple of odd syntax issues today as I set up an SQL script.

1) The following does not work:

ALTER SEQUENCE somesequence OWNER TO xyz;

Instead you have to use:

ALTER TABLE somesequence OWNER TO xyz;

But if you drop a sequence the syntax is:

DROP SEQUENCE somesquence;

Is there a reason ALTER SEQUENCE could not have been used instead of
ALTER TABLE?

2) I also noticed I cannot create a sequence targeting a
particular tablespace. Example:

CREATE SEQUENCE somesequence

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 1

CACHE 1

TABLESPACE xyz;

Why is this? I thought that when you created a sequence you were in a
sense creating a special predefined table in the background.

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu