RE: Database handle error

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.

> -----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 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)