X-Original-To: pgadmin-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DCBD847580B; Fri, 28 Mar 2003 07:16:44 -0500 (EST) Received: from mailrelay1.lrz-muenchen.de (mailrelay1.lrz-muenchen.de [129.187.254.101]) by postgresql.org (Postfix) with ESMTP id 8C53F474E44; Fri, 28 Mar 2003 07:16:43 -0500 (EST) Received: from [138.245.10.1] by mailout.lrz-muenchen.de; Fri, 28 Mar 2003 13:16:41 +0100 Message-Id: <001901c2f523$e2d510f0$16e1f48a@IPSM7N> From: "rx" To: "Dave Page" , Cc: , "pgadmin-hackers" References: <03AF4E498C591348A42FC93DEA9661B86825@mail.vale-housing.co.uk> Subject: Re: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL Date: Fri, 28 Mar 2003 13:16:39 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C2F52C.44676C70" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-16.0 required=5.0 tests=BAYES_30,HTML_20_30,ORIGINAL_MESSAGE,QUOTED_EMAIL_TEXT, REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/114 X-Sequence-Number: 942 This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C2F52C.44676C70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 < To: "rx" 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" > > 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 > ------=_NextPart_000_0016_01C2F52C.44676C70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
hallo,

my Name is Rong. I am student at TU-Munich. I have s= ome=20 questions for
Postgresql under SuSe Linux.

I want save something = in=20 Postgresql-Table, when I get a fax from "Hylafax".

I insert "
psql=20 -U postgres dbname <<END_OF_INSTR

insert into=20 "CSID_TIF"("CSID","suspens_file","actDatum")
values('0049891234567','tes= t.tif','01.01.2003'))

END_OF_INSTR=20 "

in shell script.

It work very good.

Now I want enhan= ce=20 it.

When there are some error in Postgresql, or There are some Error= at=20 insert,
I want give a message per email to me.

But I do not know,= =20 how  can I get the Error from Postgresql in Linux=20 Shell
Script.

When an Postgresql-Error is to happen, how can I ge= t the=20 Error-Message-Event
in shell script and send a email to me.

I hop= e I=20 can get your Help!

Thank you very much!

best=20 regards!

rong

PS: faxrcvd is my shell-script in Hylafax.
<= BR>#!=20 /bin/sh

psql -U postgres dbname <<END_OF_INSTR

insert i= nto=20 "CSID_TIF"("CSID","suspens_file","actDatum")
values('0049891234567','tes= t.tif','01.01.2003'))

END_OF_INSTR

##end=20 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=20 to pgsql-general


> Your message to pgsql-general has been del= ayed,=20 and requires the approval
> of the moderators, for the following=20 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=20 other concerns,
> please send a message to the list owners at the=20 following address:
>   pgsql-general-owner@postgresql.org
>
------=_NextPart_000_0016_01C2F52C.44676C70--