I recently started receiving this error as well, this was because I
disabled autocommit.
With the following option in .psqlrc the error doesn't wait for a
rollback but automatically creates a savepoint allowing you to fix the
error and continue:
This is now in my .psqlrc:
\set AUTOCOMMIT off
\set
I have the following setup:
A table called hand:
Table "stage.hand_meta"
Column | Type |
Modifiers
---+--+-
hand_id | integer
> BTW, add a foreign key and index on handhistory_plain.hand_id (unless> you
> have it already).
It's there already:
feiketracker=# \d+ handhistory_plain;
Table "stage.handhistory_plain"
Column | Type | Modifiers | Storage | Description
-+-+---+--
oops, but ofcourse, a natural view will not give the correct answer,
back to the drawing board ...
On Tue, Jan 17, 2012 at 19:53, Feike Steenbergen
wrote:
>> BTW, add a foreign key and index on handhistory_plain.hand_id (unless> you
>> have it already).
> It's there al
