pgsql-general - July 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

July 1, 2013

Thread	Author	Time
Re: (Default) Group permissions	David Johnston	00:45
Re: (Default) Group permissions	Andrew Sullivan	01:12
Re: (Default) Group permissions	Michael Orlitzky	01:14
Re: (Default) Group permissions	Michael Orlitzky	01:17
Re: (Default) Group permissions	Michael Orlitzky	01:31
Re: (Default) Group permissions	Andrew Sullivan	01:56
Re: (Default) Group permissions	Albe Laurenz	07:36
Re: Application locking	Albe Laurenz	07:54
Re: Postgres case insensitive searches	Albe Laurenz	08:01
Re: Postgres case insensitive searches	Ingmar Brouns	09:52
Re: Postgres case insensitive searches	Albe Laurenz	11:36
Re: (Default) Group permissions	Michael Orlitzky	13:34
Re: (Default) Group permissions	Michael Orlitzky	13:49
Re: (Default) Group permissions	Andrew Sullivan	14:21
incomplete CTE declaration and "column reference x is ambiguous"	Marc Mamin	14:49
Re: (Default) Group permissions	Michael Orlitzky	15:05
Re: incomplete CTE declaration and "column reference x is ambiguous"	David Johnston	16:04

July 2, 2013

Thread	Author	Time
What is the difference between cmin and cmax	高健	00:42
Re: What is the difference between cmin and cmax	高健	03:19
Re: What is the difference between cmin and cmax	Luca Ferrari	06:15
Re: (Default) Group permissions	Albe Laurenz	07:35
Re: [GENERAL] Floating point error	Abhijit Menon-Sen	08:24
Re: PostgreSQL archiving last replayed WAL after recovery	Daniel Blanco	15:33
Re: [GENERAL] Floating point error	Alvaro Herrera	17:17

July 3, 2013

Thread	Author	Time
Analyzing last run query in psql	Joe Van Dyk	05:05
Re: Analyzing last run query in psql	Andreas Kretschmer	06:20
Re: Analyzing last run query in psql	Luca Ferrari	07:10
Re: Analyzing last run query in psql	Oleg Bartunov	13:43
seq. DEFAULT values and rules	salah jubeh	13:56
Re: seq. DEFAULT values and rules	Tom Lane	14:14
Re: pg_largeobject.sql script not run after upgrade	Stuart Ford	14:59
C User Defined Functions	Jake Silverman	15:07
V8.4 TOAST table problem	Paul Tilles	15:19
How to create a cursor that is independent of transactions and doesn't calculated when created ?	boraldomaster	16:43
Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?	David Johnston	17:02
odd locking behaviour	pg noob	17:30
AWS, cascading replication and WAL archiving	Daniel Serodio (lists)	17:39
Feature Idea: Statement Echo in DO$$	David Johnston	19:32
Cannot connect to remote postgres database	Stephen Carville	20:11
Re: Cannot connect to remote postgres database	Daniel Serodio (lists)	20:30
Re: Memory usage after upgrade to 9.2.4	Daniel Cristian Cruz	20:37
Re: Analyzing last run query in psql	Joe Van Dyk	21:56
Re: Analyzing last run query in psql	Joe Van Dyk	21:58
Re: Cannot connect to remote postgres database	Stephen Carville	22:17
Re: Cannot connect to remote postgres database	Stephen Carville	22:17
async streaming and recovery_target_timeline=latest	Ben Chobot	22:23

July 4, 2013

Thread	Author	Time
Re: (Default) Group permissions	Michael Orlitzky	00:38
Re: Cannot connect to remote postgres database	Pavel Stehule	05:51
Re: Feature Idea: Statement Echo in DO$$	Pavel Stehule	06:05
Re: Cannot connect to remote postgres database	John R Pierce	06:10
Best Table to find Query Logs.	G N	07:51
Can't create plpython language	guxiaobo1982	09:26
Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?	boraldomaster	11:42
Re: odd locking behaviour	Moshe Jacobson	12:40
Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?	David Johnston	14:22
Re: Best Table to find Query Logs.	Adrian Klaver	15:32
Re: Can't create plpython language	Adrian Klaver	15:40
unable to call a function	giozh	15:53
Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?	boraldomaster	16:08
Re: unable to call a function	Moshe Jacobson	16:19
Re: unable to call a function	Adrian Klaver	16:20
Re: unable to call a function	giozh	16:33
Re: unable to call a function	giozh	16:33
Re: unable to call a function	Adrian Klaver	16:40
Re: unable to call a function	giozh	17:14
Re: unable to call a function	Adrian Klaver	17:50
Re: unable to call a function	Adrian Klaver	18:14
Re: unable to call a function	Pavel Stehule	18:19
Re: Cannot connect to remote postgres database	Stephen Carville	19:53
Efficiency of materialized views refresh in 9.3	Joe Van Dyk	21:10
Re: Efficiency of materialized views refresh in 9.3	Michael Paquier	23:22
Re: Can't create plpython language	Michael Paquier	23:29
Re: Can't create plpython language	Jov	23:59

