| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | Bill Studenmund <wrstuden(at)netbsd(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: RFD: schemas and different kinds of Postgres objects |
| Date: | 2002-01-31 03:43:41 |
| Message-ID: | 29733.1012448621@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> For example, doesn't 'DROP table a_table' drop the
> a_table table in a schema in the *path* if there's
> no a_table table in the current schema ?
Sure. And that's exactly what it should do, IMHO.
Otherwise the notion that you can ignore your private
schema (at the front of the path) if you're not using
it falls down. Also, we wouldn't be able to implement
temp tables via a backend-local schema at the front of
the path.
Any security concerns here should be addressed by putting
ACLs on the schemas you don't want altered; not by contorting
the notion of a search path to work for some operations and
not others.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2002-01-31 03:47:20 | Re: RFD: schemas and different kinds of Postgres objects |
| Previous Message | Hiroshi Inoue | 2002-01-31 03:36:19 | Re: RFD: schemas and different kinds of Postgres objects |