[BUGS] Bug #431: pg_dump errors on renamed primary key column names

2001-08-27 Thread pgsql-bugs
Markus Bertheau ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump errors on renamed primary key column names Long Description Sample Code test=# select version(); version

[BUGS] Bug #432: Macaddr accepts empty string

2001-08-28 Thread pgsql-bugs
Daniel Mantione ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Macaddr accepts empty string Long Description Hello, The datatype macaddr accepts empty strings as data. I think this is not correct; an empty string is no valid

[BUGS] Bug #433: JDBC PGcircle objects radius member variable is not Public

2001-08-28 Thread pgsql-bugs
Robert Harvey ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description JDBC PGcircle objects radius member variable is not Public Long Description Hi, I am using the following version of Postgresql PostgreSQL 7.1 on i686-pc-linux-gnu,

[BUGS] Bug #434: Maximun number of connections

2001-08-30 Thread pgsql-bugs
Sergio Muscat ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Maximun number of connections Long Description What is the maximum number of connections that postgresql can support? I am writing a connection pool using jdbc/tomc

[BUGS] Bug #435: Cannot connect to databases if using Capital Letters

2001-08-31 Thread pgsql-bugs
James Pattie ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Cannot connect to databases if using Capital Letters Long Description If I create a database Ex. BUGS it shows up as bugs instead of BUGS. I can drop the database by

[BUGS] Bug #437: postgresql-python rpm fails on mx dependency

2001-09-03 Thread pgsql-bugs
Robert Blyler ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql-python rpm fails on mx dependency Long Description Tried to install the postgresql-7.1.3 rpm's. posgtgresql-python fails on a dependency on mx. I've trie

[BUGS] Bug #436: backend closed the channel unexpectedly

2001-09-04 Thread pgsql-bugs
Michael Ablass ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description backend closed the channel unexpectedly Long Description Using Postgresql 7.1.3 on Redhat 7.1 and 6.2, currently we have 2 projects running. a few days the databas

[BUGS] Bug #438: New users inherit permissions from dropped users

2001-09-05 Thread pgsql-bugs
Sverre H. Huseby ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description New users inherit permissions from dropped users Long Description I discovered the following problem on my PostgreSQL 7.1.3 installation. Hopefully, you will be

[BUGS] Bug #440: trigger can not find a function

