[HACKERS] 7.3 pg_relcheck oddness

2002-12-05 Thread Paul Ramsey
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:

Re: [HACKERS] 7.3 pg_relcheck oddness

2002-12-05 Thread Paul Ramsey
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

Re: [HACKERS] 7.3 pg_relcheck oddness

2002-12-05 Thread Tom Lane
Paul Ramsey [EMAIL PROTECTED] writes: \d thetable returns ERROR: Relation pg_relcheck does not exist I think you are using a 7.2 psql with the 7.3 server. There will be quite a few problems with backslash commands in that combination (or the reverse), because of the extensive catalog