Fwd: Renaming sequences - Mailing list pgsql-novice

From Zahid Rahman
Subject Fwd: Renaming sequences
Date
Msg-id CAPGSW3TZ4YpguUb=B=2mZtb=MP5HCFM=vZ=VbPnHb2LCHAS1GA@mail.gmail.com
Whole thread Raw
In response to Renaming sequences  (Mike Dewhirst <miked@dewhirst.com.au>)
List pgsql-novice



If you are referring to a sequence which meets the same definition below. That is to say a persistent number generator. 

Surely by  changing  the sequence name then any  code using that sequence by name will fail. That's from an application developer's view.


sequence inPostgreSQL is a user-defined schema-bound object that generates asequence of integers based on a specified specification. To create a sequence in PostgreSQL, you use the CREATE SEQUENCE statement.

After a sequence is created, you use the 

functions nextvalcurrval, and setval to operate on the sequence. These functions are documented in Section 9.16.

Although you cannot update a sequence directly, you can use a query like:

SELECT * FROM name;


On Wed, 18 Dec 2019, 05:33 Mike Dewhirst, <miked@dewhirst.com.au> wrote:
Are there any consequences for renaming sequences to match the tables which own them?

In an existing production Django project I have just converted auth.user into common.user and company.userprofile into common.userprofile.

Having gone through the migration process more or less unscathed the original sequences are owned by the renamed tables. Eg public.auth_user_id_seq is owned by public.common_user.id

Everything seems to work fine but my unit tests are playing up and error messages are showing the original (and still correct) sequence names. It would make much visual sense to me now and especially to the future me (or anyone else) if the sequences were renamed as well.

I know how I could do it but I just need to know if I should.

Thanks for any advice

Mike

pgsql-novice by date:

Previous
From: Mike Dewhirst
Date:
Subject: Renaming sequences
Next
From: Mike Dewhirst
Date:
Subject: Re: Renaming sequences