pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
  2023-03-11 20:23 UTC  Atul Kumar <akumar14871@gmail.com>
` Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
  2023-03-11 20:54 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
  2023-03-12 14:01 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
  2023-03-12 17:00 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
  2023-03-12 18:04 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [5+ messages in thread]

ERROR: only immutable functions supported in continuous aggregate view
  2023-03-11 14:04 UTC  Martijn de Munnik <martijndemunnik@protonmail.com>
` Re: ERROR: only immutable functions supported in continuous aggregate view
  2023-03-11 15:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: ERROR: only immutable functions supported in continuous aggregate view
  2023-03-12 08:49 UTC  Martijn de Munnik <martijndemunnik@protonmail.com>
  [3+ messages in thread]

Idea: Add first() and last() aggregate functions to the main release
  2023-03-11 12:20 UTC  Ben Clements <benhasgonewalking@gmail.com>
` Re: Idea: Add first() and last() aggregate functions to the main release
  2023-03-11 23:49 UTC  Erwin Brandstetter <brsaweda@gmail.com>
  [2+ messages in thread]

select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-09 00:41 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-09 00:50 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-09 02:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-09 02:58 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-09 03:28 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-09 19:46 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-09 21:24 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-10 20:29 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
  2023-03-10 20:46 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [9+ messages in thread]

Get more columns from a lookup type subselect
  2023-03-10 07:34 UTC  Durumdara <durumdara@gmail.com>
` Re: Get more columns from a lookup type subselect
  2023-03-10 08:43 UTC  negora <public@negora.com>
` Re: Get more columns from a lookup type subselect
  2023-03-10 10:00 UTC  Durumdara <durumdara@gmail.com>
` Re: Get more columns from a lookup type subselect
  2023-03-10 11:09 UTC  negora <public@negora.com>
  [4+ messages in thread]

SV: Onfly, function generated ID for Select Query
  2023-03-10 07:33 UTC  Gustavsson Mikael <mikael.gustavsson@smhi.se>
` SV: Onfly, function generated ID for Select Query
  2023-03-10 07:48 UTC  Gustavsson Mikael <mikael.gustavsson@smhi.se>
  [2+ messages in thread]

Onfly, function generated ID for Select Query
  2023-03-10 07:12 UTC  Durumdara <durumdara@gmail.com>
` Re: Onfly, function generated ID for Select Query
  2023-03-10 07:41 UTC  Durumdara <durumdara@gmail.com>
  [2+ messages in thread]

public schema grants to PUBLIC role
  2023-03-09 09:34 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: public schema grants to PUBLIC role
  2023-03-09 11:35 UTC  Christoph Moench-Tegeder <cmt@burggraben.net>
` Re: public schema grants to PUBLIC role
  2023-03-09 13:13 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: public schema grants to PUBLIC role
  2023-03-09 15:18 UTC  Dominique Devienne <ddevienne@gmail.com>
  [4+ messages in thread]

find coumn name and his type with greatest size in bytes
  2023-03-09 14:45 UTC  Алексей Ефимов <asefimov@gmail.com>

Crosstab
  2007-02-20 23:44 UTC  Robert Fitzpatrick <lists@webtent.net>
` crosstab
  2012-09-04 15:39 UTC  punnoose <punnoose.pj@dwisesolutions.com>
` Re: crosstab
  2012-09-04 16:02 UTC  dinesh kumar <dineshkumar02@gmail.com>
` Re: crosstab
  2012-09-04 17:15 UTC  Aram Fingal <fingal@multifactorial.com>
` Re: crosstab
  2012-09-04 18:51 UTC  Vincent Veyron <vv.lists@wanadoo.fr>
` Re: crosstab
  2012-09-04 19:01 UTC  dinesh kumar <dineshkumar02@gmail.com>
` Re: crosstab
  2012-09-04 19:17 UTC  Aram Fingal <fingal@multifactorial.com>
` Re: crosstab
  2012-09-04 19:26 UTC  Joe Conway <mail@joeconway.com>
` Re: crosstab
  2012-09-04 19:48 UTC  Aram Fingal <fingal@multifactorial.com>
` Re: crosstab
  2012-09-04 19:56 UTC  Joe Conway <mail@joeconway.com>
` Re: crosstab
  2012-09-04 20:18 UTC  Misa Simic <misa.simic@gmail.com>
` Re: crosstab
  2012-09-04 20:23 UTC  Aram Fingal <fingal@multifactorial.com>
` Re: crosstab
  2012-09-04 20:30 UTC  Aram Fingal <fingal@multifactorial.com>
` Re: crosstab
  2012-09-04 20:36 UTC  A.M. <agentm@themactionfaction.com>
` Re: crosstab
  2012-09-04 20:51 UTC  Misa Simic <misa.simic@gmail.com>
` Re: crosstab
  2012-09-04 20:56 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: crosstab
  2012-09-04 21:06 UTC  Joe Conway <mail@joeconway.com>
` Re: crosstab
  2012-09-04 21:59 UTC  Aram Fingal <fingal@multifactorial.com>
` Re: crosstab
  2012-09-04 23:21 UTC  Joe Conway <mail@joeconway.com>
` Re: crosstab
  2012-09-04 23:45 UTC  Misa Simic <misa.simic@gmail.com>
` Re: crosstab
  2012-09-04 23:49 UTC  Misa Simic <misa.simic@gmail.com>
` Re: crosstab
  2012-09-04 23:59 UTC  Joe Conway <mail@joeconway.com>
` Re: crosstab
  2012-09-05 00:21 UTC  Misa Simic <misa.simic@gmail.com>
` crosstab
  2023-03-09 06:07 UTC  Rosebrock, Uwe (Environment, Hobart) <Uwe.Rosebrock@csiro.au>
` Re: crosstab
  2023-03-09 13:22 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [25+ messages in thread]

Blog post series on commitfests and patches
  2023-03-09 03:24 UTC  Chris Travers <chris.travers@gmail.com>
` RE: Blog post series on commitfests and patches
  2023-03-09 12:14 UTC  Tim Clarke <tim.clarke@minerva.info>
  [2+ messages in thread]

Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-07 20:24 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-07 21:25 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 00:52 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 01:03 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 04:25 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Fwd: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 04:26 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 04:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 04:56 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 05:19 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 05:27 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 21:29 UTC  Bryn Llewellyn <bryn@yugabyte.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-08 23:20 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  2023-03-09 04:53 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [13+ messages in thread]

could not bind IPv4 address "127.0.0.1": Address already in use
  2023-03-08 01:28 UTC  Siddharth Jain <siddhsql@gmail.com>
` Re: could not bind IPv4 address "127.0.0.1": Address already in use
  2023-03-08 04:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: could not bind IPv4 address "127.0.0.1": Address already in use
  2023-03-08 16:45 UTC  Siddharth Jain <siddhsql@gmail.com>
  [3+ messages in thread]

garbage data back
  2023-03-06 20:17 UTC  Brad White <b55white@gmail.com>
` Re: garbage data back
  2023-03-06 20:23 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: garbage data back
  2023-03-06 20:29 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Fwd: garbage data back
  2023-03-06 20:48 UTC  Brad White <b55white@gmail.com>
` Re: garbage data back
  2023-03-06 20:54 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Fwd: garbage data back
  2023-03-06 20:59 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: garbage data back
  2023-03-06 21:27 UTC  Brad White <b55white@gmail.com>
` Re: garbage data back
  2023-03-06 21:56 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: garbage data back
  2023-03-07 19:30 UTC  Brad White <b55white@gmail.com>
  [9+ messages in thread]

psql \conninfo in tabular form?
  2023-03-07 17:58 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: psql \conninfo in tabular form?
  2023-03-07 19:07 UTC  Erik Wienhold <ewie@ewie.name>
  [2+ messages in thread]

escape vs. bytea in config
  2023-03-07 10:53 UTC  Mathias Mayrhofer <mtmayr@mtmayr.com>
` Re: escape vs. bytea in config
  2023-03-07 12:35 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: escape vs. bytea in config
  2023-03-07 12:53 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
  [3+ messages in thread]

Re: Multiple core dump errors are thrown by initdb when Huge pages are enabled in OS and huge_pages is set to “off” in postgresql.conf.sample in Kubernetes.
  2023-03-07 07:00 UTC  Julien Rouhaud <rjuju123@gmail.com>

 Multiple core dump errors are thrown by initdb when Huge pages are enabled in OS and huge_pages is set to “off” in postgresql.conf.sample in Kubernetes.
  2023-03-07 05:44 UTC  M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>

How does Postgres store a B-Tree on disk while using the OS file system?
  2023-03-07 00:24 UTC  Siddharth Jain <siddhsql@gmail.com>
` Re: How does Postgres store a B-Tree on disk while using the OS file system?
  2023-03-07 00:49 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: How does Postgres store a B-Tree on disk while using the OS file system?
  2023-03-07 01:07 UTC  Christophe Pettus <xof@thebuild.com>
` Re: How does Postgres store a B-Tree on disk while using the OS file system?
  2023-03-07 02:53 UTC  Siddharth Jain <siddhsql@gmail.com>
  [4+ messages in thread]

CREATE/DROP ROLE transactional? GRANT/REVOKE?
  2023-03-06 13:19 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
  2023-03-06 14:02 UTC  Erik Wienhold <ewie@ewie.name>
` Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
  2023-03-06 15:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
  2023-03-06 15:25 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
  2023-03-06 15:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
  2023-03-06 15:34 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
  2023-03-06 15:39 UTC  Dominique Devienne <ddevienne@gmail.com>
  [7+ messages in thread]

Row Level Security Policy Name in Error Message
  2023-03-06 00:18 UTC  Louis Tian <louis.tian@aquamonix.com.au>
` Re: Row Level Security Policy Name in Error Message
  2023-03-06 11:19 UTC  Daniel Gustafsson <daniel@yesql.se>
  [2+ messages in thread]

what's hsitoric MVCC Snapshot?
  2023-03-05 14:49 UTC  jacktby@gmail.com <jacktby@gmail.com>
` Re: what's hsitoric MVCC Snapshot?
  2023-03-05 15:58 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: what's hsitoric MVCC Snapshot?
  2023-03-05 16:00 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [3+ messages in thread]

psql \set variables in crosstab queries?
  2023-03-05 00:20 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: psql \set variables in crosstab queries?
  2023-03-05 01:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: psql \set variables in crosstab queries?
  2023-03-05 01:32 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: psql \set variables in crosstab queries?
  2023-03-05 05:03 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: psql \set variables in crosstab queries?
  2023-03-05 05:05 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: psql \set variables in crosstab queries?
  2023-03-05 05:15 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [6+ messages in thread]

Dropping behavior for unique CONSTRAINTs
  2023-03-02 20:30 UTC  Conner Bean <conner.bean@icloud.com>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-03 10:54 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-03 14:44 UTC  Conner Bean <conner.bean@icloud.com>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-03 21:55 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-04 00:50 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-04 08:03 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-04 08:09 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-04 08:34 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-04 11:51 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Dropping behavior for unique CONSTRAINTs
  2023-03-04 22:01 UTC  Ron <ronljohnsonjr@gmail.com>
  [10+ messages in thread]

DISTINCT *and* ORDER BY in aggregate functions on expressions(!)
  2023-02-27 23:11 UTC  mirabilos <tg@evolvis.org>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)
  2023-02-28 00:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)
  2023-02-28 00:22 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)
  2023-02-28 00:44 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)
  2023-02-28 01:22 UTC  Thorsten Glaser <tg@evolvis.org>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)
  2023-02-28 01:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)
  2023-02-28 01:48 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
  2023-02-28 02:54 UTC  Thorsten Glaser <tg@evolvis.org>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
  2023-02-28 08:10 UTC  Alban Hertroys <haramrae@gmail.com>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
  2023-03-02 23:02 UTC  Thorsten Glaser <tg@evolvis.org>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
  2023-03-03 08:31 UTC  Alban Hertroys <haramrae@gmail.com>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
  2023-03-03 19:32 UTC  Thorsten Glaser <tg@evolvis.org>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
  2023-03-04 10:48 UTC  Alban Hertroys <haramrae@gmail.com>
` Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
  2023-03-04 20:00 UTC  Thorsten Glaser <tg@evolvis.org>
  [14+ messages in thread]


[next (older)]

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