Re: [BUGS] BUG #1141: jdbc-ant-script does not support java version

2004-04-26 Thread Kris Jurka
On Sun, 25 Apr 2004, PostgreSQL Bugs List wrote: > Description:jdbc-ant-script does not support java version 1.5 > > The ant-script build.xml tries to find out which Java version is used during > the installation of the database and uses this information to generate > Drivers for jdbc

Re: [ADMIN] How configure Oracle 9i not case sensitive...

2004-04-26 Thread Hans Forbrich
Eloy Mier Pérez wrote: > How can i do this ? Not possible. Oracle works upper-case only for dictionary unless using "". Many have found this to be "a good thing", others think it's a limitation. Not worth debating! Best you learn to code to the documented limits, or switch. /Hans Please d

Re: [ADMIN] How configure Oracle 9i not case sensitive...

2004-04-26 Thread Ross Ferris
Better still, why not switch to D3 you can make files (tables) case insensitive if you want - you can even selectively make the data case insensitive, which can be "useful" for searches oh, if you are using the "embedded tables" feature of 9i, the whole concept of storing multi-values was

[DOCS] How configure Oracle 9i not case sensitive...

2004-04-26 Thread Eloy Mier Pérez
Hi, i would configure Oracle 9i not case sensitive and in the table names dont use ""... How can i do this ? Thanks in advance ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] Problem when truncate table and get the OID from PQftable

2004-04-26 Thread Rodrigo Moreno
Hi After truncate the table, the oid retuned by PQftable/libpq returns the old value, and i'm not able to find it in pg_class, because the value of pg_class.relfilenode was changed after the truncate. The problem is only solved if i drop the table and re-creating again. Regards Rodrigo Moreno

[BUGS] make check regression "test stats" failed

2004-04-26 Thread Mike Quinn
Postgresql Version 7.4.2 Slackware 9.1 kernel 2.4.26 I did: ./configure make make check Here is the regression.diffs file: *** ./expected/stats.outFri Oct 31 19:18:20 2003 --- ./results/stats.out Wed Apr 21 09:41:57 2004 *** *** 62,68 WHERE st.relname='tenk2' AND cl.

[BUGS] postgresql idle

2004-04-26 Thread Jon Pastore
I have a strange error.   when I do a ps aux I get:   postgres 15018  0.0  0.6  9192 7396 ?    S    09:20   0:00 /usr/bin/perl /www/nexum/cgi-bin/accounting/posting/automatic_postingpostgres 15019  0.0  0.3 25696 4176 ?    S    09:20   0:00 postgres: postgres nexum [local]: idle

[BUGS] SIGSEGV is reproducible in cygwin, but not elsewhere; where do I report this bug?

2004-04-26 Thread Walker, Philip M (Utility Data Center)
Has anyone seen the following problem?, it's a show-stopper ... I can generate this fault with the following command line: $ psql -f pgbug.sql Here's a backtrace of the problem: [EMAIL PROTECTED]:/usr/src/postgresql-7.4.1-3 $ gdb postgres.exe 3492 GNU gdb 2003-09-20-cvs (cygwin-special) Copyrig

[BUGS] Regression test fails on Solaris 9 for 7.4.2

2004-04-26 Thread Nishad Prakash
I've compiled and regression-tested 7.4.2 on Solaris 8 without trouble. But I'm having some issues with the same release on Solaris 9. It won't compile with gcc (3.0.4). Config.log tells me: configure:7204: gcc -c -O2 -fno-strict-aliasing -I/usr/local/include conftest.c >&5 In file included

Re: [BUGS] How configure Oracle 9i not case sensitive...

2004-04-26 Thread sybrandb
"Eloy Mier Pérez" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > Hi, i would configure Oracle 9i not case sensitive and in the table names > dont use ""... > > How can i do this ? > > Thanks in advance You can't Stick to sqlserver. Sybrand Bakker Senior Oracle DBA

Re: [BUGS] Postgres DB

2004-04-26 Thread Sumita Biswas
Hi All, Our application is using the Postgres 7.3.4-RH database that is packaged with the AS3.0 for CCM. There is a variable type called refcursor that is being used by CAR Functions in Postgres database. This variable works fine when we execute the postgres Function from the database i.e through

[BUGS] INITDB-error - end-of-copy marker error

2004-04-26 Thread JC Jan Christensen
Dear Sirs I have a problem with INITDB After having compiled postgresql 7.4.2 against cygserver ( ./configure, make, make install ) I get the following error-message from INITDB : creating system viewsok loading pg_description...ERROR: end-of-copy marker does