Yes, I reproduced the issue in SQL Server 2014. I am still looking on why the destination schema is not passed to the provider (either subscription is not configured properly, or the OLEDB provider must support additional properties).
). It does the trick.
Code:
exec sp_addsubscription @publication = N'pgnpsnap1', @subscriber = N'localhost', @destination_db = N'postgres',
@subscription_type = N'Push',
@sync_type = N'automatic',
@article = N'all', @update_mode = N'read only',
-- type 3 is MUST for subscribers not oracle and ibmdb2 i.e. postgres
@subscriber_type = 3
. . .
exec sp_changesubscription @publication = N'pgnpsnap1', @subscriber = N'localhost',
@destination_db = N'postgres', @article = N'all',
@property=N'subscriber_providerstring',
@value=N'PORT=5444;BULK_INSERT=1000;BULK_METHOD=COPY;SEARCH_PATH=mysnap;'
. . .
exec sp_addpushsubscription_agent @publication = N'pgnpsnap1',
@subscriber = N'localhost', @subscriber_db = N'postgres',
@job_login = null, @job_password = null, @subscriber_security_mode = 0,
@subscriber_provider = N'PGNP',
@subscriber_datasrc = N'localhost',
@subscriber_location =N'',
@subscriber_provider_string = N'PORT=5444;BULK_INSERT=1000;BULK_METHOD=COPY;SEARCH_PATH=mysnap;',
@subscriber_catalog = N'postgres',
@subscriber_login = N'postgres', @subscriber_password =N'12345',
@frequency_type = 64,
@frequency_interval = 0, @frequency_relative_interval = 0,
@frequency_recurrence_factor = 0, @frequency_subday = 0,
@frequency_subday_interval = 0, @active_start_time_of_day = 0,
@active_end_time_of_day = 235959, @active_start_date = 20090715,
@active_end_date = 99991231, @enabled_for_syncmgr = N'False',
@dts_package_location = N'Distributor'
