pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
concatenating hstores in a group by?
  2025-01-17 20:43 UTC  Brent Wood <Brent.Wood@niwa.co.nz>
` concatenating hstores in a group by?
  2025-01-19 15:28 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: concatenating hstores in a group by?
  2025-01-19 16:16 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: concatenating hstores in a group by?
  2025-01-19 16:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: concatenating hstores in a group by?
  2025-01-19 20:09 UTC  Brent Wood <Brent.Wood@niwa.co.nz>
` Re: concatenating hstores in a group by?
  2025-01-21 17:34 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: concatenating hstores in a group by?
  2025-01-21 18:02 UTC  Brent Wood <pcreso@yahoo.com>
` Re: concatenating hstores in a group by?
  2025-01-22 00:29 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [8+ messages in thread]

(no subject)
  2025-01-20 18:10 UTC  Lana ABADIE <clipperDB@gmx.fr>
` Re:
  2025-01-21 17:21 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [2+ messages in thread]

Design of a reliable task processing queue
  2025-01-18 10:44 UTC  Alex Burkhart <burkharta77@gmail.com>
` Re: Design of a reliable task processing queue
  2025-01-19 11:37 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Design of a reliable task processing queue
  2025-01-19 15:17 UTC  Shaheed Haque <shaheedhaque@gmail.com>
` Re: Design of a reliable task processing queue
  2025-01-19 16:06 UTC  auxsvr@gmail.com
` Re: Design of a reliable task processing queue
  2025-01-21 12:21 UTC  Dominique Devienne <ddevienne@gmail.com>
  [5+ messages in thread]

could not open file "base/XX/XX": Interrupted system call
  2023-09-20 08:49 UTC  Torsten Krah <krah.tm@gmail.com>
` Re: could not open file "base/XX/XX": Interrupted system call
  2023-09-20 11:11 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: could not open file "base/XX/XX": Interrupted system call
  2023-09-20 11:24 UTC  Torsten Krah <krah.tm@gmail.com>
` Re: could not open file "base/XX/XX": Interrupted system call
  2024-12-26 11:48 UTC  Slava Shpitalny <slava.shpitalny@tactilemobility.com>
` Re: could not open file "base/XX/XX": Interrupted system call
  2025-01-13 09:34 UTC  Torsten Krah <krah.tm@gmail.com>
` Re: could not open file "base/XX/XX": Interrupted system call
  2025-01-20 14:24 UTC  Andreas Froede <psql@andreas.spider-net.de>
` Re: could not open file "base/XX/XX": Interrupted system call
  2025-01-20 14:30 UTC  Andreas Froede <psql@andreas.spider-net.de>
  [7+ messages in thread]

pg_repack and locks
  2025-01-13 12:40 UTC  nicolas <nicolas75_fr@yahoo.fr>
` Re: pg_repack and locks
  2025-01-13 15:41 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` RE: pg_repack and locks
  2025-01-19 12:51 UTC  nicolas75_fr@yahoo.fr
` Re: pg_repack and locks
  2025-01-19 13:50 UTC  Boris Zentner <bzm@2bz.de>
  [4+ messages in thread]

Postgresql database terminates abruptly with toomay open files error
  2025-01-14 12:52 UTC  Sri Mrudula Attili <sri@ebi.ac.uk>
` Postgresql database terminates abruptly with too many open files error
  2025-01-14 12:58 UTC  Sri Mrudula Attili <sri@ebi.ac.uk>
` Re: Postgresql database terminates abruptly with too many open files error
  2025-01-14 13:39 UTC  Frank Lanitz <frank@frank.uvena.de>
` Re: Postgresql database terminates abruptly with too many open files error
  2025-01-14 13:39 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Postgresql database terminates abruptly with too many open files error
  2025-01-14 14:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql database terminates abruptly with too many open files error
  2025-01-15 11:42 UTC  Sri Mrudula Attili <sri@ebi.ac.uk>
