[BUGS] JDBC driver DatabaseMetaData.getTables() unconditionally lowercases tableName pattern

Dave Barnett ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC driver DatabaseMetaData.getTables() unconditionally lowercases tableName pattern Long Description According to Chapter 2 of the User's Guide, NAMES may be quoted

[BUGS] no meaningful way to determine fe or be version?

Paul M. Aoki ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description no meaningful way to determine fe or be version? Long Description both the odbc and jdbc drivers seem to hardcode the database version, e.g., org/postgresql/jdbc2/Da

[BUGS] no way in LargeObject API to detect short read?

Paul M. Aoki ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description no way in LargeObject API to detect short read? Long Description org.postgresql.largeobject.LargeObject.read(byte[],int,int) returns void instead of int. there's th

[BUGS] Problems with rules

Carsten Zerbst ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problems with rules Long Description The given code is destilled from a reallife DB. All attempts to define a rule which automatically updates the column aenderung

[BUGS] NT Binary V7.0 - postgres fails start cause PG_VERSION

Elian Carsenat ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description NT Binary V7.0 - postgres fails start cause PG_VERSION Long Description NT Binary V7.0 - postgres fails to start because PG_VERSION not recognized properly (windo

[BUGS] Fail to restore index tables from pg_dumpall

jessica ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Fail to restore index tables from pg_dumpall Long Description Dear Pgsql-bugs Group, I am not sure if this is a bug or not but I really hope if any of you can help me

[BUGS] FOREIGN KEY check needs UPDATE permission

Viljar Tulit ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description FOREIGN KEY check needs UPDATE permission Long Description Lets you have 2 table. First SELECT only. Second with ALL privileges. And from second, there is REFERENCE

[BUGS] Cannot delete records

Grzegorz Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Cannot delete records Long Description I have obtained the 7.0.3 source, compiled and installed it as described in INSTALL, the database runs, but every time I try

[BUGS] Use a view as opposed to a table and it doesn't work!

Gavin Evans ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Use a view as opposed to a table and it doesn't work! Long Description If you perform the SQL below using a view to hold the avg(salary) you only get 1 row returned:

[BUGS] Bug in select with 'like' and index of two columns

Rani Pinchuk ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Bug in select with 'like' and index of two columns Long Description As you will see below - when I use index on two columns in the case below, a select with "like" d

[BUGS] Docs should clearly say that geometric types must be inserted as strings.

Michael G Schwern ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Docs should clearly say that geometric types must be inserted as strings. Long Description Its not clear in the documentation whether geometric data types are to

[BUGS] Minor typos in the Geometric Functions docs (chapter 5)

Michael G Schwern ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Minor typos in the Geometric Functions docs (chapter 5) Long Description There are a couple of minor typos in the docs for geometric functions. - the pclose(p

[BUGS] CHECK evaluation error when using more than one table

Pedro Alves ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description CHECK evaluation error when using more than one table Long Description Creating a table with the code shown, everytime I try to insert values I get the same "ERROR: E

[BUGS] Fails to add function from file with \i in psql

Roland Szabo ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Fails to add function from file with \i in psql Long Description For maintainance reasons, sql statements for our databases are saved in files, and upon installation

[BUGS] Special character pervents psql from parsing?

Roland Szabo ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Special character pervents psql from parsing? Long Description Consider the two expressions in the example code. They are almost the same, the only difference is, th

[BUGS] Both cross-named & compound foreign key constaints fail

Steffen Hulegaard ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Both cross-named & compound foreign key constaints fail Long Description This bug report is a near clone of one emailed in. I just discovered this web

[BUGS] Join Problem in Postgres 7.0.2

Khang Le ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Join Problem in Postgres 7.0.2 Long Description Database: Postgres 7.0.2 Platform: Red Hat Linux release 6.0 (Hedwig) Kernel 2.2.5-15smp on an i586 Date: 11

[BUGS] alter table rename missing numeric type

Vince Vielhaber ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description alter table rename missing numeric type Long Description I start with table n1 which contains only a numeric type 4,2. Inserting a value larger than 99.99 causes

[BUGS] \df causes an ERROR: Function oid8types(oidvector) does not exists

Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description \df causes an ERROR: Function oid8types(oidvector) does not exists Long Description When I try to use the \df function, this ERROR occurr. I use the os:

[BUGS] Outer joins in views

Grzegorz M. Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Outer joins in views Long Description In the 7.1 devel version, the OUTER JOIN statementes are working, but not in VIEWs. I have created the below listed view,

[BUGS] initdb on Alpha dies with spinlock errors

Carl Perry ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description initdb on Alpha dies with spinlock errors Long Description Compiled PostgreSQL 7.0.2 on my 21164 Alpha running SuSE 6.4 AXP. Compiled fine, but when trying to run ini

[BUGS] perl5 interface Pg.xs compile

Laurent Larquere ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description perl5 interface Pg.xs compile Long Description Not really a bug, but ... PG version 7.0.2 and 7.0.3 On Solaris 8, perl 5.6.0 : In the file src/interfaces/perl5/Pg

[BUGS] Aggregate Function (AVG) not calculated correctly

Gavin Evans ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Aggregate Function (AVG) not calculated correctly Long Description Using the following code: SELECT airline_code, AVG(distance) FROM flights GROUP BY airline_code; Th

[BUGS] createlang requires entering password 4 times

Tim Dunnington ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description createlang requires entering password 4 times Long Description When you run createlang, and you are using password authentication, you have to type in the password

[BUGS] foreign key check makes a big LOCK

Szima Gabor ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description foreign key check makes a big LOCK Long Description in: src/backend/utils/adt/ri_triggers.c RI_FKey_check(), RI_FKey_noaction_upd(), RI_FKey_noaction_del(), etc.. che

[BUGS] FreeBSD 4.2 readlib issue

Branson Matheson ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description FreeBSD 4.2 readlib issue Long Description Compiling under freebsd gives this problem: gcc -I../../include -I../../backend -O2 -m486 -pipe -Wall -Wmissing-proto

[BUGS] JDBC: connection.isClosed() doesnt throw exception

andre levy ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC: connection.isClosed() doesnt throw exception Long Description connection.isClosed() doesn't throw an SQLException if "a database access error occurs". (cf http:

[BUGS] Can't use NULL in IN conditional?

Charles Tassell ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Can't use NULL in IN conditional? Long Description I don't know if this is a "feature" that comes alogn with NULL values, or somethign I'm doing wrong, but I can'

[BUGS] Solaris ODBC - linker flag needs to be set when building shared objects

Mike McDonough ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Solaris ODBC - linker flag needs to be set when building shared objects Long Description Linker flag which needs to be set when building shared objects to prevent a

[BUGS] pqReadData() -- backend closed the channel unexpectedly

Christian HUGUES ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pqReadData() -- backend closed the channel unexpectedly Long Description I've installed the PostgreSQL 7.0.3 on a RedHat 6.1, everything was well during installa

[BUGS] Duplicate records leaking into unique indexed tables

Doug Mitchell ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Duplicate records leaking into unique indexed tables Long Description PostgreSQL 7.0.3 on RedHat 7.0 I have some fairly large (2-3 million rows) tables with a PRI

[BUGS] Outer joins aren't working with views

Grzegorz Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Outer joins aren't working with views Long Description It seems outer joins are not working at all(they work as inner joins so far). For example, see below: (the re

[BUGS] JDBC Driver Authentication Bug

Cheeren Shieh ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC Driver Authentication Bug Long Description If the userid is valid, even though null password or wrong password is sent to server with JDBC Driver, the authent

[BUGS] pg_dump fails to dump database

Mirek Hankus ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump fails to dump database Long Description pg_dump in postgreSQL 7.0.3 fails to dump database. Problem is becomeUser procedure in which lastusername stores poin

[BUGS] Backend coredump :(

Alexandr Shutko ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Backend coredump :( Long Description Well, i'm writing ICQ server - today is third day when i testing it under serious load () It work fine, but there is one prob

[BUGS] CConstraints using inherited attributes fail

Steffen Hulegaard ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description CConstraints using inherited attributes fail Long Description A previous bug entitled "Compound and cross-named foreign key constraints fail" led a most h

[BUGS] pg_dumpall doesn't handle all it should

Tomasz Krysinski ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dumpall doesn't handle all it should Long Description 1. it doesn't handle alternate data dirs (just skips the WITH LOCATION statement in CREATE DATABASE). I

[BUGS] postgresql process crashes on select * from cmd_sm (which is a view)

Cristi Posoiu ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql process crashes on select * from cmd_sm (which is a view) Long Description I have a problem with a postgreSQL view. You have the sql commands that creates

[BUGS] Problem with apostrophes in TK frontend

Hramrach ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problem with apostrophes in TK frontend Long Description I tried to enter data using pgaccess but I was unable to enter any text containing ' (apostroph). Portgres write

[BUGS] pg_dumpall -h looks up database names locally.

Scott Marlowe ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dumpall -h looks up database names locally. Long Description pg_dumpall -h should dump all the databases on a remote box, but instead appears to be looking up th

[BUGS] pg_toast_xxx table's file leak (grows indefinitely)

Ronald Tschalär ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_toast_xxx table's file leak (grows indefinitely) Long Description I'm using the CVS snapshot from Dec 26 2000 on Linux 2.2.24/glibc-2.1.3. I have a table in wh

[BUGS] Conversion errors for datetime fields

Leonardo Frittelli ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Conversion errors for datetime fields Long Description I am currently using Postgresql version 7.0.2, but I did not find any reference to this problem in your

[BUGS] update and tcl/tk

Bruno LEVEQUE ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description update and tcl/tk Long Description Sometime, when I want update data I cannot with TCL/tk but I can directly. I use Linux Slackware 7.1 kernel 2.2.16 and postgresq

[BUGS] AIX 4.3.1, 7.0.3 build annoyances: C++ comments, make all, macro problem

Travis Pouarz ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description AIX 4.3.1, 7.0.3 build annoyances: C++ comments, make all, macro problem Long Description select version(): PostgreSQL 7.0.3 on rs6000-ibm-aix4.3.1.0, compiled by xl

[BUGS] AIX 4.3.1 build, need to manually copy postgres.imp for tcl linking

Travis Pouarz ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description AIX 4.3.1 build, need to manually copy postgres.imp for tcl linking Long Description PostgreSQL 7.0.3 on rs6000-ibm-aix4.3.1.0, compiled by xlc configured --with-t

[BUGS] vacuum analyze fails with latest cvs version

Jukka Honkela ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description vacuum analyze fails with latest cvs version Long Description I have a table ('messages') of email messages (subject, sender etc..) which has a column (of type 'text

[BUGS] impossible to create a table having the same name of a sequence object

jose ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description impossible to create a table having the same name of a sequence object Long Description prova=# \d List of relations Name | Type | Owner --

[BUGS] subselects doesn't work in v7.0.3

jose ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description subselects doesn't work in v7.0.3 Long Description Version: PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2 - I'm trying the following query in a table with 19

[BUGS] Installation failure for Solaris 8 Intel

David Trusty ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Installation failure for Solaris 8 Intel Long Description Version 7.0.3 fails to build properly under Solaris 8 (intel platform). There are compile errors related to

[BUGS] JDBC Connection must be restarted after executing SQL statement that calls a PL/PGSQL function that won't compile

Jason Southern ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC Connection must be restarted after executing SQL statement that calls a PL/PGSQL function that won't compile Long Description

[BUGS] Error in Constraint Checks with PGSQL 7.03

Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Error in Constraint Checks with PGSQL 7.03 Long Description Hi, I'm experiencing this bug with Postgres 7.03 : CREATE TABLE "staff_details" ( "userid" chara

[BUGS] JDBC PreparedStatement.setMaxRows() affects other objects intantiated from this class and it's parent class

Jason Southern ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC PreparedStatement.setMaxRows() affects other objects intantiated from this class and it's parent class Long Description ==

[BUGS] Query Problem!!

Christian Gonzalez ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Query Problem!! Long Description I have problem with the GROUP BY Sample Code select name, 'user' as class from smuser union select name, 'group' as class from

[BUGS] Backend crash on query with UNION subselect

Vladimir Zamiussky ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Backend crash on query with UNION subselect Long Description There are two nearly identical tables, differ from each other by the length of corresponding field

[BUGS] Database corruption in RH 6.2/prepackaged PG

Saku Airila ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Database corruption in RH 6.2/prepackaged PG Long Description Random database corruption. The system I'm running has ~10 databases online on a single server without ot

[BUGS] Strange results with interval types computations

Laurent HERVE ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Strange results with interval types computations Long Description Look at those two queries : ez_money=> select '10/01/2000'::date+'1 month'::interval; ?column? ---

[BUGS] Silent insert lack

Luca Saccarola ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Silent insert lack Long Description 'insert' statement using a view seems to be accepted with no error message: MyDB=> insert into test_u (col1, col2) values ('1

[BUGS] delete in a trigger

Bruno LEVEQUE ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description delete in a trigger Long Description I have 2 tables and one trigger. When I delete a line in the first table, the trigger must delete a line in the second. The pro

[BUGS] Bad rights working in referential integrity?

Ing. Pavel Janousek ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Bad rights working in referential integrity? Long Description I have two tables: create table a(id serial primary key, t text); create table b(id int reference

[BUGS] ECPG, cursors and transactions

Ing. Pavel Janousek ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ECPG, cursors and transactions Long Description When I use ECPG in transactions I got some bad results - I think that this results are bug, but I'm not sure..

[BUGS] install/regression test instructions don't work.

kevin koch (kevin.koch@compaq,.com) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description install/regression test instructions don't work. Long Description When following the V7.0.3 regression test instructions after building on my Alpha Linux box, get

[BUGS] ascii() picks up sign bit past CHAR value 127

ascii() returns negative ASCII values? ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description ascii() picks up sign bit past CHAR value 127 Long Description The lack of an UNISIGNED INT1 attribute type forces those of us who need a

[BUGS] Not using indexes in WHERE clauses

Marcin Zukowski ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Not using indexes in WHERE clauses Long Description PGSQL doesn't use indexes in WHERE clauses. Tested on version 7.0.3: PostgreSQL 7.0.3 on i586-pc-linux-gnu, co

[BUGS] installation fails

Juergen Nagel ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description installation fails Long Description The error happens when it comes to point 9 in the INSTALL file: > mkdir /usr/local/pgsql/data > chown postgres /usr/local

[BUGS] inability to restore infinity values via psql or pg_restore

Thomas F. OConnell ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description inability to restore infinity values via psql or pg_restore Long Description i am currently attempting to use infinite interval values in various tables in my

[BUGS] isfinite(interval) malfunctions

Thomas F. O\'Connell ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description isfinite(interval) malfunctions Long Description for the most part, i have been impressed with postgres' ability to handle dates. unfortunately, i have run a

[BUGS] JDBC driver throws SQLException while parsing timestamp

Alexander Dietrich ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC driver throws SQLException while parsing timestamp Long Description Hi, there's a discrepancy between PreparedStatement.setTimestamp() and ResultSet.getTi

[BUGS] large objects overwriting bug

([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description large objects overwriting bug Long Description When overwriting an lo with a larger lo, the old data is not overwritten. This was supposed to be fixed in 6.5, but it happens in

[BUGS] pl/pgsql documentation

Darcy ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pl/pgsql documentation Long Description The following documentation does not apear to reflect real world use. [<>] FOR record | row IN select_clause LOOP statements END

[BUGS] Cannot drop and recreate "primary key" index

Steffen Hulegaard ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Cannot drop and recreate "primary key" index Long Description Just an FYI ... To quickly load bulk data (COPY FROM), PostgreSQL documentation suggests dropping

[BUGS] cannot index functions with multiple arguments

Scott Marlowe ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description cannot index functions with multiple arguments Long Description Postgresql version: 7.1beta2 OS: RedHat Linux 7.0 Postgresql allows indexing of functions applied to

[BUGS] JDBC ResultSet.getObject() fails for type INTERVAL

John Lemcke ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC ResultSet.getObject() fails for type INTERVAL Long Description Trying to retrieve an INTERVAL from a ResultSet causes an exception. The following output is from

[BUGS] SQL-Explorer Delphi and Access 2000/97 doesn't display tables any more

Stefan Diestelmann ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description SQL-Explorer Delphi and Access 2000/97 doesn't display tables any more Long Description I use Delphi DB-Explorer to look in my LINUX Database, therefor i use OD

[BUGS] syslog logging setup broken?

Nic Ferrier ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description syslog logging setup broken? Long Description When building from the latest (7.1 beta 4+) CVS I had a problem with syslog logging. Every time I started the postmaster

[BUGS] Large data field causes a backend crash.

Robert Bruccoleri ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Large data field causes a backend crash. Long Description In testing TOAST in PostgreSQL 7.1beta4, I was curious to see how big a field could actually be handled

[BUGS] single a suggestion

KADIR ROJAS ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description single a suggestion Long Description Hello from Panama. Working with pglib library, I discovered something, that could become a problem for the developers if they d

[BUGS] Problem displaying functions and views in 7.1b3

() reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Problem displaying functions and views in 7.1b3 Long Description BUG REPORT Version: 7.1 beta 3 Platform: SuSE Linux 7.0 Installation: Mixed; 7.0.3 & 7.1 beta parallel install Urgency: Cosmeti

[BUGS] Backend crash while indexing large strings

Stephen van Egmnond ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Backend crash while indexing large strings Long Description The attached sql crashed Postgres 7.0.2 on a debian linux system (intel), using the packages 7.0.2

[BUGS] memory leak while using cursors

Craig Schlenter ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description memory leak while using cursors Long Description Hi I'm trying to get a large result set back from a postgres 7.02 database and am bumping my head into the limita

[BUGS] PostgrSQL 70 under NT4.0 start postmaster -i & failes

Andreas Matschewsky ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PostgrSQL 70 under NT4.0 start postmaster -i & failes Long Description I've installed the Postgresql 7.0 under NT Workstation 4.0 Service-Pak 6a using cygwin

[BUGS] Server process exited with status 139

Jeremy Young ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Server process exited with status 139 Long Description (I have also emailed [EMAIL PROTECTED] - not sure if that will get through!) I am consistently getting "Server

[BUGS] PgSQL 7.1 beta 3 breaks ODBC

Josh Berkus ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PgSQL 7.1 beta 3 breaks ODBC Long Description I'm running: Postgres 7.1 beta 3 on SuSE Linux 7.0 on the server, and Windows 98 O.E. MS Access 97 SR 2a MDAC 2.5 and DC

[BUGS] bool type could be better documented

Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description bool type could be better documented Long Description The documentation in both 7.1 and 7.0.3 talks about the bool type but both fail to actually mention the name(s

[BUGS] alter table rename and ruminations on referential integrity

Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description alter table rename and ruminations on referential integrity Long Description PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2 I suspect symptoms of thi

[BUGS] bug #126, referential integrity makes big LOCK

Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description bug #126, referential integrity makes big LOCK Long Description In referral to bug #126, where someone is wondering why triggers use FOR UPDATE on data they aren't

[BUGS] Sequence increased before constraint check

David Lynn ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Sequence increased before constraint check Long Description When a table is created with a serial column and another column that has a foreign key constraint, if the f

[BUGS] Explain reports unexpected results with inheritance

David Lynn ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Explain reports unexpected results with inheritance Long Description When tab2 inherits tab1, explain in psql will always report a "Seq Scan" on tab2 even if there are

[BUGS] NOTICE: pg_setlocale()

fmatheus ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description NOTICE: pg_setlocale() Long Description Im a Debian user of postgresql version 7.0.3-4. libc6 and locales 2.2-6. (LANG=pt_BR, but problem stay with en_US) that is a unst

[BUGS] No support for int8 sized binary/hex literals

Steffen Hulegaard ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description No support for int8 sized binary/hex literals Long Description The B'111...' and X'1F...' SQL92 literal syntax is limited to int4 sized literals. Any att

[BUGS] Not able to connect to PostgreSQL in Linux!

Srini ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Not able to connect to PostgreSQL in Linux! Long Description We installed Redhat Linux 7.0 with iPlanet 4.1 web server for Linux. It is working fine. Now, we are trying to

[BUGS]

Moritz Gmelin ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Long Description Hi Postgresql developers ! I'm pretty happy with postgres, and am right now testing PSQL 7.1 for image storage and stuff. So here's my bug report.

[BUGS] pg_dump failing on LinuxPPC

Stu Coates ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description pg_dump failing on LinuxPPC Long Description pg_dump is failing (although differently from 7.0) on LinuxPPC, see example for details. Hardware: Apple Powermac G3 B&W

[BUGS] pg_dump 7.1beta4 misses a table

Tara Piorkowski ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump 7.1beta4 misses a table Long Description I noticed in attempting to dump a database I was developing that one of the tables failed to get recreated from t

[BUGS] Date calculation produces wrong output with 7.02

Mark Stosberg ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Date calculation produces wrong output with 7.02 Long Description I use Postgres nearly every day and am very appreciative of the project. I think this example wil

[BUGS] Receiving "No such file or directory" error from the database

John Puster ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Receiving "No such file or directory" error from the database Long Description While setting up the sourceforge package (which requires an installation of PostgreSQL

[BUGS] psql crashes postmaster

Krzysztof Czuma ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql crashes postmaster Long Description PostgreSQL 7.0.3, SunOS amber 5.8 Generic_108529-05 i86pc i386 i86pc gcc version 2.95.2 postmaster crashes after user try

[BUGS] psql crashes postmaster

Krzysztof Czuma ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql crashes postmaster Long Description PostgreSQL 7.0.3, SunOS amber 5.8 Generic_108529-05 i86pc i386 i86pc gcc version 2.95.2 postmaster crashes every time a u

[BUGS] JDBC packaging error in 7.0.3 with RPM

Patrice Le Gurun ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC packaging error in 7.0.3 with RPM Long Description I had recently a bug in my Java application. I got a ResultSet from a request to the DB and I had to go t

[BUGS] Intermittent Regression test failure in create_misc

Robert Hentosh ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Intermittent Regression test failure in create_misc Long Description After fetching the latest CVS yesterday. I ran the regression test several times in a row. Act

[BUGS] Date represetation bug. Some dates are incorrectly selected

Gianfranco Pesce ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Date represetation bug. Some dates are incorrectly selected Long Description Some dates are incorrectly selected from pgsql and from the C preprocessor. The same

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