Testing - Please ignore/delete this message

[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 [ í ]

After the last update

[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, mixed mode, 
sharing)

and, yes... Debian 12.

For some reason NB is not longer able to interact with PG since the last 
PG package update from Debian.

Is anyone else experiencing the same problem, or is it just me; I wonder.

The question is, how can I tackle this issue.

Thanks in advance.

--
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 [ í ]

Re: After the last update

[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 Runtime Environment (build 17.0.9+9-Debian-1deb12u1)
OpenJDK 64-Bit Server VM (build 17.0.9+9-Debian-1deb12u1, mixed mode, 
sharing)

and, yes... Debian 12.

For some reason NB is not longer able to interact with PG since the last


Define NB.

Error messages are?


PG package update from Debian.


Update from what to what?

Is anyone else experiencing the same problem, or is it just me; I 
wonder.


The question is, how can I tackle this issue.

Thanks in advance.




--
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 [ í ]

Re: After the last update

[Arbol One]

Bro., is in the OP.

-

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, mixed mode, 
sharing)

and, yes... Debian 12.

For some reason NB is not longer able to interact with PG since the last 
PG package update from Debian.

Is anyone else experiencing the same problem, or is it just me; I wonder.

The question is, how can I tackle this 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 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, mixed 
mode, sharing)

and, yes... Debian 12.

For some reason NB is not longer able to interact with PG since the 
last


Define NB.

Error messages are?


PG package update from Debian.


Update from what to what?

Is anyone else experiencing the same problem, or is it just me; I 
wonder.


The question is, how can I tackle this issue.

Thanks in advance.






--
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 [ í ]

Password forgotten

