pgsql-sql since 2011-12-01 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

Dec. 1, 2011

Thread Author Time
running totals with end of month line 📎 M. D. 01:03
Re: running totals with end of month line David Johnston 01:12
Re: plpgsql: how to get the exception's detail information? Filip Rembiałkowski 12:07

Dec. 6, 2011

Thread Author Time
Self-Join 📎 Abhinandan Raghavan 13:57
Re: Self-Join Bèrto ëd Sèra 14:04
Re: Self-Join Oliveiros d'Azevedo Cristina 14:39
Re: Self-Join Scott Swank 17:17
Re: Self-Join Oliveiros d'Azevedo Cristina 17:32
Re: Self-Join Scott Swank 18:14
Re: Self-Join Bèrto ëd Sèra 18:58

Dec. 7, 2011

Thread Author Time
No response from the backend feng.zhou 11:27
Re: No response from the backend Craig Ringer 13:25
Correlating Asterisk CDRs Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 14:34
Re: Correlating Asterisk CDRs 📎 Julien Cigar 14:40
Re: Correlating Asterisk CDRs Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 15:14
Re: Correlating Asterisk CDRs 📎 Julien Cigar 15:25
[SOLVED] Re: Correlating Asterisk CDRs Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 15:32
Re: Correlating Asterisk CDRs Brent Dombrowski 17:13
Re: Correlating Asterisk CDRs Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 17:34
Re: Correlating Asterisk CDRs Scott Marlowe 20:15
prepared statements Vad N 23:04

Dec. 8, 2011

Thread Author Time
Re: Re: [SQL] No response from the backend feng.zhou 01:38
Re: Correlating Asterisk CDRs Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 02:28
Re: No response from the backend Craig Ringer 04:11
Re: Re: [SQL] No response from the backend feng.zhou 04:18
Question on imports with foreign keys Andreas 06:48
Re: prepared statements Pavel Stehule 07:40
Re: Question on imports with foreign keys Emre Hasegeli 08:39
Re: Question on imports with foreign keys Andreas 10:10
partitions versus databases chester c young 14:26
Re: prepared statements David Johnston 14:42

Dec. 9, 2011

Thread Author Time
Re: partitions versus databases Craig Ringer 01:13
Query Timeout Question feng.zhou 01:44
Re: Query Timeout Question feng.zhou 01:58
Re: Query Timeout Question Craig Ringer 02:27
Re: Re: [SQL] Query Timeout Question feng.zhou 02:51
Re: Question on imports with foreign keys Emre Hasegeli 09:39

Dec. 10, 2011

Thread Author Time
conditional FROM Richard Klingler 16:03
Re: conditional FROM Andreas Kretschmer 16:17
Re: conditional FROM David Johnston 16:28
Re: conditional FROM Richard Klingler 17:22
Re: conditional FROM Andreas Kretschmer 17:30
Re: conditional FROM Bèrto ëd Sèra 17:39
Subselects to Joins? Or: how to design phone calls database Mario Splivalo 22:24
Re: conditional FROM Jasen Betts 22:32
Re: partitions versus databases Jasen Betts 22:42
Re: Subselects to Joins? Or: how to design phone calls database Viktor Bojović 22:51
Re: Question on imports with foreign keys Jasen Betts 23:01

Dec. 12, 2011

Thread Author Time
Re: Subselects to Joins? Or: how to design phone calls database Misa Simic 09:36

Dec. 14, 2011

Thread Author Time
JDBC Statement.setQueryTimeout : is there plan to implement this? Sylvain Mougenot 13:29
Re: JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 13:42
Re: JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 14:01
Re: JDBC Statement.setQueryTimeout : is there plan to implement this? Sylvain Mougenot 15:30
Re: JDBC Statement.setQueryTimeout : is there plan to implement this? David Fetter 16:13

Dec. 15, 2011

Thread Author Time
Re: JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 00:50
Re: JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 03:25
Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 03:26
Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 04:45
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Віталій Тимчишин 08:11
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Dave Cramer 11:21
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Radosław Smogura 11:29
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 14:02
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Dave Cramer 14:17
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Steven Schlansker 17:38
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Radosław Smogura 20:48
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Radosław Smogura 20:49

Dec. 16, 2011

Thread Author Time
Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? Craig Ringer 03:57
using a generated series in function John Fabiani 04:16
Re: using a generated series in function David Johnston 04:56
Re: using a generated series in function Misa Simic 09:30
Re: using a generated series in function John Fabiani 10:46
Re: using a generated series in function John Fabiani 11:56
Re: using a generated series in function Misa Simic 11:59
Re: using a generated series in function Misa Simic 12:08
Re: using a generated series in function Adrian Klaver 15:31

Dec. 17, 2011

