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

On Tue, Mar 4, 2025 at 6:07 PM Igor Korot <ikorot01@gmail.com> wrote:

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

Is there any way to suppress this NOTICE message?

Specifically, no. Any notice message, yes.

https://www.postgresql.org/docs/current/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT

See: client_min_messages

David J.

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,

Please ignore my previous message....

Works like a charm.

Thank you.