Which version will this run on?

From: Mads Lie Jensen <mads(at)gartneriet(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Which version will this run on?
Date: 2010-01-31 20:01:01
Message-ID: 86obm557bce9aufnnaul37dp3o9gu1lc0f@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have this:

SELECT pg_catalog.pg_get_constraintdef(r.oid, true) AS condef
FROM pg_catalog.pg_constraint r,
pg_catalog.pg_class c
WHERE c.oid=r.conrelid
AND r.contype = 'f'
AND c.relname = 'table_name'

which gives me the foreign keys of a given table in the database.
It is working perfectly on my 8.4.2-version of pstgresql.

But what other versions of postgresql will it run on?

Its used in a php-project, and I would like to know which minimum
version of postgres I should recommend.

Thanks in advance.

--
Mads Lie Jensen - mads(at)gartneriet(dot)dk - ICQ #25478403
Gartneriet - http://www.gartneriet.dk/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastien Boisvert 2010-01-31 20:24:36 Determine if postmaster can accept new connections
Previous Message Tom Lane 2010-01-31 19:02:38 Re: Problems backing up