Thread

1. atttypmod problem

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-05T19:08:12Z

   Still have some problem:
   	
   	test=> select attname,atttypmod from pg_attribute where atttypmod != 0;
   	attname      |atttypmod
   	-------------+---------
   	grolist      |       -1
   	attdisbursion|       -1
   	relacl       |       -1
   	(3 rows)
   
   It may have to do with columns that have special column types.  Any
   ideas?  If these are wrong, other values on that row are wrong too.
   
   This also shows disturbing results:
   
   	select attname,attcacheoff from pg_attribute where attcacheoff != -1;
   
   Many have a value of zero.
   
   -- 
   Bruce Momjian
   maillist@candle.pha.pa.us
   
   

2. Re: [HACKERS] atttypmod problem

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-05T19:47:00Z

   > 
   > Still have some problem:
   > 	
   > 	test=> select attname,atttypmod from pg_attribute where atttypmod != 0;
   > 	attname      |atttypmod
   > 	-------------+---------
   > 	grolist      |       -1
   > 	attdisbursion|       -1
   > 	relacl       |       -1
   > 	(3 rows)
   > 
   > It may have to do with columns that have special column types.  Any
   > ideas?  If these are wrong, other values on that row are wrong too.
   
   I found the problem.  Was a stupid mistake I made when I was adding
   atttypmod.
   
   
   > 
   > This also shows disturbing results:
   > 
   > 	select attname,attcacheoff from pg_attribute where attcacheoff != -1;
   > 
   > Many have a value of zero.
   
   Not sure about these yet.
   
   -- 
   Bruce Momjian
   maillist@candle.pha.pa.us