[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 user "postgres"
connection to server at "localhost" (::1), port 5432 failed: FATAL:  
password authentication failed for user "postgres"

*

Is there a way I can retrieve this master password?

Thanks in advance.


--
*/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 postres installed?

[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 I don't know where the 
'apt-get' installed it or why it did not add it to the path.


Is there a way I can locate the installation directory?

Thank in advance.

--
*/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?

[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 I don't know where the 
'apt-get' installed it or why it did not add it to the path.


Is there a way I can locate the installation directory?

Thank in advance.

--
*/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 [ í ]

Re: Where is my app installed?

[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 [ í ]

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

[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 do it without unsubscribing and then subscribing to a 
new email ?


--
Regards,
Muhammad Ikram


--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

Re: Questions about document "Concurrenry control" section

[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 reply to the mailing list only. Otherwise 
we'll receive multiple copies of the emails.





--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

JDBC using REFERENCES

[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(" (");
    sql.append("index SERIAL NOT NULL, ");
    sql.append("id TEXT PRIMARY KEY, ");
    sql.append("day TEXT NOT NULL, ");
    sql.append("month TEXT NOT NULL, ");
    sql.append("year TEXT NOT NULL, ");
    sql.append("hour TEXT NOT NULL, ");
    sql.append("minute TEXT NOT NULL, ");
    sql.append("second TEXT NOT NULL, ");
    sql.append("millisecond TEXT NOT NULL, ");
    sql.append("am_pm TEXT NOT NULL, ");
    sql.append("admin boolean NOT NULL DEFAULT false, ");
    sql.append("CONSTRAIN id PRIMARY KEY (id)"); *_<== Error_*
    sql.append(");");*

but I get a message saying :

Exception in thread "main" java.sql.SQLException: In 
company.contact.createTable()

ERROR: syntax error at or near "("
  Position: 315

Does JDBC allow us to do this?
What am I doing wrong?
How to fix this

--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

JDBC using REFERENCES

[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(" (");
    sql.append("index SERIAL NOT NULL, ");
    sql.append("id TEXT PRIMARY KEY, ");
    sql.append("day TEXT NOT NULL, ");
    sql.append("month TEXT NOT NULL, ");
    sql.append("year TEXT NOT NULL, ");
    sql.append("hour TEXT NOT NULL, ");
    sql.append("minute TEXT NOT NULL, ");
    sql.append("second TEXT NOT NULL, ");
    sql.append("millisecond TEXT NOT NULL, ");
    sql.append("am_pm TEXT NOT NULL, ");
    sql.append("admin boolean NOT NULL DEFAULT false, ");
    sql.append("CONSTRAIN id PRIMARY KEY (id)"); *_<== Error_*
    sql.append(");");*

but I get a message saying :

Exception in thread "main" java.sql.SQLException: In 
company.contact.createTable()

ERROR: syntax error at or near "("
  Position: 315

Does JDBC allow us to do this?
What am I doing wrong?
How to fix this

--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

Help with syntax error

[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 false,
CONSTRAINT key PRIMARY KEY (registrar_id) );

CREATE TABLE IF NOT EXISTS user_name (
user_name_id TEXT PRIMARY KEY REFERENCES registrar(registrar_id),
first_name TEXT NOT NULL,
middle_name TEXT NOT NULL,
last_name TEXT NOT NULL);*

When I enter the following pg commands :

*INSERT INTO registrar VALUES (DEFAULT, '18551420601012L23', '1', '12', 
'2024', '18', '55', '14', '207', 'PM');
INSERT INTO user_name '18551420601012L23', 'John', 'Fitzgerald', 
'Kennedy'); <= **/UserNameTable.write()/*


I get this message :

*/Exception in thread "main" java.sql.SQLException: In 
company.contact.Company$UserNameTable.write()

ERROR: syntax error at or near "'18551420601012L23'"
  Position: 23/
*

The error is in the user_name_id, which is a primary that references the 
table "*registrar*" 's "*registrar_id" *primary key.
According to the documentation 
, the 
insertion should be OK, no?


What am I doing wrong?


--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

Re: Help with syntax error

[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 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 false,
CONSTRAINT key PRIMARY KEY (registrar_id) );

CREATE TABLE IF NOT EXISTS user_name (
user_name_id TEXT PRIMARY KEY REFERENCES registrar(registrar_id),
first_name TEXT NOT NULL,
middle_name TEXT NOT NULL,
last_name TEXT NOT NULL);*

When I enter the following pg commands :

*INSERT INTO registrar VALUES (DEFAULT, '18551420601012L23', '1', 
'12', '2024', '18', '55', '14', '207', 'PM');
INSERT INTO user_name '18551420601012L23', 'John', 'Fitzgerald', 
'Kennedy'); <= **/UserNameTable.write()/*




You don't see the difference between the first and second statements.

Hint, it starts with V.


I get this message :

*/Exception in thread "main" java.sql.SQLException: In 
company.contact.Company$UserNameTable.write()

ERROR: syntax error at or near "'18551420601012L23'"
   Position: 23/
*

The error is in the user_name_id, which is a primary that references 
the table "*registrar*" 's "*registrar_id" *primary key.
According to the documentation 
<https://www.postgresql.org/docs/current/tutorial-fk.html>, the 
insertion should be OK, no?


What am I doing wrong?


--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to 
providing free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]



--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

GRANT WITH INHERIT ??

[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 error:
/ERROR:  syntax error at or near "INHERIT"
LINE 1: GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;/*/
/*

Is there something I missed?


--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

Re: GRANT WITH INHERIT ??

[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 CREATEROLE;

GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;*

I get this error:
/ERROR:  syntax error at or near "INHERIT"
LINE 1: GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;/


--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

Wired behaviour from SELECT

[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 produces the wrong output
SELECT nickname, password FROM password WHERE nickname='Arbol';
 nickname | password
--+--
(0 rows)
What am I doing wrong?

Re: Wired behaviour from SELECT

[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='0938105618107N1';
  nickname   | password
-+--
 Piccard@@21 |  Arbol
(1 row)
However, if this sql statement produces the wrong output
*SELECT nickname, password FROM password WHERE nickname='Arbol';
 nickname | password
--+--
(0 rows)*
What am I doing wrong?

Naming a column in your table the same name as the table is 
problematic generally.  As for the query, if they are both intended to 
return the same row the value Arbol is in the password column, not the 
nickname column.  You seem to have reversed the data for the two columns.


David J.


--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

Re: Wired behaviour from SELECT

[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, password FROM password WHERE id='0938105618107N1';
  nickname   | password
-+--
 Piccard@@21 |  Arbol
(1 row)

Storing passwords in plain text is the Worst Possible Security 
Practice Ever Conceived.


--
Death to , and butter sauce.
Don't boil me, I'm still alive.
 lobster!

--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]

To uninstall or not to uninstall that is...

[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 of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]