Thread Author Time
Column "..." does not exist (view + union) Stefan Weiss 02:57
Re: Column "..." does not exist (view + union) Andreas Kretschmer 09:02
Natural sort order Richard Klingler 10:33
Re: Column "..." does not exist (view + union) Stefan Weiss 14:26
Re: Natural sort order Filip Rembiałkowski 15:16
Re: using a generated series in function John Fabiani 16:50
Re: using a generated series in function Adrian Klaver 18:09
Re: using a generated series in function David Johnston 18:10
Re: Column "..." does not exist (view + union) Bèrto ëd Sèra 21:36
Re: using a generated series in function Bèrto ëd Sèra 21:49
Re: Column "..." does not exist (view + union) Stefan Weiss 22:21
Re: Column "..." does not exist (view + union) Bèrto ëd Sèra 23:15
Re: Column "..." does not exist (view + union) Adrian Klaver 23:38

Dec. 18, 2011

Thread Author Time
Re: Column "..." does not exist (view + union) Brent Dombrowski 02:58

Dec. 19, 2011

Thread Author Time
Problem with tables and columns names Gabriel Filipiak 08:16
Re: Problem with tables and columns names Andreas Kretschmer 08:26
Re: Problem with tables and columns names Samuel Gendler 10:34

Dec. 27, 2011

Thread Author Time
Call a external app on postgreSQL start-up (windows) Maurício Cruz 11:45
Re: Call a external app on postgreSQL start-up (windows) Filip Rembiałkowski 12:14
Re: Call a external app on postgreSQL start-up (windows) Filip Rembiałkowski 13:26

Dec. 29, 2011

Thread Author Time
internal format of timstamp? Lars Gustafsson 15:08
Re: internal format of timstamp? Jasen Betts 20:42
Re: internal format of timstamp? Brent Dombrowski 21:42
Re: internal format of timstamp? Steve Crawford 22:20

Dec. 30, 2011

Thread Author Time
Getting a list of a table's attributes that are sortable sorted by uniqueness Tim Landscheidt 01:07
Current transaction is aborted, commands ignored until end of transaction block Jan Bakuwel 04:25
Re: Current transaction is aborted, commands ignored until end of transaction block David Johnston 04:44
Re: Current transaction is aborted, commands ignored until end of transaction block Jan Bakuwel 08:43
Re: Current transaction is aborted, commands ignored until end of transaction block Leif Biberg Kristensen 09:44
Re: Current transaction is aborted, commands ignored until end of transaction block Thomas Kellerer 11:03
Re: Re: Current transaction is aborted, commands ignored until end of transaction block Marcin Mirosław 11:07
Re: Current transaction is aborted, commands ignored until end of transaction block Thomas Kellerer 11:18
Re: Current transaction is aborted, commands ignored until end of transaction block Leif Biberg Kristensen 11:25
avoid the creating the type for setof John Fabiani 14:26
Re: avoid the creating the type for setof Thomas Kellerer 14:48
Re: avoid the creating the type for setof Adrian Klaver 14:49
Re: avoid the creating the type for setof John Fabiani 15:08
Re: Current transaction is aborted, commands ignored until end of transaction block Jan Bakuwel 22:51
Re: Current transaction is aborted, commands ignored until end of transaction block Tom Lane 23:19

Dec. 31, 2011

Thread Author Time
Re: Current transaction is aborted, commands ignored until end of transaction block Scott Marlowe 00:03
Re: Current transaction is aborted, commands ignored until end of transaction block Samuel Gendler 01:19
Re: Current transaction is aborted, commands ignored until end of transaction block Jan Bakuwel 02:30
Nested custom types: array - unable to insert John Poole 02:53
Re: Nested custom types: array - unable to insert David Johnston 03:31
Re: Nested custom types: array - unable to insert [SOLVED] 📎 John L. Poole 03:47
Re: Current transaction is aborted, commands ignored until end of transaction block Scott Marlowe 06:28
Re: Current transaction is aborted, commands ignored until end of transaction block Misa Simic 11:11

Jan. 1, 2012

Thread Author Time
Re: Current transaction is aborted, commands ignored until end of transaction block Jasen Betts 20:27

Jan. 2, 2012

Thread Author Time
i want small information regarding postgres vinodh chowdary 04:21
Re: i want small information regarding postgres Andreas Kretschmer 08:00
Re: i want small information regarding postgres Erdinc Akkaya 08:07
Re: i want small information regarding postgres Samuel Gendler 10:36
Fwd: i want small information regarding postgres Samuel Gendler 11:44
Re: i want small information regarding postgres Brent Dombrowski 19:13
Re: new user on mac Guillaume Lelarge 22:01

Jan. 3, 2012

Thread Author Time
lo_import Maurício Cruz 12:32
Re: lo_import Tim Landscheidt 18:34
Re: lo_import Jasen Betts 19:17
ignore unique violation OR check row exists rverghese 20:54
Re: ignore unique violation OR check row exists Misa Simic 21:53

