HMG + Postgres + modo console

[Fabio_Tontini]

Hello, testing database access Postgree and is running nice but
when I use the command to create a table as shown below it returns a warning notice,
but I wanted to disable the warning. I am compiling in console mode.

cQuery := 'CREATE TABLE test('
cQuery += ' Code integer not null primary key, '
cQuery += ' Name Varchar(40), '
cQuery += ' Salary Double Precision, '
cQuery += ' Creation Date, '
cQuery += ' Description text ) '
oQuery := oServer:Query(cQuery)

The warning message that comes back is:

NOTE: CREATE TABLE / PRIMARY KEY create implicit index "test_pkey" in table "test"

The question is: how do I not see this message because it overrides what is written on the screen?

Another problem I found is that if I use the function traceon (file), apparently the program does not create the file.

If you can help thank you.

Fabio Tontini

[raumi75]

The warning message that comes back is:

NOTE: CREATE TABLE / PRIMARY KEY create implicit index "test_pkey" in table "test"

The question is: how do I not see this message because it overrides what is written on the screen?

You could reconfigure PostgreSQL-Server so it does not send NOTICE-messages to the client.

Open your postgresql.conf file and edit the entry client_min_messages so it looks like this:

Code: Select all

client_min_messages WARNING

. You might have to restart postgresql afterwards.

Source: http://www.postgresql.org/docs/9.0/stat ... gging.html

[Fabio_Tontini]

It worked all right, thanks for the help.