On Tuesday 05 February 2008 07:04:08 pm johnf wrote:
> On Tuesday 05 February 2008 06:13:41 pm Ed Leafe wrote:
> > On Feb 5, 2008, at 7:52 PM, johnf wrote:
> > > So, you'll need to quote the table name when you create it. But this
> > > means that you'll *always* have to quote references to it.
> >
> > Yes, I know that - I've been dealing with that since I started
> > working here. Apparently, several years ago someone used a tool to
> > migrate their data into Postgres, and it defaulted to case-sensitive
> > names. Now so much code exists that it would be more of a pain to
> > change it.
> >
> > The problem seems to be that getTables() is not working correctly. At
> > the point in the wizard where it crashes, the connection to the DB has
> > been made, and the backend object is trying to query the DB for its
> > tables. If you can point me to a good reference for your getTables
> > logic, I'll see if I can figure out exactly what's tripping it up.
> >
> > -- Ed Leafe
>
BTW if you use information_schema
SELECT table_name,table_schema
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
AND table_schema NOT IN
('pg_catalog', 'information_schema');
will get the tables.
I know you don't like information_schema but maybe it is time we reconsider.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
