You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Whenever I use Postgres' \ir to import my pipelinedb SQL script(s), errors like this show up:
2019-03-2017:50:14.701 EDT [11573] lusca@lusca ERROR: relation with OID0 does not exist
2019-03-2017:50:14.701 EDT [11573] lusca@lusca STATEMENT: DROP TRIGGER process_response_trg ONlusca.responses;
2019-03-2017:50:14.707 EDT [11573] lusca@lusca ERROR: could not open relation with OID02019-03-2017:50:14.707 EDT [11573] lusca@lusca STATEMENT: DROP VIEW lusca.http_fetch;
2019-03-2017:50:14.707 EDT [11573] lusca@lusca ERROR: could not open relation with OID02019-03-2017:50:14.707 EDT [11573] lusca@lusca STATEMENT: DROP VIEW lusca.http_fetch;
However, if i just read the script directly e.g. psql < pipelinedb.sql then these errors don't occur.
Any clue why this might be happening? I'd like to \ir pipelinedb.sql in my main.sql file so that I have one entrypoint to a collection of files, but it's not a huge deal since I can always just move everything from pipelinedb.sql to main.sql.
The text was updated successfully, but these errors were encountered:
Whenever I use Postgres'
\ir
to import my pipelinedb SQL script(s), errors like this show up:However, if i just read the script directly e.g.
psql < pipelinedb.sql
then these errors don't occur.Any clue why this might be happening? I'd like to
\ir pipelinedb.sql
in mymain.sql
file so that I have one entrypoint to a collection of files, but it's not a huge deal since I can always just move everything frompipelinedb.sql
tomain.sql
.The text was updated successfully, but these errors were encountered: