Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] ALTER SEQUENCE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] ALTER SEQUENCE
Date: 2003-03-05 00:14:23
Message-ID: 15514.1046823263@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
Rod Taylor <rbt(at)rbt(dot)ca> writes:
> Might get somewhere by making a special domain thats marked as being
> serial, and using that in the column.

I recall some discussion last year about making serial et al. into
domains over int4 and int8, rather than their current utter-hack
implementation.  Can't recall if we found a problem with the idea,
or no one got around to doing it, or it just didn't seem to clean
things up enough to be worth the trouble.  (AFAICS you'd still need
special-case code to set up the appropriate default expression for
each column; the domain constraint mechanism wouldn't handle that
for you.)

Seems worth looking at, though.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Neil ConwayDate: 2003-03-05 00:20:29
Subject: Re: Updateable views...
Previous:From: Tom LaneDate: 2003-03-05 00:03:05
Subject: Re: Updateable views...

pgsql-patches by date

Next:From: Rod TaylorDate: 2003-03-05 04:22:07
Subject: Re: [PATCHES] ALTER SEQUENCE
Previous:From: Alan GutierrezDate: 2003-03-04 23:27:03
Subject: Re: XML ouput for psql

pgsql-general by date

Next:From: scott.marloweDate: 2003-03-05 00:15:04
Subject: Re: phpBB2 slow on postgres vs mysql ?
Previous:From: scott.marloweDate: 2003-03-05 00:03:33
Subject: Re: phpBB2 slow on postgres vs mysql ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group