[BUGS] Mail Delivery (failure [EMAIL PROTECTED])

2006-10-02 Thread pgsql-bugs
---(end of broadcast)--- TIP 6: explain analyze is your friend

[BUGS] Status ([EMAIL PROTECTED])

2005-08-23 Thread pgsql-bugs
Mail Delivery Error - This mail contains unicode characters - failed message - 'UßPnO!&1SXlQ3lU7_ßümQt:1STnGH-V*Gö>NJUfQ+D# Rßc83zrJKm'cYmi$z6qqwe#ö9ab4SQ3QejLrEs#SV;y>2o zu8nUBpY*N#q#NAV)k_%WmKkcwcCOOi1gnp

Re: [BUGS] Postgres 7.4.7 hang in async_notify

2005-06-02 Thread pgsql-bugs
In message <[EMAIL PROTECTED]>, Tom Lane writes: [EMAIL PROTECTED] writes: > We saw the problem with async_notify again (See thread with subject > "Postgres 7.4.6 hang in async_notify" in first message to this list > dated "Mon, 25 Apr 2005 15:42:35 -0400") in a production setting

[BUGS] Postgres 7.4.7 hang in async_notify

2005-06-02 Thread pgsql-bugs
We saw the problem with async_notify again (See thread with subject "Postgres 7.4.6 hang in async_notify" in first message to this list dated "Mon, 25 Apr 2005 15:42:35 -0400") in a production setting. Since our last instance, we converted to compiling postgres with debugging, so we have a stack t

Re: [BUGS] Postgres 7.4.6 hang in async_notify

2005-04-25 Thread pgsql-bugs
In message <[EMAIL PROTECTED]>, Alvaro Herrera writes: On Mon, Apr 25, 2005 at 03:42:35PM -0400, [EMAIL PROTECTED] wrote: > The way the notify gets called is a bit convoluted. Our C program > performs an insert in table T. Some triggers run doing all sorts of > stuff in the

[BUGS] Postgres 7.4.6 hang in async_notify

2005-04-25 Thread pgsql-bugs
We have seen this twice. The first time, it was on a 32 bit Fedora Core 3 system during a `postgres stop`. The stop hung because one of the processes was in async_notify and refused to get out. We were unable to do further debugging because the db was in shutdown. We were forced to kill -9 the

[BUGS] Returned due to virus; was:Hello

2005-02-24 Thread pgsql-bugs
Important notice! Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e500 Appliance discovered a virus in this file. The file was not cleaned and has been removed. See your system administrator for further information. File name: Notice.zip Virus name: W32/[EMAIL PROTECTED] Cop

[BUGS] Returned due to virus; was:Hello

2005-01-10 Thread pgsql-bugs
Important textfile! Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e500 Appliance discovered a virus in this file. The file was not cleaned and has been removed. See your system administrator for further information. File name: Textfile.zip Virus name: W32/[EMAIL PROTECTED]

[BUGS] Returned due to virus; was: Failed ([EMAIL PROTECTED])

2004-10-26 Thread pgsql-bugs
Mail Transaction Failed - This mail couldn't be converted - failed message - t%Y_noi%-IeLjnBEI~Gb*70?a)UbW+GnH-VNaqxA|Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e250 Appliance discovered a virus in this file. The file was not cleaned and has been

[BUGS] Returned due to virus; was: Delivery Failure ([EMAIL PROTECTED])

2004-10-06 Thread pgsql-bugs
Mail Delivery Failed - This mail couldn't be represented - failed message - mv?WBG>S9B_tH$du5PRXF2SkBS%&a>i6fkOLOGuKCt6 oJ+9)ßXT<%zaoGMU$:H%RKSüVGIAgtdCG-RkOBuzQSBbO KK#7'nb;üC3hb48~-35FGtZC0q'JOß_Q)SnDCEFTTW%4B.b7 JrXißLf0d7bnZrK~+özp#_8_dßXxn(J2 Message has been sent as

[BUGS] Returned due to virus; was: Re: Re: Thanks!

