Re: [BUGS] BUG #5484: sum() bug

2010-06-02 Thread viras
Many thanks for the help! numeric is my choice :) 01.06.10, 19:19, Kevin Grittner kevin.gritt...@wicourts.gov: Robert Haas wrote: On Tue, Jun 1, 2010 at 9:24 AM, viras wrote: What type of the data is better for using? Numbers up to 10 and accuracy of 2 fractional signs.

[BUGS] Support on Postgres Database Corruption

2010-06-02 Thread botak
Dear sirs, Referring to the matter above. For your information, we are a government agency and been hosting a management system since 2006. The system was developed with Postgres Sql and PHP in Centos Platform. Recently, after a power failure, all the latest data from system were missing and the

[BUGS] canceling statement due to user request

2010-06-02 Thread Spangler, Todd
Dear PostgreSQL, I have been working with a web application that allows saving of reports to a text file using PostgreSQL. The application has worked fine for about 6 months and now we are getting the following 2 error messages: canceling statement due to statement timeout canceling

Re: [BUGS] canceling statement due to user request

2010-06-02 Thread Kevin Grittner
Spangler, Todd toddspang...@comsys.com wrote: canceling statement due to user request I cannot seem to fix. Your application is canceling queries, probably because they're not completing as quickly as it wants them to; that's not a PostgreSQL bug. You should probably gather a bit more

Re: [BUGS] Support on Postgres Database Corruption

2010-06-02 Thread Jaime Casanova
On Wed, Jun 2, 2010 at 8:38 AM, botak bota...@gmail.com wrote: Dear sirs, Referring to the matter above. For your information, we are a government agency and been hosting a management system since 2006. The system was developed with Postgres Sql and PHP in Centos Platform. Recently, after a

Re: [BUGS] BUG #5364: citext behavior when type not in public schema

2010-06-02 Thread Bruce Momjian
Robert Haas wrote: On Fri, Mar 5, 2010 at 5:24 AM, Markus Wichitill ma...@gmx.de wrote: The following bug has been logged online: Bug reference: ? ? ?5364 Logged by: ? ? ? ? ?Markus Wichitill Email address: ? ? ?ma...@gmx.de PostgreSQL version: 8.4.2 Operating system: ? Linux,

Re: [BUGS] BUG #5364: citext behavior when type not in public schema

2010-06-02 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: I have documented this citext limitation with the attached, applied patch. Are you planning to insert similar verbiage into every other contrib module's docs? regards, tom lane -- Sent via pgsql-bugs mailing list