| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: pgstattuple for schemas |
| Date: | 2003-05-23 13:19:24 |
| Message-ID: | 1053695963.279.49.camel@jester |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
On Fri, 2003-05-23 at 09:15, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > Using a table name requires that the table be in the current search
> > path, which for single use might be fine but not for an interface.
>
> Actually, it requires no such thing, because the code is already
> schema-aware -- you can do pgstattuple('foo.bar').
heh.. didn't even think of trying that (obviously).
> > Add a pgstattuplebyid(oid) function.
>
> Perhaps this is worth having, but not for the reason given above.
This is a much easier form to deal with in code. If it can be added for
that reason, it would be appreciated.
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera Munoz | 2003-05-23 14:17:23 | Re: Static snapshot data |
| Previous Message | Tom Lane | 2003-05-23 13:15:24 | Re: pgstattuple for schemas |