pgsql-sql since 2013-10-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

Oct. 2, 2013

Thread Author Time
Re: [SQL] DB link from postgres to Oracle; how to query Dbname.tablename? Jayadevan M 07:26
Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename? Albe Laurenz 07:58
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Sergey Klochkov 14:44
Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename? Chris Twombly 17:03

Oct. 3, 2013

Thread Author Time
Re: Help needed with Window function David Johnston 01:06
Re: Help needed with Window function gmb 05:10

Oct. 4, 2013

Thread Author Time
Re: Help needed with Window function Akihiro Okuno 03:08
Unique index VS unique constraint JORGE MALDONADO 16:48
Re: Unique index VS unique constraint [email protected] 17:41
Re: Unique index VS unique constraint Adrian Klaver 19:43
Re: Unique index VS unique constraint Adrian Klaver 19:49
Advice on defining indexes JORGE MALDONADO 21:28
Re: Advice on defining indexes David Johnston 22:09
Re: Advice on defining indexes JORGE MALDONADO 22:23
Re: Unique index VS unique constraint David Johnston 22:38
Re: Advice on defining indexes David Johnston 22:44

Oct. 5, 2013

Thread Author Time
Re: Unique index VS unique constraint Steve Grey 02:20
Re: Unique index VS unique constraint David Johnston 03:42
Re: Unique index VS unique constraint JORGE MALDONADO 22:24

Oct. 6, 2013

Thread Author Time
Re: Unique index VS unique constraint Sergey Konoplev 00:59

Oct. 8, 2013

Thread Author Time
[No subject] Kaleeswaran Velu 16:23
Re: Plugge, Joe R. 16:26
Re: Andreas Kretschmer 16:28
Many to many link tables with history? Craig R. Skinner 17:04

Oct. 9, 2013

Thread Author Time
Question about index/constraint definition in a table JORGE MALDONADO 22:23
Re: Question about index/constraint definition in a table David Johnston 22:31

Oct. 10, 2013

Thread Author Time
Re: Question about index/constraint definition in a table David Johnston 01:11
Re: Kaleeswaran Velu 03:54
generate a range within a view Gary Stainburn 10:26
Re: generate a range within a view Gary Stainburn 11:03
Re: Many to many link tables with history? Craig R. Skinner 20:23
Re: Many to many link tables with history? Dylan Sanders 20:25
Re: Many to many link tables with history? Craig R. Skinner 20:55

Oct. 11, 2013

Thread Author Time
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects luckyjackgao 07:24
Re: [SQL] Comparison semantics of CHAR data type Bruce Momjian 19:44
Re: [SQL] Comparison semantics of CHAR data type Kevin Grittner 20:58

Oct. 14, 2013

Thread Author Time
Re: [SQL] Comparison semantics of CHAR data type Thomas Fanghaenel 17:57

Oct. 16, 2013

Thread Author Time
PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK Craig R. Skinner 12:50
Re: PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK Craig R. Skinner 14:41
Re: [SQL] Comparison semantics of CHAR data type Bruce Momjian 18:17

Oct. 17, 2013

Thread Author Time
Advice - indexing on varchar fields where only last x characters known Gary Stainburn 11:20
Re: Advice - indexing on varchar fields where only last x characters known Jayadevan M 11:35
Re: Advice - indexing on varchar fields where only last x characters known Craig R. Skinner 11:45
Re: Advice - indexing on varchar fields where only last x characters known Gavin Flower 18:27
Re: Advice - indexing on varchar fields where only last x characters known Alvaro Herrera 18:39
Re: Advice - indexing on varchar fields where only last x characters known Gavin Flower 18:43
Re: Advice - indexing on varchar fields where only last x characters known David Johnston 19:16

Oct. 18, 2013

Thread Author Time
Re: Re: Advice - indexing on varchar fields where only last x characters known Gary Stainburn 07:22
Re: Re: Advice - indexing on varchar fields where only last x characters known Craig R. Skinner 11:37
Re: Advice - indexing on varchar fields where only last x characters known David Johnston 13:44

Oct. 21, 2013

Thread Author Time
Re: Re: Advice - indexing on varchar fields where only last x characters known Gary Stainburn 09:52

