Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | David Guyot (English) | 14:29 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | Douglas J Hunley | 14:47 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | David Guyot | 14:53 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | Douglas J Hunley | 16:51 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | Douglas J Hunley | 16:54 |
| Thread | Author | Time |
|---|---|---|
| Postgres trigger issue with update statement in it. | Kaleeswaran Velu | 04:08 |
| Re: Postgres trigger issue with update statement in it. | Wolfe Whalen | 07:28 |
| Re: Postgres trigger issue with update statement in it. | Adrian Klaver | 13:16 |
| Re: Postgres trigger issue with update statement in it. | Kaleeswaran Velu | 17:54 |
| Thread | Author | Time |
|---|---|---|
| Data Loss from SQL SELECT (vs. COPY/pg_dump) | Kong Man | 19:56 |
| Re: Data Loss from SQL SELECT (vs. COPY/pg_dump) | Kong Man | 22:51 |
| Thread | Author | Time |
|---|---|---|
| Encrypting PGBouncer to Postgres DB connections | Bhanu Murthy | 18:06 |
| Re: Encrypting PGBouncer to Postgres DB connections | AJ Weber | 18:15 |
| Re: [SQL] Encrypting PGBouncer to Postgres DB connections | [email protected] | 18:16 |
| Advice for index design | JORGE MALDONADO | 22:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice for index design | Gavin Flower | 00:00 |
| Restrict FOREIGN KEY to a part of the referenced table | Matthias Nagel | 07:55 |
| Slow update with ST_Contians() | androclos | 16:38 |
| Re: Advice for index design | Greg Sabino Mullane | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice for index design | Jasen Betts | 13:29 |
| Re: Restrict FOREIGN KEY to a part of the referenced table | Jasen Betts | 13:53 |
| Re: Restrict FOREIGN KEY to a part of the referenced table | Richard Broersma | 19:52 |
| Clarity on how LOCK interacts with INHERIT | Robins Tharakan | 20:59 |
| Re: Clarity on how LOCK interacts with INHERIT | Simon Riggs | 21:09 |
| pivot query with count | Tony Capobianco | 21:14 |
| Thread | Author | Time |
|---|---|---|
| pivot query with count | Tony Capobianco | 00:28 |
| Re: pivot query with count | David Johnston | 03:26 |
| Re: pivot query with count | David Johnston | 03:29 |
| Re: pivot query with count | Tony Capobianco | 22:05 |
| Thread | Author | Time |
|---|---|---|
| Peer-review requested of soft-delete scheme | Mark Stosberg | 16:24 |
| building psycopg2 | Thomas Burnett | 18:42 |
| Thread | Author | Time |
|---|---|---|
| copy from csv, variable filename within a function | basti | 07:26 |
| Fwd: copy from csv, variable filename within a function | basti | 08:34 |
| ALTER USER abc PASSWORD - what's going on ??? | Marcin Krawczyk | 10:59 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | SEKA Bruno-Emmanuel | 11:19 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | Marcin Krawczyk | 11:21 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | SEKA Bruno-Emmanuel | 11:31 |
| Re: Peer-review requested of soft-delete scheme | Jasen Betts | 11:44 |
| Re: copy from csv, variable filename within a function | bricklen | 13:48 |
| Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help | Sofer, Yuval | 15:41 |
| Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help | Andreas Kretschmer | 16:38 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | Guillaume Lelarge | 18:18 |
| Thread | Author | Time |
|---|---|---|
| SQL query with Overlapping date time ranges | chinnaobi | 03:41 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | Marcin Krawczyk | 08:13 |
| Thread | Author | Time |
|---|---|---|
| Table indexes in a SELECT with JOIN´s | JORGE MALDONADO | 16:32 |
| Re: [SQL] Table indexes in a SELECT with JOIN´s | Pavel Stehule | 16:59 |
| Thread | Author | Time |
|---|---|---|
| check for overlapping time intervals | Wolfgang Meiners | 10:19 |
| Re: check for overlapping time intervals | Thomas Kellerer | 10:36 |
| Re: check for overlapping time intervals | Wolfgang Meiners | 18:06 |
| Thread | Author | Time |
|---|---|---|
| Not Able to Delink the old tables | shabeer ece | 08:01 |
| Thread | Author | Time |
|---|---|---|
| execute | Mauricio Cruz | 16:17 |
| Thread | Author | Time |
|---|---|---|
| Re: execute | Sergey Konoplev | 00:21 |
| Re: execute | Jov | 00:57 |
| Thread | Author | Time |
|---|---|---|
| Re: execute | Jasen Betts | 06:34 |
| Thread | Author | Time |
|---|---|---|
| Correct implementation of 1:n relationship with n>0? | Wolfgang Keller | 14:39 |
| Re: Correct implementation of 1:n relationship with n>0? | Achilleas Mantzios | 15:12 |
| Re: Correct implementation of 1:n relationship with n>0? | Anton Gavazuk | 15:14 |
| Re: Correct implementation of 1:n relationship with n>0? | Misa Simic | 15:35 |
| Re: Correct implementation of 1:n relationship with n>0? | Misa Simic | 16:21 |
| Re: Correct implementation of 1:n relationship with n>0? | Vik Fearing | 16:37 |
| Re: Correct implementation of 1:n relationship with n>0? | Wolfgang Keller | 18:19 |
| Re: Correct implementation of 1:n relationship with n>0? | Wolfgang Keller | 18:25 |
| Re: Correct implementation of 1:n relationship with n>0? | Igor Neyman | 18:43 |