Re: Semi-unable to add new records to table--primary key needed?

On 12/20/19 11:02 PM, Adrian Klaver wrote: On 12/20/19 6:28 PM, Ron wrote: The lack of PK should make insertions *more* forgiving.  (It really should have a PK, but that's irrelevant to this problem.) Actually it is the problem: https://www.pgadmin.org/docs/pgadmin4/4.16/editgrid.html "If t

Re: Semi-unable to add new records to table--primary key needed?

On 12/20/19 6:28 PM, Ron wrote: The lack of PK should make insertions *more* forgiving.  (It really should have a PK, but that's irrelevant to this problem.) Actually it is the problem: https://www.pgadmin.org/docs/pgadmin4/4.16/editgrid.html "If the table definition does not include an OID

Re: Semi-unable to add new records to table--primary key needed?

"Boylan, Ross" writes: > I have a table that seems to act for some purposes as if I can't add new > records to it. I would like to understand why that is and fix it. > The initial problem was that an MS-Access application using an ODBC driver > (driver and database 64 bit PG 12.0) failed at >

Re: Semi-unable to add new records to table--primary key needed?

On 12/20/19 8:19 PM, Boylan, Ross wrote: I have a table that seems to act for some purposes as if I can't add new records to it. I would like to understand why that is and fix it. The initial problem was that an MS-Access application using an ODBC driver (driver and database 64 bit PG 12.0) f

Semi-unable to add new records to table--primary key needed?

I have a table that seems to act for some purposes as if I can't add new records to it. I would like to understand why that is and fix it. The initial problem was that an MS-Access application using an ODBC driver (driver and database 64 bit PG 12.0) failed at DoCmd.GoToRecord , , acNewRec

Re: Upgrading from PostgreSQL 9.3 to 11.6

On 2019-12-20 09:02, Justin wrote: Hi Tony Can you describe the database in greater detail? how many tables, type of data, how big is the down time window? So this will be on new server hardware, and new DB install, what OS? and extensions being used, has there been any testing with apps

Re: Upgrading from PostgreSQL 9.3 to 11.6

On 12/20/19 5:58 AM, t...@exquisiteimages.com wrote: I have a PostgreSQL 9.3 installation that I finally have time to migrate to a currently supported version. The server that the installation is installed on is also at its end of service. Can anyone help me with completing this conversion as

BigSQL pgc alternative

Hi all. BigSQL still allow to install Postgres and others resources as like a portable install. But today, it's only offer your tool (pgc) for newer Postgresql versions. I would like to install as portable option because it's more easy to config and use in my own user in my development station.

Re: install postgres

On Fri, 2019-12-20 at 10:24 +0100, Marc Millas wrote: > I may overlook something obvious.. > I am just looking, on the download pages of postgresql.org > for a way to download rpm.(for redhat 6 and redhat 7 x64 machines) > NOT the noarch, but the full distro. > Reason is I have to install postgre

Upgrading from PostgreSQL 9.3 to 11.6

I have a PostgreSQL 9.3 installation that I finally have time to migrate to a currently supported version. The server that the installation is installed on is also at its end of service. Can anyone help me with completing this conversion as securely and efficiently as possible with the least a

Re: install postgres

Hi, there's a section "Direct RPM download" ;) Or https://download.postgresql.org/pub/repos/yum/12/redhat/ regards Thomas Am 20.12.19 um 10:24 schrieb Marc Millas: Hi, I may overlook something obvious.. I am just looking, on the download pages of postgresql.org for a

install postgres

Hi, I may overlook something obvious.. I am just looking, on the download pages of postgresql.org for a way to download rpm.(for redhat 6 and redhat 7 x64 machines) NOT the noarch, but the full distro. Reason is I have to install postgres on a network with NO internet access. Thanks, Marc MILL