[Fwd: failure notice] - Mailing list pgsql-general

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:     MAILER-DAEMON@burntmail.com
To:     pierce@hogranch.com



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.

<guyr-ml1@burntmail.com>:
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: <pierce@hogranch.com>
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 pgsql-general-owner+M163043@postgresql.org Mon May 17 21:43:53 2010
Return-path: <pgsql-general-owner+M163043@postgresql.org>
Envelope-to: guyr-ml1@burntmail.com
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 <pgsql-general-owner+M163043@postgresql.org>)
    id 1OECmf-0004PR-Ge
    for guyr-ml1@burntmail.com; 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 <pgsql-general-postgresql.org@mail.postgresql.org>; 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 <pgsql-general-postgresql.org@mail.postgresql.org>;
 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 <pgsql-general@postgresql.org>; 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 <pgsql-general@postgresql.org>; Mon, 17 May 2010 16:39:02 -0700
Message-ID: <4BF1D391.7000109@hogranch.com>
Date: Mon, 17 May 2010 16:38:57 -0700
From: John R Pierce <pierce@hogranch.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] which function should i invoke to create a table and
     insert tuples?
References: <AANLkTik3M_WUyPgQe9wMi2v23Hmd9N2p5-ewGV5mSorM@mail.gmail.com>     <4BF1C0EA.3080008@burntmail.com>
<AANLkTimASu3Z2HZoMfEernYWW-Yf5DXanoxCgaLj-YGV@mail.gmail.com>
In-Reply-To: <AANLkTimASu3Z2HZoMfEernYWW-Yf5DXanoxCgaLj-YGV@mail.gmail.com>
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:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org
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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general