Thread: Re: Messages o Terminal

On 3/4/25 22:28, Igor Korot wrote:
> Hi, ALL,
> I'm trying to execute:
> 
> [code]
>      queries.push_back( L"CREATE TABLE IF NOT EXISTS ......
> [/code]
> 
> However, when I run my profeam second tme I see n the Terminal:
> 
> [quote]
> NOTICE:  relation "abcatcol" already exists, skipping
> [/quote]
> 
> Is there any way to suppress this NOTICE message?

 From here:

https://www.postgresql.org/docs/current/runtime-config-client.html

SET set client_min_messages = <something above NOTICE>;

You could that for just the session.


> 
> Thank you.
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

Hi, ALL,
I'm trying to execute:

[code]
    queries.push_back( L"CREATE TABLE IF NOT EXISTS ......
[/code]

However, when I run my profeam second tme I see n the Terminal:

[quote]
NOTICE:  relation "abcatcol" already exists, skipping
[/quote]

Is there any way to suppress this NOTICE message?

Thank you.

Adran,

On Tue, Mar 4, 2025 at 7:13 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 3/4/25 22:28, Igor Korot wrote:
> > Hi, ALL,
> > I'm trying to execute:
> >
> > [code]
> >      queries.push_back( L"CREATE TABLE IF NOT EXISTS ......
> > [/code]
> >
> > However, when I run my profeam second tme I see n the Terminal:
> >
> > [quote]
> > NOTICE:  relation "abcatcol" already exists, skipping
> > [/quote]
> >
> > Is there any way to suppress this NOTICE message?
>
>  From here:
>
> https://www.postgresql.org/docs/current/runtime-config-client.html
>
> SET set client_min_messages = <something above NOTICE>;

Isn't NOTICE the default one?

Thank you,

>
> You could that for just the session.
>
>
> >
> > Thank you.
> >
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>

Please ignore my previous message....

Works like a charm.

Thank you.

On Tue, Mar 4, 2025 at 7:13 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 3/4/25 22:28, Igor Korot wrote:
> > Hi, ALL,
> > I'm trying to execute:
> >
> > [code]
> >      queries.push_back( L"CREATE TABLE IF NOT EXISTS ......
> > [/code]
> >
> > However, when I run my profeam second tme I see n the Terminal:
> >
> > [quote]
> > NOTICE:  relation "abcatcol" already exists, skipping
> > [/quote]
> >
> > Is there any way to suppress this NOTICE message?
>
>  From here:
>
> https://www.postgresql.org/docs/current/runtime-config-client.html
>
> SET set client_min_messages = <something above NOTICE>;
>
> You could that for just the session.
>
>
> >
> > Thank you.
> >
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>