[go: up one dir, main page]

pgsql-general - June 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)

Browse Archives

Prev | Next

June 1, 2013

Thread Author Time
Re: Insert with query Adrian Klaver 00:27
Re: Using a CTE for an update Bosco Rama 04:14
Re: What are ExecSeqMarkPos and ExecSeqRestrPos used for Tom Lane 04:47
Re: Strange behavior of "=" as assignment operator Tom Lane 05:18
Re: Strange behavior of "=" as assignment operator Pavel Stehule 05:50
Re: Strange behavior of "=" as assignment operator David Johnston 06:36
Re: Strange behavior of "=" as assignment operator Pavel Stehule 07:16
Re: Strange behavior of "=" as assignment operator Chris Travers 07:20
Re: Strange behavior of "=" as assignment operator Pavel Stehule 07:23
Re: Strange behavior of "=" as assignment operator David Johnston 09:52
Re: Strange behavior of "=" as assignment operator Chris Travers 10:01
Re: Strange behavior of "=" as assignment operator Pavel Stehule 12:25
Sum raw with the same continuous flags Shenli Zhu 12:43
Re: Sum raw with the same continuous flags Andreas Kretschmer 13:17
Re: Insert with query Kevin Grittner 13:47
Re: Sum raw with the same continuous flags Victor Yegorov 14:27
Re: Strange behavior of "=" as assignment operator David Johnston 14:34
Re: Sum raw with the same continuous flags David Johnston 14:42
Re: Strange behavior of "=" as assignment operator Tom Lane 14:53
Re: Insert with query Adrian Klaver 16:17
Re: Insert with query Kevin Grittner 16:22
Re: Insert with query Adrian Klaver 17:41
Re: Strange behavior of "=" as assignment operator Kevin Grittner 21:27

June 2, 2013

Thread Author Time
Differences in Unicode handling on Mac vs Linux? Matt Daw 20:03
Re: Differences in Unicode handling on Mac vs Linux? Tom Lane 20:22
Re: Differences in Unicode handling on Mac vs Linux? Matt Daw 20:48
Re: Differences in Unicode handling on Mac vs Linux? Ian Lawrence Barwick 21:05

June 3, 2013

Thread Author Time
Passing a WHERE clause by trigger to a function Melvin Call 18:55
Re: Passing a WHERE clause by trigger to a function Melvin Call 21:44
Re: Passing a WHERE clause by trigger to a function David Johnston 21:54

June 4, 2013

Thread Author Time
More buffers used than a relation's relpages Amit Langote 02:29
Re: More buffers used than a relation's relpages Jeff Janes 03:17
Re: More buffers used than a relation's relpages Amit Langote 03:27
How to modify dump files created by pg_dump 任洪彩 08:44
Re: Passing a WHERE clause by trigger to a function Melvin Call 12:32
Re: Passing a WHERE clause by trigger to a function David Johnston 12:47
Re: More buffers used than a relation's relpages Andres Freund 13:04
Re: Passing a WHERE clause by trigger to a function Melvin Call 13:09
Streaming replication with sync slave, but disconnects due to missing WAL segments Mads.Tandrup 13:25
Re: More buffers used than a relation's relpages Amit Langote 13:42
Re: How to modify dump files created by pg_dump Raymond O'Donnell 15:40
Re: Foreign Key violated Keith Fiske 16:22
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments Jeff Janes 18:06
View's plan not taking advantage of WHERE? Mike Summers 21:53

June 5, 2013

Thread Author Time
vacuum_cost_delay and autovacuum_cost_delay ascot.moss@gmail.com 00:06
Re: vacuum_cost_delay and autovacuum_cost_delay Sergey Konoplev 00:58
Re: How to modify dump files created by pg_dump 任洪彩 02:02
Synonyms in PostgreSQL 9.2.4 Panneerselvam Posangu 08:29
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments Albe Laurenz 08:30
Synonyms in PostgreSQL 9.2.4 Panneerselvam Posangu 09:30
Re: Synonyms in PostgreSQL 9.2.4 Albe Laurenz 09:58
Re: Synonyms in PostgreSQL 9.2.4 Thomas Kellerer 10:12
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments Jeff Janes 10:42
Re: How to modify dump files created by pg_dump Raymond O'Donnell 11:28
Re: View's plan not taking advantage of WHERE? Mike Summers 11:31
Re: View's plan not taking advantage of WHERE? Scott Marlowe 11:53
Re: View's plan not taking advantage of WHERE? Mike Summers 12:01
Re: View's plan not taking advantage of WHERE? Scott Marlowe 12:08
Re: View's plan not taking advantage of WHERE? Scott Marlowe 12:09
Re: How to modify dump files created by pg_dump 私人邮箱 12:20
Re: View's plan not taking advantage of WHERE? Mike Summers 12:25
Re: How to modify dump files created by pg_dump Raymond O'Donnell 12:27
Re: View's plan not taking advantage of WHERE? Tom Lane 14:16
Re: View's plan not taking advantage of WHERE? Mike Summers 14:36
What's a good way to improve this query? Jorge Arévalo 18:22
point_ops with GiST PostGIS Spatial Index BladeOfLight16 18:28
Function use in query Ioana Danes 18:31
Re: What's a good way to improve this query? Paul Ramsey 18:31
Re: [postgis-users] point_ops with GiST PostGIS Spatial Index Tambade, Kedar 18:50
Trouble with replication David Greco 20:39
Re: Trouble with replication John R Pierce 21:00
Re: Function use in query David Johnston 21:14
Re: Trouble with replication David Greco 22:23

