| From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | "mike" <mike(at)quadrent(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: reindexing sequences |
| Date: | 2001-04-08 07:23:47 |
| Message-ID: | 200104080723.f387Nl223637@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)Elphick(at)lfix(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2001-04-08 07:28:35 | www.postgresql.org down? |
| Previous Message | Oliver Elphick | 2001-04-08 07:17:42 | Re: Inheritance and referential integritry in 7.0.3 |