Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

Am 22.05.25 21:04 schrieb(en) Adrian Klaver: > On 5/22/25 10:52, Achilleas Mantzios wrote: > > Hi people > > > > I'd like to know if people here know of or use any integrated solution > > for all or some of the above. It would be nice if it supported LDAP / > > OAuth 2.0 , integrate with plain v

Passing enum Parameters to User-defined C-Language Functions

Hi, I have a (I hope not too dumb) question regarding the use of enum parameters in a user-defined function written in C, e.g. for the example given in [1]: CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy'); - How would a “mood” parameter be encoded when it is passed to the function? “Four byt

Re: Q: inet operators for IPv4 encapsulated in IPv6

Am 06.09.23 19:41 schrieb(en) Erik Wienhold: The docs don't spell it out, but inet operators and functions expect values of the same inet family. Comparing IPv4 and IPv6 always returns false, e.g. [1]. The only hint in the docs that may imply this is [2]: "When sorting inet or cidr dat

Q: inet operators for IPv4 encapsulated in IPv6

I have a question regarding the use of inet operators in environments with mixed IPv4 and IPv6 notations. Consider the example from sect. 9.12. “Network Address Functions and Operators” in the docs which returns properly postgres=# select '192.168.1.5'::inet << '192.168.1/24'::inet; ?column?

Re: PostgreSQL and GUI management

Am 15.08.23 17:08 schrieb(en) Jason Long: Hello,Does PostgreSQL have a graphical environment for management or is it only managed through CLI? Have a look at DBeaver – I use the Eclipse plug-in, but there are stand-alone (free) versions, too. Hth, Albrecht. pgpQ_nw8Yof

pg_upgradecluster fails if pg_hba.conf contains "@file" entries

Hi all, I run a PostgreSQL 14 database cluster on a Debian Bullseye (oldstable) box using the deb's from apt.postgresql.org. The configuration contains “indirect” entries in /etc/postgresql/14/main/pg_hba.conf, looking like e.g. hostssl @dblist.txt all 172.16.96.0/24

Q: pg_hba.conf separate database names file format

Hi, according to the docs, the database specification in the pg_hba.conf file can be read from a separate file (: “A separate file containing database names can be specified by preceding the file name with @.”) However, I could no

Re: index row size 2720 exceeds btree version 4

Am 10.08.22 06:57 schrieb(en) Daulat: We are facing an error while uploading data in a table that has two B-tree indexes. As per the Postgres documentation there is a limitation of b-tree index size but I need to know if there is any alternative to overcome this issue. [snip] UNIQUE INDEX uk_gv

Re: ERROR: could not attach to dynamic shared area

Am 24.03.21 17:09 schrieb(en) Laurenz Albe: > > ERROR: could not attach to dynamic shared area > > LOG: background worker "parallel worker" (PID 51151) exited with exit code 1 ​ Is that repeatable? No, it isn't. I'm running PGSql 13 since ~4 Months (cluster upgraded from v. 10), and updated t

ERROR: could not attach to dynamic shared area

Hi all, in the logs of my database server, I found the following message: ERROR: could not attach to dynamic shared area LOG: background worker "parallel worker" (PID 51151) exited with exit code 1 What is the meaning of the error? The box is running Debian Buster, using the official Postgr

Re: Unique index on hash of jsonb value - correct solution?

Hi, first, thanks a lot for your input! Am 19.05.20 16:16 schrieb(en) Stephen Frost: That's only going to work up to a certain size for that text and blob value too, of course.. These three columns (stripped-down code, there are more in the table) are a “lazy” import from various python scr

Unique index on hash of jsonb value - correct solution?

Hi all, in a database I have a table with a text, a jsonb and a bytea column, which together shall be unique, like: Column | Type | Collation | Nullable | Default -++---+--+- id | bigint | | n

Re: Error “cache lookup failed for function”

Sorry for the late reply, I've been on a short vacation… Am 21.02.20 21:44 schrieb(en) Adrian Klaver: 1) From your original post what does the below mean?: -- add several db functions One trigger function, plus two “normal” ones, all (yet) unused. -- replace a DB function: This was the -

Re: Error “cache lookup failed for function”