Jan. 4, 2012

Thread Author Time
Re: ignore unique violation OR check row exists Jasen Betts 08:58
Re: ignore unique violation OR check row exists Andreas Kretschmer 09:08
Re: ignore unique violation OR check row exists Zdravko Balorda 09:57
Re: ignore unique violation OR check row exists Samuel Gendler 10:09
Re: ignore unique violation OR check row exists Misa Simic 10:23
Re: ignore unique violation OR check row exists Zdravko Balorda 12:33
Re: ignore unique violation OR check row exists rverghese 17:34

Jan. 5, 2012

Thread Author Time
Re: Current transaction is aborted, commands ignored until end of transaction block Feike Steenbergen 06:20
When To Use Quotes Carlos Mennens 13:55
Re: When To Use Quotes Plugge, Joe R. 14:00
Re: Fwd: i want small information regarding postgres Alvaro Herrera 17:52
DECIMAL or NUMERIC Data Types Carlos Mennens 18:38
Re: DECIMAL or NUMERIC Data Types Tom Lane 19:14

Jan. 6, 2012

Thread Author Time
notes on materialized views cc "maco" young 09:17

Jan. 9, 2012

Thread Author Time
compare table names Tony Capobianco 16:12
Re: compare table names Adrian Klaver 16:19
Re: compare table names Tony Capobianco 16:28
Re: compare table names Adrian Klaver 16:33
Re: compare table names Greg Sabino Mullane 16:51
Re: compare table names Steve Crawford 16:58
Re: compare table names Adrian Klaver 16:58

Jan. 10, 2012

Thread Author Time
Re: Fwd: i want small information regarding postgres Tim Landscheidt 17:01

Jan. 11, 2012

Thread Author Time
Re: compare table names Brice André 06:43
Re: compare table names Tony Capobianco 14:29
amount of join's and sequential access to the tables involved Gerardo Herzig 15:36
Re: amount of join's and sequential access to the tables involved Tom Lane 15:40
Re: amount of join's and sequential access to the tables involved Gerardo Herzig 16:06
Re: amount of join's and sequential access to the tables involved Tom Lane 16:14
Unable To Alter Data Type Carlos Mennens 23:52

Jan. 12, 2012

Thread Author Time
Re: Unable To Alter Data Type David Johnston 00:13
Re: Unable To Alter Data Type Carlos Mennens 00:30
Re: Unable To Alter Data Type David Johnston 01:21
Re: amount of join's and sequential access to the tables involved Gerardo Herzig 14:09
Unable To Modify Table Carlos Mennens 16:42
Re: Unable To Modify Table Steve Crawford 16:53
Re: Unable To Modify Table Adrian Klaver 16:54
Re: Unable To Modify Table David Johnston 16:56
Re: Unable To Modify Table David Johnston 17:02
Re: Unable To Modify Table Adrian Klaver 17:10

Jan. 13, 2012

Thread Author Time
Query Problem... Left OuterJoin / Tagging Issue John Tuliao 04:31
Re: Query Problem... Left OuterJoin / Tagging Issue David Johnston 14:26

Jan. 14, 2012

Thread Author Time
Re: Unable To Modify Table Gavin Flower 08:20
sql query problem Alok Thakur 09:18

Jan. 15, 2012

Thread Author Time
Token separation Tim Landscheidt 08:02
Re: Token separation Tom Lane 17:15
Call function with dynamic schema name IlGenna 17:28
Re: Call function with dynamic schema name Pavel Stehule 17:33
Re: Call function with dynamic schema name IlGenna 17:37
Re: Call function with dynamic schema name Pavel Stehule 18:27
Re: sql query problem Oliveiros 21:13
Re: Call function with dynamic schema name Misa Simic 22:36
Re: sql query problem Misa Simic 22:49

Jan. 16, 2012

Thread Author Time
Re: Query Problem... Left OuterJoin / Tagging Issue John Tuliao 08:43
Re: sql query problem Alok Thakur 09:48
Re: Token separation Tim Landscheidt 15:12

Jan. 17, 2012

Thread Author Time
UPDATE COMPATIBILITY Gera Mel Handumon 06:31
Wrong query plan when using a left outer join Feike Steenbergen 06:54
Re: UPDATE COMPATIBILITY Thomas Kellerer 08:49
Re: Wrong query plan when using a left outer join Filip Rembiałkowski 11:53
Re: sql query problem Andreas Kretschmer 13:35
Re: sql query problem David Johnston 14:05
Re: UPDATE COMPATIBILITY Adrian Klaver 15:19
Re: UPDATE COMPATIBILITY Thomas Kellerer 16:28
Re: Wrong query plan when using a left outer join Feike Steenbergen 18:53
Re: Wrong query plan when using a left outer join Feike Steenbergen 18:55

Browse Archives

Prev | Next