hmmm. someone on this list has an overactive spam filter. leaving full headers and stuff so the list admins can decide what to do about it, if anything.

btw, if the user at the bouncing domain happens to see this.... its very VERY rude to bounce spam based on the 'from' address as 90% of -real- spam has forged from addresses, so you'll just be spamming some innocent third party's mailbox.



-------- Original Message --------
Subject:        failure notice
Date:   18 May 2010 02:45:44 -0000
From:   [email protected]
To:     [email protected]



Hi. This is the qmail-send program at burntmail.com.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.

<[email protected]>:
Sorry - The message you have sent was identified as spam by Spam Assassin 
(message bounced)

--- Below this line is a copy of the message.

Return-Path: <[email protected]>
Received: (qmail 17830 invoked from network); 18 May 2010 02:45:43 -0000
Received: from unknown (74.52.149.146)
 by burntmail.com with SMTP; 18 May 2010 02:45:43 -0000
From [email protected] Mon May 17 21:43:53 2010
Return-path: <[email protected]>
Envelope-to: [email protected]
Delivery-date: Mon, 17 May 2010 21:43:53 -0500
Received: from [200.46.204.254] (helo=mx2.hub.org)
        by mx01.burntspam.com with esmtp (Exim 4.63)
        (envelope-from <[email protected]>)
        id 1OECmf-0004PR-Ge
        for [email protected]; Mon, 17 May 2010 21:43:53 -0500
Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
        by mx2.hub.org (Postfix) with ESMTP id A66983EACB2F;
        Mon, 17 May 2010 20:39:51 -0300 (ADT)
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
        by mail.postgresql.org (Postfix) with ESMTP id BEC40633798
        for <[email protected]>; Mon, 17 May 
2010 20:39:19 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024)
with ESMTP id 98420-01
for <[email protected]>;
Mon, 17 May 2010 23:39:11 +0000 (UTC)
X-BMDA-Edge: IPR=1,DYN=0,SRB=0,SPM=8.5,BTS=0,RBL=0,HIS=0,WHT=0,STR=0
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hogranch.com (hogranch.com [75.101.82.47])
        by mail.postgresql.org (Postfix) with ESMTP id 85F456336DF
        for <[email protected]>; Mon, 17 May 2010 20:39:12 -0300 
(ADT)
Received: from [192.168.0.2] (porker [192.168.0.2])
        by hogranch.com (8.11.6/8.11.6) with ESMTP id o4HNd2L26781
        for <[email protected]>; Mon, 17 May 2010 16:39:02 -0700
Message-ID: <[email protected]>
Date: Mon, 17 May 2010 16:38:57 -0700
From: John R Pierce <[email protected]>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: [email protected]
Subject: Re: [GENERAL] which function should i invoke to create a table and
        insert tuples?
References: <[email protected]>         
<[email protected]> 
<[email protected]>
In-Reply-To: <[email protected]>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-HawgScanner-Information: Please contact the ISP for more information
X-HawgScanner: Found to be clean
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: X-Mailing-List: pgsql-general
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:[email protected]?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:[email protected]>
List-Post: <mailto:[email protected]>
List-Subscribe: <mailto:[email protected]?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-general>
Precedence: bulk
Sender: [email protected]
X-Relayed-For: (mx2.hub.org) [200.46.204.254]

sunpeng wrote:
it's in source codes,actually i'm writting codes in postgresql source codes,just to verify some of my ideas. C language is used.

you would pass the SQL statements to do what you want to the various libpq library functions...


something like...

   PGconn *conn;
   PGresult *res;

   conn = PQconnectdb("dbname=mydatabase");
   if (PQstatus(conn) != CONNECTION_OK) {
   fprintf(stderr, "Connection to database failed: %s",
   PQerrorMessage(conn));
   exit_nicely(conn);
   }

   res = PQexec(conn, "create table test (id serial, num int, value
   text);");
   if (PQresultStatus(res) != PGRES_COMMAND_OK) {
   fprintf(stderr, "BEGIN command failed: %s", PQerrorMessage(conn));
   PQclear(res);
   exit_nicely(conn);
   }
       ...



most folks would probably put the PQexec() and status tests into a function to simplify things.


--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to