Skip site navigation (1) Skip section navigation (2)

Re: libpq on windows

From: Volkan YAZICI <volkan(dot)yazici(at)gmail(dot)com>
To: Gustavo Lopes <contratempo(at)gmail(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: libpq on windows
Date: 2005-05-22 07:22:24
Message-ID: 7104a737050522002267997cef@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

On 5/21/05, Gustavo Lopes <contratempo(at)gmail(dot)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:

=> \set verbosity verbose

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

=> 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.

In response to

pgsql-interfaces by date

Next:From: Magnus HaganderDate: 2005-05-22 13:18:03
Subject: Re: libpq on windows
Previous:From: sqlDate: 2005-05-21 22:39:44
Subject: MacOS Interface ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group