| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Delete Problem |
| Date: | 2006-07-13 06:18:16 |
| Message-ID: | 20060713061816.GA24806@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Thu, Jul 13, 2006 at 03:32:43PM +1000, Jamie Deppeler wrote:
> Michael Fuhr wrote:
> >On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
> >>Just today i have noticed i have one certain table that i cannot delete
> >>any records from
> >
> >What happens when you try to delete? Do you get an error? Does
> >the delete succeed but report zero rows deleted? Something else?
> >What does "EXPLAIN ANALYZE DELETE ..." show? Is the delete done
> >in a transaction that doesn't commit?
>
> Delete is performed without any errors or warnings but when i refresh
> the found set it is still in the table
What do you mean by "refresh the found set"? What client interface
are you using? Might the deleting transaction not be committing?
What happens if you do the delete using psql? What version of
PostgreSQL are you running?
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | surabhi.ahuja | 2006-07-13 06:20:30 | cant connect to the database, even after doing start of postmaster using a script |
| Previous Message | Michael Fuhr | 2006-07-13 05:10:07 | Re: Delete Problem |