[BUGS] PostgreSQL BugTool Submission

2000-08-21 Thread pgsql-bugs
Vinny ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description There's this bug, see? Long Description It's a huge bug that's eating tons of memory. Sample Code for(x=0;x<10;x++) p[x] = malloc(1); No file was uploaded with t

[BUGS] PostgreSQL BugTool Submission

2000-08-22 Thread pgsql-bugs
James Aspnes ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description checking foreign keys requires write access Long Description In version 7.0.2, create tables A and B where B has a foreign key reference to A. Grant user X insert ac

[BUGS] PostgreSQL BugTool Submission

2000-08-22 Thread pgsql-bugs
fmatheus ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description trouble with COPY from a iso-8859-1 encoding file Long Description Im notice this in pg 6.5.3 in a Debian/linux 2.2 in AMD K7. if there is some enhancede char like a a a

[BUGS] PostgreSQL BugTool Submission

2000-08-22 Thread pgsql-bugs
Jon Peatfield ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Docs use wrong chars Long Description In the ps docs several characters print out incorrectly, e.g. pi, sigma etc since the font being used doesn't have those glyph

[BUGS] PostgreSQL BugTool Submission

2000-08-23 Thread pgsql-bugs
Mickael FEYS ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unexpected behaviour of the ecpg -D option. Long Description Configuration : system : sun sparc ultra 5 os : solaris 2.7 postgres : 7.0.2 compilator : cc com

[BUGS] PostgreSQL BugTool Submission

2000-08-23 Thread pgsql-bugs
Gregg Wonderly ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description JDBC driver broken for ResultSet.getTimeStamp() Long Description The JDBC driver in 7.0.2 uses Timestamp.toString() to create the string representation of the time

[BUGS] PostgreSQL BugTool Submission

2000-08-23 Thread pgsql-bugs
NAGY Andras ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Foreign keys referencing read-only tables fail Long Description Consider two tables, foo(barid) and bar(id, str), where foo has a foreign key referencing bar(id). It

[BUGS] PostgreSQL BugTool Submission

2000-08-23 Thread pgsql-bugs
Stu Coates ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Not performing index scan for 64bit primary Long Description When performing a query against a table that has a 64bit (int8) primary key a sequential scan always takes

[BUGS] PostgreSQL BugTool Submission

2000-08-23 Thread pgsql-bugs
() reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Your bug system shows misformatted bug description and 'example code' Long Description When you show long description of the bug tag should be used in order to show text as it was entered Samp

[BUGS] PostgreSQL BugTool Submission

2000-08-23 Thread pgsql-bugs
chris vale ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql list ( \d ) command returns error Long Description Using 7.0.2 on LinuxPPC (YellowDog ) and RPMS's from postgresql.org. When trying to list/describe ( \d ) ERR

[BUGS] PostgreSQL BugTool Submission

2000-08-23 Thread pgsql-bugs
Doug Mitchell ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Excessive seeking by backend Long Description The backend call lseek much more often than it has to. The storage manage should not do either of the following: 1.

[BUGS] testing the reply to

2000-08-24 Thread pgsql-bugs
Vince ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description testing the reply to Long Description Check out the reply-to (it should be me and the list) and the subject (which should be the short description and nothing about bugtool

[BUGS] Invalid PG_PWD

2000-08-25 Thread pgsql-bugs
Ricard Pillosu ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Invalid PG_PWD Long Description We can't use pg_passwd to generate paswords for users, when pg_hba.conf contain : local password pg_pwd F

[BUGS] wrong permissions for triggers invoked by rewrite rules

2000-08-25 Thread pgsql-bugs
Helge Bahmann ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description wrong permissions for triggers invoked by rewrite rules Long Description Rewritten queries are normally executed with the permissions of the creator of the rewrite

[BUGS] duplicated rows on update when client dies

2000-08-25 Thread pgsql-bugs
Richard Gonda ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description duplicated rows on update when client dies Long Description We expected if a network client dies in update proceess (in case example power off), duplicated rows rem

[BUGS] Any user able to connect to a database can create tables/etc

2000-08-25 Thread pgsql-bugs
Robert Watson ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Any user able to connect to a database can create tables/etc Long Description There is no access control mechanism by which users can be allowed to connect to a data

[BUGS] postscript version of letter size manuals are really A4 format.

2000-08-25 Thread pgsql-bugs
Brooks Smith ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description postscript version of letter size manuals are really A4 format. Long Description The user, reference, tutorial, etc. manuals that I assumed to be in letter form are r

[BUGS] views containing aggregates

2000-08-26 Thread pgsql-bugs
NAGY Andras ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description views containing aggregates Long Description Not sure, whether the `Views containing aggregates sometimes fail' and `Allow views of aggregate columns' entries from th

[BUGS] CREATE VIEW does not work from within plpgsql

2000-08-27 Thread pgsql-bugs
NAGY Andras ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description CREATE VIEW does not work from within plpgsql Long Description subject says it all. postgresql 7.0.2, glibc2.1, debian 2.2. Sample Code nagya=> CREATE FUNCTION foo(

[BUGS] foreign_key regression test fails on Solaris 2.6

2000-08-28 Thread pgsql-bugs
Pascal Mueller ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description foreign_key regression test fails on Solaris 2.6 Long Description Running the regression test on PostgreSQL 7.0.2 on Solaris 2.6 (SPARC) fails with error message '

[BUGS] JDBC: allow update of Date-Columns with NULL

2000-08-29 Thread pgsql-bugs
Klaus Thiele ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description JDBC: allow update of Date-Columns with NULL Long Description JDBC: updating of Date (and other not_String)-columns with an null value throws an exception! (this wor

[BUGS] Callable Statements are not supported at this time.

2000-08-29 Thread pgsql-bugs
rosenberg Daniel ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Callable Statements are not supported at this time. Long Description org.postgresql.jdbc2.Connection.prepareCall List of the features not yet implemented? Sampl

[BUGS] prepareStatement.executeUpdate(deleteQuery) returns 1 even when no data deleted.

2000-08-29 Thread pgsql-bugs
Samuel Minne ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description prepareStatement.executeUpdate(deleteQuery) returns 1 even when no data deleted. Long Description With a delete query, prepareStatement.executeUpdate() should return

[BUGS] initdb -t trashes the entire database system

2000-08-29 Thread pgsql-bugs
toby cabot ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description initdb -t trashes the entire database system Long Description Hi, PostgreSQL is very cool, kudos to all who have worked hard to make it so! initdb is pretty dangerous

[BUGS] Cannot create tabel named 'user'

2000-08-29 Thread pgsql-bugs
Roman Solomatin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Cannot create tabel named 'user' Long Description Cannot create a table named user no matter if the database is old or freshly created. It may be version specific

[BUGS] table aliases with updates

2000-08-29 Thread pgsql-bugs
andrew brown ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description table aliases with updates Long Description It appears that table aliases cannot be used in update queries for the table we are updating. Sample Code This doesn't w

[BUGS] referential integrity requires write permission to a table which only needs to be read

2000-08-29 Thread pgsql-bugs
Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description referential integrity requires write permission to a table which only needs to be read Long Description I have two tables: create table NAS_MAKE ( id int8 no

[BUGS] inconsistent debug log output

2000-08-29 Thread pgsql-bugs
Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description inconsistent debug log output Long Description a transaction from psql shows referential integrity statements in the output, but a transaction from a client using l

[BUGS] Page 13 of tutorial has a typo I believe

2000-08-30 Thread pgsql-bugs
Chris Green ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Page 13 of tutorial has a typo I believe Long Description the Cartesian product of domains. such that V1 (is a member of) D1, V1 (is a member of) D1, ... Vk (is

[BUGS] misleading (or perhaps confusing) error messages

2000-08-30 Thread pgsql-bugs
Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description misleading (or perhaps confusing) error messages Long Description When an error is generated as the result of a trigger (or other indirect action) it would be helpf

[BUGS] Responses to bugs should appear publically with bug reports

2000-08-31 Thread pgsql-bugs
Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Responses to bugs should appear publically with bug reports Long Description The current appearance of the bugtool database makes it appear as if the bug reports ar

[BUGS] min and max function in time data type columns

2000-09-01 Thread pgsql-bugs
Peter Boda ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description min and max function in time data type columns Long Description If I try to select a min or max value from a column of time data type, I get the message "Unable to se

[BUGS] select on macaddr field type yields incorrect response

2000-09-01 Thread pgsql-bugs
Jeff MacDonald ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description select on macaddr field type yields incorrect response Long Description I have a table with several hundred records. In this table is a field of type "macaddr". Wh

[BUGS] LIKE 'bla%'

2000-09-02 Thread pgsql-bugs
Henrik Steffen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description LIKE 'bla%' Long Description I just wanted to delete a record from a table, using DELETE FROM MYTABLE WHERE NAME LIKE 'Ant%'; knowing that there existed only one

[BUGS] PG still fussy to compile on Solaris + GCC, may still need Sun ld

2000-09-02 Thread pgsql-bugs
Matt Benjamin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PG still fussy to compile on Solaris + GCC, may still need Sun ld Long Description I found that on my Solaris 8, Sparc system with GCC and GNU Binutils, there was o

[BUGS] unique/references not honored when inheriting tables

2000-09-02 Thread pgsql-bugs
Helge Bahmann ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description unique/references not honored when inheriting tables Long Description If a table inherits fields carrying the "references" or "unique" constraint, they are not hono

[BUGS] psql can crash the backend on login

2000-09-03 Thread pgsql-bugs
Alexandru Popa ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description psql can crash the backend on login Long Description On a FreeBSD 4.1-STABLE system, launching /usr/local/pgsql/bin/psql and giving control-d as a password will c

[BUGS] bugtool horribly wraps the lines

2000-09-03 Thread pgsql-bugs
Some One ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description bugtool horribly wraps the lines Long Description The lines someone types here are put in the html (possibly) without filtering. Not even a nice
 to let them show

[BUGS] pg_dump does not reflect changes in column names with primary keys

2000-09-05 Thread pgsql-bugs
Edward Pilipczuk ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump does not reflect changes in column names with primary keys Long Description If a table with primary key is created (CREATE TABLE), that implicitly forces

[BUGS] Access 97 and PSQL ODBC

2000-09-05 Thread pgsql-bugs
Charles ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Access 97 and PSQL ODBC Long Description As of now this is not reproducible. Sometimes when entering data into a PSQL table through Microsoft Access, when you leave the

[BUGS] Access 97 and PSQL ODBC Update

2000-09-05 Thread pgsql-bugs
Charles ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Access 97 and PSQL ODBC Update Long Description Update: I can reproduce this now. In a text field if a record already has the text "Hello" in it and I type that same tex

[BUGS] /usr/include/pgsql/os.h does not exist

2000-09-05 Thread pgsql-bugs
Charles Choi ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description /usr/include/pgsql/os.h does not exist Long Description I am trying to install Postgresql 7.0.2 using the RPM on RedHat 6.2. In the example code section I have shown

[BUGS] bug in date_part() function in 6.5.2, 7.0.2

2000-09-05 Thread pgsql-bugs
Alex Karpov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description bug in date_part() function in 6.5.2, 7.0.2 Long Description Checked on Postgres version 6.5.2 and 7.0.2: Incorrect DOW and DAY parts of date calculation. See exanple

[BUGS] Error with union in sub-selects

2000-09-06 Thread pgsql-bugs
Martin Neimeier ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Error with union in sub-selects Long Description Version: PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2 If i try to use unions in a subselect, pos

[BUGS] How to connect to a remote database

2000-09-07 Thread pgsql-bugs
Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description How to connect to a remote database Long Description This may be a dumb question, but how do I connect to a remote database using postgresql, or rather psql? I have

[BUGS] Select from array slices doesn't work

2000-09-07 Thread pgsql-bugs
Kuba Ober ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Select from array slices doesn't work Long Description When I try to select from array slices it gives strange qrPgSql error. Normal array indexing works, but slices do

[BUGS] createuser fails

2000-09-08 Thread pgsql-bugs
Pushkar ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description createuser fails Long Description I am trying to install postgres on windows nt . initdb worked fine , and also the createdb command. But when i run any command like crea

[BUGS] Backend crash trying to delete rows

2000-09-08 Thread pgsql-bugs
Andrea Aime ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Backend crash trying to delete rows Long Description Platform: RedHat 6.2, PostgreSQL 7.02 compiled by gcc egcs 2.91.66, running on a PIII 733Mhz, 128 MB RAM, 9 GB SCS

[BUGS] datestyle

2000-09-09 Thread pgsql-bugs
Bruno LEVEQUE ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description datestyle Long Description I use postgresql 7.0.2 under Linux (slackware 7.1) I cannot change the format of the date style with set I'm French and I want to use the

[BUGS] nested implicit selects (views) go wrong

2000-09-11 Thread pgsql-bugs
Piotr Sulecki ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description nested implicit selects (views) go wrong Long Description I'm using PostgreSQL 7.0.2, but the bug is present in 6.5.3 as well. I'm trying to create a database of le

[BUGS] test

2000-09-26 Thread pgsql-bugs
vv ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description test Long Description test Sample Code test No file was uploaded with this report

[BUGS] 7.0.2 source rpm failed to compile

2000-09-26 Thread pgsql-bugs
Olof Nyqvist ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description 7.0.2 source rpm failed to compile Long Description I'm running RedHat 6.2 SPARC, two processors, 128 MB RAM I downloaded postgresql-7.0.2-2.src.rpm from your main FT

[BUGS] Can't compile postgres 7 on HP-UX 10.2

2000-09-26 Thread pgsql-bugs
Rick Bischoff ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Can't compile postgres 7 on HP-UX 10.2 Long Description HP-UX 10.2 machine with GNU binutils and gcc, g++, etc. Configure automatically uses HP's crappy "cc" when it

[BUGS] dump/reload with sequences fails

2000-09-26 Thread pgsql-bugs
Vince ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description dump/reload with sequences fails Long Description dumping a table then reloading it on a new database fails if there are sequences involved because the sequence isn't creat

[BUGS] Documentation bug

2000-09-27 Thread pgsql-bugs
Marius Kintel ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Documentation bug Long Description in file "user/app-psql.htm" \copy table [ with oids ] { from | to } filename | stdin | stdout [ with delimiters 'characters' ] [

[BUGS] psql wraps lines at 256 characters

2000-09-27 Thread pgsql-bugs
Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description psql wraps lines at 256 characters Long Description the v7.0 psql wraps output lines at 256 characters. The 6.5 version did not. I sometimes create huge xterms so

[BUGS] how to copy data from excel spreadsheet to postgresql database

2000-09-28 Thread pgsql-bugs
Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description how to copy data from excel spreadsheet to postgresql database Long Description I have enter data in excel spreadsheet, and I would like to enter or copy this data in

[BUGS] Inexplicably running wild and freezing with 7.0

2000-09-28 Thread pgsql-bugs
Julian Coutts ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Inexplicably running wild and freezing with 7.0 Long Description Running on a HP lpr 192RAM 600mz pIII computer. Running 7.0 (have been a big fan of 6.5.3 which was/

[BUGS] very poorly optimised query

2000-09-28 Thread pgsql-bugs
Orion Henry ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description very poorly optimised query Long Description This is for Postgres 7.0.1 running on x86 linux While usually impressed with postgres's speed I ran into a query that ran

[BUGS] Subselects lack functionality

2000-09-28 Thread pgsql-bugs
Kuba Ober ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Subselects lack functionality Long Description 1. Subselects don't allow one to use tuple set operators like UNION, INTERSECT, EXCEPT. It forces one to select the resul

[BUGS] /contrib/soundex doesn't work. Version 7.0.2

2000-09-28 Thread pgsql-bugs
Edmar Wiggers ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description /contrib/soundex doesn't work. Version 7.0.2 Long Description The code in /contrib/soundex doesn't work. It does compile though. I create the function in the databa

[BUGS] after trigger not working in begin-commit block

2000-09-29 Thread pgsql-bugs
Jonah E. Safar ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description after trigger not working in begin-commit block Long Description As part of a registration system, we use a couple of before insert or update triggers to check cer

[BUGS] JDBC: HELP!!! Can't Upload BLOBS on 6.5.3

2000-10-02 Thread pgsql-bugs
Angel Leon ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description JDBC: HELP!!! Can't Upload BLOBS on 6.5.3 Long Description At First I tried the PreparedStatement "setBinaryStream" to upload a jpeg.. but it turned out to be, they ha

[BUGS] dllinit.c compilation errors on NT with cygwin

2000-10-05 Thread pgsql-bugs
K. Stuart Smith ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description dllinit.c compilation errors on NT with cygwin Long Description compiling 7.0.2 using cygwin 1.1.4 with gcc 2.95.2 dllinit.c:49: conflicting types for Dll

[BUGS] psql -P doesn't honor backslash escapes

2000-10-06 Thread pgsql-bugs
Mark Hollomon ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description psql -P doesn't honor backslash escapes Long Description The interactive command psql command: \pset fieldsep '\t' can be used to set the field separator to a tab ch

[BUGS] INSERT doesn't like (.)

2000-10-09 Thread pgsql-bugs
Adam Levine ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description INSERT doesn't like (.) Long Description I'm using Dynamo connected to Postgres. The PreparedStatement generated for an INSERT works on other dbs, but Postgres comp

[BUGS] psql: ERROR: MultiByte strings (MB) must be enabled to use this function

2000-10-12 Thread pgsql-bugs
Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description psql: ERROR: MultiByte strings (MB) must be enabled to use this function Long Description When I am trying to connect to my remote database kenyellow pages i.e. psql

[BUGS] Drop table doesn't drop serial sequences.

2000-10-13 Thread pgsql-bugs
Antonio García ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Drop table doesn't drop serial sequences. Long Description The SERIAL special type automatically creates a sequence for the field when you create a table. The seque

[BUGS] ORDER BY on INTERSECT

2000-10-14 Thread pgsql-bugs
Petr Splichal ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ORDER BY on INTERSECT Long Description I was not able to make an ORDER BY on INTERSECT of two SELECTs. Instead I got this error: ] get_sortgroupclause_tle: ORDER/GR

[BUGS] ResultSet.getTimestamp() was broken

2000-10-14 Thread pgsql-bugs
Kensaku MASUDA ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ResultSet.getTimestamp() was broken Long Description This report is same as #8. And collect format string is here. from "-MM-dd HH:mm:ss.zzz" t

[BUGS] ResultSet.getTimestamp() was broken.

2000-10-14 Thread pgsql-bugs
Kensaku MASUDA ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ResultSet.getTimestamp() was broken. Long Description About #70, It can not cover all cases. So restored data are presented by original format string. Best way

[BUGS] INSERT possible without INSERT-permission

2000-10-15 Thread pgsql-bugs
Gert Pache ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description INSERT possible without INSERT-permission Long Description Although a user without has only UPDATE/DELETE-permissions on a table he can insert into the table. Version

[BUGS] permission-error in tables with referential integrity

2000-10-15 Thread pgsql-bugs
Gert Pache ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description permission-error in tables with referential integrity Long Description Suppose you have a table A, which no user should be able to alter Table B is a table, the user to

[BUGS] constraints evaluate 'now' immediately

2000-10-16 Thread pgsql-bugs
Roger Wernersson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description constraints evaluate 'now' immediately Long Description I run Postgres 6.5.3 on Alpha/Linux. I would like a constraint stating that a column may not have a date

[BUGS] SELECTs return error with oid in WHERE clause

2000-10-17 Thread pgsql-bugs
Ilya Goldberg ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SELECTs return error with oid in WHERE clause Long Description Create a table (FOO) insert a row, do a SELECT oid from FOO. Now do a SELECT FROM FOO WHERE OID=[wha

[BUGS] UPPER and LOWER dosen't work correctly on special caracters (umlauts)

2000-10-17 Thread pgsql-bugs
Gert (Pache) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description UPPER and LOWER dosen't work correctly on special caracters (umlauts) Long Description The Upper- and the lower function don't convert the german umlauts (ü.ä.ö.) but leave them in thei

[BUGS] Field Separator setting not used.

2000-10-17 Thread pgsql-bugs
Kevin Colagio ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Field Separator setting not used. Long Description (This is major because I have about 20 scripts that I would have to modify to get this to work...and I don't thi

[BUGS] ESQL-C INSERT Problem

2000-10-20 Thread pgsql-bugs
Sascha Demetrio ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ESQL-C INSERT Problem Long Description An embedded SQL/C program INSERT operation fails, if a string value submitted through a host variable ends with a backslash

[BUGS] Updating multiple bool values crashes backend

2000-10-24 Thread pgsql-bugs
Sean Kelly ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Updating multiple bool values crashes backend Long Description Bug best described by an example, see below. Tested on two systems: Intel Pentium III 600 128Mb RAM Linu

[BUGS] Slack7.1/linux.2.4 compile error: storage size of `semun' isn't known

2000-10-25 Thread pgsql-bugs
Andreas Hinz ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Slack7.1/linux.2.4 compile error: storage size of `semun' isn't known Long Description Hi, I have a the following error compiling latest CVS of PostgreSQL: ipc.c: In

[BUGS] Select where (upper(xy)~'.CH'); ..matches also SPACE CH

2000-10-26 Thread pgsql-bugs
Marcel ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Select where (upper(xy)~'.CH'); ..matches also SPACE CH Long Description There exists a problem with the ~ statement. The codesample and the text is from an adult contact

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

2000-10-26 Thread pgsql-bugs
Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 3 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] \df causes an ERROR: Function oid8types(oidvector) does not exists

2000-10-26 Thread pgsql-bugs
Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 1 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] Response to Bug Report #37

2000-10-26 Thread pgsql-bugs
Bradley S. Huffman ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Response to Bug Report #37 Long Description It's not Makefile.PL that produces the SUN compiler options "-KPIC -xO3 -depend", but SUN's pre-install version of p

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

2000-10-26 Thread pgsql-bugs
Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 4 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] Can not use NULL values at all

2000-10-27 Thread pgsql-bugs
PL/pgSQL functions: NULL parameter trouble ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Can not use NULL values at all Long Description If one of parameters is NULL, all another parameters take NULL values regardless of tra

[BUGS] Unable to create an inheritad table with primary key containing inherited attribute

2000-10-30 Thread pgsql-bugs
Pascal Bourgeois ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Unable to create an inheritad table with primary key containing inherited attribute Long Description If u create a table basetable having two attributes mkey an

[BUGS] Joins on over 10 tables returns unreliable results

2000-10-30 Thread pgsql-bugs
Jeff Seaman ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Joins on over 10 tables returns unreliable results Long Description Running Postgres version 7.01 on Redhat linux 6.2. When joining on more than 10 tables not all of

[BUGS] RPMS don't work for 2.2.17

2000-10-31 Thread pgsql-bugs
Alex Finck ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description RPMS don't work for 2.2.17 Long Description I get this message: IpcMemoryCreate: memKey=155356396 , size=760632 , permission=384IpcMemoryCreate: shmget(..., cr

[BUGS] Backend touches index not involved in update / NULL indexing

2000-11-01 Thread pgsql-bugs
Doug Mitchell ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Backend touches index not involved in update / NULL indexing Long Description I had some updates that were taking a few seconds each on a primary-keyed table with a

[BUGS] performace about your search engine

2000-11-01 Thread pgsql-bugs
P. Ashok Kumar ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description performace about your search engine Long Description You search engine takes long time to give results. Many times It's session is timed out. Sample Code No fi

[BUGS] JDBC-Driver produces wrong output.

2000-11-02 Thread pgsql-bugs
Jan Thomae ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC-Driver produces wrong output. Long Description Hi, I recently downloaded the last snapshot of PostgreSQL and also the newest JDBC-Driver for it. I played a bit a

[BUGS] LIKE(~~) OR regular pattern(~) deliver incomplete output

2000-11-02 Thread pgsql-bugs
ernst reeh ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description LIKE(~~) OR regular pattern(~) deliver incomplete output Long Description I work with POSTGRES version 6.4, so maybe the bug is already fixed. Please tell me if it's s

[BUGS] version info to bug#94 (LIKE(~~) ...)

2000-11-02 Thread pgsql-bugs
ernst reeh ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description version info to bug#94 (LIKE(~~) ...) Long Description Sorry, i didn't give you the complete version info for my bug-report: PostgreSQL 6.4.2 on i686-pc-linux-gnu, comp

[BUGS] Bug#94 is related to compiler-version

2000-11-02 Thread pgsql-bugs
ernst.reeh ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Bug#94 is related to compiler-version Long Description Sorry again, The bug didn't appear on another machine with the following version-info: --

[BUGS] Unable to compile enterprise version of jdbc-driver

2000-11-03 Thread pgsql-bugs
Grim Iversen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unable to compile enterprise version of jdbc-driver Long Description I checked out all the source from cvs, and tried to compile the jdbc-driver with the class "Post

[BUGS] pg_dump doesn't work on Linux PPC

2000-11-04 Thread pgsql-bugs
Marco Pratesi ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description pg_dump doesn't work on Linux PPC Long Description The description is very simple. I am using PostgreSQL 7.0.2 on Yellow Dog Linux CS 1.2, I use the official RPMs.

[BUGS] Sequence bug in insert trigger

2000-11-06 Thread pgsql-bugs
Sequence bug in insert trigger ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Sequence bug in insert trigger Long Description Insert triggers always read sequences at their min (or start) value. This only occurs when trigger

[BUGS] Sending result sets from backend to frontend is _slow_

2000-11-06 Thread pgsql-bugs
Glen Parker ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Sending result sets from backend to frontend is _slow_ Long Description When operating over a fast network (ethernet), the sending of select result rows from the back

[BUGS] Security problem in psql frontends

2000-11-12 Thread pgsql-bugs
Csaba Erdei ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Security problem in psql frontends Long Description I can connect to the database with a valid username and with a false password. Why ? I think it isn't a wery good

  1   2   3   4   5   6   7   8   9   10   >