July 5, 2013

Thread	Author	Time
decrease my query duration	David Carpio	00:04
decrease my query duration	David Carpio	00:26
Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?	David Johnston	00:43
Re: decrease my query duration	bricklen	01:04
Re: decrease my query duration	Michael Paquier	01:10
query on query	Jayadevan M	03:09
回复： [GENERAL] Can't create plpython language	guxiaobo1982	05:11
Re: query on query	Luca Ferrari	06:35
Re: query on query	Jayadevan M	07:02
Re: unable to call a function	giozh	07:29
User defined cast creation	Arun P.L	07:34
Re: User defined cast creation	Pavel Stehule	07:40
General Query on Roles - Reg	sramay	08:14
Triggers	itishree sukla	08:29
Reply: Can't create plpython language	guxiaobo1982	09:31
postgresql93-devel-9.3beta2-1PGDG.rhel5.x86_64 missed pg_config	guxiaobo1982	09:47
Re: Triggers	Jov	10:26
How to build postgresql 9.3 beta2 from source with plpython3u handler and postgres_fdw extensions.	guxiaobo1982	10:31
Complex case statement	Greenhorn	11:22
Re: Triggers	itishree sukla	11:37
Re: Triggers	Thomas Kellerer	11:46
"soft lockup" in kernel	Stuart Ford	12:00
Re: query on query	hubert depesz lubaczewski	12:01
Re: Triggers	Thomas Kellerer	12:25
Re: [GENERAL] autoanalyze criteria	Magnus Hagander	13:12
Re: "soft lockup" in kernel	Dennis Jenkins	13:24
Re: unable to call a function	Adrian Klaver	13:31
Re: How to build postgresql 9.3 beta2 from source with plpython3u handler and postgres_fdw extensions.	Adrian Klaver	13:33
Re: How to build postgresql 9.3 beta2 from source withplpython3u handler and postgres_fdw extensions.	guxiaobo1982	13:45
Re: How to build postgresql 9.3 beta2 from source withplpython3u handler and postgres_fdw extensions.	guxiaobo1982	13:48
Re: How to build postgresql 9.3 beta2 from source withplpython3u handler and postgres_fdw extensions.	Adrian Klaver	13:57
Re: "soft lockup" in kernel	Stuart Ford	13:58
Re: decrease my query duration	David Carpio	15:42
Problems installing 9.2 on Ubuntu 12.04	howardnews@selestial.com	16:12
Re: Problems installing 9.2 on Ubuntu 12.04	howardnews@selestial.com	16:29
Re: "soft lockup" in kernel	Dennis Jenkins	16:31
Re: Efficiency of materialized views refresh in 9.3	Joe Van Dyk	17:23
Re: Application locking	Vick Khera	17:48
Re: decrease my query duration	David Johnston	18:51
Re: General Query on Roles - Reg	Ketana Patel	19:16
unsubscribe	Johann Eggers	19:56

July 6, 2013

Thread	Author	Time
Re: casting tsrange to tstzrange doesn't seem to work?	Jeff Davis	01:07
Re: odd locking behaviour	Joe Van Dyk	19:26

July 7, 2013

Thread	Author	Time
Re: incorrect checksum in control file	Ian Turner	03:35
Re: incorrect checksum in control file	Tom Lane	03:39
Re: incorrect checksum in control file	Ian Turner	04:14
Re: unable to call a function	giozh	15:02

July 8, 2013

Thread	Author	Time
Computing count of intersection of two queries (Relational Algebra --> SQL)	Robert James	01:09
Re: Computing count of intersection of two queries (Relational Algebra --> SQL)	David Johnston	01:25
Re: Efficiency of materialized views refresh in 9.3	Kevin Grittner	07:42
Why is NULL = unbounded for rangetypes? 📎	Andreas Joseph Krogh	08:19
backend hangs at sendto() and can't be terminated	Jov	09:31
Re: backend hangs at sendto() and can't be terminated	Bill Mitchell	09:35
Re: backend hangs at sendto() and can't be terminated	Jov	09:46
Re: backend hangs at sendto() and can't be terminated	Bill Mitchell	09:51
Re: backend hangs at sendto() and can't be terminated	Jov	09:56
Re: backend hangs at sendto() and can't be terminated	Merlin Moncure	12:35
Longest Common Subsequence in Postgres - Algorithm Challenge	Robert James	13:09
Re: Longest Common Subsequence in Postgres - Algorithm Challenge	Atri Sharma	13:14
Re: backend hangs at sendto() and can't be terminated	Tom Lane	13:15
Re: backend hangs at sendto() and can't be terminated	Jov	13:48
Re: odd locking behaviour	pg noob	13:54
replication stops working	John DeSoi	14:27
Re: Longest Common Subsequence in Postgres - Algorithm Challenge	hubert depesz lubaczewski	14:45
Re: Why is NULL = unbounded for rangetypes?	Jeff Davis	17:16
domains, case statements, functions: bug?	Joe Van Dyk	17:26
Dump/Reload pg_statistic to cut time from pg_upgrade?	Jerry Sievers	19:20
Dynamically accessing record elements using EXECUTE	Moshe Jacobson	19:49
Re: Longest Common Subsequence in Postgres - Algorithm Challenge	Robert James	20:04
Re: replication stops working	Daniel Serodio (lists)	22:41
Re: Longest Common Subsequence in Postgres - Algorithm Challenge	Michael Paquier	22:46

