Give me some suggestion

From: "usanee tuangrathooradee" <tuangrathooradee(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Give me some suggestion
Date: 2006-04-18 08:59:13
Message-ID: 3784ccaa0604180159u71269060nb94685bf6198bfe0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I 'm a new postgresql user and now I have some problem about it.
I'm not sure this problem is a bug of postgresql or not.
My problem is I have to read a text file ,processing and keep it into
database.
Each text file is about 50,000 records, the process can be insert,update
and delete.
I had random check and found that in the process of updating some can not
be updating.
It's happen with some text file ,but some are not.
I really don't know what is the cause of problem but it's not about
bussiness logic because
sometimes it's updating correctly.
I had investigate the log file of my program but there is nothing (I
wrote the log file to show if
it had an Exception or SQLException,so i'm quite sure that my sql
statement is correct.)

I used postgresql 7.4.6 , Platform is SUN Solaris9 , my program is java
web-application (on tomcat4.1).

Thanks,
Manee

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-04-18 09:15:35 Re: HUGE Stack space is gettiing consumed
Previous Message A. Kretschmer 2006-04-18 08:07:11 Re: select with date_part and month failure....