pgsql-general since 2011-04-07 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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 7, 2011

Thread Author Time
Re: Preventing accidental non-SSL connections in psql? Yang Zhang 00:19
Re: Preventing accidental non-SSL connections in psql? Yang Zhang 00:21
Re: Preventing accidental non-SSL connections in psql? Adrian Klaver 01:18
Re: Preventing accidental non-SSL connections in psql? Yang Zhang 01:19
Re: postgres segfaulting on pg_restore Craig Ringer 01:22
Attaching/detaching tablespaces (or, in general, parts of a DB) Yang Zhang 02:05
Re: Why security-definer functions are executable by public by default? Noah Misch 02:47
Re: Critical Bug Craig Ringer 02:50
Re: Attaching/detaching tablespaces (or, in general, parts of a DB) John R Pierce 02:58
Re: how to insert multiple rows and get the ids back in a temp table (pgplsql)? abhishek.itbhu2004 04:12
Re: Critical Bug Allan Kamau 06:16
database backup throws errors Michael Molz 06:23
Arrays of arrays rsmogura 09:39
Re: postgres segfaulting on pg_restore Chris Curvey 10:37
Re: postgres segfaulting on pg_restore Craig Ringer 11:33
Protecting stored procedures Michael Gould 12:46
Re: postgres segfaulting on pg_restore Chris Curvey 12:49
Re: postgres segfaulting on pg_restore Craig Ringer 13:36
Re: Protecting stored procedures Szymon Guz 13:36
Re: Protecting stored procedures Andrew Sullivan 13:43
Re: Re: how to insert multiple rows and get the ids back in a temp table (pgplsql)? Merlin Moncure 13:48
Re: Arrays of arrays Merlin Moncure 13:53
Re: Protecting stored procedures Vibhor Kumar 13:54
Re: Protecting stored procedures Sim Zacks 13:56
Re: Attaching/detaching tablespaces (or, in general, parts of a DB) Guillaume Lelarge 13:59
Re: Attaching/detaching tablespaces (or, in general, parts of a DB) Vibhor Kumar 14:09
Re: Protecting stored procedures Michael Gould 14:31
Re: database backup throws errors Tom Lane 14:38
Re: Arrays of arrays Radosław Smogura 14:44
Re: postgres segfaulting on pg_restore Tom Lane 14:45
Re: Protecting stored procedures John R Pierce 16:13
Re: Protecting stored procedures Andrew Sullivan 16:45
Re: Protecting stored procedures Joshua D. Drake 17:16
Re: Protecting stored procedures Scott Marlowe 17:45
Re: postgres segfaulting on pg_restore Chris Curvey 17:54
Understanding "unknown" data type Steve Crawford 18:01
Re: postgres segfaulting on pg_restore Chris Curvey 18:19
Re: Understanding "unknown" data type Tom Lane 18:29
Re: Understanding "unknown" data type Steve Crawford 18:52
Re: Understanding "unknown" data type Tom Lane 19:19
What happened to ALTER SCHEMA ... SET TABLESPACE? Yang Zhang 19:27
Re: What happened to ALTER SCHEMA ... SET TABLESPACE? Yang Zhang 19:28
PostgreSQL backend process high memory usage issue Shianmiin 20:42
why autocommit mode is slow? Szymon Guz 20:59
Re: why autocommit mode is slow? Dann Corbit 21:05
Re: PostgreSQL backend process high memory usage issue Merlin Moncure 21:22
Re: PostgreSQL backend process high memory usage issue John R Pierce 21:46
Re: PostgreSQL backend process high memory usage issue Shianmiin 21:52
Re: why autocommit mode is slow? Adrian Klaver 21:55
Re: PostgreSQL backend process high memory usage issue Rob Sargent 22:03
Re: PostgreSQL backend process high memory usage issue Shianmiin 22:30
Re: PostgreSQL backend process high memory usage issue Shianmiin 22:37

April 8, 2011

Thread Author Time
Re: why autocommit mode is slow? Craig Ringer 02:05
Re: why autocommit mode is slow? Scott Marlowe 03:06
Re: why autocommit mode is slow? Szymon Guz 07:41
PostgreSQL + FreeBSD memory configuration, and an issue Gipsz Jakab 08:00
Using Function returning setof record in JOIN gmb 10:57
Index scan vs table inheritance Artem Shpynov aka FYR 11:15
Re: PostgreSQL backend process high memory usage issue Shianmiin 12:43
Re: why autocommit mode is slow? Vick Khera 13:00
Re: PostgreSQL + FreeBSD memory configuration, and an issue Vick Khera 13:15
cast list of oid salah jubeh 13:28
Re: PostgreSQL + FreeBSD memory configuration, and an issue Merlin Moncure 13:29
Re: PostgreSQL backend process high memory usage issue Merlin Moncure 13:33
Re: PostgreSQL + FreeBSD memory configuration, and an issue Vick Khera 14:05
Re: PostgreSQL + FreeBSD memory configuration, and an issue Gipsz Jakab 14:07
Re: PostgreSQL + FreeBSD memory configuration, and an issue Gipsz Jakab 14:08
Re: cast list of oid Pavel Stehule 14:23
Re: why autocommit mode is slow? Simon Riggs 14:26
Re: Using Function returning setof record in JOIN David Johnston 14:34
Re: Using Function returning setof record in JOIN Merlin Moncure 14:39
Surge 2011 CFP Deadline Extended Katherine Jeschke 14:50
Re: why autocommit mode is slow? Andrew Sullivan 14:56
Re: Using Function returning setof record in JOIN Pavel Stehule 14:56
Re: PostgreSQL backend process high memory usage issue Shianmiin 15:03
Re: PostgreSQL backend process high memory usage issue Shianmiin 15:30
comma vs cross join question Jason Long 16:39
Changed SSL Certificates Carlos Mennens 16:42
Count for pagination Jason Long 16:58
Re: Changed SSL Certificates Diego Schulz 17:15
Re: Changed SSL Certificates Carlos Mennens 17:21
Re: PostgreSQL + FreeBSD memory configuration, and an issue Gipsz Jakab 17:40
Re: Changed SSL Certificates Diego Schulz 17:56
Re: Changed SSL Certificates Adrian Klaver 18:01
Re: Changed SSL Certificates Vick Khera 18:02
Re: Changed SSL Certificates Tom Lane 18:08
Re: comma vs cross join question Tom Lane 18:24
Re: PostgreSQL backend process high memory usage issue Merlin Moncure 18:39
Count for pagination Jason Long 18:42
Re: Count for pagination Stephen Frost 18:44
Re: comma vs cross join question Tom Lane 18:45
Re: PostgreSQL backend process high memory usage issue Shianmiin 18:51
Re: PostgreSQL backend process high memory usage issue Shianmiin 19:00
Deferred foreign key constraint downsides Jack Christensen 19:08
Re: comma vs cross join question Jason Long 19:09
Re: Deferred foreign key constraint downsides Jerry Sievers 19:46
Re: Changed SSL Certificates Carlos Mennens 20:11
Re: PostgreSQL backend process high memory usage issue Merlin Moncure 21:27
Howto sort the result of UNION (without modifying its type)? Clemens Eisserer 21:44
Re: PostgreSQL backend process high memory usage issue Shianmiin 22:07
Critical fix for pg_upgrade/pg_migrator users momjian 22:29
Re: Howto sort the result of UNION (without modifying its type)? Rob Sargent 22:42
Re: Deferred foreign key constraint downsides Jeff Davis 23:21

April 9, 2011

Thread Author Time
Rename or Re-Create Constraints? Carlos Mennens 00:09
Re: Rename or Re-Create Constraints? Tom Lane 00:35
Re: Rename or Re-Create Constraints? Carlos Mennens 02:33
Re: Rename or Re-Create Constraints? Rob Sargent 02:38
.pgpass not working? Yang Zhang 05:36
Re: .pgpass not working? Yang Zhang 05:39
searchable database quickinfo 06:40
Re: Howto sort the result of UNION (without modifying its type)? Clemens Eisserer 09:58
Re: Rename or Re-Create Constraints? Carlos Mennens 16:22
Re: Rename or Re-Create Constraints? Tom Lane 16:58
Re: Rename or Re-Create Constraints? Carlos Mennens 21:59
Re: Rename or Re-Create Constraints? Adrian Klaver 22:21
Re: Rename or Re-Create Constraints? Adrian Klaver 22:30

April 10, 2011

Thread Author Time
Re: could not access status of transaction 1118722281 Gordon Shannon 00:41
Re: searchable database tomas 05:24
Re: searchable database John R Pierce 05:37
Re: Handling bytea field in partition trigger function Noah Misch 10:08
Re: Transaction wraparound vacuum synchronicity Noah Misch 10:12
pg_restore problem with type Sim Zacks 11:20
what data type to store fixed size integer? Arash pajoohande 11:41
Re: what data type to store fixed size integer? Craig Ringer 12:34
list kilfdc 13:04
Re: searchable database Robert Soulliere 14:05
Re: searchable database Ivano Luberti 15:06
Re: what data type to store fixed size integer? Tom Lane 15:59
[No subject] abdede@onvol.net 20:29

April 11, 2011

Thread Author Time
Global Variables in plpgsql Nick Raj 10:53
Re: Count for pagination Michael C Rosenstein 12:26
Re: autovacuum issue after upgrade to 9.0.1 George Woodring 15:07
Howto use "COPY FROM" with the native API? Clemens Eisserer 15:21
PG 9.0 32 bits bin under 64 bit arq manuel antonio ochoa 15:23
Re: Global Variables in plpgsql Adrian Klaver 16:03
Re: Global Variables in plpgsql Dmitriy Igrishin 16:17
Re: what data type to store fixed size integer? David Johnston 16:48
CREATE RULE _copy AS ON COPY TO ... Willy-Bas Loos 18:26
Re: Howto use "COPY FROM" with the native API? Andy Chambers 18:46
Re: Howto use "COPY FROM" with the native API? Pavel Stehule 19:33
Re: CREATE RULE _copy AS ON COPY TO ... Vibhor Kumar 21:10
Column storage (EXTERNAL/EXTENDED) settings for bytea/text column Joel Stevenson 22:19

April 12, 2011

Thread Author Time
Why is 8.4 and 9.0 so much slower on some queries? Uwe Schroeder 03:29
Re: Why is 8.4 and 9.0 so much slower on some queries? Tom Lane 04:57
Re: what data type to store fixed size integer? Arash pajoohande 05:32
Re: Why is 8.4 and 9.0 so much slower on some queries? Uwe Schroeder 05:58
Different cast behavior of TEXT and VARCHAR tomas 06:36
Re: what data type to store fixed size integer? David Johnston 06:59
Multiple Results with crosstab function Sven Haag 07:53
What is the difference between these queries salah jubeh 09:47
pg_connect connection problem AI Rumman 10:06
Re: Out of memory Jeremy Palmer 10:11
Re: What is the difference between these queries tv 10:29
UPDATE failed with 'ERROR: index row requires 8968 bytes, maximum size is 8191' Lonni J Friedman 10:40
Re: pg_connect connection problem Gipsz Jakab 11:03
full text search for words with a few specific chars Armin Nesiren 11:14
Re: Why is 8.4 and 9.0 so much slower on some queries? Merlin Moncure 13:34
Re: PostgreSQL backend process high memory usage issue Merlin Moncure 13:57
Re: Different cast behavior of TEXT and VARCHAR Tom Lane 14:29
Re: What is the difference between these queries Tom Lane 14:46
Re: Different cast behavior of TEXT and VARCHAR tomas 14:56
Re: What is the difference between these queries tv 15:12
word wrap in postgres akp geek 16:31
Re: Column storage (EXTERNAL/EXTENDED) settings for bytea/text column Bill Moran 17:33
Re: PostgreSQL backend process high memory usage issue Shianmiin 17:48
Re: word wrap in postgres Andreas Kretschmer 17:59
Re: word wrap in postgres akp geek 18:12
Trying out replication: cp cannot stat log file during recovery Henry C. 19:45
Re: Howto use "COPY FROM" with the native API? Clemens Eisserer 20:37
Re: pg_restore Mike Orr 21:09
Re: [GENERAL] PostgreSQL backend process high memory usage issue Merlin Moncure 22:13
Re: Column storage (EXTERNAL/EXTENDED) settings for bytea/text column Joel Stevenson 22:47
Revisiting UPDATE FROM ... ORDER BY not respected Carlo Stonebanks 23:08
Re: PostgreSQL backend process high memory usage issue Shianmiin 23:09

April 13, 2011

Thread Author Time
Re: Revisiting UPDATE FROM ... ORDER BY not respected Tom Lane 00:14
Postgres 9.0 + LDAP Vinzenz Bildstein 00:36
Re: Trying out replication: cp cannot stat log file during recovery Fujii Masao 02:28
9.0 Out of memory Jeremy Palmer 04:02
Re: Revisiting UPDATE FROM ... ORDER BY not respected Carlo Stonebanks 04:10
Re: 9.0 Out of memory Tom Lane 05:01
Re: [GENERAL] PostgreSQL backend process high memory usage issue Tom Lane 05:29
Re: 9.0 Out of memory Tom Lane 05:44
Re: Postgres 9.0 + LDAP Sim Zacks 07:14
Re: 9.0 Out of memory Jeremy Palmer 07:30
updating rows which have a common value forconsecutive dates Lonni J Friedman 07:33
Re: Trying out replication: cp cannot stat log file during recovery Henry C. 08:18
Blob handling with Delphi... Durumdara 08:28
Re: Blob handling with Delphi... John R Pierce 08:42
Speeding up replication startup/recovery Henry C. 09:03
Re: Speeding up replication startup/recovery Simon Riggs 09:16
Re: Speeding up replication startup/recovery Henry C. 10:39
Postgres 8.3 erro on shared memory windows paulo matadr 12:02
Weird WAL problem - 9.0.3 Rafael Martinez 13:09
Re: Weird WAL problem - 9.0.3 Adrian Klaver 13:28
Re: [GENERAL] PostgreSQL backend process high memory usage issue Merlin Moncure 13:42
Re: Weird WAL problem - 9.0.3 Rafael Martinez 13:44
Cursor metadata Andy Chambers 15:23
Adding a default value to a column after it exists Gauthier, Dave 16:21
Re: Adding a default value to a column after it exists Mike Fowler 16:25
Re: Adding a default value to a column after it exists Tom Lane 16:29

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30