Peripheral Links

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

pgsql-general - September 2009

2009-09-01

• Re: [Skytools-users] WAL Shipping + checkpoint Yaroslav Tykhiy (03:14)
• Eclipse jdbc postgresql Sheepjxx (05:08)
• Re: Eclipse jdbc postgresql John R Pierce (05:39)
• Re: [Skytools-users] WAL Shipping + checkpoint Simon Riggs (07:24)
• Re: Connecting to Teradata via Postgresql Simon Riggs (08:13)
• Re: Eclipse jdbc postgresql Glyn Astill (08:20)
• Re: Aggregate function with subquery in 8.3 and 8.4. Sam Mason (09:05)
• Re: Aggregate function with subquery in 8.3 and 8.4. Sam Mason (09:38)
• pg_ctl with unix domain socket? Josef Wolf (11:28)
• Keys and indexes Alexandr Varlamov (11:37)
• Re: No buffer space available Narendra Shah (11:53)
• Re: pg_ctl with unix domain socket? Abbas (11:58)
• Re: pg_ctl with unix domain socket? Josef Wolf (12:34)
• Re: Query and the number of row result Raymond O'Donnell (12:49)
• Re: pg_ctl with unix domain socket? Daniel Verite (13:33)
• Re: pg_ctl with unix domain socket? Adrian Klaver (13:34)
• Re: Keys and indexes Michael Glaesemann (13:38)
• Re: pg_ctl with unix domain socket? Josef Wolf (14:47)
• Get closest numbers between intervals xaviergxf (16:16)
• Any former bugs that loose duplicates after a sort Richard Broersma (19:20)
• Re: Any former bugs that loose duplicates after a sort Adrian Klaver (19:45)
• how to use multiple schema's Himanshu Gupta (20:58)
• Re: Get closest numbers between intervals Dimitri Fontaine (21:51)
• Re: No buffer space available Lennin Caro (22:01)
• Re: how to use multiple schema's Scott Marlowe (22:04)
• Enum Xai (23:22)
• Re: Enum John R Pierce (23:51)

2009-09-02

• Join efficiency tanjunhua (05:31)
• Re: Join efficiency tanjunhua (05:33)
• Re: No buffer space available Narendra Shah (05:35)
• Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args August Lilleaas (07:52)
• PostgreSQL Live CD based on CentOS 5.3 and PG 8.4 released Devrim GÜNDÜZ (08:15)
• creating array of integer[] out of query - how? Massa, Harald Armin (08:34)
• Re: creating array of integer[] out of query - how? hubert depesz lubaczewski (08:54)
• Re: creating array of integer[] out of query - how? Sam Mason (09:40)
• PostgreSQL Conference 2009 Japan Markus Wanner (09:41)
• Re: creating array of integer[] out of query - how? Massa, Harald Armin (09:50)
• Re: creating array of integer[] out of query - how? Sam Mason (10:03)
• Re: Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args Devrim GÜNDÜZ (10:23)
• PosgreSQL Service does not Start In Vista Inigo Barandiaran (10:39)
• Re: PosgreSQL Service does not Start In Vista Raymond O'Donnell (10:44)
• Re: Join efficiency Sam Mason (10:45)
• Re: PosgreSQL Service does not Start In Vista Iñigo Barandiaran (10:49)
• Re: PosgreSQL Service does not Start In Vista Inigo Barandiaran (10:50)
• Re: PosgreSQL Service does not Start In Vista Inigo Barandiaran (10:52)
• Re: Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args August Lilleaas (11:19)
• Re: PosgreSQL Service does not Start In Vista Thomas Kellerer (11:39)
• Add a serial column to a table based on a sort clause Igor Katson (12:40)
• Re: PosgreSQL Service does not Start In Vista Inigo Barandiaran (12:53)
• Re: Join efficiency tanjunhua (13:11)
• Re: how to use multiple schema's Himanshu Gupta (13:19)
• PL/SQL & unset custom variable Gordon Ross (13:28)
• Re: creating array of integer[] out of query - how? Massa, Harald Armin (13:47)
• Re: creating array of integer[] out of query - how? Sam Mason (14:17)
• Subselect problem Wellmann, Harald (14:24)
• Re: creating array of integer[] out of query - how? Merlin Moncure (14:31)
• Re: PL/SQL & unset custom variable Andreas Kretschmer (14:39)
• Re: Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args Tom Lane (14:41)
• Re: creating array of integer[] out of query - how? Massa, Harald Armin (14:46)
• Re: how to use multiple schema's Scott Marlowe (14:48)
• install postgis in linux server without desktop shane_china (14:50)
• Re: how to use multiple schema's Himanshu Gupta (14:52)
• Re: PL/SQL & unset custom variable Gordon Ross (14:56)
• Re: Join efficiency Sam Mason (15:01)
• Re: PosgreSQL Service does not Start In Vista Thomas Kellerer (15:32)
• Looking for real configuration data Wei Zheng (15:39)
• Re: PosgreSQL Service does not Start In Vista Inigo Barandiaran (15:46)
• Re: Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args August Lilleaas (16:22)
• Re: PostgreSQL Live CD based on CentOS 5.3 and PG 8.4 released Emanuel Calvo Franco (16:47)
• Re: install postgis in linux server without desktop Sachin Srivastava (16:53)
• Re: install postgis in linux server without desktop Joshua D. Drake (17:00)
• Re: how to use multiple schema's Roderick A. Anderson (17:01)
• Re: how to use multiple schema's Sam Mason (17:08)
• Re: PostgreSQL Live CD based on CentOS 5.3 and PG 8.4 released Scott Marlowe (17:15)
• [Q] optmizing postgres for 'single client' / many small queries V S P (17:19)
• Re: how to use multiple schema's Roderick A. Anderson (17:30)
• Re: how to use multiple schema's Roderick A. Anderson (17:34)
• Re: [Q] optmizing postgres for 'single client' / many small queries Pavel Stehule (17:49)
• Re: PostgreSQL Live CD based on CentOS 5.3 and PG 8.4 released Devrim GÜNDÜZ (17:58)
• Re: [Q] optmizing postgres for 'single client' / many small queries V S P (18:02)
• Re: Subselect problem Tom Lane (18:08)
• Re: PL/SQL & unset custom variable Tom Lane (18:16)
• Re: [Q] optmizing postgres for 'single client' / many small queries Tom Lane (18:26)
• Re: [Q] optmizing postgres for 'single client' / many small queries V S P (18:40)
• Re: [Q] optmizing postgres for 'single client' / many small queries Tom Lane (18:45)
• Re: [Q] optmizing postgres for 'single client' / many small queries V S P (19:03)
• Re: PL/SQL & unset custom variable Gordon Ross (19:31)
• binary format of array stored as text Dave Huber (19:50)
• Should I create an index for partition with fixed key? Sergey Samokhin (19:53)
• Re: binary format of array stored as text Merlin Moncure (20:08)
• Re: Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args Lennin Caro (21:27)
• Re: [Q] optmizing postgres for 'single client' / manysmall queries David Fetter (23:35)
• Re: install postgis in linux server without desktop shane_china (23:54)
• Re: install postgis in linux server without desktop shane_china (23:58)

2009-09-03

• Re: problems with function pg_catalog.btrim(date) Tom Lane (01:10)
• Re: Add a serial column to a table based on a sort clause David Fetter (01:11)
• Re: print/return only the first X chars of a varchar column? kalyan s (04:10)
• Re: Audit Trigger puzzler Adam Rich (04:44)
• handle audiofiles in postgres edisan (04:47)
• Re: handle audiofiles in postgres John R Pierce (05:03)
• Re: handle audiofiles in postgres Harvey, Allan AC (05:22)
• Domain types versus anyelement Brendan Jurd (06:37)
• Re: Domain types versus anyelement Brendan Jurd (06:41)
• maximum count of contiguous years gorsa (07:23)
• Does PG cache results of an aggregate function, (and results of non-volatile functions)? Allan Kamau (07:44)
• easy task: concurrent select-updates Nickolay (08:05)
• Re: easy task: concurrent select-updates Nickolay (08:09)
• Re: install postgis in linux server without desktop Robert Dörfler (08:10)
• Re: Subselect problem Wellmann, Harald (08:37)
• To pass schemaname as a function parameter Kalai R (11:28)
• Re: To pass schemaname as a function parameter A. Kretschmer (11:37)
• Re: To pass schemaname as a function parameter Merlin Moncure (11:39)
• Re: maximum count of contiguous years Tim Landscheidt (11:46)
• Data folder in differnet filesystem S Arvind (12:08)
• Re: install postgis in linux server without desktop shane_china (12:18)
• Re: Data folder in differnet filesystem A. Kretschmer (12:23)
• Re: install postgis in linux server without desktop Robert Dörfler (12:27)
• Re: PosgreSQL Service does not Start In Vista Inigo Barandiaran (12:47)
• How do I use tsvector_update_trigger to index non-character columns? dennis jenkins (13:09)
• array weirdity Sim Zacks (13:19)
• Re: array weirdity Richard Huxton (13:24)
• Re: array weirdity Michael Glaesemann (13:41)
• Re: [Q] optmizing postgres for 'single client' / many small queries Richard Broersma (14:24)
• Re: PostgreSQL Live CD based on CentOS 5.3 and PG 8.4 released Emanuel Calvo Franco (14:38)
• Snow Leopard and plpython problem Jerry LeVan (14:38)
• Re: Snow Leopard and plpython problem Emanuel Calvo Franco (14:45)
• Re: Snow Leopard and plpython problem Jan Otto (15:01)
• Re: Audit Trigger puzzler David Kerr (15:08)
• Re: PostgreSQL Live CD based on CentOS 5.3 and PG 8.4 released Devrim GÜNDÜZ (15:31)
• Re: Audit Trigger puzzler Adam Rich (15:40)
• Re: easy task: concurrent select-updates Andy Colson (15:48)
• Re: handle audiofiles in postgres Christopher Browne (15:53)
• Problem with leaking connections Mark Lange (15:55)
• Re: Problem with leaking connections Joshua D. Drake (16:02)
• Re: Problem with leaking connections Andy Colson (16:10)
• Re: PosgreSQL Service does not Start In Vista Thomas Kellerer (16:13)
• auto-increment in a view Willy-Bas Loos (16:22)
• Re: auto-increment in a view Raymond O'Donnell (16:27)
• Re: [Q] optmizing postgres for 'single client' / manysmall queries David Fetter (16:28)
• Re: auto-increment in a view Adam Rich (16:44)
• add a value to an ENUM type Edoardo Panfili (16:52)
• Re: auto-increment in a view Willy-Bas Loos (17:03)
• column level, uid based authorization to update columns Gauthier, Dave (17:17)
• Re: column level, uid based authorization to update columns Ries van Twisk (17:25)
• Re: column level, uid based authorization to updatecolumns David Fetter (18:02)
• Create language PLPERL error Shakil Shaikh (18:12)
• PL/Perl 64-bit and sending emails Mark Lubratt (18:30)
• Re: Create language PLPERL error Tom Lane (18:38)
• Re: Create language PLPERL error Shakil Shaikh (19:02)
• Re: easy task: concurrent select-updates Kevin McConnell (19:05)
• Re: Create language PLPERL error Alvaro Herrera (19:08)
• Re: PL/Perl 64-bit and sending emails Steve Atkins (19:10)
• Re: easy task: concurrent select-updates Andy Colson (19:16)
• Re: pg_ctl with unix domain socket? Josef Wolf (19:20)
• Getting "insufficient data left in message" on copy with binary Gordon Shannon (19:51)
• New server disk setup? Adam Rich (20:08)
• Re: add a value to an ENUM type APseudoUtopia (20:13)
• Re: Getting "insufficient data left in message" on copy with binary Tom Lane (20:14)
• Add Large Object support to database programmatically acordner (20:15)
• Re: add a value to an ENUM type Edoardo Panfili (20:28)
• query speed question Christopher Condit (21:11)
• Re: Add Large Object support to database programmatically Richard Huxton (21:51)
• Re: query speed question Bill Moran (22:02)
• Re: [GENERAL] What happens when syslog gets blocked? Alvaro Herrera (22:04)
• Re: Snow Leopard and plpython problem Jerry LeVan (22:20)
• Regex substring help Nick (22:22)
• Re: Regex substring help David Fetter (23:00)
• Re: query speed question Christopher Condit (23:21)

2009-09-04

• How do I store tables on a remote host? Sergey Samokhin (00:10)
• Re: column level, uid based authorization to updatecolumns Stephen Frost (00:10)
• Re: pg_ctl with unix domain socket? Adrian Klaver (00:16)
• trick problem 纪晓曦 (01:02)
• Re: How do I store tables on a remote host? Scott Marlowe (02:24)
• Re: Getting "insufficient data left in message" on copy with binary Gordon Shannon (03:05)
• Got could not truncate directory "pg_multixact/offsets": apparent wraparound Gordon Shannon (03:43)
• Re: New server disk setup? Scott Marlowe (04:00)
• N + 1 replication Juan Backson (04:36)
• Re: easy task: concurrent select-updates Nickolay (04:41)
• Moving avg using SQL 纪晓曦 (05:28)
• How to stop a query A B (05:37)
• Re: libpq performance Juan Backson (05:38)
• Re: libpq performance Chris (05:44)
• custom datatype - rgb color gabriel munteanu (05:46)
• Re: How to stop a query Guillaume Lelarge (05:53)
• Re: How to stop a query Pavel Stehule (05:53)
• Re: Moving avg using SQL A. Kretschmer (06:03)
• Re: N + 1 replication Robert Dörfler (06:16)
• Re: [Q] optmizing postgres for 'single client' / many small queries Dimitri Fontaine (08:00)
• Need help in copying a table from one database to other Rekha Ravi Pai (08:23)
• Re: easy task: concurrent select-updates Nickolay (08:26)
• Re: Need help in copying a table from one database to other A. Kretschmer (08:35)
• strange error occurs when adding index Juan Backson (09:42)
• Re: query speed question Alban Hertroys (11:07)
• Re: query speed question Bill Moran (12:53)
• Re: strange error occurs when adding index hubert depesz lubaczewski (13:24)
• where clause question Scott Frankel (13:47)
• Re: Add Large Object support to database programmatically acordner (14:17)
• Re: PL/Perl 64-bit and sending emails Dimitri Fontaine (14:26)
• Re: Got could not truncate directory "pg_multixact/offsets": apparent wraparound Alvaro Herrera (14:27)
• comment on constraint Andreas Kretschmer (14:45)