Database handle error
Can anyone tell me what this error means?
Database handle destroyed without explicit disconnect.
The good news is after all the help I've gotten here (thanks everyone!) I've
managed to get my oracle db schema loaded into postgres using the ora2pg.pl
script. Now, I'm trying to get the data.....that isn't working so far. If
I don't try loading the data directly to postgres, the INSERT statements go
directly to STDOUT. Otherwise, I get the error above. I can output the
whole thing to typescript and cut and paste the SQL, but I'd rather figure
out how to get this script running correctly.
--
Susan Lane
DPN, Incorporated
4631 Spring Mountain Road
Las Vegas, NV 89102
Email suel@dpn.com
Ph. (702) 873-3282
Fax (702) 873-3913
http://www.dpn.com
AFAIK, this error is returned by Perl DBI when a script terminates without a
database connection being explicitly closed.
It is more a warning than an error per se. The script might have terminated
because of another error, though you could expect another error to be
returned in that case.
If you have your schema already set up, you have choices available as to how
you load your data. If you can get your Oracle installation to dump the
data in delimited text files, you could load the data using COPY. That
could be a nuisance if you have a lot of tables, though. Alternatively, if
you could get Oracle to dump the data in the form of INSERT statements, you
should be able to load those directly into PostgreSQL will little (perhaps
no) editing, using
psql -f <datafile> <dbname>
from the command line, or
\i <datafile>
from within psql.
This might be easier than debugging the ora2pg.pl script. A matter of
preference.
Show quoted text
-----Original Message-----
From: Susan Lane [SMTP:suel@dpn.com]
Sent: Thursday, August 09, 2001 7:29 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Database handle errorCan anyone tell me what this error means?
Database handle destroyed without explicit disconnect.
The good news is after all the help I've gotten here (thanks everyone!)
I've
managed to get my oracle db schema loaded into postgres using the
ora2pg.pl
script. Now, I'm trying to get the data.....that isn't working so far.
If
I don't try loading the data directly to postgres, the INSERT statements
go
directly to STDOUT. Otherwise, I get the error above. I can output the
whole thing to typescript and cut and paste the SQL, but I'd rather figure
out how to get this script running correctly.--
Susan Lane
DPN, Incorporated
4631 Spring Mountain Road
Las Vegas, NV 89102
Email suel@dpn.com
Ph. (702) 873-3282
Fax (702) 873-3913
http://www.dpn.com---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Import Notes
Resolved by subject fallback