Re: [pgadmin-support] Column not wide enough for data

2012-01-02 Thread Guy Rouillier
On 1/2/2012 4:40 PM, Guillaume Lelarge wrote: On Tue, 2011-12-20 at 22:29 -0500, Guy Rouillier wrote: I wanted to copy a table to another table, so I started by getting a count of the rows in the source table. The result of "select count(*) from " came out like this: count bigint -- 26

Re: [pgadmin-support] CREATE CONSTRAINT TRIGGER in SQL pane (pgAdmin 1.14.1)

2012-01-02 Thread Guillaume Lelarge
On Mon, 2011-12-19 at 10:50 +0100, Guillaume Lelarge wrote: > On Thu, 2011-12-15 at 15:39 +0200, Julius Tuskenis wrote: > > Hello, > > > > After installing pgAdmin 1.14.1 I have noticed that CREATE CONSTRAINT > > TRIGGER statements are shown in SQL pane when selecting table from > > treeview. Is

Re: [pgadmin-support] Column not wide enough for data

2012-01-02 Thread Guillaume Lelarge
On Tue, 2011-12-20 at 22:29 -0500, Guy Rouillier wrote: > I wanted to copy a table to another table, so I started by getting a > count of the rows in the source table. The result of "select count(*) > from " came out like this: > > count > bigint > -- > 26569 > > Based on that, I concl

Re: [pgadmin-support] Tables stat refresh error

2012-01-02 Thread Guillaume Lelarge
On Tue, 2011-12-20 at 10:26 +0100, bdmyt...@eranet.pl wrote: > Hi all, > I think there is a bug in refresh table stats functionality. > Scenario is: > 1. Click on "Tables" node in DB objects tree > 2. Click on "Stats" tab - You can see correct stats for all tables in schema > 3. Click on particular

Re: [pgadmin-support] pgAgent STDERR and Time Zone Questions

2012-01-02 Thread David E. Wheeler
On Dec 20, 2011, at 6:00 PM, David E. Wheeler wrote: >> Oh, OK. We use popen() to execute the task on *nix, and that only >> reads STDOUT, so you should handle redirection in your script. I did >> spend some time look at this a few years back as I recall, and didn't >> find a fix I was happy with.