Re: File Foreign Table Doesn't Exist when in Exception

2020-04-16 Thread Adrian Klaver
On 4/16/20 3:59 PM, Virendra Kumar wrote: Please reply to list also. Ccing list. Thank you Adrian! I know the data is malformed I am more concerned about the behavior that the foreign table itself doesn't exists when it has malformed data and is being queried in anonymous block. https://www.

Re: File Foreign Table Doesn't Exist when in Exception

2020-04-16 Thread Adrian Klaver
On 4/16/20 3:39 PM, Virendra Kumar wrote: Hello Everyone, I have a weird situation with file_fdw extension when I am creating a foreign table in anonymous block. Here is setup: Create extension and server: == postgres=# create extension file_fdw; CREATE EXTENSION postgres=

File Foreign Table Doesn't Exist when in Exception

2020-04-16 Thread Virendra Kumar
Hello Everyone, I have a weird situation with file_fdw extension when I am creating a foreign table in anonymous block. Here is setup: Create extension and server:== postgres=# create extension file_fdw; CREATE EXTENSION postgres=# CREATE SERVER log_server FOREIGN DATA WRAPPER