pgsql-general - February 2013

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Feb. 1, 2013

Thread Author Time
Re: Pg & Tcl - is it dying out? Carlo Stonebanks 05:19
Re: Optimizing query? Pavel Stehule 05:50
Unusually high IO for autovacuum worker Vlad Bailescu 08:14
Re: Unusually high IO for autovacuum worker Pavel Stehule 08:29
Re: Unusually high IO for autovacuum worker Pavan Deolasee 09:01
Re: [GENERAL] Unusually high IO for autovacuum worker Pavan Deolasee 09:37
Deleting 173000 records takes forever, blocks async queries for unrelated records Alexander Farber 09:38
Re: [GENERAL] Unusually high IO for autovacuum worker Pavan Deolasee 09:43
Re: Unusually high IO for autovacuum worker Vlad Bailescu 09:54
Re: naming of wal-archives Neil Worden 10:15
Re Deleting 173000 records takes forever hamann.w 10:22
Re: Deleting 173000 records takes forever, blocks async queries for unrelated records Albe Laurenz 10:38
Re: Deleting 173000 records takes forever, blocks async queries for unrelated records Michal Politowski 10:41
Re: Deleting 173000 records takes forever, blocks async queries for unrelated records Bèrto ëd Sèra 10:53
Re: Unusually high IO for autovacuum worker Pavan Deolasee 11:08
Re: Deleting 173000 records takes forever, blocks async queries for unrelated records Alexander Farber 11:30
Re: Unusually high IO for autovacuum worker Vlad Bailescu 11:49
Re: Deleting 173000 records takes forever, blocks async queries for unrelated records Bèrto ëd Sèra 11:54
Windows documentation Thomas Kellerer 11:55
Re: Unusually high IO for autovacuum worker Pavan Deolasee 12:40
Postgres version number support Martin Gainty 13:16
Re: Unusually high IO for autovacuum worker Kevin Grittner 13:27
Re: Unusually high IO for autovacuum worker Vlad Bailescu 13:40
Re: JDBC connection test with SSL on PG 9.2.1 server Hari Babu 14:06
Re: [JDBC] JDBC connection test with SSL on PG 9.2.1 server Adrian Klaver 14:22
Re: Deleting 173000 records takes forever, blocks async queries for unrelated records Carlo Stonebanks 16:24
ATET, could it be made "more concurrent" ? Sahagian, David 17:50
Re: Parsing COPY ... WITH BINARY Leonardo M. Ramé 19:34

Feb. 2, 2013

Thread Author Time
Re: trouble with upgrade from 9.0 (many schemas and tables) Jeff Janes 01:21
Re: Optimizing query? hamann.w 09:17
Re: Optimizing query? Pavel Stehule 09:25
Re: Optimizing query? Pavel Stehule 10:11
What language is faster, C or PL/PgSQL? Karel Riverón Escobar 15:42
Re: What language is faster, C or PL/PgSQL? Ovnicraft 17:04
Re: What language is faster, C or PL/PgSQL? Carlo Stonebanks 17:36

Feb. 3, 2013

Thread Author Time
Diferences between IN and EXISTS? Edson Richter 02:25
Re: Can LC_TIME affect timestamp input? Jasen Betts 02:58
Re: COPY table to file missing quotation marks Jasen Betts 03:03
Re: finding if a period is multiples of a given interval Jasen Betts 04:08
Re: finding if a period is multiples of a given interval Jasen Betts 04:10
Re: Is there a way to add a detail message in a warning with pl/Python? Jasen Betts 04:26
Re: Diferences between IN and EXISTS? Pavel Stehule 05:06
Re: Diferences between IN and EXISTS? Edson Richter 05:31
Re: Optimizing query? Jasen Betts 05:33
Re: Diferences between IN and EXISTS? Fabrízio de Royes Mello 14:46
Syncing an application cache with xmin Jason Dusek 15:22
Re: Syncing an application cache with xmin Tom Lane 16:09
Re: Syncing an application cache with xmin Jason Dusek 18:21
Using partial index in combination with prepared statement parameters Steven Schlansker 23:37

