Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread David Newall
On 14/10/10 12:14, Itagaki Takahiro wrote: Which solution is better? Or, another idea? This does seem to be an new bug in previously working code. While any solution that fixes the problem is good, it might pay to look the code that worked before. As reported, it worked for ecpg (Postgr

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread Itagaki Takahiro
On Thu, Oct 14, 2010 at 3:52 PM, David Newall wrote: > This does seem to be an new bug in previously working code.  While any > solution that fixes the problem is good, it might pay to look the code that > worked before.  As reported, it worked for ecpg (PostgreSQL 8.3.8) 4.4.1. It works on 8.3,

Re: [BUGS] libpq: system-wide root.crt

2010-10-14 Thread Robert Haas
On Sat, Sep 25, 2010 at 3:38 PM, Peter Eisentraut wrote: > On fre, 2010-09-24 at 09:50 +0200, Magnus Hagander wrote: >> > I'm thinking, libpq could really use a global (and, for that matter, a >> > per-user) configuration file, where you could set defaults for some of >> > the things that you curr

Re: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly

2010-10-14 Thread Robert Haas
On Tue, Oct 5, 2010 at 11:56 AM, Xiaohui Xue wrote: > > The following bug has been logged online: > > Bug reference:      5694 > Logged by:          Xiaohui Xue > Email address:      xiaohui@sap.com > PostgreSQL version: 8.3.4 > Operating system:   Windows > Description:        Postgres ODBC S

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread Michael Meskes
Am 14.10.2010 08:52, schrieb David Newall: On 14/10/10 12:14, Itagaki Takahiro wrote: Which solution is better? Or, another idea? This does seem to be an new bug in previously working code. While any solution that fixes the problem is good, it might pay to look the code that worked before. As

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread Robert Haas
On Thu, Oct 14, 2010 at 6:53 AM, Michael Meskes wrote: > Am 14.10.2010 08:52, schrieb David Newall: >> >> On 14/10/10 12:14, Itagaki Takahiro wrote: >>> >>> Which solution is better? Or, another idea? >> >> This does seem to be an new bug in previously working code. While any >> solution that fixe

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread Itagaki Takahiro
On Mon, Oct 11, 2010 at 7:42 AM, David Newall wrote: > Trivial program to demonstrate problem: > > main() { >    ECPGdebug(1,stderr); >    exec sql connect to postgres; >    exec sql set autocommit to off; >    exec sql start transaction; >    exec sql savepoint s; >    exec sql rollback to s; >  

[BUGS] BUG #5709: PostgreSQL server 8.4.5 does not compile with gcc 4.5

2010-10-14 Thread Daniel Gerzo
The following bug has been logged online: Bug reference: 5709 Logged by: Daniel Gerzo Email address: dan...@freebsd.org PostgreSQL version: 8.4.5 Operating system: FreeBSD Description:PostgreSQL server 8.4.5 does not compile with gcc 4.5 Details: This is the error I

Re: [BUGS] BUG #5709: PostgreSQL server 8.4.5 does not compile with gcc 4.5

2010-10-14 Thread Tom Lane
"Daniel Gerzo" writes: > libpq/auth.o: In function `pg_GSS_error.clone.2': > auth.c:(.text+0x1a9): undefined reference to `gss_display_status' > auth.c:(.text+0x1d1): undefined reference to `gss_release_buffer' > auth.c:(.text+0x203): undefined reference to `gss_display_status' > auth.c:(.text+0x2

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread Michael Meskes
Takahiro-san, I think the string-comparison is unreliable. So, I'd like to replace the code to use PQtransactionStatus(). I have two patches to do it: The first one (ecpg-trans-quick_20101014.patch) is a quick fix that replaces only the above test. The second one (ecpg-trans-full_20101014.patch)

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread David Newall
On Thu, Oct 14, 2010 at 6:53 AM, Michael Meskes wrote: You seem to be answering to an email that I didn't see and couldn't find in the archive either. Was it send in private or to the list? If it went to the list I might be lagging behind. On 14/10/10 22:51, Robert Haas wrote: I didn't g

[BUGS] BUG #5710: lock requires unintuitive privileges

2010-10-14 Thread
The following bug has been logged online: Bug reference: 5710 Logged by: Email address: mstone+postg...@mathom.us PostgreSQL version: 8.4.5 Operating system: Ubuntu Description:lock requires unintuitive privileges Details: I haven't been able to find specific docum

Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running

2010-10-14 Thread Bruce Momjian
Robert Haas wrote: > On Mon, Sep 27, 2010 at 12:44 PM, Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > > > We're happy to see the problem resolved on your end. :-)-- > > > > However, it doesn't seem that we've actually done anything about the > underlying issue with pg_ctl. I will look

Re: [BUGS] BUG #5682: Postgres Service crashes with exception 0xC0000135

2010-10-14 Thread Bruce Momjian
Craig Ringer wrote: > On 29/09/2010 5:11 PM, aswin jayaraman wrote: > > I ll try that out.Is there means to do an upgrade to 8.3 to 8.4/9.0 with > > the data in place? > > No, it requires a dump and reload. Sorry. You'll want to read the > release notes, as there have been changes between 8.3 and

[BUGS] BUG #5711: input out of error with haversine formual

2010-10-14 Thread Vince
The following bug has been logged online: Bug reference: 5711 Logged by: Vince Email address: vincecar...@gmail.com PostgreSQL version: 8.4 Operating system: Linux Description:input out of error with haversine formual Details: The following will return an input out