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 concluded that a straightforward "insert into
select * from " would su
On Dec 20, 2011, at 12:12 AM, Dave Page wrote:
>> Would be handy for such output to appear somewhere in the job history…
>
> 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 fe
On Dec 20, 2011, at 12:14 AM, Dave Page wrote:
>> postgres=# select * from pgagent.pga_jobsteplog where jslresult <> 0;
>
> Can you show me that without the where clause please? If there's too
> much data, please filter by date to exclude lines that aren't on your
> original screenshot.
postgres
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 table in DB objects tree (stats has been changed to
present selected ta
On Mon, Dec 19, 2011 at 5:54 PM, David E. Wheeler wrote:
> On Dec 19, 2011, at 1:52 AM, Dave Page wrote:
>
> FYI, I have "On error" set to "Fail".
>
>
> What's actually in pgagent.pga_jobsteplog?
>
>
> postgres=# select * from pgagent.pga_jobsteplog where jslresult <> 0;
Can you show me that with
On Mon, Dec 19, 2011 at 5:50 PM, David E. Wheeler wrote:
> On Dec 19, 2011, at 1:51 AM, Dave Page wrote:
>
>> All of the internal logging goes to the file if specified, or stdout,
>> with the exception of a couple of serious errors, like "failed to open
>> the logfile". wxWidgets might be writing
