mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-07 14:56:59 +02:00
656bf85075
The code emitted by pgloader to transform input fields into PostgreSQL column values was using too many optimization declarations, some of them that SBCL failed to follow through for lack of type marking in the generated code. As SBCL doesn't have enough information to be optimizing anyway, at least we can make it so that we don't have a warning about it. The new code does that. Fixes #803.
46 lines
974 B
Fish
46 lines
974 B
Fish
/*
|
|
* This test is ported from pgloader 2.x where it was defined as:
|
|
*
|
|
* [allcols]
|
|
* table = allcols
|
|
* format = csv
|
|
* filename = allcols/allcols.data
|
|
* field_sep = :
|
|
* columns = *
|
|
* pg_option_work_mem = 14MB
|
|
*
|
|
*/
|
|
|
|
LOAD CSV
|
|
FROM inline (a, b, c)
|
|
INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0))
|
|
|
|
WITH fields optionally enclosed by '"',
|
|
fields escaped by double-quote,
|
|
fields terminated by ':'
|
|
|
|
SET client_encoding to 'latin1',
|
|
work_mem to '14MB',
|
|
standard_conforming_strings to 'on'
|
|
|
|
BEFORE LOAD DO
|
|
$$ drop table if exists allcols; $$,
|
|
$$ create table allcols (
|
|
a integer primary key,
|
|
b date,
|
|
c text
|
|
);
|
|
$$;
|
|
|
|
|
|
|
|
|
|
1:2008-02-18:first entry
|
|
2:2008-02-19:second one
|
|
3:2008-02-20:another
|
|
4:2008-02-21:still running
|
|
5:2008-02-22:well, some more
|
|
6:2008-02-23:antepenultima
|
|
7:2008-02-24:next to last
|
|
8:2008-02-25:hey, it's today!
|