` Re: Postgresql database terminates abruptly with too many open files error
  2025-01-19 09:01 UTC  Durgamahesh Manne <maheshpostgres9@gmail.com>
` Re: Postgresql database terminates abruptly with too many open files error
  2025-01-19 11:06 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
  [8+ messages in thread]

glibc 2.35-2.39 upgrade requirements
  2025-01-16 16:44 UTC  Kamen Kalchev <kalchev035@gmail.com>
` Re: glibc 2.35-2.39 upgrade requirements
  2025-01-17 15:00 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: glibc 2.35-2.39 upgrade requirements
  2025-01-17 15:16 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>
` Re: glibc 2.35-2.39 upgrade requirements
  2025-01-17 15:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: glibc 2.35-2.39 upgrade requirements
  2025-01-19 07:20 UTC  Jeremy Schneider <schneider@ardentperf.com>
  [5+ messages in thread]

Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?
  2025-01-18 11:21 UTC  Alexander Farber <alexander.farber@gmail.com>
` Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?
  2025-01-18 12:05 UTC  GF <phabriz@gmail.com>
` Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?
  2025-01-18 14:04 UTC  Alexander Farber <alexander.farber@gmail.com>
` Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?
  2025-01-18 16:06 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [4+ messages in thread]

Different Autovacuum Settings on Master and Replica in Streaming Replication
  2025-01-17 14:37 UTC  Franjo Stipanovic <fritzfs@gmail.com>
` Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
  2025-01-17 15:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
  2025-01-17 15:34 UTC  Guillaume Lelarge <guillaume@lelarge.info>
` Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
  2025-01-17 17:12 UTC  Franjo Stipanovic <fritzfs@gmail.com>
` Re: Different Autovacuum Settings on Master and Replica in Streaming Replication
  2025-01-17 21:11 UTC  Guillaume Lelarge <guillaume@lelarge.info>
  [5+ messages in thread]

pgvector extension error
  2025-01-17 17:13 UTC  Zacher, Stacy <szacher@mcw.edu>
` Re: pgvector extension error
  2025-01-17 17:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

On enforcing default column value, AKA "Bloody nulls"
  2025-01-16 12:14 UTC  Wiwwo Staff <wiwwo@wiwwo.com>
` Re: On enforcing default column value, AKA "Bloody nulls"
  2025-01-16 12:24 UTC  hubert depesz lubaczewski <depesz@depesz.com>
  [2+ messages in thread]

Data Out of Sync with Physical Streaming Replication
  2025-01-15 18:50 UTC  Tim Gerber <tggerber@gmail.com>
` Re: Data Out of Sync with Physical Streaming Replication
  2025-01-15 20:27 UTC  Tomas Vondra <tomas@vondra.me>
` Re: Data Out of Sync with Physical Streaming Replication
  2025-01-15 21:14 UTC  Tim Gerber <tggerber@gmail.com>
  [3+ messages in thread]

Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-17 16:30 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-18 15:11 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-18 23:11 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-19 07:52 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-19 16:34 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-19 18:11 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-19 18:27 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-19 19:40 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-19 21:47 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-20 07:57 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-20 15:02 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-20 16:41 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-20 16:43 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-20 20:05 UTC  mark bradley <markbradyju@outlook.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-20 20:11 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-24 22:23 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2024-12-25 23:20 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-13 08:45 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-13 16:19 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-13 16:59 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-13 17:26 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-14 07:56 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-14 17:56 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-15 07:46 UTC  Enrico Schenone <eschenone@cleistech.it>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-15 16:03 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
  2025-01-15 17:10 UTC  Enrico Schenone <eschenone@cleistech.it>
  [26+ messages in thread]

Fwd: Lock in postgreSQL
  2025-01-14 18:42 UTC  Igor Korot <ikorot01@gmail.com>
