Thread: 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