close

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

Jan. 1, 2013

Thread Author Time
Re: Picking the first of an order in an aggregate query Robert James 01:55
Regarding mapping of postgreSQL database and RDF file vishal dave 06:32
Recovering from an exception 📎 Marko Tiikkaja 14:56
Re: rights for schema Adrian Klaver 17:26
OLD pseudo relation for INSERT in rules and triggers Rafał Pietrak 18:17
Re: OLD pseudo relation for INSERT in rules and triggers Adrian Klaver 18:24
Re: OLD pseudo relation for INSERT in rules and triggers Rafał Pietrak 21:16

Jan. 2, 2013

Thread Author Time
Re: Recovering from an exception Marko Tiikkaja 00:16
Re: Recovering from an exception Marko Tiikkaja 01:17
Using the NEW record in an EXECUTE command in a PL/pgSQL trigger function 📎 Ali Pouya 12:49
Re: Using the NEW record in an EXECUTE command in a PL/pgSQL trigger function Pavel Stehule 13:27
Re: Using the NEW record in an EXECUTE command in a PL/pgSQL trigger function Ali Pouya 13:53
Dedicated PostgreSQL System Carlos Mennens 14:30
Re: Dedicated PostgreSQL System Jov 15:44
Re: Dedicated PostgreSQL System Andrew Hastie 15:56
Is there any plugin for Nagios, which sends Postgresql ERROR information with SQL query in mail? AI Rumman 16:55
Fwd: Question on Trigram GIST indexes ERR ORR 17:04
un-pivot with crosstab? Kirk Wythers 17:16
Query fluctuates .... Strange strange ..... Abraham, Danny 19:08
Re: Is there any plugin for Nagios, which sends Postgresql ERROR information with SQL query in mail? Steve Crawford 19:22
Re: un-pivot with crosstab? David Johnston 20:32
Re: Is there any plugin for Nagios, which sends Postgresql ERROR information with SQL query in mail? Peter Geoghegan 21:02

Jan. 3, 2013

Thread Author Time
Re: Query fluctuates .... Strange strange ..... Adrian Klaver 00:54
PostgreSQL run as process in windows tuanhoanganh 02:40
Re: PostgreSQL run as process in windows John R Pierce 02:51
Re: PostgreSQL run as process in windows Craig Ringer 03:45
Re: PostgreSQL run as process in windows John R Pierce 04:04
Re: PostgreSQL run as process in windows tuanhoanganh 04:16
Re: PostgreSQL run as process in windows tuanhoanganh 04:51
Re: PostgreSQL run as process in windows Craig Ringer 04:52
Re: PostgreSQL run as process in windows tuanhoanganh 06:49
Re: PostgreSQL run as process in windows Alban Hertroys 08:46
Postgresql 9.1 - select statement with multiple "with-clauses" becomes very slow Opel Fahrer 11:43
Re: Postgresql 9.1 - select statement with multiple "with-clauses" becomes very slow Alban Hertroys 12:25
Re: Postgresql 9.1 - select statement with multiple "with-clauses" becomes very slow Opel Fahrer 13:01
Database Design: Maintain Audit Trail of Changes Rich Shepard 15:38
Large number of rows in pg_type and slow gui (pgadmin) refresh Robert Klaus 15:50
Re: Database Design: Maintain Audit Trail of Changes Adrian Klaver 16:09
Re: Corrupt indexes on slave when using pg_bulkload on master James Cowell 16:12
Re: Database Design: Maintain Audit Trail of Changes Fabrízio de Royes Mello 16:19
Unable to reload postgresql.conf without restarting Jose Martinez 16:25
Re: Database Design: Maintain Audit Trail of Changes Rich Shepard 16:50
Re: Database Design: Maintain Audit Trail of Changes Rich Shepard 16:52
Re: Database Design: Maintain Audit Trail of Changes Bèrto ëd Sèra 17:01
Re: [ADMIN] Unable to reload postgresql.conf without restarting Bruce Momjian 17:17
Re: Database Design: Maintain Audit Trail of Changes Rich Shepard 17:18
Re: Database Design: Maintain Audit Trail of Changes Fabrízio de Royes Mello 17:27
Re: Unable to reload postgresql.conf without restarting Matheus de Oliveira 17:30
Re: Large number of rows in pg_type and slow gui (pgadmin) refresh Thomas Kellerer 17:30
Re: [GENERAL] Unable to reload postgresql.conf without restarting sk baji 17:36
Re: Large number of rows in pg_type and slow gui (pgadmin) refresh Robert Klaus 17:45
Re: Database Design: Maintain Audit Trail of Changes Bèrto ëd Sèra 17:49
Re: Unable to reload postgresql.conf without restarting Scott Ribe 18:02
Re: Unable to reload postgresql.conf without restarting Matheus de Oliveira 18:34
alter default privileges problem Gauthier, Dave 19:09
Re: [ADMIN] Unable to reload postgresql.conf without restarting Jerry Sievers 19:15
Re: Large number of rows in pg_type and slow gui (pgadmin) refresh Thomas Kellerer 19:15
Curious unnest behavior Jeff Trout 19:22
Re: alter default privileges problem Gauthier, Dave 21:57
Unnecessary files that can be deleted/moved in cluster dir? John Abraham 23:31
Re: alter default privileges problem Tom Lane 23:59

Jan. 4, 2013

Thread Author Time
Re: Curious unnest behavior Patrick Krecker 04:18
DbLink connection with SSPI authentication fails Florent Mazzone 10:53
Re: [GENERAL] Unable to reload postgresql.conf without restarting Amit Kapila 14:26
Re: Large number of rows in pg_type and slow gui (pgadmin) refresh Igor Neyman 14:36
Re: Monitoring streaming replication from standby on Windows Ali Pouya 16:26
recasting to timestamp from varchar Kirk Wythers 17:00
recasting to timestamp from varchar Kirk Wythers 17:16
Re: recasting to timestamp from varchar Pavel Stehule 17:27
recasting to timestamp from varchar Kirk Wythers 17:28
Re: Curious unnest behavior Pavel Stehule 20:32
Re: Permission for relationship but not for select is possible? Kevin Grittner 20:51
Re: Large number of rows in pg_type and slow gui (pgadmin) refresh Kevin Grittner 22:41
pgpool2 load balancing not working Greg Donald 23:42
Re: pgpool2 load balancing not working Lonni J Friedman 23:55

Jan. 5, 2013

Thread Author Time
Re: pgpool2 load balancing not working Tatsuo Ishii 02:04
Re: recasting to timestamp from varchar Chris Angelico 05:19
Re: PostgreSQL run as process in windows Jeff Janes 05:24
Re: recasting to timestamp from varchar John R Pierce 05:53
Question on Trigram GIST indexes ERR ORR 18:20

Jan. 6, 2013

Thread Author Time
Counterintuitive locking behavior Chris Travers 02:18
Re: Counterintuitive locking behavior Amit kapila 05:40
Re: Counterintuitive locking behavior Amit kapila 06:53
Re: Counterintuitive locking behavior Boszormenyi Zoltan 07:11
Re: Counterintuitive locking behavior Thomas Kellerer 08:52
currval of sequence xxx_seq is not yet defined in this session? kenyon 09:57

Jan. 7, 2013

Thread Author Time
lc_time not working? J. Hondius 14:45
Re: lc_time not working? Adrian Klaver 15:13
Re: lc_time not working? Tom Lane 15:56
Re: currval of sequence xxx_seq is not yet defined in this session? Tom Lane 16:09
Re: lc_time not working? Adrian Klaver 16:18
spring a string to rows (Postgresql 8.4) Emi Lu 19:44
Re: spring a string to rows (Postgresql 8.4) Raymond O'Donnell 19:52
Re: spring a string to rows (Postgresql 8.4) Thomas Kellerer 19:54
Re: spring a string to rows (Postgresql 8.4) Moshe Jacobson 19:55

