pgsql-general - September 2009

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

Sept. 1, 2009

Thread	Author	Time
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

Sept. 2, 2009

Thread	Author	Time
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' / many small 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

Sept. 3, 2009

Thread	Author	Time
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' / many small 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 update columns	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

Sept. 4, 2009

Thread	Author	Time
How do I store tables on a remote host?	Sergey Samokhin	00:10
Re: column level, uid based authorization to update columns	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

Browse Archives

Prev | Next