Added to TODO:
|Add function to dump pg_depend information cleanly
---
Greg Smith wrote:
> On Wed, 9 Sep 2009, decibel wrote:
>
> > What might be more useful is a view that takes the guesswork out of using
> > pg_
On Sep 14, 2009, at 1:36 AM, Greg Smith wrote:
CASE
WHEN c1.relkind='r' THEN 'table'
WHEN c1.relkind='i' THEN 'index'
WHEN c1.relkind='S' THEN 'sequence'
WHEN c1.relkind='v' THEN 'view'
WHEN c1.relkind='c' THEN 'composite'
WHEN c1.relkind='t' THEN 'TOAST'
ELSE '?'
On Wed, 9 Sep 2009, decibel wrote:
What might be more useful is a view that takes the guesswork out of using
pg_depend. Namely, convert (ref)classid into a catalog table name (or better
yet, what type of object it is), (ref)objid into an actual object name, and
(ref)objsubid into a real name.
On Sun, 2009-09-13 at 21:20 -0400, Robert Haas wrote:
> I'm not sure there's any point in reviewing this patch in its present
> form. Barring objections (or a new version), I think we should mark
> this Returned with Feedback.
>
> ...Robert
Yeah, sounds reasonable. The new version probably won'
On Thu, Sep 10, 2009 at 10:23 AM, Robert Haas wrote:
> On Thu, Sep 10, 2009 at 12:47 AM, Josh Williams wrote:
>> On Wed, 2009-09-09 at 11:30 -0500, decibel wrote:
>>> On Sep 9, 2009, at 8:05 AM, Peter Eisentraut wrote:
>>> > How is this better than just reading the information directly from
>>> >
On Thu, Sep 10, 2009 at 12:47 AM, Josh Williams wrote:
> On Wed, 2009-09-09 at 11:30 -0500, decibel wrote:
>> On Sep 9, 2009, at 8:05 AM, Peter Eisentraut wrote:
>> > How is this better than just reading the information directly from
>> > pg_depend?
>>
>> pg_depend is very difficult to use. You ha
On Wed, 2009-09-09 at 11:30 -0500, decibel wrote:
> On Sep 9, 2009, at 8:05 AM, Peter Eisentraut wrote:
> > How is this better than just reading the information directly from
> > pg_depend?
>
> pg_depend is very difficult to use. You have to really, really know
> the catalogs to be able to figur
On Sep 9, 2009, at 8:05 AM, Peter Eisentraut wrote:
On Thu, 2009-09-03 at 20:45 -0400, Josh Williams wrote:
The patch adds two new functions to the backend, pg_get_owner_object
and
pg_get_owner_column. These look up the requested object in the
pg_depend table, looking for an 'a' type dependency
On Thu, 2009-09-03 at 20:45 -0400, Josh Williams wrote:
> The patch adds two new functions to the backend, pg_get_owner_object
> and
> pg_get_owner_column. These look up the requested object in the
> pg_depend table, looking for an 'a' type dependency to another
> relation,
> and resolve either th
Attached is a patch to add a couple basic dependency look-up capability
functions. They're based off the pg_get_serial_sequence function, and
are kind of the inverse of that function in some respects.
The patch adds two new functions to the backend, pg_get_owner_object and
pg_get_owner_column. T
10 matches
Mail list logo
