To uninstall or not to uninstall that is...

2025-01-04 Thread Arbol One
Hello. In my Debian 12 machine, I have PostgreSQL-15 installed; I'd like to upgrade to PostgreSQL-16. Should I first uninstalled PostgreSQL-15 and then install PostgreSQL-16 or is there a way to just do an upgrade? Thanks. -- */ArbolOne ™/* Using Fire Fox and Thunderbird. ArbolOne is composed

Re: GRANT WITH INHERIT ??

2024-12-06 Thread Arbol One
Resolved. Thanks On 2024-12-06 7:40 a.m., Arbol One wrote: When enter this commands in psql : *sudo -u postgres psql CREATE GROUP arbolone_dev_group; // Create a group CREATE ROLE company_admin LOGIN PASSWORD 'myPassword' CREATEDB IN GROUP arbolone_dev_group CREATERO

GRANT WITH INHERIT ??

2024-12-06 Thread Arbol One
Hello. When enter this commands in psql : *sudo -u postgres psql CREATE GROUP arbolone_dev_group; // Create a group CREATE ROLE company_admin LOGIN PASSWORD 'myPassword' CREATEDB IN GROUP arbolone_dev_group CREATEROLE; GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;* I get this e

Help with syntax error

2024-12-01 Thread Arbol One
I have these tables: *CREATE TABLE IF NOT EXISTS registrar ( index SERIAL, registrar_id TEXT, day TEXT NOT NULL, month TEXT NOT NULL, year TEXT NOT NULL, hour TEXT NOT NULL, minute TEXT NOT NULL, second TEXT NOT NULL, millisecond TEXT NOT NULL, am_pm TEXT NOT NULL, admin BOOLEAN NOT NULL DEFAULT

Re: Help with syntax error

2024-12-01 Thread Arbol One
😳 O, I feel so dumb, that I find it so funny!! Thanks man!!! I need to step away from the computer for a while, I think fatigue is getting the best of me. On 2024-12-01 7:17 p.m., Adrian Klaver wrote: On 12/1/24 16:14, Arbol One wrote: I have these tables: *CREATE TABLE IF NOT EXISTS

JDBC using REFERENCES

2024-11-24 Thread Arbol One
In an application that uses JDBC I am trying to use the following statement *   // Table parameters     var sql = new MyString();     sql.setData("CREATE TABLE IF NOT EXISTS ");     sql.append(this.tableName);     sql.append(" (");  

JDBC using REFERENCES

2024-11-24 Thread Arbol One
In an application that uses JDBC I am trying to use the following statement *   // Table parameters     var sql = new MyString();     sql.setData("CREATE TABLE IF NOT EXISTS ");     sql.append(this.tableName);     sql.append(" (");  

Re: Wired behaviour from SELECT

2024-11-23 Thread Arbol One
Yes! Absolutely true. Thanks for the advice 🙂 On 2024-11-22 3:36 p.m., Ron Johnson wrote: On Fri, Nov 22, 2024 at 3:07 PM Arbol One wrote: Two different SELECT sql statement don't behave the same way. The below sql statement produces the right output SELECT nickname, pas

Re: Wired behaviour from SELECT

2024-11-23 Thread Arbol One
Oops! I am putting too many hours in front of the computer, better take a break 😳 On 2024-11-22 3:12 p.m., David G. Johnston wrote: On Fri, Nov 22, 2024 at 1:07 PM Arbol One wrote: The below sql statement produces the right output SELECT nickname, password FROM password WHERE id

Wired behaviour from SELECT

2024-11-22 Thread Arbol One
Two different SELECT sql statement don't behave the same way. The below sql statement produces the right output SELECT nickname, password FROM password WHERE id='0938105618107N1'; nickname | password -+-- Piccard@@21 | Arbol (1 row) However, if this sql statement produce

Re: Questions about document "Concurrenry control" section

2024-10-12 Thread Arbol One
Yes, this is IMOP, the best way. I have set up Thunderbird to throw everything that is not in my contact list to Trash, thus your email will never be read by me if you don't use - Reply to Mailing list -. Just saying. On 2024-10-11 11:10 p.m., admin@iseki.space wrote: I found. Maybe we should

Re: Is there a way to change email for subscription ?

2024-09-06 Thread Arbol One
Hi back to you. I would unsubscribe the undesired email from the mailing-list, and then subscribe the desired email. Simple as that! Hope this help you. On 2024-09-05 12:09 a.m., Muhammad Ikram wrote: Hi, I want to change email for my PostgreSQL community subscriptions. Is there a way to

Re: Where is my app installed?

2024-08-23 Thread Arbol One
Thanks everyone, the issue was resolved. -- */ArbolOne.ca/* Using Fire Fox and Thunderbird. ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations. ArbolOne on Java Development is in progress [ í ]

Where is my app installed?

2024-08-22 Thread Arbol One
After installing PostgreSQL on my Debian-12 machine, I typed 'postgres --version' and got this msg: *bash: postgres: command not found* 'psql --version', however, does work and gives me this message : *psql (PostgreSQL) 16.3 (Debian 16.3-1.pgdg120+1)* Obviously postgres is not in the path, but

where is postres installed?

2024-08-22 Thread Arbol One
After installing PostgreSQL on my Debian-12 machine, I typed 'postgres --version' and got this msg: *bash: postgres: command not found* 'psql --version', however, does work and gives me this message : *psql (PostgreSQL) 16.3 (Debian 16.3-1.pgdg120+1)* Obviously postgres is not in the path, but

Password forgotten

2024-04-23 Thread Arbol One
Hello. In my Debian box, after entering this command to psql-16, *psql -h localhost -U postgres* psql-16 asks for the password, which I have forgotten. So I get this message: *psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for

Re: After the last update

2024-01-15 Thread Arbol One
issue. Thanks in advance. --- On 2024-01-15 6:22 p.m., Adrian Klaver wrote: On 1/15/24 14:38, Arbol One wrote: Netbeans 20. Sorry, my bad. And the rest of the questions? On 2024-01-15 4:48 p.m., Adrian Klaver wrote: On 1/15/24 13:33, Arbol One wrote: I am working on an

Re: After the last update

2024-01-15 Thread Arbol One
Netbeans 20. Sorry, my bad. On 2024-01-15 4:48 p.m., Adrian Klaver wrote: On 1/15/24 13:33, Arbol One wrote: I am working on an application using NB-20, PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian 15.5-1.pgdg120+1)), postgresql-42.7.0.jar. openjdk 17.0.9 2023-10-17 OpenJDK

After the last update

2024-01-15 Thread Arbol One
I am working on an application using NB-20, PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian 15.5-1.pgdg120+1)), postgresql-42.7.0.jar. openjdk 17.0.9 2023-10-17 OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1) OpenJDK 64-Bit Server VM (build 17.0.9+9-Debian-1deb12u1, mix

Testing - Please ignore/delete this message

2024-01-02 Thread Arbol One
Did it work? -- ArbolOne.ca Using Fire Fox and Thunderbird. ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations. ArbolOne on Java Development is in progress [ í ]