public inbox for [email protected]  
help / color / mirror / Atom feed
Messages from [email protected]

Re: How to escape string in Postgres?
  2026-03-29 08:00 UTC  Pavel Stehule <[email protected]>

Re: Where to store some session based info?
  2026-03-25 17:40 UTC  Pavel Stehule <[email protected]>

Re: LISTAGG à la Oracle in PostgreSQL
  2026-03-10 21:46 UTC  Pavel Stehule <[email protected]>

Re: LISTAGG à la Oracle in PostgreSQL
  2026-03-10 20:23 UTC  Pavel Stehule <[email protected]>

Re: plpgsql: remove a field from a record?
  2025-12-27 16:14 UTC  Pavel Stehule <[email protected]>

Re: Quick questions about postgres name?
  2025-09-23 04:16 UTC  Pavel Stehule <[email protected]>

Re: MVCC and all that...
  2025-09-11 17:55 UTC  Pavel Stehule <[email protected]>

Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
  2025-08-22 15:07 UTC  Pavel Stehule <[email protected]>

Re: CALL and named parameters
  2025-08-07 14:16 UTC  Pavel Stehule <[email protected]>

Re: CALL and named parameters
  2025-08-06 18:08 UTC  Pavel Stehule <[email protected]>

Re: Stored procedures or raw queries
  2025-08-06 12:11 UTC  Pavel Stehule <[email protected]>

Re: Determine server version from psql script
  2025-03-23 19:17 UTC  Pavel Stehule <[email protected]>

Re: size of attributes table is too big
  2025-03-19 17:16 UTC  Pavel Stehule <[email protected]>

Re: Error on the query
  2025-03-04 17:35 UTC  Pavel Stehule <[email protected]>

Re: Logging queries executed by SPI_execute
  2025-02-04 05:06 UTC  Pavel Stehule <[email protected]>

Re: Logging queries executed by SPI_execute
  2025-02-03 05:45 UTC  Pavel Stehule <[email protected]>

Re: search_path for PL/pgSQL functions partially cached?
  2025-01-02 16:20 UTC  Pavel Stehule <[email protected]>

Re: search_path for PL/pgSQL functions partially cached?
  2025-01-02 12:48 UTC  Pavel Stehule <[email protected]>

Re: search_path for PL/pgSQL functions partially cached?
  2025-01-02 11:40 UTC  Pavel Stehule <[email protected]>

Re: search_path for PL/pgSQL functions partially cached?
  2024-12-28 05:34 UTC  Pavel Stehule <[email protected]>

Re: search_path for PL/pgSQL functions partially cached?
  2024-12-27 21:23 UTC  Pavel Stehule <[email protected]>

Re: search_path for PL/pgSQL functions partially cached?
  2024-12-27 20:57 UTC  Pavel Stehule <[email protected]>

Re: Request for new column in pg_namespace
  2024-12-15 17:15 UTC  Pavel Stehule <[email protected]>

Re: PQexecParams and "SET TIME ZONE $1" gets 'syntax error at or near "$1" at character 15'
  2024-11-23 15:57 UTC  Pavel Stehule <[email protected]>

Re: Using Expanded Objects other than Arrays from plpgsql
  2024-11-19 18:44 UTC  Pavel Stehule <[email protected]>

Re: Trouble in generating the plpgsql procedure code
  2024-09-30 10:22 UTC  Pavel Stehule <[email protected]>

Re: Debugging set up for Postgres?
  2024-08-08 17:40 UTC  Pavel Stehule <[email protected]>

Re: Planet Postgres and the curse of AI
  2024-07-17 17:41 UTC  Pavel Stehule <[email protected]>

Re: Detecting PostgreSQL client library
  2024-07-10 16:10 UTC  Pavel Stehule <[email protected]>

Re: Declaring a field that is also an out parameter in a function
  2024-07-07 15:02 UTC  Pavel Stehule <[email protected]>

Re: Declaring a field that is also an out parameter in a function
  2024-07-07 14:58 UTC  Pavel Stehule <[email protected]>

Re: Declaring a field that is also an out parameter in a function
  2024-07-07 14:53 UTC  Pavel Stehule <[email protected]>

Re: Declaring a field that is also an out parameter in a function
  2024-07-07 14:42 UTC  Pavel Stehule <[email protected]>

Re: Declaring a field that is also an out parameter in a function
  2024-07-07 09:13 UTC  Pavel Stehule <[email protected]>

Re: Declaring a field that is also an out parameter in a function
  2024-07-07 07:31 UTC  Pavel Stehule <[email protected]>

Re: Can a long running procedure detect when smart shutdown is pending?
  2024-07-06 06:22 UTC  Pavel Stehule <[email protected]>

