[BUGS] Bug #546: un-pg_restore-able pg_dump

2001-12-31 Thread pgsql-bugs
mike south ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description un-pg_restore-able pg_dump Long Description HI, I'm trying to do a dump/restore on a database. I created the dump like this: pg_dump -u -Fc db_xref_qa >db_xref_qa.

[BUGS] Bug #547: postmaster enters infinite loop if lock file creation fails?

2002-01-01 Thread pgsql-bugs
Michael Dickerson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description postmaster enters infinite loop if lock file creation fails? Long Description I'm running PostgreSQL 7.1.1 on FreeBSD 4.4, installed from the FreeBSD ports tree.

[BUGS] Bug #548: Misleading documentation of `palloc'

2002-01-02 Thread pgsql-bugs
Holger Krug ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Misleading documentation of `palloc' Long Description In section 12.5.6 "Writing Code" of the "PostgreSQL 7.2 Programmer's Guide" the following is said: "When alloca

[BUGS] Bug #549: select table privilege in postgres allows user to create index on the table

2002-01-03 Thread pgsql-bugs
Shahid Mohammad Shamsi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description select table privilege in postgres allows user to create index on the table Long Description I created a user and assigned select privilege on a table. The

[BUGS] Bug #549: select table privilege in postgres allows user to create index on the table

2002-01-03 Thread pgsql-bugs
Shahid Mohammad Shamsi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description select table privilege in postgres allows user to create index on the table Long Description I created a user and assigned select privilege on a table. The

[BUGS] Bug #551: alter table add field serial - does not create serial field

2002-01-04 Thread pgsql-bugs
wolfgang fuertbauer ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description alter table add field serial - does not create serial field Long Description altering an existing table and adding a field from type serial via >>alter table

[BUGS] Bug #552: src/backend/catalog/README

2002-01-04 Thread pgsql-bugs
Holger Krug ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description src/backend/catalog/README Long Description src/backend/catalog/README: tuples are in fact present. That is, only the variable-length portions of a catalog tuple are

[BUGS] Bug #553: Error Vacuuming and restoring a DataBase

2002-01-04 Thread pgsql-bugs
Miguel Juan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Error Vacuuming and restoring a DataBase Long Description Hi. About two months ago I sent here a message reporting a error while vacuuming a large table (near a mill

[BUGS] Bug #554: Error vacumming and restoring

2002-01-05 Thread pgsql-bugs
Miguel Juan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Error vacumming and restoring Long Description - Original Message - From: Tom Lane <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Satu

[BUGS] Bug #555: Lock-problem via ODBC

2002-01-08 Thread pgsql-bugs
Wolfgang Fürtbauer ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Lock-problem via ODBC Long Description connecting via Access and ODBC (Driver Version 7.1.9) to an DB Version 7.1.3; in Access Tabeles are embedded; trying to

[BUGS] Bug #556: Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3

2002-01-08 Thread pgsql-bugs
Wolfgang Fürtbauer ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3 Long Description created table umsatz: fakt32=# \d umsatz Table "

[BUGS] Bug #557: triggers tablename are not rename if table are renamed.

2002-01-08 Thread pgsql-bugs
Søren laursen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description triggers tablename are not rename if table are renamed. Long Description I had a database where I during development created a new table to test a new design. On th

[BUGS] Bug #558: JDBC InputStream.read() from oid returns incorrect values for negative bytes and really messes up -1

2002-01-09 Thread pgsql-bugs
James Lynn ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC InputStream.read() from oid returns incorrect values for negative bytes and really messes up -1 Long Description Using: PostgresSQL 7.1, jdbc7.1-1.2.jar After in

[BUGS] Bug #559: MACADDR type & 00:00:00:00:00:00

2002-01-11 Thread pgsql-bugs
Michael Handler ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description MACADDR type & 00:00:00:00:00:00 Long Description postgresql version 7.1.3, compiled with gcc 2.95.2 on solaris 2.6, running on solaris 2.8. provisioning=> \d en

[BUGS] Bug #560: ODBC problem at migrating 7.0 to 7.1

2002-01-11 Thread pgsql-bugs
Sndor, Vig ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ODBC problem at migrating 7.0 to 7.1 Long Description I wrote an application (in Borland CBuilder) that uses ODBC to access a DB. First I used Psql 6.5, then 7.0 withou

[BUGS] Bug #561: typo in trigger.c

2002-01-15 Thread pgsql-bugs
Holger Krug ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description typo in trigger.c Long Description A typo in `trigger.c' causes a loop actually is not to be used as a loop, see the patch appended. Because nobody never reported th

[BUGS] Bug #562: create plpgsql language failed

2002-01-17 Thread pgsql-bugs
Mehdaoui A ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description create plpgsql language failed Long Description Version PostgreSQL v7.1.3 Kenel: Linux 2.4.2 distrib: RedHat 6.2 createlang 'plpgsql' test commande don't work with out

[BUGS] Bug #563: kernel table full

2002-01-20 Thread pgsql-bugs
Alla El Gohary ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description kernel table full Long Description i'm running FreeBSD 4.3 with posygresql7.1.3 as server ,and data server the front end applications runs on win32s clients. the l

[BUGS] Bug #564: CREATE TABLE with long table name and long serial column name can cause conflicting sequence naming

2002-01-20 Thread pgsql-bugs
Jeff Synnestvedt ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description CREATE TABLE with long table name and long serial column name can cause conflicting sequence naming Long Description When two tables are named with similiar name

[BUGS] Bug #567: no way of restricting creation of tables

2002-01-24 Thread pgsql-bugs
Holger Jakobs ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description no way of restricting creation of tables Long Description pg_hba.conf restricts or allows access to a database for a user. As soon as the user has access to the data

[BUGS] Bug #568: RULE ON SELECT with old values.

2002-01-24 Thread pgsql-bugs
Vadim Passynkov (Vadim.Passynkov) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description RULE ON SELECT with old values. Long Description # SELECT version(); version -

[BUGS] Bug #569: Strange Queries Behaviours

2002-01-29 Thread pgsql-bugs
Carlos Atencio ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Strange Queries Behaviours Long Description Hi, I've installed Postgres 7.0.3. The bug I founded was very weird. I've this query that I run in my ap

[BUGS] Bug #570: \d in psql does not show triggers

2002-02-01 Thread pgsql-bugs
Gerald Vogt ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description \d in psql does not show triggers Long Description When using \d in psql to find details of a table, occasionally triggers will not be listed although the table does

[BUGS] Bug #571: Impossible to completly support JDBC

2002-02-03 Thread pgsql-bugs
Tiago Antao ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Impossible to completly support JDBC Long Description This is in fact to report 2 problems regarding JDBC. #1: JDBC DatabaseMetaData.getImportedKeys returns a null be

[BUGS] Bug #572: Double Format

2002-02-03 Thread pgsql-bugs
Ralf Klingebeil ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Double Format Long Description With glibc 2.2 and linux-i386 MAX_DBL must be formated with 17 digits, not with 15 (C99 says 15 ?!). HUGE_VAL is infinty and not acc

[BUGS] Bug #573: fails to make darwin 5.2

2002-02-05 Thread pgsql-bugs
Tom ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description fails to make darwin 5.2 Long Description pasting output from configure and make: [localhost:/postgresql-7.1.3] tom% ./configure | tee myconfig.log loading cache ./config.cac

[BUGS] Bug #574: can not create tables that start with "Clinic"

2002-02-06 Thread pgsql-bugs
Ivan Handler ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description can not create tables that start with "Clinic" Long Description First I logged in to my Linux server (latest RH) as root and did a su -l postgres. I created a datab

[BUGS] Bug #575: Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources:

2002-02-07 Thread pgsql-bugs
Andre Blanchard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources: Long Description System Configuration - Architecture

[BUGS] Bug #576: Can not compile IRIX + GCC

