[BUGS] BUG #2815: Editing / Creating ODBC on Windows fails libintl-2.dll not found

2006-12-06 Thread mike godshall
The following bug has been logged online: Bug reference: 2815 Logged by: mike godshall Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows 2003 webserver edition Description:Editing / Creating ODBC on Windows fails libintl-2.dll not foun

Re: [BUGS] BUG #2810: restore to lower version of dump

2006-12-06 Thread Christopher Browne
Quoth [EMAIL PROTECTED] ("Murali"): > The following bug has been logged online: > > Bug reference: 2810 > Logged by: Murali > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: WINXP > Description:restore to lower version of dump > Details:

Re: [BUGS] BUG #2811: Error determining param type in prepared statement of unused variable

2006-12-06 Thread Tom Lane
"Ross Cohen" <[EMAIL PROTECTED]> writes: > PREPARE demo (unknown) AS SELECT 1; > ERROR: could not determine data type of parameter $1 This doesn't seem like a bug to me. The parser needs to be able to resolve the types of any unknown parameters, and you've not given it enough information to do t

Re: [BUGS] BUG #2812: Transaction is aborted after error

2006-12-06 Thread Alvaro Herrera
Alex Piyevsky wrote: > We issue a command which drops the existing table and recreates the table > under the same name, all in one transaction. If the table does not > previously exist, an error message is returned for the drop command and the > transaction aborts with the following: > > current

[BUGS] BUG #2812: Transaction is aborted after error

2006-12-06 Thread Alex Piyevsky
The following bug has been logged online: Bug reference: 2812 Logged by: Alex Piyevsky Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux Kernel-2.4.21-glibc-2.3.2 x86 32bit Description:Transaction is aborted after error Details: We i

Re: [BUGS] 8.2 bug with outer join reordering

2006-12-06 Thread Tom Lane
I wrote: > I can't reproduce it with less than four tables, so it's a pretty > weird corner case. Apparently there's something wrong with > distribute_qual_to_rels' logic for determining qual placement, but > I'm not sure what yet ... OK, I've localized the problem and been able to reduce it to a

Re: [BUGS] 8.2 bug with outer join reordering

2006-12-06 Thread Tom Lane
Jeff Davis <[EMAIL PROTECTED]> writes: > On 8.1 this returns 1 record. On 8.2 this returns 10. It appears to > be applying the filter too soon, and then it does an outer join which > violates the WHERE. AFAICS the outer join reordering is perfectly legal --- the problem is that the WHERE condi

[BUGS] BUG #2809: Incorrect ASP/ADO data types (ODBC Driver)

2006-12-06 Thread Brien R. Givens
The following bug has been logged online: Bug reference: 2809 Logged by: Brien R. Givens Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Win XP Description:Incorrect ASP/ADO data types (ODBC Driver) Details: Hi, In ADO, a boolean field is

[BUGS] BUG #2808: setup error

2006-12-06 Thread kindy
The following bug has been logged online: Bug reference: 2808 Logged by: kindy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0-1 Operating system: Window 2003 Enterprise Edition SP1(CHS) Description:setup error Details: setup log: The program "postgres" i

[BUGS] BUG #2810: restore to lower version of dump

2006-12-06 Thread Murali
The following bug has been logged online: Bug reference: 2810 Logged by: Murali Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: WINXP Description:restore to lower version of dump Details: I have taken dump from 8.1.4 postgresql db + win

[BUGS] BUG #2811: Error determining param type in prepared statement of unused variable

2006-12-06 Thread Ross Cohen
The following bug has been logged online: Bug reference: 2811 Logged by: Ross Cohen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: linux (fedora core 4, released RPMS) Description:Error determining param type in prepared statement of unused

[BUGS] BUG #2807: constraint violation

2006-12-06 Thread Ross Cohen
The following bug has been logged online: Bug reference: 2807 Logged by: Ross Cohen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: linux (fedora core 4, released RPMS) Description:constraint violation Details: This query: select phot

[BUGS] 8.2 bug with outer join reordering

2006-12-06 Thread Jeff Davis
Thanks to rcohen on IRC yesterday for pointing this out and providing his query + EXPLAIN output. It looks like he still hasn't posted it to -bugs, and I was finally able to reproduce it in a narrower, self contained test case, so I'm posting this right now. On 8.1 this returns 1 record. On 8.2