Re: [BUGS] BUG #3067: Unnecessary lock blocks reindex

"Axel Noltemeier" <[EMAIL PROTECTED]> writes: > -- This statement generates an unnecessary(?) lock > -- on factory_pkey. That index is not used in the plan. > EXPLAIN ANALYZE SELECT * > FROM factory f > Where f.id IN (select m.factory_id from machine m); That behavior was changed here: http://arch

Re: [BUGS] BUG #3064: In Stored Procedures (pgplgql

Fridman Garri wrote: > > The following bug has been logged online: > > Bug reference: 3064 > Logged by: Fridman Garri > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.0 > Operating system: WinXP-Prof > Description:In Stored Procedures (pgplgql > Details:

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

On Fri, 23 Feb 2007, Zdenek Kotala wrote: There is Solaris FAQ update. Please, look on it and let me know any comments. Very minor grammatical nits aside, it looks fine to me. Thanks for updating the FAQ! Cheers, -- Rich Teer, SCSA, SCNA, SCSECA, OpenSolaris CAB member President, Rite Onlin

Re: [BUGS] BUG #3048: pg_dump dumps intarray metadata incorrectly

Maybe possibly remove DEFAULT definition from the intarray initialization SQL and eliminate in the documentation: "if you want to use GIN with _int4, you have to specify the operator class explicitly and manually"? This at least does not break the standard pg_dump behaviour. We checked, if we remo

[BUGS] BUG #3067: Unnecessary lock blocks reindex

The following bug has been logged online: Bug reference: 3067 Logged by: Axel Noltemeier Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: linux: Ubuntu 6.10, Edgy Eft; Mandriva 9.2 Description:Unnecessary lock blocks reindex Details: Data

Re: [BUGS] BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys

On 2007-02-23, Tom Lane wrote: "Eli Green" <[EMAIL PROTECTED]> writes: The columns listed in constraint_column_usage in the SQL92 information schema are from the wrong "side" of the key. Are you certain this is wrong? The SQL99 spec is not exactly readable on the matter, but as best I can tel

[BUGS] BUG #3065: Bug in stored procedure EXEPTION handling or in plpgsql ?

The following bug has been logged online: Bug reference: 3065 Logged by: Fridman Garri Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: WinXP-Prof SP2 Description:Bug in stored procedure EXEPTION handling or in plpgsql ? Details: If I cal

[BUGS] Spelling error in 8.1.6-1 Windows Error Dialog typo

Not sure where to find the TODO list per the bug reporting guidelines, but this is pretty simple. It may be fixed in newer versions, but we are using this version until 8.2 is tested on our systems. Do with this what you will. When you create a superuser with a semi-colon or quotes the error dial

[BUGS] BUG #3064: In Stored Procedures (pgplgql

The following bug has been logged online: Bug reference: 3064 Logged by: Fridman Garri Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: WinXP-Prof Description:In Stored Procedures (pgplgql Details: A PSQL terminates with a Message: server

[BUGS] BUG #3059: psql to 'postgres' shortcut

The following bug has been logged online: Bug reference: 3059 Logged by: Raymond Naseef Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:psql to 'postgres' shortcut Details: The shortcut to run psql.exe added to the m

Re: [BUGS] BUG #3032: Commit hung for days

Thanks for the response Magnus. The server logs do not show anything unusual, other than the occurrence 5 minutes prior. I will still take your advice on the upgrade. 2007-02-15 19:54:13 LOG: autovacuum: processing database "MM" 2007-02-15 19:55:13 LOG: autovacuum: processing database "postg