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

2010-06-02 Thread Tom Lane
Bruce Momjian 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 (pgsql-bugs@postgresql.org) To

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 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] Support on Postgres Database Corruption

2010-06-02 Thread Jaime Casanova
On Wed, Jun 2, 2010 at 8:38 AM, botak 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 power fail

Re: [BUGS] canceling statement due to user request

2010-06-02 Thread Kevin Grittner
"Spangler, Todd" 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 information and post to

[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 statemen

[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

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" : > 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. > > > > numeric is