Can't figure out column type dependencies

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Can't figure out column type dependencies
Date: 2004-08-10 04:13:22
Message-ID: 41184B62.9000300@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I'm looking to find all records in pg_depend that show that some columns
in my db depend on the 'timestamp' type. So I do this:

select * from pg_depend where refclassid=1247 and refobjid=1114;

1257 is the oid of the pg_type table and 1114 is the oid of the
timestamp type.

It returns just this:

australia=# select * from pg_depend where refclassid=1247 and refobjid=1114;
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
---------+-------+----------+------------+----------+-------------+---------
0 | 0 | 0 | 1247 | 1114 | 0 | p
(1 row)

How is that possible? I have heaps of columns that use the timestamp type:

select count(*) from pg_attribute where atttypid=1114;

If such dependencies aren't recorded, does the bit of code in alter
column type that deletes them ever do anything?

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-10 04:43:52 Re: Can't figure out column type dependencies
Previous Message Robert Treat 2004-08-10 03:46:53 Re: Beta Leader?