Re: [BUGS] Indexes not always used after inserts/updates/vacuum

Hi, On Fri, 1 Mar 2002 at 09:37, Tom Lane wrote: > Reinhard Max <[EMAIL PROTECTED]> writes: > > > I'll tell my colleague (it's his test database, after all) that he > > should take more realistic test data before complaining about bad > > performance... > > Actually, is it unrealistic test data?

[BUGS] cannot install postgresql 7.2

Hello pgsql-bugs, I cannot install postgresql-7.2 on my Debian Linux I have downloaded postgresql-7.2.tar.gz from http://www.ca.postgresql.org/ftpsite/v7.2/postgresql-7.2.tar.gz and try to install on Debian linux 2.2 release 5 Here is all info about system, that was get by the command "

[BUGS] Segmentation Fault

Hi Sidney, Cool. Really glad to hear you got it working! Could you email the PostgreSQL "General" mailing list with that info? It might need to be added to an FAQ or something. :-) Regards and best wishes, Justin Clift Sidney wrote: > > Hi Justin, > I was using gcc 2.95.1, >

Re: [BUGS] Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com

Follow up: PGv7.2 still suffers from the Seg. Fault on exit problem reported below on that system. However, Ran the new v7.2 on a new machine with the following config: Architecture (example: Intel Pentium): Sun sparc, Ultra-2 Operating System (example: Linux 2.0.26 E

[BUGS] Bug #607: to_date() function bug

Nurlan Mukhanov ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description to_date() function bug Long Description otdyh=# select to_date(20020200,'MMDD'); to_date 2002-02-01 must be 2002-01-31 !! Why??? 00 hours 0

[BUGS] Incorrect PostgreSQL 7.2 ODBC RPM for RedHat 6.2

I am attempting to install PostgreSQL 7.2 on Redhat 6.2. It looks like the RPM are not installing the actual ODBC library. When I query the RPM for the actual files in the RPM, I get the following: [root@steveark rpms]# rpm -qpl postgresql-odbc-7.2-1PGDG.i386.rpm /usr/lib/libpsqlodbc.so /usr

[BUGS] BUG: bigint and indexes ?

Is it a known bug if optimizer, that Postgres can't use indexes created on a int8 (bigint) ? This problem exists in 7.1.3 and even in 7.2.     test=# CREATE TABLE parent_child (test(# parent_id int8 NOT NULL,test(# parent_type int4 NOT NULL,test(# child_id int8 NOT

[BUGS] RSERV AND POSTGRESQL 7.2

Hello everyone,   pgsql 7.2 compiles fine with LinuxPPC 2000, but Rserv compiles fine but doesn't work. When i try for example a MasterInit blabla... it says " stat failed at /rserv " no such file or directory.   so, i had to back to 7.1.3 which works fine.   Any Suggestions ?   Thanks   F

[BUGS] postmaster problem....

I'm using postgres as an backend with java servlet/jsp using linux as operating system but when i see the see the CPU process using TOP command than what i found that postmaster is using 97% of CPU which raise my system speed very slow. so could u pls help me to sort out my problem that how can

[BUGS] Encoding Problem?

Hi! pgsql 7.2, Linux 2.0.35. procedure to reproduce incorrect result: (1) either initdb -E EUC_TW or initdb -E MULE_INTERNAL (2)createdb database1 (3) psql database1 (4) create table test (f1 charchar(255) primary key); (5) insert into test values('¦¨¥\'); (6) insert into test values('³\'); E

[BUGS] about catalogue tables bugs?

Hi I have two databases and every thing work well , but this morning i don't have any database in pg_database .and when i want to see my tables there is no tables even structure and data is here in /base. How can i resolve this problem ? can i insert structure of my databases in pg_database ?

Re: [BUGS] BUG: bigint and indexes ?

On Fri, 1 Mar 2002, Victor Krasinsky wrote: > Is it a known bug if optimizer, that Postgres can't use indexes created on a int8 >(bigint) ? > This problem exists in 7.1.3 and even in 7.2. You need to explicitly cast the constant that you're comparing to bigint (1::bigint or CAST(1 as bigint)).

Re: [BUGS] Bug #607: to_date() function bug

[EMAIL PROTECTED] writes: > otdyh=# select to_date(20020200,'MMDD'); > to_date > > 2002-02-01 > must be 2002-01-31 !! > 00 day - is the last day of the previous month! I don't think so. If anything, this should raise an error. regards, tom lane --

Re: [BUGS] Encoding Problem?

> pgsql 7.2, Linux 2.0.35. > > procedure to reproduce incorrect result: > > (1) > either > initdb -E EUC_TW > or > initdb -E MULE_INTERNAL > > (2)createdb database1 > (3) psql database1 > (4) create table test (f1 charchar(255) primary key); > (5) insert into test values('¦¨¥\'); > (6) insert i

Re: [BUGS] postmaster problem....

Hi Nitesh, You need to tune your PostgreSQL system to more efficiently allocate memory buffers, etc. http://techdocs.postgresql.org has pointer and documents on how to do this. Regards and best wishes, Justin Clift On Thursday 28 February 2002 17:25, Nitesh wrote: > I'm using postgres as an