Hello.
At Wed, 15 May 2019 10:04:12 +0300, ayaho...@ibagroup.eu wrote in
> Hello,
> Thank You for the response.
>
> Yes that's possible to monitor replication delay. But my questions were
> not about monitoring network issues.
>
> I use exactly wal_sender_timeout=1s because it allows to dete
Hi all,
when running query below, pid returns empty when inserting new record
WITH s AS (
SELECT pid FROM test WHERE area = 'test5'
), i AS (
INSERT INTO test (area)
SELECT 'test5'
WHERE NOT EXISTS (SELECT 1 FROM s)
RETURNING pid
)
UPDATE area
SET last_update = CURRENT_TIMESTAMP
WH
On Thu, 16 May 2019 at 19:56, Winanjaya Amijoyo
wrote:
> when running query below, pid returns empty when inserting new record
>
> WITH s AS (
>SELECT pid FROM test WHERE area = 'test5'
> ), i AS (
>INSERT INTO test (area)
>SELECT 'test5'
>WHERE NOT EXISTS (SELECT 1 FROM s)
>RE
column pid is bigserial that I expect to return on both insert and update
I don't want to use ON CONFLICT since it would increasing the sequence
although it updating the data
On Thu, May 16, 2019 at 3:26 PM David Rowley
wrote:
> On Thu, 16 May 2019 at 19:56, Winanjaya Amijoyo
> wrote:
> > when
On Thu, 16 May 2019 at 20:28, Winanjaya Amijoyo
wrote:
> column pid is bigserial that I expect to return on both insert and update
> I don't want to use ON CONFLICT since it would increasing the sequence
> although it updating the data
It's not very clear what you're trying to do here.
So, by "
Hi
What I want to archive here is:
When record not found then insert and return pid value or if not found then
update based on pid and again return its pid.
Please help.
Many thanks in advance.
Regards
Win
On Thu, 16 May 2019 at 15.47 David Rowley
wrote:
> On Thu, 16 May 2019 at 20:28, Wina
On Thu, 16 May 2019 at 21:13, Winanjaya Amijoyo
wrote:
> When record not found then insert and return pid value or if not found then
> update based on pid and again return its pid.
You could do something like:
WITH s AS (
SELECT pid FROM test WHERE area = 'test5'
), i AS (
INSERT INTO tes
Hi All,
I have records as below that I inserted using exclusion gist constraint
user_idstart_date end_date pid
001 2019-01-012019-02-101
001 2019-02-012019-03-122
001 2019-03-052019-06-153
I need to find records base
Am 16.05.19 um 11:57 schrieb Winanjaya Amijoyo:
Hi All,
I have records as below that I inserted using exclusion gist constraint
user_id start_date end_date pid
001 2019-01-01 2019-02-10 1
001 2019-02-01 2019-03-12 2
001 2019-03-0
Hi David,
thanks for your advise, as I am new with postgresql..
I try to use LOCK as below, but it does not returning pid?
what I missed?
BEGIN TRANSACTION;
LOCK TABLE test IN ACCESS EXCLUSIVE MODE;
WITH s AS (
SELECT pid FROM test WHERE area = 'test4'
), i AS (
INSERT INTO test (area)
S
On 5/16/19 7:10 AM, Winanjaya Amijoyo wrote:
Hi David,
thanks for your advise, as I am new with postgresql..
I try to use LOCK as below, but it does not returning pid?
what I missed?
I'm not sure which pid you are referring to, the INSERT or UPDATE or both?
Can you show the output of the quer
see enclosed screenshot..
I thought, the record still locked that's why it returns empty..
On Thu, May 16, 2019 at 9:21 PM Adrian Klaver
wrote:
> On 5/16/19 7:10 AM, Winanjaya Amijoyo wrote:
> > Hi David,
> >
> > thanks for your advise, as I am new with postgresql..
> > I try to use LOCK as bel
and yes .. I need both inserted pid and updated pid
On Thu, May 16, 2019 at 9:25 PM Winanjaya Amijoyo <
winanjaya.amij...@gmail.com> wrote:
> see enclosed screenshot..
>
> I thought, the record still locked that's why it returns empty..
>
> On Thu, May 16, 2019 at 9:21 PM Adrian Klaver
> wrote:
On 5/16/19 7:26 AM, Winanjaya Amijoyo wrote:
and yes .. I need both inserted pid and updated pid
The INSERT pid is going to be 'swallowed' by the CTE that is why the:
SELECT pid FROM s UNION SELECT pid FROM i
Which also means the UPDATE RETURNING pid will be equal to it.
On Thu, May 16,
I changed the query to:
LOCK TABLE test IN EXCLUSIVE MODE;
WITH s AS (
SELECT pid,area FROM test WHERE area = 'test123'
), i AS (
INSERT INTO test (area)
SELECT ' test123 '
WHERE NOT EXISTS (SELECT 1 FROM s)
RETURNING pid
)
UPDATE area
SET last_update = CURRENT_TIMESTAMP
WHERE pid =
yes you are right!.. the insert was swallowed
I tried below:
WITH s AS (
SELECT pid,area FROM test WHERE area = '11'
), i AS (
INSERT INTO test (area)
SELECT '11'
WHERE NOT EXISTS (SELECT 1 FROM s)
RETURNING pid
)
UPDATE test
SET last_update = CURRENT_TIMESTAMP
WHERE pid = (SELECT
On 5/16/19 7:25 AM, Winanjaya Amijoyo wrote:
see enclosed screenshot..
I thought, the record still locked that's why it returns empty..
I'm not sure I believe that screenshot. For one I don't know why it
showing the area and last_update as they are not being returned?
Try the query in psql
On 5/16/19 7:52 AM, Winanjaya Amijoyo wrote:
yes you are right!.. the insert was swallowed
I tried below:
WITH s AS (
SELECT pid,area FROM test WHERE area = '11'
), i AS (
INSERT INTO test (area)
SELECT '11'
WHERE NOT EXISTS (SELECT 1 FROM s)
RETURNING pid
)
UPDATE test
SET
Hello team ,
We are getting ERROR: bigint out of range. Please help on this.
ERROR: bigint out of range
kbdb=# INSERT INTO kb_dar_ran_url_check
(url_hash,stat_date,topic_id,site_id,url,status,user_comments,review_comments)
VALUES
(72894677781133866997924561390146294513,E'19-04-2019',32793,
On Thu, 16 May 2019 at 16:31, Daulat Ram wrote:
> Hello team ,
>
> We are getting ERROR: bigint out of range. Please help on this.
>
>
>
Bigint is -9223372036854775808 to 9223372036854775807.
https://www.postgresql.org/docs/current/datatype-numeric.html
On Thu, May 16, 2019 at 8:31 AM Daulat Ram
wrote:
> url_hash| bigint | | not null |
>
Change the type of url_hash; make it text instead of bigint.
As a bonus:
Use text instead of arbitrary varchar(4000) fields and add, e.g., check
(length(url) < 4000) or some
Hi,
I've just inherited an ancient install of 9.1.17 after our tech guy left, on what turns out to be a rapidly dying server and being a total newb to PostgreSQL (and not much more advanced on Linux) I'm a little stuck on the way ahead.
I've managed to secure a decent new server for a new i
Hi All,
I am fairly this question has many answers but here it goes:
I need a tool that can track schema changes in a postgesql database, write
scripts to alter the tables, and store those changes in git. Are there
tools that exist that can do this?
BTW, I know if I use a framework with some for
> On May 16, 2019, at 5:41 PM, Benedict Holland
> wrote:
>
> Hi All,
>
> I am fairly this question has many answers but here it goes:
>
> I need a tool that can track schema changes in a postgesql database, write
> scripts to alter the tables, and store those changes in git. Are there tool
What are the correct permissions to give to a role so that all objects
in the information_schema (and pg_catalog) are visible to a user?
Permissions seem to make a difference but I don't know which adjustments
to make without causing unintended consequences. We revoked select on
all tables and
Adding to what David said, I don't see much point of having a bigint
status. Usually status attributes are a fixed set of values that can be
checked programmatically.
>
On 5/16/19 9:41 AM, Benedict Holland wrote:
I need a tool that can track schema changes in a postgesql database,
write scripts to alter the tables, and store those changes in git. Are
there tools that exist that can do this?
BTW, I know if I use a framework with some form of model tracking
(l
On Thu, May 16, 2019 at 9:36 AM wrote:
> Hi,
>
> I've just inherited an ancient install of 9.1.17 after our tech guy left,
> on what turns out to be a rapidly dying server and being a total newb to
> PostgreSQL (and not much more advanced on Linux) I'm a little stuck on the
> way ahead.
>
> I've
On Thu, May 16, 2019 at 9:50 AM Susan Hurst
wrote:
> What are the correct permissions to give to a role so that all objects
> in the information_schema (and pg_catalog) are visible to a user?
>
Have you determined that using the underlying pg_catalog schema is not
viable.
David J.
On Thu, May 16, 2019 at 9:41 AM Benedict Holland <
benedict.m.holl...@gmail.com> wrote:
>
> I need a tool that can track schema changes in a postgesql database, write
> scripts to alter the tables, and store those changes in git. Are there
> tools that exist that can do this?
>
> We ended up rolli
On 5/16/19 4:36 AM, nigel.ander...@gmx.com wrote:
Hi,
I've just inherited an ancient install of 9.1.17 after our tech guy left,
on what turns out to be a rapidly dying server and being a total newb to
PostgreSQL (and not much more advanced on Linux) I'm a little stuck on the
way ahead.
I've ma
The objects are granted SELECT to PUBLIC.
---
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hu...@brookhurstdata.com
Mobile: 314-486-3261
On 2019-05-16 11:53, David G. Johnston wrote:
> On Thu, May 16, 2019 at 9:50 AM Susan
On 16/05/2019 18:20, Ron wrote:
On 5/16/19 4:36 AM, nigel.ander...@gmx.com wrote:
Hi,
I've just inherited an ancient install of 9.1.17 after our tech guy
left, on what turns out to be a rapidly dying server and being a total
newb to PostgreSQL (and not much more advanced on Linux) I'm a lit
On 5/16/19 9:50 AM, Susan Hurst wrote:
What are the correct permissions to give to a role so that all objects
in the information_schema (and pg_catalog) are visible to a user?
As example:
https://www.postgresql.org/docs/11/infoschema-tables.html
"... Only those tables and views are shown that
On Thu, May 16, 2019 at 10:38 AM Fabio Ugo Venchiarutti <
f.venchiaru...@ocado.com> wrote:
> On 16/05/2019 18:20, Ron wrote:
> > On 5/16/19 4:36 AM, nigel.ander...@gmx.com wrote:
> >> but I wonder whether that might be an easier/more reliable option from
> >> an install and point of view and certa
On 5/16/19 10:38 AM, Fabio Ugo Venchiarutti wrote:
11.x would be best, since it's EOL is furthest in the future.
9.6 would be best, because it's had more bug-fix releases.
Aren't all important bugfixes backported to every non-EOL affected
majors at once?
Correct me if I'm wrong but I
Hi All!
Thanks for the replies. I am looking for a solution, possibly 3rd party,
where I write changes to the schema and it keeps track of the changes I
made. I am used to doing stuff in pgadmin4 but I don't mind something else.
This isn't really ad-hoc. This is more like, I have a v1.0 release c
On 5/16/19 10:55 AM, Benedict Holland wrote:
Hi All!
Thanks for the replies. I am looking for a solution, possibly 3rd party,
where I write changes to the schema and it keeps track of the changes I
made. I am used to doing stuff in pgadmin4 but I don't mind something else.
This isn't really
On Thu, May 16, 2019 at 9:41 AM Benedict Holland <
benedict.m.holl...@gmail.com> wrote:
> I need a tool that can track schema changes in a postgesql database, write
> scripts to alter the tables, and store those changes in git. Are there
> tools that exist that can do this?
>
For dev and QA, my c
Hello team
I need your help on this issue.
My Postgres 11.2 container is not started due to the below error message. It is
in streaming replication environment.
2019-05-17 06:41:08.989 UTC [1] LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5432"
2019-05-17 06:41:09.093 UTC [11] L
40 matches
Mail list logo
