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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