June 6, 2013

Thread Author Time
Re: [postgis-users] point_ops with GiST PostGIS Spatial Index BladeOfLight16 00:05
Re: How to modify dump files created by pg_dump Adrian Klaver 00:30
Re: How to modify dump files created by pg_dump 任洪彩 01:17
Re: Trouble with replication Michael Paquier 01:42
Re: How to modify dump files created by pg_dump Adrian Klaver 01:55
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments 📎 Mads.Tandrup 06:26
PostgreSQL Synchronous Replication in production Colin Sloss 10:20
Re: What's a good way to improve this query? Jorge Arévalo 10:23
Re: PostgreSQL Synchronous Replication in production Richard Huxton 10:50
passing schema name and table name as parameter functions in postgresql 9.2 anushasrivastava03 11:19
checking schema present or not by passing schema name as parameter anushasrivastava03 11:24
Re: passing schema name and table name as parameter functions in postgresql 9.2 Pavel Stehule 11:25
Re: checking schema present or not by passing schema name as parameter Pavel Stehule 11:40
Re: PostgreSQL Synchronous Replication in production Colin S 11:48
Re: Trouble with replication David Greco 12:19
Re: Trouble with replication David Greco 12:22
Re: PostgreSQL Synchronous Replication in production Richard Huxton 12:23
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments Shaun Thomas 13:25
Re: Function use in query Ioana Danes 13:32
Re: Function use in query David Johnston 14:23
plpgsql : looping over multidimensional array : getting NULL for subdimension Vinicio Nocciolini 14:44
User postgres unable to revoke privileges? François Beausoleil 15:40
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments Jeff Janes 16:32
Slave promotion failure François Beausoleil 16:37
Re: Trouble with replication Jeff Janes 16:51
Database performs massive reads when I'm doing writes. Ray Cote 16:53
Load Mysql table CSV into postgresql Adarsh Sharma 17:33
Re: Load Mysql table CSV into postgresql Adrian Klaver 17:49
Re: Function use in query Ioana Danes 18:21
Re: Database performs massive reads when I'm doing writes. bricklen 19:44
Re: Database performs massive reads when I'm doing writes. Ray Cote 19:55
Re: Load Mysql table CSV into postgresql Adarsh Sharma 19:58
Re: Database performs massive reads when I'm doing writes. Jeff Janes 20:05
Re: Function use in query David Johnston 20:17
Re: Database performs massive reads when I'm doing writes. Ray Cote 21:12
Re: Database performs massive reads when I'm doing writes. Ray Cote 21:15
Re: Database performs massive reads when I'm doing writes. Jeff Janes 21:41
Re: Load Mysql table CSV into postgresql Adrian Klaver 21:53
Re: User postgres unable to revoke privileges? Tom Lane 21:59
Re: Load Mysql table CSV into postgresql Thomas Kellerer 22:03
Re: Database performs massive reads when I'm doing writes. Ray Cote 22:15
PSA: If you are running Precise/12.04 upgrade your kernel. Joshua D. Drake 22:35
Re: Slave promotion failure Michael Paquier 22:40
Re: PSA: If you are running Precise/12.04 upgrade your kernel. Scott Marlowe 22:48
Re: PSA: If you are running Precise/12.04 upgrade your kernel. Joshua D. Drake 22:51
Re: Trouble with replication Michael Paquier 23:00

June 7, 2013

