[BUGS] Bug in select with 'like' and index of two columns

2000-11-24 Thread pgsql-bugs
Rani Pinchuk ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Bug in select with 'like' and index of two columns Long Description As you will see below - when I use index on two columns in the case below, a select with "like" d

Re: [BUGS] Bug in select with 'like' and index of two columns

2000-11-24 Thread Tom Lane
[EMAIL PROTECTED] writes: > As you will see below - when I use index on two columns in the case > below, a select with "like" doesn't work correctly. This looks like a variant of the known problems with LIKE index optimization in non-ASCII locales. What locale settings (environment variables) ar

[BUGS] installation Pb

2000-11-24 Thread RAMI ZALLOUM
Hi, I've tried to install your database and I can't run the initdb (see logfile below)> I've installed it on a compact deskpro (DPENS P5000/10.0/N4 EUROA4) platform with Red Hat Linux 6.2. Could you please help me. Best regards > Rami Zalloum ><> errorlog

[BUGS] Bug in 'bigcheckt'

2000-11-24 Thread Lou Picciano
Dear Postgres,   I think it's a bug!   The command 'make bigcheck' runs perfectly in all respects.  However, the 'sequential test geometry' test reports FAILED.   Bug?   Lou Picciano

Re: [BUGS] installation Pb

2000-11-24 Thread Peter Eisentraut
RAMI ZALLOUM writes: > I've tried to install your database and I can't run the initdb (see logfile > below)> I've installed it on a compact deskpro (DPENS P5000/10.0/N4 EUROA4) > platform with Red Hat Linux 6.2. > Could you please help me. Read the FAQ. -- Peter Eisentraut [EMAIL PROTECTE

Re: [BUGS] Bug in 'bigcheckt'

2000-11-24 Thread Tom Lane
"Lou Picciano" <[EMAIL PROTECTED]> writes: > The command 'make bigcheck' runs perfectly in all respects. However, the '= > sequential test geometry' test reports FAILED. What Postgres version? On what platform? What exactly are the differences in the geometry output (are they just low-order-di

Re: [INTERFACES] Re: [BUGS] no meaningful way to determine fe or beversion?

2000-11-24 Thread Bruce Momjian
OK, I think I understand this now. getDatabaseProductVersion() calls getVersion, which is defined in Driver.java.in as the version string from configure. It returns the version of the client jdbc code. To get the server version, you need that SELECT you suggested. Is that OK? > I think Peter

Re: [INTERFACES] Re: [BUGS] no meaningful way to determine fe or be version?

2000-11-24 Thread Bruce Momjian
Sorry, I am just now catching up to the fact that this problem was already discussed. I have gotten the patch from the URL supplied by the author, and have applied it to the CVS tree. It will appear in tomorrow's snapshot, and in 7.1. Thanks for the patch. Someone else we complaining about th

Re: [BUGS] no meaningful way to determine fe or be version?

2000-11-24 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > Yes, should we return the client or server version from the interface? > > If we return the server version, how does someone query the client version? > > sorry, yes. the client-side interfaces (DatabaseMetaData.getDriver*) > are actually fine -

Re: [INTERFACES] Re: [BUGS] no meaningful way to determine fe or beversion?

2000-11-24 Thread Bruce Momjian
Thanks. This URL was a huge help. I applied the change to the proper function. > I think Peter Mount looked at it, but there where some big changes to > the JDBC driver going on at that time. When I look at the code in CVS > now it looks nothing like what it did when I did the patch against it