Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Adrian Klaver
On 11/15/25 12:25, Peter 'PMc' Much wrote: In this case, I looked into what Rails now supports as a scheduler, and found it too elabore (for now) to grok in-depth. And a small and a bit older tool has an advantage, that one can quite easily understand it and, if need arises, make it do what is l

Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Peter 'PMc' Much
On Sat, Nov 15, 2025 at 10:36:54AM -0800, Adrian Klaver wrote: ! On 11/15/25 10:10, Peter 'PMc' Much wrote: ! > On Sat, Nov 15, 2025 at 08:06:22AM -0800, Adrian Klaver wrote: ! > ! On 11/15/25 06:57, Peter 'PMc' Much wrote: ! > ! > ! > ! > Hi, ! > ! ! > ! > Que is this: https://github.com/que-rb/qu

Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Adrian Klaver
On 11/15/25 10:10, Peter 'PMc' Much wrote: On Sat, Nov 15, 2025 at 08:06:22AM -0800, Adrian Klaver wrote: ! On 11/15/25 06:57, Peter 'PMc' Much wrote: ! > ! > Hi, ! ! > Que is this: https://github.com/que-rb/que ! ! Personally I would be more worried about an application ! where the last commit w

Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Peter 'PMc' Much
On Sat, Nov 15, 2025 at 08:06:22AM -0800, Adrian Klaver wrote: ! On 11/15/25 06:57, Peter 'PMc' Much wrote: ! > ! > Hi, ! ! > Que is this: https://github.com/que-rb/que ! ! Personally I would be more worried about an application ! where the last commit was: ! ! Changelog: Add entry for version

Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Peter 'PMc' Much
On Sat, Nov 15, 2025 at 10:28:18AM -0500, Ron Johnson wrote: ! On Sat, Nov 15, 2025 at 10:00 AM Peter 'PMc' Much < ! > The routine was trying to remove all database objects in the order ! > they were formerly created, ! ! ! In the *REVERSE* order they were created? I might suppose so ;) ! >

Re: pg_upgrade reflink support on OpenZFS

2025-11-15 Thread Marcel Menzel
On 15/11/2025 05:17, Thomas Munro wrote: On Sat, Nov 15, 2025 at 7:16 AM Marcel Menzel wrote: For the PostgreSQL upgrade to version 18, I took the opportunity to test the reflink support in pg_upgrade (with --clone) on OpenZFS 2.3.4 / Linux 6.15.11 and it worked flawlessly, being a huge time sa

Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Adrian Klaver
On 11/15/25 06:57, Peter 'PMc' Much wrote: Hi, Que is this: https://github.com/que-rb/que Personally I would be more worried about an application where the last commit was: Changelog: Add entry for version 2.4.1 committed on Oct 27, 2024. Makes you wonder what will happen if you upgrade t

Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Tom Lane
Ron Johnson writes: > On Sat, Nov 15, 2025 at 10:00 AM Peter 'PMc' Much < > [email protected]> wrote: >> trying to unload (and then reload) a development application, >> failed with this error: >> >> fin(dev)> Que.migrate! version: 0 >> ERROR: cannot drop table que_jobs because other

Re: failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Ron Johnson
On Sat, Nov 15, 2025 at 10:00 AM Peter 'PMc' Much < [email protected]> wrote: > > Hi, > trying to unload (and then reload) a development application, > failed with this error: > > fin(dev)> Que.migrate! version: 0 > ERROR: cannot drop table que_jobs because other objects depend on it

failure to drop table due to pg_temp_7 schema

2025-11-15 Thread Peter 'PMc' Much
Hi, trying to unload (and then reload) a development application, failed with this error: fin(dev)> Que.migrate! version: 0 ERROR: cannot drop table que_jobs because other objects depend on it (PG::DependentObjectsStillExist) DETAIL: function pg_temp_7.lock_and_update_priorities(jsonb,que_j