` Re: Fwd: Lock in postgreSQL
  2025-01-14 18:46 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [2+ messages in thread]

About PostgreSQL Memory Usage
  2025-01-14 11:00 UTC  Eşref Halıcıoğlu <esref.halicioglu@primeit.com.tr>

About PostgreSQL Query Plan
  2025-01-13 14:26 UTC  Eşref Halıcıoğlu <esref.halicioglu@primeit.com.tr>
` Re: About PostgreSQL Query Plan
  2025-01-13 15:42 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: About PostgreSQL Query Plan
  2025-01-13 16:48 UTC  Eşref Halıcıoğlu <esref.halicioglu@primeit.com.tr>
` Re: About PostgreSQL Query Plan
  2025-01-13 16:56 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: About PostgreSQL Query Plan
  2025-01-13 17:01 UTC  Eşref Halıcıoğlu <esref.halicioglu@primeit.com.tr>
` Re: About PostgreSQL Query Plan
  2025-01-13 17:04 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: About PostgreSQL Query Plan
  2025-01-14 10:09 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: About PostgreSQL Query Plan
  2025-01-14 10:45 UTC  Eşref Halıcıoğlu <esref.halicioglu@primeit.com.tr>
  [8+ messages in thread]

pgAgent error on Installation
  2025-01-13 19:11 UTC  Fakarai, Edgar <EFakarai@iot.IN.gov>
` Re: pgAgent error on Installation
  2025-01-14 10:15 UTC  Daniel Gustafsson <daniel@yesql.se>
  [2+ messages in thread]

Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-12 22:28 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-12 22:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-12 23:37 UTC  Bruce Momjian <bruce@momjian.us>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-13 00:15 UTC  Isaac Morland <isaac.morland@gmail.com>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-13 00:17 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-13 17:11 UTC  Joe Conway <mail@joeconway.com>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-13 17:19 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-13 20:41 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Automatic upgrade of passwords from md5 to scram-sha256
  2025-01-14 01:09 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
  [9+ messages in thread]

Need help in logical replication
  2025-01-13 12:29 UTC  Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>
` Re: Need help in logical replication
  2025-01-13 15:38 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Need help in logical replication
  2025-01-13 16:45 UTC  Justin <zzzzz.graf@gmail.com>
` Re: Need help in logical replication
  2025-01-13 17:19 UTC  Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>
  [4+ messages in thread]

Display Bytea field
  2025-01-09 20:16 UTC  Andy Hartman <hartman60home@gmail.com>
` Re: Display Bytea field
  2025-01-09 20:17 UTC  Andy Hartman <hartman60home@gmail.com>
` Re: Display Bytea field
  2025-01-09 20:24 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Display Bytea field
  2025-01-09 20:31 UTC  Andy Hartman <hartman60home@gmail.com>
` Re: Display Bytea field
  2025-01-09 20:37 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Display Bytea field
  2025-01-09 22:10 UTC  thiemo@gelassene-pferde.biz
` Re: Display Bytea field
  2025-01-09 22:11 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Display Bytea field
  2025-01-10 12:49 UTC  Daniel Verite <daniel@manitou-mail.org>
` Re: Display Bytea field
  2025-01-10 14:39 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Display Bytea field
  2025-01-10 17:35 UTC  Erik Wienhold <ewie@ewie.name>
` Re: Display Bytea field
  2025-01-11 11:05 UTC  Andy Hartman <hartman60home@gmail.com>
` Re: Display Bytea field
  2025-01-11 12:50 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Display Bytea field
  2025-01-11 16:50 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Display Bytea field
  2025-01-11 23:49 UTC  Andy Hartman <hartman60home@gmail.com>
` Re: Display Bytea field
  2025-01-12 00:03 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Display Bytea field
  2025-01-12 00:08 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Display Bytea field
  2025-01-12 00:09 UTC  Andy Hartman <hartman60home@gmail.com>
` Re: Display Bytea field
  2025-01-12 00:25 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [18+ messages in thread]

