public inbox for [email protected]  

help / color / mirror / Atom feed

From: rx <[email protected]>
To: Dave Page <[email protected]>
To: [email protected]
Cc: [email protected]
Cc: pgadmin-hackers <[email protected]>
Subject: how can I get Error-message from postgresql in linux shell script
Date: Fri, 28 Mar 2003 13:18:53 +0100
Message-ID: <003a01c2f524$3398b9b0$16e1f48a@IPSM7N> (raw)
References: <[email protected]>

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: <[email protected]>
To: "rx" <[email protected]>
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" <[email protected]>
>
> 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:
>   [email protected]
>



Attachments:

  [application/octet-stream] faxrcvd (7.1K, 3-faxrcvd)
  download

view thread (4+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: how can I get Error-message from postgresql in linux shell script
  In-Reply-To: <003a01c2f524$3398b9b0$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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox