RE: now getting log messages!

2018-05-31 Thread Ian Bell
- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: 31 May, 2018 16:24 To: i...@ianbellsoftware.com; pgsql-general@lists.postgresql.org Subject: Re: now getting log messages! On 05/31/2018 01:03 PM, Ian Bell wrote: > Hello Adrian, > > Your suggestions have changed something and my me

now getting log messages!

2018-05-31 Thread Ian Bell
write 'raise' messages to log file? On 05/31/2018 12:18 PM, Ian Bell wrote: > Hello Adrian, > > Yes, if I call the function in PSQL then the expected message is displayed > the console display. Here is what is displayed in PSQL: > > testdb=# select * from

RE: unable to write 'raise' messages to log file?

2018-05-31 Thread Ian Bell
ailto:adrian.kla...@aklaver.com> <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> wrote: On 05/31/2018 11:20 AM, Ian Bell wrote: I am having considerable difficulty logging information in PL-pgSQL functions by using the ‘RAISE’ sta

RE: unable to write 'raise' messages to log file?

2018-05-31 Thread Ian Bell
r [mailto:adrian.kla...@aklaver.com] Sent: 31 May, 2018 15:07 To: i...@ianbellsoftware.com; pgsql-general@lists.postgresql.org Subject: Re: unable to write 'raise' messages to log file? On 05/31/2018 11:20 AM, Ian Bell wrote: > I am having considerable difficulty logging information in P

unable to write 'raise' messages to log file?

2018-05-31 Thread Ian Bell
I am having considerable difficulty logging information in PL-pgSQL functions by using the 'RAISE' statement.I am asking for comments/suggestions on what I am doing wrong. Each time I restart the server then server startup messages appear in the log file. In addition, changing the message

RE: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Ian Bell
ebugger - unable to call ltree functions "Ian Bell" writes: > I just tried your suggestion and it generates the same error. For > verification, here is the function run in the debugger. I just realized that "syntax error at position N" is *not* the exact spelling you w

RE: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Ian Bell
<mailto:i...@ianbellsoftware.com> ; pgsql-general@lists.postgresql.org <mailto:pgsql-general@lists.postgresql.org> Subject: Re: PGAdmin4 debugger - unable to call ltree functions On 04/26/2018 01:22 PM, Ian Bell wrote: > I have recently started working with the PGAdmin4 debugger and have &

PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Ian Bell
I have recently started working with the PGAdmin4 debugger and have encountered a particular problem when testing my own functions that, in turn, call functions from the ltree module. The sample code below successfully runs in PSQL. However, it fails when run in the PGAdmin4 debugger. Specifi