atttypmod problem

Started by Bruce Momjianabout 28 years ago2 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.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.

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Bruce Momjian (#1)
Re: [HACKERS] 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.

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