Re: [BUGS] (ver. 7.4) select netmask('192.168.1.5/24') return '255.255.255.0/24'

2003-12-09 Thread Gaetano Mendola
saint wrote: (ver. 7.4) select netmask('192.168.1.5/24') return '255.255.255.0/24' not '255.255.255.0' (example in docs) (ver. 7.3) return '255.255.255.0' Fixed on 7.4.1 Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is you

Re: [BUGS] java.lang.NullPointerException - at

2003-12-09 Thread Kris Jurka
On Mon, 8 Dec 2003, Dhaval Bhagat wrote: > >Hi! > > > >We are experiencing problems on a live application and are getting intermittent > >errors. The stack trace is as follows. As the system is live, this is urgent. > > > >java.lang.NullPointerException > > at o

Re: [BUGS] decode function

2003-12-09 Thread Peter Eisentraut
gerard manvu wrote: > I don't know if it is really a bug or a missuse of postgresql but > when I issue the following request select decode(encode('µ'::bytea, > 'escape'), 'escape'); > , the result is \346, not 'µ'. That's the same thing. bytea stores bytes, not characters, so we expect that you a

[BUGS] decode function

2003-12-09 Thread gerard manvu
Hi I don't know if it is really a bug or a missuse of postgresql but when I issue the following request select decode(encode('µ'::bytea, 'escape'), 'escape'); , the result is \346, not 'µ'. Any help or a forum link ? Thanks in advance Gerard. PS: PostGreSQL 7.4, Red Hat 8, Base under SQL_ASCII or

[BUGS] java.lang.NullPointerException - at org.postgresql.Connection.ExecSQL(Connection.java:312)

2003-12-09 Thread Dhaval Bhagat
>Hi! > >We are experiencing problems on a live application and are getting intermittent >errors. The stack trace is as follows. As the system is live, this is urgent. > >java.lang.NullPointerException > at org.postgresql.Connection.ExecSQL(Connection.java:312)

Re: [BUGS] Failed regression test in postgresql-7.4

2003-12-09 Thread LANE WILLIAM HOY
Thanks, Bruce. I have a 7.3.4 install in my current path when running the regression tests. I will try rebuilding and retesting with a modified path. Lane Hoy [EMAIL PROTECTED] On Sat, 6 Dec 2003, Bruce Momjian wrote: > [EMAIL PROTECTED] wrote: > > /usr/local/src/postgresql-7.4/src/test/regres

[BUGS] Unintended shutdown in postgres 7.4

2003-12-09 Thread Chad N. Tindel
Let me just say that I love all the work that has been done for postgres 7.4. The information_schema is totally cool! We've been seeing a problem where the database server will shutdown unexpectedly. This generally happens when we are in the middle of importing a large dump in .sql format from a

[BUGS] postmaster.pid in version 7.4

2003-12-09 Thread Dario Marini
My postmaster.pid is something like: 23479 /export/home1/staff/marini/pgsql/data 5432001 11703 I don't know if there is something wrong with my installation (I run postgresql on Ultra-2 station with Solaris 6), for sure I cannot stop postgrsql server using: kill `cat /usr/local/pgsql/data/

[BUGS] (ver. 7.4) select netmask('192.168.1.5/24') return '255.255.255.0/24' not '255.255.255.0' (example in docs)

2003-12-09 Thread saint
(ver. 7.4) select netmask('192.168.1.5/24') return '255.255.255.0/24' not '255.255.255.0' (example in docs) (ver. 7.3) return '255.255.255.0' ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [BUGS] Error compiling PostgreSQL 7.4 for Fedora Core 1

2003-12-09 Thread Tom Lane
Jonathan Gardner <[EMAIL PROTECTED]> writes: > Unfortunately, in testing the bugger, it accidentally worked. I find this > most disturbing. However, I was pleasantly surprised that it failed at > least one more time before working properly. Weird; there's no obvious reason for the script to be n

Re: [BUGS] BUG #1003: postgres config error

2003-12-09 Thread Neil Conway
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > I have installed the Postgres by the procedure by. it got installed > at /usr/local/pgsql/bin but, when i re-start the system. the > postgres service starts from /usr/bin. > > what shall i do i have tried it by editing the > /etc/rc.d/inid.d /

[BUGS] BUG #1003: postgres config error

2003-12-09 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1003 Logged by: hemachandra Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3 Operating system: Red Hat8.0 Description:postgres config error Details: I have installed the Postgres by the procedure by.

Re: [BUGS] Error compiling PostgreSQL 7.4 for Fedora Core 1

2003-12-09 Thread Joe Conway
Tom Lane wrote: We could fall back in that direction if we had to. But I'd like to understand why we have to, first. Gen_fmgrtab.sh has worked on all our supported platforms for a long time, and I'm disinclined to assume that it's suddenly broken ... especially on what's presumably a modern platf

Re: [BUGS] Error compiling PostgreSQL 7.4 for Fedora Core 1

2003-12-09 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 08 December 2003 9:33 pm, Tom Lane wrote: > In the absence of any brilliant insight, I'd suggest slogging through > Gen_fmgrtab.sh to try to narrow down where functions are getting lost > --- add code to save the various intermediate files, a