Re: reindexing sequences - Mailing list pgsql-general

From Oliver Elphick
Subject Re: reindexing sequences
Date
Msg-id 200104080723.f387Nl223637@linda.lfix.co.uk
Whole thread Raw
In response to reindexing sequences  ("mike" <mike@quadrent.net>)
List pgsql-general
"mike" wrote:
  >is there a way to reindex a sequence?
  >if so how and is it in the curent docs?

If you wish to reset its value, the function is setval().

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Do not be anxious about anything, but in everything,
      by prayer and supplication, with thanksgiving, present
      your requests to God. And the peace of God, which
      transcends all understanding, will guard your hearts
      and your minds in Christ Jesus."   Philippians 4:6,7



pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: www.postgresql.org down?
Next
From: "Oliver Elphick"
Date:
Subject: Re: Inheritance and referential integritry in 7.0.3