Hi Tom,
I didn't receive any warnings upon entering the postgres server.
My client version is psql (PostgreSQL) 8.3.5.
My database server version is EnterpriseDB 8.3.0.12 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.0
Would it make a difference?
Ridvan
On Tue, Aug 4, 2009 at 11:38 AM, Tom Lane
<tgl@sss.pgh.pa.us> wrote:
"Ridvan Lakas ng Bayan S. Baluyos" <
ridvan@baluyos.net> writes:
> I'm currently having problems trying to describe a table in one of my
> database servers. Here's the error:
> backoffice_t2=# \d control.storedate_done
> ERROR: column t.tgconstraint does not exist
> LINE 3: WHERE t.tgrelid = '1154864' AND t.tgconstraint = 0
> ^
It should have warned you when you started it, like so:
WARNING: You are connected to a server with major version 8.2,
but your psql client is major version 8.3. Some backslash commands,
such as \d, might not work properly.
> Even in phpPgAdmin, I could not check the description of the table.
... and I'll bet your phpPgAdmin is out of sync too.
As of 8.4, psql's \d commands work with a range of older server
versions, but in every preceding release they are quite
version-specific. I don't know the exact story on cross-version
compatibility for phpPgAdmin, but it sounds like it's version-specific
as well.
regards, tom lane
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.comhttp://ridvan.baluyos.nethttp://www.onxiam.com/people/rbaluyosRegistered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.
