[BUGS] No Postgres Bug! Heavy downloading problems...

2001-02-28 Thread pgsql-bugs
Juri Memmert ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description No Postgres Bug! Heavy downloading problems... Long Description Greetings and sorry for wasting your time with a bug report on this... but from most available mirrors

[BUGS] RPM postinstall script fails in postgresql-server-7.0.3-2.i386.rpm

2001-02-28 Thread pgsql-bugs
Mark Reibert ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description RPM postinstall script fails in postgresql-server-7.0.3-2.i386.rpm Long Description Installing postgresql-server-7.0.3-2.i386.rpm on a Red Hat 6.2 box resulted in the

[BUGS] Wrong output for 7.0.3 from NULL fields in CASE statement

2001-02-28 Thread pgsql-bugs
Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Wrong output for 7.0.3 from NULL fields in CASE statement Long Description I am getting output that doesn't make sense from a simple SQL statement. I am expecting t

[BUGS] select problem

2001-03-01 Thread pgsql-bugs
Elie Atallah ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description select problem Long Description I'm using JDBC as an interface. The select query will be dynamicly built. In some situation the query string can reach a big length

[BUGS] Timestamp field error value

2001-03-02 Thread pgsql-bugs
Fabio ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Timestamp field error value Long Description Mandrake 7.2 Postgresql 7.0.2 glibc 2.1.3-18. If you have a field type timestamp and if you try to insert this value in that fie

[BUGS] backend crashes deterministically

2001-03-02 Thread pgsql-bugs
Marinos Yannikos ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description backend crashes deterministically Long Description With the postgresql-7.0.3 port for FreeBSD, using FreeBSD 4.1.1-STABLE, the following query kills the backend:

[BUGS] polygon insert into r-tree sometimes fails

