Tom Lane wrote:
> Heikki Linnakangas <[EMAIL PROTECTED]> 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 fi
Heikki Linnakangas <[EMAIL PROTECTED]> 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 r
Guillaume 'ioguix' de Rorthais wrote:
> Heikki Linnakangas a écrit :
>> Tom Lane wrote:
>>> Alvaro Herrera <[EMAIL PROTECTED]> writes:
I am amused by the fact that we store the sequence name in the sequence
itself though.
>>> Yeah, it's a bit pointless. One possible response to this grip
Heikki Linnakangas a écrit :
> Tom Lane wrote:
>> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>>> I am amused by the fact that we store the sequence name in the sequence
>>> itself though.
>> Yeah, it's a bit pointless. One possible response to this gripe would
>> be to take the name out of the seq
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> I am amused by the fact that we store the sequence name in the sequence
>> itself though.
>
> Yeah, it's a bit pointless. One possible response to this gripe would
> be to take the name out of the sequence itself. However, that woul
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I am amused by the fact that we store the sequence name in the sequence
> itself though.
Yeah, it's a bit pointless. One possible response to this gripe would
be to take the name out of the sequence itself. However, that would
likely break client-side
Tom Lane wrote:
> ioguix <[EMAIL PROTECTED]> writes:
> > br3619=# CREATE SEQUENCE sample_seq_to_rename;
> > CREATE SEQUENCE
> > br3619=# select sequence_name from sample_seq_to_rename;
> > sequence_name
> > --
> > sample_seq_to_rename
> > (1 ligne)
>
> > br3619=# ALTER TAB
ioguix <[EMAIL PROTECTED]> writes:
> br3619=# CREATE SEQUENCE sample_seq_to_rename;
> CREATE SEQUENCE
> br3619=# select sequence_name from sample_seq_to_rename;
> sequence_name
> --
> sample_seq_to_rename
> (1 ligne)
> br3619=# ALTER TABLE sample_seq_to_rename RENAME TO sa
I created this bug report using the pagila db sample (
http://pgfoundry.org/projects/dbsamples/ ). Here is how the sequence and
table are created :
~
CREATE SEQUENCE actor_actor_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO
I am confused by this bug report. Please show us the CREATE TABLE that
goes with it.
---
Guillaume 'ioguix' de Rorthais wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3619
> Logged by:
The following bug has been logged online:
Bug reference: 3619
Logged by: Guillaume 'ioguix' de Rorthais
Email address: [EMAIL PROTECTED]
PostgreSQL version: all - cvs
Operating system: Linux
Description:Renaming sequence does not update its 'sequence_name'
field
Detai
11 matches
Mail list logo
