public inbox for [email protected]help / color / mirror / Atom feed
Messages from [email protected] Re: assertion failure with unique index + partitioning + join 2026-06-17 02:00 UTC Tender Wang <[email protected]> Re: assertion failure with unique index + partitioning + join 2026-06-16 09:32 UTC Tender Wang <[email protected]> Re: assertion failure with unique index + partitioning + join 2026-06-16 07:45 UTC Tender Wang <[email protected]> Re: assertion failure with unique index + partitioning + join 2026-06-16 04:06 UTC Tender Wang <[email protected]> Re: assertion failure with unique index + partitioning + join 2026-06-16 01:58 UTC Tender Wang <[email protected]> Re: Wrong unsafe-flag test in check_output_expressions() 2026-06-02 01:12 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2026-06-01 07:57 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2026-05-31 11:28 UTC Tender Wang <[email protected]> Re: Discarded adjust_relid_set() return values in remove_self_join_rel 2026-04-25 07:53 UTC Tender Wang <[email protected]> Re: pg_plan_advice 2026-04-16 01:45 UTC Tender Wang <[email protected]> Re: pg_plan_advice 2026-04-15 10:30 UTC Tender Wang <[email protected]> Re: pg17: XX000: no relation entry for relid 0 2026-04-11 01:31 UTC Tender Wang <[email protected]> Re: pg17: XX000: no relation entry for relid 0 2026-04-10 12:49 UTC Tender Wang <[email protected]> Re: Bug: var_is_nonnullable() gives wrong results for old/new in RETURNING 2026-04-10 01:29 UTC Tender Wang <[email protected]> Fix "detected double pfree in PgStat Snapshot 0x557d9926b400" error 2026-04-08 07:56 UTC Tender Wang <[email protected]> Re: Clean up remove_rel_from_query() after self-join elimination commit 2026-04-07 01:43 UTC Tender Wang <[email protected]> Re: Fix "could not find memoization table entry" 2026-03-25 09:00 UTC Tender Wang <[email protected]> Re: Fix "could not find memoization table entry" 2026-03-24 03:07 UTC Tender Wang <[email protected]> Re: Fix "could not find memoization table entry" 2026-03-24 01:10 UTC Tender Wang <[email protected]> Fix "could not find memoization table entry" 2026-03-23 06:29 UTC Tender Wang <[email protected]> Re: More speedups for tuple deformation 2026-03-19 12:39 UTC Tender Wang <[email protected]> [PATCH] Update HandleChildCrash comments 2026-03-17 05:24 UTC Tender Wang <[email protected]> Re: More speedups for tuple deformation 2026-03-16 07:01 UTC Tender Wang <[email protected]> Re: [PATCH] Simplify trivial shmem size calculations 2026-03-11 00:21 UTC Tender Wang <[email protected]> [PATCH] Simplify trivial shmem size calculations 2026-03-10 12:59 UTC Tender Wang <[email protected]> Re: [BUG?] estimate_hash_bucket_stats uses wrong ndistinct for avgfreq 2026-03-01 04:14 UTC Tender Wang <[email protected]> Re: [BUG?] estimate_hash_bucket_stats uses wrong ndistinct for avgfreq 2026-03-01 03:40 UTC Tender Wang <[email protected]> Re: [BUG?] estimate_hash_bucket_stats uses wrong ndistinct for avgfreq 2026-02-27 23:57 UTC Tender Wang <[email protected]> Re: MERGE behavior with REPEATABLE READ isolation level 2026-02-27 12:54 UTC Tender Wang <[email protected]> Re: [BUG?] estimate_hash_bucket_stats uses wrong ndistinct for avgfreq 2026-02-26 13:56 UTC Tender Wang <[email protected]> Re: MERGE behavior with REPEATABLE READ isolation level 2026-02-24 03:12 UTC Tender Wang <[email protected]> Re: Planner : anti-join on left joins 2026-02-13 02:17 UTC Tender Wang <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-02-04 04:54 UTC Tender Wang <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-01-29 08:48 UTC Tender Wang <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-01-28 01:59 UTC Tender Wang <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-01-27 02:32 UTC Tender Wang <[email protected]> Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed 2026-01-25 07:20 UTC Tender Wang <[email protected]> Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 2026-01-06 07:13 UTC Tender Wang <[email protected]> Re: Planner : anti-join on left joins 2026-01-06 01:47 UTC Tender Wang <[email protected]> Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 2026-01-05 11:06 UTC Tender Wang <[email protected]> Re: Planner : anti-join on left joins 2026-01-05 10:59 UTC Tender Wang <[email protected]> Re: Planner : anti-join on left joins 2026-01-02 06:53 UTC Tender Wang <[email protected]> Re: Planner : anti-join on left joins 2026-01-01 06:23 UTC Tender Wang <[email protected]> Re: Extended Statistics set/restore/clear functions. 2025-12-25 11:00 UTC Tender Wang <[email protected]> Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 2025-12-21 07:14 UTC Tender Wang <[email protected]> Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 2025-12-20 03:18 UTC Tender Wang <[email protected]> Re: [PATCH v1] Fixed a spelling error in the comments in gininsert.c 2025-12-19 05:55 UTC Tender Wang <[email protected]> Re: Some optimizations for COALESCE expressions during constant folding 2025-11-25 12:07 UTC Tender Wang <[email protected]> Re: generic plans and "initial" pruning 2025-11-23 12:17 UTC Tender Wang <[email protected]> Re: Fix typos in ExecChooseHashTableSize() 2025-11-19 02:32 UTC Tender Wang <[email protected]> Fix typos in ExecChooseHashTableSize() 2025-11-18 09:29 UTC Tender Wang <[email protected]> Re: Use opresulttype instead of calling SearchSysCache1() in match_orclause_to_indexcol() 2025-11-17 03:36 UTC Tender Wang <[email protected]> Re: Use opresulttype instead of calling SearchSysCache1() in match_orclause_to_indexcol() 2025-11-16 12:41 UTC Tender Wang <[email protected]> Fix a typo in the comment for gettuple_eval_partition() 2025-11-10 11:11 UTC Tender Wang <[email protected]> Re: Use opresulttype instead of calling SearchSysCache1() in match_orclause_to_indexcol() 2025-10-18 03:12 UTC Tender Wang <[email protected]> Re: Fix an unnecessary cast calling elog in ExecHashJoinImpl 2025-10-17 04:20 UTC Tender Wang <[email protected]> Re: Fix an unnecessary cast calling elog in ExecHashJoinImpl 2025-10-16 12:24 UTC Tender Wang <[email protected]> Re: Fix typo in comment of match_orclause_to_indexcol() 2025-09-19 11:46 UTC Tender Wang <[email protected]> Use opresulttype instead of calling SearchSysCache1() in match_orclause_to_indexcol() 2025-09-19 11:44 UTC Tender Wang <[email protected]> Fix typo in comment of match_orclause_to_indexcol() 2025-09-19 10:48 UTC Tender Wang <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-09-08 00:51 UTC Tender Wang <[email protected]> Fix an unnecessary cast calling elog in ExecHashJoinImpl 2025-08-30 06:09 UTC Tender Wang <[email protected]> Fix typos in comments in worker.c and execReplication.c 2025-08-16 07:43 UTC Tender Wang <[email protected]> Re: Typo in create_index regression test 2025-08-04 14:18 UTC Tender Wang <[email protected]> Re: A little cosmetic to convert_VALUES_to_ANY() 2025-08-04 04:40 UTC Tender Wang <[email protected]> Re: A little cosmetic to convert_VALUES_to_ANY() 2025-08-04 03:41 UTC Tender Wang <[email protected]> Re: A little cosmetic to convert_VALUES_to_ANY() 2025-08-01 14:45 UTC Tender Wang <[email protected]> Re: When creating index, why pointing to old version of tuple 2025-08-01 06:58 UTC Tender Wang <[email protected]> Re: When creating index, why pointing to old version of tuple 2025-08-01 06:36 UTC Tender Wang <[email protected]> Re: Raw parse tree is not dumped to log 2025-08-01 06:24 UTC Tender Wang <[email protected]> A little cosmetic to convert_VALUES_to_ANY() 2025-07-27 07:53 UTC Tender Wang <[email protected]> Re: MergeJoin beats HashJoin in the case of multiple hash clauses 2025-07-20 00:05 UTC Tender Wang <[email protected]> Re: postgres_fdw could deparse ArrayCoerceExpr 2025-07-18 14:33 UTC Tender Wang <[email protected]> Re: duplicate line in ExecEvalJsonCoercionFinish 2025-07-17 00:51 UTC Tender Wang <[email protected]> Re: MergeJoin beats HashJoin in the case of multiple hash clauses 2025-07-08 00:52 UTC Tender Wang <[email protected]> Re: MergeJoin beats HashJoin in the case of multiple hash clauses 2025-07-03 09:48 UTC Tender Wang <[email protected]> Re: MergeJoin beats HashJoin in the case of multiple hash clauses 2025-07-03 02:02 UTC Tender Wang <[email protected]> Re: MergeJoin beats HashJoin in the case of multiple hash clauses 2025-06-30 02:38 UTC Tender Wang <[email protected]> Re: Foreign key validation failure in 18beta1 2025-05-29 04:35 UTC Tender Wang <[email protected]> Re: Foreign key validation failure in 18beta1 2025-05-28 12:38 UTC Tender Wang <[email protected]> Re: Foreign key validation failure in 18beta1 2025-05-28 12:12 UTC Tender Wang <[email protected]> Re: Standardize the definition of the subtype field of AlterDomainStmt 2025-05-28 11:30 UTC Tender Wang <[email protected]> Re: Foreign key validation failure in 18beta1 2025-05-28 10:54 UTC Tender Wang <[email protected]> Re: MERGE issues around inheritance 2025-05-28 10:37 UTC Tender Wang <[email protected]> Re: ALTER TABLE ALTER CONSTRAINT misleading error message 2025-05-28 09:26 UTC Tender Wang <[email protected]> Re: MERGE issues around inheritance 2025-05-26 11:50 UTC Tender Wang <[email protected]> Re: MERGE issues around inheritance 2025-05-26 09:39 UTC Tender Wang <[email protected]> Re: MERGE issues around inheritance 2025-05-26 06:46 UTC Tender Wang <[email protected]> Re: MERGE issues around inheritance 2025-05-26 02:27 UTC Tender Wang <[email protected]> Re: MERGE issues around inheritance 2025-05-25 12:05 UTC Tender Wang <[email protected]> Re: MERGE issues around inheritance 2025-05-25 11:17 UTC Tender Wang <[email protected]> Re: Issue attaching a table to a partitioned table with an auto-referenced foreign key 2025-05-01 15:21 UTC Tender Wang <[email protected]> Re: Typos in the comment for the estimate_multivariate_ndistinct() 2025-04-25 01:21 UTC Tender Wang <[email protected]> Re: MergeJoin beats HashJoin in the case of multiple hash clauses 2025-04-24 14:07 UTC Tender Wang <[email protected]> Re: not null constraints, again 2025-04-17 17:01 UTC Tender Wang <[email protected]> Re: Typos in the comment for the estimate_multivariate_ndistinct() 2025-04-16 14:16 UTC Tender Wang <[email protected]> Re: not null constraints, again 2025-04-16 12:11 UTC Tender Wang <[email protected]> Re: not null constraints, again 2025-04-16 06:28 UTC Tender Wang <[email protected]> Re: not null constraints, again 2025-04-15 05:08 UTC Tender Wang <[email protected]> Re: not null constraints, again 2025-04-15 03:20 UTC Tender Wang <[email protected]> Typos in the comment for the estimate_multivariate_ndistinct() 2025-04-14 13:34 UTC Tender Wang <[email protected]> Re: MergeJoin beats HashJoin in the case of multiple hash clauses 2025-04-14 06:17 UTC Tender Wang <[email protected]> Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c 2025-04-10 08:44 UTC Tender Wang <[email protected]> Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c 2025-04-09 11:51 UTC Tender Wang <[email protected]> Re: Removing unneeded self joins 2025-04-06 13:09 UTC Tender Wang <[email protected]> Re: Removing unneeded self joins 2025-04-06 11:42 UTC Tender Wang <[email protected]> Re: Removing unneeded self joins 2025-04-06 04:02 UTC Tender Wang <[email protected]> Re: bug when apply fast default mechanism for adding new column over domain with default value 2025-04-02 15:24 UTC Tender Wang <[email protected]> Re: bug when apply fast default mechanism for adding new column over domain with default value 2025-04-02 02:01 UTC Tender Wang <[email protected]> Re: [PATCH] Fix potential overflow in binary search mid calculation 2025-04-01 01:42 UTC Tender Wang <[email protected]> Re: Typo in comment for pgstat_database_flush_cb() 2025-03-30 11:31 UTC Tender Wang <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-03-26 06:06 UTC Tender Wang <[email protected]> Re: Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c 2025-03-25 11:07 UTC Tender Wang <[email protected]> Re: Add semi-join pushdown to postgres_fdw 2025-03-25 07:04 UTC Tender Wang <[email protected]> Re: Add mention in docs about locking all partitions for generic plans 2025-03-24 09:19 UTC Tender Wang <[email protected]> Re: Add mention in docs about locking all partitions for generic plans 2025-03-24 06:50 UTC Tender Wang <[email protected]> Re: Question about duplicate JSONTYPE_JSON check 2025-03-12 01:00 UTC Tender Wang <[email protected]> Re: Anti join confusion 2025-03-03 07:57 UTC Tender Wang <[email protected]> Re: Anti join confusion 2025-02-26 10:08 UTC Tender Wang <[email protected]> Re: Anti join confusion 2025-02-24 08:00 UTC Tender Wang <[email protected]> Re: Anti join confusion 2025-02-24 03:24 UTC Tender Wang <[email protected]> Re: generic plans and "initial" pruning 2025-02-23 12:46 UTC Tender Wang <[email protected]> Re: generic plans and "initial" pruning 2025-02-22 17:02 UTC Tender Wang <[email protected]> Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic() 2025-02-19 02:47 UTC Tender Wang <[email protected]> Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic() 2025-02-03 14:28 UTC Tender Wang <[email protected]> Re: Adjust tuples estimate for appendrels 2025-01-27 13:40 UTC Tender Wang <[email protected]> Re: Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c 2024-11-29 01:39 UTC Tender Wang <[email protected]> Re: Tweak some codes format in gist.c 2024-11-18 05:36 UTC Tender Wang <[email protected]> Re: Tweak some codes format in gist.c 2024-11-15 10:10 UTC Tender Wang <[email protected]> Tweak some codes format in gist.c 2024-11-15 09:48 UTC Tender Wang <[email protected]> Re: Remove a unnecessary backslash in CopyFrom 2024-11-12 02:58 UTC Tender Wang <[email protected]> Unsafe access BufferDescriptors array in BufferGetLSNAtomic() 2024-11-07 11:07 UTC Tender Wang <[email protected]> Re: Remove an obsolete comment in gistinsert() 2024-11-07 06:27 UTC Tender Wang <[email protected]> Re: Remove an obsolete comment in gistinsert() 2024-11-07 02:57 UTC Tender Wang <[email protected]> Remove an obsolete comment in gistinsert() 2024-11-05 11:48 UTC Tender Wang <[email protected]> Fix a typo in the comment of gistdoinsert() 2024-11-04 14:31 UTC Tender Wang <[email protected]> Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-11-01 07:39 UTC Tender Wang <[email protected]> Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-11-01 02:59 UTC Tender Wang <[email protected]> Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-11-01 02:39 UTC Tender Wang <[email protected]> Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-10-29 06:38 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-28 11:42 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-28 08:45 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-27 11:00 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-25 09:06 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-25 06:51 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-24 15:27 UTC Tender Wang <[email protected]> Re: execute prepared statement passing parameter expression with COLLATE clause 2024-10-24 09:19 UTC Tender Wang <[email protected]> Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-10-24 07:01 UTC Tender Wang <[email protected]> Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-10-24 04:46 UTC Tender Wang <[email protected]> Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-10-24 02:10 UTC Tender Wang <[email protected]> Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 2024-10-23 13:48 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-22 02:56 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-10-21 08:30 UTC Tender Wang <[email protected]> Re: Improve node type forward reference 2024-10-15 09:03 UTC Tender Wang <[email protected]> Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c 2024-10-09 07:26 UTC Tender Wang <[email protected]> Re: not null constraints, again 2024-09-23 06:40 UTC Tender Wang <[email protected]> Re: not null constraints, again 2024-09-20 06:31 UTC Tender Wang <[email protected]> Re: not null constraints, again 2024-09-20 04:14 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2024-09-13 07:48 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2024-09-11 02:52 UTC Tender Wang <[email protected]> Re: not null constraints, again 2024-09-09 09:08 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-09-05 04:56 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2024-09-05 01:40 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2024-09-04 03:48 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-09-03 09:55 UTC Tender Wang <[email protected]> Re: not null constraints, again 2024-09-03 07:17 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-09-03 02:16 UTC Tender Wang <[email protected]> Re: not null constraints, again 2024-09-02 10:33 UTC Tender Wang <[email protected]> Re: not null constraints, again 2024-09-01 05:45 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2024-08-29 03:38 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2024-08-29 03:22 UTC Tender Wang <[email protected]> Re: Eager aggregation, take 3 2024-08-28 03:57 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-08-23 02:44 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-08-22 07:07 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-08-22 03:19 UTC Tender Wang <[email protected]> Re: Small code simplification 2024-08-22 02:55 UTC Tender Wang <[email protected]> Small code simplification 2024-08-21 10:25 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-08-20 02:45 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-08-20 01:51 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-08-08 14:25 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-08-08 02:16 UTC Tender Wang <[email protected]> Re: Fixed small typo in bufpage.h 2024-08-05 02:29 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-07-26 09:08 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-07-23 02:15 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-07-22 05:52 UTC Tender Wang <[email protected]> Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 2024-07-18 06:34 UTC Tender Wang <[email protected]> Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 2024-07-12 02:43 UTC Tender Wang <[email protected]> Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 2024-06-19 02:55 UTC Tender Wang <[email protected]> Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 2024-06-14 03:02 UTC Tender Wang <[email protected]> Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 2024-06-11 08:11 UTC Tender Wang <[email protected]> Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 2024-06-04 10:51 UTC Tender Wang <[email protected]> Re: why memoize is not used for correlated subquery 2024-05-28 07:46 UTC Tender Wang <[email protected]> Re: struct RelOptInfo member relid comments 2024-05-24 03:13 UTC Tender Wang <[email protected]> Re: First draft of PG 17 release notes 2024-05-14 02:22 UTC Tender Wang <[email protected]> Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 2024-04-23 08:59 UTC Tender Wang <[email protected]> Re: Can't find not null constraint, but \d+ shows that 2024-04-19 06:41 UTC Tender Wang <[email protected]> Re: Can't find not null constraint, but \d+ shows that 2024-04-12 06:02 UTC Tender Wang <[email protected]> Re: Can't find not null constraint, but \d+ shows that 2024-04-12 03:26 UTC Tender Wang <[email protected]> Re: Can't find not null constraint, but \d+ shows that 2024-04-11 07:19 UTC Tender Wang <[email protected]> Re: Can't find not null constraint, but \d+ shows that 2024-04-11 02:18 UTC Tender Wang <[email protected]> 200+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox