Re: [BUGS] BUG #3269: PSQL does not display error output

2007-08-04 Thread Brandon Craig Rhodes
"Bojan Jovanovic" <[EMAIL PROTECTED]> writes: > We just upgraded to 8.2.4, and noticed that psql does not display error > messages, e.g.: > ... > shp_production=# select * from asdfafsdf; On my system I compiled 8.2.4 as well, and not only would an interactive session like yours display no error

Re: [BUGS] failed to re-find parent key in "..." for deletion target page

2007-08-04 Thread Tom Lane
Brian Hirt <[EMAIL PROTECTED]> writes: > basement_dev=# VACUUM FULL developer_name; > ERROR: failed to re-find parent key in > "developer_name_developer_name" for deletion target page 163 Oh dear, I thought we'd fixed that. Can you send me copies of this index file ... and preferably the under

[BUGS] BUG #3512: buggy install + no manual support

2007-08-04 Thread Lamia Jackson
The following bug has been logged online: Bug reference: 3512 Logged by: Lamia Jackson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4.1 Operating system: win32 Description:buggy install + no manual support Details: before completing installation i reciev

[BUGS] failed to re-find parent key in "..." for deletion target page

2007-08-04 Thread Brian Hirt
I was doing some testing with tsearch2 on my dev box and I've run across this problem. I created the tsvector and added the trigger and then i was updating the entire table to populate the ixdfti field. When i was done, I was unable to vacuum the table, I get this error. Any ideas an

Re: [BUGS] Oddities with ANYARRAY

2007-08-04 Thread Decibel!
On Thu, Aug 02, 2007 at 12:44:02AM +0100, Gregory Stark wrote: > > "Decibel!" <[EMAIL PROTECTED]> writes: > > > On Jul 31, 2007, at 11:55 PM, Gregory Stark wrote: > >> > >> And what type would the result be? > > > > ANYELEMENT? I know that'd still have to be casted to something normal > > eventua

Re: [BUGS] BUG #3499: no owner privileges in information_schema.table_privileges

2007-08-04 Thread Decibel!
Any idea what the spec says about this? On Mon, Jul 30, 2007 at 10:28:37PM +, Kirill Simonov wrote: > > The following bug has been logged online: > > Bug reference: 3499 > Logged by: Kirill Simonov > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.4 > Operating

Re: [BUGS] BUG #3511: timeofday()::timestamp failing on Saturday when using australian_timezones = on

2007-08-04 Thread Tom Lane
"Adam" <[EMAIL PROTECTED]> writes: > Conversion to a timestamp is failing to decode a timeofday() date string > which has both 'Sat' and a timezone 'EST', when australian_timezones is > enabled. Yeah, there's not a lot we can do about that. Changing timeofday()'s output format seems a bad idea, b

[BUGS] BUG #3511: timeofday()::timestamp failing on Saturday when using australian_timezones = on

2007-08-04 Thread Adam
The following bug has been logged online: Bug reference: 3511 Logged by: Adam Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: Debian etch, using postgresql-8.1:8.1.9-0etch1 Description:timeofday()::timestamp failing on Saturday when using