Feb. 4, 2013

Thread Author Time
Weird explain output wd 04:19
Re: Weird explain output Tom Lane 07:48
Re: Using partial index in combination with prepared statement parameters Tom Lane 07:59
PGAdmin on Windows (yeah, i know!!) and registry/.ini questions David Wooffindin 08:03
Re: Weird explain output wd 08:35
grouping consecutive records Morus Walter 09:34
Re: Diferences between IN and EXISTS? zeljko 09:35
Re: Diferences between IN and EXISTS? Thomas Kellerer 10:13
Re: grouping consecutive records Виктор Егоров 10:14
Re: grouping consecutive records Morus Walter 10:46
WARNING: pgstat wait timeout Jake Stride 11:54
Re: [GENERAL] JDBC connection test with SSL on PG 9.2.1 server Hari Babu 12:46
Re: WARNING: pgstat wait timeout dinesh kumar 13:54
Adding PRIMARY KEY: Table contains duplicated values Alexander Farber 14:17
Re: Adding PRIMARY KEY: Table contains duplicated values Adrian Klaver 14:32
Re: What language is faster, C or PL/PgSQL? Merlin Moncure 14:33
Re: Adding PRIMARY KEY: Table contains duplicated values Alexander Farber 14:36
Re: [JDBC] JDBC connection test with SSL on PG 9.2.1 server Adrian Klaver 14:39
partial time stamp query Kirk Wythers 14:45
Re: Adding PRIMARY KEY: Table contains duplicated values Alexander Farber 14:45
partial time stamp query Kirk Wythers 14:46
Re: partial time stamp query Misa Simic 14:50
Re: Adding PRIMARY KEY: Table contains duplicated values Adrian Klaver 14:55
Re: Adding PRIMARY KEY: Table contains duplicated values Alexander Farber 14:57
Re: Diferences between IN and EXISTS? zeljko 15:03
Re: Adding PRIMARY KEY: Table contains duplicated values Adrian Klaver 15:29
Re: Diferences between IN and EXISTS? Edson Richter 15:52
Re: Adding PRIMARY KEY: Table contains duplicated values Andreas Kretschmer 16:06
Re: Adding PRIMARY KEY: Table contains duplicated values Andreas Kretschmer 16:23
Re: partial time stamp query Kirk Wythers 16:51
Fwd: partial time stamp query Kirk Wythers 16:58
date_trunc to aggregate values? Kirk Wythers 17:18
Re: Adding PRIMARY KEY: Table contains duplicated values Alexander Farber 17:52
DEFERRABLE NOT NULL constraint 📎 Andreas Joseph Krogh 18:48
Options for passing values to triggers? org.postgresql 19:01
Re: Options for passing values to triggers? Pavel Stehule 19:10
Re: Adding PRIMARY KEY: Table contains duplicated values Andreas Kretschmer 19:29
Is it possible to migrate database from Postgresql 8.2 to 9.2 using pg_upgrade? AI Rumman 20:06
Re: partial time stamp query Brent Wood 20:14
Re: Is it possible to migrate database from Postgresql 8.2 to 9.2 using pg_upgrade? Steve Crawford 20:16
Re: partial time stamp query Kirk Wythers 20:46
Passing dynamic parameters to a table-returning function Moshe Jacobson 20:51
Aggregating inet subnets to supernets Sven Ulland 20:53
Re: Options for passing values to triggers? Gurjeet Singh 21:04
Re: PGAdmin on Windows (yeah, i know!!) and registry/.ini questions John R Pierce 21:22
Re: date_trunc to aggregate values? Jason Dusek 21:26
Re: date_trunc to aggregate values? Kirk Wythers 21:37
Re: PGAdmin on Windows (yeah, i know!!) and registry/.ini questions Carlo Stonebanks 21:56
Reverse Engr into erwin Little, Douglas 22:35
Re: Passing dynamic parameters to a table-returning function David Johnston 23:49

Feb. 5, 2013

Thread Author Time
Hot Standby has PANIC: WAL contains references to invalid pages Michael Harris 00:35
Re: Reverse Engr into erwin Edson Richter 00:41
Re: partial time stamp query Misa Simic 01:03
Re: partial time stamp query Moshe Jacobson 01:26
Re: partial time stamp query Kirk Wythers 03:40
Re: What language is faster, C or PL/PgSQL? Bruce Momjian 05:06
Re: What language is faster, C or PL/PgSQL? Carlo Stonebanks 05:51
Re: What language is faster, C or PL/PgSQL? Pavel Stehule 06:56
BUG #7850: left outer join is not working or I didn't contruct the query properly nvardar 07:09
Re: DEFERRABLE NOT NULL constraint Albe Laurenz 08:59
Re: DEFERRABLE NOT NULL constraint 📎 Andreas Joseph Krogh 09:22
Re: partial time stamp query Misa Simic 09:37
Re: DEFERRABLE NOT NULL constraint Darren Duncan 09:39
Re: DEFERRABLE NOT NULL constraint 📎 Andreas Joseph Krogh 09:57
Re: DEFERRABLE NOT NULL constraint Thomas Kellerer 10:04
Re: DEFERRABLE NOT NULL constraint Виктор Егоров 10:11
Re: DEFERRABLE NOT NULL constraint 📎 Andreas Joseph Krogh 10:15
COPY FROM on Windows and accentuated characters in the file path Thierry Hauchard 10:17
Re: DEFERRABLE NOT NULL constraint Alban Hertroys 10:26
Re: DEFERRABLE NOT NULL constraint Thomas Kellerer 10:31
Re: Hot Standby has PANIC: WAL contains references to invalid pages Hari Babu 11:06
Re: COPY FROM on Windows and accentuated characters in the file path Bruce Momjian 11:11
Re: COPY FROM on Windows and accentuated characters in the file path Raghavendra 11:22
Re: DEFERRABLE NOT NULL constraint 📎 Andreas Joseph Krogh 11:41
Re: DEFERRABLE NOT NULL constraint Alban Hertroys 12:32
Re: DEFERRABLE NOT NULL constraint 📎 Andreas Joseph Krogh 12:52
Re: DEFERRABLE NOT NULL constraint Bèrto ëd Sèra 13:12
Re: DEFERRABLE NOT NULL constraint Chris Angelico 13:13
Re: DEFERRABLE NOT NULL constraint Bèrto ëd Sèra 13:20
Re: DEFERRABLE NOT NULL constraint Chris Angelico 13:26
Re: DEFERRABLE NOT NULL constraint Bèrto ëd Sèra 13:31
tablespace directories Bèrto ëd Sèra 13:38
Re: tablespace directories Bèrto ëd Sèra 13:44
Re: DEFERRABLE NOT NULL constraint Albe Laurenz 13:47
Re: DEFERRABLE NOT NULL constraint Bèrto ëd Sèra 13:51
SP-GiST indexing for box types? aasat 14:02
Re: Passing dynamic parameters to a table-returning function Amit Kapila 14:09
Re: COPY table to file missing quotation marks Vick Khera 14:11
Re: DEFERRABLE NOT NULL constraint 📎 Andreas Joseph Krogh 14:24
Re: DEFERRABLE NOT NULL constraint Alban Hertroys 14:25
Re: tablespace directories Albe Laurenz 14:27
Re: tablespace directories Bèrto ëd Sèra 14:33
Re: BUG #7850: left outer join is not working or I didn't contruct the query properly Pavel Stehule 14:45
cleanup of pgsql_tmp directory Robert Klaus 15:50
Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly Amit Kapila 16:06
Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly Alban Hertroys 16:45
.pgpass and root: a problem Shaun Thomas 17:15
Re: Passing dynamic parameters to a table-returning function Moshe Jacobson 17:34
cleanup of pgsql_tmp directory ROBERT KLAUS 17:52
Re: cleanup of pgsql_tmp directory Tom Lane 18:06
Re: cleanup of pgsql_tmp directory Robert Klaus 18:35
Re: .pgpass and root: a problem Scott Marlowe 18:44
Re: .pgpass and root: a problem Joshua D. Drake 18:53
Re: .pgpass and root: a problem Scott Mead 18:57
Re: .pgpass and root: a problem Scott Marlowe 18:57
Re: .pgpass and root: a problem Shaun Thomas 19:07
Re: .pgpass and root: a problem Michael Nolan 19:12
Re: .pgpass and root: a problem Stephen Frost 19:19
Re: .pgpass and root: a problem Scott Marlowe 20:58
Re: .pgpass and root: a problem Shaun Thomas 21:27
Re: .pgpass and root: a problem Stephen Frost 21:40
Re: .pgpass and root: a problem Shaun Thomas 21:58
Re: .pgpass and root: a problem Stephen Frost 22:05

