Re: 7.3 pg_relcheck oddness

On further investigation, the problem is related to using a 7.2 psql
against a 7.3 backend. The \d from the 7.2 psql is not compatible with
the 7.3 backend in the case of tables with non-standard types apparently.

P.

Paul Ramsey wrote:
>
> I am poking around at upgrading PostGIS to work with version 7.3. So
> far, the changes seem relatively minor. There is one odd quirk though.
> Having gotten the PostGIS types and index bindings loaded, and having
> loaded a table full of spatial data, trying to do
>
> \d thetable
>
> returns
>
> ERROR: Relation "pg_relcheck" does not exist
>
> And when I check, lo and behold, it does *not* exist! \d still works on
> all "normal" tables however. I checked in the 7.2 instance, and
> pg_relcheck does exist, but has no entries in it. Simply adding an empty
> pg_relcheck to my 7.3 instance using the old 7.2 definitions caused \d
> to start working again on my spatial table.
>
> P.
>

--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey(at)refractions(dot)net
| Phone: (250) 885-0632
\_