Re: Can a long running procedure detect when smart shutdown is pending?
  2024-07-06 06:19 UTC  Pavel Stehule <[email protected]>

Re: Can a long running procedure detect when smart shutdown is pending?
  2024-07-06 05:39 UTC  Pavel Stehule <[email protected]>

Re: search_path and SET ROLE
  2024-05-22 19:40 UTC  Pavel Stehule <[email protected]>

Re: search_path wildcard?
  2024-05-22 19:38 UTC  Pavel Stehule <[email protected]>

Re: search_path wildcard?
  2024-05-22 19:34 UTC  Pavel Stehule <[email protected]>

Re: Need some assistance on stored procedures execution using libpq in C
  2024-04-25 16:49 UTC  Pavel Stehule <[email protected]>

Re: Need some assistance on stored procedures execution using libpq in C
  2024-04-25 14:56 UTC  Pavel Stehule <[email protected]>

Re: PL/pgSQL techniques better than bash for dynamic DO?
  2024-04-09 17:10 UTC  Pavel Stehule <[email protected]>

Re: Pgxs - How to reference another extension
  2024-03-11 14:00 UTC  Pavel Stehule <[email protected]>

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?
  2024-03-07 16:25 UTC  Pavel Stehule <[email protected]>

Re: Fastest way to clone schema ~1000x
  2024-02-26 07:14 UTC  Pavel Stehule <[email protected]>

Re: Fastest way to clone schema ~1000x
  2024-02-26 06:36 UTC  Pavel Stehule <[email protected]>

Re: Nested-Internal Functions
  2024-01-18 12:34 UTC  Pavel Stehule <[email protected]>

Re: Add support for data change delta tables
  2024-01-15 10:40 UTC  Pavel Stehule <[email protected]>

Re: Add support for data change delta tables
  2024-01-15 10:17 UTC  Pavel Stehule <[email protected]>

Re: Add support for data change delta tables
  2024-01-15 10:05 UTC  Pavel Stehule <[email protected]>

Re: Postgres Version Upgrade to 14.1 error
  2022-02-04 06:16 UTC  Pavel Stehule <[email protected]>

Re: psql does not provide proper response
  2022-01-20 18:54 UTC  Pavel Stehule <[email protected]>

Re: plpgsql function problem whith creating temp table - not correctly using search_path ?
  2022-01-11 15:55 UTC  Pavel Stehule <[email protected]>

Re: plpgsql function problem whith creating temp table - not correctly using search_path ?
  2022-01-11 13:27 UTC  Pavel Stehule <[email protected]>

Re: Getting json-value as varchar
  2022-01-06 13:42 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-24 05:35 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-23 06:31 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-23 06:25 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-21 19:04 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-21 18:50 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-20 19:37 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-17 04:08 UTC  Pavel Stehule <[email protected]>

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL
  2021-12-16 21:48 UTC  Pavel Stehule <[email protected]>

Re: pass non-formated query to PL function
  2021-04-02 09:42 UTC  Pavel Stehule <[email protected]>

Re: SELECT is faster on SQL Server
  2021-03-19 11:10 UTC  Pavel Stehule <[email protected]>

Re: SELECT is faster on SQL Server
  2021-03-19 10:00 UTC  Pavel Stehule <[email protected]>

Re: SELECT is faster on SQL Server
  2021-03-19 08:56 UTC  Pavel Stehule <[email protected]>

Re: Stored function RETURNS table, but in some cases columns are missing - should I set them to NULL?
  2021-03-08 19:31 UTC  Pavel Stehule <[email protected]>

Re: Localizing stored functions by replacing placeholders in their body
  2021-03-02 17:00 UTC  Pavel Stehule <[email protected]>

Re: Localizing stored functions by replacing placeholders in their body
  2021-03-02 16:40 UTC  Pavel Stehule <[email protected]>

Re: Catching errors inside a LOOP is causing performance issues
  2017-09-28 13:07 UTC  Pavel Stehule <[email protected]>

Re: Is float8 a reference type?
  2017-09-23 03:28 UTC  Pavel Stehule <[email protected]>

Re: Is float8 a reference type?
  2017-09-23 03:05 UTC  Pavel Stehule <[email protected]>

Re: Dynamic use of RAISE with USING to generate and catch non-hardcoded custom exceptions
  2017-09-22 05:09 UTC  Pavel Stehule <[email protected]>

Re: Dynamic use of RAISE with USING to generate and catch non-hardcoded custom exceptions
  2017-09-22 04:15 UTC  Pavel Stehule <[email protected]>

