| From: | "Oscar I(dot) del Rey" <nacho(at)rlc01(dot)sertecnet(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | cannot insert or update |
| Date: | 2003-09-22 07:36:42 |
| Message-ID: | 3F6EA68A.7090405@rlc01.sertecnet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi list
I have any problems with Postgres 7.0 and a DataBase.
When I do a select to the database it works well, but when I try to
insert or to update it remains hooked and I couldn't work with it.
Problems started 2 days ago after I done a vacuum in one table (only).
Since this day I have several processes such as:
/usr/bin/postgres localhost root database UPDATE waiting
These processes never die and are repeating themselves until they
exhaust the connections to the Data Base
Any ideas?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christian Imbeault | 2003-09-22 08:18:28 | Foreign key constraint accepted even when not same data type |
| Previous Message | Howard Lowndes | 2003-09-22 07:21:01 | psql and \lo_import |