To: pgadmin-support@postgresql.org
From: "Milen A. Radev" <milen@radev.net>
Subject: Re: Alternative Serial
Date: Sun, 11 Mar 2007 18:54:32 +0200
Lines: 40
Message-ID: <et1c74$6f0$1@sea.gmane.org>
References: <55c095e90703110720o78dfcfeai2b31bbadf17582b7@mail.gmail.com>	
	<et14pj$5u5$1@sea.gmane.org>
	<55c095e90703110808u567e9a1dr4d038b2b382b3a68@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
User-Agent: Mozilla Thunderbird 1.5.0.10 (Windows/20070221)
In-Reply-To: <55c095e90703110808u567e9a1dr4d038b2b382b3a68@mail.gmail.com>
Cc: pgsql-sql@postgresql.org

Ezequias Rodrigues da Rocha написа:
> Yes you are right, I means sequences.
> 

Please re-read my reply!

> The second way is better for me that have Id (PK) fields not  defined  as
> Sequences. Now it is much more difficult to change the  type of my PK than

A field could not be defined as 'sequence', but as 'serial', because
'sequence' is a db object and 'serial' is a (pseudo-)type. The actual
type of a field defined as 'serial' is 'integer' (or 'bigint' in case of
'bigserial'). You could change the type of a field (defined as sequence
earlier) as easy as you could any other field. Or you could just change
its default value. Or anything else.

> define a Default value. I am just concerned about the consistency of this
> sequence. Could you make me more easy ?

What do you mean by 'consistency' here? Guaranteed uniqueness of the
numbers generated by the sequence? Pleas read the fine documentation
here - http://www.postgresql.org/docs/8.2/static/sql-createsequence.html.


> 
> And about the cast I have found ?
> 
> nextval('mySerial_id'::regclass)
> 
> I ask again. What is regclass ? What does it really is.

I already answered that one, please re-read my reply and the pages it
mentions.

[...]


-- 
Milen A. Radev