From: | mailtolouis2020-postgres(at)yahoo(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: public schema doubt |
Date: | 2007-11-16 16:26:49 |
Message-ID: | 626731.97403.qm@web30410.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 and create your own schema?
Regards
Louis
----- Original Message ----
From: Martin Gainty <mgainty(at)hotmail(dot)com>
To: mailtolouis2020-postgres(at)yahoo(dot)com
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_path TO public,$user;
HTH/
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
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 for me. So why it doing this for me? I thought it should restore back excatly the same what I backup from 8.2.4?
Should I just let the public schema there? Will it cause any problem? In the postgres doc http://www.postgresql.org/docs/8.2/interactive/ddl-schemas.html (5.7.2) it said if I create a table without specify any schema name, it will put it into public schema, so I test it in my case, but it not doing it, the table is create under myschema, strange. And I check the search_path, it show "$user",public .
Could someone explain it to me?
Thanks
Louis
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now!
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-16 16:28:20 | Re: unexplainable error |
Previous Message | Scott Marlowe | 2007-11-16 16:19:15 | Re: Substitute column in SELECT with static value? |