Quick Links

pgsql-sql since 2013-03-21 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

March 21, 2013

Thread	Author	Time
Reading from file without superuser privilege	Jose Antonio Quintana/UPC	11:43
Re: Reading from file without superuser privilege	Adrian Klaver	13:40

March 25, 2013

Thread	Author	Time
From with case	Mauricio Cruz	13:48
Re: From with case	Pavel Stehule	14:01
Re: From with case	Mauricio Cruz	14:38
Re: From with case	Ben Morrow	22:50

March 26, 2013

Thread	Author	Time
Re: From with case	Pavel Stehule	05:33
Re: From with case	Ben Morrow	06:22
Re: From with case	Pavel Stehule	07:44
Re: From with case	Pavel Stehule	08:08
how can I replace all instances of a pattern	James Sharrett	13:08
Re: how can I replace all instances of a pattern	James Sharrett	13:13
Re: how can I replace all instances of a pattern	[email protected]	13:18
Re: how can I replace all instances of a pattern	Steve Crawford	13:22
Re: how can I replace all instances of a pattern	James Sharrett	13:31

April 2, 2013

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

April 4, 2013

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

April 5, 2013

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

April 10, 2013

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

April 11, 2013

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

April 12, 2013

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

April 13, 2013

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

April 16, 2013

Thread	Author	Time
Peer-review requested of soft-delete scheme	Mark Stosberg	16:24
building psycopg2	Thomas Burnett	18:42

April 18, 2013

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

April 19, 2013

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

April 20, 2013

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

April 22, 2013

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

April 23, 2013

Thread	Author	Time
Not Able to Delink the old tables	shabeer ece	08:01

April 25, 2013

Thread	Author	Time
execute	Mauricio Cruz	16:17

April 26, 2013

Thread	Author	Time
Re: execute	Sergey Konoplev	00:21
Re: execute	Jov	00:57

April 27, 2013

Thread	Author	Time
Re: execute	Jasen Betts	06:34

April 30, 2013

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

May 2, 2013

Thread	Author	Time
Re: Correct implementation of 1:n relationship with n>0?	Achilleas Mantzios	07:45

May 6, 2013

Thread	Author	Time
Order of execution	JORGE MALDONADO	00:04
Re: Order of execution	Jasen Betts	09:07

May 7, 2013

Thread	Author	Time
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	handsfree	16:17
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	Bhanu Murthy	17:07

May 8, 2013

Thread	Author	Time
Re: Correct implementation of 1:n relationship with n>0?	Achilleas Mantzios	07:04
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	Albe Laurenz	07:47
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	handsfree	08:35
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	handsfree	08:40
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	Albe Laurenz	09:32

May 13, 2013

Thread	Author	Time
transaction isolationa level - SERIALIZABLE	Marcin Krawczyk	09:22
Re: transaction isolationa level - SERIALIZABLE	Adrian Klaver	14:31
Re: transaction isolationa level - SERIALIZABLE	Marcin Krawczyk	22:25

May 14, 2013

Thread	Author	Time
array_agg() with join question	George Woodring	14:08
Re: array_agg() with join question	Igor Neyman	15:37
Re: Correct implementation of 1:n relationship with n>0?	Wolfgang Keller	18:33
Re: array_agg() with join question	George Woodring	19:38

May 17, 2013

Thread	Author	Time
How to right justify text in psql?	Brian Sherwood	15:26

May 18, 2013

Thread	Author	Time
Re: How to right justify text in psql?	Jov	04:07
Re: How to right justify text in psql?	Ian Lawrence Barwick	05:28

May 23, 2013

Thread	Author	Time
Select statement with except clause	JORGE MALDONADO	18:10
Re: Select statement with except clause	David Johnston	18:36

May 24, 2013

Thread	Author	Time
Re: Select statement with except clause	JORGE MALDONADO	17:26
Re: Select statement with except clause	David Johnston	18:15

May 25, 2013

