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, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Laurent ROCHE <[EMAIL PROTECTED]> À : Martijn van Oosterhout <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Martijn van Oosterhout <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgsql-general@postgresql.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 <[EMAIL PROTECTED]> 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
