FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-admin @
categoriespostgresql
postedApr 2, '08 at 3:25p
activeApr 2, '08 at 3:25p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Campbell, Lance: 1 post

People

Translate

site design / logo © 2022 Grokbase