BUG #5213: copy command gives error
The following bug has been logged online:
Bug reference: 5213
Logged by: savita
Email address: savita.halli@gmail.com
PostgreSQL version: 8.3.5
Operating system: AIX
Description: copy command gives error
Details:
Hi
I have a file which has data of a table. Now I want to copy this data into
postgres database.
When I am running the script which has copy command, it gives me error for
5th row. I compared the data for 4th and 5th row and looks similar.
I would like to know id there anyway I can get exact sql queries those are
running in postgres database. If so please give me the exact steps.
Thanks
Savita
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, Nov 25, 2009 at 07:58:53AM +0000, savita wrote:
[...]
Hi, Savita --
I have a file which has data of a table. Now I want to copy this data into
postgres database.
this is most probably not a bug in PostgreSQL, so it doesn't make sense
to file a bug here.
I think you will get more help posting this to the general help list,
<pgsql-novice@postgresql.org>. That said...
When I am running the script which has copy command, it gives me error for
5th row. I compared the data for 4th and 5th row and looks similar.
The database seems to disagree ;-)
I would like to know id there anyway I can get exact sql queries those are
running in postgres database. If so please give me the exact steps.
I think I don't understand what you are trying to say here: the command
to the database is surely "COPY", right? And if something goes wrong,
you will surely see an error message as a reaction to it?
Regards
- - tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFLDWFmBcgs9XrR2kYRAj3tAJ9rb5m1b1W10wlelO1A4YT5/AJBeQCdFT1b
D0dbdPJJRa/5Lw/lt7wKE1I=
=7nRB
-----END PGP SIGNATURE-----