2004-06-09 Thread pgsql-bugs
Here is the file. Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e500 Appliance discovered a virus in this file. The file was not cleaned and has been removed. See your system administrator for further information. File name: document.pif Virus name: W32/[EMAIL PROTECTED] Co

[BUGS] Returned due to virus; was:hi

2004-03-25 Thread pgsql-bugs
your name is wrong ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[BUGS] Returned due to virus; was:Mail Delivery (failure sandra.niehoff@services.fujitsu.com)

2004-03-23 Thread pgsql-bugs
If the message will not displayed automatically, follow the link to read the delivered message. Received message is available at: www.services.fujitsu.com/inbox/sandra.niehoff/read.php?sessionid-9290   Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e500 Appliance VGuard2 di

[BUGS] Returned due to virus; was:Re: Your letter

2004-03-09 Thread pgsql-bugs
Your document is attached. Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e500 Appliance discovered a virus in this file. The file was not cleaned and has been removed. See your system administrator for further information. File name: your_letter.pif Virus name: W32/[EMAIL PR

[BUGS] Returned due to virus; was:Status

2004-02-05 Thread pgsql-bugs
Â-ß3ÑÙ‹¢)$TÝ—²K?Õ$O¿ÎO×»ïr9 xGlQñ“Ë„öÞNë}*£`߇ž‘ý($‰¤gnt˱šÊ̲¼ùÎ>¼§E™_˜ržw“‰ÖµÉÖ?«Óò¹Šâc]ýía·5zYá_:™8`Á"F,û1óŒ¼é[4½­‚!}?6¼ì6‡¦ó¿’íw‘Á|3®BÓÄ;û–Ù#Ð_P–þôÄl0¯Æ(Uïò 5búg¶:ªŸ¹¤5|ð9-dB²0›?*—®z¤ßäµß’¢éHŽÛº4IJÈ?¢±Q¬¥õì Çä?‘ x†w{à~ .Ö¹ŽÔ)§cE»¬‘Ñ;é?²#\ì]£ØÆÜ<¾ÆïZÈú4‘WO²y»Û»-Q®$fôeržÁj*Þ‘—àŲzA5’ªßÔE>®?ý ÙÙ¤‡

[BUGS] [Magic OnLine] Suppression du Virus: Server Report

2004-02-03 Thread pgsql-bugs
î<¡§ˆ¿e?'¿JÈ7vÛ£Š1YÇ2G»ÖQʺ|6¡ ”:dJ<‚ÚDØGèÎÉÉ¿“¤osoò!2^%Á&UʹģàïeûÄû×zGë5êlñ|Õ6ch9Úæ‰E"ýÁ¼754«­³Ôä?Vü°G¼$Ó2ÇöíeJ n¿ËqéÖÈ‹cúÀyw//žÉqΈAä4ò¬•Â"çqKFÕÐ#"n¸»IDÏ& ÕL½7_úõç>4ãÓûá4c~a¢Ù‚vú—JÜšÝy±ò­RHmyÐw‡ B\cÝÒÍ]V‚ˆ,9°†6_‘|ScGéX‡Â¹1Æx™JݬàVS4J¡2¥ôNô#Íi<"ôtDȺšIkb«¤?¬½NR·9©éMu¥Ÿa}„}lBÖ»3u„9¼Qu·?ê#£\Ö”í²°?

[BUGS] Virus Infection Alert! Mail Transaction Failed

2004-01-29 Thread pgsql-bugs
The message contains Unicode characters and has been sent as a binary attachment. Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e500 Appliance discovered a virus in this file. The file was not cleaned and has been removed. Please contact the Help Desk for further information

[BUGS] Returned due to virus; was:hi

2004-01-27 Thread pgsql-bugs
The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment. Title: VIRUS INFECTION ALERT VIRUS INFECTION ALERT The WebShield® e500 Appliance discovered a virus in this file. The file was not cleaned and has been removed. See your system administrator for

[BUGS] ERROR: record "previousrec" is unassigned yet

2003-10-04 Thread pgsql-bugs
I am writing a script that loops through a series of records, comparing each to a previous record, and writing the changes to a new table. It selects the current record into a RECORD variable (CurrentRec), and then attempts to load the previous record into a second RECORD variable (PreviousRec). W

