| From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
|---|---|
| To: | Gary M <postgres-general(at)mwwm(dot)net> |
| Cc: | Gary M <postgres-general(at)mwwm(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Retrieving database schema |
| Date: | 2003-03-25 03:02:48 |
| Message-ID: | 200303242202.48256.lamar.owen@wgcr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Saturday 22 March 2003 23:43, Gary M wrote:
> Thanks, the syntax works fine on 7.3.2.
> Note that "lower($table)" may not be desirable as you CAN create
> mixed-case table and column names, for example...
Like I said, it's a fairly old library query I use in the nspostgres AOLserver
database driver. It hasn't been updated in ages -- in fact, it's not been
changed since PostgreSQL 6.2.1 days. Methinks I need to do some PM on the
bit-rot, no? :-)
But how to move forward, without breaking backwards compatibility... will
require some thought. I can't force the use of PostgreSQL 7.3.x; but I can
check for it at compile time. (There are multiple OpenACS installations that
use this driver with 7.1.x and 7.2.x backends.)
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Olivier | 2003-03-25 10:44:38 | Migrate Mysql to Posgresql |
| Previous Message | Alvaro Herrera | 2003-03-25 02:32:41 | Re: 4 billion + oids |