Re: ON CONFLICT DO NOTHING ignored on bulk insert

Are you wanting to minimize the locking time, or ensure the whole process completes as soon as possible? If the prior, you can insert into a temp table like the real one (which is maybe what pricelistnew is already), delete the rows where they don't have a valid reference, and then insert all

Re: ON CONFLICT DO NOTHING ignored on bulk insert

https://www.postgresql.org/docs/11/sql-insert.html#SQL-ON-CONFLICT "The optional ON CONFLICT clause specifies an alternative action to raising a *unique violation or exclusion constraint violation* error." El mar, 25 de may. de 2021 a la(s) 03:29, Geoff Winkless ( pgsqlad...@geoff.dj) escribió:

Re: Simple question from a beginner: Can I use PostgreSQL as a file database?

https://Dataverse.org is used by The Royal Danish Library (I have made a setup while employed there) - glassfish server with PostgreSQL as databasebackend. A very detailed documentation of how to setup is available too. Works fine and is free. Be sure to follow recommendations from dataverser.org.

Re: pgadmin4 SRPM

You can find sources for all platform packages of pgAdmin at https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=tree;f=pkg -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi*

Re: pgadmin4 SRPM

út 25. 5. 2021 v 14:56 odesílatel Ron napsal: > > The pgAdmin mailing list is a better place to ask: > https://www.pgadmin.org/support/list/ > > Postgres community repository has pgadmin too https://ftp.postgresql.org/pub/repos/yum/srpms/common/redhat/rhel-6.7-x86_64/ you can download srpms

Re: pgadmin4 SRPM

The pgAdmin mailing list is a better place to ask: https://www.pgadmin.org/support/list/ On 5/25/21 7:22 AM, Radomír Kůs wrote: Hello, I cannot find a spec file to build my own rpm of pgadmin4 for rhel8. At my company we have a security policy not to use any 3rd-party binaries, we have

pgadmin4 SRPM

Hello, I cannot find a spec file to build my own rpm of pgadmin4 for rhel8. At my company we have a security policy not to use any 3rd-party binaries, we have to compile everything from source and build our own rpms. Is src.rpm (srpm) and the .spec file available somewhere? Thank you very

Re: Simple question from a beginner: Can I use PostgreSQL as a file database?

Basically, you can store binary data by using blobs but that is not the best practice. A better approach would be to store your information in the database and to add a varchar column in which you store the folder and file name where the file is stored on your computer. Then you can retrieve it

Simple question from a beginner: Can I use PostgreSQL as a file database?

Hi everyone! I'm a middle student and new to join this mail list. I just want to ask a simple question: Can I use PostgreSQL as a file database? (I plan to make a web system to store my class note with some personal file) Please give me some suggestions,thank you in advance!

Re: I have no idea why pg_dump isn't dumping all of my data

‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 12:46, Ian Lawrence Barwick wrote: > 2021年5月21日(金) 20:42 Vijaykumar Jain vijaykumarjain.git...@gmail.com: > > > PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an > > Extension > > > > so it works as

Re: ON CONFLICT DO NOTHING ignored on bulk insert

On Tue, 25 May 2021 at 08:18, Andrus wrote: > Looking for a method to do bulk insert ignoring product foreign key > mismatches. > ON CONFLICT only works with unique constraints, it's not designed for what you're trying to use it for. Geoff

ON CONFLICT DO NOTHING ignored on bulk insert

Hi! Looking for a method to do bulk insert ignoring product foreign key mismatches. Only products which exist in product table should be added to price list. Tried update/truncate/insert     update pricelistnew set timestamp=to_char(now(), 'MMDDHH24MISS');     truncate pricelist;