null rows - importing a table with - Mailing list pgadmin-support

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.