Postgres Pro
Downloads
Home   >   mailing lists

Thread:

From
Ramesh T
Date:
Hi all,
as i mentioned above i have function called delete parts

can i mention select deleteparts();
          or

c:\programfiles\9.4\pgagent\check.sql in this path check.sql contain to delete parts.i placed query select deleteparts();

when click run now job,it returns statistics failed and etc/pg_log not contian any error please suggest How to solve this..



Re:

From
Melvin Davidson
Date:
Sorry, my crystal ball is not working today.

What is the PostgreSQL version?
What is the O/S?
What is the function definition?
Where are you executing that command from?
What is the error in the postgres log?

Help us to help you. Please don't ask open ended questions
without providing as much detail as possible.

On Wed, Apr 29, 2015 at 6:27 AM, Ramesh T <rameshparnanditech@gmail.com> wrote:
Hi all,
as i mentioned above i have function called delete parts

can i mention select deleteparts();
          or

c:\programfiles\9.4\pgagent\check.sql in this path check.sql contain to delete parts.i placed query select deleteparts();

when click run now job,it returns statistics failed and etc/pg_log not contian any error please suggest How to solve this..






--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.