Re: BUG #5213: copy command gives error - Mailing list pgsql-bugs

From tomas@tuxteam.de
Subject Re: BUG #5213: copy command gives error
Date
Msg-id 20091125165502.GB28634@tomas
Whole thread Raw
In response to BUG #5213: copy command gives error  ("savita" <savita.halli@gmail.com>)
List pgsql-bugs
-----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-----

pgsql-bugs by date:

Previous
From: Greg Smith
Date:
Subject: Re: Re: [GENERAL] How duplicate data produce when a UNIQUE index exite ?
Next
From: Robert Haas
Date:
Subject: Re: BUG #5207: unable to start postgresql server services