2002-02-07 Thread pgsql-bugs
oota toshiya ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Can not compile IRIX + GCC Long Description /src/backend/storage/lmgr/s_lock.c line 173 .global tas \n\ is incorrect (T

[BUGS] Bug #577: incorect sort using order by

2002-02-07 Thread pgsql-bugs
Christophe RIMBAUD ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description incorect sort using order by Long Description I have a problem with the order by command. The column is in CHAR, for example : table WAPI (wapinom CHAR(6)); s

[BUGS] Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0

2002-02-08 Thread pgsql-bugs
Rainer Tammer ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description pg_dumpall from 7.1.3 can not be imported in 7.2.0 Long Description The DB dump from 7.1.3 can not be imported in 7.2.0. 1. error the user root has id 0 and the imp

[BUGS] Bug #579: Auto-VACUUM doesnt work

2002-02-10 Thread pgsql-bugs
Paul Mamin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Auto-VACUUM doesnt work Long Description I have PIII 800MHz, 128MB, HDD IDE Quantum Fibeball AS Plus 20 Gb, Slackware Linux 8.0, kernel 2.4.17, PostgreSQL 7.2b3, stand

[BUGS] Bug #582: no mapping for java.sql.Types.DECIMAL

2002-02-11 Thread pgsql-bugs
BAZIN Nicolas ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description no mapping for java.sql.Types.DECIMAL Long Description The JDBC driver does not map the java.sql.Types.DECIMAL when using the getTypeInfo() method of the connection

[BUGS] Bug #581: Sequence cannot be deleted

2002-02-11 Thread pgsql-bugs
BAZIN Nicolas ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Sequence cannot be deleted Long Description A Sequence is created automatically with the SQL command: CREATE TABLE fa_ccpsholderscpt(hsc_serial SERIAL NOT NULL ,ch

[BUGS] Bug #583: Wrong example in 7.2 Tutorial

2002-02-12 Thread pgsql-bugs
Rainer Tammer ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Wrong example in 7.2 Tutorial Long Description Wrong referentical integrity example in PostgreSQL 7.2 Tutorial Sample Code Chapter 3.3. Foreign Keys ===

[BUGS] Bug #584: postgresql will not build on Solaris with cc

2002-02-12 Thread pgsql-bugs
Andre Blanchard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql will not build on Solaris with cc Long Description This is the input to build on Solaris OS Version 5.6 5.7 5.8 (same results) Ansi C Compiler version

[BUGS] Bug #584: postgresql will not build on Solaris with cc

2002-02-12 Thread pgsql-bugs
Andre Blanchard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql will not build on Solaris with cc Long Description This is the input to build on Solaris OS Version 5.6 5.7 5.8 (same results) Ansi C Compiler version

[BUGS] Bug #584: postgresql will not build on Solaris with cc

2002-02-12 Thread pgsql-bugs
Andre Blanchard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql will not build on Solaris with cc Long Description This is the input to build on Solaris OS Version 5.6 5.7 5.8 (same results) Ansi C Compiler version

[BUGS] Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode

2002-02-13 Thread pgsql-bugs
Andre Blanchard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Postgresql will not build on HP-UX 11.0 in debug mode Long Description Greetings: This configuration: Version 7.2 of postgresql HP-UX 11.0 64 Bit Kernel lr-xr-x

[BUGS] Bug #588: Postgresql will not build on AIX; cannot locate tcl library

2002-02-13 Thread pgsql-bugs
Andre Blanchard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Postgresql will not build on AIX; cannot locate tcl library Long Description Greetings: With the following configuration: VisualAge 5.0 Compiler Resources AIX OS

[BUGS] Bug #589: JDBC KEY_SEQ in getImportedKey starts at 0

2002-02-15 Thread pgsql-bugs
David Goodenough ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC KEY_SEQ in getImportedKey starts at 0 Long Description getImportedKey from DatabaseMetaData returns a ResultSet and in that ResultSet are values with a key K

[BUGS] Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name

2002-02-15 Thread pgsql-bugs
Ruud van den Brink ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Migration to Postgres 7.2 impossible when capitals are used in database name Long Description Hello, I discovered a bug in the connect statements of postgresql

[BUGS] Bug #591: Postgres apparently not identifying users created in Caps

2002-02-16 Thread pgsql-bugs
Ricardo J. Méndez Castro ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Postgres apparently not identifying users created in Caps Long Description I'm unable to change the password for an user after creating it with some of th

[BUGS] Bug #593: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library

2002-02-18 Thread pgsql-bugs
Pertti Karppinen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library Long Description In the RPM file postgresql-odbc-7.2-1PGDG.i386.rpm there exist a link /usr/li

[BUGS] Bug #592: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library

2002-02-18 Thread pgsql-bugs
Pertti Karppinen ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library Long Description postgresql-odbc-7.2-1PGDG.i386.rpm file has a symbolic link /usr/lib/libpsqlod

[BUGS] Bug #594: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library

2002-02-18 Thread pgsql-bugs
Jouko Pynnonen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library Long Description The packet contains just a symbolic link "/usr/lib/libpsqlodbc.so" which points

[BUGS] Bug #595: No connection with jdbc since update to 7.2

2002-02-18 Thread pgsql-bugs
Norbert Pfaff ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description No connection with jdbc since update to 7.2 Long Description Exception in thread "main" Etwas ungewöhnliches ist passiert. Bitte Teilen Sie diesem Fehler mit: Exce

[BUGS] Bug #596: bind to 127.0.0.1 in pgstat.c in secure server

2002-02-19 Thread pgsql-bugs
Denis Medvedev ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description bind to 127.0.0.1 in pgstat.c in secure server Long Description I am trying to run postgresql in secure server where is only one IP available. There is no means to

[BUGS] Bug #597: ResultSet.next() throws NullPointerException

2002-02-19 Thread pgsql-bugs
Craig Brown ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ResultSet.next() throws NullPointerException Long Description When invoking the next() method on a ResultSet that has been closed a NullPointerException is thrown. I

[BUGS] Bug #598: optimizer: convert 'IN' to join

2002-02-20 Thread pgsql-bugs
piers haken ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description optimizer: convert 'IN' to join Long Description the optimizer should do better than a sequential scan with statements like: SELECT * FROM t1 WHERE t1.index IN (SELEC

[BUGS] Bug #599: ecpg does not parse correctly define and struct in the same file

2002-02-21 Thread pgsql-bugs
BAZIN Nicolas ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ecpg does not parse correctly define and struct in the same file Long Description The following example does not get pre-processed: EXEC SQL ifndef COMMERCANT; EXEC

[BUGS] Bug #600: how to run the Postgres postmaster with -i flag

2002-02-22 Thread pgsql-bugs
ANH TUAN ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description how to run the Postgres postmaster with -i flag Long Description I want to run the Postgres postmaster with -i flag.Can you show me the command?Is it "/etc/rc.d/init.d/p

[BUGS] Bug #601: libpq needs a lo_truncate() or INV_TRUNC

2002-02-22 Thread pgsql-bugs
Aaron Hillegass ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description libpq needs a lo_truncate() or INV_TRUNC Long Description I'm using the large object interface to store documents. Sometimes the documents are edited and get lar

[BUGS] Bug #602: Chinese characters query bug.

2002-02-24 Thread pgsql-bugs
Young ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Chinese characters query bug. Long Description db=> select objectid, name from state where countryOId=39 and name='xxx' order by name; (Here xxx is a Chinese stat

[BUGS] Bug #603: time() problems with PostgreSQL 7.2

2002-02-26 Thread pgsql-bugs
Ricardo Ryoiti Sugawara Junior ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description time() problems with PostgreSQL 7.2 Long Description time('now') used to work but it doesn't work anymore in PostgreSQL 7.2. Sample Code carteirinh

[BUGS] Bug #604: string join problem

2002-02-26 Thread pgsql-bugs
Erol Ozcan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description string join problem Long Description I have a major problem with string joining in sql query in Postgresql 7.1.3. It is always return null string if any of column has

[BUGS] Bug #605: timestamp(timestamp('a timestamp)) no longer works

2002-03-01 Thread pgsql-bugs
Andrew McMillan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description timestamp(timestamp('a timestamp)) no longer works Long Description In version 7.2 it seems that I can't reduntantly cast value to timestamp if it is already a t

[BUGS] We have visited your website shop.juni.gliwice.pl

2002-03-02 Thread pgsql-bugs
Title: We have visited shop.juni.gliwice.pl  

[BUGS] Bug #606: exec sql ifdef, ... incorrect parsing

2002-03-03 Thread pgsql-bugs
Nicolas BAZIN ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description exec sql ifdef, ... incorrect parsing Long Description When exec sql ifdef test; is used with the definition of a statement bloc, a premature EOF is reached: Sa

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

2002-03-04 Thread pgsql-bugs
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] Bug #608: cache lookup failed

2002-03-06 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 cache lookup failed Long Description Hi all, I have just upgraded my 1.7.3 database to 7.2, following documentation's instruction (pg_dumpall + psql < dumpfile).

[BUGS] Bug #609: CREATE TABLE with implicit index should not fail if index already exists

2002-03-07 Thread pgsql-bugs
Vladimir ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description CREATE TABLE with implicit index should not fail if index already exists Long Description When PostgreSQL tries to create implicit index during table creation and assumed

[BUGS] Bug #610: collation fails sorting because of strcoll() bug

2002-03-07 Thread pgsql-bugs
Mathias August Gruber (mgruber) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description collation fails sorting because of strcoll() bug Long Description Hi there, I was trying to migrate a MS-SQL Server database to a Postgresql platform about two years

[BUGS] Bug #611: configure script produces incorrect results under IRIX

2002-03-10 Thread pgsql-bugs
Jonathan C. Patschke ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description configure script produces incorrect results under IRIX Long Description Under IRIX (and, presumably, other commercial UNIX platforms), the configure script in

[BUGS] Bug #612: PostgreSQL 7.2 does not build according to documentation under IRIX w/ MIPSpro

2002-03-10 Thread pgsql-bugs
Jonathan C. Patschke ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PostgreSQL 7.2 does not build according to documentation under IRIX w/ MIPSpro Long Description Ignore my submission about sh-vs-bash in configure. Configure

[BUGS] Bug #613: Sequence values fall back to previously checkpointed value after crash

2002-03-11 Thread pgsql-bugs
Ben Grimm ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Sequence values fall back to previously checkpointed value after crash Long Description It's hard to decide if it's devestating or not, since the bug is only apparent wh

[BUGS] Bug #614: Incorrect parse with time function

2002-03-14 Thread pgsql-bugs
Jacek Smyda ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Incorrect parse with time function Long Description Parser error with function time (ver. 7.2). See example. Sample Code SELECT time('10:10'); Output: ERROR: parser

[BUGS] Bug #615: Bug in ilke and ~~* Sql expression

2002-03-14 Thread pgsql-bugs
Torsten Krämer ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Bug in ilke and ~~* Sql expression Long Description i tried to do a select on some columns case insensitive. some charachters like äöü.. the ilike,~~*,upper made mi

[BUGS] Bug #616: Alter table add foreign key

2002-03-15 Thread pgsql-bugs
Dirk Jacobs ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Alter table add foreign key Long Description I tried to execute following SQL alter table PRICEGROUP add FOREIGN KEY ("PARENT") REFERENCES "PRICEGROUP" ON DELETE CAS

[BUGS] Bug #617: In SQL the tableowner is not allowed

2002-03-15 Thread pgsql-bugs
Dirk Jacobs ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description In SQL the tableowner is not allowed Long Description It seems that it is not allowed to specify the tableowner in an SQL statement Sample Code No file was uploaded

[BUGS] Bug #618: Incorrect error codes

2002-03-15 Thread pgsql-bugs
Dirk Jacobs ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Incorrect error codes Long Description I tried some ODBC stuff. Here I've seen that the S result codes are not correct. Most of the time it simply return S1000 wh

[BUGS] Bug #619: Not possible to specify foreign key name

2002-03-15 Thread pgsql-bugs
Dirk Jacobs ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Not possible to specify foreign key name Long Description It is not possible to specify a foreign key name. Version 7.2 on redhat 7.2 Sample Code No file was upload

[BUGS] Bug #620: create index ... (date_part('year', d)) fails

2002-03-15 Thread pgsql-bugs
Ernst Molitor ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description create index ... (date_part('year', d)) fails Long Description IMHO, creation of an index on a part of a date field should work, but it fails due to the definition

[BUGS] Bug #621: why postgreSQL stored databases in digital filenames?

2002-03-16 Thread pgsql-bugs
daizhong ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description why postgreSQL stored databases in digital filenames? Long Description In Mysql, database files as tables is stored in alpa. filename, but why not postgresql uses digital

[BUGS] Bug #622: jdbc driver exception: failed to get datetime field from a table

2002-03-18 Thread pgsql-bugs
Zhou Hui Qing ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description jdbc driver exception: failed to get datetime field from a table Long Description platform: SuSE 7.3 , Win2000 Server + cygwin ! When I using the example 'psql' (ja

[BUGS] Bug #623: Compling 7.2 on a Tru64 V5.1 UNIX

2002-03-25 Thread pgsql-bugs
Jerry Thompson ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Compling 7.2 on a Tru64 V5.1 UNIX Long Description I am using V5.1 with gnu gcc compiler ver 2.9. I am running configure with these options: --with-perl --enable-o

[BUGS] Bug #624: case sensitivity in pg_dumpall

2002-03-26 Thread pgsql-bugs
Volker Klemann ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description case sensitivity in pg_dumpall Long Description Dear people from postgres, Don't know if I am the first where this bug appeared: While updating from 7.1.2 to 7.2 I

[BUGS] Bug #625: bytea data type problem/bug

2002-03-27 Thread pgsql-bugs
Eric Lu ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description bytea data type problem/bug Long Description Hi, It happens when I was trying to test the avalaibility of the new binary data type comes with ver 7.2. As I read from th

[BUGS] Bug #626: Query with View not returning proper results

2002-03-27 Thread pgsql-bugs
Les Hazlewood ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Query with View not returning proper results Long Description Hello, I have been trying step by step to find where my query was working, and the breaking point whe

[BUGS] Bug #627:

2002-03-28 Thread pgsql-bugs
Harish Rao ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Long Description create table t1 (f1 real); insert into t1 values(1.01); select * from t1 where f1 > 1.01; Sample Code create table t1 (f1 real); insert into t1 valu

[BUGS] Bug #628: move works incorrectly on cursors using GiST indexes

2002-04-03 Thread pgsql-bugs
Dmitry Tkach ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description move works incorrectly on cursors using GiST indexes Long Description If you declare a cursor for a query, that's using a gist index, then fetch a few rows from it,

[BUGS] Bug #629: "for ... select ... loop" repeat first 9 rows

2002-04-04 Thread pgsql-bugs
Michael V. Reztsov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description "for ... select ... loop" repeat first 9 rows Long Description Hello! Sorry for bad English. PostgreSQL 7.2, Redhat Linux 7.1 Problem: In pl/pgsql, when table

[BUGS] Bug #630: date/time storage problem: timestamp parsed incorrectly...

2002-04-08 Thread pgsql-bugs
Sean Chittenden ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description date/time storage problem: timestamp parsed incorrectly... Long Description It looks like a bad parser or defaults for time values. The example code below explai

[BUGS] Bug #631: pg_dumpall does not accept -F or -f

2002-04-10 Thread pgsql-bugs
Don Pellegrinio ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dumpall does not accept -F or -f Long Description The pg_dumpall script seems to ignore the file and format switches that are used with pg_dump. pg_dumpall al

[BUGS] Bug #632: Problem configuring postgresql

2002-04-13 Thread pgsql-bugs
Pierre ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Problem configuring postgresql Long Description Hi, I try to configure postgresql-7.2.1 on my linux slackware 8 with gcc-3.0.4, and i got this : [...] checking for tclsh.

[BUGS] Bug #633: CASE statement evaluation does not short-circut

2002-04-14 Thread pgsql-bugs
James Cole (colejatmsu.edu) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description CASE statement evaluation does not short-circut Long Description In 7.2.1, Both the WHEN and THEN clauses of a CASE statement are evaluated, even if the WHEN clause evalu

[BUGS] Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1

2002-04-17 Thread pgsql-bugs
Josh Berkus ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PG_DUMP Files do not restore on PostgreSQL 7.2.1 Long Description This bug was originally reported by Phillip Jourdan on the NOVICE list. It seems that PostgreSQL 7.2

[BUGS] Bug #635: PostgreSQL ODBC Driver BUG

2002-04-18 Thread pgsql-bugs
Daniel Peccini ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description PostgreSQL ODBC Driver BUG Long Description Hi Im using a PostgreSQL database on Slackware Linux Server. I have some reports created with Crystal Reports 8.5 on WIM

[BUGS] Bug #636: REFERENCES on Inherits Table

2002-04-19 Thread pgsql-bugs
Alban Médici ([EMAIL PROTECTED];net) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description REFERENCES on Inherits Table Long Description Some inheritances bugss are fiked but not all In the New version of postgresSQL (7.2.1) inheritance bug was fi

[BUGS] Bug #637: pltcl bug with multibyte support

2002-04-20 Thread pgsql-bugs
Yury Don ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pltcl bug with multibyte support Long Description I have a database with KOI8 encoding, many tables names and fields names contain cyrillic characters. And I have a trig

[BUGS] Bug #638: Buggy select statment with numeric

2002-04-22 Thread pgsql-bugs
Florian Steffen ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Buggy select statment with numeric Long Description A select statement with a where clause on a numeric column tested for equality against null always return empt

[BUGS] Bug #639: JDBC interface, ResultSet.getObject on with an array of char is crashing.

2002-04-22 Thread pgsql-bugs
Florian Steffen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC interface, ResultSet.getObject on with an array of char is crashing. Long Description Using the JDBC interface version 7.2, when calling ResultSet.getObject

[BUGS] Bug #640: ECPG: inserting float numbers

2002-04-22 Thread pgsql-bugs
Edward ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ECPG: inserting float numbers Long Description Inserting records with single precision real variables having small value (range 1.0e-6 or less) frequently results in error

[BUGS] Bug #641: LIBPQ Linking with the static library on the WIN32 platform fails connections with "unknown host name".

2002-04-22 Thread pgsql-bugs
Jason Erickson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description LIBPQ Linking with the static library on the WIN32 platform fails connections with "unknown host name". Long Description I was having problems connecting up to a r

[BUGS] Bug #642: Need "Alter table drop column"

2002-04-22 Thread pgsql-bugs
Richard Neill ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Need "Alter table drop column" Long Description Please can we have the option of "Alter table drop column "? Otherwise, correcting a simple mistake of setting up a

[BUGS] Bug #643: spin lock aborts in 7.0.3

2002-04-23 Thread pgsql-bugs
John Maddalozzo ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description spin lock aborts in 7.0.3 Long Description Running many backends on a 7.0.3 postgres server RedHat 6.2 PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc egcs-

[BUGS] Bug #644: Incorrect result in math operation

2002-04-24 Thread pgsql-bugs
Francisco Blay ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Incorrect result in math operation Long Description 3088.8 - (2847.64 + 241.16)=4.54747350886464e-13 It's spected to be 0.0 the result of this operation (I think) G

[BUGS] Bug #645: core dump while \df in trasaction

2002-04-24 Thread pgsql-bugs
Jean-Luc Lachance ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description core dump while \df in trasaction Long Description I get a core dump when it try: begin; truncate table r; \df Also, I would be nice to have a different prompt

[BUGS] Bug #646: Problems inserting new records

2002-04-25 Thread pgsql-bugs
Miguel Juan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problems inserting new records Long Description Hello, I have installed Postgresql server 7.2.1 on a windows XP, and the server runs well. I have done a dump from a

[BUGS] Bug #647: test

2002-04-25 Thread pgsql-bugs
test (test) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description test Long Description Sample Code No file was uploaded with this report ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaste

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