From: | _ <ndescripto(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | what is the meaning of "schema"? |
Date: | 2003-06-20 15:19:01 |
Message-ID: | 20030620151901.59349.qmail@web13202.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
My understanding of "schema" that I discovered
in 7.3 (I don't think they were available before)
is that you can have two tables with the same name
if they are in different schemas.
I have done a google search, as well as archive search
but
pg_dump and pg_dumpall are broken if a database
contains schemas.
First of all if there are two tables with the same
name in different schemas pg_dump only dumps out
one table. There is no way to dump other tables
and I have checked pg_dump man page
Restoring a pg_dumpall is now a nightmare because
I had as superuser
# create schema test authorization httpd
on a database not owned by database owner.
And it works merrily until the time to
dump and restore.
pg_dumpall answers to above create authorization is
\connect - httpd
create schema test
Hell breaks lose with that! Because httpd cannot
create schema on a database that it does not own.
Why couldn't pg_dumpall does
create schema test authorization httpd
as superuser when the schema was created in that
fashion?
I really don't think anyone is going to pay attention
to this rant since these list does not like/answer anonymous posts
but I have to post just so some poor soul might find
it in the archive and be warned.
My current versions are 7.3.2 and 7.3.3 and I have been using
posgres since 7.1 and consider myself experienced with postgres
Schemas are the best thing since slice breads but
the baker decided to poison the bread. Nice!
Thanks
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-06-21 11:55:47 | Re: [HACKERS] what is the meaning of "schema"? |
Previous Message | Achilleus Mantzios | 2003-06-20 12:58:50 | Re: JDBC in PostgreSql for Linux |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2003-06-20 15:20:14 | Re: Two weeks to feature freeze |
Previous Message | The Hermit Hacker | 2003-06-20 15:10:43 | Re: tsearch V2 (Was: Re: Two weeks to feature freeze) |