[HACKERS] Can't figure out column type dependencies

[Christopher Kings-Lynne]

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
---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [HACKERS] Can't figure out column type dependencies

[Tom Lane]

Christopher Kings-Lynne [EMAIL PROTECTED] writes:
 How is that possible?  I have heaps of columns that use the timestamp type:

We don't make dependency entries for pinned objects (which includes all
built-in datatypes).

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]