mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-07 14:56:59 +02:00
25e5ea9ac3
Given new SQLite test case from issue #563 we see that pgloader doesn't handle errors gracefully in post-copy stage. That's because the API were not properly defined, we should use pgsql-execute-with-timing rather than other construct here, because it allows the "on error resume next" behavior we want with after load DDL statements. See #563.
15 lines
289 B
SQL
Vendored
15 lines
289 B
SQL
Vendored
--
|
|
-- sqlite3 -batch test_pk.db < sqlite_pk.sql
|
|
--
|
|
|
|
PRAGMA foreign_keys = ON;
|
|
|
|
CREATE TABLE division_kind (
|
|
division_kind_id INTEGER PRIMARY KEY
|
|
);
|
|
|
|
CREATE TABLE division (
|
|
division_id INTEGER PRIMARY KEY,
|
|
division_kind_id INTEGER REFERENCES division_kind(division_kind_id)
|
|
);
|