Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field
Date
Msg-id 27122.1191432838@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field
List pgsql-bugs
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Well, the way it is now is just broken, so IMO we have to either fix it
> or remove it altogether.

> Since having sequence_name in there doesn't let you do anything you
> can't do without it, and there's no easy way to fix it, I'd say let's
> just remove it in 8.3 and do nothing in backbranches.

I don't think this is a good idea.  It's removing functionality that
works fine as long as you don't rename sequences.  Also, there's still
the notion of someday providing a system catalog or view that shows
parameters of all sequences, and in that view the current column set of
an individual sequence would be what we'd want.

My inclination is to leave it alone for now until we have an approach to
providing that view, and at that time decide what to do about individual
sequences.  If we have to change the API, then so be it, but lets do it
just once not twice.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field
Next
From: "Anton A. Patrushev"
Date:
Subject: Re: BUG #3648: Server crashes when trying to create a table