From: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
---|---|
To: | byrnejb(at)harte-lyne(dot)ca |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: UUID generation problem |
Date: | 2020-10-05 17:07:01 |
Message-ID: | B81B7CE5-05F9-45AB-A3B7-8B6FEEEED624@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi James,
> idempiere=# select uuid_generate_v4();
> ERROR: function uuid_generate_v4() does not exist
> LINE 1: select uuid_generate_v4();
> ^
> HINT: No function matches the given name and argument types. You might need to
> add explicit type casts.
> idempiere=# select public.uuid_generate_v4();
> uuid_generate_v4
> --------------------------------------
> 5ba19b69-ec8e-4d8e-8968-7c84eccc4351
> (1 row)
> On 05. Oct, 2020, at 18:51, James B. Byrne <byrnejb(at)harte-lyne(dot)ca> wrote:
> idempiere=# show search_path;
> search_path
> -----------------------
> adempiere, pg_catalog
> (1 row)
I guess that's why you don't see the uuid_generate_v4() function. I suggest you either fully qualify it, i.e. public.uuid_generate_v4() or add public to your search path.
Cheers,
Paul
From | Date | Subject | |
---|---|---|---|
Next Message | James B. Byrne | 2020-10-05 17:16:43 | Re: UUID generation problem |
Previous Message | James B. Byrne | 2020-10-05 16:59:05 | Re: UUID generation problem |