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
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
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.
>
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
18 matches
Mail list logo