Обсуждение: Which version will this run on?

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@gartneriet.dk - ICQ #25478403
Gartneriet - http://www.gartneriet.dk/

Mads Lie Jensen <mads@gartneriet.dk> writes:
> 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?

A quick test says that it works back to 7.4, which is the oldest
version that is supported at all anymore.  I don't think you need
to worry too much.

            regards, tom lane

On Sun, 31 Jan 2010 16:11:46 -0500, tgl@sss.pgh.pa.us (Tom Lane) wrote:

>A quick test says that it works back to 7.4, which is the oldest
>version that is supported at all anymore.  I don't think you need
>to worry too much.

Thank you for the answer.
Had it worked on just any 8.x-version, I would have been more than happy
:-)
--
Mads Lie Jensen - mads@gartneriet.dk - ICQ #25478403
Gartneriet - http://www.gartneriet.dk/