pgAdmin: blank header in the "Edit Data" window if table OID changes

Поиск
Список
Период
Сортировка
От Steven Elliott
Тема pgAdmin: blank header in the "Edit Data" window if table OID changes
Дата
Msg-id 1303019314.26790.136.camel@grey
обсуждение исходный текст
Ответы Re: pgAdmin: blank header in the "Edit Data" window if table OID changes  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
I noticed that the headers (column names and types at the top of the
table) are blank in the "Edit Data" window (displayed if "View the data
in the selected object" button is pressed) if the table OID changes
while pgAdmin is running.  I have this problem (changed table OID) when
I recreate a database from a dump while pgAdmin is running.

Turning on query logging reveals that the issue is that pgAdmin is using
cached OIDs.  Refreshing the table (pressing F5 while the table is
selected) fixes the problem.  Refreshing also causes pgAdmin to use the
updated OID.

There are various queries involved in displaying the "Edit Data" window,
but consider this one: SELECT attisdropped  FROM pg_attribute  WHERE attnum > 0 AND attrelid=36214::oid ORDER BY
attnum;
In this case "36214" is the cached and possibly stale table OID.  If the
OID is stale then the above returns zero rows, so one possibility is to
reload the table OIDs if the this query returns less rows than expected.
Another is to use the table name in each query, so the above becomes (if
the table is named "my-table"): SELECT attisdropped  FROM pg_attribute  WHERE attnum > 0 AND
attrelid='my-table'::regclassORDER BY attnum;
 
But I suppose that is slower.

I've seen this problem on Fedora 13 i686 as well as Fedora 14 x86_64.
I've seen it with pgAdmin version 1.10.5 as well as latest GIT as of
2011-04-17.

Let me know if there is anything else I can tell you that would be
helpful.

-- 
------------------------------------------------------------------------
|  Steven Elliott  |  http://selliott.org  |  selliott4@austin.rr.com  |
------------------------------------------------------------------------



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

Предыдущее
От: "John Pagakis"
Дата:
Сообщение: PGAdmin - saving result sets from queries where one or more columns are of the type boolean
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgAdmin: blank header in the "Edit Data" window if table OID changes