The following bug has been logged online:
Bug reference: 4596
Logged by: Kirill Simonov
Email address: x...@gamma.dn.ua
PostgreSQL version: 8.3.5
Operating system: Linux Ubuntu 8.10
Description:information_schema.table_privileges is way too slow
Details:
It takes
Tom Lane wrote:
"Kirill Simonov" writes:
It takes about 5 minutes to perform the query
SELECT * FROM information_schema.table_privileges
on an empty database (i.e. with system tables only).
Not here. What non-default settings might you be using?
Indeed, it is slow because there
Pavel Stehule wrote:
2008/12/25 Kirill Simonov :
Tom Lane wrote:
"Kirill Simonov" writes:
It takes about 5 minutes to perform the query
SELECT * FROM information_schema.table_privileges
on an empty database (i.e. with system tables only).
Not here. What non-default settings mi
el';
Yes, I realize why it's slow. I'm introspecting the database schema,
that's why I need the whole contents of "table_privileges". I suppose I
could obtain the same data from "pg_class.relacl", but I hoped to do it
in a portable way.
Thanks,
Kirill
The following bug has been logged online:
Bug reference: 2942
Logged by: Kirill Simonov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Linux
Description:information_schema.element_types: documentation error
Details:
The page
http
The following bug has been logged online:
Bug reference: 3499
Logged by: Kirill Simonov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux
Description:no owner privileges in
information_schema.table_privileges
Details:
Owner
The following bug has been logged online:
Bug reference: 4132
Logged by: Kirill Simonov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: FreeBSD
Description:REASSIGN OWNED fails on procedural languages
Details:
In Postgresql 8.3, one can
Hi,
I found a bug where a column from a LEFT OUTER JOIN sub-SELECT is not
equal to NULL when the whole row must be NULL because the join condition
is not satisfied.
Here is the test case:
--
DROP TABLE IF EXISTS c;
DROP TABLE IF EXISTS b;
DROP TABLE IF EXISTS a;
