Problem with trigger function

; I do not see what the error is. What is wrong with the syntax I used? -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow lin

Re: Need another set of eyes on this

te: > > Try single quotes > Thank you both. -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrne

Need another set of eyes on this

n manu_code to manufact.manu_code but that is not yet implemented. The reference to column "SHM" not existing has me confused. I am probably missing something obvious but I cannot see what the problem is. Any help would be most welcome. Thanks, -- *** e-Mail is NOT a SECURE ch

interval data type

egal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3

character datatype explaination sought

-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton,

[SOLVED] Re: UUID generation problem

t sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox:

Re: UUID generation problem

a step? -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Hart

Re: UUID generation problem

On Mon, October 5, 2020 15:35, David G. Johnston wrote: > On Monday, October 5, 2020, James B. Byrne wrote: > >> >> >> I am so confused by this. I tried to do this: >> >> [root@accounting-2 ~ (master)]# psql -E --dbname=idempiere >> --username=idem

Re: UUID generation problem

dempiere-dbadmin" does not exist idempiere(5432)=# If the role idempiere-dbadmin does not exist then how did I connect to the idempiere database? -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim

Re: UUID generation problem

t use the postgres user to create an extension? -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrne

Re: UUID generation problem

Something in the installer must be doing something to the adempiere role, but I cannot find where. -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow

Re: UUID generation problem

a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.ha

Re: UUID generation problem

_dbadmin (1 row) -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Li

Re: UUID generation problem

this. -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne

Re: UUID generation problem

On Mon, October 5, 2020 12:51, Tom Lane wrote: > "James B. Byrne" writes: >> [root@accounting-2 ~ (master)]# psql --dbname=idempiere >> --username=idempiere_dbadmin --host=localhost >> Password for user idempiere_dbadmin: >> psql (11.8) >> Ty

Re: UUID generation problem

g_catalog (1 row) -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.

Re: UUID generation problem

n/postgres -D /var/db/postgres/data11 -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:

Re: UUID generation problem

On Mon, October 5, 2020 12:08, Adrian Klaver wrote: > On 10/5/20 8:57 AM, James B. Byrne wrote: >> >> >> On Mon, October 5, 2020 11:15, Adrian Klaver wrote: >>> >>> Per Tom's post this does not make sense. >>> >>> What if

Re: UUID generation problem

On Mon, October 5, 2020 12:06, Tom Lane wrote: > "James B. Byrne" writes: >> On Mon, October 5, 2020 10:53, Tom Lane wrote: >>> I continue to suspect that you are somehow >>> confusing yourself by testing in different databases and/or >>> with dif

Re: UUID generation problem

have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3

Re: UUID generation problem

OT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox:

Re: UUID generation problem

e uuid-ossp extension. That possibly bears on this matter. -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrne

Re: UUID generation problem

Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive

Re: UUID generation problem

E channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.hart

Re: UUID generation problem

On Fri, October 2, 2020 21:13, Tom Lane wrote: > "James B. Byrne" writes: >> On Fri, October 2, 2020 18:46, Tom Lane wrote: >>> The two likely possibilities are that Idempiere isn't connecting to the >>> same database as you are doing manually, or

Re: UUID generation problem

On Fri, October 2, 2020 18:46, Tom Lane wrote: > "James B. Byrne" writes: >> I have a FreeBSD-12.1p10 system running postgreSQL-11.8. This is a test >> platform for Idempiere. When creating a new client in Idempiere I get this >> error message: > >> **

Re: UUID generation problem

e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited

UUID generation problem

he problem? -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrnemailto:byrn...@harte-lyne.ca Harte &