| From: | patrick keshishian <patrick+pgsql(at)pioneerdigital(dot)com> |
|---|---|
| To: | Mona <mlisa(at)bisil(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2001-10-16 21:05:40 |
| Message-ID: | 20011016140540.W13487@pioneerdigital.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Try:
begin;
update TABLE set FIELDx = VALUEy
rollback;
On Sat, Oct 13, 2001 at 12:02:01PM +0530, Mona wrote:
>
> We are trying to rollback an update in postgres. But so far we have not been able to do it.
> When we Rollback..
> it says:
>
> ROLLBACK: No transaction in progress.
>
> Same happens with commit.
> We are used to SQL PlUS
>
> Without these facilities we really cannot go ahead with postgres db. Could you please help us out on this.
--
patrick keshishian
Gnu __ _
-o)/ / (_)__ __ ____ __
/\\ /__/ / _ \/ // /\ \/ /
_\_v __/_/_//_/\_,_/ /_/\_\
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keary Suska | 2001-10-16 21:24:29 | Re: postgresql 7.1.3 |
| Previous Message | Dave Cramer | 2001-10-16 21:01:27 | Re: JDBC - Related Question. |