Re: UUID generation problem

On 10/2/20 7:17 PM, James B. Byrne wrote: 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 that it is

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 that it is using a search_path >>> setting

Re: UUID generation problem

"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 that it is using a search_path >> setting that doesn't include the "public" schema. >> I think you

Re: UUID generation problem

On 10/2/20 5:08 PM, James B. Byrne wrote: On Fri, October 2, 2020 18:14, Adrian Klaver wrote: Per comment over at SO, have you run uuid_generate_v4()/generate_uuid(). in psql to see if it is there and works? [root@accounting-2 ~ (master)]# sudo -u postgres psql --dbname=idempiere

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: > >> ** org.postgresql.util.PSQLException:

Re: UUID generation problem

On Fri, October 2, 2020 18:14, Adrian Klaver wrote: > > Per comment over at SO, have you run uuid_generate_v4()/generate_uuid(). > in psql to see if it is there and works? > [root@accounting-2 ~ (master)]# sudo -u postgres psql --dbname=idempiere --username=idempiere_dbadmin Password for user

Re: UUID generation problem

"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: > ** org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does > not exist Hint: No

Re: UUID generation problem

On 10/2/20 3:08 PM, James B. Byrne wrote: 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: ** org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist

UUID generation problem

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: ** org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist Hint: No function matches the given name and

Re: Profile Creation

On 10/2/20 1:56 PM, Brajendra Pratap Singh wrote: Hi Adrian, Here the user profile means which contains the following functionality same as in  EDB profile contains like password_verify_function, password_life_time, password_lock_time etc. The below then?:

Re: Profile Creation

On 10/2/20 2:45 PM, David G. Johnston wrote: On Fri, Oct 2, 2020 at 1:43 PM Brajendra Pratap Singh mailto:singh.bpratap...@gmail.com>> wrote: How can we create a user profile in open postgresql db? ? CREATE TABLE user_profile (...); INSERT INTO user_profile VALUES (...); David J.

Re: Profile Creation

On Fri, Oct 2, 2020 at 1:43 PM Brajendra Pratap Singh < singh.bpratap...@gmail.com> wrote: > How can we create a user profile in open postgresql db? > ? CREATE TABLE user_profile (...); INSERT INTO user_profile VALUES (...); David J.

Re: Profile Creation

On 10/2/20 1:40 PM, Brajendra Pratap Singh wrote: Hi All, How can we create a user profile in open postgresql db? You are going to need to be more specific about what you consider a user profile to be. Thanks, Singh -- Adrian Klaver adrian.kla...@aklaver.com

Profile Creation

Hi All, How can we create a user profile in open postgresql db? Thanks, Singh

Re: Detecting which columns a query will modify in a function called by a trigger

On Tue, Mar 3, 2020 at 4:19 PM David G. Johnston wrote: > On Tue, Mar 3, 2020 at 4:11 PM Adrian Klaver > wrote: > >> On 3/3/20 3:06 PM, David G. Johnston wrote: >> > On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver > > > wrote: >> > >> > The link was for

Re: Rows removed on child table when updating parent partitioned table.

On Fri, Oct 2, 2020 at 9:11 AM Eduard Català wrote: > If no one else gives an opinion I will open a bug for at least, force an > update of the documentation. > It's been seen and begun to be discussed over on -hackers [1]. [1]

Re: Rows removed on child table when updating parent partitioned table.

On Thu, Oct 1, 2020 at 8:02 PM David G. Johnston wrote: > The convention on these lists is to inline or bottom-post, please do not > top-post. > > On Thu, Oct 1, 2020 at 10:41 AM Jonathan Strong > wrote: > >> I've been away from coding for several years, but dusting off my chops >> and getting

ERROR: terminating logical replication worker due to timeout

Hello Everyone, How can I handle this error. Any idea ? I am usin PostgreSQL 12 on both Server. The error appear on the slave. My OS is Ubuntu Server 18.04 -- Jaurès FOUTE

Re: Doubt in pgbouncer

On 2/10/20 9:50 π.μ., Fabio Pardi wrote: Hi Rama, On 02/10/2020 01:42, Rama Krishnan wrote: Hi Friends, By using pg bouncer can we split read and queries pgbouncer is just a connection pooler. The logic where to send the reads and where the writes, should be in our application. yeah

Re: Doubt in pgbouncer

On Thursday, October 1, 2020, Fabio Pardi wrote: > Hi Rama, > > On 02/10/2020 01:42, Rama Krishnan wrote: > > Hi Friends, > > By using pg bouncer can we split read and queries > > > pgbouncer is just a connection pooler. > > The logic where to send the reads and where the writes, should be in

Re: Doubt in pgbouncer

Hi Rama, On 02/10/2020 01:42, Rama Krishnan wrote: > Hi Friends,  > > By using pg bouncer can we split read and queries > pgbouncer is just a connection pooler. The logic where to send the reads and where the writes, should be in our application. regards, fabio pardi