Thread Author Time
Re: PSA: If you are running Precise/12.04 upgrade your kernel. Toby Corkindale 02:25
pgxs question - linking c-functions to external libraries Rad Cirskis 03:49
Re: checking schema present or not by passing schema name as parameter anushasrivastava03 04:56
Re: PSA: If you are running Precise/12.04 upgrade your kernel. Nikhil G Daddikar 05:36
compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time c k 06:05
Re: passing schema name and table name as parameter functions in postgresql 9.2 anushasrivastava03 06:58
Re: passing schema name and table name as parameter functions in postgresql 9.2 anushasrivastava03 07:03
Re: PostgreSQL Synchronous Replication in production Albe Laurenz 08:22
Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form Aitor Gil Martin 09:35
Function tracking Rebecca Clarke 10:30
Re: Function tracking Pavel Stehule 10:44
Strange ranking with dict_xsyn F Wolff 10:48
Re: Slave promotion failure François Beausoleil 11:00
Re: User postgres unable to revoke privileges? François Beausoleil 11:03
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments Mads.Tandrup 11:13
excute function before DROP EXTENSION Beena Emerson 11:53
Re: Function tracking Dmitriy Igrishin 11:57
Full text search, SQL functions, and the planner Marc Dahn 12:10
Re: Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form Vincent Veyron 12:41
Re: Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form Aitor Gil Martin 13:13
Re: Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form Pavel Stehule 13:21
Re: compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time Tom Lane 13:45
Re: Full text search, SQL functions, and the planner Tom Lane 14:30
Re: PostgreSQL Synchronous Replication in production Merlin Moncure 15:20
Re: Function tracking Stephen Cook 15:24
Re: Function tracking Ian Lawrence Barwick 15:44
Re: Function tracking Thomas Kellerer 15:52
Re: Slave promotion failure François Beausoleil 16:00
Re: Function tracking Glyn Astill 16:51
Re: Function tracking Glyn Astill 16:54
Re: What's a good way to improve this query? Jorge Arévalo 18:18
Re: Slave promotion failure François Beausoleil 19:16
Re: PostgreSQL Synchronous Replication in production Jeff Janes 19:59

June 8, 2013

Thread Author Time
Question on explain Enrico Pirozzi 15:06
Re: Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form Vincent Veyron 16:14
Re: Question on explain Jeff Janes 17:47
Re: compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time c k 17:50
Re: compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time Scott Marlowe 19:46
Re: compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time Jeff Janes 21:29
Postgres 8.4 stopped working---Please urgent help needed g.singh 22:04
Sample database with difficult SQL questions Alexander Gataric 23:42

June 9, 2013

Thread Author Time
Re: Postgres 8.4 stopped working---Please urgent help needed wd 02:30
Re: Postgres 8.4 stopped working---Please urgent help needed dinesh kumar 13:17
Postgresql - Currval Vs Session Pool Gustavo Amarilla Santacruz 15:59
Re: Postgresql - Currval Vs Session Pool David Johnston 16:47
Re: User postgres unable to revoke privileges? Tom Lane 19:35
multilib environment with postgresql92 from CentOS-repos? (9.2.4) Markus Renner 21:15

June 10, 2013

Thread Author Time
Re: Question on explain Jeff Janes 02:19
Re: Sample database with difficult SQL questions Craig Ringer 02:43
My function run successfully with cursor, but can't change table 高健 02:59
databse version Philipp Kraus 07:52
Re: Question on explain Enrico Pirozzi 12:41
Re: My function run successfully with cursor, but can't change table Kevin Grittner 13:19
Re: Postgresql - Currval Vs Session Pool Albe Laurenz 13:21
Re: Trouble with replication David Greco 13:29
Re: Postgresql - Currval Vs Session Pool Merlin Moncure 14:13
Re: Postgresql - Currval Vs Session Pool Gustavo Amarilla Santacruz 15:24
Re: Postgresql - Currval Vs Session Pool Gustavo Amarilla Santacruz 15:24
Re: Postgresql - Currval Vs Session Pool Gustavo Amarilla Santacruz 16:02
Re: My function run successfully with cursor, but can't change table Thomas Kellerer 16:42
Re: My function run successfully with cursor, but can't change table Alvaro Herrera 16:48
why does this not give a syntax error? Scott Ribe 18:42
Re: why does this not give a syntax error? Tom Lane 18:52
Re: why does this not give a syntax error? Scott Ribe 19:16
Re: why does this not give a syntax error? Tom Lane 19:22
updatable view Sajeev Mayandi 22:02
Re: databse version Adrian Klaver 22:26
Re: databse version John R Pierce 22:42
INSERT RETURNING with values other than inserted ones. Aleksandr Furmanov 23:29
Re: INSERT RETURNING with values other than inserted ones. Richard Dunks 23:39
Re: INSERT RETURNING with values other than inserted ones. Aleksandr 23:49
Re: databse version Scott Marlowe 23:53

June 11, 2013

Thread Author Time
Re: updatable view Raghavendra 05:37
Oracle Packages and Stored Procedures - PostgreSQL conversion Panneerselvam Posangu 05:41
Re: Oracle Packages and Stored Procedures - PostgreSQL conversion Pavel Stehule 06:35
Re: PSA: If you are running Precise/12.04 upgrade your kernel. Toby Corkindale 06:58
Calculate a quotient for a count of boolean values (true or false) Alexander Farber 09:51
Re: Calculate a quotient for a count of boolean values (true or false) Alban Hertroys 09:59
Re: Calculate a quotient for a count of boolean values (true or false) Alexander Farber 10:33
Re: Calculate a quotient for a count of boolean values (true or false) Albe Laurenz 10:57
Re: databse version Luca Ferrari 10:57

Browse Archives

Prev | Next