pgsql-general since 2009-10-26 00:00

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

Oct. 26, 2009

Thread Author Time
Re: Can the string literal syntax for function definitions please be dropped ? Tom Lane 00:17
Re: Can the string literal syntax for function definitions please be dropped ? David W Noon 00:43
indexing ginanjar 01:45
Re: How can I get one OLD.* field in a dynamic query inside a trigger function ? Bruno Baguette 02:40
Re: Can the string literal syntax for function definitions please be dropped ? Pavel Stehule 04:37
Allowed types in embedded SQL, ecpg Hans-Michael Stahl 10:30
cursor MOVE vs OFFSET in SELECT silly8888 10:30
Re: cursor MOVE vs OFFSET in SELECT Grzegorz Jaśkiewicz 10:34
Re: cursor MOVE vs OFFSET in SELECT silly8888 11:14
Re: cursor MOVE vs OFFSET in SELECT Pavel Stehule 12:07
Logging statements with errors in PostgreSQL 8.1 Radcon Entec 12:48
joining an array with a table or...? Ivan Sergio Borgonovo 13:15
Re: [ANNOUNCE] PGDay.EU 2009 - approaching fast! Raymond O'Donnell 14:12
Re: drop view and recreate - for sync Vick Khera 14:20
Re: cursor MOVE vs OFFSET in SELECT Alvaro Herrera 14:28
Why does pg_dump set default_with_oids to true? Kynn Jones 15:04
Re: joining an array with a table or...? Ivan Sergio Borgonovo 15:05
Defining roles Michael Gould 15:32
Operational performance: one big table versus many smaller tables David Wall 16:46
Postmaster taking 100% of the CPU David Kerr 17:30
How to list user-specific configuration parameters? Tim Landscheidt 17:58
How do I pipe output from query to a file in PostgreSQL? Penrod, John 18:03
Re: Why does pg_dump set default_with_oids to true? Joshua D. Drake 18:47
Re: joining an array with a table or...? Merlin Moncure 18:56
Re: Can the string literal syntax for function definitions please be dropped ? Timothy Madden 19:03
Re: [ANNOUNCE] PGDay.EU 2009 - approaching fast! Cédric Villemain 19:08
Re: Why does pg_dump set default_with_oids to true? Alvaro Herrera 19:10
Re: How to list user-specific configuration parameters? Alvaro Herrera 19:36
Re: [ANNOUNCE] PGDay.EU 2009 - approaching fast! Raymond O'Donnell 19:43
Re: [GENERAL] [ANNOUNCE] PGDay.EU 2009 - approaching fast! Peter Geoghegan 19:44
Re: Postmaster taking 100% of the CPU Vick Khera 19:47
Re: joining an array with a table or...? Ivan Sergio Borgonovo 19:48
Re: How to list user-specific configuration parameters? Vick Khera 19:48
Re: Postmaster taking 100% of the CPU David Kerr 19:58
Re: Logging statements with errors in PostgreSQL 8.1 Adrian Klaver 20:08
Re: Logging statements with errors in PostgreSQL 8.1 John R Pierce 20:09
Re: Why does pg_dump set default_with_oids to true? Tom Lane 20:11
Re: [ANNOUNCE] PGDay.EU 2009 - approaching fast! Dave Page 20:15
Re: Postmaster taking 100% of the CPU Tom Lane 20:38
Re: Postmaster taking 100% of the CPU David Kerr 20:44
Re: How do I pipe output from query to a file in PostgreSQL? Kevin Kempter 21:03
Re: How do I pipe output from query to a file in PostgreSQL? Raymond O'Donnell 21:06
Re: [GENERAL] [ANNOUNCE] PGDay.EU 2009 - approaching fast! Peter Geoghegan 21:36
Re: CSV files & empty strings Niklas Johansson 22:36
Implementing Frontend/Backend Protocol TCP/IP Raimon Fernandez 22:44
Re: [GENERAL] [ANNOUNCE] PGDay.EU 2009 - approaching fast! Joshua D. Drake 22:47
Re: How to list user-specific configuration parameters? Tim Landscheidt 22:55
Re: Implementing Frontend/Backend Protocol TCP/IP Alvaro Herrera 23:15
Re: Implementing Frontend/Backend Protocol TCP/IP John R Pierce 23:17

Oct. 27, 2009

Thread Author Time
Is there any ways to pass an array as parameter in libpq? ChenXun 00:07
Re: drop view and recreate - for sync Craig Ringer 01:10
Re: cursor MOVE vs OFFSET in SELECT silly8888 01:59
PHP + PDO + PGPOOL = Segmentation fault VladK 02:59
How does PostgreSQL recognise "deleted" tuples by using xmax ? 纪晓曦 04:55
Re: Implementing Frontend/Backend Protocol TCP/IP Craig Ringer 05:10
Re: Is there any ways to pass an array as parameter in libpq? Craig Ringer 05:14
PostgreSQL function can not load dll library. A.Bhattacharya 06:19
Re: PostgreSQL function can not load dll library. Craig Ringer 06:30
Re: Implementing Frontend/Backend Protocol TCP/IP Raimon Fernandez 07:20
Re: Implementing Frontend/Backend Protocol TCP/IP John R Pierce 07:29
Re: How does PostgreSQL recognise "deleted" tuples by using xmax ? Martijn van Oosterhout 07:38
Re: Implementing Frontend/Backend Protocol TCP/IP Raimon Fernandez 08:02
Re: Implementing Frontend/Backend Protocol TCP/IP Albe Laurenz 08:55
design, ref integrity and performance Ivan Sergio Borgonovo 09:05
Re: Operational performance: one big table versus many smaller tables Richard Huxton 09:12
Re: design, ref integrity and performance Richard Huxton 09:17
Re: Implementing Frontend/Backend Protocol TCP/IP Craig Ringer 10:10
Re: design, ref integrity and performance Ivan Sergio Borgonovo 10:11
Re: design, ref integrity and performance Richard Huxton 10:54
Re: Defining roles Sam Mason 11:09
Invalid Page Header Error Denis BUCHER 11:28
Re: joining an array with a table or...? Merlin Moncure 12:06
Re: Is there any ways to pass an array as parameter in libpq? Merlin Moncure 12:15
Re: Invalid Page Header Error Richard Huxton 12:21
Re: Implementing Frontend/Backend Protocol TCP/IP John DeSoi 12:40
Re: Implementing Frontend/Backend Protocol TCP/IP John DeSoi 12:51
Re: Is there any ways to pass an array as parameter in libpq? ChenXun 12:56
Re: Implementing Frontend/Backend Protocol TCP/IP Alvaro Herrera 13:00
Re: Implementing Frontend/Backend Protocol TCP/IP Raimon Fernandez 13:25
Re: Implementing Frontend/Backend Protocol TCP/IP Raimon Fernandez 13:38
Re: Implementing Frontend/Backend Protocol TCP/IP Alvaro Herrera 13:41
Re: Implementing Frontend/Backend Protocol TCP/IP Alvaro Herrera 13:44
Just saw a blog on Amazon Relational Database Service (Beta) John Cheng 13:46
Upgrade from 8.2 to 8.3 & catching errors in functions Joshua Berry 13:52
Re: Implementing Frontend/Backend Protocol TCP/IP Raimon Fernandez 14:00
Re: Why does pg_dump set default_with_oids to true? Kynn Jones 14:04
Re: Implementing Frontend/Backend Protocol TCP/IP Alvaro Herrera 14:06
Re: Implementing Frontend/Backend Protocol TCP/IP Merlin Moncure 14:07
auto truncate/vacuum full JC Praud 14:15
Absolute value of intervals Joshua Berry 14:27
Re: Implementing Frontend/Backend Protocol TCP/IP Raimon Fernandez 14:43
Re: Absolute value of intervals Sam Mason 14:49
Re: Absolute value of intervals Tom Lane 14:55
Re: Absolute value of intervals Sam Mason 15:25
Re: Absolute value of intervals Sam Mason 15:29
Re: Absolute value of intervals Scott Bailey 15:49
Re: Upgrade from 8.2 to 8.3 & catching errors in functions Pavel Stehule 16:35
Re: Procedure for feature requests? Tim Landscheidt 17:01
Re: Procedure for feature requests? Sam Mason 17:06
Re: Upgrade from 8.2 to 8.3 & catching errors in functions Joshua Berry 17:31
Re: auto truncate/vacuum full Alvaro Herrera 17:31
Re: Procedure for feature requests? Tim Landscheidt 18:53
Re: Upgrade from 8.2 to 8.3 & catching errors in functions Pavel Stehule 18:57
Re: auto truncate/vacuum full Pavel Stehule 19:02
Re: auto truncate/vacuum full Alvaro Herrera 19:39
Re: PHP + PDO + PGPOOL = Segmentation fault Richard Huxton 19:43
Re: indexing Richard Huxton 19:50
Re: auto truncate/vacuum full Greg Smith 19:52
Re: How to list a role's permissions for a given relation? Richard Huxton 20:02
Re: auto truncate/vacuum full Tom Lane 20:33
Re: auto truncate/vacuum full Greg Smith 20:40
Re: auto truncate/vacuum full Tom Lane 20:47
Re: auto truncate/vacuum full Tom Lane 20:52
Re: Pgadmin support for writing files or psql \copy command Little, Douglas 21:31
how to identify outliers Rhys A.D. Stewart 21:36
Slow running query with views...how to increase efficiency? with index? fox7 22:11
Re: how to identify outliers Rhys A.D. Stewart 22:37
Re: Slow running query with views...how to increase efficiency? with index? Alan Hodgson 22:44
Re: how to identify outliers Alvaro Herrera 22:56
Re: how to identify outliers Scott Bailey 23:04
Re: Slow running query with views...how to increase efficiency? with index? Merlin Moncure 23:18
Re: auto truncate/vacuum full Alvaro Herrera 23:29
Re: how to identify outliers John R Pierce 23:58

Oct. 28, 2009

Thread Author Time
Re: PHP + PDO + PGPOOL = Segmentation fault Tatsuo Ishii 00:25
Re: PHP + PDO + PGPOOL = Segmentation fault Martin Gainty 01:27
Re: PHP + PDO + PGPOOL = Segmentation fault VladK 02:12
Re: Slow running query with views...how to increase efficiency? with index? fox7 08:57
still on joining array/inline values was and is: design, ref integrity and performance Ivan Sergio Borgonovo 09:50
log slow queries and hints Vasiliy G Tolstov 10:10
Re: Procedure for feature requests? Sam Mason 10:41
Re: auto truncate/vacuum full JC Praud 10:53
Re: Slow running query with views...how to increase efficiency? with index? Alban Hertroys 10:57
Re: how to identify outliers Sam Mason 11:00
Re: how to identify outliers Chris Spotts 12:34
Re: Slow running query with views...how to increase efficiency? with index? fox7 12:42
Emal reg expression Xai 12:45
Re: Slow running query with views...how to increase efficiency? with index? Alban Hertroys 12:55
Re: Slow running query with views...how to increase efficiency? with index? A. Kretschmer 12:56
Re: Slow running query with views...how to increase efficiency? with index? fox7 13:06
Postgres alpha testing docs and general test packs Thom Brown 13:33
Re: Postgres alpha testing docs and general test packs Grzegorz Jaśkiewicz 13:37
Re: Postgres alpha testing docs and general test packs Thom Brown 13:46
Re: Slow running query with views...how to increase efficiency? with index? fox7 13:51
Re: Postgres alpha testing docs and general test packs Adrian Klaver 13:57
Re: Postgres alpha testing docs and general test packs Thom Brown 14:13
Re: still on joining array/inline values was and is: design, ref integrity and performance Peter Hunsberger 15:12
could not find array type for data type character varying[] Viktor Rosenfeld 15:17
Re: auto truncate/vacuum full JC Praud 15:21
Re: could not find array type for data type character varying[] Tom Lane 15:30
Re: auto truncate/vacuum full Alvaro Herrera 15:36
Re: could not find array type for data type character varying[] Sam Mason 15:36
Re: could not find array type for data type character varying[] Merlin Moncure 15:44
Re: still on joining array/inline values was and is: design, ref integrity and performance Ivan Sergio Borgonovo 15:48
Re: auto truncate/vacuum full Jaime Casanova 16:13
Has anyone seen this while running pg_dumpall? Penrod, John 16:17
Re: auto truncate/vacuum full Tom Lane 16:33
Forms generator ? Stuart Adams 16:59
Re: Forms generator ? Ries van Twisk 18:37
Re: Forms generator ? Thomas Kellerer 18:41
Re: [GENERAL] Has anyone seen this while running pg_dumpall? Alvaro Herrera 18:55
Re: Has anyone seen this while running pg_dumpall? Penrod, John 18:56
Re: [GENERAL] Has anyone seen this while running pg_dumpall? Tom Lane 19:04
Help with postgresql memory issue Brooks Lyrette 19:22
Re: Help with postgresql memory issue Thom Brown 19:46
Re: Help with postgresql memory issue Brooks Lyrette 19:50
Re: PHP + PDO + PGPOOL = Segmentation fault Richard Huxton 19:52
Re: Help with postgresql memory issue Thom Brown 19:56
Re: log slow queries and hints Richard Huxton 19:58
Re: Emal reg expression Richard Huxton 20:01
Re: Help with postgresql memory issue Tom Lane 20:01
Re: Help with postgresql memory issue Brooks Lyrette 20:05
could not identify an equality operator for type annotation (Was: could not find array type for data type character varying[]) Viktor Rosenfeld 20:22
Re: How to list a role's permissions for a given relation? Kynn Jones 20:34
Re: Emal reg expression Roman Neuhauser 20:56
Re: Help with postgresql memory issue Greg Stark 21:13
Re: Help with postgresql memory issue Greg Smith 21:37
Re: Help with postgresql memory issue Greg Smith 21:45
Re: Postgres alpha testing docs and general test packs Guillaume Lelarge 22:18
Re: could not identify an equality operator for type annotation (Was: could not find array type for data type character varying[]) Tom Lane 22:23
Re: Postgres alpha testing docs and general test packs Guillaume Lelarge 22:37
Re: Postgres alpha testing docs and general test packs Adrian Klaver 22:43
Re: Postgres alpha testing docs and general test packs Thom Brown 22:55
Re: Postgres alpha testing docs and general test packs Alvaro Herrera 23:50

Oct. 29, 2009

Thread Author Time
Re: Postgres alpha testing docs and general test packs Adrian Klaver 00:17
Re: Postgres alpha testing docs and general test packs Thom Brown 00:27
Re: Postgres alpha testing docs and general test packs Greg Smith 01:13
Re: Slow running query with views...how to increase efficiency? with index? Alban Hertroys 08:48
multiple identical calc and function in single query Sim Zacks 10:05
Re: Emal reg expression William Temperley 10:20
[Newbie] UPDATE based on other table content Daniel Chiaramello 10:25
Re: Emal reg expression Stephane Bortzmeyer 10:27
Is data compressed when stored? Howard Cole 11:03
Re: Is data compressed when stored? A. Kretschmer 11:26
Re: [Newbie] UPDATE based on other table content Daniel Chiaramello 11:57
Re: [Newbie] UPDATE based on other table content Thom Brown 13:31
Re: multiple identical calc and function in single query Sam Mason 13:41
Re: [Newbie] UPDATE based on other table content Daniel Chiaramello 16:31
Can't connect Bob Pawley 17:08
Re: Can't connect Richard Huxton 17:24
Re: Can't connect Bob Pawley 17:53

Browse Archives

Prev | Next