Re: BUG #5213: copy command gives error

From: tomas(at)tuxteam(dot)de
To: savita <savita(dot)halli(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5213: copy command gives error
Date: 2009-11-25 16:55:02
Message-ID: 20091125165502.GB28634@tomas
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)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-----

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Yadira Lizama Mue 2009-11-25 18:49:35 change of oid values?
Previous Message Greg Smith 2009-11-25 16:42:42 Re: Re: [GENERAL] How duplicate data produce when a UNIQUE index exite ?