Oct. 24, 2013

Thread Author Time
Number of days in a tstzrange? Craig R. Skinner 20:46
Re: Number of days in a tstzrange? Jonathan S. Katz 21:00

Oct. 25, 2013

Thread Author Time
index on values stored in a json array Raphael Bauduin 09:17
Re: index on values stored in a json array Jonathan S. Katz 14:21

Oct. 28, 2013

Thread Author Time
Re: index on values stored in a json array Raphael Bauduin 07:30

Oct. 29, 2013

Thread Author Time
sum of until (running balance) and sum of over date range in the same query M. D. 03:42
Re: sum of until (running balance) and sum of over date range in the same query David Johnston 04:17
Re: Number of days in a tstzrange? Craig R. Skinner 11:34
Re: Re: sum of until (running balance) and sum of over date range in the same query M. D. 13:19

Oct. 30, 2013

Thread Author Time
Re: Number of days in a tstzrange? Craig R. Skinner 10:40
Re: Number of days in a tstzrange? Gavin Flower 18:21

Nov. 4, 2013

Thread Author Time
json and aggregate Diway 20:22
Re: json and aggregate David Johnston 20:38
Re: json and aggregate Diway 21:05
Re: json and aggregate David Johnston 21:15

Nov. 8, 2013

Thread Author Time
Query specific table using relative position in search path George Woodring 16:51
How to script inserts where id is needed as fk Michael Schmidt 19:44
Re: How to script inserts where id is needed as fk Jonathan S. Katz 19:48
Re: Query specific table using relative position in search path Sergey Konoplev 20:42
Re: Query specific table using relative position in search path George Woodring 20:57
Re: Query specific table using relative position in search path Sergey Konoplev 21:32

Nov. 9, 2013

Thread Author Time
Find datatype of a column during the backend flow Ishaya Bhatt 15:27
Re: How to script inserts where id is needed as fk Michael Schmidt 20:09
Re: How to script inserts where id is needed as fk Jonathan S. Katz 21:15
Re: How to script inserts where id is needed as fk David Johnston 21:55
Re: How to script inserts where id is needed as fk Michael Schmidt 23:20

Nov. 10, 2013

Thread Author Time
Re: Find datatype of a column during the backend flow Sergey Konoplev 23:40

Nov. 12, 2013

Thread Author Time
Function args: TEXT -vs- VARCHAR? Craig R. Skinner 18:17
Re: Function args: TEXT -vs- VARCHAR? Luca Vernini 18:23

Nov. 13, 2013

Thread Author Time
Re: Function args: TEXT -vs- VARCHAR? Sergey Konoplev 03:07
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 13:03
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 13:05
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 14:17
Re: Function args: TEXT -vs- VARCHAR? Pavel Stehule 14:20
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 14:25
Re: Function args: TEXT -vs- VARCHAR? Adrian Klaver 14:34
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 15:51
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 16:36
Re: Function args: TEXT -vs- VARCHAR? David Johnston 17:14
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 17:51
Re: Function args: TEXT -vs- VARCHAR? David Johnston 17:59
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 18:04
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 18:31

Nov. 14, 2013

Thread Author Time
Re: Function args: TEXT -vs- VARCHAR? Sergey Konoplev 07:41

Nov. 24, 2013

Thread Author Time
Importing MySql dumped db into pgadmin miks87 15:49
Re: Importing MySql dumped db into pgadmin Theodore Petrosky 16:02
Re: Importing MySql dumped db into pgadmin Adrian Klaver 16:08
Re: Importing MySql dumped db into pgadmin miks87 16:11
Re: Importing MySql dumped db into pgadmin miks87 16:21
Re: Importing MySql dumped db into pgadmin Jan Lentfer 16:37
Re: Importing MySql dumped db into pgadmin Adrian Klaver 17:06

Nov. 25, 2013

Thread Author Time
tab delimiter in output Marcin Krawczyk 11:14
Re: tab delimiter in output Ian Lawrence Barwick 11:26
Re: tab delimiter in output Thomas Kellerer 11:42
Re: tab delimiter in output Marcin Krawczyk 12:00
Re: tab delimiter in output Marcin Krawczyk 12:01

Nov. 27, 2013