2001-03-02 Thread pgsql-bugs
Jim Stone ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description polygon insert into r-tree sometimes fails Long Description I'm always hesitant to submit a bug report--it's usually something I [did | didn't do]--but I'm beginning to

[BUGS] Possible Addition of a CREATE TABLE Warning

2001-03-03 Thread pgsql-bugs
Austin C. Brooks ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Possible Addition of a CREATE TABLE Warning Long Description The enclosed CREATE TABLE statement attempts to create a not-nullable field that is a foreign key in

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

2001-03-06 Thread pgsql-bugs
Sean Kelly ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description "select ... where field like lower('%text%')" fails Long Description I am trying to search a varchar(x) field with a query like "select ... where field like lower('%so

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

2001-03-06 Thread pgsql-bugs
Sean Kelly ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description "select ... where field like lower('%text%')" fails Long Description I am trying to search a varchar(x) field with a query like "select ... where field like lower('%so

[BUGS] Mis-firing of rules with a WHERE condition

2001-03-06 Thread pgsql-bugs
Richard Huxton ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Mis-firing of rules with a WHERE condition Long Description Jens Hartwig posted a question to pgsql-sql today (2001-03-06) regarding rules with where conditions. I

[BUGS] No error checking on bug submission form?

2001-03-06 Thread pgsql-bugs
Richard Huxton ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description No error checking on bug submission form? Long Description Just posted a bug about rules, and didn't select a severity - gave an error message "Unable to insert...

[BUGS] upgrade 7.0 -> 7.1 using pg_upgrade

2001-03-07 Thread pgsql-bugs
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

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

2001-03-07 Thread pgsql-bugs
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

[BUGS] absolute(int rownumber) method not implemented as per Sun guidlines

2001-03-08 Thread pgsql-bugs
Rahul Tyagi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description absolute(int rownumber) method not implemented as per Sun guidlines Long Description absolute(int rownumber) method of ResultSet interface (in postgresql.jar) is not

[BUGS] createStatement(int,int) of interface Statement not implemented

2001-03-08 Thread pgsql-bugs
Rahul Tyagi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description createStatement(int,int) of interface Statement not implemented Long Description createStatement(int,int) of interface Statement not implemented Sample Code No

[BUGS] Memory leak in ODBC driver

2001-03-09 Thread pgsql-bugs
Terry Carlin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Memory leak in ODBC driver Long Description As part of Great Bridge QA testing, we run the AS3AP, TPC-C, and TPC-D benchmarks using 1 to 100 users. Our benchmarking

[BUGS] PG 7.0.3SuSE7-1: /usr/include/pgsql/os.h points to nowhere

2001-03-10 Thread pgsql-bugs
Ivan Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description PG 7.0.3SuSE7-1: /usr/include/pgsql/os.h points to nowhere Long Description /usr/include/pgsql/os.h in PostgreSQL 7.0.3 packaged for SuSE 7.0 in its version -1 (versio

[BUGS] pygresql returns incorrect result with fetchone

2001-03-11 Thread pgsql-bugs
Robert Blyler ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pygresql returns incorrect result with fetchone Long Description The pgdb fetchone function always returns the first row. Interestingly it contains the correct rowc

[BUGS] Error on bug reporting page

2001-03-13 Thread pgsql-bugs
Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Error on bug reporting page Long Description Hi all, I just tried to report a bunch of bugs and got this : Warning: PostgreSQL query failed: ERROR: Tuple is too big

[BUGS] Error on bug reporting page

2001-03-13 Thread pgsql-bugs
Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Error on bug reporting page Long Description Hi all, I just tried to report a bunch of bugs and got this : Warning: PostgreSQL query failed: ERROR: Tuple is too big

[BUGS] Checking PQstatus (libpq) returns CONNECTION_OK when it is not.

2001-03-13 Thread pgsql-bugs
Philip ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Checking PQstatus (libpq) returns CONNECTION_OK when it is not. Long Description Hi I'm having problems with the PQstatus function in the libpq library. It returns CONNEC

[BUGS] Using types in an inappropriate way causes crash of backend

2001-03-15 Thread pgsql-bugs
Boris Boehlen ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Using types in an inappropriate way causes crash of backend Long Description I tried to create a type to achieve the same as the "CREATE DOMAIN" command of SQL2. Aft

[BUGS] Problem with JDBC Driver / Statement.executeQuery()

2001-03-15 Thread pgsql-bugs
Kevin Rood ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problem with JDBC Driver / Statement.executeQuery() Long Description I am using PostgreSQL and Tomcat on Red Hat Linux 7.0 to develop a database enabled webapp. The c

[BUGS] Doucumentation bug in libpq > Asynchronous Query Processing

2001-03-15 Thread pgsql-bugs
Philip ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Doucumentation bug in libpq > Asynchronous Query Processing Long Description In the online docs: http://postgresql.org/users-lounge/docs/7.0/postgres/libpq-chapter22577.ht

[BUGS] Some regression tests are failed RH7.0

2001-03-19 Thread pgsql-bugs
Martin Eichhorn ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Some regression tests are failed RH7.0 Long Description Installing Postgress on a Red Hat 7.0 Server, some regression test failed (see below). How can i fix this

[BUGS] comments on columns aren't displayed by \dd

2001-03-19 Thread pgsql-bugs
Stephen van Egmond ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description comments on columns aren't displayed by \dd Long Description Comments on columns appear to be broken. CREATE COMMENT ON COLUMN inserts stuff into the backend

[BUGS] Doc bug: libpq PQconnectPoll()

2001-03-20 Thread pgsql-bugs
Philip ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Doc bug: libpq PQconnectPoll() Long Description In the online docs: http://www.postgresql.org/users-lounge/docs/7.0/postgres/libpq-chapter.htm The PQconnectPoll function

[BUGS] Encoding problem

2001-03-21 Thread pgsql-bugs
Danny Kao ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Encoding problem Long Description I have tried "initdb --encoding=BIG5" then doing some create table and insert. As shows below,it seems loss one byte "\", and dumping

[BUGS] deferred constraints don't work correctly

2001-03-22 Thread pgsql-bugs
Robert Bihlmeyer ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description deferred constraints don't work correctly Long Description Using the example code, I get "ERROR: referential integrity violation - key in foo still referenced

[BUGS] bug with identd autentication

2001-03-22 Thread pgsql-bugs
Sébastien BLON ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description bug with identd autentication Long Description Hi The postmaster backend seems to be blocked when the identd server of the peer accepts the connection but does not

[BUGS] psql core dump on login

2001-03-22 Thread pgsql-bugs
Leandro Peracchi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql core dump on login Long Description The default pg_hba.conf file have these two entries: local trust host 127.0.0.1 255.255

[BUGS] Compile fail on 7.1b6 on cygwin with --enable-cassert

2001-03-23 Thread pgsql-bugs
stuart ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Compile fail on 7.1b6 on cygwin with --enable-cassert Long Description Postgresql-7.1beta6 uname -srm CYGWIN_98-4.10 1.1.7(0.31/3/2) i586 spec: win98SE, PIII 733MHz, 64MB H

[BUGS] return error from date_part

2001-03-23 Thread pgsql-bugs
Antonio Murillo ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description return error from date_part Long Description I've Postgres 7.02, run in Linux "RedHat 7.0 i386". When I have a specific select, only whitch this date return a erro

[BUGS] --enable-perl doesn't like Solaris

2001-03-25 Thread pgsql-bugs
Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description --enable-perl doesn't like Solaris Long Description When testing which 7.1RC1 options are working on Solaris 8 SPARC, I've come across this when using --enable-perl.

[BUGS] Python and OpenSSL don't work together

2001-03-25 Thread pgsql-bugs
Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Python and OpenSSL don't work together Long Description Hi, When testing which ./configure options work, I've just discovered that something in the ./configure proc

[BUGS] Local Host Security? All users should have passwords optionally...

2001-03-26 Thread pgsql-bugs
Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Local Host Security? All users should have passwords optionally... Long Description I wanted to add passwords to all the users on the database, including the postgres

[BUGS] Wrong formated date on the first day of the Daylight Saving time.

2001-03-27 Thread pgsql-bugs
Laurent Faillie ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Wrong formated date on the first day of the Daylight Saving time. Long Description Hi every body, I find this problem using the following configuration: $ uname -

[BUGS] pg v7.1RC1: jdbc1 fails to compile

2001-03-27 Thread pgsql-bugs
Michael Fischer v. Mollard ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg v7.1RC1: jdbc1 fails to compile Long Description When I was compiling postgresql-7.1RC1 (on a debian 2.2 with a jdk118_v3 from blackdown.org) I got

[BUGS] 7.0.3 max function

2001-03-28 Thread pgsql-bugs
Tae, KwangHo ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description 7.0.3 max function Long Description create table aaa ( aa varchar(3) ); insert into aaa values ('001'); insert into aaa values ('002'); insert into aaa values ('003')

[BUGS] Datatype SERIAL incorrectly interpreted

2001-03-28 Thread pgsql-bugs
Hubert Hafner ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Datatype SERIAL incorrectly interpreted Long Description If you create a table with more than 1 SERIAL, only for the last a sequence is created by PostgreSQL. The o

[BUGS] Option in pg_hba.conf to specify permissions and owner for the socket file

2001-03-28 Thread pgsql-bugs
Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Option in pg_hba.conf to specify permissions and owner for the socket file Long Description It would be nice to have options in the pg_hba.conf file to specify the perm

[BUGS] unix_socket_directory isn't used by all bin tools

2001-03-30 Thread pgsql-bugs
Jerome Alet ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description unix_socket_directory isn't used by all bin tools Long Description I use 7.1RC1 I've defined unix_socket_directory to be /var/lib/postgres in /var/lib/data/postgresql

[BUGS] segmentation fault in psql

2001-03-31 Thread pgsql-bugs
David George ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description segmentation fault in psql Long Description System info: Sparc Solaris 2.7 with GCC 2.95.2 I have compiled Postgresql 7.1RC1 without any problems. initdb, createuser,

[BUGS] Table constraint ordering disrupted by pg_dump

2001-04-02 Thread pgsql-bugs
Tricia Holben ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Table constraint ordering disrupted by pg_dump Long Description When running a backup/restore version of the regression tests on 7.0.3 and 7.1RCD1 the following was

[BUGS] Loosing files after backend crash

2001-04-02 Thread pgsql-bugs
Konstantin Solodovnikov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Loosing files after backend crash Long Description After a backend crash the file for my sequence cannot be found. I use PostgreSQL 7.1RC1 compiled by GCC

[BUGS] PostgreSQL 7.0.2 Date Miscalculation

2001-04-02 Thread pgsql-bugs
Jay Guerette ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PostgreSQL 7.0.2 Date Miscalculation Long Description PostgreSQL 7.0.2 The RELTIME function is miscalculating dates. (all my graphs were wrong today!) Sample Code T

[BUGS] contrib/pg_resetxlog fails to compile under Digital Unix

2001-04-03 Thread pgsql-bugs
Alessio Bragadini ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description contrib/pg_resetxlog fails to compile under Digital Unix Long Description Under Digital Unix (aka Compaq Tru64) 4.0f with cc, contrib/pg_resetxlog fails to comp

[BUGS] to_char miscalculation on April Fool's Day, the start of daylight savings

2001-04-03 Thread pgsql-bugs
straka ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description to_char miscalculation on April Fool's Day, the start of daylight savings Long Description Nip this one in the bud because knowledge of it will hinder adoption of PostgreSQ

[BUGS] PostgreSQL 7.1 and bugs with locale support

2001-04-04 Thread pgsql-bugs
Rob Gaszewski ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PostgreSQL 7.1 and bugs with locale support Long Description I've discovered bugs in locale support in PostgreSQL (encoding set to UNICODE, locale set to pl_PL). I

[BUGS] compilation error

2001-04-05 Thread pgsql-bugs
suresh ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description compilation error Long Description Hi Iam installing postgresql-7.0.3 on solaris sparc 2.7. In that machine i installed flex, gnu-make ,readline and bison i installed.But

[BUGS] inet function return untestable texts

2001-04-06 Thread pgsql-bugs
Laurent Wacrenier ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description inet function return untestable texts Long Description I'm running 7.0.3 on FreeBSD host, netmask, etc.. inet function return unusable strings : for example, ho

[BUGS] date_part returns wrong day for 1974-04-28

2001-04-09 Thread pgsql-bugs
Phil Steinke ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description date_part returns wrong day for 1974-04-28 Long Description The date_part function is returning the wrong value for the date 1974-04-28. It seems to work with other

[BUGS] Loss of significant digits on pg_dump

2001-04-10 Thread pgsql-bugs
Patricia Holben ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Loss of significant digits on pg_dump Long Description This has been noticed on 7.0.3 and all betas/releases of 7.1. When data is stored as a timestamp(see examp

[BUGS] When I install postgresql using rpm it is ok. When I compile the fonts and execute the initdb hapen a Error: unknown type 'ame'.

2001-04-10 Thread pgsql-bugs
Marcos Roberto Henker ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description When I install postgresql using rpm it is ok. When I compile the fonts and execute the initdb hapen a Error: unknown type 'ame'. Long Description initdb Thi

[BUGS] reltime with NULL fields crashes backend

2001-04-11 Thread pgsql-bugs
Dmitry Tsitelov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description reltime with NULL fields crashes backend Long Description I use expression like int4(reltime()) to get interval length in seconds. When is NULL backend crashes (

[BUGS] result of conversion to timestamp is shifted 1 minute back

2001-04-11 Thread pgsql-bugs
Tomas Dobrovolny ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description result of conversion to timestamp is shifted 1 minute back Long Description When postgresql converts string representation of date to timestamp, he make one minu

[BUGS] table data not being restored after pg_dump

2001-04-12 Thread pgsql-bugs
Patricia Holben ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description table data not being restored after pg_dump Long Description After running the regression test suite, I perform a pg_dump, drop the db, recreate the db, use "psq

[BUGS] postgresql-7.0.3.tar.gz != postgresql-7.0.3-2.src.rpm

2001-04-12 Thread pgsql-bugs
Kevin Cole ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description postgresql-7.0.3.tar.gz != postgresql-7.0.3-2.src.rpm Long Description I'm trying to use D'Arcy J.M. Cain's python interface to PostgreSQL. He told me that the file tha

[BUGS] bug in 7.0.3 related to triggers and field rename

2001-04-13 Thread pgsql-bugs
Giuseppe Sacco ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description bug in 7.0.3 related to triggers and field rename Long Description Hi, I probably found a bug in PostgreSQL 7.0.3 running on Debian GNU/Linux potato. Kernel 2.2.19

[BUGS] Homepage images do not set ALT attribute

2001-04-14 Thread pgsql-bugs
Christian Reis ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Homepage images do not set ALT attribute Long Description Well, the PostgreSQL.org homepage has a very pretty logo table at the top, which lays out very nicely in g

[BUGS] can't compile JDBC1

2001-04-14 Thread pgsql-bugs
joachim wolf ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description can't compile JDBC1 Long Description in postgresql 7.1, compiling of JDBC1 isn't possible, syntax errors in the java source (JDBC2 works): make[3]: Entering directo

[BUGS] 7.0.3 dumps aren't accessible via JDBC in 7.1

2001-04-15 Thread pgsql-bugs
Rainer Mager ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description 7.0.3 dumps aren't accessible via JDBC in 7.1 Long Description If the character '\255' exists in a 7.0.3 dump then JDBC barfs on reading this character in 7.1. Appar

[BUGS] Segmentation fault when changing view

2001-04-16 Thread pgsql-bugs
Vlad Seryakov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Segmentation fault when changing view Long Description When i dropped column quantity in view package_tree_view, recreated this view, but didn't recreated the view

[BUGS] JDBC setObject(n,obj) throws exception when obj is null

2001-04-17 Thread pgsql-bugs
Dave Cramer ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC setObject(n,obj) throws exception when obj is null Long Description The jdbc call setObject(n,obj) does not set the column to null if the object is null and the

[BUGS] What's wrong with glibc-devel-2.2

2001-04-17 Thread pgsql-bugs
YodaWu ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description What's wrong with glibc-devel-2.2 Long Description This afternoon I download postgresql-7.1.tar.gz. After I extract this tarball,enter ./configure command to config this se

[BUGS] position('' in '') returns 1 instead of 0

2001-04-18 Thread pgsql-bugs
Terry Carlin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description position('' in '') returns 1 instead of 0 Long Description While running an ODBC test suite against PostgreSQL 7.1, the test software reported that the ODBC command

[BUGS] Date Representation Bug. Timezone and update on an already posted as #208 reportbug

2001-04-20 Thread pgsql-bugs
Gianfranco Pesce ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Date Representation Bug. Timezone and update on an already posted as #208 reportbug Long Description The problem of date representation of 22/05/1977 and 28/05/19

[BUGS] wrong dump order in pg_dump for new data types

2001-04-20 Thread pgsql-bugs
Harald Bartel ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description wrong dump order in pg_dump for new data types Long Description Version: PostgreSQL 7.1 System: Debian Woody, both Linux 2.2.14 and 2.4.3 The problem occurs for new

[BUGS] grant insert for single tables does not work

2001-04-20 Thread pgsql-bugs
Harald Bartel (harald.bartel@prozentor) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description grant insert for single tables does not work Long Description Version: PostgreSQL 7.1 System: Debian Woody, both Linux 2.2.14 and 2.4.3.1 It is not possible t

[BUGS] the operator "=" does not work for some SQL queries

2001-04-20 Thread pgsql-bugs
Harald Bartel ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description the operator "=" does not work for some SQL queries Long Description Version: PostgreSQL 7.1 System: Debian Woody, both Linux 2.2.14 and 2.4.3 For some SQL queries

[BUGS] lo_import does not check type before performing an import

2001-04-20 Thread pgsql-bugs
Michael Richards ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description lo_import does not check type before performing an import Long Description lo_import within pgsql does not verify that it is reading from a file. You can import

[BUGS] SQL function lo_unlink is not documented

2001-04-20 Thread pgsql-bugs
Michael Richards ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description SQL function lo_unlink is not documented Long Description http://postgresql.readysetnet.com/users-lounge/docs/7.1/programmer/lo-funcs.html Says: There are two bu

[BUGS] lo_import does not check type before performing an import

2001-04-20 Thread pgsql-bugs
Michael Richards ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description lo_import does not check type before performing an import Long Description lo_import within pgsql does not verify that it is reading from a file. You can import

[BUGS] TCL error with rserv on Solaris

2001-04-21 Thread pgsql-bugs
Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description TCL error with rserv on Solaris Long Description Hi guys, I'm trying out the replication module in contrib/ and after installing it as per the instructions in READM

[BUGS] An statement causes postmaster to die

2001-04-22 Thread pgsql-bugs
Sean Kelly ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description An statement causes postmaster to die Long Description I am having a problem trying to run an update on my database. The SQL that causes the problem is listed below, a

[BUGS] select a.name ... union select a.name ... order by a.name fails in 7.1

2001-04-22 Thread pgsql-bugs
Palle Girgensohn ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description select a.name ... union select a.name ... order by a.name fails in 7.1 Long Description Hi! I'm not certain this is correct SQL, and I know the rewrite is easy,

[BUGS] jdbc2 fails to getDate

2001-04-22 Thread pgsql-bugs
Palle Girgensohn ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description jdbc2 fails to getDate Long Description Hi. Here's a java app that has been working well for quite som time on various postgres versions. With 7.1, it fails: j

[BUGS] Compile file if using readline-4.2 (PostGres 7.1)

2001-04-23 Thread pgsql-bugs
Laurent Faillie ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Compile file if using readline-4.2 (PostGres 7.1) Long Description Hello All, psql will not compile if using readline-4.2 because some functions has been renamed.

[BUGS] postgres.h missing

2001-04-24 Thread pgsql-bugs
Darren Cook ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description postgres.h missing Long Description include/postgres.h is no longer there. php4 tries to include it, so now fails to compile. postgres_fe.h says: * This should be t

[BUGS] 7.1 Build fails with Bash and CDPATH

2001-04-24 Thread pgsql-bugs
Mark Hollomon ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description 7.1 Build fails with Bash and CDPATH Long Description If using Bash with CDPATH set, the build of 7.1 fails with the following messages: gmake[2]: Entering director

[BUGS] incompatible return type for netmask(inet) function between 7.0.3 and 7.1

2001-04-24 Thread pgsql-bugs
Vadim Passynkov ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description incompatible return type for netmask(inet) function between 7.0.3 and 7.1 Long Description Function netmask(inet) change return type from 7.0.3 to 7.1 In 7.0.3 ret

[BUGS] pg_regress hangs on parallel test

2001-04-24 Thread pgsql-bugs
Mark Hollomon ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_regress hangs on parallel test Long Description HPUX 10.20 postgreSQL 7.1 pg_regress hangs on the second set of parallel tests. It never finishes (waited an hou

[BUGS] build of PL/Perl cannot find include files.

2001-04-24 Thread pgsql-bugs
Mark Hollomon ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description build of PL/Perl cannot find include files. Long Description HPUX 10.20 PostgreSQL 7.1 native compiler A build that includes PL/Perl fails with : gmake[1]: Enterin

[BUGS] pg7.0.2 doesnt yield match on regexps w/ many "|"

2001-04-26 Thread pgsql-bugs
Emils Klotins ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg7.0.2 doesnt yield match on regexps w/ many "|" Long Description Adding more than a very limited number of complexness to a regexp query will yield 0 rows without

[BUGS] Optimalisation options change query results

2001-04-27 Thread pgsql-bugs
Marcin Zukowski ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Optimalisation options change query results Long Description I had a problem with retrieving data when some of the multi-column index fields were NULL - it was al

[BUGS] Input/Output of byte[]-Fields with 'FF' values in LargeObject with JDBC

2001-04-27 Thread pgsql-bugs
wolfgang ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Input/Output of byte[]-Fields with 'FF' values in LargeObject with JDBC Long Description The following Java-Code don't work because of the "0xff" values in the byteField:

[BUGS] JDBC 7.0-1.2.jar has limit of 8k!

2001-04-28 Thread pgsql-bugs
Kenny GONG ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description JDBC 7.0-1.2.jar has limit of 8k! Long Description when i insert a row data more than 8k into PostgreSQL7.1, jdbc throw me a exception called "SQL statement too long."

[BUGS] DECIMAL NULL value

2001-04-29 Thread pgsql-bugs
Xavier Bergade ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description DECIMAL NULL value Long Description Version: 7.0.3 Platform: Intel 586, 512 megs RAM CREATE TABLE test (price DECIMAL(9,2)); INSERT INTO test VALUES ('NULL'); Wil

[BUGS] Inheritance of functions shows unexpected behaviour

2001-04-29 Thread pgsql-bugs
Ganesh Prasad ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Inheritance of functions shows unexpected behaviour Long Description This is an example to demonstrate a possible bug in the inheritance behaviour of the PostgreSQL

[BUGS] Postgresql is not starting

2001-04-30 Thread pgsql-bugs
martin ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Postgresql is not starting Long Description I got to upgrade my linux from 7.0 to 7.1, and since them the posgresql is not starting it's giving me an error: psql: connect

[BUGS] Date Conversion Bug

2001-04-30 Thread pgsql-bugs
Ayal Leibowitz ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Date Conversion Bug Long Description Hi, I encountered this bug in Postgres version 6.5 to 7.1 and on RedHat Linux versions 6.1 to 7.1. It's similar or even iden

[BUGS] Cygwin: postgres.exe exits with "*** recreate_mmaps_after_fork_failed" message

2001-04-30 Thread pgsql-bugs
David Polberger ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Cygwin: postgres.exe exits with "*** recreate_mmaps_after_fork_failed" message Long Description (Note that this bug might be considered a duplicate of #188). I ha

[BUGS] debug_level 0 does not stop debug messages

2001-04-30 Thread pgsql-bugs
JP ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description debug_level 0 does not stop debug messages Long Description I'm trying to silence the annoying output generated by vacuum. I've tried both command line options (-d 0, -S (with

[BUGS] Dates and times (and timestamps) don't behave as expected

2001-04-30 Thread pgsql-bugs
Bob Soeters ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Dates and times (and timestamps) don't behave as expected Long Description For the most part, I get wrong results when using timestamps and other date or time types a

[BUGS] SELECT min(id) FROM test; uses seqscan

2001-05-02 Thread pgsql-bugs
Nick Gazaloff ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description SELECT min(id) FROM test; uses seqscan Long Description SELECT min(id) FROM test; uses sequential scan even if an index on "id" exists. VACUUM ANALYZE doesn't help.

[BUGS] Error in Makefile.tcldefs

2001-05-03 Thread pgsql-bugs
Ian Harding ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Error in Makefile.tcldefs Long Description 'gmake' process blows up when it gets to compiling pl/tcl. The error message is something to the effect of "flag '-Wl,-R/u

[BUGS] error in make the example

2001-05-03 Thread pgsql-bugs
kun xie ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description error in make the example Long Description In postgresql7.1,I cann't "make" the examples(/postgresql7.1/src/test/example/),it returns something like this: undefined refe

[BUGS] error in make the example

2001-05-03 Thread pgsql-bugs
kun xie ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description error in make the example Long Description In postgresql7.1,I cann't "make" the examples(/postgresql7.1/src/test/example/),it returns something like this: undefined refe

[BUGS] Error in rounding of timestamp

2001-05-05 Thread pgsql-bugs
Alexander Bodnar ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Error in rounding of timestamp Long Description djs=# SELECT version(); version

<    1   2   3   4   5   6   7   8   9   10   >