[BUGS] Bug #307 resolved (concerned timestamp problems)

Bob Soeters ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Bug #307 resolved (concerned timestamp problems) Long Description I was experiencing timestamp problems using versions of PostgreSQL below 7.1 (I've been using 6.5 &

[BUGS] Alter table add column ignores default

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 add column ignores default Long Description Alter table add column ignores the default values in both v7.0x and 7.1. In the example code the table is

[BUGS] Big problems with query optimization

Dmitriy A. Anipko ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Big problems with query optimization Long Description I use a 7.0 release running under SunOS on SPARC. I found that there is no real way to perform queries to s

[BUGS] The ignored "_" character

Laszlo Kohl ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description The ignored "_" character Long Description Hi, I am Laszlo from Hungary. I have some problem with PostgreSQL. Environment: PostgreSQL version: 7.0.3 Server OS: RedH

[BUGS] interval( 'seconds 27960' ) is broken

elein ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description interval( 'seconds 27960' ) is broken Long Description In 7.0.3, I'm converting seconds from midnight to a time of day using interval ( 'seconds '). This worked fine in 7.

[BUGS] PostgreSQL 7.1.1: Backend crash when calling plpgsql function

([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PostgreSQL 7.1.1: Backend crash when calling plpgsql function Long Description Hi, while porting a 6.5 app to 7.1.1 i found a plpgsql function that crashes the backend. Other fu

[BUGS] Another plpgsql crash

([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Another plpgsql crash Long Description Ok, just found another one: The function crashes, when the corresponding user is not found. This one just looks too common, so i guess i m

[BUGS] SELECT updatability clause defective.

Jerome O\'Neil ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description SELECT updatability clause defective. Long Description The syntax for select updatability clause is non-standard. Postgres describes select updatability as SELEC

[BUGS] Better dump of foreign key data

Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Better dump of foreign key data Long Description When you dump a database wich has tables that have foreign keys, it dumps a lot of things regarding foreign keys that

[BUGS] order by using functions under unions

Eric Pare ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description order by using functions under unions Long Description When using union over queries, if the order by clause occurs using a function, the output will not be correctly o

[BUGS] Irix build failes (PSQL 7.1.1)

Erik Hofman ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Irix build failes (PSQL 7.1.1) Long Description I'm unable to build on Irix (6.5.9) using the MipsPro compiler (Vs 7.3). The output is this: cc-1092 cc: ERROR File =

[BUGS] PG 7.1.1 version for SuSE 7.0

Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description PG 7.1.1 version for SuSE 7.0 Long Description Here we are having some problems with Postgres 7.0 and we would like to try out 7.1.1 before trying to analyze further t

[BUGS] Cannot unzip binary tar.gz file for IRIX 6.5.7I

BETTLER ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Cannot unzip binary tar.gz file for IRIX 6.5.7I Long Description You can t unzip sgi-pgsql-n32.tar.gz orsgi-pgsql-o32.tar.gz files of version 7.1 for IRIX 6.5.7 (i have t

[BUGS] GRANT permissions on views have no effect; \dv reports nothing

Kristis Makris (kristis dot makris at datasoft dot com) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description GRANT permissions on views have no effect; \dv reports nothing Long Description I run a bunch if GRANT statements on tables/views/sequences. T

[BUGS] Foreign key constraints on inherited columns, 2 errors.

Stephen Deasey ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Foreign key constraints on inherited columns, 2 errors. Long Description Using the Postgres 7.1.1 RPMs I typed the following into psql: =# create table foo (foo in

[BUGS] Loss of avg() functionality

Jon Pastore ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Loss of avg() functionality Long Description In v7.0.3 we use avg() with a type money column and it works just fine. In the new 7.1 (which btw way to verify we did a

[BUGS] PostgreSQL 7.1+ screw up Chinese Encoding after JDBC

Jeff Liu ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PostgreSQL 7.1+ screw up Chinese Encoding after JDBC Long Description I can read Chinese Encoding (gb2312) using select statement manually in psql after I installed Postg

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

Kristis Makris ([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 Here are the facts: I have a plpgsql function that should return a value out of a query.

[BUGS] Problems with avg on interval data type

Jeremy Blumenfeld ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Problems with avg on interval data type Long Description We have recently upgraded from 7.0.3 to 7.1 and a query which used to work is no longer working. The qu

[BUGS] select avg() and sum() returns false value

Christoph Lorenz ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description select avg() and sum() returns false value Long Description I don't know, if it's my fault, but when I sum up several thousands of positive entries in a column (t

[BUGS] references fail over rows inserted via inherited tables

Diego Saravia ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description references fail over rows inserted via inherited tables Long Description When you insert a row via an inherited table, with 7.1.1, you can see in the parent table.

[BUGS] Comments on Database Broken

Patricia Holben ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Comments on Database Broken Long Description When comments are added to a database (testdb in this example) (either at the point of creation or using the "comment

[BUGS] psql dumps core when entering invalid backslash command

Lukas Ertl ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql dumps core when entering invalid backslash command Long Description PostgreSQL v. 7.1.1., running on FreeBSD 4.3, standard installation via the ports collection.

[BUGS] pg_dumpall problem

Karthikeyan V ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dumpall problem Long Description I'm using tar version of PostgreSql 7.0. I'm planning to move to PostgreSql 7.1 and I wanted to backup the databases using pg_du

[BUGS] DATE_PART() BUG? We have an SQL statement that is giving wrong output.

Peter Kelly ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description DATE_PART() BUG? We have an SQL statement that is giving wrong output. Long Description Here are operational details: RedHat Linux 7.0: Linux version 2.2.17-14 ([EM

[BUGS] Optimizer in 7.1.1 worse thatn 7.0.3

Paul Wehr ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Optimizer in 7.1.1 worse thatn 7.0.3 Long Description While upgrading from 7.0.3 to 7.1.1, I found a particular query that was not being planned in the same way. The qu

[BUGS] DROP USER results in backend closure

J. Michael Caine ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description DROP USER results in backend closure Long Description Just switched to Debian distro and got postgresql set up. (Actually, comes "out of the box" quite nice!)

[BUGS] Outer join does not report rows with null values

Mirek Hankus ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Outer join does not report rows with null values Long Description I'm running two databases (7.1.2). Same structure, the only difference is data stored in them. When

[BUGS] dlopen() of libpsqlodbc.so fails in 7.1.2

Bob Deblier ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description dlopen() of libpsqlodbc.so fails in 7.1.2 Long Description While trying to upgrade Postgres from version 7.0.3 to 7.1.2, I find that a program which dlopens the libra

[BUGS] INSTALL procedure doesn't create data dir.

Josh Burdick ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description INSTALL procedure doesn't create data dir. Long Description when doing an install-from-source of 7.1.2, on an Intel Red Hat 6.1 box, following the INSTALL "short v

[BUGS] pg_dump dumps view ACLs before the view

Mark Reibert ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump dumps view ACLs before the view Long Description System Configuration: - Intel Pentium - Red Hat 6.2 (Linux 2.2.19) Version [output of "select version()"

[BUGS] REVOKE ... FROM username equals REVOKE ... FROM PUBLIC

Jean-Francois Leveque ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description REVOKE ... FROM username equals REVOKE ... FROM PUBLIC Long Description System: SuSE 7.0 PostgreSQL RPM: postgres-7.0.2-29 select version(); : PostgreSQL 7.0

[BUGS] GRANT SELECT ON ... TO username does REVOKE ALL ON ... FROM PUBLIC at the same time

Jean-Francois Leveque ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description GRANT SELECT ON ... TO username does REVOKE ALL ON ... FROM PUBLIC at the same time Long Description System: SuSE 7.0 PostgreSQL RPM: postgres-7.0.2-29 sele

[BUGS] pg_dump: Too much in COPY ouput

Jean-Francois Leveque ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description pg_dump: Too much in COPY ouput Long Description System: SuSE 7.0 select version(); : PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2 pg_dump

[BUGS] Trigger causes the server to crash with SEGV

Vlad Seryakov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Trigger causes the server to crash with SEGV Long Description PostgreSQL version : PostgreSQL 7.2devel on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 create tab

[BUGS] plpython: sys module doesn't know about _getframe

Steven D. Arnold ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description plpython: sys module doesn't know about _getframe Long Description I have a module which I import and use in plpython functions. One function in this module imp

[BUGS] repeated syntax errors in plpython modules cause database to reset

David Casti ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description repeated syntax errors in plpython modules cause database to reset Long Description I am migrating from PL TCL to PL Python for my procedural language. However, when

[BUGS] Backend unexpectedly closed connection

Paul Mamin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Backend unexpectedly closed connection Long Description Sequence: - listen xxx; create table xx (a int4); cr

[BUGS] System Logs filling up with gunk

Rick Saunders ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description System Logs filling up with gunk Long Description I'm running PG 6.5.3 on RedHat 6.0 with a 2.2.17 kernel: My /var/log/messages is filling up with the following.

[BUGS] Problems with remote access

Elie Atallah ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Problems with remote access Long Description I installed PostgreSQL on an NTServer machine via cygwin and I had no problems accessing the databases on this machine.

[BUGS] ERROR: EXECUTE of SELECT ... INTO is not implemented yet

Kristis Makris ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description ERROR: EXECUTE of SELECT ... INTO is not implemented yet Long Description -PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 It looks like execu

[BUGS] SELECT on VIEW returns wrong result, Buffer Leak

Ulrich Döhner ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SELECT on VIEW returns wrong result, Buffer Leak Long Description The following SELECT statements return different number of lines, depending on the ORDER clause (Te

[BUGS] Apparent deadlock for simultaneous sequential scans

Robert Bruccoleri ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Apparent deadlock for simultaneous sequential scans Long Description On an SGI Origin 2000 with 32 CPU's, I'm running Postgresql 7.1beta4 using 32768 buffers. I

[BUGS] coalesce in execute crashes backend

Vinod Kurup ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description coalesce in execute crashes backend Long Description When I use a coalesce statement to calculate an expression that is part of a dynamic query, it crashes the backen

[BUGS] failed connect from ecpg destroys evidence of failure

Rafal Boni ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description failed connect from ecpg destroys evidence of failure Long Description PostgreSQL version 7.1.2, built from source, on Linux (RH 6.2) If a CONNECT form ecpg fails, the

[BUGS] "WHERE col NOT IN" yields falsely empty result.

Dr M J Carter ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description "WHERE col NOT IN" yields falsely empty result. Long Description Consider SELECT * FROM bar WHERE col2 NOT IN (SELECT col1 FROM foo) where tables foo and b

[BUGS] Strange CREATE VIEW behavior??

Basil A. Evseenko ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Strange CREATE VIEW behavior?? Long Description createdb test psql test test=# create table zz(ss int, ff varchar); test=# create view ff2 as select ff as user,

[BUGS] Segmentation fault in psql

Paul Mamin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Segmentation fault in psql Long Description $ psql Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help wi

[BUGS] can not create database!!!!

scott cao ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description can not create database Long Description Can not create database I don't have an explicit transaction block in progress. ERROR: CREATE DATABASE: may not be call

[BUGS] sqlca.sqlcode doesn't work in 7.xx

scottc ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description sqlca.sqlcode doesn't work in 7.xx Long Description sqlca.sqlcode work in version 6.xx but doesn't work in version 7.xx Sample Code No file was uploaded with this repor

[BUGS] to_date() month translation

Andrei Popov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description to_date() month translation Long Description When using to_date() format conversion with an arbitrary date-string, conversion mask description does not work as expec

[BUGS] Referential Integrity corrupted sometimes by Rules

José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Referential Integrity corrupted sometimes by Rules Long Description If you define an empty rule with a condition over a table which references to an

[BUGS] Perl DBI Module fails to install correctly from RPM

Chris Carkner ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Perl DBI Module fails to install correctly from RPM Long Description I installed version 7.1.2 from RPMs from your FTP site specifically with the following files (n

[BUGS] can't create timestamp field (only timestamp with time zone)

Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description can't create timestamp field (only timestamp with time zone) Long Description 7.1.2 on debian It appears to be impossible to create a field with the "timestamp" dat

[BUGS] Sequences with pg_dump -a not properly set

HERVE Laurent ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Sequences with pg_dump -a not properly set Long Description I use PostgreSQL 7.0.3 When I use the pg_dump -a, the script contains CREATE SEQUENCE statements for loa

[BUGS] PL/pgSQL triggers with parameters don't work

José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PL/pgSQL triggers with parameters don't work Long Description The report is for PostgreSQL 7.1.2. When you create a trigger which calls a f

[BUGS] JDBC: The raise of an SQLException force the user to call either commit() or rollback() on the connection

Denis ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC: The raise of an SQLException force the user to call either commit() or rollback() on the connection Long Description Using JDBC, after an SQLException is raised as a

[BUGS] ecpg: INITALLY DEFERRED translated into intially deferrable

() reports a bug with a severity of 3 The lower the number the more severe it is. Short Description ecpg: INITALLY DEFERRED translated into intially deferrable Long Description The SQL preprocessor ecpg generates "initially deferrable" from INITIALLY DEFERRED in source code. cf. preproc.y:1455.

[BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found

Kristis Makris ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Long Description Using Postgres 7.1.2, I'm executing a plpgsql function that is expected to

[BUGS] JDBC - DatabaseMetaData.getTables() null pointer exception

Dave Antal ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC - DatabaseMetaData.getTables() null pointer exception Long Description When you pass the DatabaseMetaData.getTables() method a types array that contains "VIEW" a

[BUGS] your web site register is broken, cannot download Win32 distribution needed

Jill Gemmill ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description your web site register is broken, cannot download Win32 distribution needed Long Description (1) I went to http://www.ca.postgresql.org/ftpsite/odbc/download.html to

[BUGS] postmaster locks up in 7.1b3

paul vixie ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description postmaster locks up in 7.1b3 Long Description this morning at 1:00AM our nightly "vacuum analyze;" ran from cron and immediately went idle. both the psql process and t

[BUGS] libpgtcl doesn't use UTF encoding of TCL

Eugene Faukin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description libpgtcl doesn't use UTF encoding of TCL Long Description Modern versions of the TCL (8.2 at least) use UTF encoding to internal storage of the text. libpgtcl uses T

[BUGS] ERROR: CreateTrigger: function check_primary_key() does not exist

Young ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ERROR: CreateTrigger: function check_primary_key() does not exist Long Description I am using 7.1.2 I always got such an error when creating a trigger: ERROR: CreateTrigger

[BUGS] Two foreign keys in one table both referencing same record in primary table gives error on update of primary table

Bob Soeters ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Two foreign keys in one table both referencing same record in primary table gives error on update of primary table Long Description (PostgreSQL 7.1.1 on i686-pc-linux

[BUGS] some timestamps are wrong from JDBC

Rainer Mager ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description some timestamps are wrong from JDBC Long Description Postgres 7.1 (or its driver) munges timestamps. When the milliseconds M are in the range: 0 < (M mod 1000) < 1

[BUGS] When inserting '\' the insert fails.

Kristian Knudsen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description When inserting '\' the insert fails. Long Description When inserting '\' to a text field and there is a date column the insert fails. But only if the date inser

[BUGS] real or float4 '=' operator is broken in 7.1.2

David Dodsworth ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description real or float4 '=' operator is broken in 7.1.2 Long Description As the example shows, a select for on a 'real' or 'float4' value value will not return any rows wh

[BUGS] pg_dump doesn't handle CREATE FUNCTIONs well

Rainer Mager ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump doesn't handle CREATE FUNCTIONs well Long Description We have a table (table_A) that has a constraint on it that uses a custom function (func_B), which refer

[BUGS] insert of date is wrong

Marcos ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description insert of date is wrong Long Description when I insert the date '1914/01/01' in a column with the 'date' format, the table returns the value '1913/12/31' Sample Code in

[BUGS] ERROR: parser: parse error at or near "execute"

Christian Villa Real Lopes ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description ERROR: parser: parse error at or near "execute" Long Description I created a function to drop a table if it exists. On pgsql-7.0.3 this function retur

[BUGS] subquery results bypassed

Anthony Wood ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description subquery results bypassed Long Description The second query in the example code should return: a | b | c ---+---+--- (0 rows) but actually returns a | b | c -

[BUGS] 'order by' and 'desc' not working in subquery using 'not in'

Rahul Gade ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description 'order by' and 'desc' not working in subquery using 'not in' Long Description Hello, I am facing two big problems,they may not be really big but in my case these are b

[BUGS] Postmaster will not restart

mark hewitt ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Postmaster will not restart Long Description Afetr several very happy years of using PostgreSQL, I finally have a serious problem. As far as I know, the postmaster ter

[BUGS] pg_regress fails at "point" test

Volker Hetzer ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_regress fails at "point" test Long Description gcc2.95; hppa2.0-hp-hpux10.20, postgresql 7.1.2 make check checks the first group all right (tests check out ok and

[BUGS] error in libpq reading large fields

Stephen Oberski ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description error in libpq reading large fields Long Description Problem observed with Postgres 7.1.12 on SunOS 5.6. Application using libpq running the following: DECLARE c

[BUGS] query first time works second time fails for one connection

Rahul Gade ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description query first time works second time fails for one connection Long Description In fact i want to execute the code which i hade placed in remark, but since the orderby, l

[BUGS] alloc error on multiple action-queries within a rule

clemens oertel ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description alloc error on multiple action-queries within a rule Long Description when executing the rule 'tax_genuses_del' (see sample code) postgresql reports 'ERROR: Memor

[BUGS] backend don't use index when querying by indexed column

Zdenek Habala ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description backend don't use index when querying by indexed column Long Description I have a table named formula with this structure: id_formula | intege

[BUGS] timestamp handling in postgres 7.1 behaves strange

Martin Würtele ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description timestamp handling in postgres 7.1 behaves strange Long Description version: 7.1release-4 of debian/woody when comparing timestamps i always get ERROR: Bad timest

[BUGS] ecpg: unstable INSERT operation

Edward Pilipczuk ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ecpg: unstable INSERT operation Long Description Frequently INSERT operation causes backend crash (with SIGSEGV) or the parser reports: error [-400] 'ERROR: pa

[BUGS] reserved words on table

Erol Ozcan ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description reserved words on table Long Description I think that Postgresql should not allowed the create a table with reserved word. It could be caused to syntax error when quer

[BUGS] Except all eliminates what it shouldnt

Gerzson Szinyei ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Except all eliminates what it shouldnt Long Description "except all" eliminates records which had 2 instances in the original table, and one instance in the table

[BUGS] triggers

martin ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description triggers Long Description Hi, I have a problem I am using postgresql database and I want to enforce >triggers between my related tables ( tables with relationship), one

[BUGS] ECPG does not correctly identify pointer type

Lee Kindness ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ECPG does not correctly identify pointer type Long Description The embedded SQL preprocessor, ecpg, does not correctly identify pointer types. Example #1 below resul

[BUGS] JDBC driver converts search string patterns to lowercase

Bjorn Peterson ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC driver converts search string patterns to lowercase Long Description The metadata class of the Postgresql 7.1 JDBC driver converts search string patterns to a

[BUGS] inherited tables failure

Laszlo Csite ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description inherited tables failure Long Description We have two tables inherited one from the other one. If you try to insert from the parent into the child by an "INSERT INTO

[BUGS] ecpg 2.8.0 fails to handle struct properly

Clifford T. Matthews ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ecpg 2.8.0 fails to handle struct properly Long Description When I upgraded from postgresql 7.0.3 to 7.1.1 and 7.1.2, certain parts of my ECPG-using code stop

[BUGS] multicolumn PRIMARY KEY introduces wrong 'not null' fields

Laurent Martelli ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description multicolumn PRIMARY KEY introduces wrong 'not null' fields Long Description If you have a primary key on several columns, each of these columns is given the 'not

[BUGS] Left Join/Outer Join

Martijn Beelen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Left Join/Outer Join Long Description When using left join, I get the errormessage "ERROR: OUTER JOIN is not yet supported" I hope left-joins are supported, if not

[BUGS] timestamps cannot be created without time zones

Rainer Mager ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description timestamps cannot be created without time zones Long Description Creating a TABLE with a TIMESTAMP type seems to ignore the WITH TIME ZONE option. That is, with or w

[BUGS] Bug #422: testing the subject and header changes

test ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description testing the subject and header changes Long Description testing Sample Code No file was uploaded with this report ---(end of broadcast)--

[BUGS] Bug #423: unable to do selects on certain fields in large tables

dave miller ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description unable to do selects on certain fields in large tables Long Description In a table of about 300 MG, I am unable browse or select the text field - xml (holding a large

[BUGS] Bug #424: JDBC driver security issue.

David Daney ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description JDBC driver security issue. Long Description The JDBC driver requires permission java.lang.RuntimePermission "shutdownHooks"; in the policy file in order to func

[BUGS] Bug #425: Upper(), Lower() bug

Dmitry Bezgodov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Upper(), Lower() bug Long Description The functions Lower amd Upper doesn't work with cyrillic, but works fine with latin (a-z A-Z). Tested on psql (PostgreSQL) 7

[BUGS] Bug #427: joining views

Vladimir Bezak ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description joining views Long Description PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 wrong results when joining views. Sample Code table ORDER_

[BUGS] Bug #426:

Vladimir () reports a bug with a severity of 3 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 3: if posting/reading through Usene

[BUGS] Bug #428: Another security issue with the JDBC driver.

David Daney ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Another security issue with the JDBC driver. Long Description The JDBC driver requires permission java.net.SocketPermission "host:port", "connect"; in the policy f

[BUGS] Bug #429: Concurrent JDBC connections to result in wrong data

Amit Kelkar ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Concurrent JDBC connections to result in wrong data Long Description We are designing a major enterprise resource management system for a client and are using java (s

[BUGS] Bug #430: triggered data change violation on relation "tbl_b"

Pawe³ Paw³owski ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description triggered data change violation on relation "tbl_b" Long Description When I insert to table new row and after this in the same transaction I delete this row I get

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