pipelinedb icon indicating copy to clipboard operation
pipelinedb copied to clipboard

CREATE FOREIGN TABLE IF NOT EXISTS throws an error if the stream already exists

Open hedayat opened this issue 5 years ago • 0 comments

This command is expected to not throw an error when the foreign table exists, but currently it prints an error related to pipelinedb:

CREATE FOREIGN TABLE IF NOT EXISTS alerts (...) SERVER pipelinedb;

NOTICE: relation "alerts" already exists, skipping
ERROR: duplicate key value violates unique constraint "pipeline_stream_relid_index"

hedayat avatar Mar 06 '19 12:03 hedayat