agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed
Recursive CTE with a function
  2020-06-03 13:52 UTC  Mark Bannister <mark@injection-moldings.com>

autovacuum processes not spawning
  2020-06-02 00:43 UTC  Wayne Cuddy <lists-pgsql@useunix.net>

left outer join with count
  2020-05-29 16:09 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: left outer join with count
  2020-05-30 04:43 UTC  Gábor SZŰCS <surrano@gmail.com>
` Re: left outer join with count
  2020-05-30 19:40 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
  [3+ messages in thread]

Postgres stored procedure errs while parsing JSONB object
  2020-05-20 14:39 UTC  Igor Shmukler <igor.shmukler@gmail.com>
` Re: Postgres stored procedure errs while parsing JSONB object
  2020-05-20 15:04 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Postgres stored procedure errs while parsing JSONB object
  2020-05-20 15:10 UTC  Igor Shmukler <igor.shmukler@gmail.com>
  [3+ messages in thread]

Exporting modifications to a table as XML/JSON
  2020-05-11 21:17 UTC  ertan.kucukoglu@1nar.com.tr
` Re: Exporting modifications to a table as XML/JSON
  2020-05-11 23:37 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Exporting modifications to a table as XML/JSON
  2020-05-11 23:51 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [3+ messages in thread]

Table/log file name which store the queries which got executed in last 1 month
  2020-05-01 03:19 UTC  Gaurav Tomar <gauravtomar14@gmail.com>
` Re: Table/log file name which store the queries which got executed in last 1 month
  2020-05-01 03:33 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Table/log file name which store the queries which got executed in last 1 month
  2020-05-01 03:34 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: Table/log file name which store the queries which got executed in last 1 month
  2020-05-01 07:55 UTC  legrand legrand <legrand_legrand@hotmail.com>
` Re: Table/log file name which store the queries which got executed in last 1 month
  2020-05-04 15:36 UTC  Craig Jackson <craig.jackson@broadcom.com>
  [5+ messages in thread]

pg_dump fails when a table is in ACCESS SHARE MODE
  2020-02-25 15:11 UTC  Viral Shah <viralshah009@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-02-25 15:36 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-02-25 15:45 UTC  Viral Shah <viralshah009@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-02-25 16:27 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-02-25 18:31 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-04-30 22:15 UTC  Viral Shah <viralshah009@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-05-01 02:58 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-05-01 13:53 UTC  Viral Shah <viralshah009@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-05-01 14:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-05-02 01:06 UTC  Viral Shah <viralshah009@gmail.com>
` Re: pg_dump fails when a table is in ACCESS SHARE MODE
  2020-05-02 01:24 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [11+ messages in thread]

insert in an array of composite type
  2020-04-25 21:45 UTC  Maxime FRYSOU <maxprocess@gmail.com>
` Re: insert in an array of composite type
  2020-04-25 22:15 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: insert in an array of composite type
  2020-04-25 22:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert in an array of composite type
  2020-04-26 06:57 UTC  Maxime FRYSOU <maxprocess@gmail.com>
  [4+ messages in thread]

How to sql scripts in a file?
  2020-04-23 12:42 UTC  John Zhang <johnzhang06@gmail.com>
` Fwd: How to sql scripts in a file?
  2020-04-23 13:08 UTC  Sándor Daku <daku.sandor@gmail.com>
` Re: [postgis-users] How to sql scripts in a file?
  2020-04-23 13:37 UTC  Giuseppe Broccolo <g.broccolo.7@gmail.com>
` Re: [postgis-users] How to sql scripts in a file?
  2020-04-23 16:08 UTC  John Zhang <johnzhang06@gmail.com>
  [4+ messages in thread]

FK constraint question
  2020-04-01 13:49 UTC  Heinemann, Manfred (IMS) <HeinemannM@imsweb.com>
` Re: FK constraint question
  2020-04-01 15:29 UTC  Steve Midgley <science@misuse.org>
` Re: FK constraint question
  2020-04-22 15:50 UTC  Samed YILDIRIM <samed@reddoc.net>
` Re: FK constraint question
  2020-04-22 16:31 UTC  Ashutosh Sharma <ashu.coek88@gmail.com>
  [4+ messages in thread]

回复: [External] Re: Separate volumes
  2020-04-07 16:31 UTC  Lu Dillon <ludi_1981@hotmail.com>
` Re: 回复: [External] Re: Separate volumes
  2020-04-10 20:04 UTC  Bruce Momjian <bruce@momjian.us>
`  Re: 回复: [External] Re: Separate volumes
  2020-04-10 20:52 UTC  Erik Brandsberg <erik@heimdalldata.com>
` Re: 回复: [External] Re: Separate volumes
  2020-04-10 21:01 UTC  Bruce Momjian <bruce@momjian.us>
`  Re: 回复: [External] Re: Separate volumes
  2020-04-10 21:26 UTC  Erik Brandsberg <erik@heimdalldata.com>
  [5+ messages in thread]

Separate volumes
  2020-04-06 11:51 UTC  Ed Behn <ed.behn@collins.com>
` Re: Separate volumes
  2020-04-06 16:41 UTC  Erik Brandsberg <erik@heimdalldata.com>
` Re: Separate volumes
  2020-04-06 17:11 UTC  Steve Midgley <science@misuse.org>
` Re: Separate volumes
  2020-04-06 19:30 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: [External] Re: Separate volumes
  2020-04-06 19:36 UTC  Ed Behn <ed.behn@collins.com>
` Re: [External] Re: Separate volumes
  2020-04-06 21:40 UTC  Iuri Sampaio <iuri.sampaio@gmail.com>
  [6+ messages in thread]

How do CHECK Constraint Function privileges work?
  2020-04-05 08:22 UTC  Ruwan Fernando <rutechs@gmail.com>
` Re: How do CHECK Constraint Function privileges work?
  2020-04-05 14:37 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: How do CHECK Constraint Function privileges work?
  2020-04-05 15:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How do CHECK Constraint Function privileges work?
  2020-04-05 15:46 UTC  Ruwan Fernando <rutechs@gmail.com>
` Re: How do CHECK Constraint Function privileges work?
  2020-04-05 15:58 UTC  Ruwan Fernando <rutechs@gmail.com>
  [5+ messages in thread]

min()/max() with BRIN indexes
  2020-02-29 16:50 UTC  Wayne <lists-pgsql@useunix.net>
` Re: min()/max() with BRIN indexes
  2020-02-29 19:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: min()/max() with BRIN indexes
  2020-02-29 21:40 UTC  Wayne <lists-pgsql@useunix.net>
` Re: min()/max() with BRIN indexes
  2020-03-25 17:45 UTC  Bruce Momjian <bruce@momjian.us>
  [4+ messages in thread]

What is the right syntax for retrieving the last_insert_id() in Postgresql ?
  2020-03-01 10:17 UTC  Karen Goh <karenworld@yahoo.com>
` Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?
  2020-03-01 10:26 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?
  2020-03-01 11:16 UTC  agharta agharta <agharta82@gmail.com>
` Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?
  2020-03-03 15:50 UTC  Karen Goh <karenworld@yahoo.com>
` Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?
  2020-03-03 16:04 UTC  john <johnf@jfcomputer.com>
` Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?
  2020-03-03 16:26 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?
  2020-03-03 16:36 UTC  Sándor Daku <daku.sandor@gmail.com>
  [7+ messages in thread]

Documentation of the pg_service file
  2020-02-25 20:25 UTC  Tim Uckun <timuckun@gmail.com>
` Re: Documentation of the pg_service file
  2020-02-25 22:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Documentation of the pg_service file
  2020-02-25 22:32 UTC  Steve Midgley <science@misuse.org>
  [3+ messages in thread]

SQL schema and query optimisation for fast cross-table query execution
  2020-01-25 08:49 UTC  Brice André <brice@famille-andre.be>
` RE: SQL schema and query optimisation for fast cross-table query execution
  2020-01-25 13:18 UTC  Mike Sofen <msofen@runbox.com>
  [2+ messages in thread]

For each statement trigger and update table
  2020-01-03 23:09 UTC  Mike Martin <mike@redtux.plus.com>
` Re: For each statement trigger and update table
  2020-01-03 23:39 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: For each statement trigger and update table
  2020-01-03 23:55 UTC  Mike Martin <mike@redtux.plus.com>
` Re: For each statement trigger and update table
  2020-01-04 00:06 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: For each statement trigger and update table
  2020-01-04 00:26 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: For each statement trigger and update table
  2020-01-04 00:32 UTC  Mike Martin <mike@redtux.plus.com>
` Re: For each statement trigger and update table
  2020-01-04 03:45 UTC  Mike Martin <mike@redtux.plus.com>
` Re: For each statement trigger and update table
  2020-01-05 01:49 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: For each statement trigger and update table
  2020-01-05 16:10 UTC  Mike Martin <mike@redtux.plus.com>
` Re: For each statement trigger and update table
  2020-01-05 19:42 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: For each statement trigger and update table
  2020-01-06 13:53 UTC  Erik Brandsberg <erik@heimdalldata.com>
  [11+ messages in thread]

