No title

Hi Rong,

for everything more sophisticated then blindfolded top down execution of
statements, I strongly recommend using a better scripting language than
sh or bash (like Tcl or perl).

Jan

rx wrote:

hallo,

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

Name: faxrcvd
faxrcvd Type: unspecified type (application/octet-stream)
Encoding: quoted-printable

---------------------------------------------------------------

---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #