Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Adrian Klaver
On 12/7/24 15:58, Igor Korot wrote: Hi, Adrian, What distinguishes your tables from other users' tables? I am making the tables and naming them with a specific pattern. Now I'm curious - if I start psql and will want to create a table named pg_am, what will happen? I presume psql will prod

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread David G. Johnston
On Sat, Dec 7, 2024 at 4:59 PM Igor Korot wrote: > > I am making the tables and naming them with a specific pattern. > > Now I'm curious - if I start psql and will want to create a table > named pg_am, what will happen? > I presume psql will produce error saying that the system table with > that

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Rob Sargent
But not to me. My application targets developers, not end users. Thank you. What does your app enable developers to do?

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Igor Korot
Hi, Adrian, On Sat, Dec 7, 2024 at 5:07 PM Adrian Klaver wrote: > > On 12/7/24 12:17, Igor Korot wrote: > > Hi, Adrian, > > > > On Sat, Dec 7, 2024 at 12:32 PM Adrian Klaver > > wrote: > >> > >> On 12/7/24 09:59, Igor Korot wrote: > >>> Hi, Adrian, > >>> > >>> On Sat, Dec 7, 2024 at 11:18 AM Ad

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Adrian Klaver
On 12/7/24 12:17, Igor Korot wrote: Hi, Adrian, On Sat, Dec 7, 2024 at 12:32 PM Adrian Klaver wrote: On 12/7/24 09:59, Igor Korot wrote: Hi, Adrian, On Sat, Dec 7, 2024 at 11:18 AM Adrian Klaver wrote: On 12/6/24 19:36, Igor Korot wrote: Hi, All, When my application starts up, ot creat

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Igor Korot
Hi, Adrian, On Sat, Dec 7, 2024 at 12:32 PM Adrian Klaver wrote: > > On 12/7/24 09:59, Igor Korot wrote: > > Hi, Adrian, > > > > On Sat, Dec 7, 2024 at 11:18 AM Adrian Klaver > > wrote: > >> > >> On 12/6/24 19:36, Igor Korot wrote: > >>> Hi, All, > >>> > >>> When my application starts up, ot cr

Re: Errors when restoring backup created by pg_dumpall

2024-12-07 Thread David G. Johnston
On Sat, Dec 7, 2024 at 12:25 PM PopeRigby wrote: > > It actually looks like setting those all to have public fixed all the > errors, including the one with lldap. So, how can I get it to not put > public there automatically for next time? > > I assume you mean "get it to put public there" (i.e.,

Re: Errors when restoring backup created by pg_dumpall

2024-12-07 Thread PopeRigby
On 12/5/24 14:48, Adrian Klaver wrote: On 12/5/24 14:32, PopeRigby wrote: On 12/1/24 13:55, Tom Lane wrote: Adrian Klaver writes: On 12/1/24 13:14, Tom Lane wrote: It would be useful to know what is the command at line 4102 of all.sql. It is here: https://gist.github.com/poperigby/fcb59eb6c

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Adrian Klaver
On 12/7/24 09:59, Igor Korot wrote: Hi, Adrian, On Sat, Dec 7, 2024 at 11:18 AM Adrian Klaver wrote: On 12/6/24 19:36, Igor Korot wrote: Hi, All, When my application starts up, ot creates some tables and insert records in them. When the app starts for the second time it should check if the

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Igor Korot
Hi, Adrian, On Sat, Dec 7, 2024 at 11:18 AM Adrian Klaver wrote: > > On 12/6/24 19:36, Igor Korot wrote: > > Hi, All, > > > > When my application starts up, ot creates some tables and insert records > > in them. > > > > When the app starts for the second time it should check if the tables > > and

Re: Insert records in the tavke only if they are not exist

2024-12-07 Thread Adrian Klaver
On 12/6/24 19:36, Igor Korot wrote: Hi, All, When my application starts up, ot creates some tables and insert records in them. When the app starts for the second time it should check if the tables and the records in them are exist and skip the process. Does this also apply to starts after