X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 475BA52861
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun, 22 May 2005 04:21:55 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 19995-04
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun, 22 May 2005 07:21:46 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.201])
	by svr1.postgresql.org (Postfix) with ESMTP id 167FB52868
	for <pgsql-interfaces@postgresql.org>;
	Sun, 22 May 2005 04:21:43 -0300 (ADT)
Received: by wproxy.gmail.com with SMTP id 68so1758800wri
	for <pgsql-interfaces@postgresql.org>;
	Sun, 22 May 2005 00:22:24 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=kDf+mPms5n8QP4wOfpf/Mv5j5skSU50HbKWuCMlcDPFCdm2NXx4JBHLndWulcKPPdNHMfIj3D4a4ORYheHtOOEBprkdmaqhTPwRizRiRlQ3cR2rqMtPXERbh8Gf6PBgfpT5eJ4QRgUnopAz3tySs/KPjP7/V7oNzI+QQl0fKHKo=
Received: by 10.54.16.60 with SMTP id 60mr2379321wrp;
	Sun, 22 May 2005 00:22:24 -0700 (PDT)
Received: by 10.54.30.45 with HTTP; Sun, 22 May 2005 00:22:24 -0700 (PDT)
Message-ID: <7104a737050522002267997cef@mail.gmail.com>
Date: Sun, 22 May 2005 10:22:24 +0300
From: Volkan YAZICI <volkan.yazici@gmail.com>
Reply-To: Volkan YAZICI <volkan.yazici@gmail.com>
To: Gustavo Lopes <contratempo@gmail.com>
Subject: Re: libpq on windows
Cc: pgsql-interfaces@postgresql.org
In-Reply-To: <2b5c484b0505201643d628432@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <2b5c484b05051906526f8bb577@mail.gmail.com>
	<20704.202.47.227.25.1116570741.squirrel@202.47.227.25>
	<2b5c484b05052006206c301de@mail.gmail.com>
	<2b5c484b05052009545a310cd7@mail.gmail.com>
	<27068.1116615085@sss.pgh.pa.us>
	<2b5c484b0505201643d628432@mail.gmail.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.331 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, RCVD_BY_IP
X-Spam-Level: 
X-Archive-Number: 200505/55
X-Sequence-Number: 5558

Hi,

On 5/21/05, Gustavo Lopes <contratempo@gmail.com> wrote:
> Is there any easy (ie, no C postgres functions)  way to generate
> multi-line error messages so that I can explore that possibility?

One way of generating mult-line error messages could be increasing
verbosity level:

=3D> \set verbosity verbose

=3D> CREATE TABLE del_me_1 (id1 integer PRIMARY KEY);
=3D> CREATE TABLE del_me_2 (id2 integer REFERENCES del_me_1 (id1) );

=3D> DROP TABLE del_me_1;
NOTICE:  constraint del_me_2_id2_fkey on table del_me_2 depends on
table del_me_1
ERROR:  cannot drop table del_me_1 because other objects depend on it
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

HTH.
Regards.