pgsql-sql since 2011-12-30 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. 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 [email protected] 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

Feb. 1, 2012

Thread Author Time
Fw: Re: pg_dump not correctly saving schema with partitioned tables? chester c young 00:42
Display Length Between Var & Varchar Carlos Mennens 04:08
Re: Display Length Between Var & Varchar Adrian Klaver 04:13
Re: Fw: Re: [SQL] pg_dump not correctly saving schema with partitioned tables? Tom Lane 04:47
Re: MS-SQL Store Procedure to Postgresql Function Jasen Betts 10:52

Feb. 2, 2012

Thread Author Time
Multiple tables query on Mapserver tiplip 05:16
Re: Multiple tables query on Mapserver David Johnston 05:22
Re: Multiple tables query on Mapserver tiplip 05:32
Re: Multiple tables query on Mapserver David Johnston 05:45
Re: Multiple tables query on Mapserver tiplip 07:58
Re: MS-SQL Store Procedure to Postgresql Function F. BROUARD / SQLpro 21:00
Re: MS-SQL Store Procedure to Postgresql Function Pavel Stehule 21:20

Feb. 3, 2012

Thread Author Time
array dimensions, pg_catalog.pg_attribute and the \d command Achilleas Mantzios 15:41
Re: array dimensions, pg_catalog.pg_attribute and the \d command Dmitriy Igrishin 20:21

Feb. 5, 2012

Thread Author Time
Is there a way to remove every character but numbers? Andreas 13:47
Re: Is there a way to remove every character but numbers? Viktor Bojović 13:56

Feb. 6, 2012

Thread Author Time
type cast about int to bit zoulx1982 06:11
Re: array dimensions, pg_catalog.pg_attribute and the \d command Achilleas Mantzios 08:42
Re: type cast about int to bit Jasen Betts 11:05

Feb. 7, 2012

Thread Author Time
Re: type cast about int to bit Adrian Klaver 01:19
Re: type cast about int to bit Adrian Klaver 03:28
problem with nested dblink function Bear 14:00

Feb. 8, 2012

Thread Author Time
update multiple columns with multiple values ssylla 07:39
Re: problem with nested dblink function Bear 07:48
Concurrent Reindex on Primary Key for large table rverghese 18:07
Re: Concurrent Reindex on Primary Key for large table Thomas Kellerer 18:28
time interval math Edward W. Rouse 20:01
Re: time interval math Steve Crawford 20:25
Re: time interval math Edward W. Rouse 20:49

Feb. 9, 2012

Thread Author Time
Re: time interval math Tim Landscheidt 01:51
update column ssylla 01:58
update column with multiple values ssylla 02:31
Re: time interval math Jasen Betts 11:36
Re: time interval math Edward W. Rouse 14:31
Re: Concurrent Reindex on Primary Key for large table rverghese 17:48

Feb. 10, 2012

Thread Author Time
Re: Concurrent Reindex on Primary Key for large table Igor Neyman 14:41
Re: update column Oliveiros d'Azevedo Cristina 15:33
Re: update column with multiple values David Johnston 16:08

Feb. 11, 2012

Thread Author Time
Re: time interval math Jasen Betts 03:18
Calling Postgresql Function to delete user data Rehan Saleem 19:53

Feb. 12, 2012

Thread Author Time
Re: Calling Postgresql Function to delete user data Philip Couling 13:02

Feb. 13, 2012

Thread Author Time
foreign key is it a real key John Fabiani 15:46
Re: foreign key is it a real key Andreas Kretschmer 15:50
Re: foreign key is it a real key John Fabiani 17:30

Feb. 16, 2012

Thread Author Time
need help with import Andreas 01:02
Re: need help with import David Johnston 01:13
Re: need help with import Andreas 02:05
Re: need help with import David Johnston 02:41
Re: need help with import Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 02:55
pg_dump - 8.3 - schemas Edward W. Rouse 18:59
Re: pg_dump - 8.3 - schemas Adrian Klaver 19:21
Re: pg_dump - 8.3 - schemas Edward W. Rouse 19:31
Re: pg_dump - 8.3 - schemas Adrian Klaver 19:38
Re: pg_dump - 8.3 - schemas Edward W. Rouse 20:17
Re: pg_dump - 8.3 - schemas Adrian Klaver 20:22

Feb. 17, 2012

Thread Author Time
Window function frame clause vpapavas 01:01

Browse Archives

Prev | Next