Greg Sabino Mullane wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
cut and paste:
set ON_ERROR_ROLLBACK;
Should be
\set ON_ERROR_ROLLBACK on
You can also set this when calling psql like so:
psql --set ON_ERROR_ROLLBACK=on
But that's getting off-topic now, as we've got the problem narrowed:
INSERT 0 1
This shows the session_replication_role is working as it should. Double
check where and how you are setting it; your foreign key problems
will go away once it is set correctly.
I'm not sure how to address this. I'm not exactly sure where to place
session_replication_role. It's very close to the top of the file:
--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF-8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
set session_replication_role = replica;
I'm still getting the errors. If it doesn't belong at the beginning of
this process, I'm not exactly sure where it should go.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
