agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed
Apparently table locks are the key issue to see red flags
  2022-03-16 20:14 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Apparently table locks are the key issue to see red flags
  2022-03-16 20:15 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Apparently table locks are the key issue to see red flags
  2022-03-16 20:21 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Apparently table locks are the key issue to see red flags
  2022-03-16 20:23 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Apparently table locks are the key issue to see red flags
  2022-03-16 20:32 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Apparently table locks are the key issue to see red flags
  2022-03-17 13:21 UTC  Jayson Hreczuck <jayson.hreczuck@studentuniverse.com>
  [6+ messages in thread]

(no subject)
  2016-06-02 21:31 UTC  Max Lipsky <maxlipsky@gmail.com>
` Re:
  2016-06-03 00:28 UTC  Steve Midgley <science@misuse.org>
` Re:
  2016-06-03 01:24 UTC  Max Lipsky <maxlipsky@gmail.com>
` Re:
  2016-06-03 01:42 UTC  Max Lipsky <maxlipsky@gmail.com>
` Re:
  2016-06-03 15:15 UTC  Michael Moore <michaeljmoore@gmail.com>
` How to explicitly state unlock in sql?
  2022-03-16 20:56 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: How to explicitly state unlock in sql?
  2022-03-16 21:03 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: How to explicitly state unlock in sql?
  2022-03-16 21:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]

Best practice for naming temp table trigger functions
  2022-03-07 18:19 UTC  Sebastien Flaesch <sebastien.flaesch@4js.com>
` Re: Best practice for naming temp table trigger functions
  2022-03-08 15:38 UTC  Sebastien Flaesch <sebastien.flaesch@4js.com>
` Re: Best practice for naming temp table trigger functions
  2022-03-08 16:16 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Best practice for naming temp table trigger functions
  2022-03-08 17:24 UTC  Sebastien Flaesch <sebastien.flaesch@4js.com>
` Re: Best practice for naming temp table trigger functions
  2022-03-09 08:26 UTC  Sebastien Flaesch <sebastien.flaesch@4js.com>
  [5+ messages in thread]

unique index with several columns
  2022-03-04 15:06 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
` RE: unique index with several columns
  2022-03-04 15:09 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
` Re: unique index with several columns
  2022-03-04 15:32 UTC  David G. Johnston <david.g.johnston@gmail.com>
` RE: unique index with several columns
  2022-03-04 16:11 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
` Re: unique index with several columns
  2022-03-04 18:26 UTC  Alexey M Boltenkov <padrebolt@yandex.ru>
` Re: unique index with several columns
  2022-03-04 18:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` RE: unique index with several columns
  2022-03-04 18:57 UTC  Klaus Kaisersberger <woodconsult@outlook.de>
` Re: unique index with several columns
  2022-03-04 19:06 UTC  David G. Johnston <david.g.johnston@gmail.com>
` RE: unique index with several columns
  2022-03-04 19:18 UTC  Klaus Kaisersberger <klaus.kaisersberger@outlook.com>
` RE: unique index with several columns
  2022-03-04 20:02 UTC  Klaus Kaisersberger <woodconsult@outlook.de>
` Re: unique index with several columns
  2022-03-04 20:47 UTC  Alexey M Boltenkov <padrebolt@yandex.ru>
` RE: unique index with several columns
  2022-03-08 16:59 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
  [12+ messages in thread]

ERROR:  extra data after last expected column
  2022-03-07 01:59 UTC  Scott Macri <Scott@BITSnBYTES.io>
` Re: ERROR: extra data after last expected column
  2022-03-07 09:08 UTC  Sándor Daku <daku.sandor@gmail.com>
` Re: ERROR: extra data after last expected column
  2022-03-07 09:57 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: ERROR: extra data after last expected column
  2022-03-07 23:33 UTC  scott macri <hacktorious@gmail.com>
` Re: ERROR: extra data after last expected column
  2022-03-07 23:54 UTC  Steve Midgley <science@misuse.org>
` Re: ERROR: extra data after last expected column
  2022-03-07 23:56 UTC  Steve Midgley <science@misuse.org>
` Re: ERROR: extra data after last expected column
  2022-03-07 23:57 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: ERROR: extra data after last expected column
  2022-03-08 01:40 UTC  Scott Macri <Scott@BITSnBYTES.io>
