Hi.
I'm having a hard time trying to import a table with null rows.
I'm using the PgAdminII Database Migration Wizard plug-in.
I could isolate the problem: if I get rid of null rows, I can import
the table.
The question is: is it a plug-in's issue, ODBC driver's issue or
Postgres' issue?
Even not being a good pratice, I would want to import null rows, or at
least ignore them and import the rest.
Currently I'm using a view to select * from the original table where
all fields not null, then importing this view. An automatic workaround
would suffice.
Any idea?
I'm sending below more information.
Thanks in advance.
Felipe N.
-----
Software Versions:
pgAdmin II - 1.2.0
Database Migration Wizard - 1.2.0
ODBC driver - 7.01.00.10
PostgreSQL - 7.1.3
-----
Database Migration Wizard log:
Creating table: RINA2
Copying data...
An error occured at: 09/04/02 10:35:00:
5: Invalid procedure call or argument
Rolling back... Done.
-----
pgAdmin log file:
09/04/02 10:34:36 - Entering pgAdmin
II:frmMain.imgSplitter_MouseMove(0, 0, 0, 0)
09/04/02 10:34:38 - Entering pgAdmin II:frmMain.mnuPluginsPlg_Click(1)
09/04/02 10:34:38 - Entering pgAdmin II:clsPlugins.Property Get
Item("Database Migration Wizard")
09/04/02 10:34:38 - Entering pgAdmin II:clsPlugins.Property Get
Item("Database Migration Wizard")
09/04/02 10:34:38 - Executing Plugin: Database Migration Wizard v1.2.0
09/04/02 10:34:38 - Entering pgAdmin II:clsPlugins.Property Get
Item("Database Migration Wizard")
09/04/02 10:34:38 - Entering Database Migration
Wizard:frmWizard.Initialise()
09/04/02 10:34:40 - Entering Database Migration
Wizard:frmWizard.cmdBrowse_Click()
09/04/02 10:34:43 - Entering Database Migration
Wizard:frmWizard.cmdNext_Click()
09/04/02 10:34:43 - Entering Database Migration
Wizard:frmWizard.dbConnect()
09/04/02 10:34:44 - Opening and Examining Source Database...
09/04/02 10:34:44 - Opening File: C:\Meus documentos\Felipe\dados\tmp1.mdb
09/04/02 10:34:44 - Opened connection:
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=C:\Meus documentos\Felipe\dados\tmp1.mdb;Mode=Share Deny
None;Extended Properties="";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine
Type=4;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
09/04/02 10:34:44 - Provider: Microsoft.Jet.OLEDB.4.0 v2.5
09/04/02 10:34:44 - Quote Character: '`'
09/04/02 10:34:44 - Done - 0,22 Secs.
09/04/02 10:34:44 - Entering Database Migration
Wizard:frmWizard.GetTargetDatabases()
09/04/02 10:34:44 - Looking for possible target databases...
09/04/02 10:34:44 - Entering pgSchema:pgServer.Property Get Databases()
09/04/02 10:34:44 - Entering pgSchema:Databases.Property Get NewEnum()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get
SystemObject()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get Identifier()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get Comment()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.LookupComment(18720)
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get
SystemObject()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get Identifier()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get Comment()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.LookupComment(67430)
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get
SystemObject()
09/04/02 10:34:44 - Entering pgSchema:pgDatabase.Property Get Identifier()
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.Property Get Comment()
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.LookupComment(67781)
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.Property Get
SystemObject()
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.Property Get Identifier()
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.Property Get Comment()
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.LookupComment(18719)
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:34:45 - Entering pgSchema:pgServer.Property Get Connection()
09/04/02 10:34:45 - Entering pgSchema:pgServer.Property Get MasterDB()
09/04/02 10:34:45 - Entering pgSchema:pgServer.Property Get ShowPassword()
09/04/02 10:34:45 - Entering pgSchema:pgServer.Property Get iPassword()
09/04/02 10:34:45 - Opening cnDatabase: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template0;SERVER=localhost;PORT=5432;UID=trabalhador;PWD=********;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"
09/04/02 10:34:45 - Entering pgSchema:pgDatabase.Property Get
SystemObject()
09/04/02 10:34:45 - Done - 1,2 Secs.
09/04/02 10:34:45 - Entering Database Migration
Wizard:frmWizard.tabWizard_Click()
09/04/02 10:34:48 - Entering Database Migration
Wizard:frmWizard.cmdNext_Click()
09/04/02 10:34:48 - Entering Database Migration
Wizard:frmWizard.tabWizard_Click()
09/04/02 10:34:51 - Entering Database Migration
Wizard:frmWizard.cmdNext_Click()
09/04/02 10:34:51 - Entering Database Migration
Wizard:frmWizard.Load_Data()
09/04/02 10:34:51 - Entering Database Migration
Wizard:frmWizard.tabWizard_Click()
09/04/02 10:34:55 - Entering Database Migration
Wizard:frmWizard.cmdNext_Click()
09/04/02 10:34:55 - Entering Database Migration
Wizard:frmWizard.GetEligibleForeignKeys()
09/04/02 10:34:55 - Searching for Foreign Keys...
09/04/02 10:34:55 - Done - 0,39 Secs.
09/04/02 10:34:55 - Entering Database Migration
Wizard:frmWizard.tabWizard_Click()
09/04/02 10:34:56 - Entering Database Migration
Wizard:frmWizard.cmdNext_Click()
09/04/02 10:34:56 - Entering Database Migration
Wizard:frmWizard.tabWizard_Click()
09/04/02 10:34:57 - Entering Database Migration
Wizard:frmWizard.cmdMigrate_Click()
09/04/02 10:34:57 - Entering Database Migration
Wizard:frmWizard.Migrate_Data()
09/04/02 10:34:57 - Migrating database...
09/04/02 10:34:57 - Migration from
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=C:\Meus documentos\Felipe\dados\tmp1.mdb;Mode=Share Deny
None;Extended Properties="";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine
Type=4;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False to
geosist starting.
09/04/02 10:34:57 - NOT NULL rules being honoured.
09/04/02 10:34:57 - Entering pgSchema:pgServer.Property Get Databases()
09/04/02 10:34:57 - Entering pgSchema:Databases.Property Get
Item("geosist")
09/04/02 10:34:57 - Entering pgSchema:pgDatabase.Execute("BEGIN", 0, -1)
09/04/02 10:34:58 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:34:58 - Entering pgSchema:pgServer.ExecSQL("BEGIN",
"Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=geosist;SERVER=localhost;PORT=5432;UID=trabalhador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
09/04/02 10:34:58 - SQL (geosist): BEGIN
09/04/02 10:34:58 - Creating table: RINA2
09/04/02 10:34:58 - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
09/04/02 10:34:58 - Entering pgSchema:pgServer.Property Get Databases()
09/04/02 10:34:58 - Entering pgSchema:Databases.Property Get
Item("geosist")
09/04/02 10:34:59 - Entering pgSchema:pgDatabase.Execute("CREATE TABLE
"RINA2" ( "FORMUL�RIO" float8, "CART�OSUS" float8, "NOME" varchar(50),
"IDADE" float8, "SEXO" float8, "NASCIMENTO" date, "CPFOURG" float8,
"RA�A" float8, "ESTCIVIL" float8, "ENDERE�O" varchar(45), "INSTRU��O"
float8, "BAIRRDISTR" varchar(33), "MUNIC�PIO" varchar(32),
"C�DIGMUNIC" float8, "UF" varchar(2), "RELTRAB" float8, "ZONA" float8,
"OCUPA��O" varchar(75), "CBO" float8, "OCUPANOS" float8, "OCUPMESES"
float8, "RAZSOCIAL1" varchar(47), "CGC1" float8, "RAZSOCIA01"
varchar(47), "CGC2" float8, "RAMOATIVID" varchar(72), "CNAE" float8,
"GRAURISCO" float8, "ENDEREMPR" varchar(51), "BAIDISEMPR" varchar(42),
"MUNICEMPR" varchar(50), "C�DMUNEMPR" float8, "UFEMPR" varchar(2),
"SERVSA�DE" varchar(46), "MUNICATEND" varchar(38), "C�DMUNATEN"
float8, "CRS" float8, "TIPSERVI�O" float8, "ENCAMINHA" float8,
"ENCAMINHA1" varchar(29), "FIS" float8, "TIPOATEND" float8,
"TIPOATEND1" float8, "TIPOATEND2" float8, "PRIMATEND" date,
"DATADAALTA" date, "ACIDDOEN�A" float8, "CIDACID1" varchar(3),
"DIAGN1ACID" varchar(72), "CIDACID2" varchar(3), "DIAGN2ACID"
varchar(72), "CIDACID3" varchar(3), "DIAGN3ACID" varchar(72),
"DATADOACID" date, "HORADOACID" varchar(5), "AP�SHORAS" float8,
"LOCALACID" float8, "SETORACID" varchar(29), "AGENTEACID" varchar(41),
"EVOLACID" float8, "DESCRACID1" varchar(72), "DESCRACID2" varchar(72),
"CIDDOEN�1" varchar(5), "DIAG1DOEN�" varchar(72), "CIDDOEN�2"
varchar(5), "DIAG2DOEN�" varchar(72), "CIDDOEN�3" varchar(5),
"DIAG3DOEN�" varchar(72), "DATADIAGN" date, "EST�DOEN�" float8,
"AGENTDOEN�" varchar(43), "SETOREXPOS" varchar(72), "RELA��O" float8,
"CRIT�RIO" float8, "EVOLDOEN�" float8, "DESCRAGRA1" varchar(72),
"DESCRAGRA2" varchar(72), "PER�CIA" float8, "CAT" float8, "QUEMEMITIU"
float8, "RESP1" varchar(41), "REGPROF1" float8, "FUN��O1" varchar(22),
"RESP2" varchar(41), "REGPROF2" float8, "FUN��O2" varchar(22),
"DATPREENCH" date )", 0, -1)
09/04/02 10:34:59 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:34:59 - Entering pgSchema:pgServer.ExecSQL("CREATE TABLE
"RINA2" ( "FORMUL�RIO" float8, "CART�OSUS" float8, "NOME" varchar(50),
"IDADE" float8, "SEXO" float8, "NASCIMENTO" date, "CPFOURG" float8,
"RA�A" float8, "ESTCIVIL" float8, "ENDERE�O" varchar(45), "INSTRU��O"
float8, "BAIRRDISTR" varchar(33), "MUNIC�PIO" varchar(32),
"C�DIGMUNIC" float8, "UF" varchar(2), "RELTRAB" float8, "ZONA" float8,
"OCUPA��O" varchar(75), "CBO" float8, "OCUPANOS" float8, "OCUPMESES"
float8, "RAZSOCIAL1" varchar(47), "CGC1" float8, "RAZSOCIA01"
varchar(47), "CGC2" float8, "RAMOATIVID" varchar(72), "CNAE" float8,
"GRAURISCO" float8, "ENDEREMPR" varchar(51), "BAIDISEMPR" varchar(42),
"MUNICEMPR" varchar(50), "C�DMUNEMPR" float8, "UFEMPR" varchar(2),
"SERVSA�DE" varchar(46), "MUNICATEND" varchar(38), "C�DMUNATEN"
float8, "CRS" float8, "TIPSERVI�O" float8, "ENCAMINHA" float8,
"ENCAMINHA1" varchar(29), "FIS" float8, "TIPOATEND" float8,
"TIPOATEND1" float8, "TIPOATEND2" float8, "PRIMATEND" date,
"DATADAALTA" date, "ACIDDOEN�A" float8, "CIDACID1" varchar(3),
"DIAGN1ACID" varchar(72), "CIDACID2" varchar(3), "DIAGN2ACID"
varchar(72), "CIDACID3" varchar(3), "DIAGN3ACID" varchar(72),
"DATADOACID" date, "HORADOACID" varchar(5), "AP�SHORAS" float8,
"LOCALACID" float8, "SETORACID" varchar(29), "AGENTEACID" varchar(41),
"EVOLACID" float8, "DESCRACID1" varchar(72), "DESCRACID2" varchar(72),
"CIDDOEN�1" varchar(5), "DIAG1DOEN�" varchar(72), "CIDDOEN�2"
varchar(5), "DIAG2DOEN�" varchar(72), "CIDDOEN�3" varchar(5),
"DIAG3DOEN�" varchar(72), "DATADIAGN" date, "EST�DOEN�" float8,
"AGENTDOEN�" varchar(43), "SETOREXPOS" varchar(72), "RELA��O" float8,
"CRIT�RIO" float8, "EVOLDOEN�" float8, "DESCRAGRA1" varchar(72),
"DESCRAGRA2" varchar(72), "PER�CIA" float8, "CAT" float8, "QUEMEMITIU"
float8, "RESP1" varchar(41), "REGPROF1" float8, "FUN��O1" varchar(22),
"RESP2" varchar(41), "REGPROF2" float8, "FUN��O2" varchar(22),
"DATPREENCH" date )", "Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=geosist;SERVER=localhost;PORT=5432;UID=trabalhador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
09/04/02 10:34:59 - SQL (geosist): CREATE TABLE "RINA2" ( "FORMUL�RIO"
float8, "CART�OSUS" float8, "NOME" varchar(50), "IDADE" float8, "SEXO"
float8, "NASCIMENTO" date, "CPFOURG" float8, "RA�A" float8, "ESTCIVIL"
float8, "ENDERE�O" varchar(45), "INSTRU��O" float8, "BAIRRDISTR"
varchar(33), "MUNIC�PIO" varchar(32), "C�DIGMUNIC" float8, "UF"
varchar(2), "RELTRAB" float8, "ZONA" float8, "OCUPA��O" varchar(75),
"CBO" float8, "OCUPANOS" float8, "OCUPMESES" float8, "RAZSOCIAL1"
varchar(47), "CGC1" float8, "RAZSOCIA01" varchar(47), "CGC2" float8,
"RAMOATIVID" varchar(72), "CNAE" float8, "GRAURISCO" float8,
"ENDEREMPR" varchar(51), "BAIDISEMPR" varchar(42), "MUNICEMPR"
varchar(50), "C�DMUNEMPR" float8, "UFEMPR" varchar(2), "SERVSA�DE"
varchar(46), "MUNICATEND" varchar(38), "C�DMUNATEN" float8, "CRS"
float8, "TIPSERVI�O" float8, "ENCAMINHA" float8, "ENCAMINHA1"
varchar(29), "FIS" float8, "TIPOATEND" float8, "TIPOATEND1" float8,
"TIPOATEND2" float8, "PRIMATEND" date, "DATADAALTA" date, "ACIDDOEN�A"
float8, "CIDACID1" varchar(3), "DIAGN1ACID" varchar(72), "CIDACID2"
varchar(3), "DIAGN2ACID" varchar(72), "CIDACID3" varchar(3),
"DIAGN3ACID" varchar(72), "DATADOACID" date, "HORADOACID" varchar(5),
"AP�SHORAS" float8, "LOCALACID" float8, "SETORACID" varchar(29),
"AGENTEACID" varchar(41), "EVOLACID" float8, "DESCRACID1" varchar(72),
"DESCRACID2" varchar(72), "CIDDOEN�1" varchar(5), "DIAG1DOEN�"
varchar(72), "CIDDOEN�2" varchar(5), "DIAG2DOEN�" varchar(72),
"CIDDOEN�3" varchar(5), "DIAG3DOEN�" varchar(72), "DATADIAGN" date,
"EST�DOEN�" float8, "AGENTDOEN�" varchar(43), "SETOREXPOS"
varchar(72), "RELA��O" float8, "CRIT�RIO" float8, "EVOLDOEN�" float8,
"DESCRAGRA1" varchar(72), "DESCRAGRA2" varchar(72), "PER�CIA" float8,
"CAT" float8, "QUEMEMITIU" float8, "RESP1" varchar(41), "REGPROF1"
float8, "FUN��O1" varchar(22), "RESP2" varchar(41), "REGPROF2" float8,
"FUN��O2" varchar(22), "DATPREENCH" date )
09/04/02 10:34:59 - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
09/04/02 10:34:59 - Migrating Data from: RINA2
09/04/02 10:34:59 - Executing: SELECT * FROM `RINA2`
09/04/02 10:34:59 - Entering pgSchema:pgServer.Property Get Databases()
09/04/02 10:34:59 - Entering pgSchema:Databases.Property Get
Item("geosist")
09/04/02 10:34:59 - Entering pgSchema:pgDatabase.Execute("INSERT INTO
"RINA2" ("FORMUL�RIO", "NOME", "IDADE", "SEXO", "NASCIMENTO", "RA�A",
"ESTCIVIL", "ENDERE�O", "INSTRU��O", "BAIRRDISTR", "MUNIC�PIO",
"C�DIGMUNIC", "UF", "RELTRAB", "ZONA", "OCUPA��O", "CBO", "OCUPANOS",
"CNAE", "GRAURISCO", "ENDEREMPR", "BAIDISEMPR", "MUNICEMPR",
"C�DMUNEMPR", "UFEMPR", "SERVSA�DE", "MUNICATEND", "C�DMUNATEN",
"CRS", "TIPSERVI�O", "ENCAMINHA", "FIS", "TIPOATEND", "PRIMATEND",
"ACIDDOEN�A", "CIDACID1", "DIAGN1ACID", "LOCALACID", "EVOLACID",
"EST�DOEN�", "RELA��O", "CRIT�RIO", "PER�CIA", "CAT", "QUEMEMITIU",
"RESP1", "REGPROF1", "FUN��O1", "DATPREENCH") VALUES (' .19', 'Sergio
Lemos', ' 41', ' 1', '1959-11-18 00:00:00', ' 1', ' 9', 'Riachuelo
1714', ' 9', 'Centro', 'Tramandai', ' 2160', 'RS', ' 8', ' 1',
'padeiro', ' 5.3', ' 0', ' 5.5', ' 2', 'Av. da Igreja 592', 'Centro',
'Tramandai', ' 2160', 'RS', 'Posto Saude Emergencial', 'Tramandai', '
2160', ' 18', ' 1', ' 1', ' 1', ' 1', '2001-09-12 00:00:00', ' 1',
'S61', 'ferimento na mao', ' 2', ' 4', ' 4', ' 1', ' 1', ' 9', ' 9', '
9', 'Carlos Mello', ' 80951', 'enfermeiro', '2001-09-12 00:00:00')",
0, -1)
09/04/02 10:34:59 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:34:59 - Entering pgSchema:pgServer.ExecSQL("INSERT INTO
"RINA2" ("FORMUL�RIO", "NOME", "IDADE", "SEXO", "NASCIMENTO", "RA�A",
"ESTCIVIL", "ENDERE�O", "INSTRU��O", "BAIRRDISTR", "MUNIC�PIO",
"C�DIGMUNIC", "UF", "RELTRAB", "ZONA", "OCUPA��O", "CBO", "OCUPANOS",
"CNAE", "GRAURISCO", "ENDEREMPR", "BAIDISEMPR", "MUNICEMPR",
"C�DMUNEMPR", "UFEMPR", "SERVSA�DE", "MUNICATEND", "C�DMUNATEN",
"CRS", "TIPSERVI�O", "ENCAMINHA", "FIS", "TIPOATEND", "PRIMATEND",
"ACIDDOEN�A", "CIDACID1", "DIAGN1ACID", "LOCALACID", "EVOLACID",
"EST�DOEN�", "RELA��O", "CRIT�RIO", "PER�CIA", "CAT", "QUEMEMITIU",
"RESP1", "REGPROF1", "FUN��O1", "DATPREENCH") VALUES (' .19', 'Sergio
Lemos', ' 41', ' 1', '1959-11-18 00:00:00', ' 1', ' 9', 'Riachuelo
1714', ' 9', 'Centro', 'Tramandai', ' 2160', 'RS', ' 8', ' 1',
'padeiro', ' 5.3', ' 0', ' 5.5', ' 2', 'Av. da Igreja 592', 'Centro',
'Tramandai', ' 2160', 'RS', 'Posto Saude Emergencial', 'Tramandai', '
2160', ' 18', ' 1', ' 1', ' 1', ' 1', '2001-09-12 00:00:00', ' 1',
'S61', 'ferimento na mao', ' 2', ' 4', ' 4', ' 1', ' 1', ' 9', ' 9', '
9', 'Carlos Mello', ' 80951', 'enfermeiro', '2001-09-12 00:00:00')",
"Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=geosist;SERVER=localhost;PORT=5432;UID=trabalhador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
09/04/02 10:34:59 - SQL (geosist): INSERT INTO "RINA2" ("FORMUL�RIO",
"NOME", "IDADE", "SEXO", "NASCIMENTO", "RA�A", "ESTCIVIL", "ENDERE�O",
"INSTRU��O", "BAIRRDISTR", "MUNIC�PIO", "C�DIGMUNIC", "UF", "RELTRAB",
"ZONA", "OCUPA��O", "CBO", "OCUPANOS", "CNAE", "GRAURISCO",
"ENDEREMPR", "BAIDISEMPR", "MUNICEMPR", "C�DMUNEMPR", "UFEMPR",
"SERVSA�DE", "MUNICATEND", "C�DMUNATEN", "CRS", "TIPSERVI�O",
"ENCAMINHA", "FIS", "TIPOATEND", "PRIMATEND", "ACIDDOEN�A",
"CIDACID1", "DIAGN1ACID", "LOCALACID", "EVOLACID", "EST�DOEN�",
"RELA��O", "CRIT�RIO", "PER�CIA", "CAT", "QUEMEMITIU", "RESP1",
"REGPROF1", "FUN��O1", "DATPREENCH") VALUES (' .19', 'Sergio Lemos', '
41', ' 1', '1959-11-18 00:00:00', ' 1', ' 9', 'Riachuelo 1714', ' 9',
'Centro', 'Tramandai', ' 2160', 'RS', ' 8', ' 1', 'padeiro', ' 5.3', '
0', ' 5.5', ' 2', 'Av. da Igreja 592', 'Centro', 'Tramandai', ' 2160',
'RS', 'Posto Saude Emergencial', 'Tramandai', ' 2160', ' 18', ' 1', '
1', ' 1', ' 1', '2001-09-12 00:00:00', ' 1', 'S61', 'ferimento na
mao', ' 2', ' 4', ' 4', ' 1', ' 1', ' 9', ' 9', ' 9', 'Carlos Mello',
' 80951', 'enfermeiro', '2001-09-12 00:00:00')
09/04/02 10:35:00 - Entering pgSchema:pgServer.Property Get Databases()
09/04/02 10:35:00 - Entering pgSchema:Databases.Property Get
Item("geosist")
09/04/02 10:35:00 - Entering pgSchema:pgDatabase.Execute("INSERT INTO
"RINA2" ("FORMUL�RIO", "NOME", "IDADE", "SEXO", "NASCIMENTO", "RA�A",
"ESTCIVIL", "ENDERE�O", "INSTRU��O", "BAIRRDISTR", "MUNIC�PIO",
"C�DIGMUNIC", "UF", "RELTRAB", "ZONA", "OCUPA��O", "CBO", "OCUPANOS",
"CNAE", "GRAURISCO", "SERVSA�DE", "MUNICATEND", "C�DMUNATEN", "CRS",
"TIPSERVI�O", "ENCAMINHA", "FIS", "TIPOATEND", "PRIMATEND",
"ACIDDOEN�A", "CIDACID1", "DIAGN1ACID", "DATADOACID", "LOCALACID",
"EVOLACID", "EST�DOEN�", "RELA��O", "CRIT�RIO", "PER�CIA", "CAT",
"QUEMEMITIU", "RESP1", "REGPROF1", "FUN��O1", "DATPREENCH") VALUES ('
.2', 'Geraldo Alves Almeida', ' 38', ' 1', '1962-12-27 00:00:00', '
1', ' 9', 'AV. Emancipacao 1945', ' 9', 'centro', 'Tramandai', '
2160', 'RS', ' 1', ' 1', 'Cabo ser. militar', ' 10.7', ' 0', ' 75.3',
' 4', 'Posto Saude Emergencial', 'Tramandai', ' 2160', ' 18', ' 1', '
1', ' 1', ' 1', '2001-09-12 00:00:00', ' 1', 'T15', 'corpo estranho
olho', '2001-09-12 00:00:00', ' 9', ' 1', ' 9', ' 1', ' 1', ' 9', '
9', ' 9', 'Carlos Mello', ' 80951', 'enfermeiro', '2001-09-12
00:00:00')", 0, -1)
09/04/02 10:35:00 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:35:00 - Entering pgSchema:pgServer.ExecSQL("INSERT INTO
"RINA2" ("FORMUL�RIO", "NOME", "IDADE", "SEXO", "NASCIMENTO", "RA�A",
"ESTCIVIL", "ENDERE�O", "INSTRU��O", "BAIRRDISTR", "MUNIC�PIO",
"C�DIGMUNIC", "UF", "RELTRAB", "ZONA", "OCUPA��O", "CBO", "OCUPANOS",
"CNAE", "GRAURISCO", "SERVSA�DE", "MUNICATEND", "C�DMUNATEN", "CRS",
"TIPSERVI�O", "ENCAMINHA", "FIS", "TIPOATEND", "PRIMATEND",
"ACIDDOEN�A", "CIDACID1", "DIAGN1ACID", "DATADOACID", "LOCALACID",
"EVOLACID", "EST�DOEN�", "RELA��O", "CRIT�RIO", "PER�CIA", "CAT",
"QUEMEMITIU", "RESP1", "REGPROF1", "FUN��O1", "DATPREENCH") VALUES ('
.2', 'Geraldo Alves Almeida', ' 38', ' 1', '1962-12-27 00:00:00', '
1', ' 9', 'AV. Emancipacao 1945', ' 9', 'centro', 'Tramandai', '
2160', 'RS', ' 1', ' 1', 'Cabo ser. militar', ' 10.7', ' 0', ' 75.3',
' 4', 'Posto Saude Emergencial', 'Tramandai', ' 2160', ' 18', ' 1', '
1', ' 1', ' 1', '2001-09-12 00:00:00', ' 1', 'T15', 'corpo estranho
olho', '2001-09-12 00:00:00', ' 9', ' 1', ' 9', ' 1', ' 1', ' 9', '
9', ' 9', 'Carlos Mello', ' 80951', 'enfermeiro', '2001-09-12
00:00:00')", "Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=geosist;SERVER=localhost;PORT=5432;UID=trabalhador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
09/04/02 10:35:00 - SQL (geosist): INSERT INTO "RINA2" ("FORMUL�RIO",
"NOME", "IDADE", "SEXO", "NASCIMENTO", "RA�A", "ESTCIVIL", "ENDERE�O",
"INSTRU��O", "BAIRRDISTR", "MUNIC�PIO", "C�DIGMUNIC", "UF", "RELTRAB",
"ZONA", "OCUPA��O", "CBO", "OCUPANOS", "CNAE", "GRAURISCO",
"SERVSA�DE", "MUNICATEND", "C�DMUNATEN", "CRS", "TIPSERVI�O",
"ENCAMINHA", "FIS", "TIPOATEND", "PRIMATEND", "ACIDDOEN�A",
"CIDACID1", "DIAGN1ACID", "DATADOACID", "LOCALACID", "EVOLACID",
"EST�DOEN�", "RELA��O", "CRIT�RIO", "PER�CIA", "CAT", "QUEMEMITIU",
"RESP1", "REGPROF1", "FUN��O1", "DATPREENCH") VALUES (' .2', 'Geraldo
Alves Almeida', ' 38', ' 1', '1962-12-27 00:00:00', ' 1', ' 9', 'AV.
Emancipacao 1945', ' 9', 'centro', 'Tramandai', ' 2160', 'RS', ' 1', '
1', 'Cabo ser. militar', ' 10.7', ' 0', ' 75.3', ' 4', 'Posto Saude
Emergencial', 'Tramandai', ' 2160', ' 18', ' 1', ' 1', ' 1', ' 1',
'2001-09-12 00:00:00', ' 1', 'T15', 'corpo estranho olho', '2001-09-12
00:00:00', ' 9', ' 1', ' 9', ' 1', ' 1', ' 9', ' 9', ' 9', 'Carlos
Mello', ' 80951', 'enfermeiro', '2001-09-12 00:00:00')
09/04/02 10:35:00 - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
09/04/02 10:35:00 - Entering pgSchema:pgServer.Property Get Databases()
09/04/02 10:35:00 - Entering pgSchema:Databases.Property Get
Item("geosist")
09/04/02 10:35:00 - Entering pgSchema:pgDatabase.Execute("ROLLBACK",
0, -1)
09/04/02 10:35:00 - Entering pgSchema:pgDatabase.dbConnect()
09/04/02 10:35:00 - Entering pgSchema:pgServer.ExecSQL("ROLLBACK",
"Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=geosist;SERVER=localhost;PORT=5432;UID=trabalhador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
09/04/02 10:35:00 - SQL (geosist): ROLLBACK
09/04/02 10:35:00 - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
09/04/02 10:35:00 - Done - 2,63 Secs.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
