[BUGS] Bug #755: Error on create a new sequence by using the create table command.

2002-09-03 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 Error on create a new sequence by using the create table command. Long Description In postgresql 7.1 and 7.2.1: Then using a statement like: CREATE TABLE longtablen

[BUGS] Bug #756: suggestion: file with password instead of $PGPASSWORD

2002-09-04 Thread pgsql-bugs
Wojciech Scigala ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description suggestion: file with password instead of $PGPASSWORD Long Description This is not a bug-report in fact, but a suggestion of a feature. (I couldn't find an separa

[BUGS] Bug #757: ODBC Doesn works

2002-09-04 Thread pgsql-bugs
Lazaro ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ODBC Doesn works Long Description I have Postgresql 7.2.2 in a red hat 7.3 machine. I'm programming in a PowerBuilder 8.0 in a windows 2000 machine, I have a PSQLODBC-07-0

[BUGS] Bug #758: show_planner_stats does not work for new PREPARE calls

2002-09-05 Thread pgsql-bugs
Barry Lind ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description show_planner_stats does not work for new PREPARE calls Long Description I was testing the 7.3 PREPARE functionality. I was using the timing information from show_pars

[BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-06 Thread pgsql-bugs
Tim Knowles ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM Long Description Hi, Been playing with the 7.3beta1 version and I've noticed a small problem with dependency checking when dr

[BUGS] Bug #760: to_date

2002-09-06 Thread pgsql-bugs
Swaminathan.K ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description to_date Long Description I have created a table with a datetime datatype. Using to_date function I am unable to format the date and I am unable to get the time sepe

[BUGS] Bug #761: Date format ambiguity while insertion!!!!

2002-09-09 Thread pgsql-bugs
Shubhankar Dasgupta ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Date format ambiguity while insertion Long Description I am using Postgres 7.2.2 on Redhat Linux 7.2 My datestyle settings have been set as "ISO US(non eu

[BUGS] Bug #762: copy table from '/home/postgres/import' using delimiters ',' errors on first line.

2002-09-09 Thread pgsql-bugs
Jeff Post ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description copy table from '/home/postgres/import' using delimiters ',' errors on first line. Long Description When I attempt to populate an empty table using copy from (specifical

[BUGS] Bug #763: PgLargeObject Class

2002-09-11 Thread pgsql-bugs
Randy L. Pearson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description PgLargeObject Class Long Description The definition of PgLargeObject currently declares all data members as private Problem: When attempting to read an existing

[BUGS] Bug #764: 7.3b1 : SET gives misleading error information with non-valid option name and multiple arguments

2002-09-12 Thread pgsql-bugs
Tim Knowles ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description 7.3b1 : SET gives misleading error information with non-valid option name and multiple arguments Long Description PostgrsqSQL 7.3b1 If you use SET with a non-valid o

[BUGS] Bug #771: rewrite rules on update or insert do not report errors

2002-09-17 Thread pgsql-bugs
marc persuy ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description rewrite rules on update or insert do not report errors Long Description If you try to use rules to implement update and insert on views, these rules do not report any

[BUGS] Bug #772: Rewriting on multi-record updates is unreliable

2002-09-18 Thread pgsql-bugs
Anto Prijosoesilo ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Rewriting on multi-record updates is unreliable Long Description Using RULEs to push values up a hierarchy of relations fail to work correctly when multiple rec

[BUGS] Bug #774: Sometimes we do not get the correct record set

2002-09-19 Thread pgsql-bugs
Michelle ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Sometimes we do not get the correct record set Long Description We did a select statement to select a recordset from the database and the recordset size differs. For ex

[BUGS] Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'

2002-09-19 Thread pgsql-bugs
Daniel Serodio ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unable to identify an operator '=' for types 'numeric' and 'double precision' Long Description If I create a table with a 'numeric' column, and try to make a query

[BUGS] Bug #776: PGSQL 7.2.2 build broken on OS X 10.2

2002-09-19 Thread pgsql-bugs
Lee Nelson ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PGSQL 7.2.2 build broken on OS X 10.2 Long Description Postgresql 7.2.2 does not build on Mac OS X 10.2 . Worked perfectly on OS X 10.1.4. Developer disk (GCC, etc

[BUGS] Bug #777: postgresql desconectado (not connect)

2002-09-20 Thread pgsql-bugs
José Alberto Torres ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql desconectado (not connect) Long Description I'm not English. I'm Spanish, please... Tenemos un servidor postgresql con la version 7.1 y cuando se p

[BUGS] Bug #778: pg_dump crashes when dumping a view

2002-09-20 Thread pgsql-bugs
g triggers for table parent_element pg_dump: query to obtain definition of view "parent_body_view" failed: ERROR: phony_equal: unexpected node type 721 pg_dump: *** aborted because of error Please do copy your messages about this bug to my e-mail - I am not currently subscribed to pgsql-b

[BUGS] Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend

2002-09-23 Thread pgsql-bugs
Vadim Passynkov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description query 'SELECT '{1,2}' *= NULL' crash backend Long Description SELECT version(); version -

[BUGS] Bug #780: Timestamp shifted by one minute

2002-09-26 Thread pgsql-bugs
gmake install gmake install-all-headers This bug appears similar to: http://archives.postgresql.org/pgsql-bugs/2001-04/msg00072.php I have another similar setup which works perfectly: the binary was built with the same source tree and options, however the differences between the two setu

[BUGS] Bug #781: Broken Indices in 7.3 Beta

2002-09-26 Thread pgsql-bugs
Christoph Nelles ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Broken Indices in 7.3 Beta Long Description Hello everybody! I am currently using 7.3 Beta (my data is not so important ;)) and it breaks frequently one index d

[BUGS] Bug #782: clog files disappear after 'vacuum;'

2002-09-26 Thread pgsql-bugs
Steven Wilton ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description clog files disappear after 'vacuum;' Long Description We are having a problem with our pg_clog files disappearing after a vacuum command is run. We have a database

[BUGS] Bug #783: WINDOWS 2000: invalid primary checkpoint record

2002-09-26 Thread pgsql-bugs
Le Quang Anh Ngoc ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description WINDOWS 2000: invalid primary checkpoint record Long Description Hello, I'm using Windows 2000, PostgreSQL 7.2.1-win32. While System was be running, the power w

[BUGS] Bug #784: DROP 7.3b1 - DOMIAN CASCADE can leave a table with no columns

2002-09-27 Thread pgsql-bugs
Tim Knowles ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description DROP 7.3b1 - DOMIAN CASCADE can leave a table with no columns Long Description Hello, I've posted this a few times but my email has been playing up a bit - blame Brit

[BUGS] Bug #785: 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT

2002-09-27 Thread pgsql-bugs
Tim Knowles ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT Long Description I don't know if this is intended behaviour but as the 7.3 devel docs a

[BUGS] Bug #786: simbols in relation names

2002-09-27 Thread pgsql-bugs
Andrew Shubas ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description simbols in relation names Long Description Good afternoon! We use chars as ':' ,or '=' ,or similar in the relations - views - names. Problem is that in the psql do

[BUGS] Bug #787: Backup Files Output Constraints Before Functions

2002-09-27 Thread pgsql-bugs
David Wheeler ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Backup Files Output Constraints Before Functions Long Description Bricolage has a table with a constraint that uses a custom function. The code to build it is funct

[BUGS] Bug #788: configure script confused by gcc-3.2

2002-09-28 Thread pgsql-bugs
Richard Lightman ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description configure script confused by gcc-3.2 Long Description The configure script tries to get gcc's version number into confdefs.h gcc-3.0.* outputs one line of text, b

[BUGS] Bug #789: Transaction Archival Logging -- Hot Backups

2002-09-28 Thread pgsql-bugs
Jon Watte ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Transaction Archival Logging -- Hot Backups Long Description I see no mention of transaction archival logging in the documentation. This means that, even though you sup

[BUGS] Bug #790: Optimizer does not want to use an index for large table

2002-09-29 Thread pgsql-bugs
Jekabs Andrushaitis ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Optimizer does not want to use an index for large table Long Description I have a table with large number of records (10). Data from this table is mostly

[BUGS] Bug #791: Error when inserting timestamp 2002-10-13 00:00:00

2002-09-30 Thread pgsql-bugs
Jéfferson R. Zuchi ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Error when inserting timestamp 2002-10-13 00:00:00 Long Description When I try to insert in a field of the type timestamp value 2002-10-13 00:00:00 occurs t

[BUGS] Bug #792: pg_dump uses all available RAM and swap

2002-10-01 Thread pgsql-bugs
Steve Riley ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump uses all available RAM and swap Long Description We noticed that doing a pg_dump was taking longer and longer to perform when doing data backup. For this and

[BUGS] Bug #793: ODBC driver does not compile on Sun Solaris

2002-10-01 Thread pgsql-bugs
Renney Thomas ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ODBC driver does not compile on Sun Solaris Long Description towards the end of the compile of the unixODBC driver I get naming conflict error. Also what is the par

[BUGS] Bug #794: JDBC 7.3 PreparedStatement.setNull(..) .setObject(.., null) throws exception

2002-10-08 Thread pgsql-bugs
Olaf Liepelt ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description JDBC 7.3 PreparedStatement.setNull(..) .setObject(.., null) throws exception Long Description I'm using your JDBC driver 7.3 beta 1 (tested the developer one as well)

[BUGS] Bug #795: null resulting from left join corrupts select

2002-10-10 Thread pgsql-bugs
karsten merkle ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description null resulting from left join corrupts select Long Description Version: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96 Error: equal in where clause fa

[BUGS] Bug #796: Problem after upgrading to v. 723

2002-10-12 Thread pgsql-bugs
Michael Brusser ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Problem after upgrading to v. 723 Long Description After upgrading from v. 721 to 723 some of regression tests failed. (We're running on Solaris) Looking into pro

[BUGS] Bug #797: Inaccurate in PostgreSQL 7.3b2 Developer's Guide

2002-10-15 Thread pgsql-bugs
Piotr Kuczynski ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Inaccurate in PostgreSQL 7.3b2 Developer's Guide Long Description There is small inaccurate in the "PostgreSQL 7.3b2 Developer's Guide": [Chapter 10. Native Langu

[BUGS] Bug #798: Data in table causes server to terminate with signal 11

2002-10-16 Thread pgsql-bugs
Dan Wilder ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Data in table causes server to terminate with signal 11 Long Description I have a table which brings about the error message (from syslog) server process (pid 21503)

[BUGS] Bug #803: Problem with timestamp conversion

2002-10-23 Thread pgsql-bugs
Osmar Junior Klock ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problem with timestamp conversion Long Description I tried SELECT * FROM Noticia WHERE data >= CURRENT_DATE - 10 and returns: Unable to convert data to tm. Howe

[BUGS] Bug #799: configure does not check for -lodbcinst

2002-10-18 Thread pgsql-bugs
Steven Taschuk ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description configure does not check for -lodbcinst Long Description When configure is run with ./configure --enable-odbc --with-unixodbc it does not verify that -lodbcinst

[BUGS] Bug #800: Bad free in function PQclear

2002-10-18 Thread pgsql-bugs
Yvan Maillet ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Bad free in function PQclear Long Description I use the libc library with the version 7.0.2-17. I send a query with bad function. The server answer me an error with

[BUGS] Bug #801: now() in transaction

2002-10-18 Thread pgsql-bugs
Bhuvan A ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description now() in transaction Long Description I am using 7.2.1. now() returns same value ever, within transaction. If we use now() say 10 times in the same transaction, all 10 ti

[BUGS] Bug #802: Can't short hungarian database with PostgreSQL on Debian/Woody

2002-10-22 Thread pgsql-bugs
Lajos Barf ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Can't short hungarian database with PostgreSQL on Debian/Woody Long Description Dear Developers! I want to use PostgreSQL with Hungarian national location and character

[BUGS] Bug #804: plpgsql not work on solaris

2002-10-24 Thread pgsql-bugs
Claudio Mannucci ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description plpgsql not work on solaris Long Description I try to create language plpgsql for db "template1" on solaris 9 but don't work. It's seems that all other work, but i

[BUGS] Bug #806: create function failing... ERROR: stat failed on file '

2002-10-28 Thread pgsql-bugs
Lynn Tilby ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description create function failing... ERROR: stat failed on file ' Long Description DEBUG: ProcessUtility: create function dys_btwn_dates ( date , date ) returns int as '

[BUGS] Bug #807: Sequence currupted on recovery after kill -9

2002-10-29 Thread pgsql-bugs
Matt Thompson ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Sequence currupted on recovery after kill -9 Long Description If you create a file with an implied sequence and do a couple of inserts, then do a kill -9, when you s

[BUGS] Bug #808: bison dies with max table size fatal error

2002-10-30 Thread pgsql-bugs
Dave Bartmess ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description bison dies with max table size fatal error Long Description I downloaded the source, ran configure with --with-java option, then ran make. The error coming back is:

[BUGS] Bug #809: View not using index

2002-10-31 Thread pgsql-bugs
Philip Warner ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description View not using index Long Description It seems that a UNION view fails to use underlying table indexes. This is a major pain when using subclassed tables which are u

[BUGS] Bug #810: Fail to compile with perl 5.8.0

2002-11-04 Thread pgsql-bugs
Magnus Enbom ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Fail to compile with perl 5.8.0 Long Description When using configure --with-perl with perl 5.8.0, plperl fails to compile due to unknowns. This is because perl-5.8 i

[BUGS] Bug #811: Using || with char and char varying

2002-11-07 Thread pgsql-bugs
John Lim ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Using || with char and char varying Long Description The following sql: select firstname||lastname from adoxyz; generates this error: PostgreSQL said: ERROR: Unable t

[BUGS] Bug #812: can not compile 7.3b5 on Suse8.1 with perl

2002-11-10 Thread pgsql-bugs
Christoph Becker ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description can not compile 7.3b5 on Suse8.1 with perl Long Description Can not compile (make) Postgresql 7.3b5 on Suse 8.1 if the option --with-perl is used with configure.

[BUGS] Bug #813: postmaster not running

2002-11-11 Thread pgsql-bugs
sampathraghavan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description postmaster not running Long Description The Posgresql 7.1 Suddenly the /etc/init.d/posgresql script is not starting it always reporst fialure. I want to know the

[BUGS] Bug #814: ArrayIndexOutOfBoundsException with extended character data

2002-11-12 Thread pgsql-bugs
Michael Brown ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ArrayIndexOutOfBoundsException with extended character data Long Description I get an exception when reading data (using DbVisualizer 3.1) when reading data from a t

[BUGS] Bug #815: after trigger not working in begin-commit block (no bug)

2002-11-12 Thread pgsql-bugs
Jonah Safar (jsafar.at.vfocus.com) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description after trigger not working in begin-commit block (no bug) Long Description This is to retract my bug report from Sep 30th, 2000 by the above name. A workaround to i

[BUGS] Bug #816: Bad time conversion from type abstime to datetime

2002-11-13 Thread pgsql-bugs
Paul Mamin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Bad time conversion from type abstime to datetime Long Description After making query (in psql): select '2002-11-12 15:02:05'::abstime::datetime; timestamp ---

[BUGS] Bug #817: Valid timezone +1300 rejected

2002-11-13 Thread pgsql-bugs
MI ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Valid timezone +1300 rejected Long Description New Zealand Daylight Savings Time time zone is "+1300" (and others as well, I think). Silly, I agree, but that's how it is. Postg

[BUGS] Bug #818: There are no aggregate functions for type RELTIME

2002-11-14 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 There are no aggregate functions for type RELTIME Long Description create table a (b reltime); insert into a values ('00:02:00'); select sum(b) from a; sum - 120

[BUGS] Bug #819:

2002-11-16 Thread pgsql-bugs
so sakol ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Long Description I want to know more about Mysql server, how can i know ? Sample Code No file was uploaded with this report ---(end of broadc

[BUGS] Bug #820: RULE on INSERT unable to access NEW serial value anymore

2002-11-18 Thread pgsql-bugs
Kristofer Munn ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description RULE on INSERT unable to access NEW serial value anymore Long Description Enclosed is example code that behaves differently on versions 7.1.3 and 7.2.3 with a loss

[BUGS] Bug #821: bug when using between or <= on varchar fields

2002-11-19 Thread pgsql-bugs
Thomas Piszczek ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description bug when using between or <= on varchar fields Long Description I just recognized that when using between or <= and >= on varchar fields postgresql behaves quite s

[BUGS] Bug #822: Condition on rule is not respected.

2002-11-23 Thread pgsql-bugs
Luís Mota ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Condition on rule is not respected. Long Description I think I spoted a bug while developing a database. To better understand if this was really a bug, I developed a sma

[BUGS] Bug #823: upper() does not handle å, ä and ö correctly.

2002-11-26 Thread pgsql-bugs
Marcus Andersson ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description upper() does not handle å, ä and ö correctly. Long Description The function upper() just leaves the letters å, ä, and ö unmodified. It should replace them with Å,

[BUGS] Bug #824: Problem creating data base !!

2002-11-28 Thread pgsql-bugs
Christian Gonzalez ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Problem creating data base !! Long Description Recently i tried to create a data base via SSH with an user allowed to do it, but it displays the following messa

[BUGS] Bug #824: Problem creating data base !!

2002-11-28 Thread pgsql-bugs
Christian Gonzalez ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Problem creating data base !! Long Description Recently i tried to create a data base via SSH with an user allowed to do it, but it displays the following messa

[BUGS] Bug #826: opaque->internal translation required for 7.2 dumps

2002-12-01 Thread pgsql-bugs
Philip Warner ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description opaque->internal translation required for 7.2 dumps Long Description Dumping from 7.2 using 7.3 gives: CREATE FUNCTION postgis_gist_sel (opaque, oid, opaque, integer

[BUGS] Bug #827: pg_dump in 7.3 can't dump 7.1 db

2002-12-01 Thread pgsql-bugs
Philip Warner ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump in 7.3 can't dump 7.1 db Long Description Whenevr dumping a 7.1 db using 7.3 pg_dump, I get: pg_dump: last built-in OID is 18539 pg_dump: saving database def

[BUGS] Bug #828: psql in 7.3 can't talk to 7.1 backends

2002-12-01 Thread pgsql-bugs
Philip Warner ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description psql in 7.3 can't talk to 7.1 backends Long Description acheron:/home/pjw/work/postgresql-7.3/src/bin/pg_dump # /var/lib/pgsql-7.3/bin/psql -p 5432 pjw ERROR: parse

[BUGS] Bug #829: 7.3 crashes when trying to set variable to default

2002-12-01 Thread pgsql-bugs
Dustin Sallings ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description 7.3 crashes when trying to set variable to default Long Description Logged in as dustin (superuser), I did the following: alter user nobody set search_path to [som

[BUGS] Bug #830: 7.3 - timespan missing?

2002-12-01 Thread pgsql-bugs
Dustin Sallings ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description 7.3 - timespan missing? Long Description I couldn't find any documentation on timespan other than saying it should be preferred over reltime, however I use timespa

[BUGS] Bug #831: RFE - Schema list from psql

2002-12-01 Thread pgsql-bugs
Dustin Sallings ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description RFE - Schema list from psql Long Description psql should have a \d type builtin to list schemas in the current database. Sample Code select ns.nspname as

[BUGS] Bug #832: delete rule reports 0 modifications

2002-12-01 Thread pgsql-bugs
Dustin Sallings ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description delete rule reports 0 modifications Long Description I have a table that has a delete rule that performs a logical delete (set a ``deleted'' column to true) whenev

[BUGS] Bug #833: prep_buildtree and solaris ln

2002-12-02 Thread pgsql-bugs
Nathan Mueller ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description prep_buildtree and solaris ln Long Description The linking command in config/prep_buildtree doesn't work with /usr/ucb/ln on solaris. If line 36 is changed from:

[BUGS] Bug #834: not usage index in subquerys o inner joins

2002-12-03 Thread pgsql-bugs
Gabriel Monsalvo ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description not usage index in subquerys o inner joins Long Description PostgreSQL makes sequencial scans when uses subqueries or inner joins like: select * from ctacte where

[BUGS] Bug #835: round(double precision,integer) function in 7.3 does not work

2002-12-04 Thread pgsql-bugs
Eugene von Niederhausern ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description round(double precision,integer) function in 7.3 does not work Long Description round(double precision,integer) does not work with 7.3. This function did w

[BUGS] Bug #836: Deadlock during insert w/o autocommit

2002-12-04 Thread pgsql-bugs
Alexander Kirpa ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Deadlock during insert w/o autocommit Long Description Deadlock during insert w/o autocommit in 2 tables with check to table3. Environment Postgres 7.2.3(cygwin) &

[BUGS] Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding

2002-12-05 Thread pgsql-bugs
Steve Haslam ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unable to use LATIN9 (=ISO-8859-15) encoding Long Description I am trying to use LATIN9 (ISO-8859-15) as my client encoding rather than LATIN1-- the database I am usi

[BUGS] Bug #838: SSL problems in 7.3

2002-12-05 Thread pgsql-bugs
Nathan Mueller ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SSL problems in 7.3 Long Description In 7.3 if a client exists without disconnecting from the database the backend dumps core. This wouldn't be so bad except that

[BUGS] Bug #839: triggers do not execute in right order in procedures

2002-12-05 Thread pgsql-bugs
Eugene Gridasov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description triggers do not execute in right order in procedures Long Description The constraint trigger on delete executes ONLY after procedure completion, but it does not exe

[BUGS] Bug #840: Query with null string

2002-12-06 Thread pgsql-bugs
Stéphane Bérubé ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Query with null string Long Description When I do a query (SELECT or INSERT) with null vars (see example) I get warnings from php: Warning: pg_query() query faile

[BUGS] Bug #841: SET search_path in createdb -T ... and pgdump

2002-12-09 Thread pgsql-bugs
Przemyslaw Sztoch ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description SET search_path in createdb -T ... and pgdump Long Description Database variable is not dumped in pg_dump. Database variable is not copied by cratedb with -T para

[BUGS] Bug #842: pgplsql: IF-THEN-ELSIF-ELSE acts different from IF-THEN-ELSE IF

2002-12-09 Thread pgsql-bugs
Jørn Cornelius Olsen ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description pgplsql: IF-THEN-ELSIF-ELSE acts different from IF-THEN-ELSE IF Long Description 1) The 'boolean-expression' after 'ELSIF' always evaluates to FALSE. According

[BUGS] Bug #843: pg_clog files problem

2002-12-10 Thread pgsql-bugs
Nikolay Hristov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description pg_clog files problem Long Description I am running PostgreSQL 7.2.1 distributed with cygwin on Windows NT4 SP6. The data directory is on NTFS drive. I performed t

[BUGS] Bug #844: initdb fails on an ext2/3 fs mounted on /var/lib/pgsql/data

2002-12-10 Thread pgsql-bugs
JMM ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description initdb fails on an ext2/3 fs mounted on /var/lib/pgsql/data Long Description If a whole filesystem (eg a whole disk in one filesystem that is dedicated to postgres data) is mo

[BUGS] Bug #845: JDBC driver have a problem with floating-point numbers

2002-12-11 Thread pgsql-bugs
Maxim A. Karavaev ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description JDBC driver have a problem with floating-point numbers Long Description I found a problem for defining a floating-point numbers in PreparedStatement class. I use

[BUGS] Bug #846: Oncurrent transactions about select for update

2002-12-12 Thread pgsql-bugs
zeng yubo ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Oncurrent transactions about select for update Long Description Two concurrent transactions control by "select for update", they can shared the data with insert ?

[BUGS] Bug #847: plpgsql 'raise notice' > 4000 chars disconnects pgsql backend 7.2.1

2002-12-12 Thread pgsql-bugs
stephen dee (ala_frosty@yaho#nospam#o.com) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description plpgsql 'raise notice' > 4000 chars disconnects pgsql backend 7.2.1 Long Description Try this: It will cause you (et al) to get disconnected from the back e

[BUGS] Bug #848: Index on bigint column is unused in selects

2002-12-14 Thread pgsql-bugs
Peter Roozemaal ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Index on bigint column is unused in selects Long Description PostgreSQL 7.2 will allways do a full table scan when the index field is a bigint. even with a "where

[BUGS] Bug #849: pg_restore bug on views with union, PostgreSQL 7.2.3

2002-12-17 Thread pgsql-bugs
Dariusz Knociñski ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_restore bug on views with union, PostgreSQL 7.2.3 Long Description I have problem with restoring views with union and without attribute names in select, withou

[BUGS] Bug #849: pg_restore bug on views with union, PostgreSQL 7.2.3

2002-12-17 Thread pgsql-bugs
Dariusz Knociñski ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_restore bug on views with union, PostgreSQL 7.2.3 Long Description I have problem with restoring views with union and without attribute names in select, withou

[BUGS] Bug #851: cast() no longer works in array inserts

2002-12-18 Thread pgsql-bugs
Malcolm Tredinnick ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description cast() no longer works in array inserts Long Description If I have a table containing an array (e.g. a bigint[] field), then it does not appear to be possible t

[BUGS] Bug #852: Wrong sequence name generated

2002-12-20 Thread pgsql-bugs
Andras Balogh ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Wrong sequence name generated Long Description When i create the following table: CREATE TABLE groups_events ( group_event_id serial, event_id integer NOT NU

[BUGS] Bug #853: Software unavailable on any US mirror

2002-12-20 Thread pgsql-bugs
Glenn Horton-Smith ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Software unavailable on any US mirror Long Description This is not a bug with PostgreSQL as such, but a major annoyance in that it seems to be impossible to get

[BUGS] Bug #854: configure file and tcl/tk

2002-12-24 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 configure file and tcl/tk Long Description I have succesfully run configure and gmake with no arguments. All works ok but of course i can't get pgaccess I added the

[BUGS] Bug #855: pg_dump crash on linux-xfs

2002-12-24 Thread pgsql-bugs
Ruslan V Lopation ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump crash on linux-xfs Long Description pg_dump crashes with PostgreSQL 7.3(1) server installed on Linux-2.4.20(2.4.19) with XFS patches from ftp://oss.sgi

[BUGS] Bug #856: coredump

2002-12-25 Thread pgsql-bugs
Mike Pechkin ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description coredump Long Description $ psql Welcome to psql 7.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL comman

[BUGS] Bug #857: [7.3] Attribute oid not found in a temporary table creted by a SELECT

2002-12-25 Thread pgsql-bugs
jmm ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description [7.3] Attribute oid not found in a temporary table creted by a SELECT Long Description I ran on a problem today while running a SQL script that used to perfectly run from 7.0.2

[BUGS] Bug #858: bitfromint4 not present in 7.3.1

2002-12-26 Thread pgsql-bugs
Andrew Goldsmith ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description bitfromint4 not present in 7.3.1 Long Description I have installed a copy of PostgreSQL 7.3.1 from src on my Debian/Linux system. The bitfromint4 function is no

[BUGS] Bug #859: 7.3.1 on linux-alpha: 3 "make check" tests fail

2002-12-26 Thread pgsql-bugs
ttn ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description 7.3.1 on linux-alpha: 3 "make check" tests fail Long Description platform (uname -a): Linux alphasql 2.4.18-rc2 #2 Wed Feb 20 02:49:42 EST 2002 alpha unknown gcc --version: 2.

[BUGS] Bug #860: [7.3.x] pg_config --configure not readily usable

2002-12-27 Thread pgsql-bugs
jmm ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description [7.3.x] pg_config --configure not readily usable Long Description The use of quotes in pg_config --configure makes it not longer usable as ./configure argument Example: jmma@

[BUGS] Download Eminem-Shaggy'S Mp3s 01.01.2003 17:16:11

2003-01-01 Thread pgsql-bugs
! Hello Webmasters ! www.Netlist.net has Opened ! So Join Our toplist and increase your traffic for free. You wont need to open pop-up ! Because we have a dinamic counter looks like: Click That logo and come to our site. Than Add Your site to the correct Category.. We Accep All Kind

[BUGS] Bug #861: postgresql fails to build on FreeBSD/sparc64

2003-01-01 Thread pgsql-bugs
Roderick van Domburg ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql fails to build on FreeBSD/sparc64 Long Description Building postgresql from ports on a sparc64 fails with the following error message. Both postgr

<    3   4   5   6   7   8   9   10   >