From: rx <rong.xie@stud.tu-muenchen.de>
To: Dave Page <dpage@vale-housing.co.uk>
To: pgsql-docs@postgresql.org
Cc: pgadmin-support@postgresql.org
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Subject: Re: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
Date: Fri, 28 Mar 2003 13:16:39 +0100
Message-ID: <001901c2f523$e2d510f0$16e1f48a@IPSM7N> (raw)
References: <03AF4E498C591348A42FC93DEA9661B86825@mail.vale-housing.co.uk>
Messagehallo,
my Name is Rong. I am student at TU-Munich. I have some questions for
Postgresql under SuSe Linux.
I want save something in Postgresql-Table, when I get a fax from "Hylafax".
I insert "
psql -U postgres dbname <<END_OF_INSTR
insert into "CSID_TIF"("CSID","suspens_file","actDatum")
values('0049891234567','test.tif','01.01.2003'))
END_OF_INSTR "
in shell script.
It work very good.
Now I want enhance it.
When there are some error in Postgresql, or There are some Error at insert,
I want give a message per email to me.
But I do not know, how can I get the Error from Postgresql in Linux Shell
Script.
When an Postgresql-Error is to happen, how can I get the Error-Message-Event
in shell script and send a email to me.
I hope I can get your Help!
Thank you very much!
best regards!
rong
PS: faxrcvd is my shell-script in Hylafax.
#! /bin/sh
psql -U postgres dbname <<END_OF_INSTR
insert into "CSID_TIF"("CSID","suspens_file","actDatum")
values('0049891234567','test.tif','01.01.2003'))
END_OF_INSTR
##end script
----- Original Message -----
From: <pgsql-general-owner@postgresql.org>
To: "rx" <rong.xie@stud.tu-muenchen.de>
Sent: Thursday, March 27, 2003 4:03 PM
Subject: Stalled post to pgsql-general
> Your message to pgsql-general has been delayed, and requires the approval
> of the moderators, for the following reason(s):
>
> Non-Member Submission from "rx" <rong.xie@stud.tu-muenchen.de>
>
> If you do not wish the message to be posted, or have other concerns,
> please send a message to the list owners at the following address:
> pgsql-general-owner@postgresql.org
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: rong.xie@stud.tu-muenchen.de, dpage@vale-housing.co.uk, pgadmin-support@postgresql.org, pgadmin-hackers@postgresql.org
Subject: Re: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
In-Reply-To: <001901c2f523$e2d510f0$16e1f48a@IPSM7N>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox