Re: Seems to be impossible to set a NULL search_path

On 2022-07-06 20:47:19 -0700, Bryn Llewellyn wrote: > But never mind. If you'd like a diverting read on this topic, go here: > > https://blogs.oracle.com/sql/post/a-collection-of-plsql-essays > > look for this, and download the PDF: > > « > Names vs identifiers > > Databases are full of things:

Re: About revoking large number of privileges; And the PUBLIC role.

On 2022-07-07 09:47:38 +0200, Dominique Devienne wrote: > Hi. I'm struggling to delete databases because of grants to roles on > objects of those DBs. I don't understand this. You can drop objects (and databases containing objects) with grants to existing roles. It would be very inconvenient if th

- operator overloading not giving expected result

Hi, We are migrating our database from Oracle to Postgresql.  In oracle we have used this syntax "SELECT ('1999-12-30'::DATE) - ('1999-12-11'::DATE)" to get difference between two dates as a integer output (ex: 19).  But in Postgres the same query returns result as "19 days".  Because of this

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

Hi Team, Hi Team, We are using the below command to perform the PG Upgrade. '/opt///services/datastore/engine-new/bin/pg_upgrade' -b '/opt///services/datastore/engine/bin' -B '/opt///services/datastore/engine-new/bin' -d '/opt///db/data' -D '/opt///db/da

postgresql generate ddl returns FK with `()` in it

I have a schema with two tables, where the first table's composite 2-columns FK points to the second table's 2-columns composite PK. But the order of columns is reversed. When I use `Generate DDL` on the first table, FK definition comes back as: ALTER TABLE eval.rubric_questions ADD CONSTRAINT ru

Error when pasting function blocks into psql

Hello: I noticed that I'm getting errors when copy and pasting code for stored procedure from Windows directly into psql running in putty. To reproduce create a procedure that has multiple statements with each statements having multiple lines, similar to the ones below: CREATE OR REPLACE PROCEDUR

Why does pg_statio_user_tables report heap_blks_hit after index only scan?

Hey pgsql-general, while debugging some performance issues, I've noticed that index only scan (with number of heap fetches reported as 0) can still cause heap_blks_hit as reported by pg_statio_user_tables to increment (in my case by 1). For example, on 14.4:   create table test (a int);   C

CPU is 100% azure rds postgreSQL-11

Hi Team, One of our RDS postgresql -11 version CPU is drastically high continuously. we are unable to find what is causing. the server is 4Vcore 100 GB storage. is there any way what is causing the issue.? we have datadog integration with custom metrics. we have done all vacuum and analyze opera

postgresql bug

Hallo, there is a postgresql bug /usr/local/bin/postgres -V ld-elf.so.1: Shared object "libicui18n.so.70" not found, required by "postgres" Installed Version: postgresql14-server-14.1 find / -name "*libicui*" /usr/local/lib/libicuio.a /usr/local/lib/libicui18n.so.71 /usr/local/lib/libicuio.so.

Re: - operator overloading not giving expected result

On 2022-07-05 13:52:32 +0530, Rajesh S wrote: > We are migrating our database from Oracle to Postgresql.  In oracle we have > used this syntax "SELECT ('1999-12-30'::DATE) - ('1999-12-11'::DATE)" to get > difference between two dates as a integer output (ex: 19).  But in Postgres > the > same quer

Re: postgresql bug

On Fri, 2022-07-08 at 12:47 +0200, m...@ft-c.de wrote: > there is a postgresql bug An error need not be a bug. > /usr/local/bin/postgres -V > ld-elf.so.1: Shared object "libicui18n.so.70" not found, required by > "postgres" > > Installed Version: > postgresql14-server-14.1 > > find / -name "*li

Re: postgresql generate ddl returns FK with `()` in it

On 2022-07-07 07:05:53 -0600, Roman Gavrilov wrote: > I have a schema with two tables, where the first table's composite 2-columns > FK > points to the second table's 2-columns composite PK. But the order of columns > is reversed. > > When I use `Generate DDL` on the first table, FK definition co

Re: postgresql generate ddl returns FK with `()` in it

On Fri, 8 Jul 2022 at 12:37, Roman Gavrilov wrote: > I have a schema with two tables, where the first table's composite 2-columns > FK points to the second table's 2-columns composite PK. But the order of > columns is reversed. Note sql does not look at the NAMES of the foreign key columns or t

