Re: [gnome-db]Not all tables in PostgreSQL

[Rodrigo Moya <rodrigo gnome-db org>]

On 25 Jul 2001 13:18:13 -0400, Adam Tauno Williams wrote:
> Is there a known problem with table enumeration?  I create a new
> PostgreSQL database with one table and one sequence.  I attached with
> gnomedb-fe and gASQL to see if it worked and it did!  Then I added a few
> more tables and sequences and .... they don't show up in either
> gnomedb-fe or gASQL.  I can see them in psql using "\d".  I've restarted
> the applications,  logged out and back in, etc... but can't get the
> tables.
> 
I have never seen this problem before.

	" SELECT a.realname AS \"Name\" "
	" FROM pg_class a, pg_user b "
        "WHERE ( relkind = 'r') and relname !~ '^pg_' "
        "AND relname !~ '^xin[vx][0-9]+' AND "
        "b.usesysid = a.relowner AND "
        "NOT (EXISTS (SELECT viewname FROM pg_views "
        "WHERE viewname=a.relname)) ");

That's the query the postgres provider does to get the list of tables
from the postgres server. Maybe the names of your tables don't match the
"AND relname !~ '^xin[vx][0-9]+'" condition?

cheers
--
Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com>
http://www.gnome-db.org/ - http://www.ximian.com/