Am 20.02.20 21:41 schrieb(en) Adrian Klaver: It would be nice to know what: [snip] represented in: Dropping and re-creating the function is actually the last operation in the script. The function is /very/ simple (just a wrapper to hide all internals from "agent" clients): ---8<--

Re: Error “cache lookup failed for function”

Am 20.02.20 19:32 schrieb(en) Tom Lane: This is, actually, not very surprising. You dropped the old function while clients were using it. The new function is a completely unrelated object, even if it happens to have the same name. Yes, I agree that this was not a too clever approach… It d

Error “cache lookup failed for function”

Hi all, On a Debian Buster/64 Bit I run Postgres 11 (apt-cache info): Package: postgresql-11 Version: 11.7-0+deb10u1 Maintainer: Debian PostgreSQL Maintainers I tried to update the running server by executing the following SQL update script using psql: ---8<--

Re: Q: cert authentication and user remapping fails

es is to specify allowed combinations of the validated external user name ("Albrecht Dreß" in your example) and the database role the user asked to connect as. So given > certaccess /^.*$ testuser it should be possible to do psql -h dbserver -U testuser testdb with a certi

Q: cert authentication and user remapping fails

users?) certaccess /^.*$ testuser I have a user certificate, issued by the same CA as the server cert, with CN "Albrecht Dreß". Running psql on a remote client fails: albrecht@deneb:~$ psql -h dbserver -U "Albrecht Dreß" testdb psql: FATAL: certificate authentication faile

Re: simple division

Am 04.12.18 21:57 schrieb(en) Martin Mueller: I didn't formulate my question properly, because the query went like "select alldefects /wordcount" where alldefects and wordcount are integers. test=# create table xxx(alldefects bigint, wordcount bigint); CREATE TABLE test=# insert into xxx value

(was: CTE with JOIN of two tables is much faster than a regular query)

Am 18.08.18 11:36 schrieb(en) kpi6...@gmail.com: [snip] What can I do to improve the performance of the regular query without using a CTE? Sorry for jumping into this discussion late – I'm facing similar problems with Postgres choosing strange and inefficient query plans for no (for me) appar

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

Am 16.07.18 00:14 schrieb(en) Tim Cross: Thank you for the point. I'm the C++ programmer and I'm author of the C++ client library for PostgreSQL - Pgfe and I'm going to use it in this project. But I'm not sure about the cross-platform GUI toolkit. The cross-platform GUI toolkit will be the ch

Re: FDW Foreign Table Access: strange LOG message

Hi Tom: Am 22.03.18 23:55 schrieb(en) Tom Lane: It finally occurred to me what is a likely explanation for why you're seeing these messages but I don't when I test postgres_fdw locally: probably, you are encrypting connections to the foreign server with SSL. I can confirm that the confusing

Re: FDW Foreign Table Access: strange LOG message

Hi Adrian: Am 21.03.18 19:25 schrieb(en) Adrian Klaver: Does it also happen when you open a psql session and do?: psql>select * from ext_table limit 1; No messages are printed whilst the session is open. However, when I quit the session by typing “\q” /after/ entering the command above, the

Re: FDW Foreign Table Access: strange LOG message

Hi Adrian & Tom: Thanks a lot for your input! Am 20.03.18 20:38 schrieb(en) Tom Lane: My suspicion is it has to do with this: postgres_fdw establishes a connection to a foreign server during the first query that uses a foreign table associated with the foreign server. This connection is kept

FDW Foreign Table Access: strange LOG message

Hi all, I use Postgres 10.3 on a Debian Stretch system with foreign tables, and noticed strange LOG messages when accessing them. The data base setup is basically ---8<-- CREATE EXTENSION IF NOT EXISTS post

Re: Q: text palloc() size vs. SET_VARSIZE()

Am 04.03.18 20:52 schrieb(en) Tom Lane: > From the docs, for me it is not clear whether the value assigned using SET_VARSIZE() must be the *exact* size of the newly allocated return value, or just the length of the text plus the header size. IOW would the code above create a memory leak if o

Q: text palloc() size vs. SET_VARSIZE()

Hi all, I have a (hopefully not too dumb) question regarding the size allocation of a text return value in a C user-defined function. Basically, the function is somewhat similar to the copytext() example on . However, the function shall