Re: postgresql bug

## m...@ft-c.de (m...@ft-c.de): > /usr/local/bin/postgres -V > ld-elf.so.1: Shared object "libicui18n.so.70" not found, required by > "postgres" You screwd up your upgrades: that postgres binary was built against ICU 70, but as hou have shown you have ICU 71 installed: > find / -name "*libicui*"

Re: Error when pasting function blocks into psql

Hi Ludwig: On Fri, 8 Jul 2022 at 12:37, Ludwig Isaac Lim wrote: > I noticed that I'm getting errors when copy and pasting code for stored > procedure from Windows directly into psql running in putty. > To reproduce create a procedure that has multiple statements with each > statements having mu

Re: CPU is 100% azure rds postgreSQL-11

Hi Pavan, Could you please check the CPU utilization graph and the queries running during the same timeframe. I would be able to help more on this issue if I could have more information. *Thanks and Regards,* *Sunil M. K. Thakur* *Database Architect* On Fri, 8 Jul 2022 at 16:08, Pavan Kumar S

Re: - operator overloading not giving expected result

Hi Rajesh: On Fri, 8 Jul 2022 at 12:36, Rajesh S wrote: > We are migrating our database from Oracle to Postgresql. In oracle we have > used this syntax "SELECT ('1999-12-30'::DATE) - ('1999-12-11'::DATE)" to get > difference between two dates as a integer output (ex: 19). But in Postgres > t

Re: - operator overloading not giving expected result

## Rajesh S (rajes...@fincuro.com): > We are migrating our database from Oracle to Postgresql.  In oracle we > have used this syntax "SELECT ('1999-12-30'::DATE) - > ('1999-12-11'::DATE)" to get difference between two dates as a integer > output (ex: 19).  But in Postgres the same query returns

Re: - operator overloading not giving expected result

Christoph Moench-Tegeder writes: > ## Rajesh S (rajes...@fincuro.com): >> We are migrating our database from Oracle to Postgresql.  In oracle we >> have used this syntax "SELECT ('1999-12-30'::DATE) - >> ('1999-12-11'::DATE)" to get difference between two dates as a integer >> output (ex: 19). 

Re: Error when pasting function blocks into psql

Ludwig Isaac Lim writes: > Hello: > I noticed that I'm getting errors when copy and pasting code for stored > procedure from Windows directly into psql running in putty. > To reproduce create a procedure that has multiple statements with each > statements having multiple lines, similar to the on

Re: - operator overloading not giving expected result

LANGUAGE 'edbspl' This is the root cause of your issue. You are not using PGSQL, but EDB version of it which is compatible with Oracle PL/SQL.

Database designs

Hi, This link with hundreds of database designs is expired. http://databaseanswers.org/data_models/index_all_models.htm Is there a similar website with database designs ? https://www.backbutton.org ¯\_(ツ)_/¯ ♡۶♡ ۶♡۶

Re: Database designs

Zahid, This appears to be the most recently archived version. All of the links on the page work. https://web.archive.org/web/2021070100*/http://databaseanswers.org/data_models/index_all_models.htm

Re: Database designs

so 9. 7. 2022 v 0:53 odesílatel Pete Yunker napsal: > > Zahid, > > This appears to be the most recently archived version. All of the links on > the page work. > > https://web.archive.org/web/2021070100*/http://databaseanswers.org/data_models/index_all_models.htm I have checked that as well,

Re: Database designs

I’m seeing the ERD images on the 10 links I’ve checked. What is an example of a detail page where you aren’t seeing them? > On Jul 8, 2022, at 6:55 PM, Josef Šimánek wrote: > > so 9. 7. 2022 v 0:53 odesílatel Pete Yunker > napsal: >> >> Zahid, >> >> This appears to be the most recently arch

Re: Database designs

so 9. 7. 2022 v 1:02 odesílatel Pete Yunker napsal: > > I’m seeing the ERD images on the 10 links I’ve checked. What is an example > of a detail page where you aren’t seeing them? For example here - https://web.archive.org/web/20191227184610/http://www.databaseanswers.org/data_models/martin/ind

range with infinity bound data type disallow extra empty white space.

Hi, there. Not sure this is a bug, or intentional. select '[1, )'::int8range; --fail. select '[1,)'::int8range; --ok. tested on pg14.4, pg15.1 -- I recommend David Deutsch's <> Jian