Re: ERROR: current transaction is aborted, commands ignored until end of transaction block - Mailing list pgsql-general

On Mon, Oct 16, 2006 at 06:54:31AM -0700, DXScale452 wrote:
> if if i swap the ordering of any of these tables.... the second in the list always fail...
>
> HERE is the syntax of the statements before the fail
> -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
> SELECT value FROM table1
> INSERT INTO table1 (numeric_type, value_description) VALUES (0,'Description')
> SELECT value FROM table2
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_

There must be another error you're not displaying. If you have a look
at the server log file, what do you see?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.