Link error on Release mode

2024-11-27 Thread Igor Korot
Hi, ALL. Today for the first time I tried to build my software in Release mode. This is the command MSVC generates: /OUT:"..\dbhandler\vc_mswudll\postgres_dll.dll" /MANIFEST /NXCOMPAT /PDB:"vc_mswudll\my_dll.pdb" /DYNAMICBASE "dbinterface.lib" "libpq.lib" "kernel32.lib" "user32.lib" "gdi32.lib" "

Re: uninstalling postgresql 13 on ubuntu 22.04?

2024-11-27 Thread Rob Sargent
> On Nov 27, 2024, at 3:51 PM, Adrian Klaver wrote: > > On 11/27/24 13:54, Richard Welty wrote: >> i installed pg13 from the postgres repos but am not really using it >> in that form; i'm using docker images instead. i now find i need >> to uninstall it to facilitate upgrading my desktop to u

Re: uninstalling postgresql 13 on ubuntu 22.04?

2024-11-27 Thread Adrian Klaver
On 11/27/24 13:54, Richard Welty wrote: i installed pg13 from the postgres repos but am not really using it in that form; i'm using docker images instead. i now find i need to uninstall it to facilitate upgrading my desktop to ubuntu 24 Not really. Per here: https://www.postgresql.org/download

Re: uninstalling postgresql 13 on ubuntu 22.04?

2024-11-27 Thread Ray O'Donnell
On 27/11/2024 21:54, Richard Welty wrote: i installed pg13 from the postgres repos but am not really using it in that form; i'm using docker images instead. i now find i need to uninstall it to facilitate upgrading my desktop to ubuntu 24 is apt remove an effective way to uninstall or is there a

uninstalling postgresql 13 on ubuntu 22.04?

2024-11-27 Thread Richard Welty
i installed pg13 from the postgres repos but am not really using it in that form; i'm using docker images instead. i now find i need to uninstall it to facilitate upgrading my desktop to ubuntu 24 is apt remove an effective way to uninstall or is there a better method? thanks,    richard

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

2024-11-27 Thread Alvaro Herrera
On 2024-Nov-27, Tom Lane wrote: > I doubt that there's anything actually wrong with the catalog state at > this point (perhaps Alvaro would confirm that). That leads to the > conclusion that what's wrong is the release notes' query for fingering > broken constraints, and it needs some additional

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

2024-11-27 Thread Tom Lane
Paul Foerster writes: > On 26 Nov 2024, at 22:25, Tom Lane wrote: >> I'm suspicious that our repair recipe might not have accounted >> for self-reference FKs fully, but that's just a gut feeling at >> this point. > Of course, it contains no secret data. Please find the full log below. > Accordi

Re: Customize psql prompt to show current_role

2024-11-27 Thread Dominique Devienne
On Wed, Nov 27, 2024 at 3:14 PM Raphael Salguero Aragón wrote: > Am 23.09.2024 um 17:37 schrieb Dominique Devienne : > > I'd be glad to use Pavel's proposed %N. —DD > I just wanted to add that we are also supporting a larger customer with > exactly the same request. > Perhaps this increases the v

Re: Customize psql prompt to show current_role

2024-11-27 Thread Raphael Salguero Aragón
Am 23.09.2024 um 17:37 schrieb Dominique Devienne : > > On Mon, Sep 23, 2024 at 5:16 PM Adrian Klaver > wrote: >> On 9/23/24 08:07, Dominique Devienne wrote: >>> I often resort to \conninfo, but it's less automatic and >>> harder to visually parse (IMHO) compared to a custom ad-hoc prompt. > >>

Re: Validating check constraints without a table scan?

2024-11-27 Thread Philip Couling
It looks like updating pg_constraint isn't an option for AWS RDS due to the way AWS doesn't give you superuser access. Thanks a lot for the suggestion anyway. On Fri, 15 Nov 2024 at 15:28, Torsten Förtsch wrote: > On Fri, Nov 15, 2024 at 9:38 AM Philip Couling wrote: > >> Is there a solid reaso