Category : postgresql

Qt 5.15.2 (Linux) DB: PostgreSQL 13 (Linux) Updating a DB record using QSqlTableModel setData returns false on a second row. A query on the model’s lastError returns an empty string. Table preparation: create table email (nr integer NOT NULL,id serial primary key,priority integer not null,address varchar(100)) insert into email (nr, priority, address) values (358, 1, ..

Read more

wondering around psql. postgres-# ev staff_list 2 environment variable PSQL_EDITOR_LINENUMBER_ARG must be set to specify a line number https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-PATTERNS as the psql cli shows, in order to execute ev staff_list 2 I need know about PSQL_EDITOR_LINENUMBER_ARG. But I don’t know how to set environment variable: PSQL_EDITOR_LINENUMBER_ARG. So how to make ev staff_list 2 works in ..

Read more

I’m using Windows 10 WSL2 to install CentOS7. During the install of CentOS7, the dbus setup failed but the installation completed successfully. I’m now trying to setup a postgresql96 server which is failing because dbus is not in /etc/init.d/. Therefore the initial error during the CentOS7 failure is significant. I’ve tried to reinstall dbus using ..

Read more