Re: pgstattuple for schemas - Mailing list pgsql-patches

From Rod Taylor
Subject Re: pgstattuple for schemas
Date
Msg-id 1053695963.279.49.camel@jester
Whole thread Raw
In response to Re: pgstattuple for schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Fri, 2003-05-23 at 09:15, Tom Lane wrote:
> Rod Taylor <rbt@rbt.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@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgstattuple for schemas
Next
From: Fernando Nasser
Date:
Subject: JDBC: Wrong type