Re: Is it possible to remove the public schema?

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: "Henry Combrinck" <henry(at)metroweb(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible to remove the public schema?
Date: 2004-10-21 17:11:19
Message-ID: 200410211111.19692.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday October 21 2004 10:07, Tom Lane wrote:
> "Henry Combrinck" <henry(at)metroweb(dot)co(dot)za> 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.
> >
> It sounds to me like the real problem is with non-schema-aware client
> software. I think your options are to fix that, or downgrade to a
> non-schema-aware database (eg. Postgres 7.2 or before).

And you do NOT want to downgrade to Pgsql 7.2 or before. Check out the list
of changes and bug-fixes since 7.2 to see what you'll be downgrading to.
You'll likely have far more trouble than modifying your client software.

Ed

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Fitzpatrick 2004-10-21 17:19:03 Outliers of data
Previous Message Jan Wieck 2004-10-21 17:03:01 Re: Information about storge engine in PostgreSQL