From: | Vivek Khera <khera(at)kcilink(dot)com> |
---|---|
To: | Nathan Wilhelmi <wilhelmi(at)ucar(dot)edu> |
Cc: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Script to reset all sequence values in the a given DB? |
Date: | 2007-12-10 22:25:36 |
Message-ID: | 9E2947AD-EA8A-4120-904B-2FA7BEBA08AE@kcilink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
please don't hijack old threads ("partitioned table query question" in
this case) and change the subject line to start your new question. it
messes up threaded mail readers.
thanks.
On Dec 10, 2007, at 3:00 PM, Nathan Wilhelmi wrote:
> Hello - Does anyone happen to have a SQL script or function that can
> reset all the sequence values found in a given DB? When we rebuild
> the DB it would be handy to be able to set all the sequence back to
> a known starting place.
>
> Thanks!
>
> -Nate
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2007-12-10 22:27:14 | Re: SQL design pattern for a delta trigger? |
Previous Message | Colin Wetherbee | 2007-12-10 22:04:31 | Re: SQL design pattern for a delta trigger? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-12-10 22:26:11 | Re: Release Note Changes |
Previous Message | Bruce Momjian | 2007-12-10 22:18:51 | Re: Release Note Changes |