Thread Author Time
isnumeric(varchar) by psql Emi Lu 21:46
Re: isnumeric(varchar) by psql Venky Kandaswamy 21:54

Dec. 2, 2013

Thread Author Time
Re: tab delimiter in output seikath 09:49

Dec. 5, 2013

Thread Author Time
Re: Results list String to comma separated int David Johnston 03:02
Re: XMLELEMENT produce a lower case of element name David Johnston 03:19

Dec. 11, 2013

Thread Author Time
Scheduled Events Dev Kumkar 11:38
Re: Scheduled Events Dev Kumkar 15:00

Dec. 12, 2013

Thread Author Time
NULLs and composite types Dean Gibson (DB Administrator) 00:19
Re: [GENERAL] Scheduled Events Vick Khera 16:29
Re: NULLs and composite types David Johnston 19:25
Re: NULLs and composite types Dean Gibson (DB Administrator) 21:57
Re: NULLs and composite types Tom Lane 23:57

Dec. 13, 2013

Thread Author Time
Re: NULLs and composite types Dean Gibson (DB Administrator) 04:31

Dec. 16, 2013

Thread Author Time
Query caching (with 8.3) Achilleas Mantzios 10:58
Re: Query caching (with 8.3) Vik Fearing 23:21

Dec. 17, 2013

Thread Author Time
Re: Query caching (with 8.3) Achilleas Mantzios 08:09
Re: Query caching (with 8.3) Vik Fearing 10:32
Re: [ADMIN] Scheduled Events Marcin Krawczyk 12:06
Re: Query caching (with 8.3) Achilleas Mantzios 14:54
Re: Query caching (with 8.3) Gavin Flower 18:37
Re: Query caching (with 8.3) Sergey Konoplev 20:26

Dec. 18, 2013

Thread Author Time
Re: Query caching (with 8.3) Achilleas Mantzios 08:45

Jan. 2, 2014

Thread Author Time
Index on multiple columns VS multiple index Brice André 19:17
Re: Index on multiple columns VS multiple index Jonathan S. Katz 19:22
Re: Index on multiple columns VS multiple index Jonathan S. Katz 19:33
Re: Index on multiple columns VS multiple index Erik Darling 19:41
Re: Index on multiple columns VS multiple index Brice André 19:45
Re: Index on multiple columns VS multiple index Brice André 20:00
Re: Index on multiple columns VS multiple index Jonathan S. Katz 20:05
Re: Index on multiple columns VS multiple index Jonathan S. Katz 20:06
Re: Index on multiple columns VS multiple index Brice André 20:12

Jan. 14, 2014

Thread Author Time
An archiving query - is it safe? Herouth Maoz 11:06
Re: An archiving query - is it safe? Vik Fearing 12:55
Re: An archiving query - is it safe? Herouth Maoz 14:34

Jan. 15, 2014

Thread Author Time
debugging triggers - get original statement? gmb 08:52
Re: debugging triggers - get original statement? Luca Vernini 11:22
Re: debugging triggers - get original statement? gmb 11:30
Re: debugging triggers - get original statement? bricklen 15:25

Jan. 16, 2014

Thread Author Time
about running plpgsqlo.sql minsheng.bai 08:02
Re: about running plpgsqlo.sql Adrian Klaver 15:18

Jan. 22, 2014

Thread Author Time
Deferrable conditional unique constraints Andreas Joseph Krogh 01:34
Re: Deferrable conditional unique constraints Marc Mamin 17:33

Jan. 24, 2014

Thread Author Time
consulting the question about the usage about SSH Tunnel function minsheng.bai 02:06
find all views depend on a schema/table Emi Lu 15:55
Re: find all views depend on a schema/table Tom Lane 16:23
Re: consulting the question about the usage about SSH Tunnel function Adrian Klaver 16:29
Re: consulting the question about the usage about SSH Tunnel function Adrian Klaver 16:48
Re: find all views depend on a schema/table Emi Lu 17:04

Jan. 27, 2014

Thread Author Time
Detecting when field value changes in Foreign Table? bobspero 00:17
How to detect values changed in field of foreign table? Bob Spero 00:20
Re: find all views depend on a schema/table Tim Landscheidt 04:42