Thread	Author	Time
reduce many loosely related rows down to one	Bill MacArthur	07:19
DELETE...RETURNING problem with libpq	Brice André	11:07
Re: reduce many loosely related rows down to one	Marc Mamin	11:57
Re: DELETE...RETURNING problem with libpq	Wolfe Whalen	12:00
Re: DELETE...RETURNING problem with libpq	Brice André	12:49
Advice on re-writing a SELECT query.	JORGE MALDONADO	17:17
Re: Advice on re-writing a SELECT query.	Marc Mamin	17:52

May 26, 2013

Thread	Author	Time
Re: DELETE...RETURNING problem with libpq 📎	Guillaume Lelarge	06:51
Re: DELETE...RETURNING problem with libpq 📎	Brice André	18:35

May 27, 2013

Thread	Author	Time
Re: DELETE...RETURNING problem with libpq 📎	Guillaume Lelarge	06:56
Re: DELETE...RETURNING problem with libpq	Brice André	07:06

May 28, 2013

Thread	Author	Time
Re: reduce many loosely related rows down to one	Bill MacArthur	04:09
Re: reduce many loosely related rows down to one	Torsten Grust	15:07
Re: reduce many loosely related rows down to one	Bill MacArthur	20:58

May 29, 2013

Thread	Author	Time
foreign key to multiple tables depending on another column's value	Rodrigo Rosenfeld Rosas	13:58
Re: reduce many loosely related rows down to one	Marc Mamin	15:07
Re: foreign key to multiple tables depending on another column's value	Vick Khera	15:51
Re: [GENERAL] foreign key to multiple tables depending on another column's value	Rodrigo Rosenfeld Rosas	16:14

June 2, 2013

Thread	Author	Time
Correlated Update Query	Robert DiFalco	20:39

June 5, 2013

Thread	Author	Time
Re: crosstab help	Jayadevan	04:24

June 7, 2013

Thread	Author	Time
Advice with an insert query	JORGE MALDONADO	13:58
Re: Advice with an insert query	Andreas Gaab	14:01
Re: Advice with an insert query	Oliver d'Azevedo Cristina	14:06
Re: Advice with an insert query	Thomas Kellerer	14:26

June 13, 2013

Thread	Author	Time
Index Usage and Running Times by FullTextSearch with prefix matching	rawi	11:39
Re: Index Usage and Running Times by FullTextSearch with prefix matching	Tom Lane	14:56
Re: Index Usage and Running Times by FullTextSearch with prefix matching	rawi	15:20
Re: Index Usage and Running Times by FullTextSearch with prefix matching	rawi	15:39
Select clause in JOIN statement	JORGE MALDONADO	22:40
Re: Select clause in JOIN statement	Luca Vernini	23:10

June 14, 2013

Thread	Author	Time
Re: Select clause in JOIN statement 📎	Andreas Joseph Krogh	07:14

June 18, 2013

Thread	Author	Time
apt.postgresql.org vs. Pitti PPA - install error	rawi	10:12
Re: apt.postgresql.org vs. Pitti PPA - install error	basti	10:43
Re: apt.postgresql.org vs. Pitti PPA - install error	rawi	11:31
Re: Index Usage and Running Times by FullTextSearch with prefix matching	rawi	12:49

June 20, 2013

Thread	Author	Time
UNNEST result order vs Array data	gmb	10:40
Re: UNNEST result order vs Array data	Vik Fearing	10:45
Re: UNNEST result order vs Array data	gmb	11:00
Re: UNNEST result order vs Array data	Achilleas Mantzios	11:15
Re: UNNEST result order vs Array data	Richard Huxton	11:37
Re: UNNEST result order vs Array data	Vik Fearing	12:11
Re: UNNEST result order vs Array data	gmb	12:13
Re: UNNEST result order vs Array data	gmb	12:32
Re: UNNEST result order vs Array data	David Johnston	13:34

June 21, 2013

Thread	Author	Time
Re: Index Usage and Running Times by FullTextSearch with prefix matching	rawi	09:31

July 3, 2013

