On Fri, Nov 16, 2007 at 11:01:17AM -0600, Scott Marlowe wrote:
> > Another question, this public schema, in the usual practice way, do you
> > delete it or just leave it there and create your own schema?
>
> I leave it in place. IT doesn't hurt anything really.
Alternativly, you can revoke all p
On Nov 16, 2007 10:26 AM, <[EMAIL PROTECTED]> wrote:
>
>
> Hello Martin,
>
> Yes, SHOW search_path show this
> "$user",public .
>
> Oh yes, I get it now, the "$user" will take priority.
>
> Another question, this public schema, in the usual practice way, do you
> delete it or just leave it there a
--- Original Message
From: Martin Gainty <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Friday, November 16, 2007 3:17:40 PM
Subject: RE: [GENERAL] public schema doubt
Hello Louis
SHOW search_path
if public is not on search_path or does'nt come first then
SET search_pat
On Nov 16, 2007 8:56 AM, <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> I did a migration from 8.2.4 to 8.2.5,
Just FYI, from 8.2.4 to 8.2.5 doesn't require a dump / restore, you
can update minor versions in place.
> I used pg_dumpall to backup all the
> db and then restore it into 8.2.5. In my 8.2
Hello,
I did a migration from 8.2.4 to 8.2.5, I used pg_dumpall to backup all the db
and then restore it into 8.2.5. In my 8.2.4 db, I don't have public schema (it
was dropped when I create the db, so only myschema is there), but when I
restore to 8.2.5, I found that it created a public schema