Re: libpq confusion
  2017-09-20 04:14 UTC  Pavel Stehule <[email protected]>

Re: a JOIN to a VIEW seems slow
  2017-09-14 13:17 UTC  Pavel Stehule <[email protected]>

Re: a JOIN to a VIEW seems slow
  2017-09-14 13:09 UTC  Pavel Stehule <[email protected]>

Re: a JOIN to a VIEW seems slow
  2017-09-14 12:03 UTC  Pavel Stehule <[email protected]>

Re: Joining 16 tables seems slow
  2017-09-12 14:05 UTC  Pavel Stehule <[email protected]>

Re: Joining 16 tables seems slow
  2017-09-12 11:13 UTC  Pavel Stehule <[email protected]>

Re: Joining 16 tables seems slow
  2017-09-12 10:39 UTC  Pavel Stehule <[email protected]>

Re: Joining 16 tables seems slow
  2017-09-12 08:32 UTC  Pavel Stehule <[email protected]>

Re: Joining 16 tables seems slow
  2017-09-12 06:53 UTC  Pavel Stehule <[email protected]>

Re: Long wrapped header lines in psql with expanded mode (9.6.3)
  2017-07-13 14:05 UTC  Pavel Stehule <[email protected]>

Re: Oracle database into PostgreSQL using Ora2PG tool.
  2017-06-02 09:33 UTC  Pavel Stehule <[email protected]>

Re: Oracle database into PostgreSQL using Ora2PG tool.
  2017-06-02 08:43 UTC  Pavel Stehule <[email protected]>

Re: Current best practice for maximum shared_buffers settings on big hardware?
  2017-05-24 13:27 UTC  Pavel Stehule <[email protected]>

Re: Error that shouldn't happen?
  2017-05-18 20:46 UTC  Pavel Stehule <[email protected]>

Re: PSQL command line print speed
  2017-05-17 16:09 UTC  Pavel Stehule <[email protected]>

Re: COPY: row is too big
  2017-01-05 13:19 UTC  Pavel Stehule <[email protected]>

Re: COPY: row is too big
  2017-01-04 15:20 UTC  Pavel Stehule <[email protected]>

Re: COPY: row is too big
  2017-01-04 14:54 UTC  Pavel Stehule <[email protected]>

Re: Book or other resource on Postgres-local code?
  2016-12-30 07:50 UTC  Pavel Stehule <[email protected]>

Re: Performance PLV8 vs PLPGSQL
  2016-12-29 09:35 UTC  Pavel Stehule <[email protected]>

Re: Performance PLV8 vs PLPGSQL
  2016-12-29 09:12 UTC  Pavel Stehule <[email protected]>

Re: Performance PLV8 vs PLPGSQL
  2016-12-29 09:00 UTC  Pavel Stehule <[email protected]>

Re: Indexes and loops
  2016-12-28 16:42 UTC  Pavel Stehule <[email protected]>

Re: LYDB: What advice about stored procedures and other server side code?
  2016-12-28 15:36 UTC  Pavel Stehule <[email protected]>

Re: Performance PLV8 vs PLPGSQL
  2016-12-28 10:04 UTC  Pavel Stehule <[email protected]>

Re: Performance PLV8 vs PLPGSQL
  2016-12-28 09:46 UTC  Pavel Stehule <[email protected]>

Re: Is there a way to Send attachments with email using pgmail postgreSQl?
  2016-12-19 17:36 UTC  Pavel Stehule <[email protected]>

Re: pg_dump and quoted identifiers
  2016-12-13 16:43 UTC  Pavel Stehule <[email protected]>

Re: Importing SQLite database
  2016-12-10 19:50 UTC  Pavel Stehule <[email protected]>

Re: Importing SQLite database
  2016-12-10 19:43 UTC  Pavel Stehule <[email protected]>

Re: Multidimentional array access
  2016-12-09 15:17 UTC  Pavel Stehule <[email protected]>

Re: When to use COMMENT vs --
  2016-12-07 16:04 UTC  Pavel Stehule <[email protected]>

Re: Avoid sorting when doing an array_agg
  2016-12-04 22:22 UTC  Pavel Stehule <[email protected]>

Re: PL/pgSQL debugger
  2016-01-29 21:02 UTC  Pavel Stehule <[email protected]>

Re: Postgres and timezones
  2016-01-20 15:46 UTC  Pavel Stehule <[email protected]>

Re: Postgres and timezones
  2016-01-20 15:34 UTC  Pavel Stehule <[email protected]>

Re: Postgres and timezones
  2016-01-20 13:27 UTC  Pavel Stehule <[email protected]>

