python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - postgres-10

Error: Consult the last few lines of "pg_upgrade_dump_1.log"

I wanted to ugrade my postgresql database from v10 to v14 I have run these commands in windows command prompt: C:\Users\mahajan>CD C:\Program Files\PostgreSQL\14\bin C:\Program Files\PostgreSQL\14\...
test-img

mahajan

windows

postgresql

postgresql-14

postgres-10

pg-upgrade

Votes: 0

Answers: 1

Latest Answer

Omit the cd in the beginning and stay in a directory where you have write permissions. Then pg_upgrade can write the log files that contain the actual problem. The error message that you then get is c...
test-img

Laurenz Albe

How to execute an insert or update operation in postgres 10 ( that not have store procedures)?

it is possible to execute an insert or update operation using only functions in postgres?. I am using version 10.14 that not support store procedures.
test-img

EdwinMald

database

postgresql

postgres-10

Votes: 0

Answers: 1

Latest Answer

You should use INSERT ... ON CONFLICT. It doesn't matter much if you run that from a function or not.
test-img

Laurenz Albe

Posts

Questions

Blogs

Jobs