Postgres do not support tinyint?
  2025-01-08 05:06 UTC  Igor Korot <ikorot01@gmail.com>
` Re: Postgres do not support tinyint?
  2025-01-08 05:20 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Postgres do not support tinyint?
  2025-01-08 05:24 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Postgres do not support tinyint?
  2025-01-08 06:26 UTC  Igor Korot <ikorot01@gmail.com>
` Re: Postgres do not support tinyint?
  2025-01-08 06:28 UTC  Christophe Pettus <xof@thebuild.com>
` Re: Postgres do not support tinyint?
  2025-01-08 06:44 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Postgres do not support tinyint?
  2025-01-08 06:49 UTC  Christophe Pettus <xof@thebuild.com>
` Re: Postgres do not support tinyint?
  2025-01-08 06:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres do not support tinyint?
  2025-01-08 19:30 UTC  Igor Korot <ikorot01@gmail.com>
` Re: Postgres do not support tinyint?
  2025-01-08 19:34 UTC  Christophe Pettus <xof@thebuild.com>
` Re: Postgres do not support tinyint?
  2025-01-08 19:40 UTC  Igor Korot <ikorot01@gmail.com>
` Re: Postgres do not support tinyint?
  2025-01-08 19:47 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Postgres do not support tinyint?
  2025-01-10 09:13 UTC  Vladlen Popolitov <v.popolitov@postgrespro.ru>
` Re: Postgres do not support tinyint?
  2025-01-10 09:41 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: Postgres do not support tinyint?
  2025-01-10 10:44 UTC  shammat@gmx.net
` Re: Postgres do not support tinyint?
  2025-01-10 15:04 UTC  Vladlen Popolitov <v.popolitov@postgrespro.ru>
  [16+ messages in thread]

Parameter - shared_memory_size
  2025-01-10 06:44 UTC  Jayadevan M <maymala.jayadevan@gmail.com>
` Re: Parameter - shared_memory_size
  2025-01-10 08:05 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

recovery error while running any statement
  2025-01-09 16:42 UTC  yudhi s <learnerdatabase99@gmail.com>
` Re: recovery error while running any statement
  2025-01-09 16:48 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: recovery error while running any statement
  2025-01-09 16:51 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: recovery error while running any statement
  2025-01-09 16:54 UTC  yudhi s <learnerdatabase99@gmail.com>
` Re: recovery error while running any statement
  2025-01-09 17:01 UTC  yudhi s <learnerdatabase99@gmail.com>
` Re: recovery error while running any statement
  2025-01-09 17:05 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: recovery error while running any statement
  2025-01-09 17:10 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
  [7+ messages in thread]

Issue with Password Authentication for Pgpool
  2025-01-09 05:06 UTC  vijay patil <vijay.postgres@gmail.com>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 05:17 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 05:31 UTC  vijay patil <vijay.postgres@gmail.com>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 05:44 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 06:04 UTC  vijay patil <vijay.postgres@gmail.com>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 06:12 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 07:19 UTC  Tatsuo Ishii <ishii@postgresql.org>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 07:23 UTC  Tatsuo Ishii <ishii@postgresql.org>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 07:36 UTC  vijay patil <vijay.postgres@gmail.com>
` Re: Issue with Password Authentication for Pgpool
  2025-01-09 17:08 UTC  Martin Gainty <mgainty@hotmail.com>
  [10+ messages in thread]

Unexpected results from a query with UNION ALL
  2025-01-03 18:19 UTC  Andrey <adnyre@gmail.com>
` Re: Unexpected results from a query with UNION ALL
  2025-01-04 18:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected results from a query with UNION ALL
  2025-01-08 17:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected results from a query with UNION ALL
  2025-01-09 16:49 UTC  Andrii Novikov <adnyre@gmail.com>
  [4+ 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