Which version will this run on?

Поиск
Список
Период
Сортировка
От Mads Lie Jensen
Тема Which version will this run on?
Дата
Msg-id 86obm557bce9aufnnaul37dp3o9gu1lc0f@4ax.com
обсуждение исходный текст
Ответы Re: Which version will this run on?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@gartneriet.dk - ICQ #25478403
Gartneriet - http://www.gartneriet.dk/

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problems backing up
Следующее
От: Sebastien Boisvert
Дата:
Сообщение: Determine if postmaster can accept new connections