From: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re : Re : Resetting SEQUENCEs |
Date: | 2007-10-18 21:32:59 |
Message-ID: | 520765.68227.qm@web34402.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)u
The Computing Froggy
----- Message d'origine ----
De : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
À : Martijn van Oosterhout <kleptog(at)svana(dot)org>
Envoyé le : Jeudi, 18 Octobre 2007, 20h15mn 46s
Objet : Re : [GENERAL] 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(at)u
The Computing Froggy
----- Message d'origine ----
De : Martijn van Oosterhout <kleptog(at)svana(dot)org>
À : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
Cc : pgsql-general(at)postgresql(dot)org
Envoyé le : Jeudi, 18 Octobre 2007, 20h02mn 31s
Objet : Re: [GENERAL] 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(at)svana(dot)org>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Wipf | 2007-10-18 21:34:18 | Re: Determining oldest WAL for Archiving PITR Standby - SOLVED |
Previous Message | Laurent ROCHE | 2007-10-18 21:26:43 | Re : Abbreviation list |