Re: Way to retrieve UserName/Password

2025-11-22 Thread Igor Korot
David, On Sat, Nov 22, 2025 at 9:37 PM David G. Johnston wrote: > > On Saturday, November 22, 2025, Igor Korot wrote: >> >> >> WHat I'd like to do in my software is to get those parameters and use >> them in the "Connect To DB" dialog. > > > There is pretty much nothing special about this situat

Re: Way to retrieve UserName/Password

2025-11-22 Thread Igor Korot
Hi, David, On Sat, Nov 22, 2025 at 9:37 PM David G. Johnston wrote: > > On Saturday, November 22, 2025, Igor Korot wrote: >> >> >> WHat I'd like to do in my software is to get those parameters and use >> them in the "Connect To DB" dialog. > > > There is pretty much nothing special about this si

Re: Way to retrieve UserName/Password

2025-11-22 Thread David G. Johnston
On Saturday, November 22, 2025, Igor Korot wrote: > > > WHat I'd like to do in my software is to get those parameters and use > them in the "Connect To DB" dialog. There is pretty much nothing special about this situation pertaining to PostgreSQL. What specific challenge are you encountering?

Re: Way to retrieve UserName/Password

2025-11-22 Thread Ron Johnson
On Sat, Nov 22, 2025 at 10:22 PM Igor Korot wrote: > Hi, ALL, > I successfully built the server and I previously had the odbc driver > installed. > > I can successfully connect from psql from the Terminal, and from isql > unixODBC utility. > > However, what I wonder is - is there a simple way to

Way to retrieve UserName/Password

2025-11-22 Thread Igor Korot
Hi, ALL, I successfully built the server and I previously had the odbc driver installed. I can successfully connect from psql from the Terminal, and from isql unixODBC utility. However, what I wonder is - is there a simple way to retrieve UsrerName and Password from odbc.ini file? Below is my cu

Re: FK from logged to unlogged table?

2025-11-22 Thread Bernice Southey
wrote: > Is it allowed to key from a logged table to an unlogged table? I tried and it seems not: create unlogged table u(i int primary key); create table l(i int references u); ERROR: constraints on permanent tables may reference only permanent tables Interestingly it works in the other directio

Re: FK from logged to unlogged table?

2025-11-22 Thread David G. Johnston
On Friday, November 21, 2025, wrote: > Hello, > > I'm looking to improve bulk write performance on a table of about 23 > million rows by setting it unlogged. If lost, the table can be re-generated > from archived raw data. The unlogged table would be referenced from a > different, logged, table b

FK from logged to unlogged table?

2025-11-22 Thread dolan
Hello, I'm looking to improve bulk write performance on a table of about 23 million rows by setting it unlogged. If lost, the table can be re-generated from archived raw data. The unlogged table would be referenced from a different, logged, table by a sparse but very important foreign key. If