2001-09-06 Thread pgsql-bugs
arnauld michelizza ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description trigger can not find a function Long Description ERROR: CreateTrigger: function check_key() does not exist Sample Code CREATE FUNCTION check_key(varchar,varc

[BUGS] Bug #441: Index using INT8 data type is ignored

2001-09-07 Thread pgsql-bugs
Mauro Flores ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Index using INT8 data type is ignored Long Description I have some tables on my data base with index and primary keys over int8(bigint) data type columns. Postgress

[BUGS] Bug #442: output not exectly the given input

2001-09-08 Thread pgsql-bugs
Patrick Ho ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description output not exectly the given input Long Description Platform: Chinese Windows98(front end), Red hat 7.1 Chinese Version + PostgresQL 7.02 (back end) connection: ODBC

[BUGS] Bug #443: Problem with time functions.

2001-09-09 Thread pgsql-bugs
Alessandro Rossi ([EMAIL PROTECTED]>) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problem with time functions. Long Description Here is the DB and some sample entries. CREATE TABLE "timetest" ( "id" serial primary key, "timeb

[BUGS] Bug #444: create table xy as select a,b from t_a left join t_b on cond fails in PL/pgSQL

2001-09-09 Thread pgsql-bugs
Marc Balmer ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description create table xy as select a,b from t_a left join t_b on cond fails in PL/pgSQL Long Description A SQL statement "create table t2 as select a,b from t_a left join t_b o

[BUGS] Bug #445: SQLDescribeCol() returns "wrong" info

2001-09-09 Thread pgsql-bugs
Jim Dickenson ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SQLDescribeCol() returns "wrong" info Long Description Running PostgreSQL 7.0.3 on Red Hat Linux 7.1 system using gcc 2.96. When I call SQLDescribeCol() for a colum

[BUGS] Bug #446: Windows 2000 ODBC driver(7.01.0006) crashes.

2001-09-11 Thread pgsql-bugs
Mika Mäntylä ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Windows 2000 ODBC driver(7.01.0006) crashes. Long Description Using the PostgreSql in W2K through ODBC(7.01.0006) the program(psqlodbc.dll) crashes, when trying to i

[BUGS] Bug #447: lost connection to back end

2001-09-11 Thread pgsql-bugs
Terry Hughes ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description lost connection to back end Long Description If I do a select in psql with a fairly large number of rows expected to be returned , i get a message to say that the c

[BUGS] Bug #448: 7.1.3 interfaces build fail on solaris w. gcc

2001-09-11 Thread pgsql-bugs
Bob Deblier ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description 7.1.3 interfaces build fail on solaris w. gcc Long Description I've been having problems with doing a dlopen() of libpsqlodbc since version 7.1; now that I wanted to

[BUGS] Bug #449: there is a problem with foreign key

2001-09-12 Thread pgsql-bugs
yves piel ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description there is a problem with foreign key Long Description I have got a 7.1 PGSQL/PG_dump version I have a table wich references some values of another one with a foreign key

[BUGS] Bug #450: triggered data change violation on relation

2001-09-13 Thread pgsql-bugs
Sebastien Bechet ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description triggered data change violation on relation Long Description We have exactly the same problem : http://fts.postgresql.org/db/mw/msg.html?mid=1032531 Stephan Szab

[BUGS] Bug #451: Multiple Inserts where should be unique

2001-09-14 Thread pgsql-bugs
Paul Green ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Multiple Inserts where should be unique Long Description Hi, I have been having problems with my indexes and I have discussed this with people on the mailing lists an

[BUGS] Bug #452: unique indices and multi-row UPDATE problem

2001-09-15 Thread pgsql-bugs
Andrew Gerweck ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description unique indices and multi-row UPDATE problem Long Description When doing a multi-row update, unique indices seem to be recalculated in the middle of the query. Upd

[BUGS] Bug #454: result of intersect depends on order?

2001-09-17 Thread pgsql-bugs
karl s.eiringer ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description result of intersect depends on order? Long Description first at all - postgres:fabulous while concatenating queries in php there happend this strange error - it s

[BUGS] Bug #453:

2001-09-17 Thread pgsql-bugs
() reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Long Description Sample Code No file was uploaded with this report ---(end of broadcast)--- TIP 2: you can get off all lists at once with th

[BUGS] Bug #455: Broken indexes - FIXED - Was a bug in glibc-2.2.2

2001-09-19 Thread pgsql-bugs
Paul Green ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Broken indexes - FIXED - Was a bug in glibc-2.2.2 Long Description Title says it all really. This bug was crippling my database as it corrupted my indexes (allowing du

[BUGS] Bug #456: postgres dumps core in initlocalbuffer

2001-09-19 Thread pgsql-bugs
Florian Baumert ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgres dumps core in initlocalbuffer Long Description Hi, first of all: postgres normally works very well. But in one case, postgres dumps core, which prevents

[BUGS] Bug #457: foreign keys are broken

2001-09-19 Thread pgsql-bugs
Robert Forsman ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description foreign keys are broken Long Description I'm performing a transaction that has temporary violations of a referential integrity constraint which are repaired later

[BUGS] Bug #458: serial data type problem

2001-09-20 Thread pgsql-bugs
Teoh Teik Liang ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description serial data type problem Long Description I had created a table with 2 fields (transaction_code serial primary key) and (trans_desc varchar(20) not null). I foun

[BUGS] Bug #460: serial data type problem

2001-09-20 Thread pgsql-bugs
Teoh Teik Liang ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description serial data type problem Long Description I had created a table with 2 fields (transaction_code serial primary key) and (trans_desc varchar(20) not null). I foun

[BUGS] Bug #461: serial data type problem

2001-09-20 Thread pgsql-bugs
Teoh Teik Liang ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description serial data type problem Long Description I had created a table with 2 fields (transaction_code serial primary key) and (trans_desc varchar(20) not null). I foun

[BUGS] Bug #459: serial data type problem

2001-09-20 Thread pgsql-bugs
Teoh Teik Liang ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description serial data type problem Long Description I had created a table with 2 fields (transaction_code serial primary key) and (trans_desc varchar(20) not null). I foun

[BUGS] Bug #462: bug in ODBC interface in unix environment

2001-09-20 Thread pgsql-bugs
Gang Wang ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description bug in ODBC interface in unix environment Long Description When the driver parse .odbc.ini file, only space is treated as blank character. I happened use TAB, the drive

[BUGS] Bug #463: Make 'infinity' work with type 'date'

2001-09-20 Thread pgsql-bugs
Dax Kelson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Make 'infinity' work with type 'date' Long Description CREATE TABLE test ( somedate date NOT NULL DEFAULT 'infinity' ); ERROR: Unrecognized date external representation

[BUGS] Bug #464: To uKanjiv

2001-09-20 Thread pgsql-bugs
Tadanori Yokoyama ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description To uKanjiv Long Description Hello? I'm Tadanori Yokoyama live in Japan. The letter is first letter to you that I wrote.I found a bugg in PostgreSQL. If such a

[BUGS] Bug #465: Program terminates with "Broken pipe" after PQexec (...)

2001-09-21 Thread pgsql-bugs
Roland Baum, MD-SOFT ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Program terminates with "Broken pipe" after PQexec (...) Long Description A self-written program terminates after a 2nd PQexec (...). The programm makes a con

[BUGS] Bug #466: Unable to remove /root/tmp/initdb:xxxx.xxx

2001-09-21 Thread pgsql-bugs
Vladimir Georgiev ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Unable to remove /root/tmp/initdb:.xxx Long Description I've tried to follow the detailed description in INSTALL as for fresh install as long as it was poss

[BUGS] Bug #467: Can't insert a value of 0 (zero) into a Bytea type.

2001-09-23 Thread pgsql-bugs
Billy G. Allie ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Can't insert a value of 0 (zero) into a Bytea type. Long Description It does not zeem possible to insert a value of zero (0) into a bytea type. Also, using '\134'

[BUGS] Bug #468: psql field separator......

2001-09-24 Thread pgsql-bugs
Maurizio Totti ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description psql field separator.. Long Description The option for change the field separator in psql don't work (or I'm not able to use it :-). I tried whit -F ';' or -P

[BUGS] Bug #469: The 7.1.3 tar ball from main site produced an error while extracting

2001-09-27 Thread pgsql-bugs
Ralph ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description The 7.1.3 tar ball from main site produced an error while extracting Long Description Hi I download the latest code release of PostGresql from http://www.postgresql.org/ft

[BUGS] Bug #474: Index using problem

2001-10-05 Thread pgsql-bugs
JoE Olcsak ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Index using problem Long Description I have a problem when using indexes under PostgreSQL 7.1.1 ... The problem is : I have a field of table ... This is an INT4 ty

[BUGS] Bug #475: "hard coded" tk.h search

2001-10-05 Thread pgsql-bugs
Eugene Fokin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description "hard coded" tk.h search Long Description When I build postgresql (its tcl/tk tools and libraries) with different tcl/tk location, it does use this location to create

[BUGS] Bug #486: tab-complete.o: filename_completion_function reference not found when make'ing either 7.1.2 or 7.1.3 under Windows 2000

2001-10-18 Thread pgsql-bugs
Sean Dockery ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description tab-complete.o: filename_completion_function reference not found when make'ing either 7.1.2 or 7.1.3 under Windows 2000 Long Description I've been trying to install

[BUGS] Bug #487: Erroneus values of BOOLEANS

2001-10-18 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 Erroneus values of BOOLEANS Long Description I did not find a "report a bug" for the ODBC driver so I send it here: I thing it is a problem of the ODBC driver, when

[BUGS] Bug #488: Apache daemon dying on segfault from postgres

2001-10-19 Thread pgsql-bugs
Darrell Parlee ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Apache daemon dying on segfault from postgres Long Description I have stable code that runs without change from one iteration to the next. Get sporadic failures wh

[BUGS] Bug #489: pg_dump places GRANT queries before CREATE VIEW

2001-10-22 Thread pgsql-bugs
Edwin Grubbs ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump places GRANT queries before CREATE VIEW Long Description System Configuration - Architecture (example: Intel Pentium) : AMD Athl

[BUGS] Bug #490: Can't compile PostgreSQL 7.1.3 with Solaris 2.6

2001-10-23 Thread pgsql-bugs
Holger Mittewald ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Can't compile PostgreSQL 7.1.3 with Solaris 2.6 Long Description Trying to compile postgresql under solaris 2.6 configure stops claiming about an unknown symbol

[BUGS] Bug #491: ERROR: RelationClearRelation: relation using JDBC

2001-10-24 Thread pgsql-bugs
Alex Korneyev ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ERROR: RelationClearRelation: relation using JDBC Long Description Hi, I have done a little research and seems like this should have been fixed, but it is not.

[BUGS] Bug #495: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #493: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #493: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #492: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #493: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #493: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #493: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #493: corrupt pg_language_oid_index, (how to fix?)

2001-10-27 Thread pgsql-bugs
Jonathan Dugan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description corrupt pg_language_oid_index, (how to fix?) Long Description it appears that pg_language_oid_index has been corrupted in some way, I first noticed that the vacuum

[BUGS] Bug #507: Granting insert on a table does not grant update to the ralated sequence

2001-11-03 Thread pgsql-bugs
Antonis Kanavouras ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Granting insert on a table does not grant update to the ralated sequence Long Description I recently upgrated to PostgreSQL 7.1.3 from 7.0.something (I don't re

[BUGS] Bug #508: update not atomic

2001-11-03 Thread pgsql-bugs
John Havard ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description update not atomic Long Description Version tested: 7.2b1, all 7.1 Update is not atomic. This really is not a problem, unless updating a field with a unique index.

[BUGS] Bug #515: REVOKE delete set select grant to user

2001-11-14 Thread pgsql-bugs
vic ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description REVOKE delete set select grant to user Long Description create table a; grant select on a to public; revoke delete on a from sameuser; Now we have "sameuser=r" ! Sample Code

[BUGS] Bug #516: Vacuum error in psql

2001-11-16 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 Vacuum error in psql Long Description Hello, I have a problem when I ran a VACUUM on a Postgresql database, I had tried to do it a few times and the vacuum always s

[BUGS] Bug #517: TO_CHAR(timestamp, 'Day') adds extra whitespace

2001-11-20 Thread pgsql-bugs
Ashley Cambrell ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description TO_CHAR(timestamp, 'Day') adds extra whitespace Long Description Using the postgresql TO_CHAR function with Day, DAY, day, Month, MONTH or month as the text argum

[BUGS] Bug #518: SERIAL type value not seen in FOREIGN KEY

2001-11-21 Thread pgsql-bugs
Edward Grabczewski ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SERIAL type value not seen in FOREIGN KEY Long Description I have defined a table called arch_object which contains a SERIAL type. I have defined another tabl

[BUGS] Bug #519: Bug in order by clausule

2001-11-23 Thread pgsql-bugs
Sandor, Vig ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Bug in order by clausule Long Description I have made a table with a TableID called "mit_id" character(16) This column is filled as follows: row 0:

[BUGS] Bug #520: Bug in order by clausule part II

2001-11-23 Thread pgsql-bugs
Sandor, Vig ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Bug in order by clausule part II Long Description Sorry, I forgot: The select max(mit_id) from table is also wrong! (At the specified range. see below) I have made

[BUGS] Bug #473:

2001-09-28 Thread pgsql-bugs
() reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Long Description Sample Code No file was uploaded with this report ---(end of broadcast)--- TIP 2: you can get off all lists at once with th

[BUGS] Bug #470: INTERSECT fails

2001-09-27 Thread pgsql-bugs
Tamas Vincze ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description INTERSECT fails Long Description I've used INTERSECT to get the common rows in 3 simple SELECTs. If I write the query without grouping parentheses, PG reports 0 rows

[BUGS] Bug #471: [make install] problem with jdbc driver in 7.1.3

2001-09-27 Thread pgsql-bugs
Stingray ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description [make install] problem with jdbc driver in 7.1.3 Long Description While I untared all the tarballs and configure it with [--with-java] option, [make], and [make install]

[BUGS] Bug #472: Cant get source from website for 7.2

2001-09-27 Thread pgsql-bugs
Britton Wesley ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Cant get source from website for 7.2 Long Description The link ftp://ftp.postgresql.org/pub/postgresql-7.2.tar.gz is broken Sample Code No file was uploaded with

[BUGS] Bug #521: Backup - Restore Problem in VIEWs

2001-11-26 Thread pgsql-bugs
Stefan Hadjistoytchev ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Backup - Restore Problem in VIEWs Long Description 1. Tested on: OS: Red Hat 6.2 Linux, SlackWare 7.0 Linux, CygWin PostgreSQL: 7.1.3, 7.2b3 2. Base configu

[BUGS] Bug #522: Cannot Create Database

2001-11-26 Thread pgsql-bugs
Curtis Hermann ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Cannot Create Database Long Description I am on Mac OS 10.1. Every time I try to create a database I get the following error: [localhost:~] postgres% createdb cur

[BUGS] Bug #523: ERROR: fmgr_info: function 19053: cache lookup failed

2001-11-27 Thread pgsql-bugs
Kris Anderson ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ERROR: fmgr_info: function 19053: cache lookup failed Long Description pgSQL information - PostgreSQL 7.1.3 on i386--freebsd4.4, compiled by GCC 2.95.3 I've tried

[BUGS] Bug #524: Bad quoting of backslash in text arrays

2001-11-29 Thread pgsql-bugs
Ondrej Palkovsky ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Bad quoting of backslash in text arrays Long Description I'm using text arrays to store some information. Unfortunately I got some text that contained backslash.

[BUGS] Bug #525: createlang for plperl fails on Tru64 version 4.0F (v 7.1.3)

2001-11-29 Thread pgsql-bugs
Mike Beerman ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description createlang for plperl fails on Tru64 version 4.0F (v 7.1.3) Long Description We had plperl operating fine on our Compaq Tru64 4.0F system, when it was running Postgr

[BUGS] Bug #476: pg_dump error: dtoi4: integer out of range

2001-10-09 Thread pgsql-bugs
Robert Hanzlik ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description pg_dump error: dtoi4: integer out of range Long Description When dumping large database with many tables by pg_dump utility 7.1.3 on Linux or on FreeBSD (tried sev

[BUGS] Bug #477: path ?# path

2001-10-09 Thread pgsql-bugs
Curtis Barrett ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description path ?# path Long Description nothing major. the ?# (geometric intersection) operator for paths iterates over point pairs in each path testing for intersection. ho

[BUGS] Bug #478: Integer overflow in pg_dump

2001-10-11 Thread pgsql-bugs
Premysl Maly ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Integer overflow in pg_dump Long Description Talking about version pg_dump (7.1.3) Well, it fails, when dumping databases indices (while dumping comment on indexes

[BUGS] Bug #479: Backend crashes when using certain commands with SJIS encoded databases

2001-10-11 Thread pgsql-bugs
Anonymous ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Backend crashes when using certain commands with SJIS encoded databases Long Description The problem seems to occur when using databases with SJIS encoding. So far, I h

[BUGS] Bug #481: java-building ant confused with xscreenhack-ant by .configure

2001-10-14 Thread pgsql-bugs
Markus Mikkolainen ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description java-building ant confused with xscreenhack-ant by .configure Long Description when building 7.1.3 with option --with-java , the configure script found an "ant"

[BUGS] Bug #482: psql (7.1.3) doesn't like sysid=0

2001-10-15 Thread pgsql-bugs
Sherwin Daganato ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description psql (7.1.3) doesn't like sysid=0 Long Description I have migrated a production database from 7.0.3 to 7.1.3 successfully. Then I was trying to load this databas

[BUGS] Bug #483: could not copy dump files to postgres directory

2001-10-15 Thread pgsql-bugs
bipin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description could not copy dump files to postgres directory Long Description i could not copy the dump file of a database into the postgres directory.when i try to login to postgresuse

[BUGS] Bug #484: TIMESTAMP arithmetic insconsistencies

2001-10-16 Thread pgsql-bugs
Rick Mason ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description TIMESTAMP arithmetic insconsistencies Long Description I have found some inconsistencies relating to TIMESTAMP arithmetic. I am not sure if this is a bug, but perhaps

[BUGS] Bug #485: strange behavior when creting rules with serial id

2001-10-16 Thread pgsql-bugs
Tony Tomov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description strange behavior when creting rules with serial id Long Description I do not know if this is a bug, but for me this is a strange behavior. I will describe the followin

[BUGS] Bug #526: Three levels deeply nested SELECT goes wrong

2001-11-30 Thread pgsql-bugs
Maarten Fokkinga ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Three levels deeply nested SELECT goes wrong Long Description A 3 levels deeply nested SELECT with "R(a)" in the top-most FROM part and "R.a=S.a AND XXX" in the

[BUGS] Bug #527: server hangs up and refuses any connection

2001-11-30 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 server hangs up and refuses any connection Long Description dear pgsql-bugs i'm running postgresql 7.1.2 on freebsd4.3 my application consists of se

[BUGS] Bug #528: Core dump on OpenBSD 2.7 using postgresql 7.1.3

2001-12-02 Thread pgsql-bugs
Magnus Karlsson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Core dump on OpenBSD 2.7 using postgresql 7.1.3 Long Description Hi I cannot run postgresql on OpenBSD2.7 (i386).(more info further down) According to the INSTALL

[BUGS] Bug #529: UPDATE fails after an index is changed

2001-12-03 Thread pgsql-bugs
Paul Smith ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description UPDATE fails after an index is changed Long Description I had to drop and re-create an index on a table for a large insert. Then I needed to run an UPDATE on a differe

[BUGS] Bug #530: index does not work on int8

2001-12-05 Thread pgsql-bugs
hh () reports a bug with a severity of 1 The lower the number the more severe it is. Short Description index does not work on int8 Long Description creating an index on an int8 column has no effect on planner. It always chooses to do a seq scan. Sample Code No file was uploaded with this re

[BUGS] Bug #531: libpq: Operations following PQfinish() work.

2001-12-06 Thread pgsql-bugs
Anthony Chavez ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description libpq: Operations following PQfinish() work. Long Description The PGconn *conn argument to PQfinish() is not set to NULL. As a result, calling libpq functions---i

[BUGS] Bug #532: backend crashes due to segmentation fault

2001-12-08 Thread pgsql-bugs
yaniv hamo ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description backend crashes due to segmentation fault Long Description After 3 hours of trying to figure out why my backend cannot stand on its feet for more than 20 seconds, I

[BUGS] Bug #533: BLOB (lo type) objects could not be restored

2001-12-09 Thread pgsql-bugs
Stefan Hadjistoytchev ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description BLOB (lo type) objects could not be restored Long Description Hi :) Problem appeared in POSTGRESQL 7.2b3 CVS distribution After creating a table containing

[BUGS] Bug #534: factorial function

2001-12-10 Thread pgsql-bugs
Janko Richter ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description factorial function Long Description 1. The factorial function returns 0 when the argument is 0. The factorial Funtion is defined as: factorial(0)=1 2. It would be

[BUGS] Bug #535: postgreSQL v7.1.3 doesn't build properly with gcc v3.0.2 on Solaris 8

2001-12-10 Thread pgsql-bugs
Robert Berglin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description postgreSQL v7.1.3 doesn't build properly with gcc v3.0.2 on Solaris 8 Long Description I attempted a build of postgreSQL v7.1.3 on a Solaris 8 system using gcc v3.0

[BUGS] Bug #536: the sql 'except' generates erroneous result

2001-12-11 Thread pgsql-bugs
luby liao ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description the sql 'except' generates erroneous result Long Description A student of mine, Sean Canaday, worked on prob 6.17 of M Kifer's Dabatabase book (AW, p175): 6.17 Consider

[BUGS] Bug #537: In Red Hat don't open port 5432 and PostgreSql don't work.

2001-12-13 Thread pgsql-bugs
Roger ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description In Red Hat don't open port 5432 and PostgreSql don't work. Long Description Hi! I recently installing Red Hat 7.2. One of RPM were your PostgreSql. I thing that there is

[BUGS] Bug #538: Backend crasches

2001-12-14 Thread pgsql-bugs
Holubniak Piotr ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Backend crasches Long Description My system is running on Pentium II 350 with 128 MB memory, WD-SCSI linux Mandrake 6.0, kernel 2.2.9-27mdk, glibc 1.2.3 Sending

[BUGS] Bug #539: Unexpected DeadLock on REFERENCES

2001-12-14 Thread pgsql-bugs
Eugene Fokin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unexpected DeadLock on REFERENCES Long Description DeadLock happens when we're trying to concurrent update different tables which chained with one table through REFER

[BUGS] Bug #540: pg_dump a simple table can fail if other view/triggers are faulty

2001-12-16 Thread pgsql-bugs
luby liao ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump a simple table can fail if other view/triggers are faulty Long Description We use Postgresql 7.1.2 on a Redhat 7.0 Linux PC. My CS145 students all work in a da

[BUGS] Bug #541: [JDBC] DatabaseMetaData.getTables() does not return tables with rules on them

2001-12-18 Thread pgsql-bugs
Dominik Drzewiecki ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description [JDBC] DatabaseMetaData.getTables() does not return tables with rules on them Long Description When a table is created, DatabaseMetaData.getTables() finds the t

[BUGS] Bug #542: 7.1.3 will not compile/install on SCO Open Server 5.0.4/5.0.5

2001-12-18 Thread pgsql-bugs
Roger While ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description 7.1.3 will not compile/install on SCO Open Server 5.0.4/5.0.5 Long Description Firstly, "make" blows with undefined symbol "NOFILE" in "src/backend/storage/file/fd.c".

[BUGS] Bug #543: Unable to build postgres on Aix

2001-12-18 Thread pgsql-bugs
Francisco Leovey ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Unable to build postgres on Aix Long Description I have tried many ways to build Postgres on Aix, but all failed with different problems. Is there a binary relea

[BUGS] Bug #544: Upgrade to 7.1 - sequence permissions not restored

2001-12-19 Thread pgsql-bugs
John Bradshaw ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Upgrade to 7.1 - sequence permissions not restored Long Description Permissions on sequences are not restored when upgrading to 7.1 Got a write error stating that I

[BUGS] Bug #545: Keyword USER not detected in CREATE VIEW

2001-12-28 Thread pgsql-bugs
Avi Kivity ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Keyword USER not detected in CREATE VIEW Long Description The reserved keyword USER is rejected in CREATE TABLE, as expected: avi=> create table x (user varchar);

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