Re: [BUGS] seq scan on a table whereas an index exist

Nicolas GIMMILLARO <[EMAIL PROTECTED]> writes: > What's wrong with my "select * from web_access where date between > '01/01/2001' and '06/03/2001' " query ? Nothing. The planner is estimating that this query will retrieve a sufficiently large fraction of the rows in the table that a seqscan wil

Re: [BUGS] Pbm with aggregates on empty output

Jean-Francois Rabasse <[EMAIL PROTECTED]> writes: >=> select sum(1) from thetable where thevalue > 1; >pqReadData() -- backend closed the channel unexpectedly. Strange ... but rather than spend any time debugging 6.5.3, I'd suggest updating to 7.0.3. We've fixed an awful lot of bugs

Re: [BUGS] COBOL

Jarom Hagen <[EMAIL PROTECTED]> writes: > /usr/local/bin/install -c -m 555 postgres /usr/local/pgsql/bin/postgres > You must have a COBOL system present to install this product Weird. It looks like you have some exceedingly nonstandard program in /usr/local/bin/install --- certainly not what con

Re: [BUGS] "select ... where field like lower('%text%')" fails

It was doing exactly what the query told it to do. I believe if you rewrite your query like this, you will get the desired results. select ... where lower(field) like '%sometext%' Be sure to build an index on lower(field) otherwise you will resort to sequence scans. Sean Kelly wrote: >

Re: [BUGS] Pbm with aggregates on empty output

Jean-Francois Rabasse writes: > (I use PostgreSQL 6.5.3 on i686-pc-linux-gnu): Time to upgrade. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://

Re: [BUGS] Using libpq to access a repote database from a c triggerfunction breaks.

Tom Lane writes: > [EMAIL PROTECTED] writes: > > Using libpq to access a repote database from a c trigger function breaks. > > Try linking libpq.a into your .so file. I think your references to > PQexec and so forth are being resolved to the > similarly-named-but-completely-different functions t

[BUGS] Pbm with aggregates on empty output

Hello, I found a problem. I don't know if it's a bug or a misuse from me. Here is, in a minimal test version (I use PostgreSQL 6.5.3 on i686-pc-linux-gnu): 1. A table, even very simple => create table thetable ( thevalue int4 ); 2. I populate the table with several numeric values... => i

[BUGS] Table restriction problems

Pgsql Staff, Ive been using PostgreSQL 7.0.3 since about the time it came out. Im very happy with it. Cheers! But im writting to ask about a problem ive noticed. Any user with access to a database on my system that isnt the owner still has the ability to create tables (and possibly functions, vie

[BUGS] COBOL

Why do I get a message about COBOL when doing a gmake install and what am I supposed to do about it? This is on a Solaris 2.7 system. Thanks, Jarom P.S. The make was successful. gmake[3]: `SUBSYS.o' is up to date. gmake[3]: Leaving directory `/data/postgresql-7.0.3/src/backend/utils/time' gm

[BUGS] "select ... where field like lower('%text%')" fails

Hello, I was trying to send the following bug report from the web page but it kept timing out. I hope this is the only time it arrives on the list... I am trying to search a varchar(x) field with a query like: select ... where field like lower('%someText%')

[BUGS] seq scan on a table whereas an index exist

I don't understand the query plan used to resolve this query : select * from web_access where date between '01/01/2001' and '06/03/2001' The web_access table as this structure : Table "web_access" Attribute | Type | Modifier ---+--+-- source| va

Re: [BUGS] Using libpq to access a repote database from a c trigger function breaks.

[EMAIL PROTECTED] writes: > Using libpq to access a repote database from a c trigger function breaks. Try linking libpq.a into your .so file. I think your references to PQexec and so forth are being resolved to the similarly-named-but-completely-different functions that exist in the backend (see

[BUGS] Using libpq to access a repote database from a c trigger function breaks.

Andrew Fritz ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Using libpq to access a repote database from a c trigger function breaks. Long Description The database is running on x86 (PenIII-650,256meg). The 7.0.2 source was co

Re: [BUGS] upgrade 7.0 -> 7.1 using pg_upgrade

This is not a bug. pg_upgrade is not compatible with 7.1 and is not included in the source tree. You will need to do a full dump and restore. If your database also contains large objects, you will need to use pg_dumplo_old from the 7.1 source tree to export 7.0 large objects. Then use pg_dumpl

[BUGS] upgrade 7.0 -> 7.1 using pg_upgrade

AR ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description upgrade 7.0 -> 7.1 using pg_upgrade Long Description Can't upgrade from 7.0 to 7.1 using pg_upgrade script. In script is used data/base/template1 directory to do sth, but in 7