Re: Parallel workers via functions?

On Mon, 2025-01-27 at 18:08 +, Jim Vanns wrote: > If I have a function that is marked 'stable parallel safe' and returns > a table, can a calling function or procedure (marked volatile parallel > unsafe) still take advantage of the parallel workers from the first > function - as the data source

Re: Alter table fast

I don't think I qualify as an expert, but I can nominate a course of action for you to consider. Rather than convert an existing column from one data type to another, might it not be easier to simply recreate the table with the correct data type. There are caveats! You have to consider any refer

Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

On Tue, Jan 28, 2025 at 10:02 AM Nem Tudom wrote: > Any help, advice, recommendations, URL-s, references &c. appreciated. As others have said, we're using the POSIX AKA Unix time scale, as almost all general purpose computer systems do. It's based on the UTC time scale (the one that has SI secon

Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

"Peter J. Holzer" writes: > On 2025-01-27 21:01:59 +, Nem Tudom wrote: >> I thought that the EPOCH was the number of seconds since 1970-01-01 >> 00:00:00? Is this incorrect? > The POSIX standard mandates that leap seconds must be ignored. It's not > really "number of seconds since 1970-01-01"

Re: Content of pg_publication using a local connection versus network connection?

On Mon, 27 Jan 2025 at 21:54, Adrian Klaver wrote: > On 1/27/25 13:34, Shaheed Haque wrote: > > Hi Adrian, > > > > On Mon, 27 Jan 2025 at 20:51, Adrian Klaver > > wrote: > > > > On 1/27/25 12:41, Shaheed Haque wrote: > > > Hi, > > > > > > I'm

Re: Content of pg_publication using a local connection versus network connection?

On 1/27/25 13:34, Shaheed Haque wrote: Hi Adrian, On Mon, 27 Jan 2025 at 20:51, Adrian Klaver > wrote: On 1/27/25 12:41, Shaheed Haque wrote: > Hi, > > I'm a novice-ish when it comes to Postgres, but I've studied the docs > and not

Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

On 1/27/25 13:23, Nem Tudom wrote: Reply to list also. Ccing list. See post from Peter Holzer . Hi Adrian, all, Any help, advice, recommendations, URL-s, references &c. appreciated. https://www.postgresql.org/docs/current/functions-datetime.html https://www.postgresql.org/docs/current/

Re: Content of pg_publication using a local connection versus network connection?

Hi Adrian, On Mon, 27 Jan 2025 at 20:51, Adrian Klaver wrote: > On 1/27/25 12:41, Shaheed Haque wrote: > > Hi, > > > > I'm a novice-ish when it comes to Postgres, but I've studied the docs > > and not been able to understand why I can see the rows in pg_publication > > via a local psql session,

Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

On 2025-01-27 21:01:59 +, Nem Tudom wrote: > I'm having trouble understanding matters related to TIMESTAMP(TZ)-s and leap > seconds - my machine runs on UTC so as to remove any issues related to the > zones. > > From here: https://en.wikipedia.org/wiki/Leap_second, > > There have been 27 leap

Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

Hi all, I'm having trouble understanding matters related to TIMESTAMP(TZ)-s and leap seconds - my machine runs on UTC so as to remove any issues related to the zones. From here: https://en.wikipedia.org/wiki/Leap_second, There have been 27 leap seconds added to UTC since 1972. But, whe

Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

On 1/27/25 13:01, Nem Tudom wrote: Hi all, I'm having trouble understanding matters related to TIMESTAMP(TZ)-s and leap seconds - my machine runs on UTC so as to remove any issues related to the zones. From here: https://en.wikipedia.org/wiki/Leap_second, There have been 27 leap seconds

Re: Content of pg_publication using a local connection versus network connection?

On 1/27/25 12:41, Shaheed Haque wrote: Hi, I'm a novice-ish when it comes to Postgres, but I've studied the docs and not been able to understand why I can see the rows in pg_publication via a local psql session, but not when I am connected via the network. Since the network login is (a) succ

Content of pg_publication using a local connection versus network connection?

Hi, I'm a novice-ish when it comes to Postgres, but I've studied the docs and not been able to understand why I can see the rows in pg_publication via a local psql session, but not when I am connected via the network. Since the network login is (a) successful and (b) can read the content of other

Parallel workers via functions?

Apologies for the rushed question ... If I have a function that is marked 'stable parallel safe' and returns a table, can a calling function or procedure (marked volatile parallel unsafe) still take advantage of the parallel workers from the first function - as the data source. I.e. func_a(); //