Thread	Author	Time
Unquoted column names fold to lower case	Dev Kumkar	09:12
Re: Unquoted column names fold to lower case	Dev Kumkar	09:16
Re: Unquoted column names fold to lower case	Vik Fearing	09:27
Re: Unquoted column names fold to lower case	Dev Kumkar	11:25
Re: Unquoted column names fold to lower case	Theodore Petrosky	13:41
Re: Unquoted column names fold to lower case	Thomas Kellerer	14:16
Re: Unquoted column names fold to lower case	Bruce Momjian	15:24
Re: Unquoted column names fold to lower case	Dev Kumkar	15:32
Re: Unquoted column names fold to lower case	Bruce Momjian	15:35
Re: Unquoted column names fold to lower case	Dev Kumkar	15:50
Re: Unquoted column names fold to lower case	Thomas Kellerer	16:05
Re: Unquoted column names fold to lower case	Tom Lane	16:20
Re: Unquoted column names fold to lower case	Bruce Momjian	16:27
Re: Unquoted column names fold to lower case	Dev Kumkar	18:46
Re: Unquoted column names fold to lower case	Dev Kumkar	18:49
Re: Unquoted column names fold to lower case	Alvaro Herrera	19:08
Re: Unquoted column names fold to lower case	Dev Kumkar	19:42
Re: Unquoted column names fold to lower case	Tom Lane	19:47
Re: Unquoted column names fold to lower case	Bruce Momjian	20:06
Re: Unquoted column names fold to lower case	Dev Kumkar	20:30
Re: Unquoted column names fold to lower case	Dev Kumkar	21:01
Re: Unquoted column names fold to lower case	Bruce Momjian	23:29

July 8, 2013

Thread	Author	Time
monthly statistics	Andreas	12:18
Update a composite nested type variable	Luca Vernini	13:11
Re: Update a composite nested type variable	David Johnston	19:01
Re: Update a composite nested type variable	Luca Vernini	19:44
Re: Update a composite nested type variable	David Johnston	23:25

July 9, 2013

Thread	Author	Time
delete where not in another table	Campbell, Lance	19:25
Re: delete where not in another table	Igor Neyman	20:36

July 11, 2013

Thread	Author	Time
DateDiff() function	Huan Ruan	05:17
Re: DateDiff() function	Gavin Flower	06:18

July 14, 2013

Thread	Author	Time
Re: delete where not in another table	Marc Mamin	07:24

July 16, 2013

Thread	Author	Time
update column based on postgis query on anther table	Stefan Sylla	02:53
Re: update column based on postgis query on anther table	Tom Lane	05:24
Re: update column based on postgis query on anther table	ssylla	07:57
Re: update column based on postgis query on anther table	Igor Neyman	13:45
Re: SOLVED: update column based on postgis query on anther table	Stefan Sylla	14:27

July 17, 2013

Thread	Author	Time
Re: update column based on postgis query on anther table	Gulcin Yildirim	09:58
Listing table definitions by only one command	Carla Goncalves	15:29
Re: Listing table definitions by only one command	Wes James	16:07

July 18, 2013

Thread	Author	Time
Re: Listing table definitions by only one command	Giuseppe Broccolo	16:39

July 21, 2013

Thread	Author	Time
Mag Gam	Mag Gam	06:22

July 22, 2013

Thread	Author	Time
table constraint on two columns	ldrlj1	14:05
Re: table constraint on two columns	Vik Fearing	14:16
Re: table constraint on two columns	Adrian Klaver	14:44
Re: table constraint on two columns	ldrlj1	14:53

July 23, 2013

Thread	Author	Time
Advice on key design	JORGE MALDONADO	21:44
Re: Advice on key design	Anton Gavazuk	22:02
Re: Advice on key design	JORGE MALDONADO	22:28

July 24, 2013

Thread	Author	Time
Re: Advice on key design	Anton Gavazuk	08:16
Re: Advice on key design	Stanley Hui	08:23
Re: Advice on key design	Bèrto ëd Sèra	08:38
Re: Advice on key design	Luca Ferrari	09:39

Browse Archives

Prev | Next