` Re: ERROR: extra data after last expected column
  2022-03-08 01:42 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: ERROR: extra data after last expected column
  2022-03-08 01:51 UTC  Scott Macri <Scott@BITSnBYTES.io>
` Re: ERROR: extra data after last expected column
  2022-03-08 02:40 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: ERROR: extra data after last expected column
  2022-03-08 03:47 UTC  scott macri <hacktorious@gmail.com>
  [12+ messages in thread]

Bug in tables column data in postgres database
  2022-03-03 16:45 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-03 17:18 UTC  Christophe Pettus <xof@thebuild.com>
` Re: Bug in tables column data in postgres database
  2022-03-03 17:24 UTC  MichaelDBA Vitale <michaeldba@sqlexec.com>
` RE: Bug in tables column data in postgres database
  2022-03-03 18:06 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
` Re: Bug in tables column data in postgres database
  2022-03-03 18:41 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-03 19:24 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-03 19:27 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-03 20:03 UTC  Steve Midgley <science@misuse.org>
` Re: Bug in tables column data in postgres database
  2022-03-04 14:04 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-04 14:33 UTC  Erik Brandsberg <erik@heimdalldata.com>
` Re: Bug in tables column data in postgres database
  2022-03-04 14:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bug in tables column data in postgres database
  2022-03-04 14:52 UTC  Steve Midgley <science@misuse.org>
` Re: Bug in tables column data in postgres database
  2022-03-05 08:04 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 08:15 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 08:29 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 08:40 UTC  Thomas Kellerer <shammat@gmx.net>
` Re: Bug in tables column data in postgres database
  2022-03-05 08:51 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 10:10 UTC  mgbii bax <gezeala@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 10:28 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 15:27 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 15:56 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-05 16:07 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-06 10:08 UTC  Sándor Daku <daku.sandor@gmail.com>
` Re: Bug in tables column data in postgres database
  2022-03-06 12:23 UTC  Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
` Re: Bug in tables column data in postgres database
  2022-03-06 13:49 UTC  Sarita Sharma <saritakumarisharma61@gmail.com>
  [25+ messages in thread]

AW: unique index with several columns
  2022-03-04 15:32 UTC  Marc Mamin <M.Mamin@intershop.de>

limits on the number of concurrent DBMS sessions per account
  2022-03-04 15:07 UTC  Kevin Tu <kevintu888@gmail.com>
` Re: limits on the number of concurrent DBMS sessions per account
  2022-03-04 15:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: limits on the number of concurrent DBMS sessions per account
  2022-03-04 15:29 UTC  Kevin Tu <kevintu888@gmail.com>
  [3+ messages in thread]

AW: Bug in tables column data in postgres database
  2022-03-03 17:10 UTC  Stöcker, Martin <Martin.Stoecker@etl-datenservice.de>

Global setting for ORDER BY ... NULLS FIRST / LAST
  2022-03-01 14:16 UTC  Sebastien Flaesch <sebastien.flaesch@4js.com>
` Re: Global setting for ORDER BY ... NULLS FIRST / LAST
  2022-03-01 14:41 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Global setting for ORDER BY ... NULLS FIRST / LAST
  2022-03-01 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Global setting for ORDER BY ... NULLS FIRST / LAST
  2022-03-02 12:23 UTC  Sebastien Flaesch <sebastien.flaesch@4js.com>
  [4+ messages in thread]

pg_stat_progress_copy not working as intended
  2022-03-01 17:55 UTC  asalias mark <postgres.rocks@gmail.com>
` Re: pg_stat_progress_copy not working as intended
  2022-03-02 00:17 UTC  Ian Lawrence Barwick <barwick@gmail.com>
` Re: pg_stat_progress_copy not working as intended
  2022-03-02 09:48 UTC  asalias mark <postgres.rocks@gmail.com>
  [3+ messages in thread]

NORM(NO ORM) transform two one-many relationships into a single json.
  2022-03-01 13:58 UTC  Jian He <hejian.mark@gmail.com>

Array_reverse
  2022-02-27 16:53 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Array_reverse
  2022-02-27 16:59 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [2+ messages in thread]

Is there any function for calculating angle between 2 line segments in 3D?
  2022-02-27 10:39 UTC  Shaozhong SHI <shishaozhong@gmail.com>

PSQL: "\set ECHO all" doesn't work with "\o"
  2022-02-23 18:18 UTC  Alberto Benini <alberto.benini@tasgroup.eu>
` Re: PSQL: "\set ECHO all" doesn't work with "\o"
  2022-02-23 18:27 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [2+ messages in thread]

automatic scan a table, report on data formats in columns
  2022-02-21 10:06 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: automatic scan a table, report on data formats in columns
  2022-02-21 12:45 UTC  Jian He <hejian.mark@gmail.com>