July 9, 2013

Thread	Author	Time
Force ssl connection	Muhammad Bashir Al-Noimi	00:32
Re: Force ssl connection	Adrian Klaver	00:46
Re: domains, case statements, functions: bug?	Adrian Klaver	00:52
Re: domains, case statements, functions: bug?	Tom Lane	01:58
Re: Longest Common Subsequence in Postgres - Algorithm Challenge	Marcin Mańk	03:42
PERFORM statement	Mike Christensen	04:20
Re: PERFORM statement	Tony Theodore	04:38
Re: PERFORM statement	Mike Christensen	04:45
Re: Longest Common Subsequence in Postgres - Algorithm Challenge	Darren Duncan	08:08
Re: Longest Common Subsequence in Postgres - Algorithm Challenge	Misa Simic	08:15
Re: Why is NULL = unbounded for rangetypes? 📎	Andreas Joseph Krogh	08:45
Support for Foreign keys with arrays	itishree sukla	09:26
My question about autonomous transaction	高健	09:29
Re: PERFORM statement	Raymond O'Donnell	10:20
Re: My question about autonomous transaction	Adrian.Vondendriesch	11:28
Re: [GENERAL] 回复： [GENERAL] Can't create plpython language	Raghavendra	11:30
Re: replication stops working	John DeSoi	13:30
pg 9.2.4 dblink	Peter Kroon	13:55
Re: pg 9.2.4 dblink	Karsten Hilbert	14:03
Re: domains, case statements, functions: bug?	Adrian Klaver	14:37
Re: pg 9.2.4 dblink	Joshua D. Drake	15:26
function with unknown params	giozh	16:30
Re: function with unknown params	Alvaro Herrera	16:49
Re: function with unknown params	Raghavendra	16:50
Re: Force ssl connection	Muhammad Bashir Al-Noimi	17:02
Re: function with unknown params	giozh	17:17
Re: function with unknown params	Mike Christensen	17:31
Re: Force ssl connection	Jeff Janes	17:54
Re: pg 9.2.4 dblink	Merlin Moncure	20:20
Re: Force ssl connection	Muhammad Bashir Al-Noimi	20:55
Re: Force ssl connection	Jeff Janes	21:14
Re: Force ssl connection	Adrian Klaver	21:16
Re: Force ssl connection	Jeff Janes	21:21
plpgsql plan caching allowing invalid data to enter table?	Joe Van Dyk	23:05
Re: plpgsql plan caching allowing invalid data to enter table?	Joe Van Dyk	23:12
Fwd: plpgsql plan caching allowing invalid data to enter table?	Joe Van Dyk	23:21
Re: plpgsql plan caching allowing invalid data to enter table?	Adrian Klaver	23:29
Re: plpgsql plan caching allowing invalid data to enter table?	Joe Van Dyk	23:34
Re: plpgsql plan caching allowing invalid data to enter table?	Tom Lane	23:42

July 10, 2013

Thread	Author	Time
Re: My question about autonomous transaction	高健	01:44
Reply: [GENERAL] 回复： [GENERAL] Can't create plpython language	guxiaobo1982	02:06
Re: Support for Foreign keys with arrays	Michael Paquier	03:46
Re: Support for Foreign keys with arrays	itishree sukla	06:10
Re: Support for Foreign keys with arrays	Michael Paquier	06:14
Removing duplicates	Johann Spies	09:11
Re: Force ssl connection	Muhammad Bashir Al-Noimi	09:59
Re: Force ssl connection	Muhammad Bashir Al-Noimi	10:04
Single Line Query Logging	Emre ÖZTÜRK	10:16
Re: Force ssl connection	Magnus Hagander	10:16
Re: Force ssl connection	Muhammad Bashir Al-Noimi	10:20
Re: Computing count of intersection of two queries (Relational Algebra --> SQL)	Kevin Grittner	12:44
Re: Force ssl connection	Adrian Klaver	13:39
Re: dynamic partitioning 📎	dafNi zaf	14:28
Re: Removing duplicates	Giuseppe Broccolo	15:50
Re: Force ssl connection	Jeff Janes	16:58
Re: function with unknown params	Kevin Grittner	17:21

Browse Archives

Prev | Next