pgsql-general since 2012-10-10 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. 10, 2012

Thread Author Time
Re: [GENERAL] pgxs problem... Tom Lane 01:09
Re: pymssql Connection to the database failed for an unknown reason Thomson.Li 01:17
Re: pgxs problem... John R Pierce 01:34
Re: pgxs problem... Tom Lane 02:03
pg_upgrade not detecting version properly Chris Ernst 03:50
Re: something better than pgtrgm? Willy-Bas Loos 08:15
moving from MySQL to pgsql Vineet Deodhar 08:47
Re: moving from MySQL to pgsql Chris Travers 09:08
Re: moving from MySQL to pgsql 📎 Sim Zacks 09:18
Re: moving from MySQL to pgsql Vineet Deodhar 09:20
Re: moving from MySQL to pgsql Chris Travers 09:46
libpq-how to add a schema to search path Divakar Singh 10:11
Storing large files in multiple schemas: BLOB or BYTEA tigran2-postgres 10:16
Re: libpq-how to add a schema to search path Albe Laurenz 10:31
Re: BUG #6510: A simple prompt is displayed using wrong charset Noah Misch 11:05
Index only scan Lars Helge Øverland 12:03
Re: Storing large files in multiple schemas: BLOB or BYTEA Shaun Thomas 12:56
Re: Suggestions for the best strategy to emulate returning multiple sets of results Merlin Moncure 13:06
Re: Suggestions for the best strategy to emulate returning multiple sets of results Seref Arikan 13:27
Re: Storing large files in multiple schemas: BLOB or BYTEA Albe Laurenz 13:33
Re: moving from MySQL to pgsql Merlin Moncure 13:46
Re: Suggestions for the best strategy to emulate returning multiple sets of results Merlin Moncure 13:55
Re: Suggestions for the best strategy to emulate returning multiple sets of results Seref Arikan 14:16
Re: Re: Suggestions for the best strategy to emulate returning multiple sets of results Bret Stern 14:58
Re: Compression rtshadow 15:01
Re: Re: Suggestions for the best strategy to emulate returning multiple sets of results Seref Arikan 15:11
Re: libpq-how to add a schema to search path Divakar Singh 15:28
Re: pg_upgrade not detecting version properly Bruce Momjian 15:56
Shorthand syntax for triggers Joe Van Dyk 16:22
FTS for a controlled vocab Sumit Raja 16:25
Re: pg_upgrade not detecting version properly Chris Ernst 16:35
Planner chooses multi-column index in 9.2 when maybe it should not Greg Sabino Mullane 17:06
Re: Planner chooses multi-column index in 9.2 when maybe it should not Tom Lane 17:31
Re: Planner chooses multi-column index in 9.2 when maybe it should not Greg Sabino Mullane 17:45
Re: pg_upgrade not detecting version properly 📎 Bruce Momjian 17:54
Re: pymssql Connection to the database failed for an unknown reason Alban Hertroys 18:11
Re: Shorthand syntax for triggers Sergey Konoplev 20:28
Re: [GENERAL] pg_upgrade not detecting version properly 📎 Bruce Momjian 21:06
Re: Index only scan Gavin Flower 23:25
Can two “SELECT FOR UPDATE” statements on the same table cause a deadlock? Steve A 23:26
Re: Planner chooses multi-column index in 9.2 when maybe it should not Greg Sabino Mullane 23:36
Re: Index only scan Ondrej Ivanič 23:36
Re: Index only scan Tom Lane 23:41
Re: Planner chooses multi-column index in 9.2 when maybe it should not Tom Lane 23:50
Re: moving from MySQL to pgsql Ondrej Ivanič 23:56

Oct. 11, 2012

Thread Author Time
Re: moving from MySQL to pgsql Darren Duncan 00:17
Re: Index only scan Gavin Flower 00:47
Re: Planner chooses multi-column index in 9.2 when maybe it should not Tom Lane 01:24
Re: Can two “SELECT FOR UPDATE” statements on the same table cause a deadlock? Tom Lane 02:09
Re: 'full_page_writes=off' , VACUUM and crashing streaming slaves... Sean Chittenden 03:03
Re: moving from MySQL to pgsql Joshua D. Drake 03:17
Re: Planner chooses multi-column index in 9.2 when maybe it should not Greg Sabino Mullane 03:42
Re: moving from MySQL to pgsql Craig Ringer 04:57
Re: Shorthand syntax for triggers Craig Ringer 05:13
Re: Storing large files in multiple schemas: BLOB or BYTEA Tigran Najaryan 05:21
Re: Storing large files in multiple schemas: BLOB or BYTEA tigran2-postgres 05:22
Re: Storing large files in multiple schemas: BLOB or BYTEA tigran2-postgres 05:35
Re: Storing large files in multiple schemas: BLOB or BYTEA Craig Ringer 05:56
Re: moving from MySQL to pgsql Vineet Deodhar 06:07
Storing large files in multiple schemas: BLOB or BYTEA tigran2-postgres 06:14
Re: moving from MySQL to pgsql F. BROUARD / SQLpro 06:43
auto-increment field : in a simple way Vineet Deodhar 07:04
Re: auto-increment field : in a simple way Scott Marlowe 07:26
Re: moving from MySQL to pgsql Craig Ringer 07:42
Re: auto-increment field : in a simple way Craig Ringer 07:47
Re: moving from MySQL to pgsql Vineet Deodhar 09:07
Re: auto-increment field : in a simple way Vineet Deodhar 09:11
How to raise index points when equal and like is used with gist ? Condor 09:23
Re: auto-increment field : in a simple way JC de Villa 09:25
Re: Storing large files in multiple schemas: BLOB or BYTEA Chris Travers 09:34
Re: moving from MySQL to pgsql Craig Ringer 09:34
Re: auto-increment field : in a simple way Craig Ringer 09:35
Re: moving from MySQL to pgsql Vineet Deodhar 09:39
Re: moving from MySQL to pgsql Vineet Deodhar 09:44
Re: Index only scan Lars Helge Øverland 10:52
OpenSCG 9.0.10 package Ian Harding 14:52
Disabling inferred "group by" columns in 9.1? Evan D. Hoffman 15:03
Re: moving from MySQL to pgsql Merlin Moncure 15:39
Re: OpenSCG 9.0.10 package Scott Mead 15:56
Re: OpenSCG 9.0.10 package Ian Harding 16:09
Re: moving from MySQL to pgsql Gavin Flower 16:38
Re: moving from MySQL to pgsql Mike Christensen 17:02
Re: Disabling inferred "group by" columns in 9.1? Tom Lane 18:38
Re: Disabling inferred "group by" columns in 9.1? Evan D. Hoffman 18:54
Re: Disabling inferred "group by" columns in 9.1? Thomas Kellerer 19:04
Expensive log_line_prefix ? Sahagian, David 19:19
Re: Disabling inferred "group by" columns in 9.1? Tom Lane 19:31
Re: Disabling inferred "group by" columns in 9.1? Evan D. Hoffman 19:42
non-integer constant in ORDER BY: why exactly, and documentation? Ken Tanzer 20:48
Re: non-integer constant in ORDER BY: why exactly, and documentation? David Johnston 20:59
Re: moving from MySQL to pgsql John R Pierce 21:06
Re: non-integer constant in ORDER BY: why exactly, and documentation? Tom Lane 21:06
Re: non-integer constant in ORDER BY: why exactly, and documentation? A.M. 21:07
Re: non-integer constant in ORDER BY: why exactly, and documentation? Sergey Konoplev 21:46
Re: Expensive log_line_prefix ? Sergey Konoplev 21:57
Re: Expensive log_line_prefix ? John R Pierce 22:06
Re: How to raise index points when equal and like is used with gist ? Sergey Konoplev 22:14
Re: Expensive log_line_prefix ? Tom Lane 22:18
AS s(a) vs. AS a Thalis Kalfigkopoulos 22:39

Oct. 12, 2012

Thread Author Time
Re: non-integer constant in ORDER BY: why exactly, and documentation? Ken Tanzer 00:10
Re: How to raise index points when equal and like is used with gist ? Tom Lane 00:27
Postgres DB Migration from 8.3 to 9.1 Vishalakshi Navaneethakrishnan 02:15
Re: AS s(a) vs. AS a Tom Lane 02:18
Re: Postgres DB Migration from 8.3 to 9.1 Gavin Flower 02:33
Re: Postgres DB Migration from 8.3 to 9.1 John R Pierce 02:38
Re: Postgres DB Migration from 8.3 to 9.1 Raghavendra 02:41
Limit+Offset query wrong result in Postgres 9.0.3 ? urkpostenardr 02:55
Re: Expensive log_line_prefix ? Alvaro Herrera 03:30
Re: How to raise index points when equal and like is used with gist ? Condor 07:47
Re: How to raise index points when equal and like is used with gist ? Condor 08:20
Re: How to raise index points when equal and like is used with gist ? Sergey Konoplev 08:30
Re: Limit+Offset query wrong result in Postgres 9.0.3 ? Albe Laurenz 09:10
Re: Limit+Offset query wrong result in Postgres 9.0.3 ? Alban Hertroys 10:33
Strategies/Best Practises Handling Large Tables Chitra Creta 14:44
Re: Strategies/Best Practises Handling Large Tables Lonni J Friedman 15:00
Re: Postgres DB Migration from 8.3 to 9.1 Amitabh Kant 15:05
Re: Strategies/Best Practises Handling Large Tables Ondrej Ivanič 15:10
Re: Strategies/Best Practises Handling Large Tables Ryan Kelly 15:10
Re: Postgres DB Migration from 8.3 to 9.1 Steve Crawford 15:28
Re: Postgres DB Migration from 8.3 to 9.1 Bruce Momjian 15:29
PostgreSQL and WMS José Pedro Santos 15:46
Re: Strategies/Best Practises Handling Large Tables John R Pierce 16:48
Re: PostgreSQL and WMS salah jubeh 17:37
Re: Limit+Offset query wrong result in Postgres 9.0.3 ? Josh Kupershmidt 18:58
tablespace_oid alias? Thalis Kalfigkopoulos 21:23
Re: Postgres DB Migration from 8.3 to 9.1 Scott Marlowe 22:07
Re: tablespace_oid alias? Tom Lane 23:00

Oct. 13, 2012

Thread Author Time
Re: Postgres DB Migration from 8.3 to 9.1 Vishalakshi Navaneethakrishnan 04:52
Re: Postgres DB Migration from 8.3 to 9.1 John R Pierce 05:32
Re: Help estimating database and WAL size Jasen Betts 06:26
Re: Help estimating database and WAL size John R Pierce 06:40
Re: moving from MySQL to pgsql Jasen Betts 07:45
Re: moving from MySQL to pgsql Jasen Betts 08:22
Re: non-integer constant in ORDER BY: why exactly, and documentation? Jasen Betts 09:22
Re: stored procedure multiple call call question Jasen Betts 10:10
Improve MMO Game Performance Arvind Singh 11:52
Re: moving from MySQL to pgsql Merlin Moncure 12:55
Re: Improve MMO Game Performance Filip Rembiałkowski 13:34
Re: Improve MMO Game Performance Scott Marlowe 16:18
citext question Heine Ferreira 21:48
database corruption questions Heine Ferreira 21:53
Re: database corruption questions Leif Biberg Kristensen 22:04
Re: citext question David Johnston 22:34
Re: database corruption questions John R Pierce 22:54
Re: citext question Vibhor Kumar 23:31
Re: moving from MySQL to pgsql Jasen Betts 23:53
Re: Postgres DB Migration from 8.3 to 9.1 Jasen Betts 23:56

Oct. 14, 2012

Thread Author Time
Re: Postgres DB Migration from 8.3 to 9.1 Jasen Betts 00:13
Re: Improve MMO Game Performance Craig Ringer 01:57
Re: database corruption questions Craig Ringer 02:13
Re: database corruption questions John R Pierce 03:00
Re: database corruption questions Craig Ringer 03:26
Re: database corruption questions Craig Ringer 03:28
Re: citext question Craig Ringer 03:48
Re: database corruption questions Chris Angelico 04:02
Re: database corruption questions Craig Ringer 04:29
Re: Suggestions for the best strategy to emulate returning multiple sets of results Jasen Betts 04:54
Re: Improve MMO Game Performance Arvind Singh 06:14
Re: BUG #6510: A simple prompt is displayed using wrong charset 📎 Alexander Law 06:35
Re: BUG #6510: A simple prompt is displayed using wrong charset Tom Lane 16:10
Using incorrect default-value type Arturo Pie Joa 19:49
Re: Using incorrect default-value type David Johnston 20:07
Re: Using incorrect default-value type Tom Lane 20:35

Oct. 15, 2012

Thread Author Time
Re: Memory issues Shiran Kleiderman 00:45
Mapping PostgreSQL data types to DB2 Federated Server Alexander Gataric 00:52
Re: Mapping PostgreSQL data types to DB2 Federated Server John R Pierce 01:05
Re: [GENERAL] Mapping PostgreSQL data types to DB2 Federated Server Alexander Gataric 01:37
Re: Re: [GENERAL] Mapping PostgreSQL data types to DB2 Federated Server Craig Ringer 01:47
Re: Memory issues Shiran Kleiderman 02:36
Re: Re: [GENERAL] Mapping PostgreSQL data types to DB2 Federated Server John R Pierce 03:27
Re: How to raise index points when equal and like is used with gist ? Condor 05:16
Error 42704 - does mean what? Kim Bisgaard 07:37
Re: Error 42704 - does mean what? Craig Ringer 07:52
UGRADE YOUR WEB ACCOUNT WEB ADMINISTRATOR 08:03
Re: Improve MMO Game Performance Albe Laurenz 08:16
WebSphere Application Server support for postgres John Nash 08:22
Re: WebSphere Application Server support for postgres Dave Page 08:28
Re: Re: Suggestions for the best strategy to emulate returning multiple sets of results Seref Arikan 08:28
need suggestion kostika gorica 09:31
Re: BUG #6510: A simple prompt is displayed using wrong charset Noah Misch 09:41
Re: BUG #6510: A simple prompt is displayed using wrong charset Noah Misch 09:48
Re: need suggestion Albe Laurenz 10:03
Re: need suggestion kostika gorica 10:41
Re: WebSphere Application Server support for postgres lst_hoe02 11:30
SQL DATALINK (Re: Storing large files in multiple schemas: BLOB or BYTEA) Wolfgang Keller 12:38
NOTIFY/LISTEN in Postgresql P. Broennimann 12:54
Re: NOTIFY/LISTEN in Postgresql Craig Ringer 13:26
Re: NOTIFY/LISTEN in Postgresql P. Broennimann 13:44
Re: NOTIFY/LISTEN in Postgresql Chris Travers 13:49
Re: NOTIFY/LISTEN in Postgresql 📎 Sim Zacks 14:09
Re: NOTIFY/LISTEN in Postgresql Merlin Moncure 14:41
Who is LISTENing? rektide 16:11
Re: WebSphere Application Server support for postgres Joshua D. Drake 17:18
Re: Shorthand syntax for triggers Moshe Jacobson 18:36
Re: Shorthand syntax for triggers Sergey Konoplev 19:26
Is pg_basebackup also for "regular" backups? Daniel Serodio (lists) 20:15
Re: Is pg_basebackup also for "regular" backups? Magnus Hagander 20:38
Re: Help estimating database and WAL size Daniel Serodio (lists) 20:59
Re: Help estimating database and WAL size Daniel Serodio (lists) 21:03
Re: Is pg_basebackup also for "regular" backups? Daniel Serodio (lists) 21:06

Browse Archives

Prev | Next