On Sun, 2025-01-05 at 22:18 -0500, Ron Johnson wrote:
> On Sun, Jan 5, 2025 at 7:27 PM Nick wrote:
> >
> > I have some questions about the
> > pgAdmin Debian package version.
> >
> > 1. If we're using the pgAdmin DEB repo, will `apt-update` always
> > update
> > pgAdmin to the latest major versi
On Sun, Jan 5, 2025 at 7:27 PM Nick wrote:
>
> I sent this to the PgAdmin list but didn't get any replies. Not sure
> how many people are on that list, but since these questions are general
> enough, I figure someone on the main list will know:
>
> I'm using the apt repository version for Debian
I sent this to the PgAdmin list but didn't get any replies. Not sure
how many people are on that list, but since these questions are general
enough, I figure someone on the main list will know:
I'm using the apt repository version for Debian 12 (Bookworm). I'm also
using Ansible to manage the se
On Sun, 05 Jan 2025 07:48:56 +0100
Laurenz Albe wrote:
> So what you should do is set the "search_path" *on* the function, not *in*
> the function:
>
> CREATE FUNCTION "run"() RETURNS TEXT LANGUAGE plpgsql
> SET search_path = myschema
> AS $$
> DECLARE
> "variable" "tbl"."col"%TYPE;
> BE
On Sun, 2025-01-05 at 00:12 +0100, Jan Behrens wrote:
> I constructed the following new example:
>
>
>
> CREATE TABLE "tbl" ("col" NUMERIC(15, 0));
>
> CREATE FUNCTION "foo"() RETURNS TEXT LANGUAGE plpgsql AS $$
> BEGIN
> RETURN '2.4';
> END;
> $$;
>
> BEGIN;
>
> CREATE SC