Feb. 6, 2013

Thread Author Time
ERROR: invalid input syntax for integer: "" Ben Madin 04:24
ERROR: invalid input syntax for integer: "" - more confusion Ben Madin 04:38
Re: ERROR: invalid input syntax for integer: "" Adrian Klaver 04:40
Re: ERROR: invalid input syntax for integer: "" - more confusion Adrian Klaver 04:44
Re: .pgpass and root: a problem Jasen Betts 04:51
Re: ERROR: invalid input syntax for integer: "" Ben Madin 04:52
Re: ERROR: invalid input syntax for integer: "" Adrian Klaver 04:52
Re: ERROR: invalid input syntax for integer: "" - more confusion Ben Madin 04:54
Re: ERROR: invalid input syntax for integer: "" Adrian Klaver 04:57
Re: ERROR: invalid input syntax for integer: "" Ben Madin 05:01
Re: DEFERRABLE NOT NULL constraint Jasen Betts 05:05
Re: ERROR: invalid input syntax for integer: "" Adrian Klaver 05:30
Re: ERROR: invalid input syntax for integer: "" Adrian Klaver 05:33
Re: ERROR: invalid input syntax for integer: "" Tom Lane 05:42
Re: ERROR: invalid input syntax for integer: "" Ben Madin 05:46
Re: DEFERRABLE NOT NULL constraint Bèrto ëd Sèra 07:37
Re: DEFERRABLE NOT NULL constraint Jasen Betts 09:01
Re: DEFERRABLE NOT NULL constraint Chris Angelico 09:22
Re: ERROR: invalid input syntax for integer: "" Ben Madin 09:28
REINDEX deadlock - Postgresql -9.1 Anoop K 09:28
"explain analyze" a procedure verbosely - to find which statement in it takes longer Alexander Farber 10:03
Re: "explain analyze" a procedure verbosely - to find which statement in it takes longer Pavel Stehule 10:12
function for setting/getting same timestamp during whole transaction Miroslav Šimulčík 10:19
Re: function for setting/getting same timestamp during whole transaction Misa Simic 10:32
Re: function for setting/getting same timestamp during whole transaction Miroslav Šimulčík 10:39
Re: "explain analyze" a procedure verbosely - to find which statement in it takes longer Alban Hertroys 10:39
Re: function for setting/getting same timestamp during whole transaction Pavel Stehule 10:55
Need help understanding WAL and checkpoints drew_hunt1976 11:01
Re: DEFERRABLE NOT NULL constraint Bèrto ëd Sèra 11:36
Re: DEFERRABLE NOT NULL constraint Chris Angelico 11:56
Re: function for setting/getting same timestamp during whole transaction Craig Ringer 12:06
Re: function for setting/getting same timestamp during whole transaction Miroslav Šimulčík 12:06
Re: Need help understanding WAL and checkpoints Albe Laurenz 12:16
Re: function for setting/getting same timestamp during whole transaction Miroslav Šimulčík 12:26
Re: DEFERRABLE NOT NULL constraint Alban Hertroys 12:31
Re: function for setting/getting same timestamp during whole transaction Pavel Stehule 12:58
Re: Passing dynamic parameters to a table-returning function Moshe Jacobson 14:24
Re: ERROR: invalid input syntax for integer: "" Adrian Klaver 14:59

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28