Re: Error in Update and Set statement
  2016-01-20 10:47 UTC  Pavel Stehule <[email protected]>

Re: Error in Update and Set statement
  2016-01-20 10:41 UTC  Pavel Stehule <[email protected]>

Re: Dynamic collation support
  2016-01-19 19:15 UTC  Pavel Stehule <[email protected]>

Re: Dynamic collation support
  2016-01-19 15:15 UTC  Pavel Stehule <[email protected]>

Re: Call postgres PL/Python stored function from another PL/Python block.
  2016-01-13 16:48 UTC  Pavel Stehule <[email protected]>

Re: Function error
  2016-01-08 09:58 UTC  Pavel Stehule <[email protected]>

Re: Function error
  2016-01-08 09:24 UTC  Pavel Stehule <[email protected]>

Re: Function error
  2016-01-08 08:04 UTC  Pavel Stehule <[email protected]>

Re: Function error
  2016-01-08 07:35 UTC  Pavel Stehule <[email protected]>

Re: Code of Conduct: Is it time?
  2016-01-06 17:06 UTC  Pavel Stehule <[email protected]>

Re: Code of Conduct: Is it time?
  2016-01-06 16:23 UTC  Pavel Stehule <[email protected]>

Re: Code of Conduct: Is it time?
  2016-01-06 08:51 UTC  Pavel Stehule <[email protected]>

Re: Code of Conduct: Is it time?
  2016-01-06 07:36 UTC  Pavel Stehule <[email protected]>

Re: Question -- Session Operations - Feasibility Of Proposed Synchronization Method?
  2016-01-03 20:43 UTC  Pavel Stehule <[email protected]>

Re: Recurring and non recurring events.
  2015-12-26 08:22 UTC  Pavel Stehule <[email protected]>

 Re: [GENERAL] 回复: [GENERAL] ??: postgres cpu 100% need help
  2015-11-09 11:03 UTC  Pavel Stehule <[email protected]>

Re: Unable to select a table as postgres user
  2015-10-30 07:17 UTC  Pavel Stehule <[email protected]>

Re: Unable to select a table as postgres user
  2015-10-30 06:19 UTC  Pavel Stehule <[email protected]>

Re: A question about PL/pgSQL DECLAREd variable behavior
  2015-10-23 16:24 UTC  Pavel Stehule <[email protected]>

Re: My first PL/pgSQL function
  2015-10-21 15:41 UTC  Pavel Stehule <[email protected]>

Re: My first PL/pgSQL function
  2015-10-21 07:20 UTC  Pavel Stehule <[email protected]>

Re: My first PL/pgSQL function
  2015-10-20 20:37 UTC  Pavel Stehule <[email protected]>

Re: My first PL/pgSQL function
  2015-10-20 15:21 UTC  Pavel Stehule <[email protected]>

Re: md5(large_object_id)
  2015-10-07 11:30 UTC  Pavel Stehule <[email protected]>

Re: "Too far out of the mainstream"
  2012-09-01 15:45 UTC  Pavel Stehule <[email protected]>

Re: "Too far out of the mainstream"
  2012-09-01 15:33 UTC  Pavel Stehule <[email protected]>

Re: calling a C function from pgsql function
  2012-08-29 13:37 UTC  Pavel Stehule <[email protected]>

Re: GRANT SELECT
  2012-08-27 17:35 UTC  Pavel Stehule <[email protected]>

Re: 9.2 and index only scans
  2012-08-27 04:04 UTC  Pavel Stehule <[email protected]>

Re: 9.2 and index only scans
  2012-08-26 19:42 UTC  Pavel Stehule <[email protected]>

Re: FETCH in subqueries or CTEs
  2012-08-24 13:46 UTC  Pavel Stehule <[email protected]>

Re: FETCH in subqueries or CTEs
  2012-08-24 04:34 UTC  Pavel Stehule <[email protected]>

Re: NULL value comparison
  2012-08-22 13:28 UTC  Pavel Stehule <[email protected]>

Re: Are there any options to parallelize queries?
  2012-08-21 09:20 UTC  Pavel Stehule <[email protected]>

Re: Add Metadata to Postgre SQL
  2012-08-14 11:51 UTC  Pavel Stehule <[email protected]>

Re: How to raise error from PostgreSql SQL statement if some condition is met
  2012-08-12 09:12 UTC  Pavel Stehule <[email protected]>

Re: How to raise error from PostgreSql SQL statement if some condition is met
  2012-08-11 20:46 UTC  Pavel Stehule <[email protected]>

Re: Are stored procedures always kept in memory?
  2012-08-07 14:19 UTC  Pavel Stehule <[email protected]>


152+ results

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