Horton
Menu

Alban Hertroys

haramrae@gmail.com

Email: haramrae@gmail.com
Name: Alban Hertroys
Messages: 584
First message: 2011-09-14
Last message: 2025-12-04

Recent messages

DateSubject
2025-12-04T22:58:17Z Re: Extract only maximum date from column
2025-09-24T20:50:56Z Re: Index rebuilding strategy
2025-08-20T20:14:56Z Re: MS SQL to Postgres
2025-08-20T20:03:52Z Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
2025-08-20T09:41:19Z Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
2024-09-15T11:22:41Z Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-14T10:05:50Z Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-08-15T15:48:10Z Re: Column type modification in big tables
2024-08-11T10:09:44Z Re: Insert works but fails for merge
2024-08-08T18:55:22Z Re: Column type modification in big tables
2024-08-08T18:48:32Z Re: Destination Table - Condition Amount 0
2024-07-31T06:40:24Z Re: Trigger usecase
2024-07-25T12:34:49Z Re: Memory issues with PostgreSQL 15
2024-07-10T06:57:52Z Re: Finding error in long input file
2024-06-19T20:20:45Z Re: Transaction issue
2024-06-14T07:08:51Z Re: Reset sequence to current maximum value of rows
2024-05-31T07:15:54Z Re: Rules and Command Status - update/insert/delete rule with series of commands in action
2024-05-22T18:07:25Z Re: Finding "most recent" using daterange
2024-05-20T09:30:29Z Re: Updating 457 rows in a table
2024-03-22T16:00:43Z Re: could not open file "global/pg_filenode.map": Operation not permitted
2024-03-04T13:04:22Z Re: Inconsistent results in timestamp/interval comparison
2024-02-04T11:19:49Z Re: How to do faster DML
2024-01-11T19:13:23Z Re: Time zone offset in to_char()
2024-01-11T19:04:31Z Re: Time zone offset in to_char()
2023-11-13T19:59:34Z Re: Issue in compiling postgres on latest macOS 14.1.1
2023-10-04T21:10:38Z Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
2023-10-04T19:06:34Z Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
2023-09-11T15:33:56Z Re: Making Sure Primary and Secondary Keys Alligns
2023-09-09T09:33:57Z Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
2023-08-26T10:38:30Z Re: ident auth does not works as usual
2023-07-29T09:37:55Z Re: How to improve the performance of my SQL query？
2023-07-20T06:32:36Z Re: Nu-B here
2023-06-09T06:59:25Z Re: How To: A large [2D] matrix, 100,000+ rows/columns
2023-04-14T08:42:26Z Re: "PANIC: could not open critical system index 2662" - twice
2023-04-09T09:26:16Z Re: [EXTERNAL]: Re: UPSERT in Postgres
2023-03-29T20:15:48Z Re: Using CTID system column as a "temporary" primary key
2023-03-14T08:01:28Z Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause
2023-03-04T10:48:24Z Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
2023-03-03T08:31:03Z Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
2023-02-28T08:10:54Z Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y
2023-02-10T08:14:19Z Re: WHERE col = ANY($1) extended to 2 or more columns?
2023-02-09T16:28:37Z Re: WHERE col = ANY($1) extended to 2 or more columns?
2023-01-17T08:05:00Z Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?
2022-12-11T10:41:06Z Re: Regular expression for lower case to upper case.
2022-12-04T17:05:30Z Re: Stored procedure code no longer stored in v14 and v15, changed behaviour
2022-12-03T11:23:17Z Re: Stored procedure code no longer stored in v14 and v15, changed behaviour
2022-11-19T10:39:43Z Re: Duda sobre como imprimir un campo INTERVAL
2022-10-07T20:31:25Z Re: pg_restore creates public schema?
2022-07-05T07:01:57Z Re: Getting data from a record variable dynamically
2022-06-18T10:28:01Z Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?