` Re: automatic scan a table, report on data formats in columns
  2022-02-21 16:27 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: automatic scan a table, report on data formats in columns
  2022-02-21 16:59 UTC  Steve Midgley <science@misuse.org>
` Re: automatic scan a table, report on data formats in columns
  2022-02-21 19:54 UTC  Shaozhong SHI <shishaozhong@gmail.com>
  [5+ messages in thread]

Aw: Re: Turn a json column into a table
  2022-02-15 08:09 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>
` Aw: Re: Turn a json column into a table
  2022-02-20 09:07 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>
  [2+ messages in thread]

Turn a json column into a table
  2022-02-15 07:21 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Turn a json column into a table
  2022-02-15 07:52 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Re: Turn a json column into a table
  2022-02-15 08:11 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Re: Turn a json column into a table
  2022-02-19 22:03 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Re: Re: Turn a json column into a table
  2022-02-19 22:40 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Turn a json column into a table
  2022-02-19 22:46 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Turn a json column into a table
  2022-02-19 23:22 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Turn a json column into a table
  2022-02-19 23:54 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Turn a json column into a table
  2022-02-20 00:18 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Turn a json column into a table
  2022-02-20 00:58 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Turn a json column into a table
  2022-02-20 01:08 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Turn a json column into a table
  2022-02-20 03:31 UTC  Shaozhong SHI <shishaozhong@gmail.com>
  [12+ messages in thread]

Advancing the capability of Postgres and PostGIS
  2022-02-17 22:38 UTC  Shaozhong SHI <shishaozhong@gmail.com>

Is there a way to automatically scan a table and determine the format of data
  2022-02-16 01:27 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Is there a way to automatically scan a table and determine the format of data
  2022-02-16 02:13 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Is there a way to automatically scan a table and determine the format of data
  2022-02-16 10:03 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>
  [3+ messages in thread]

Try catch error, return data
  2022-02-16 02:13 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Try catch error, return data
  2022-02-16 03:08 UTC  Skylar Thompson <skylar2@uw.edu>
` Re: Try catch error, return data
  2022-02-16 10:01 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>
  [3+ messages in thread]

Storing thousands of csv files in postgresql
  2022-02-15 08:15 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 16:20 UTC  Steve Midgley <science@misuse.org>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 19:38 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 20:11 UTC  Erik Brandsberg <erik@heimdalldata.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 20:27 UTC  Marcos Pegoraro <marcos@f10.com.br>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 20:40 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 20:42 UTC  Erik Brandsberg <erik@heimdalldata.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 20:43 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 20:58 UTC  Steve Midgley <science@misuse.org>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 21:12 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 21:13 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 21:21 UTC  Steve Midgley <science@misuse.org>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 21:21 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
` Re: Storing thousands of csv files in postgresql
  2022-02-15 21:30 UTC  Ion Alberdi <ion.alberdi@pricemoov.com>
  [14+ messages in thread]

Aw: Re: Re: Turn a json column into a table
  2022-02-15 08:37 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>

How best to work around the issue - regex string cannot contain brackets
  2022-02-03 16:53 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: How best to work around the issue - regex string cannot contain brackets
  2022-02-03 16:58 UTC  Christophe Pettus <xof@thebuild.com>
` Re: How best to work around the issue - regex string cannot contain brackets
  2022-02-03 17:04 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: How best to work around the issue - regex string cannot contain brackets
  2022-02-04 12:55 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: How best to work around the issue - regex string cannot contain brackets
  2022-02-04 14:00 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: How best to work around the issue - regex string cannot contain brackets
  2022-02-04 17:14 UTC  Steve Midgley <science@misuse.org>
` Re: How best to work around the issue - regex string cannot contain brackets
  2022-02-04 17:24 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: How best to work around the issue - regex string cannot contain brackets
  2022-02-04 17:29 UTC  Steve Midgley <science@misuse.org>
  [8+ messages in thread]

Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-03 11:40 UTC  aditya desai <admad123@gmail.com>
` Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 03:50 UTC  aditya desai <admad123@gmail.com>
` Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 03:55 UTC  Steve Midgley <science@misuse.org>
` Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 03:56 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 03:59 UTC  aditya desai <admad123@gmail.com>
` Fwd: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 04:02 UTC  aditya desai <admad123@gmail.com>
` Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 04:14 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 04:18 UTC  aditya desai <admad123@gmail.com>
` Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  2022-02-04 04:18 UTC  aditya desai <admad123@gmail.com>
  [9+ 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