Markus Mehrwald wrote:
> Hi,
>
> I do not think this will work. As far as I know foreign key checks are
> not triggers. Postgres is very strict with things concerning referential
> integrity so you cannot turn them off.
Actually you are mistaken -- FKs are triggers, and you can turn them
off.
Th
Hi,
I do not think this will work. As far as I know foreign key checks are
not triggers. Postgres is very strict with things concerning referential
integrity so you cannot turn them off.
Maybe it will help to use "--orig-order" for creating the dump.
Markus
Richard Huxton schrieb:
> Peter Bill
Peter Billen wrote:
> Hi all,
>
> I have a problem with foreign keys and data-only (no schema) backup. I
> have a simple table node (pseudo-SQL):
> When I do a data-only backup, the backup file contains following two lines:
>
> INSERT INTO NODE (node_id, parent_node_id) VALUES (2, 1);
> INSERT I
