I found a bug in the ->tables method.  It includes all the system tables.
A patch is at the bottom of the message.

The SQL was correct in 1.13 so I'm not sure how this happened.  There's
also no real test of this method in the test suite, other than testing to
make sure that calling it doesn't die.  But you need to test that it
returns the right thing too ;)

I'd like to offer a test patch but I don't know exactly what you'd expect
to find in the schema during testing.


--- Pg.pm.old   2002-11-29 13:38:45.000000000 -0600
+++ Pg.pm       2002-11-29 13:38:18.000000000 -0600
@@ -531,6 +531,7 @@
             select relname  AS \"TABLE_NAME\"
             from   pg_class
             where  relkind = 'r'
+            and    relname !~ '^pg_'
             and    relname !~ '^xin[vx][0-9]+'
             order by 1
         ") or return undef;

Reply via email to