RE: Database handle error
От | Jeff Eckermann |
---|---|
Тема | RE: Database handle error |
Дата | |
Msg-id | 08CD1781F85AD4118E0800A0C9B8580B094B94@NEZU обсуждение исходный текст |
Ответ на | Database handle error ("Susan Lane" <suel@dpn.com>) |
Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: