Re: [pgadmin-support] (Bug) Numeric fault calculation

2013-06-18 Thread David Johnston
Kanitchet Vaiassava wrote > (Bug) Numeric fault calculation > > postgresql : 714.355 > long division method: 714.356 FYI: My prior posts use a result cast "::text" in order to avoid any kind of interaction with how pgAdmin would handle numbers. This is not a pgadmin bug/issue it is

Re: [pgadmin-support] (Bug) Numeric fault calculation

2013-06-18 Thread David Johnston
Guillaume Lelarge-3 wrote > If you use a floating > point datatype (which is what happens when you don't specificy the > type), I covered this in my prior post but per the documentation this is incorrect. http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-CONSTAN

Re: [pgadmin-support] (Bug) Numeric fault calculation

2013-06-18 Thread David Johnston
Guillaume Lelarge-3 wrote > On Sun, 2013-06-16 at 04:59 -0700, Chirag Mittal wrote: >> Dear Kanitchet, >> >> Please try this >> >> SELECT (260739.94 * (1.00/365.00))::numeric(20,7) >> >> I am a beginner but I think we need to explicitly mention the "output" >> format required to get accuracy. >

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Marc Cooper
On 18/06/13 22:12, Guillaume Lelarge wrote: > On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: >> Hi, >> >> When in the SQL editor, I can no longer add queries to my favourites. >> >> I have added entries in the past, and I can see these and access them, >> but I can no longer add new entries

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Marc Cooper
On 18/06/13 22:12, Guillaume Lelarge wrote: > On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: >> Hi, >> >> When in the SQL editor, I can no longer add queries to my favourites. >> >> I have added entries in the past, and I can see these and access them, >> but I can no longer add new entries

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Michael Shapiro
Maybe he doesn't have a Favourites file path set in the Query Tool options? On Tue, Jun 18, 2013 at 4:12 PM, Guillaume Lelarge wrote: > On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: > > Hi, > > > > When in the SQL editor, I can no longer add queries to my favourites. > > > > I have added

Re: [pgadmin-support] pgAdmin with a driver to run Sql statements over multiple databases

2013-06-18 Thread Guillaume Lelarge
Hi, On Tue, 2013-06-04 at 13:57 -0700, Matthieu Labour wrote: > [...] > Is it possible for pgAdmin to execute SQL statements over multiple > databases? > > As an example, if one has done horizontal sharding with Databas01, > Database02...DatabaseN having the same schema and the data spread over t

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Guillaume Lelarge
On Tue, 2013-06-18 at 22:19 +0100, Marc Cooper wrote: > On 18/06/13 22:12, Guillaume Lelarge wrote: > > On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: > >> Hi, > >> > >> When in the SQL editor, I can no longer add queries to my favourites. > >> > >> I have added entries in the past, and I ca

Re: [pgadmin-support] Trucate Cascaded YES

2013-06-18 Thread Guillaume Lelarge
On Tue, 2013-06-04 at 11:36 -0300, Humberto Cereser Ibanez wrote: > Hello list, > > There was a sinister in all data on a table. > > Explaining > > My right button mouse started a defect that was doing multiples clicks > when pressed. > > I did wish to backup a table. Then I clicked with a righ

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Marc Cooper
On 18/06/13 22:12, Guillaume Lelarge wrote: > On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: >> Hi, >> >> When in the SQL editor, I can no longer add queries to my favourites. >> >> I have added entries in the past, and I can see these and access them, >> but I can no longer add new entries

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Guillaume Lelarge
On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: > Hi, > > When in the SQL editor, I can no longer add queries to my favourites. > > I have added entries in the past, and I can see these and access them, > but I can no longer add new entries as the menu item "Add favourite..." > is greyed ou

Re: [pgadmin-support] (Bug) Numeric fault calculation

2013-06-18 Thread Guillaume Lelarge
On Sun, 2013-06-16 at 04:59 -0700, Chirag Mittal wrote: > Dear Kanitchet, > > Please try this > > SELECT (260739.94 * (1.00/365.00))::numeric(20,7) > > I am a beginner but I think we need to explicitly mention the "output" > format required to get accuracy. > Nope, you simply need to use the

Re: [pgadmin-support] [GENERAL] Postgres DB crashing

2013-06-18 Thread AI Rumman
Stop the autovacuum process and try again. On Tue, Jun 18, 2013 at 1:31 PM, bhanu udaya wrote: > Hello, > Greetings. > > My PostgresSQL (9.2) is crashing after certain load tests. Currently, > postgressql is crashing when simulatenously 800 to 1000 threads are run on > a 10 million records sche

[pgadmin-support] Postgres DB crashing

2013-06-18 Thread bhanu udaya
Hello, Greetings. My PostgresSQL (9.2) is crashing after certain load tests. Currently, postgressql is crashing when simulatenously 800 to 1000 threads are run on a 10 million records schema. Not sure, if we have to tweak some more parameters of postgres. Currently, the postgressql is config

Re: [pgadmin-support] Server Instrumentation

2013-06-18 Thread Brett Maton
Have look see what postgres packages are available $ yum list | grep postgres My only other suggestion would be to install the postgresql yum repo package Brett -Original Message- From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf

Re: [pgadmin-support] Server Instrumentation

2013-06-18 Thread carlosinfl .
On Tue, Jun 18, 2013 at 1:13 AM, Brett Maton wrote: > Hi Carlos, > > I'm guessing you want the "adminpack" for use with pgadmin. > It's usually bundled in the postgresql92-contrib RPM with EL distros. > > As root install the package > # yum install postgresql92-contrib I am using Amazon EC2 A

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

2013-06-18 Thread Ashesh Vashi
Thanks Timon for point out. I already know about this - I've made that mistake and will resolve it very soon. Made some changes in pgQueryThread class, which leads to this bug. Actually - I was busy with some other stuff, and couldn't spend time on pgadmin3. On Tue, Jun 18, 2013 at 2:05 PM, Timon

Re: [pgadmin-support] bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane

2013-06-18 Thread Timon
seems that commit 140e8aee4cb5d423bb76ad81874e442d3e17b5c1 (Rewrite the debugger to resolve numerous known issues and instabilities mostly due to the threading code.) also broke ability to cancel query by pressing stop button in query editor 2013/5/16 Dave Page : > Ashesh - this appears to be rela