Обсуждение: atttypmod problem
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
> > 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