Re: PgAmin view

2023-10-27 Thread Merlin Moncure
On Thu, Oct 26, 2023 at 5:56 AM Shaozhong SHI wrote: > If a PgAmin view is created and tables it queries are missing, what will > happen? > > If a PdAmin view is created, and it may take 20 hours to complete, what > will happen? > > Would views automatically run, when

Re: PgAmin view

2023-10-26 Thread Adrian Klaver
On 10/26/23 03:56, Shaozhong SHI wrote: If a PgAmin view is created and tables it queries are missing, what will happen? Easy enough to test: create view test_vw as select * from non_existent_table; ERROR: relation "non_existent_table" does not exist LINE 1: create view test_vw

Re: PgAmin view

2023-10-26 Thread David G. Johnston
On Thursday, October 26, 2023, Shaozhong SHI wrote: > If a PgAmin view is created and tables it queries are missing, what will > happen? > > If a PdAmin view is created, and it may take 20 hours to complete, what > will happen? > > Would views automatically run, when

PgAmin view

2023-10-26 Thread Shaozhong SHI
If a PgAmin view is created and tables it queries are missing, what will happen? If a PdAmin view is created, and it may take 20 hours to complete, what will happen? Would views automatically run, when you start the PgAmin? Regards, David