[BUGS] VIRUS INFECTED MESSAGE NOT DELIVERED

2003-09-08 Thread pgsql-bugs
A message from [EMAIL PROTECTED] to [EMAIL PROTECTED] entitled Re: Re: My details was virus infected and was not delivered. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmail

[BUGS] Returned due to virus; was: Re: Wicked screensaver

2003-09-02 Thread pgsql-bugs
See the attached file for details ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[BUGS] "Returned due to virus; was:" Re: Your application

2003-08-31 Thread pgsql-bugs
Please see the attached file for details. INFECTION ALERT The WebShield Appliance, at Binghamton University, discovered a virus in this file.You may or may not have sent this file. We do not check each email for correct addressing, we only return to the address on the FROM: line. The file was not

[BUGS] "Returned due to virus; was:" Re: Re: My details

2003-08-28 Thread pgsql-bugs
See the attached file for details INFECTION ALERT The WebShield Appliance, at Binghamton University, discovered a virus in this file.You may or may not have sent this file. We do not check each email for correct addressing, we only return to the address on the FROM: line. The file was not cleaned

[BUGS] Returned due to virus; Was: Re: Thank you!

2003-08-24 Thread pgsql-bugs
Please see the attached file for details.<<< Text/HTML; name="details.pif.htm": Unrecognized >>> ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[BUGS] "VIRUS found in:" Re: That movie

2003-08-24 Thread pgsql-bugs
See the attached file for detailsTitle: VIRUS INFECTION ALERT VIRUS INFECTION ALERT A virus was detected in this file. The file was not cleaned and has been removed. See your system administrator for further information. File name: thank_you.pif Virus name: W32/[EMAIL PROTECTED] -

[BUGS] Returned due to virus; Was: Re: Thank you!

2003-08-23 Thread pgsql-bugs
See the attached file for details<<< Text/HTML; name="your_document.pif.htm": Unrecognized >>> ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] Returned due to virus; Was: Re: Re: My details

2003-08-20 Thread pgsql-bugs
Please see the attached file for details.<<< Text/HTML; name="movie0045.pif.htm": Unrecognized >>> ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[BUGS] Bug #945: RFE: Update table SET CASE...END=foo WHERE...

2003-04-12 Thread pgsql-bugs
Richard Neill ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description RFE: Update table SET CASE...END=foo WHERE... Long Description It would be *really* nice to be able to determine the column which should be updated by a case stateme

[BUGS] Bug #935: UPDATE on column with UNIQUE constraint sometimes(!) fails.

2003-04-05 Thread pgsql-bugs
Chris Wesseling ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description UPDATE on column with UNIQUE constraint sometimes(!) fails. Long Description The result of an UPDATE changing a column with a uniqueness CONSTRAINT depends on the

[BUGS] Bug #934: readline.h not found during configure

2003-04-04 Thread pgsql-bugs
Bill Eichin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description readline.h not found during configure Long Description I'm running debian woody, and I've been revisiting this problem for several months. I had no choice during comp

[BUGS] Bug #933: Too many inserts crash server

2003-04-03 Thread pgsql-bugs
Mark Pether ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Too many inserts crash server Long Description If I create an external C function consisting of a simple loop that inserts 25 records into a table the server proce

[BUGS] Bug #932: some system tables are not accessible

2003-04-03 Thread pgsql-bugs
Raouf ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description some system tables are not accessible Long Description Platform: Windows 2ooo professional workstation posgresql : PgSQL731wina1.exe postgresql version: PostgreSQL 7.3.1 on

[BUGS] Bug #931: bugs "create user" "alter user"

2003-04-03 Thread pgsql-bugs
techi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description bugs "create user" "alter user" Long Description I think i have found a bug . I am using PostgreSQL 7.3.2 on a platform WindowsXP under cygwin. And the bug looks like

[BUGS] Bug #930: UNIQUE CONSTRAINT

2003-04-01 Thread pgsql-bugs
Chris Wesseling ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description UNIQUE CONSTRAINT Long Description Sample Code No file was uploaded with this report ---(end of broadcast)---

[BUGS] Bug #929: Client connection to postgresql hangs indefinitely (under possibly pathological scenarios)

2003-03-31 Thread pgsql-bugs
Claudio Natoli ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Client connection to postgresql hangs indefinitely (under possibly pathological scenarios) Long Description Configuration = WinNT 4.0.0 (build 1381 w/

[BUGS] Bug #928: server_min_messages (log_min_messages in CVS) have PGC_USERSET GucContext

2003-03-30 Thread pgsql-bugs
Sergey N. Yatskevich ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description server_min_messages (log_min_messages in CVS) have PGC_USERSET GucContext Long Description In src/backend/utils/misc/guc.c "server_min_messages" ("log_min_mess

[BUGS] Bug #927: Hardcoded paths in windows install (731a1)

2003-03-30 Thread pgsql-bugs
Matthijs Piek ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Hardcoded paths in windows install (731a1) Long Description Windows installer for Postgresql 7.3.1 Alpha 1 forces install to the resident program files directory (D:

[BUGS] Bug #926: if old postgresql.jar in CLASSPATH, ant fails

2003-03-29 Thread pgsql-bugs
Palle Girgensohn ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description if old postgresql.jar in CLASSPATH, ant fails Long Description See http://www.freebsd.org/cgi/query-pr.cgi?pr=48878 If there is an older postgresql.jar file in th

[BUGS] Bug #925: typing error in src/backend/libpq/be-secure.c ???

2003-03-28 Thread pgsql-bugs
Sergey N. Yatskevich ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description typing error in src/backend/libpq/be-secure.c ??? Long Description In src/backend/libpq/be-secure.c: secure_write on SSL_ERROR_WANT_WRITE call secure_read inst

[BUGS] Bug #924: Segmentation fault in libpq/PQconsumeInput on SSL connection

2003-03-28 Thread pgsql-bugs
Sergey N. Yatskevich ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Segmentation fault in libpq/PQconsumeInput on SSL connection Long Description When I start SSL connection and try to handle async query: // run query action

[BUGS] Bug #923: psql can't read file prepaired by pg_dumpall

2003-03-28 Thread pgsql-bugs
Krzysztof Czuma ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql can't read file prepaired by pg_dumpall Long Description I can't move databases from PostgreSQL 7.0 to PostgreSQL 7.3 When I try to execute: psql -d template

[BUGS] Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory

2003-03-27 Thread pgsql-bugs
A. Hackmann ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory Long Description Hi, I'm loading aprrox. 20GB into a Postgresql 7.3.2 db (using COP

[BUGS] Bug #921: Default value not available in RULE

2003-03-26 Thread pgsql-bugs
A.Bhuvaneswaran ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Default value not available in RULE Long Description I as using postgresql 7.2.3. The default value of a column is not available in the INSERT RULE. The same value

[BUGS] Bug #920: The PostgreSql Server goes down

2003-03-25 Thread pgsql-bugs
Kallol Nandi ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description The PostgreSql Server goes down Long Description Hi, I am facing this problem when I start the PostgreSql database server and query any of the database.All the proce

[BUGS] Bug #919: Can't initialize a database cluster in Cygwin/PostgreSQL 7.3.2

2003-03-25 Thread pgsql-bugs
Stephane Decleire ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Can't initialize a database cluster in Cygwin/PostgreSQL 7.3.2 Long Description Hi, When I try to initialize a new database cluster in Cygwin / PostgreSQL 7.3.2,

[BUGS] Bug #918: pg_dump problem w/ SEQUENCE

2003-03-25 Thread pgsql-bugs
laurent faillie ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump problem w/ SEQUENCE Long Description Hi all, in order to correct bug #899, I have downloaded the current snapshot and I discover a new trouble w/ pg_dump.

[BUGS] Bug #917: SERVICE DENIAL ON XP

2003-03-24 Thread pgsql-bugs
Oluwatope Akinniyi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description SERVICE DENIAL ON XP Long Description 1. During Installation of Postgresql on Windows XP it defaults the service account to the Administrator which is not a pro

[BUGS] Bug #916: Unable to escape the char {.

2003-03-22 Thread pgsql-bugs
Balu Kunju ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Unable to escape the char {. Long Description I am Using psql (PostgreSQL) 7.2.2 version. I am unable to populate the value which contains the character '{'. I have ODB

[BUGS] Bug #915: problem with returning setof with double precision values

2003-03-21 Thread pgsql-bugs
Daniel Brozek ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description problem with returning setof with double precision values Long Description I have got the table and the function (look at example code). After executing this functio

[BUGS] Bug #914: Possible bug with regards to multiple persistant connections

2003-03-19 Thread pgsql-bugs
Philippe Hajjar ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Possible bug with regards to multiple persistant connections Long Description The operating environment in which this occurred is: Apache 1.3.27 PHP

[BUGS] Bug #913: plpgsql function fails on second call

2003-03-18 Thread pgsql-bugs
John Duffy ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description plpgsql function fails on second call Long Description A function containing a left outer join declared to return a set works correctly when first called. A second call

[BUGS] Bug #912: pg_restore cannot restore individual rule from custom dump

2003-03-17 Thread pgsql-bugs
Joseph Tate ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_restore cannot restore individual rule from custom dump Long Description pg_restore can restore individual triggers and tables, but cannot restore individual rules.

[BUGS] Bug #911: pg_dump/pg_restore fails when using triggers/rules on tables including large objects

2003-03-17 Thread pgsql-bugs
Joseph Tate ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump/pg_restore fails when using triggers/rules on tables including large objects Long Description If a table has a large object referenced in a column, but also has

[BUGS] Bug #910: query with inherits

2003-03-15 Thread pgsql-bugs
Igor ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description query with inherits Long Description In the next situation: CREATE TABLE main (f1 int4 NOT NULL, PRIMARY KEY(f1)); CREATE TABLE derived (f2 int4) INHERIT (main);

[BUGS] Bug #909: Website docs broken

2003-03-14 Thread pgsql-bugs
Daniel Quaroni ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Website docs broken Long Description I couldn't find a place to report bugs about the website, so I apologize for sending it to this address if it's not the correct

[BUGS] Bug #908: Can not INSERT Cyrilic characters when use UNICODE database

2003-03-10 Thread pgsql-bugs
Yuliyan Topalov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Can not INSERT Cyrilic characters when use UNICODE database Long Description Hi! There's a bug when use try to insert Cyrilic characters: Error number -214746

[BUGS] pgsql-bugs ¤Ñ¨Ïªº¬G¨Æ~~

2003-03-09 Thread pgsql-bugs
Title: ¤Ñ¨Ïªº¬G¨Æ    ¤Ñ¨Ïªº¬G¨Æ    ¤Ñ¨Ïªº¬G¨Æ [EMAIL PROTECTED]   [EMAIL PROTECTED]¤¤«×±J¡C ³o®a¤H¹ï¤Ñ¨Ï­Ì«Ü¤£«È®ð¡A¤S¤£­ã¥L­Ì¦í¦b¤j¦vªº«È©Ð¡C ©ó¬O¡A¥L­Ì°ß¦³¦í¦b¦B§Nªº¦a¨c¡C ·í¤Ñ¨Ï­Ì¦b°íµwªº¦a¤W·Ç³Æ§ÉçE®É¡A ¤j¤Ñ¨Ïµo²{Àð¤W¦³­Ó¬}¡A´N§â­×

[BUGS] Bug #907: psql 7.3.2 \d , \lmeta commands on windows

2003-03-09 Thread pgsql-bugs
Philip R Brenan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql 7.3.2 \d , \lmeta commands on windows Long Description The psql 7.3.2 \d, \l meta commands running on windowsXP produces: \d ERROR: parser: parse error at or

[BUGS] Bug #906: Web site bug in Docs

2003-03-06 Thread pgsql-bugs
Jack Neely ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Web site bug in Docs Long Description On the postgres web site at www.postgresql.org/docs the links to the static and interactive documentation are all very broken. Al

[BUGS] Bug #905: Postgree not working under XP (Italian Version)

2003-03-02 Thread pgsql-bugs
Davide Palmaghini ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Postgree not working under XP (Italian Version) Long Description I've downloaded PgSQL731wina1 and I tried to install it under Windows XP Italian Version. As I c

[BUGS] Bug #904: Deallocating of prepared statement in ECPG at COMMIT

2003-02-27 Thread pgsql-bugs
Jiri Langr ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Deallocating of prepared statement in ECPG at COMMIT Long Description When I prepare a statement in ECPG it lives only to first explicit transaction block. At the COMMI

[BUGS] Bug #903: Performance Hangs during Lookups

2003-02-24 Thread pgsql-bugs
Michael Peddemors ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Performance Hangs during Lookups Long Description We have a postgres backend to our Mail Server product, and encountering performance issues. Simple selects are

[BUGS] Hello pgsql-bugs !

2003-02-24 Thread pgsql-bugs
Dear pgsql-bugs , Hola! Hello! Como estas? How are you? I got your email address as someone involved with tourism, hotel and condo rentals. We are an award winning web design firm in the USA doing web applications for many companies, including hotels in 3 countries. We have references

[BUGS] Hello pgsql-bugs !

2003-02-24 Thread pgsql-bugs
Dear pgsql-bugs , Hola! Hello! Como estas? How are you? I got your email address as someone involved with tourism, hotel and condo rentals. We are an award winning web design firm in the USA doing web applications for many companies, including hotels in 3 countries. We have references

[BUGS] Bug #902: Build problems with 7.3.1 and 7.3.2 on SunOS (crypt.h) + Solution

2003-02-23 Thread pgsql-bugs
Fred Houweling ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Build problems with 7.3.1 and 7.3.2 on SunOS (crypt.h) + Solution Long Description Hi, As per request from Justin Clift [EMAIL PROTECTED] I think I have found a smal

[BUGS] Bug #900: Win32 Postgres ODBC driver does not allow 2 connections to a database at the same time

2003-02-21 Thread pgsql-bugs
Jim Kardias ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Win32 Postgres ODBC driver does not allow 2 connections to a database at the same time Long Description You cant connect to two data sources with the postgres 7.02.0005

[BUGS] Bug #899: pg_dumpall produce erroneous files if the databbase use procedural language.

2003-02-19 Thread pgsql-bugs
Laurent Faillie ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dumpall produce erroneous files if the databbase use procedural language. Long Description Hi all, I'm working to migrate my database from postgresql 7.2.2 to 7

[BUGS] Bug #898: client_encoding can't support GB18030 encoding in postgresql 7.3.1

2003-02-19 Thread pgsql-bugs
zzhb ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description client_encoding can't support GB18030 encoding in postgresql 7.3.1 Long Description When I insert records using files, psql -f install.sql if I set PGCLIENTENCODING=GB18030,

[BUGS] Bug #897: EXTRACT(EPOCH FROM column): Possible wrong output

2003-02-15 Thread pgsql-bugs
Jonas Bentzen (jonas at understroem dot dk) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description EXTRACT(EPOCH FROM column): Possible wrong output Long Description I'm not sure whether this is actually a bug, but here goes: If you define a column as TI

[BUGS] Bug #896: Column Constraint Not Working in ALTER TABLE ADD COLUMN?

2003-02-12 Thread pgsql-bugs
Tara Piorkowski ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Column Constraint Not Working in ALTER TABLE ADD COLUMN? Long Description According to the docs, you should be able to put a column constraint into an ALTER TABLE

[BUGS] Bug #895: incorrect error message when duplicate index name

2003-02-12 Thread pgsql-bugs
VIacheslav N Tararin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description incorrect error message when duplicate index name Long Description ERROR: relation named "pk_exchange_batch_idx" already exists Why relation when I create ind

[BUGS] Bug #894: different result with the same parameterlist in function call

2003-02-09 Thread pgsql-bugs
Kovacs Balazs ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description different result with the same parameterlist in function call Long Description I have written a simple function in C under pg (it uses regex lib): #include #include

[BUGS] Bug #893: Trigger causes database to crash

2003-02-05 Thread pgsql-bugs
Peter Childs ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Trigger causes database to crash Long Description I have a trigger that when in use on a table causes the postgresql database backend to crash with a segmentation fau

[BUGS] Bug #892: Java ant not usable on debian woody

2003-02-04 Thread pgsql-bugs
Terrell Larson ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Java ant not usable on debian woody Long Description The installer fails with a message that ANT is not available. Note: I wrote a script to do the install so that

[BUGS] Bug #891: CAP letters

2003-02-04 Thread pgsql-bugs
venu ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description CAP letters Long Description i want to port SQL server database to Postgresql,while porting i am encouting problem with capital letter table names and field names. is it ca

[BUGS] Bug #890: only one user per process in libpq with krb5 auth

2003-02-03 Thread pgsql-bugs
Ed Schaller ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description only one user per process in libpq with krb5 auth Long Description Most of the kerberos authentication information used to authenticate a connection to the server with

[BUGS] Bug #889: PQconnectdb SEGV

2003-01-29 Thread pgsql-bugs
Chris Brown ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PQconnectdb SEGV Long Description In the libpq C interface, PQconnectdb results in a SEGV when the conn->sock number is greater than __FD_SETSIZE (1024 on linux). The

[BUGS] Bug #887: pg_restore blocks

2003-01-26 Thread pgsql-bugs
Emmanuel Guyot ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_restore blocks Long Description I launch pg_restore from my Java programs with the following command : bash --login -c \"/usr/bin/pg_restore.exe -v -c -F c -d myb

[BUGS] Bug #886: jdbc "update row" can mess up other columns

2003-01-24 Thread pgsql-bugs
Andrew Fyfe ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description jdbc "update row" can mess up other columns Long Description The attached program when run gives me the following output DatabaseProductName: PostgreSQL DatabaseProduc

[BUGS] Bug #884: Schema access not inherited by functions declared SECURITY DEFINER

2003-01-24 Thread pgsql-bugs
Jason B. Alonso ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Schema access not inherited by functions declared SECURITY DEFINER Long Description When calling a function declared SECURITY DEFINER, I get permission denied error

[BUGS] Bug #883: explain analyze causes postgres to die

2003-01-23 Thread pgsql-bugs
Christopher Hodson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description explain analyze causes postgres to die Long Description running explain analyze on the code below causes postgres to crash. See below for error messages.

[BUGS] Bug #882: Cannot manually log in to database.

2003-01-23 Thread pgsql-bugs
Ben Kinsey ([EMAIL PROTECTED]; [EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Cannot manually log in to database. Long Description We are receiving the following error when trying to manually log in to the the database: okapvi

[BUGS] Bug #881: floor function returning double precision with integer arguments in 7.3, returns numeric in 7.2 with the same statement

2003-01-22 Thread pgsql-bugs
Allan Oepping ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description floor function returning double precision with integer arguments in 7.3, returns numeric in 7.2 with the same statement Long Description Return datatype of the floor

[BUGS] Bug #880: COMMENT ON DATABASE depends on current database

2003-01-22 Thread pgsql-bugs
Marcin Kaminski ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description COMMENT ON DATABASE depends on current database Long Description PostgreSQL has mechanism for commenting databases. Database comments can by read by obj_description

[BUGS] Bug #879: python interface broken by removal of pg_type.typprtlen

2003-01-21 Thread pgsql-bugs
Peter Harris ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description python interface broken by removal of pg_type.typprtlen Long Description Version 7.3.1, pg_type seems to no longer have a column called typprtlen. This is OK by me,

[BUGS] Bug #878: different format of float values in 7.2.and 7.3

2003-01-20 Thread pgsql-bugs
Denis N.Stepanov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description different format of float values in 7.2.and 7.3 Long Description There is a difference in return value of some floating point operations in PostgreSQL 7.2 and 7.3

[BUGS] Bug #877: numbers are no longer recognized as smallints

2003-01-19 Thread pgsql-bugs
Denis N. Stepanov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description numbers are no longer recognized as smallints Long Description I have bunch of functions (doesn't matter of which language) which take parameters as 'smallint's.

[BUGS] Bug #876: Bugs Inserts Arrays

2003-01-15 Thread pgsql-bugs
Walter ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Bugs Inserts Arrays Long Description Hi, Im Walter, from Brazil, and I use PG 7.2. (excuse my english!) The error: the last entrance (last array dimension) determine the dim

[BUGS] Bug #875: init script problem with reload

2003-01-15 Thread pgsql-bugs
philippe ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description init script problem with reload Long Description In the RPM from ftp, for postgresql 7.2.3 you have an error in the /etc/rc.d/init.d/postgresql reload The reload function

[BUGS] Bug #874: Install pgsql on solaris 8 error

2003-01-14 Thread pgsql-bugs
yuxia ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Install pgsql on solaris 8 error Long Description When I have run "initdb -D /sur/local/pgsql/data",it occured "create conversion --core dump" Sample Code No file was up

[BUGS] Bug #873: 7.3.1 install fails for RH7.3... cannot find ascii_and_mic.so

2003-01-13 Thread pgsql-bugs
Jeffrey Graham ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description 7.3.1 install fails for RH7.3... cannot find ascii_and_mic.so Long Description On a RH 7.3 machine using gcc 3.1, everything builds fine (set --prefix to a nonstanda

[BUGS] Bug #872: Cursor scrolling

2003-01-12 Thread pgsql-bugs
Artur Zajac ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Cursor scrolling Long Description There is some example in attachment. Sometimes after second fetch I had 0 rows (in other query). It seems that there is a bug in curs

[BUGS] Bug #871: FW: How to solve the problem

2003-01-11 Thread pgsql-bugs
Derek ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description FW: How to solve the problem Long Description NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally

[BUGS] Bug #870: subselect returns more than one tuple where not possible

2003-01-10 Thread pgsql-bugs
Bors Folgmann ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description subselect returns more than one tuple where not possible Long Description I'm using postgresql 7.2.2 on RedHat Linux 8.0. Inside a transaction (PL/pgSQL function) I u

[BUGS] Bug #869: varchar 's comparision

2003-01-09 Thread pgsql-bugs
trainee ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description varchar 's comparision Long Description SERVER: PGSQL 7.31 + MANDRAKE LINUX 8.1 CLIENT: VISIVAL FOXPRO 7.0 + PGSQLODBC 7.02 TABLE :MYTABLE M_ID VARCHAR(1

[BUGS] Bug #868: temp schema can't be clean automatically

2003-01-09 Thread pgsql-bugs
trainee ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description temp schema can't be clean automatically Long Description postgresql 7.31 + mandrake linux 8.1 when I create a temporary table, server will create temporary schema pg_te

[BUGS] Bug #867: CLUSTER does not rebuild referential integrity triggers

2003-01-08 Thread pgsql-bugs
Boris Folgmann ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description CLUSTER does not rebuild referential integrity triggers Long Description I've got the following behaviour using pgsql 7.2.2 on Linux: When clustering a table with C

[BUGS] Bug #866: Cursor scrolling broken in 7.3.1 (works in 7.2.1)

2003-01-08 Thread pgsql-bugs
Florian Wunderlich ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Cursor scrolling broken in 7.3.1 (works in 7.2.1) Long Description A MOVE BACKWARD after a FETCH in a cursor declared for a SELECT with a WHERE clause does not

[BUGS] Bug #865: PostgreSQL 7.3 and 7.3.1 fails to compile pg_dump

2003-01-07 Thread pgsql-bugs
D. Wright ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PostgreSQL 7.3 and 7.3.1 fails to compile pg_dump Long Description While I can get PostgreSQL 7.2 to compile fine on my machine (running FreeBSD), I can not get 7.3 or 7

[BUGS] Bug #864: MOD(RANDOM(),1.0) don't work in 7.3.1

2003-01-05 Thread pgsql-bugs
Sverre H. Huseby ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description MOD(RANDOM(),1.0) don't work in 7.3.1 Long Description I just upgraded from 7.2.3 to 7.3.1. Something has changed, as one of my old queries no longer works: S

  1   2   3   4   5   6   7   8   9   10   >