Re: Please clarify with regard to Renaming a Sequence

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Anand B Kumar <akumar(at)addr(dot)com>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Please clarify with regard to Renaming a Sequence
Date: 2003-03-22 08:22:56
Message-ID: 20030322082255.GC12633@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Please reply to the list, not just me. On the list many people can answer
your question.

If you rename a sequence it doesn't affect any other property (including
where it is upto). Surely you could have tried this out and seen how it
works?

On Sat, Mar 22, 2003 at 12:33:59PM +0530, Anand B Kumar wrote:
> Martijn
>
> Thanx for your reply. But my question was to know, whether the sequence
> would be maintained if we rename the sequence to a new name!! We are
> equally aware of the alter command, but let us know about the continuity of
> the sequence
>
> ----- Original Message -----
> From: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
> To: "Anand B Kumar" <akumar(at)addr(dot)com>
> Cc: <pgsql-general(at)postgresql(dot)org>; <pgsql-hackers(at)postgresql(dot)org>
> Sent: Saturday, March 22, 2003 12:21 PM
> Subject: Re: [GENERAL] Please clarify with regard to Renaming a Sequence
>
>

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> IT is not something like pizza that you order in at one o'clock in
> the morning. - John Loebenstein, St George CIO

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ian 2003-03-22 09:32:04 postgresql newsgroups (comp.databases.postgresql.*)
Previous Message Joe Conway 2003-03-22 07:14:07 Re: table function: limit, offset, order

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2003-03-22 12:17:48 Re: timestamp/date in ecpg
Previous Message Martijn van Oosterhout 2003-03-22 06:51:48 Re: Please clarify with regard to Renaming a Sequence