pgsql-sql since 2011-01-02 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

Jan. 4, 2011

Thread Author Time
"<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? Bryce Nesbitt 22:29
Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? Michael Glaesemann 22:32
Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? Bryce Nesbitt 22:47
Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? bricklen 23:03

Jan. 5, 2011

Thread Author Time
foreign key question Gary Stainburn 09:53
Re: foreign key question Gary Stainburn 10:40
return records with more than one occurrences Tarsis Lima 14:18
pattern matching with dates? Good, Thomas 19:39
Re: foreign key question Jasen Betts 19:54

Jan. 6, 2011

Thread Author Time
explicit casts Iuri Sampaio 00:24
Re: explicit casts Iuri Sampaio 01:22
Re: explicit casts Adrian Klaver 02:20
Re: explicit casts Adrian Klaver 02:33

Jan. 7, 2011

Thread Author Time
Re: return records with more than one occurrences Jasmin Dizdarevic 10:07
Re: pattern matching with dates? Samuel Gendler 10:44
Re: return records with more than one occurrences Oliveiros d'Azevedo Cristina 11:04
Re: pattern matching with dates? Susanne Ebrecht 12:39
Re: pattern matching with dates? pasman pasmański 14:15
Re: pattern matching with dates? Richard Huxton 16:09

Jan. 8, 2011

Thread Author Time
Re: return records with more than one occurrences Russell Galyon 04:48
Re: pattern matching with dates? Jasen Betts 10:22

Jan. 11, 2011

Thread Author Time
Find NOT NULLs in a group of 20 columns gvim 02:14
Re: Find NOT NULLs in a group of 20 columns Tom Lane 02:45
help needs in converting db2 function in postgresql. Amar Dhole 12:17
Getting top 2 by Category Ozer, Pam 19:00
Re: Getting top 2 by Category Peter Steinheuser 19:51
Re: Getting top 2 by Category Ozer, Pam 19:53
Re: Getting top 2 by Category msi77 20:00
Re: help needs in converting db2 function in postgresql. Filip Rembiałkowski 20:11

Jan. 12, 2011

Thread Author Time
Re: help needs in converting db2 function in postgresql. Amar Dhole 08:18
Implement PostgreSQL full text search - 09:14
INSERT/UPDATE .. RETURNING Protasov Vladimir 12:41
joining one record according to max value George Francis 22:30
Re: joining one record according to max value George Francis 22:39
Re: joining one record according to max value Jasmin Dizdarevic 22:49
Re: joining one record according to max value George Francis 22:53
Re: joining one record according to max value Jasmin Dizdarevic 23:05
Re: joining one record according to max value George Francis 23:38

Jan. 14, 2011

Thread Author Time
why does seq scan instead of index scan 中川　誠貴 08:58
Re: why does seq scan instead of index scan Tom Lane 17:56

Jan. 15, 2011

Thread Author Time
Re: why does seq scan instead of index scan 中川　誠貴 05:19
Re: why does seq scan instead of index scan Dmitriy Igrishin 16:36

Jan. 17, 2011

Thread Author Time
Re: why does seq scan instead of index scan 中川　誠貴 01:25
failing to connect to postgresql with php victor katemana 08:42
Re: failing to connect to postgresql with php Viktor Bojović 08:51
Re: failing to connect to postgresql with php Marcin Mirosław 09:23
Help needed in skipping column for copy command Amar Dhole 13:59
Re: Help needed in skipping column for copy command Adrian Klaver 20:46
Re: Help needed in skipping column for copy command Russell Galyon 21:14

Jan. 18, 2011

Thread Author Time
question about reg. expression andrew1 23:41

Jan. 19, 2011

Thread Author Time
Re: question about reg. expression Samuel Gendler 10:21
Re: question about reg. expression Stephen Belcher 13:17
Re: question about reg. expression Kenneth Marshall 14:18
Re: Getting top 2 by Category Carla 20:11
Re: Getting top 2 by Category Peter Steinheuser 20:59

Jan. 21, 2011

Thread Author Time
Issue with postgres connectivity Arindam Hore 10:45
Re: Issue with postgres connectivity Reinoud van Leeuwen 10:57
Re: Issue with postgres connectivity Arindam Hore 11:17
Re: Issue with postgres connectivity Arindam Hore 11:43
Re: Issue with postgres connectivity Edward W. Rouse 14:47

Jan. 22, 2011

Thread Author Time
Control reached end of trigger procedure without RETURN MoNiLlO 06:32
Re: Issue with postgres connectivity Jasen Betts 08:53
Re: question about reg. expression Jasen Betts 08:59
Control reached end of trigger procedure without RETURN Adelo Herrero Pérez 09:37
Re: Issue with postgres connectivity Arindam Hore 15:40
Re: Issue with postgres connectivity Arindam Hore 15:43

Jan. 24, 2011

Thread Author Time
loosing data in postgres database victor katemana 09:37
Postgres function for full text search - 09:38
Re: loosing data in postgres database Filip Rembiałkowski 09:49
Re: loosing data in postgres database Piotr Czekalski 09:51
Re: Postgres function for full text search Ivan Sergio Borgonovo 10:08

Jan. 25, 2011

Thread Author Time
check files .backup manuel antonio ochoa 00:18
Re: check files .backup Craig Ringer 05:45
Re: check files .backup Scott Marlowe 07:10
Re: Control reached end of trigger procedure without RETURN MoNiLlO 09:27
Re: Control reached end of trigger procedure without RETURN Adelo Herrero 09:33
Re: Control reached end of trigger procedure without RETURN Adelo 09:38
create geometry by lat/long gargdevender74 11:10
Queyring for columns which are exist in table. Santosh Bhujbal (sabhujba) 12:39
Re: Control reached end of trigger procedure without RETURN Tom Lane 15:06
Re: Control reached end of trigger procedure without RETURN MoNiLlO 15:21
Re: Control reached end of trigger procedure without RETURN MoNiLlO 15:22
Re: Control reached end of trigger procedure without RETURN Adelo 15:24
control function pgsql with script bash manuel antonio ochoa 16:46
Re: create geometry by lat/long Joshua Tolley 17:02
Re: control function pgsql with script bash Joshua Tolley 17:05
Benchmarking manuel antonio ochoa 17:39
Re: Benchmarking Scott Marlowe 18:20

Jan. 26, 2011

Thread Author Time
pgbench tools manuel antonio ochoa 00:34
Re: Queyring for columns which are exist in table. msi77 07:17
how to get row number in select query Emi Lu 16:11
Re: how to get row number in select query Oliveiros d'Azevedo Cristina 16:40
Re: how to get row number in select query Oliveiros d'Azevedo Cristina 17:02
Compare the resulta of a count sql into bash manuel antonio ochoa 17:07

Jan. 27, 2011

Thread Author Time
Re: check files .backup Craig Ringer 00:11
Re: Compare the resulta of a count sql into bash Josh Kupershmidt 04:49
Re: Compare the resulta of a count sql into bash Scott Marlowe 06:11
Queyring for columns which are exist in table. Santosh Bhujbal (sabhujba) 07:52
Re: Queyring for columns which are exist in table. Thom Brown 09:38
Re: Queyring for columns which are exist in table. Santosh Bhujbal (sabhujba) 09:53
Re: Queyring for columns which are exist in table. Thom Brown 10:08
Re: Compare the resulta of a count sql into bash Jasen Betts 10:20
Re: Queyring for columns which are exist in table. Sim Zacks 10:56
Re: Queyring for columns which are exist in table. Sim Zacks 14:15
Re: how to get row number in select query Emi Lu 14:32
Re: how to get row number in select query Oliveiros d'Azevedo Cristina 15:02
Re: how to get row number in select query Piotr Czekalski 15:21
Re: how to get row number in select query Thomas Kellerer 15:30
Automating PostgreSql table partition using triggers Amitabh Kant 17:50
Re: Automating PostgreSql table partition using triggers Amitabh Kant 17:52
Re: Automating PostgreSql table partition using triggers Viktor Bojović 21:10
Re: Automating PostgreSql table partition using triggers Scott Marlowe 21:27

Jan. 28, 2011

Thread Author Time
Re: Automating PostgreSql table partition using triggers Amitabh Kant 02:41
Re: Automating PostgreSql table partition using triggers Amitabh Kant 02:47
aggregation of setof Andreas Gaab 11:42

Jan. 29, 2011

Thread Author Time
something simple but I can't John Fabiani 01:16
Re: something simple but I can't Jasen Betts 03:46
Re: something simple but I can't John Fabiani 15:14

Jan. 31, 2011

Thread Author Time
Re: aggregation of setof Andreas Gaab 08:52
Re: aggregation of setof Pavel Stehule 09:23
Re: aggregation of setof Andreas Gaab 10:22
fix uuid contrib module for Windows 64 Michael Gould 13:40
Re: aggregation of setof Tom Lane 15:32
Re: aggregation of setof Viktor Bojović 15:37
Get days between two dates? Emi Lu 15:50
Re: Get days between two dates? Tovo J. RABEMANANTSOA 16:29
Re: Get days between two dates? Oliveiros d'Azevedo Cristina 16:33
Re: Get days between two dates? Emi Lu 16:36
Re: Get days between two dates? Kenneth Marshall 16:39
Re: how to get row number in select query Emi Lu 16:39
Re: Get days between two dates? Oliveiros d'Azevedo Cristina 16:51

Feb. 1, 2011

Thread Author Time
TABLE PARTITION NEVIN ALEX 13:31
Re: fix uuid contrib module for Windows 64 Hiroshi Saito 15:49

Feb. 2, 2011

Thread Author Time
How to checking the existance of constraints for a table? creationw 20:40
How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1? creationw 22:21

Feb. 3, 2011

Thread Author Time
Transaction-specific global variable Florian Weimer 09:10
out of shared memory - find temporary tables Sabin Coanda 10:52
how control update rows Sabin Coanda 11:01
UNIQUE on everything except primary key gvim 15:44
Re: UNIQUE on everything except primary key Andreas Gaab 15:48
Re: Transaction-specific global variable Tom Lane 16:31
using of select (myfunction()).* is so slow Gerardo Herzig 18:40
Re: using of select (myfunction()).* is so slow Pavel Stehule 19:47

Feb. 4, 2011

Thread Author Time
Re: UNIQUE on everything except primary key msi77 07:02
Re: how control update rows Pavel Stehule 07:18
Re: How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1? Viktor Bojović 08:33
Re: using of select (myfunction()).* is so slow Gerardo Herzig 10:51
Re: using of select (myfunction()).* is so slow Pavel Stehule 11:17
Re: using of select (myfunction()).* is so slow Gerardo Herzig 12:05
Re: How to checking the existance of constraints for a table? bricklen 16:38

Feb. 5, 2011

Thread Author Time
PosgreSQL - TSQL2 question Sarbu Anca 22:26

Feb. 6, 2011

Thread Author Time
Re: TABLE PARTITION Vibhor Kumar 12:10

Feb. 7, 2011

Thread Author Time
Re: PosgreSQL - TSQL2 question Craig Ringer 03:12
Cumulative result with increment Shawn Tayler 21:11
Re: Cumulative result with increment Steve Crawford 22:13

Feb. 8, 2011

Thread Author Time
why SELECT query needs relationname (schemaName.tableName) Amar Dhole 06:56
Re: why SELECT query needs relationname (schemaName.tableName) Samuel Gendler 07:16
UTF characters compromising data import. Gavin Beau Baumanis 10:03
Re: UTF characters compromising data import. Pavel Stehule 10:20
Get postgresql server ip address Gera Mel Handumon 10:28
Re: Get postgresql server ip address Dmitriy Igrishin 14:56
Re: Get postgresql server ip address Chris Browne 15:30
Re: Cumulative result with increment Shawn Tayler 18:09
data import: 12-hour time w/o AM/PM Tarlika Elisabeth Schmitz 18:14
Re: data import: 12-hour time w/o AM/PM Leif Biberg Kristensen 18:25
Re: data import: 12-hour time w/o AM/PM Oliveiros d'Azevedo Cristina 18:38
Re: data import: 12-hour time w/o AM/PM Andrej 19:21
Re: data import: 12-hour time w/o AM/PM Tarlika Elisabeth Schmitz 19:27
"select c1, method(c2) group by c1" returns all values of c2 for c1 Emi Lu 19:35
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Pavel Stehule 19:43
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Peter Steinheuser 19:43
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Rolando Edwards 19:51
Re: data import: 12-hour time w/o AM/PM 📎 Tarlika Elisabeth Schmitz 19:55
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Emi Lu 20:09
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Pavel Stehule 20:14

Feb. 10, 2011

Thread Author Time
DELETE FROM takes forever Josh 17:57
Re: DELETE FROM takes forever Hiltibidal, Rob 18:13
Re: DELETE FROM takes forever Piotr Czekalski 18:36
Re: DELETE FROM takes forever Samuel Gendler 18:37
Re: DELETE FROM takes forever Tom Lane 18:44
Re: DELETE FROM takes forever Chris Browne 18:51
Re: DELETE FROM takes forever Josh 19:15

Feb. 11, 2011

Thread Author Time
Drawing a blank on some SQL Aaron Burnett 18:46
Re: Drawing a blank on some SQL Peter Steinheuser 19:11
Re: Drawing a blank on some SQL Rob Sargent 19:17
Re: Drawing a blank on some SQL Samuel Gendler 19:22
Re: Drawing a blank on some SQL Osvaldo Kussama 20:09
Re: Drawing a blank on some SQL Aaron Burnett 20:47

Feb. 12, 2011

Thread Author Time
Re: Drawing a blank on some SQL Samuel Gendler 00:55
Re: DELETE FROM takes forever Jasen Betts 08:09
Re: UTF characters compromising data import. Jasen Betts 09:15

Feb. 13, 2011

Thread Author Time
Re: UTF characters compromising data import. Gavin Beau Baumanis 11:08

Feb. 14, 2011

Thread Author Time
SQL gotcha Dean Gibson (DB Administrator) 23:29

Feb. 15, 2011

Thread Author Time
Re: SQL gotcha Achilleas Mantzios 07:41
Determine length of numeric field Tony Capobianco 20:48
Re: Determine length of numeric field Pavel Stehule 21:04
Re: Determine length of numeric field Peter Steinheuser 21:08
Re: Determine length of numeric field Tony Capobianco 21:09
Re: Determine length of numeric field Tom Lane 21:10
Re: Determine length of numeric field Tony Capobianco 21:14

Browse Archives

Prev | Next