Jan. 8, 2013

Thread Author Time
Re: PostgreSQL run as process in windows Craig Ringer 02:31
Re: PostgreSQL run as process in windows Craig Ringer 02:32
Re: Database Design: Maintain Audit Trail of Changes Craig Ringer 05:32
Re: Unnecessary files that can be deleted/moved in cluster dir? Craig Ringer 05:51
Re: Unnecessary files that can be deleted/moved in cluster dir? Raghavendra 05:58
Why the default data range for "pre_auth_delay" and "post_auth_delay" is different? Jackie Zhang 06:02
PostgreSQL 9.2 and PGBOUNCER ac@hsk.hk 06:40
Re: PostgreSQL 9.2 and PGBOUNCER Birta Levente 07:13
Re: PostgreSQL 9.2 and PGBOUNCER ac@hsk.hk 08:21
Re: PostgreSQL 9.2 and PGBOUNCER Birta Levente 09:04
How to store clickmap points? aasat 10:12
Re: lc_time not working? Solved. J. Hondius 11:05
Re: Database Design: Maintain Audit Trail of Changes Stevo Slavić 11:24
Re: PostgreSQL 9.2 and PGBOUNCER ac@hsk.hk 11:52
When to run Vacuum in postgres 9.0.4 Anjali Arora 12:45
Questions about 9.2 unique constraints ac@hsk.hk 12:56
Error: absolute path not allowed Wolf Schwurack 15:09
Using composite types within PLPGSQL Function Graeme Hinchliffe 15:10
Re: Database Design: Maintain Audit Trail of Changes Wolfgang Keller 15:20
Query with LIMIT but as random result set? Stefan Keller 15:20
Re: Query with LIMIT but as random result set? Adrian Klaver 15:27
Re: Using composite types within PLPGSQL Function Leif Biberg Kristensen 15:35
Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master James Cowell 17:00
Re: Picking the first of an order in an aggregate query Vincent Veyron 17:03
Re: [postgis-users] Query with LIMIT but as random result set? Stefan Keller 17:24
pgxs "missing magic block ... PG_MODULE_MAGIC" with "MODULE_big" 📎 David Fuhry 17:30
Re: pgxs "missing magic block ... PG_MODULE_MAGIC" with "MODULE_big" David Fuhry 17:33
Re: pgxs "missing magic block ... PG_MODULE_MAGIC" with "MODULE_big" Tom Lane 17:55
Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master Tom Lane 18:02
Re: pgxs "missing magic block ... PG_MODULE_MAGIC" with "MODULE_big" David Fuhry 18:11
Getting PLPython to work with PostgreSQL 9.2 ledocf 18:38
Discerning when functions had execute revoked from public Todd Kover 21:26
query by partial timestamp Kirk Wythers 22:19
Re: query by partial timestamp Raymond O'Donnell 22:26
Installation James 22:26
Re: query by partial timestamp Raymond O'Donnell 22:39
Re: query by partial timestamp Rob Sargent 22:51
Re: query by partial timestamp Steve Crawford 23:03
Re: Discerning when functions had execute revoked from public Tom Lane 23:57

Jan. 9, 2013

Thread Author Time
Re: query by partial timestamp Gavan Schneider 00:26
Re: query by partial timestamp Tom Lane 00:48
Re: Discerning when functions had execute revoked from public Jerry Sievers 01:06
Re: Discerning when functions had execute revoked from public Tom Lane 01:48
Re: currval of sequence xxx_seq is not yet defined in this session? kenyon 01:58
Re: query by partial timestamp Kirk Wythers 02:15
Re: Error: absolute path not allowed Scott Marlowe 05:48
Re: Error: absolute path not allowed Raghavendra 05:57
Database connections seemingly hanging Fredrik.HuitfeldtMadsen 10:14
Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master James Cowell 10:43
Bug: dblink_send_query not work on 9.2? aasat 13:55
Re: Getting PLPython to work with PostgreSQL 9.2 Adrian Klaver 14:35
Re: query by partial timestamp Nathan Clayton 15:49
Re: query by partial timestamp Steve Crawford 17:07
PostgreSQL hackfest @ Developer Conference 2013, Brno, CZ Honza Horak 17:14
Re: query by partial timestamp Michael Nolan 17:42
Re: query by partial timestamp Michael Nolan 17:47
Re: query by partial timestamp hubert depesz lubaczewski 18:09
Re: Error: absolute path not allowed wschwurack 19:50
Re: How to store clickmap points? Ben Chobot 21:08
Re: How to store clickmap points? David Johnston 21:33
Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master Tom Lane 21:51
How can I detect if a schema exists? felix 22:39

Jan. 10, 2013

Thread Author Time
Re: How can I detect if a schema exists? Ian Lawrence Barwick 00:11
Re: Error: absolute path not allowed Scott Marlowe 00:15
Re: currval of sequence xxx_seq is not yet defined in this session? Adrian Klaver 00:21
Re: How can I detect if a schema exists? felix 00:25
Re: .. yatler sahri 00:49
Custom JDBC wrapper for DB2 Fed Server Alexander Gataric 02:00
Re: Bug: dblink_send_query not work on 9.2? Tom Lane 02:10
Re: Database connections seemingly hanging Tom Lane 04:30
Re: Error: absolute path not allowed Raghavendra 05:07
[No subject] Vikram A 07:52
Re: How to store clickmap points? Jasen Betts 09:36
Re: Bug: dblink_send_query not work on 9.2? aasat 10:04
Re: query by partial timestamp Gavan Schneider 11:11
Identifier gets truncated Peter Kroon 14:36
Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master Fujii Masao 14:50
Re: Error: absolute path not allowed wschwurack 15:02
Re: Error: absolute path not allowed wschwurack 15:14
data corruption when using base backups generated from hot standby Lonni J Friedman 16:07
Re: Identifier gets truncated Bruce Momjian 16:23
Re: When to run Vacuum in postgres 9.0.4 Kevin Grittner 17:06
Re: When to run Vacuum in postgres 9.0.4 Kevin Grittner 17:08
Re: [postgis-users] Query with LIMIT but as random result set? Kevin Grittner 20:28
Re: Error: absolute path not allowed wschwurack 21:33
Re: [postgis-users] Query with LIMIT but as random result set? Stefan Keller 22:36

Jan. 11, 2013

Thread Author Time
What can we do to create windows 7 boot disk xunuogui 04:28
Re: a yatler sahri 10:45
Re: Database connections seemingly hanging Fredrik.HuitfeldtMadsen 13:05
Libpq and multithreading Asia 15:27
Re: [postgis-users] Query with LIMIT but as random result set? Gavin Flower 17:31
Re: [postgis-users] Query with LIMIT but as random result set? Bosco Rama 17:45
Re: [postgis-users] Query with LIMIT but as random result set? Gavin Flower 17:49
psql copy from through bash Kirk Wythers 18:13
Re: psql copy from through bash Szymon Guz 18:18
Re: psql copy from through bash Kirk Wythers 18:32
Re: psql copy from through bash Szymon Guz 18:36
Re: psql copy from through bash Pavel Stehule 18:40
Re: psql copy from through bash Jerry Sievers 20:19
changes "during checkpointing" Sahagian, David 21:04
> Gavan Schneider 21:44
Re: > Gavin Flower 22:22
Getting Mysql data into Postgres: least painful methods? Ken Tanzer 23:54

Jan. 12, 2013

Thread Author Time
Re: Getting Mysql data into Postgres: least painful methods? Adrian Klaver 00:12
Re: Getting Mysql data into Postgres: least painful methods? wd 00:30

Browse Archives

Prev | Next