[Gambas-user] gb3 and postgresql indexes

[emanuele sottocorno]

Here the console output during function execution.

NOTICE:  table "sezioni" does not exist, skipping
NOTICE:  CREATE TABLE will create implicit sequence
"sezioni_idsezione_seq" for serial column "sezioni.idsezione"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"sezioni_pk" for table "sezioni"
NOTICE:  table "misure" does not exist, skipping
NOTICE:  CREATE TABLE will create implicit sequence
"misure_idmisura_seq" for serial column "misure.idmisura"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"misure_pk" for table "misure"
NOTICE:  table "cerchio" does not exist, skipping
NOTICE:  CREATE TABLE will create implicit sequence
"cerchio_idcerchio_seq" for serial column "cerchio.idcerchio"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"cerchio_pk" for table "cerchio"
NOTICE:  table "clienti" does not exist, skipping
NOTICE:  CREATE TABLE will create implicit sequence
"clienti_idcliente_seq" for serial column "clienti.idcliente"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"clienti_pk" for table "clienti"
NOTICE:  table "comuni" does not exist, skipping
NOTICE:  CREATE TABLE will create implicit sequence
"comuni_idcomune_seq" for serial column "comuni.idcomune"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"comuni_pk" for table "comuni"
NOTICE:  table "provincie" does not exist, skipping
NOTICE:  CREATE TABLE will create implicit sequence
"provincie_idprovincia_seq" for serial column "provincie.idprovincia"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"provincie_pk" for table "provincie"
NOTICE:  table "cap" does not exist, skipping
NOTICE:  CREATE TABLE will create implicit sequence "cap_idcap_seq"
for serial column "cap.idcap"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"cap_pk" for table "cap"
postgresql: 0x8ca8260: select substring(version(),12,5)
postgresql: 0x8ca8260: show client_encoding
postgresql: 0x8ca8260: select datname from pg_database where
(datallowconn = 't') and (datname = 'gbputenti')
postgresql: 0x8ca8260: select datname from pg_database where
(datallowconn = 't') and (datname = 'gbputenti')
postgresql: 0x8ca8260: create database "gbputenti"
postgresql: 0x8ca8260: select substring(version(),12,5)
postgresql: 0x8ca8260: show client_encoding
postgresql: 0x8ca8260: select relname from pg_class where (relkind =
'r' or relkind = 'v') and (relname = 'utenti') and (relnamespace in
(select oid from pg_namespace where nspname = 'public'))
postgresql: 0x8ca8260: CREATE TABLE "utenti" ( "id" BIGSERIAL ,
"unome" VARCHAR(30), "ucognome" VARCHAR(30), "ulogin" VARCHAR(30),
"upassword" VARCHAR(50), "ureparto" VARCHAR(30), "uaziende"
VARCHAR(100), "utipo" INT NOT NULL DEFAULT 1, "ulastmodify" TIMES
TAMP, PRIMARY KEY (id) )
NOTICE:  CREATE TABLE will create implicit sequence "utenti_id_seq"
for serial column "utenti.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"utenti_pkey" for table "utenti"
-----
postgresql: 0x8ca8260: select pg_class.relname from pg_class,
pg_index, pg_class pg_class2 where pg_class2.relname = 'utenti' and
(pg_class2.relnamespace in (select oid from pg_namespace where nspname
= 'public')) and pg_index.indrelid = pg_class2.oid and
pg_index.indexrelid = pg_class.oid and pg_class.relname = 'login'
postgresql: 0x8ca8260: CREATE UNIQUE INDEX "login" ON "utenti" ( "utenti" )
----
what follow is the "remove structure due an error occured."

postgresql: 0x8c905a8: select substring(version(),12,5)
postgresql: 0x8c905a8: show client_encoding
postgresql: 0x8c905a8: select datname from pg_database where
(datallowconn = 't') and (datname = 'gbp_sotema')
postgresql: 0x8c905a8: drop database "gbp_sotema"
postgresql: 0x8c905a8: select datname from pg_database where
(datallowconn = 't') and (datname = 'gbputenti')
postgresql: 0x8c905a8: drop database "gbputenti"

I tried also a postgresql server on WinXP with the same error.

Regards,
Emanuele