Hello,
>>> paf=# \db
>>>
>>> ERROR: column "spclocation" does not exist
>>>
>>> LINE 3: spclocation AS "Location"
>>>
>>> ^
>>>
>>>
>
>
>> Are you using the psql provided by 9.2 beta 2? Or an older version? It
>> appears that the version of psql in 9.2 beta 2 does the correct thing,
>> look at src/bin/psql/describe.c line 142 or so.
>>
>
> Yeah, the OP must be using a 9.1 or earlier psql to connect to the
> 9.2beta2 server showed in his version() output. There's a reason we
> print out a warning like this:
>
> WARNING: psql version X.a, server version Y.b
> Some psql features might not work.
>
> when the major version of psql and the server it is connecting to don't match.
>
> Josh
>
>
Oups ! You are right, I was not using the right psql client version!!!
I am using different pg version for various tests. And I failed here to
use the right PATH.
Please accept my apologies for the noise.
I will be more careful before reporting the next bug ;-)
Best regards.
Philippe.