Re : Re : Resetting SEQUENCEs

[Laurent ROCHE <laurent_roche@xxxxxxxxx>]

Hi,

So nobody can help me to write the SELECT that will return the SEQUENCE names, and their linked columns and their linked tables ?
Are the system tables documented somewhere ?

 

Cheers,
L@u
The Computing Froggy

----- Message d'origine ----
De : Laurent ROCHE <laurent_roche@xxxxxxxxx>
À : Martijn van Oosterhout <kleptog@xxxxxxxxx>
Envoyé le : Jeudi, 18 Octobre 2007, 20h15mn 46s
Objet : Re : Resetting SEQUENCEs

Yes, but when I change a database schema and I reload the data, and I need to resynch the SEQUENCE so that the INSERT command will work !

 

Have fun,
L@u
The Computing Froggy

----- Message d'origine ----
De : Martijn van Oosterhout <kleptog@xxxxxxxxx>
À : Laurent ROCHE <laurent_roche@xxxxxxxxx>
Cc : pgsql-general@xxxxxxxxxxxxxx
Envoyé le : Jeudi, 18 Octobre 2007, 20h02mn 31s
Objet : Re: Resetting SEQUENCEs

On Thu, Oct 18, 2007 at 10:06:00AM -0700, Laurent ROCHE wrote:
> Hi,
>
> I am quite surprised I could not find a way to automatically reset the value of a sequence for all my tables.

I never bother resetting sequences. It's not like the numbers mean
anything...

Have a nice day,
--
Martijn van Oosterhout  <kleptog@xxxxxxxxx>  http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

---

Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail

---

Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail