No problem at all.
It's easy to automate the table linking process.
I have a table in access that holds - among other things - the internal
and external name of my linked tables, in which database, schema and
server they locate.
[snip]
Thank you very much for the information.
Regards
Henry
Hello all
I've been approached by the development people about removing the 'public'
schema. They complain about having to manually remove the 'public_' tag
from table names generated by their development software whenever they
link to PG via ODBC.
Renaming or using another schema is not what
Henry Combrinck [EMAIL PROTECTED] writes:
I've been approached by the development people about removing the 'public'
schema. They complain about having to manually remove the 'public_' tag
from table names generated by their development software whenever they
link to PG via ODBC.
Renaming
On Thursday October 21 2004 10:07, Tom Lane wrote:
Henry Combrinck [EMAIL PROTECTED] writes:
I've been approached by the development people about removing the
'public' schema. They complain about having to manually remove the
'public_' tag from table names generated by their development
It sounds to me like the real problem is with non-schema-aware client
software.
They're using Office XP Developer (Access 2000). No hope of fixing that.
...I think your options are to fix that, or downgrade to a
non-schema-aware database (eg. Postgres 7.2 or before).
...and miss out on the
Henry Combrinck wrote:
It sounds to me like the real problem is with non-schema-aware client
software.
They're using Office XP Developer (Access 2000). No hope of fixing that.
Don't be pessimistic - give Bill a call and see if he'll accept a patch...
Failing that, I wrote a small VBA procedure
Bill, Madonna, and I are going out for beers after work. I'll mention it.
Richard Huxton
Henry Combrinck wrote:
It sounds to me like the real problem is with non-schema-aware client
software.
They're using Office XP Developer (Access 2000). No hope of fixing that.
No problem at all.
It's easy to automate the table linking process.
I have a table in access that holds - among other