pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedoutput
7+ messages / 3 participants
[nested] [flat]
* output
@ 2003-10-02 08:52 Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 11:01 ` Re: output Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 7+ messages in thread
From: Popeanga Marian @ 2003-10-02 08:52 UTC (permalink / raw)
To: pgsql-sql
Hello all,
I am interested on how can i put output data for debugging
purposes. Any sample will be very good!
Thanks,
/Marian
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: output
2003-10-02 08:52 output Popeanga Marian <pmarian@cnlo.ro>
@ 2003-10-02 11:01 ` Richard Huxton <dev@archonet.com>
2003-10-02 11:09 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
0 siblings, 1 reply; 7+ messages in thread
From: Richard Huxton @ 2003-10-02 11:01 UTC (permalink / raw)
To: Popeanga Marian <pmarian@cnlo.ro>; pgsql-sql
On Thursday 02 October 2003 09:52, Popeanga Marian wrote:
> Hello all,
>
>
> I am interested on how can i put output data for debugging
> purposes. Any sample will be very good!
Output what data when? To what?
If you can describe your situation, I'm sure we can come up with something to
help.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: output
2003-10-02 08:52 output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 11:01 ` Re: output Richard Huxton <dev@archonet.com>
@ 2003-10-02 11:09 ` Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 12:17 ` Re: output Richard Huxton <dev@archonet.com>
2003-10-02 14:35 ` Re: output Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 7+ messages in thread
From: Popeanga Marian @ 2003-10-02 11:09 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
Richard Huxton wrote:
>On Thursday 02 October 2003 09:52, Popeanga Marian wrote:
>
>
>> Hello all,
>>
>>
>> I am interested on how can i put output data for debugging
>>purposes. Any sample will be very good!
>>
>>
>
>Output what data when? To what?
>
>If you can describe your situation, I'm sure we can come up with something to
>help.
>
>
>
Inside a plpgsql block .
RAISE NOTICE ''Operation performed!'';
Now if i don't use psql from where i can read the output ?
Thanks,
/Marian
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: output
2003-10-02 08:52 output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 11:01 ` Re: output Richard Huxton <dev@archonet.com>
2003-10-02 11:09 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
@ 2003-10-02 12:17 ` Richard Huxton <dev@archonet.com>
1 sibling, 0 replies; 7+ messages in thread
From: Richard Huxton @ 2003-10-02 12:17 UTC (permalink / raw)
To: Popeanga Marian <pmarian@cnlo.ro>; +Cc: pgsql-sql
On Thursday 02 October 2003 12:09, Popeanga Marian wrote:
>
> Inside a plpgsql block .
> RAISE NOTICE ''Operation performed!'';
>
> Now if i don't use psql from where i can read the output ?
Ah - I think you need to set CLIENT_MIN_MESSAGES accordingly and then you can
check for a non-fatal error code in your result-code. Never done it myself
mind.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: output
2003-10-02 08:52 output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 11:01 ` Re: output Richard Huxton <dev@archonet.com>
2003-10-02 11:09 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
@ 2003-10-02 14:35 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-10-03 04:09 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
1 sibling, 1 reply; 7+ messages in thread
From: Tom Lane @ 2003-10-02 14:35 UTC (permalink / raw)
To: Popeanga Marian <pmarian@cnlo.ro>; +Cc: Richard Huxton <dev@archonet.com>; pgsql-sql
Popeanga Marian <pmarian@cnlo.ro> writes:
> Now if i don't use psql from where i can read the output ?
If you're using libpq directly, you can install a notice processor hook
routine to catch NOTICE messages. Otherwise they go to stderr.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: output
2003-10-02 08:52 output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 11:01 ` Re: output Richard Huxton <dev@archonet.com>
2003-10-02 11:09 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 14:35 ` Re: output Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-10-03 04:09 ` Popeanga Marian <pmarian@cnlo.ro>
2003-10-06 13:32 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
0 siblings, 1 reply; 7+ messages in thread
From: Popeanga Marian @ 2003-10-03 04:09 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Richard Huxton <dev@archonet.com>; pgsql-sql
I am using libpg inside a plugin.
For oracle conections i can read the server output with this package
dbms_output.read_line (... ).
For pgsql is something similar for reading server output ?
Tom Lane wrote:
>Popeanga Marian <pmarian@cnlo.ro> writes:
>
>
>>Now if i don't use psql from where i can read the output ?
>>
>>
>
>If you're using libpq directly, you can install a notice processor hook
>routine to catch NOTICE messages. Otherwise they go to stderr.
>
> regards, tom lane
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: output
2003-10-02 08:52 output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 11:01 ` Re: output Richard Huxton <dev@archonet.com>
2003-10-02 11:09 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 14:35 ` Re: output Tom Lane <tgl@sss.pgh.pa.us>
2003-10-03 04:09 ` Re: output Popeanga Marian <pmarian@cnlo.ro>
@ 2003-10-06 13:32 ` Popeanga Marian <pmarian@cnlo.ro>
0 siblings, 0 replies; 7+ messages in thread
From: Popeanga Marian @ 2003-10-06 13:32 UTC (permalink / raw)
To: Popeanga Marian <pmarian@cnlo.ro>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Richard Huxton <dev@archonet.com>; pgsql-sql
Popeanga Marian wrote:
>
> I am using libpg inside a plugin.
> For oracle conections i can read the server output with this package
> dbms_output.read_line (... ).
> For pgsql is something similar for reading server output ?
>
> Tom Lane wrote:
>
>>Popeanga Marian <pmarian@cnlo.ro> writes:
>>
>>
>>>Now if i don't use psql from where i can read the output ?
>>>
>>>
>>
>>If you're using libpq directly, you can install a notice processor hook
>>routine to catch NOTICE messages. Otherwise they go to stderr.
>>
>> regards, tom lane
>>
>>
>>
>
Can you tell me more about how to install a notice processor hook
routine to catch NOTICE messages ?
Thanks,
/Marian
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2003-10-06 13:32 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-02 08:52 output Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 11:01 ` Richard Huxton <dev@archonet.com>
2003-10-02 11:09 ` Popeanga Marian <pmarian@cnlo.ro>
2003-10-02 12:17 ` Richard Huxton <dev@archonet.com>
2003-10-02 14:35 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-10-03 04:09 ` Popeanga Marian <pmarian@cnlo.ro>
2003-10-06 13:32 ` Popeanga Marian <pmarian@cnlo.ro>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox