Re: [GENERAL] Need to run a job in PgAdmin-III

2012-09-24 Thread pavithra
I dont get my psql console itself disabled in the plug-ins menu.Is there a way i can see the error log?. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Need-to-run-a-job-in-PgAdmin-III-tp5725093p5725110.html Sent from the PostgreSQL - general mailing list archive at Na

Re: [GENERAL] Need to run a job in PgAdmin-III

2012-09-24 Thread Leif Biberg Kristensen
Mandag 24. september 2012 11.06.32 skrev pavithra : > I have a scheduled a sql query as "select sysdate from dual" and i have > given as "Data Export". That's an Oraclism. Have you actually tested the query in psql? postgres=> select sysdate from dual; ERROR: relation "dual" does not exist LINE

Re: [GENERAL] Need to run a job in PgAdmin-III

2012-09-24 Thread pavithra
I have a scheduled a sql query as "select sysdate from dual" and i have given as "Data Export". Moreover i cant see the debugger option, or any error log where i can see it, Can you tell me any suggestions on this?. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Need

Re: [GENERAL] Need to run a job in PgAdmin-III

2012-09-24 Thread Raghavendra
On Mon, Sep 24, 2012 at 12:27 PM, John R Pierce wrote: > On 09/23/12 11:24 PM, pavithra wrote: > >> I have pgAdmin-III. It has version 1.12.3. I would like to run a job. I >> have schedule an SQL Job. But when i run there is no output. Can anybody >> let me know what needs to be done?. Also, Can

Re: [GENERAL] Need to run a job in PgAdmin-III

2012-09-23 Thread John R Pierce
On 09/23/12 11:24 PM, pavithra wrote: I have pgAdmin-III. It has version 1.12.3. I would like to run a job. I have schedule an SQL Job. But when i run there is no output. Can anybody let me know what needs to be done?. Also, Can any one tell, where i need to look for the errors, when i run a jo

[GENERAL] Need to run a job in PgAdmin-III

2012-09-23 Thread pavithra
I have pgAdmin-III.It has version 1.12.3.I would like to run a job. I have schedule an SQL Job. But when i run there is no output.Can anybody let me know what needs to be done?.Also, Can any one tell, where i need to look for the errors, when i run a job?. -- View this message in context: http: