Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-general - May 2012

May 1, 2012

• Re: Test ODBC connection failed. Pleae help me to take a look. Thanks. yxj (00:45)
• Re: Test ODBC connection failed. Pleae help me to take a look. Thanks. leaf_yxj (00:55)
• PL/R install, no pgxs available Daniel Cole (03:04)
• Re: PL/R install, no pgxs available John R Pierce (03:22)
• Re: PL/R install, no pgxs available John R Pierce (03:31)
• Re: PL/R install, no pgxs available Joe Conway (04:05)
• Re: Database upgrading: upgrade server first or client first? roy hills (08:12)
• Having trouble with pg_dumpall -o Matthew Churcher (10:12)
• Re: Having trouble with pg_dumpall -o Thom Brown (10:22)
• Re: how robust are custom dumps? Willy-Bas Loos (10:36)
• Re: Having trouble with pg_dumpall -o Matthew Churcher (10:55)
• Re: Having trouble with pg_dumpall -o Thom Brown (10:58)
• Re: Having trouble with pg_dumpall -o Matthew Churcher (11:37)
• Re: Having trouble with pg_dumpall -o Thom Brown (11:39)
• Re: Having trouble with pg_dumpall -o Thom Brown (11:42)
• Re: PL/R install, no pgxs available Daniel Cole (11:47)
• PostgreSQL 8.3 data corruption Chitra Creta (11:51)
• Re: Having trouble with pg_dumpall -o Matthew Churcher (12:06)
• Re: Listen and Notify Mark Morgan Lloyd (12:51)
• Table / View Security Report Schade, Jeffrey (12:58)
• Re: Having trouble with pg_dumpall -o Tom Lane (13:35)
• Re: Having trouble with pg_dumpall -o Adrian Klaver (13:38)
• Re: Table / View Security Report Bartosz Dmytrak (15:42)
• Re: Explain verbose query with CTE Bartosz Dmytrak (15:43)
• How do I setup this Exclusion Constraint? bradford (17:15)
• Re: How do I setup this Exclusion Constraint? Richard Broersma (17:26)
• Re: How do I setup this Exclusion Constraint? bradford (17:39)
• Re: How do I setup this Exclusion Constraint? Bartosz Dmytrak (18:20)
• Re: How do I setup this Exclusion Constraint? Misa Simic (18:38)
• installation of plpython2.7 Mark Rostron (19:56)
• Re: Listen and Notify Alexander Reichstadt (20:25)

May 2, 2012

• SQL functions not being inlined Evan Martin (02:43)
• Re: SQL functions not being inlined Chris Angelico (03:23)
• Re: SQL functions not being inlined Tom Lane (03:44)
• Re: installation of plpython2.7 Peter Eisentraut (03:50)
• Inefficient plan selected by PostgreSQL 9.0.7 Maxim Boguk (04:10)
• Re: Inefficient plan selected by PostgreSQL 9.0.7 Tom Lane (04:50)
• Re: Inefficient plan selected by PostgreSQL 9.0.7 Maxim Boguk (05:04)
• Re: SQL functions not being inlined Evan Martin (05:34)
• Re: Inefficient plan selected by PostgreSQL 9.0.7 Maxim Boguk (05:41)
• Re: PostgreSQL 8.3 data corruption Chitra Creta (06:11)
• Re: PostgreSQL 8.3 data corruption Pavel Stehule (06:26)
• Postgres 8.x on Linux : how to use HugePages STERBECQ Didier (09:28)
• Significance of Postgres (version 9.1.1) Compilation parameters - Performance Jayashankar K B (09:46)
• Re: Postgres 8.x on Linux : how to use HugePages Boszormenyi Zoltan (09:56)
• updating 6million rows, slowdown every 5minutes, manually doing checkpoints? Gábor Farkas (10:13)
• Which Java persistence library would you use with PostgreSQL? Bata Degen (10:15)
• Re: Which Java persistence library would you use with PostgreSQL? Bata Degen (10:42)
• Re: Which Java persistence library would you use with PostgreSQL? Sumit Raja (11:09)
• RE : Postgres 8.x on Linux : how to use HugePages STERBECQ Didier (11:39)
• PLR Help Daniel Cole (12:01)
• Uppercase to lowercase trigger? Chrishelring (12:33)
• Re: SQL functions not being inlined Evan Martin (12:48)
• new rows based on existing rows Andy Chambers (12:52)
• Re: Significance of Postgres (version 9.1.1) Compilation parameters - Performance Albe Laurenz (13:19)
• Re: SQL functions not being inlined Tom Lane (13:41)
• Re: How do I setup this Exclusion Constraint? bradford (14:02)
• Re: How do I setup this Exclusion Constraint? Misa Simic (14:22)
• Re: PLR Help Steve Crawford (14:53)
• How to insert random character data into tables. leaf_yxj (16:10)
• How to insert random character data into tables for testing purpose. THanks. leaf_yxj (16:14)
• Re: Uppercase to lowercase trigger? Chris Angelico (16:30)
• Removal of BSDi, BSD/OS port Bruce Momjian (16:31)
• Re: How to insert random character data into tables fortesting purpose. THanks. Andreas Kretschmer (16:32)
• Re: Which Java persistence library would you use with PostgreSQL? Radosław Smogura (16:39)
• Re: new rows based on existing rows Chris Angelico (17:03)
• Re: How to insert random character data into tables for testing purpose. THanks. leaf_yxj (18:03)
• Re: Limit the normal user to see system catalog or not??? And create privilege??? Bruce Momjian (18:42)
• Re: PLR Help Joe Conway (19:59)
• Re: PLR Help Joe Conway (20:07)
• Re: psql latex and newlines Bruce Momjian (20:29)
• Re: Difference between speed of 2 functions: SQL+STABLE and PLPGSQL+EXECUTE Dmitry Koterov (20:30)
• Re: PLR Help Daniel Cole (21:23)
• pqlib garbage collection Alexander Reichstadt (21:32)
• Re: new rows based on existing rows Tom Lane (22:00)
• Re: spanish locale question Tulio (22:45)
• Is there away to output a time stamp in a specified time zone with the time zone indicator (e.g. EDT) Matrix Guy (22:59)
• Re: Limit the normal user to see system catalog or not??? And create privilege??? Adrian Klaver (23:03)
• Re: Re: How to insert random character data into tables for testing purpose. THanks. Bruce Momjian (23:14)
• Re: Limit the normal user to see system catalog or not??? And create privilege??? Bruce Momjian (23:15)

May 3, 2012

• Re: Advisory Locks and Prepared Transactions Tom Lane (00:13)
• SQLSTATE XX000 Internal Error 7 Ben Madin (02:37)
• Re: Is there away to output a time stamp in a specified time zone with the time zone indicator (e.g. EDT) Adrian Klaver (02:50)
• Re: postgresql log indicate too many execute S_2:COMMIT leo xu (02:57)
• logging query result size? Ben Chobot (03:45)
• Re: SQLSTATE XX000 Internal Error 7 Tom Lane (03:57)
• Re: pqlib garbage collection Alexander Reichstadt (06:33)
• Re: SQLSTATE XX000 Internal Error 7 Ben Madin (06:46)
• Re: new rows based on existing rows Alban Hertroys (06:52)
• Memory Management in pqlib, Garbage Collection support Alexander Reichstadt (07:08)
• Re: SQLSTATE XX000 Internal Error 7 Martijn van Oosterhout (07:12)
• Re: Memory Management in pqlib, Garbage Collection support Peter Bex (07:16)
• Re: Uppercase to lowercase trigger? Chrishelring (07:19)
• Re: Memory Management in pqlib, Garbage Collection support John R Pierce (07:23)
• Re: Memory Management in pqlib, Garbage Collection support Alexander Reichstadt (07:39)
• Re: Uppercase to lowercase trigger? Pavel Stehule (07:41)
• Re: Uppercase to lowercase trigger? Ken Tanzer (07:50)
• Re: Uppercase to lowercase trigger? John R Pierce (07:56)
• Re: Memory Management in pqlib, Garbage Collection support Magnus Hagander (07:56)
• Re: Difference between speed of 2 functions: SQL+STABLE and PLPGSQL+EXECUTE Albe Laurenz (07:59)
• Re: Memory Management in pqlib, Garbage Collection support Peter Bex (08:13)
• Re: Memory Management in pqlib, Garbage Collection support Simon Riggs (08:32)
• Re: Memory Management in pqlib, Garbage Collection support Alban Hertroys (08:56)
• Re: Memory Management in pqlib, Garbage Collection support Alexander Reichstadt (09:24)
• Re: Uppercase to lowercase trigger? Chrishelring (11:03)
• Re: SQL functions not being inlined Evan Martin (13:21)
• How to get the physical locations of tables, views, functions etc of Postgresql in Windows & Linux? Siva Palanisamy (13:22)
• Re: How to get the physical locations of tables, views, functions etc of Postgresql in Windows & Linux? Raghavendra (13:39)
• Encryption - searching and sorting David Welton (13:42)
• Re: SQLSTATE XX000 Internal Error 7 Tom Lane (14:00)
• Re: Removal of BSDi, BSD/OS port Bruce Momjian (15:02)
• Re: Re: How to insert random character data into tables for testing purpose. THanks. yxj (15:23)
• Re: SQL functions not being inlined Tom Lane (15:30)
• Re: Limit the normal user to see system catalog or not??? And create privilege??? yxj (15:31)
• Issue with rsync based incremental backup : postgres: startup process waiting for 0000000100000001000000D2 Samba (15:49)
• Re: pqlib garbage collection Martijn van Oosterhout (16:32)
• Re: Uppercase to lowercase trigger? Darren Duncan (17:21)
• privs drop after alter table Gauthier, Dave (18:14)
• Re: Issue with rsync based incremental backup : postgres: startup process waiting for 0000000100000001000000D2 Michael Nolan (18:25)
• Re: privs drop after alter table Josh Kupershmidt (18:54)
• Move the postgreSQL database from Drive C to Map Network Drive (Called Z) EllyR (18:55)
• Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) John R Pierce (21:12)
• Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) Magnus Hagander (21:12)
• Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) Chris Angelico (21:50)

May 4, 2012

• Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) EllyR (00:15)
• Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) EllyR (00:17)
• Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) EllyR (00:20)
• trimming a column Michael P. Soulier (01:01)
• Re: trimming a column Greg Williamson (01:55)
• Re: trimming a column Adrian Klaver (02:05)
• Re: trimming a column Adrian Klaver (02:12)
• Re: SQL functions not being inlined Evan Martin (02:45)
• Re: trimming a column Michael P. Soulier (03:13)
• Re: trimming a column Michael P. Soulier (03:17)
• Re: trimming a column Michael P. Soulier (03:23)
• Re: Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) John R Pierce (04:21)
• Re: Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) David Johnston (05:18)
• Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records) Geo-x (07:34)
• Re: errors on restoring postgresql binary dump to glusterfs Magnus Hagander (07:58)
• Re: spanish locale question Albe Laurenz (08:22)
• Re: Is it possible to call other functions inside plpythonu? Stuart Bishop (09:09)
• Re: Is it possible to call other functions inside plpythonu? Stuart Bishop (09:17)
• Re: How to get the physical locations of tables, views, functions etc of Postgresql in Windows & Linux? Siva Palanisamy (10:01)
• Re: How to get the physical locations of tables, views, functions etc of Postgresql in Windows & Linux? Raghavendra (12:03)
• Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records) Pavel Stehule (13:04)
• Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records) Merlin Moncure (13:12)
• Streaming replication: sequences on slave seemingly ahead of sequences on master Vincent de Phily (13:55)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Merlin Moncure (14:47)
• set returning functions and resultset order Ingmar Brouns (16:10)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Vincent de Phily (16:16)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Michael Nolan (16:27)
• .pgpass not working Rebecca Clarke (16:30)
• Re: .pgpass not working Tom Lane (16:54)
• Re: spanish locale question Al Eridani (17:17)
• How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks leaf_yxj (17:23)
• Re: spanish locale question Tom Lane (17:31)
• Re: .pgpass not working Ben Chobot (17:35)
• Re: How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks Adrian Klaver (17:36)
• Re: Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) John R Pierce (18:16)
• Re: spanish locale question Andreas Joseph Krogh (18:54)
• Re: set returning functions and resultset order Pavel Stehule (18:54)

May 5, 2012

• Re: spanish locale question Tulio (02:22)
• manipulating anyarray columns Tomas Vondra (16:04)
• Lost one tablespace - can't access whole database Stefan Tzeggai (21:19)

May 6, 2012

• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Simon Riggs (09:29)
• how to amend SQL standard to add comments? Aleksey Tsalolikhin (17:24)
• Re: how to amend SQL standard to add comments? Thomas Kellerer (17:49)
• Is there a tool for checking database integrity Clemens Eisserer (18:47)
• Re: how to amend SQL standard to add comments? Tom Lane (19:05)
• Re: Is there a tool for checking database integrity Tomas Vondra (22:37)
• Re: Is there a tool for checking database integrity Bruce Momjian (22:56)
• Re: Is there a tool for checking database integrity Tomas Vondra (23:07)

May 7, 2012

• Re: Lost one tablespace - can't access whole database Michael Nolan (06:49)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Vincent de Phily (08:01)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Simon Riggs (08:14)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Magnus Hagander (08:19)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Simon Riggs (09:36)
• COPY column order MD33 (12:33)
• Re: COPY column order Adrian Klaver (13:13)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Tom Lane (13:33)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Michael Nolan (13:52)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Fujii Masao (13:59)
• Re: Streaming replication: sequences on slave seemingly ahead of sequences on master Merlin Moncure (14:05)
• Re: How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks leaf_yxj (14:10)
• Re: How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks leaf_yxj (14:12)
• Re: Re: How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks Adrian Klaver (14:24)
• Re: errors on restoring postgresql binary dump to glusterfs Liang Ma (15:02)
• Simultaneous Installations 7.4 9.x Randy Johnson (15:08)
• Re: errors on restoring postgresql binary dump to glusterfs Magnus Hagander (16:54)
• Re: errors on restoring postgresql binary dump to glusterfs Liang Ma (17:34)
• Upgrading from 8.4 and 9.0 to 9.1 Scott Briggs (19:10)
• Re: COPY column order Brent Wood (19:26)
• Re: errors on restoring postgresql binary dump to glusterfs Magnus Hagander (19:27)
• Re: Upgrading from 8.4 and 9.0 to 9.1 Guillaume Lelarge (19:28)
• Re: Upgrading from 8.4 and 9.0 to 9.1 Scott Briggs (19:37)
• Re: Upgrading from 8.4 and 9.0 to 9.1 Raymond O'Donnell (19:45)
• Re: Simultaneous Installations 7.4 9.x Peter Eisentraut (19:58)
• Re: Upgrading from 8.4 and 9.0 to 9.1 Guillaume Lelarge (19:59)
• Use LISTEN/NOTIFY between different databases Igor (20:13)
• Re: Use LISTEN/NOTIFY between different databases John R Pierce (20:23)