Fwd: Proposed Italian Translation of Code of Conduct Policy

Someone politely informed me that the attachments did not make it through to the archives, so I'm re-sending from my gmail account in hopes that the attachments stick this time. Regards, Stacey -- Forwarded message - *From: *Stacey Haysler *Subject: **Proposed Italian Translation

Re: How to install PostgreSQL binaries on a different directory than the default one

Why not use the docker container? Thanks, Ben On Fri, Apr 2, 2021, 8:25 PM rob stone wrote: > Hello, > > On Fri, 2021-04-02 at 22:01 +, Allie Crawford wrote: > > Hi, > > I am new in postgresql and I am trying to install PostgreSQL on Linux > > server but instead of using the default locatio

Re: How to install PostgreSQL binaries on a different directory than the default one

Hello, On Fri, 2021-04-02 at 22:01 +, Allie Crawford wrote: > Hi, > I am new in postgresql and I am trying to install PostgreSQL on Linux > server but instead of using the default location for the binaries I > want to install them in a different directory. > I have research for a while and I c

Re: Have I found an interval arithmetic bug?

br...@momjian.us wrote: > [Thread moved to hackers.] …The best fix I think is… > >> Bryn wrote: Further… there’s a notable asymmetry. The fractional part of >> “1.7 years” is 8.4 months. But the fractional part of the months value >> doesn’t spread further down into days. However, the fractiona

Re: Have I found an interval arithmetic bug?

On Fri, Apr 2, 2021 at 01:20:26PM -0700, Ken Tanzer wrote: > On Fri, Apr 2, 2021 at 11:06 AM Bruce Momjian wrote: > > > Thread moved to hackers, with a patch. > > --- > > > > Here is a link to that thread, for o

How to install PostgreSQL binaries on a different directory than the default one

Hi, I am new in postgresql and I am trying to install PostgreSQL on Linux server but instead of using the default location for the binaries I want to install them in a different directory. I have research for a while and I cannot find any information on how to do that using the dnf utility which

Re: Have I found an interval arithmetic bug?

On Fri, Apr 2, 2021 at 11:06 AM Bruce Momjian wrote: > > Thread moved to hackers, with a patch. > --- > > Here is a link to that thread, for others who might be curious about it as I was: https://www.postgresql.org/message-id

Re: Have I found an interval arithmetic bug?

Thread moved to hackers, with a patch. --- On Thu, Apr 1, 2021 at 09:46:58PM -0700, Bryn Llewellyn wrote: > Or am I misunderstanding something? > > Try this. The result of each “select” is shown as the trailing comment on

Re: How to implement expiration in PostgreSQL?

On Thu, 1 Apr 2021 09:51:38 +0800 Glen Huang wrote: Hi, If you are in a position to modify your design, I believe your problem comes from this part : > WHERE paid OR join_time > now() - ‘1h’::interval which suggests that there is a 'paid' column being updated. I learned that the proper

Re: pass non-formated query to PL function

Hi Pavel and Gianni, Thank you for the suggestions and documentation. That is exactly the kind of thing I was looking for. Cool, thx Joao On Fri, Apr 2, 2021 at 10:54 AM Gianni Ceccarelli wrote: > On 2021-04-02 Joao Miguel Ferreira > wrote: > > Is it possible, in PL/pgSQL, to pass an argumen

Have I found an interval arithmetic bug?

Or am I misunderstanding something? Try this. The result of each “select” is shown as the trailing comment on the same line. I added whitespace by hand to line up the fields. select interval '-1.7 years'; -- -1 years -8 mons select interval '29.4 months';

Re: pass non-formated query to PL function

On 2021-04-02 Joao Miguel Ferreira wrote: > Is it possible, in PL/pgSQL, to pass an argument to a function which > is actually a "query skeleton" that the method will "fill in the > blanks" and execute it or return it to the caller after ? you probably want to use the ``EXECUTE`` command: https:/

Re: pass non-formated query to PL function

Hi pá 2. 4. 2021 v 11:35 odesílatel Joao Miguel Ferreira < joao.miguel.c.ferre...@gmail.com> napsal: > Hello all, > > Is it possible, in PL/pgSQL, to pass an argument to a function which is > actually a "query skeleton" that the method will "fill in the blanks" and > execute it or return it to th

pass non-formated query to PL function

Hello all, Is it possible, in PL/pgSQL, to pass an argument to a function which is actually a "query skeleton" that the method will "fill in the blanks" and execute it or return it to the caller after ? The caller does not have access to the variables/values that will be used to fill the blanks,

Re: Primary keys and composite unique keys(basic question)

On Thu, 2021-04-01 at 21:28 -0500, Merlin Moncure wrote: > I would never use UUIDS for keys though. That makes me curious for your reasons. I see the following disadvantages: - A UUID requires twice as much storage space as a bigint. - B-tree indexes are space optimized for inserting at the r

Re: questions about wraparound

On Thu, 18 Mar 2021 09:56:16 +0100 Luca Ferrari wrote: [...] > Therefore my question is: shouldn't autovacuum be able to freeze other > tables/databases? I mean, the wraparound problem in this scenario will > cause problems, but I was expecting different numbers for different > tables/databases.

Re: Primary keys and composite unique keys(basic question)

On Fri, Apr 2, 2021 at 8:57 AM Hemil Ruparel wrote: > I used uuid4 for customer ids because i needed to interface with payment > providers. Is that wrong? All other places except transaction ids, i have > used serial ints > > On Fri 2 Apr, 2021, 8:56 AM Rob Sargent, wrote: > >> On 4/1/21 8:28 PM

Re: Copy Statistics Tables During Upgrade

Hello, This is a pg_upgrade known limitation that has been summarized by Greg Sabino Mullane on https://www.endpoint.com/blog/2016/12/07/postgres-statistics-and-pain-of-analyze this way: The nominal reason for not copying the data is that the table format may change from version to version.