Whether to use "IN" clause
  2019-12-31 10:15 UTC  Mark Williams <markwillimas@gmail.com>

problem with read-only user
  2019-12-20 13:01 UTC  ROS Didier <didier.ros@edf.fr>
` Re: problem with read-only user
  2019-12-20 14:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` RE: problem with read-only user
  2019-12-27 08:56 UTC  ROS Didier <didier.ros@edf.fr>
  [3+ messages in thread]

Solving my query needs with Rank and may be CrossTab
  2019-12-01 22:54 UTC  Iaam Onkara <iamonkara@gmail.com>
` Re: Solving my query needs with Rank and may be CrossTab
  2019-12-01 23:28 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Solving my query needs with Rank and may be CrossTab
  2019-12-01 23:38 UTC  Iaam Onkara <iamonkara@gmail.com>
` Re: Solving my query needs with Rank and may be CrossTab
  2019-12-02 04:58 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Solving my query needs with Rank and may be CrossTab
  2019-12-02 06:09 UTC  Iaam Onkara <iamonkara@gmail.com>
` Re: Solving my query needs with Rank and may be CrossTab
  2019-12-02 13:42 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Solving my query needs with Rank and may be CrossTab
  2019-12-02 16:55 UTC  Iaam Onkara <iamonkara@gmail.com>
` Re: Solving my query needs with Rank and may be CrossTab
  2019-12-02 21:14 UTC  Rob Sargent <robjsargent@gmail.com>
  [8+ messages in thread]

How to use Array in Array of Json
  2019-11-25 12:02 UTC  Monalee Bhandge <monalee.bhandge@epps-erp.com>
` Re: How to use Array in Array of Json
  2019-11-25 16:13 UTC  Steve Midgley <science@misuse.org>
` RE: How to use Array in Array of Json
  2019-11-25 16:14 UTC  2.andriychuk@gmail.com
` Re: How to use Array in Array of Json
  2019-11-26 05:38 UTC  Monalee Bhandge <monalee.bhandge@epps-erp.com>
` How to use Array in Array of Json
  2019-11-27 12:11 UTC  Monalee Bhandge <monalee.bhandge@epps-erp.com>
  [5+ messages in thread]

PostGreSQL Replication and question on maintenance
  2019-11-14 17:23 UTC  github kran <githubkran@gmail.com>
` Fwd: PostGreSQL Replication and question on maintenance
  2019-11-15 05:26 UTC  github kran <githubkran@gmail.com>
` Re: PostGreSQL Replication and question on maintenance
  2019-11-15 05:41 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: PostGreSQL Replication and question on maintenance
  2019-11-15 15:10 UTC  github kran <githubkran@gmail.com>
` Re: PostGreSQL Replication and question on maintenance
  2019-11-16 13:36 UTC  github kran <githubkran@gmail.com>
` Re: PostGreSQL Replication and question on maintenance
  2019-11-16 17:13 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: PostGreSQL Replication and question on maintenance
  2019-11-20 12:12 UTC  Soto Cuevas Manuel Alejandro <MCSoto@entel.cl>
` Re: PostGreSQL Replication and question on maintenance
  2019-11-20 12:15 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: PostGreSQL Replication and question on maintenance
  2019-11-27 01:22 UTC  github kran <githubkran@gmail.com>
  [9+ messages in thread]

Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-12 18:27 UTC  github kran <githubkran@gmail.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-12 18:33 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-12 18:55 UTC  github kran <githubkran@gmail.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-13 15:49 UTC  github kran <githubkran@gmail.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-13 17:37 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-14 15:47 UTC  github kran <githubkran@gmail.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-14 18:43 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-14 22:11 UTC  github kran <githubkran@gmail.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-14 22:58 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-17 17:03 UTC  github kran <githubkran@gmail.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-19 17:11 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-02-22 04:57 UTC  github kran <githubkran@gmail.com>
` Re: Postgresql RDS DB Latency Chossing Hash join Plan
  2019-11-14 17:21 UTC  github kran <githubkran@gmail.com>
  [13+ messages in thread]

install problem with extensions
  2019-11-12 17:09 UTC  stan <stanb@panix.com>
` Re: install problem with extensions
  2019-11-12 21:50 UTC  legrand legrand <legrand_legrand@hotmail.com>
` Re: install problem with extensions
  2019-11-13 18:09 UTC  stan <stanb@panix.com>
` Re: install problem with extensions
  2019-11-13 18:11 UTC  legrand legrand <legrand_legrand@hotmail.com>
  [4+ messages in thread]


[next (older)]

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox