mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
ea6c91b429
The support for drop default in (user defined) casting rules was completely broken in SQLite, because the code didn't even bother looking at what's returning after applying the casting rules. This patch fixes the code so that is uses the pgcol instance's default value, as per after applying casting rules. The bug also existed in a subtle form for MySQL and MS SQL, but would only show up there when the default value is spelled using a known variation of “current timestamp”.
11 lines
307 B
Fish
11 lines
307 B
Fish
load database
|
|
from 'sqlite/storage.sqlite'
|
|
into postgresql:///pgloader
|
|
|
|
with include drop, create tables, create indexes, reset sequences
|
|
|
|
set work_mem to '16MB',
|
|
maintenance_work_mem to '512 MB',
|
|
search_path to 'storage'
|
|
|
|
before load do $$ create schema if not exists storage; $$; |