Re: [BUGS] BUG #2628: jdbc2

2006-09-26 Thread Kris Jurka



On Thu, 14 Sep 2006, viniciusasousa wrote:



The following bug has been logged online:

Bug reference:  2628
PostgreSQL version: 8.0
Description:jdbc2
Details:

I has problem:

org.postgresql.jdbc2.Jdbc2DatabaseMetaData.locatorsUpdateCopy()Z



locatorsUpdateCopy is not part of the JDBC2 spec, but was added in JDBC3. 
So you'll need to download the JDBC3 version.


Kris Jurka

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [BUGS] BUG #2636: JDBC error behaviour incorrect

2006-09-26 Thread Kris Jurka



On Mon, 18 Sep 2006, Kiren Pillay wrote:


The following bug has been logged online:

Bug reference:  2636
PostgreSQL version: 8.1.4
Operating system:   Windows
Description:JDBC error behaviour incorrect
Details:

try {
DBActions db=DBActions.getInstance();


  rs = 
db.getConnection().prepareCall(loadApplicationParameters
).executeQuery();
  while (rs.next()) {
  // Testing
values.put(rs.getString(1), rs.getString(2));
System.out.println(rs.getString(1)+","+ 
rs.getString(2));
  }
} catch (SQLException sqle) {
  logger.error("Could not load application parameters ", 
sqle);
}
catch (Exception e){
e.printStackTrace();
}
catch (Throwable e){
e.printStackTrace();
}
/*finally {

  DBConnection.close(rs, ps);
}*/


In this code, the program gets to the executeQuery part with no exception.
When it gets to the rs.next() part, the code jumps to the finally block.
This is non-deterministic behaviour as the code seems to have thrown an
exception, but even the catch Throwable part does not catch the error.


Isn't it just likely that rs.next() returned false?


The database being connected to is a restore from another database. The fact
is this database restore could be incorrect, but how can I find the actual
error
cause of the problem. Is there a way to increase the logging so that I can
figure out the problem here.


The driver can be started given a URL connection parameter ?loglevel=2 
that will print out a fair amount of protocol information.



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [BUGS] BUG #2651: 8.2 - beta 1 does now compile with Sun Studio 11

2006-09-26 Thread Zdenek Kotala

Remy Beaumont napsal(a):

The following bug has been logged online:

Bug reference:  2651
Logged by:  Remy Beaumont
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2 - beta 1
Operating system:   Solaris 10 on T2000
Description:8.2 - beta 1 does now compile with Sun Studio 11
Details: 


When we try to compile 8.2 - beta 1 on a T2000 wth Sun Studio 11, the build
fails at the following file: 


make[5]: Entering directory
`/usr/home/remy/postgresql-8.2beta1/src/backend/utils/adt'
/opt/SUNWspro/bin/cc -Xa -xtarget=ultraT1 -fast -I../../../../src/include  
-c -o float.o float.c

"float.c", line 112: identifier redeclared: cbrt
current : static function(double) returning double
previous: function(double) returning double :
"/usr/include/iso/math_c99.h", line 126
cc: acomp failed for float.c
make[5]: *** [float.o] Error 2


The flags used for compiling are:  CC=/opt/SUNWspro/bin/cc
'CFLAGS=-xtarget=ultraT1 -fast'



The cbrt function is not part of libc. It is located in the libm. Try 
export LDFLAGS='-lm'


Zdenek

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[BUGS] BUG #2655: failed to make

2006-09-26 Thread ted Petrosky

The following bug has been logged online:

Bug reference:  2655
Logged by:  ted Petrosky
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2 beta
Operating system:   Mac OS X 10.4.7
Description:failed to make
Details: 

this is  a G4 mac mini 1.25 gigahertz
developers tools 2.4

Usage: powerpc-apple-darwin8-gcc-4.0.1 [options] file...

failed to make

gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -DFRONTEND
-I. -I../../../src/interfaces/libpq -I../../../src/bin/pg_dump
-I../../../src/include   -c -o tab-complete.o tab-complete.c
tab-complete.c: In function 'psql_completion':
tab-complete.c:574: warning: implicit declaration of function
'rl_completion_matches'
tab-complete.c:574: warning: assignment makes pointer from integer without a
cast
tab-complete.c:578: warning: assignment makes pointer from integer without a
cast
tab-complete.c:981: warning: assignment makes pointer from integer without a
cast
tab-complete.c:989: error: 'rl_filename_completion_function' undeclared
(first use in this function)
tab-complete.c:989: error: (Each undeclared identifier is reported only
once
tab-complete.c:989: error: for each function it appears in.)
tab-complete.c:989: warning: assignment makes pointer from integer without a
cast
tab-complete.c:1001: warning: assignment makes pointer from integer without
a cast

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [BUGS] BUG #2655: failed to make

2006-09-26 Thread Tom Lane
"ted Petrosky" <[EMAIL PROTECTED]> writes:
> PostgreSQL version: 8.2 beta
> Operating system:   Mac OS X 10.4.7
> Description:failed to make

It works fine for me on 10.4.7.  Which flavor of readline support are
you using (Apple's libedit or GNU readline)?  Are you sure you have
matching header and library files?  You'll need to look at configure's
results to see if it's finding the right things.

regards, tom lane

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match