Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pgloader mssql to postgres creates other tables with view filter #1603

Open
4 of 5 tasks
bheemvennapureddy opened this issue Aug 10, 2024 · 0 comments
Open
4 of 5 tasks

Comments

@bheemvennapureddy
Copy link

bheemvennapureddy commented Aug 10, 2024

  • pgloader --version

    3.6.9
    
  • did you test a fresh compile from the source tree?

  • did you search for other similar issues?

  • how can I reproduce the bug?

    Create a load files with a filter and copies more than whats expected.
    
    	pgloader --debug my.load
    
    
LOAD DATABASE
     FROM mssql://blah/dev
     INTO postgresql://blah/archive

MATERIALIZE VIEWS
       history AS $$ select * from Receipt where RECEIPT_KEY in ( 1010 ); $$
set work_mem to '32MB', maintenance_work_mem to '512 MB'
alter schema 'dbo' rename to 'arch'
ALTER TABLE NAMES MATCHING 'Receipt' IN SCHEMA 'dbo' RENAME TO 'receipt';

  • pgloader output you obtain

log.txt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant