Re: [GENERAL] table - sequence dependent informatio
Peter Geoghegan peter.geoghega...@gmail.com writes: On 31 August 2010 18:02, akp geek akpg...@gmail.com wrote: Hi all - Is there a way I can tell table - sequence dependent information. which sequences are being used by which table? thanks for the help Take a look at the post Finding orphaned sequences on this blog: http://blog.tapoueh.org/blog.dim.html Or use the direct link to the article : http://tapoueh.org/articles/blog/_Finding_orphaned_sequences.html Regards, -- dim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] table - sequence dependent informatio
Hi all - Is there a way I can tell table - sequence dependent information. which sequences are being used by which table? thanks for the help
Re: [GENERAL] table - sequence dependent informatio
On 31 August 2010 18:02, akp geek akpg...@gmail.com wrote: Hi all - Is there a way I can tell table - sequence dependent information. which sequences are being used by which table? thanks for the help Take a look at the post Finding orphaned sequences on this blog: http://blog.tapoueh.org/blog.dim.html Change the last part of the query from WHERE a.tablename IS NULL to WHERE a.tablename IS NOT NULL. That'll show you what tables your SERIAL sequences are being used on. -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general