[baseten-users] Log from SQL Server regarding strange behaviour in new builds

Michael Ruepp michael at ruepp.at
Wed Sep 23 20:16:01 EEST 2009


These are some new and unusual SQL Logs I never recognized with the  
older versions of the framework:

SQL function "enable" statement 1
NOTICE:  CREATE TABLE will create implicit sequence  
"directories_id_seq" for serial column "directories.id"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index  
"directories_pkey" for table "directories"
NOTICE:  CREATE TABLE will create implicit sequence "files_id_seq" for  
serial column "files.id"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index  
"files_pkey" for table "files"
NOTICE:  schema "baseten" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"view_pkey_pkey" for table "view_pkey"
NOTICE:  CREATE TABLE will create implicit sequence "relation_id_seq"  
for serial column "relation.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"relation_pkey" for table "relation"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index  
"relation_nspname_key" for table "relation"
NOTICE:  CREATE TABLE will create implicit sequence  
"foreign_key_conid_seq" for serial column "foreign_key.conid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"foreign_key_pkey" for table "foreign_key"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index  
"foreign_key_conrelid_key" for table "foreign_key"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"ignored_fkey_pkey" for table "ignored_fkey"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"modification_pkey" for table "modification"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"lock_pkey" for table "lock"
NOTICE:  role "basetenuser" is already a member of role "basetenread"
NOTICE:  role "basetenowner" is already a member of role "basetenuser"
NOTICE:  merging column "baseten_lock_relid" with inherited definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".lock__2  
("baseten_lock_relid" INTEGER NOT NULL DEFAULT 2,  
"baseten_lock_reloid" OID NOT NULL DEFAULT 51647, id pg_catalog.int4  
NOT NULL) INHERITS ("baseten".lock)"
PL/pgSQL function "enable" line 40 at EXECUTE statement
SQL function "enable" statement 1
NOTICE:  merging column "baseten_lock_reloid" with inherited definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".lock__2  
("baseten_lock_relid" INTEGER NOT NULL DEFAULT 2,  
"baseten_lock_reloid" OID NOT NULL DEFAULT 51647, id pg_catalog.int4  
NOT NULL) INHERITS ("baseten".lock)"
PL/pgSQL function "enable" line 40 at EXECUTE statement
SQL function "enable" statement 1
NOTICE:  merging column "baseten_modification_relid" with inherited  
definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".mod__2  
("baseten_modification_relid" INTEGER NOT NULL DEFAULT 2,  
"baseten_modification_reloid" OID NOT NULL DEFAULT 51647, id  
pg_catalog.int4 NOT NULL) INHERITS ("baseten".modification)"
PL/pgSQL function "enable" line 63 at EXECUTE statement
SQL function "enable" statement 1
NOTICE:  merging column "baseten_modification_reloid" with inherited  
definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".mod__2  
("baseten_modification_relid" INTEGER NOT NULL DEFAULT 2,  
"baseten_modification_reloid" OID NOT NULL DEFAULT 51647, id  
pg_catalog.int4 NOT NULL) INHERITS ("baseten".modification)"
PL/pgSQL function "enable" line 63 at EXECUTE statement
SQL function "enable" statement 1
NOTICE:  merging column "baseten_lock_relid" with inherited definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".lock__1  
("baseten_lock_relid" INTEGER NOT NULL DEFAULT 1,  
"baseten_lock_reloid" OID NOT NULL DEFAULT 51660, id pg_catalog.int4  
NOT NULL) INHERITS ("baseten".lock)"
PL/pgSQL function "enable" line 40 at EXECUTE statement
SQL function "enable" statement 1
NOTICE:  merging column "baseten_lock_reloid" with inherited definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".lock__1  
("baseten_lock_relid" INTEGER NOT NULL DEFAULT 1,  
"baseten_lock_reloid" OID NOT NULL DEFAULT 51660, id pg_catalog.int4  
NOT NULL) INHERITS ("baseten".lock)"
PL/pgSQL function "enable" line 40 at EXECUTE statement
SQL function "enable" statement 1
NOTICE:  merging column "baseten_modification_relid" with inherited  
definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".mod__1  
("baseten_modification_relid" INTEGER NOT NULL DEFAULT 1,  
"baseten_modification_reloid" OID NOT NULL DEFAULT 51660, id  
pg_catalog.int4 NOT NULL) INHERITS ("baseten".modification)"
PL/pgSQL function "enable" line 63 at EXECUTE statement
SQL function "enable" statement 1
NOTICE:  merging column "baseten_modification_reloid" with inherited  
definition
CONTEXT:  SQL statement "CREATE TABLE "baseten".mod__1  
("baseten_modification_relid" INTEGER NOT NULL DEFAULT 1,  
"baseten_modification_reloid" OID NOT NULL DEFAULT 51660, id  
pg_catalog.int4 NOT NULL) INHERITS ("baseten".modification)"
PL/pgSQL function "enable" line 63 at EXECUTE statement
SQL function "enable" statement 1



More information about the baseten-users mailing list