Scaling Postgres
Custom Data Types, Row Level Triggers, Dynamic pl/pgsql Columns, citext Usage | Scaling Postgres 162
- Author: Vários
- Narrator: Vários
- Publisher: Podcast
- Duration: 0:10:47
- More information
Informações:
Synopsis
In this episode of Scaling Postgres, we discuss implementing row level triggers, how to return dynamic columns using pl/pgsql, and when to use citext. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://pganalyze.com/blog/custom-postgres-data-types-ruby-rails https://www.cybertec-postgresql.com/en/what-to-return-from-a-postgresql-row-level-trigger/ https://www.depesz.com/2021/04/21/getting-value-from-dynamic-column-in-pl-pgsql-triggers/ https://www.youtube.com/watch?v=iq8sUHYilPk https://www.highgo.ca/2021/04/22/hash-index-internals/ https://www.highgo.ca/2021/04/19/calling-stored-procedure-from-java-part-2/ https://pgsqlpgpool.blogspot.com/2021/04/visibility-with-query-cache.html https://postgresql.life/post/pavlo_golub/