pgsql-sql before 2012-02-01 00:42

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. 10, 2011

Thread Author Time
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
Re: Wrong query plan when using a left outer join Rosser Schwarz 19:13

Jan. 18, 2012

Thread Author Time
Re: UPDATE COMPATIBILITY Samuel Gendler 07:22
Postgresql Function Rehan Saleem 09:03
PostgreSQL Function Rehan Saleem 09:10
Re: PostgreSQL Function Pavel Stehule 09:25

Jan. 19, 2012

Thread Author Time
date range to set of dates expansion Gary Stainburn 07:13
Re: date range to set of dates expansion hari.fuchs 08:32
how to return whole table from Function not just the id integer column Rehan Saleem 09:57
Re: how to return whole table from Function not just the id integer column Samuel Gendler 10:33
Re: date range to set of dates expansion Gary Stainburn 15:11
Re: date range to set of dates expansion Gary Stainburn 15:16
Re: date range to set of dates expansion Gary Stainburn 15:59
Re: SOLVED - date range to set of dates expansion Gary Stainburn 16:10
Re: date range to set of dates expansion Adrian Klaver 16:20
Re: date range to set of dates expansion Steve Crawford 16:50
Re: date range to set of dates expansion Samuel Gendler 17:17
Re: date range to set of dates expansion Gary Stainburn 17:27
Re: date range to set of dates expansion Adrian Klaver 19:42

Jan. 20, 2012

Thread Author Time
Re: Token separation Jasen Betts 13:29

Jan. 22, 2012

Thread Author Time
How to Return Table From Function Rehan Saleem 13:09
Re: How to Return Table From Function Pavel Stehule 13:53
Re: How to Return Table From Function Rob Sargentg 21:42

Jan. 25, 2012

Thread Author Time
Problem with sequence increment Francisco Calderón 14:12
Re: Problem with sequence increment Brice André 14:31
Re: Problem with sequence increment ktm@rice.edu 14:31

Jan. 26, 2012

Thread Author Time
Query question John Tuliao 12:00
Update Mass Data in Field? Carlos Mennens 23:59

Jan. 27, 2012

Thread Author Time
Re: Update Mass Data in Field? Steve Crawford 00:06
Re: Update Mass Data in Field? David Johnston 00:20
Re: Getting a list of a table's attributes that are sortable sorted by uniqueness Tim Landscheidt 02:13
Re: Query question Lew 19:04

Jan. 30, 2012

Thread Author Time
MS-SQL Store Procedure to Postgresql Function Rehan Saleem 06:42
querying a column w/ timestamp with timezone datatype Anson Abraham 15:00
Re: querying a column w/ timestamp with timezone datatype Steve Crawford 18:09

Jan. 31, 2012

Thread Author Time
pg_dump not correctly saving schema with partitioned tables? chester c young 13:17
must appear in the GROUP BY clause or be used in an aggregate function problem Edward W. Rouse 20:27
Re: must appear in the GROUP BY clause or be used in an aggregate function problem David Johnston 20:48
Re: must appear in the GROUP BY clause or be used in an aggregate function problem Samuel Gendler 20:57
Re: pg_dump not correctly saving schema with partitioned tables? Tom Lane 21:04
Re: must appear in the GROUP BY clause or be used in an aggregate function problem Edward W. Rouse 21:26
Re: must appear in the GROUP BY clause or be used in an aggregate function problem Edward W. Rouse 21:43
Re: must appear in the GROUP BY clause or be used in an aggregate function problem Samuel Gendler 21:51
Re: must appear in the GROUP BY clause or be used in an aggregate function problem Edward W. Rouse 22:13

Browse Archives

Prev | Next