Re: Borland BDE showing public schema in table names

This seems to have to do with the schema support in 7.3. There should be
a setting to turn it off, but I'm not sure.

Paul Cochrane wrote:

>Hi There.
>
>Might be a FAQ. First posting to this list. I just upgraded to
>postgresql 7.3.1 and am have some problems accessing the
>database from Paradox (which uses borlands BDE) through the
>psqlodbc driver (I am using the latest PGADMIN2).
>
>Whenever I want to use a table on the pgsql server, the tablenames
>returned to paradox are of the form "public.tablename" instead of
>plain "tablename". This screws up the application since it would
>need a LOT of changing to rename all the table references to this
>format.
>
>The server & connection seem to work properly - it's just the public
>addition to the name that is causing me problems.
>
>Thanks in advance for any information.
>
>                       -------------------------------------
>Paul Cochrane         |       Tayside Orthopaedic &         |
>                      | Rehabilitation Technology Centre    |
>=============         |-------------------------------------|
>                      | Ninewells Hospital & Med. School    |
>                      | Dundee, Scotland, UK.               |
>                      | DD1 9SY.                            |
>                      | Phone:  +44 1382 496284             |
>                      | Fax:    +44 1382 496322             |
>                      | E-Mail: paul@tortc.tuht.scot.nhs.uk |
>                       -------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>