BUG #4147: pg_constraint table data retrieval error

Поиск
Список
Период
Сортировка
От Arun J M
Тема BUG #4147: pg_constraint table data retrieval error
Дата
Msg-id 200805061100.m46B0CSG045982@wwwmaster.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4147
Logged by:          Arun J M
Email address:      arun.jaganathan@alliedgroups.com
PostgreSQL version: 8.3
Operating system:   Windows XP Pro SP2
Description:        pg_constraint table data retrieval error
Details:

While we are retrieving the values from the Pg_constraint table using the
confkey column as mentioned below the query returns the null value, But it
should return the appropriate value from the small int array..

Executed Query:

select pg_constraint.confkey[1] from pg_catalog.pg_constraint

Expected Result:

{1}
{111}
{444}

Result Obtained:

Null values


This is not working on pgadmin/sql , psql , phpadmin/sql.

But the same query is working while executing from php code.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: BUG #4137: Postgres drives pg_standby %r param to delete WAL file before processing
Следующее
От:
Дата:
Сообщение: BUG: aliases does not work ((