mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-08 07:16:58 +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.
10 lines
222 B
Fish
10 lines
222 B
Fish
load database
|
|
from 'sqlite/test_pk.db'
|
|
into postgresql:///pgloader
|
|
|
|
before load do
|
|
$$ drop schema if exists sqlite cascade; $$,
|
|
$$ create schema if not exists sqlite; $$
|
|
|
|
set search_path to 'sqlite';
|