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

July 1, 2009

Thread	Author	Time
Re: Postgres online backup and restore	Scott Mead	00:05
Re: Postgres online backup and restore	Scott Mead	00:35
Re: [Fwd: Re: Python client + select = locked resources???]	Craig Ringer	07:43
Re: Python client + select = locked resources???	Scott Marlowe	07:49
Re: High consumns memory	Albe Laurenz	08:08
Multi - table statistics	Scara Maccai	09:15
cache reads vs. disk reads	Gerd König	09:20
Re: Regex Character-Class	Henry	09:29
Big Delete Consistently Causes a Crash	Tony Webb	11:24
Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function	Chris Spotts	11:32
Re: [Fwd: Re: Python client + select = locked resources???]	durumdara	12:33
Re: WAL and master multi-slave replication	Scot Kreienkamp	13:24
Re: Big Delete Consistently Causes a Crash	Tom Lane	13:56
Re: FW: lack in psql console	Juan Camilo Marín	15:57
Re: Python client + select = locked resources???	johnf	16:21
Re: Python client + select = locked resources???	Scott Mead	16:34
Preventing a user to use implicit casts	Stéphane A. Schildknecht	17:57
Re: Preventing a user to use implicit casts	Scott Marlowe	18:05
Re: Preventing a user to use implicit casts	Stéphane A. Schildknecht	18:11
Re: Preventing a user to use implicit casts	Pavel Stehule	18:43
Re: High consumns memory	Merlin Moncure	21:00
Does anyone know of a job scheduler that uses PostgreSQL?	Anthony Caduto	21:16
Re: Python client + select = locked resources???	Erik Jones	21:31
Re: Preventing a user to use implicit casts	Scott Marlowe	21:44
Re: datestyle no effect in 8.3.7	Bruce Momjian	22:38

July 2, 2009

Thread	Author	Time
1 Sequence per Row i.e. each customer's first order starts at 1	Merrick	00:04
Problem search on text arrays, using the overlaps (&&) operator	John Cheng	00:07
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Greg Stark	00:32
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Scott Marlowe	01:01
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Merrick	01:46
Re: Bug in ecpg lib ? 📎	leif	01:52
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Scott Marlowe	02:10
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Scott Marlowe	02:12
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Merrick	03:11
R: Does anyone know of a job scheduler that uses PostgreSQL?	Scara Maccai	05:57
Re: Help with installation please...	Craig Ringer	07:02
The connection closed unexpectedly - C++ and Postgre	drestajumena	08:05
Re: The connection closed unexpectedly - C++ and Postgre	Scott Marlowe	08:28
Re: The connection closed unexpectedly - C++ and Postgre	drestajumena	09:28
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Greg Stark	09:28
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Scott Marlowe	09:35
An example needed for Serializable conflict...	Durumdara	09:52
Delete triggers order in delete cascade (pg 8.3.7).	Michaël Lemaire	09:56
Re: 1 Sequence per Row i.e. each customer's first order starts at 1	Greg Stark	11:27
Re: Delete triggers order in delete cascade (pg 8.3.7).	Richard Huxton	12:14
Re: Does anyone know of a job scheduler that uses PostgreSQL?	Reid Thompson	12:42
Re: Delete triggers order in delete cascade (pg 8.3.7).	Michaël Lemaire	13:01
Re: Delete triggers order in delete cascade (pg 8.3.7).	Richard Huxton	13:32
Fwd: High consumns memory	Anderson Valadares	14:18
Fwd: High consumns memory	Anderson Valadares	14:19
Re: Delete triggers order in delete cascade (pg 8.3.7).	Michaël Lemaire	14:27
No password prompt logging into Postgres 8.4	Ben Trewern	14:37
Upgrading 8.3 to 8.4 on Windows.	Hartman, Matthew	14:46
Re: Replication	Simon Riggs	14:50
Re: No password prompt logging into Postgres 8.4	Bill Moran	14:57
Re: Upgrading 8.3 to 8.4 on Windows.	Richard Huxton	14:59
Re: Database schema dumper	Joshua J. Kugler	15:11
compiling postgres for 64 bit windows using mingw64	McWilliams, Steven	16:22
Re: Replication and coding good practices	Simon Riggs	16:33
Re: pgAdmin - no_spool	Simon Riggs	16:36
Re: compiling postgres for 64 bit windows using mingw64	Tom Lane	16:49
PG_DUMP/RESTORE Would like an explanation of these (non-critical) errors	James B. Byrne	16:56
simulate multiple primary keys	Brandon Metcalf	17:27
Re: simulate multiple primary keys	Hartman, Matthew	17:29
Re: pgAdmin - no_spool	Pedro Doria Meunier	17:30
Re: simulate multiple primary keys	Brandon Metcalf	17:37
Re: simulate multiple primary keys	Bill Moran	17:40
Re: simulate multiple primary keysx	Brandon Metcalf	17:55
Re: pgAdmin - no_spool	Simon Riggs	18:03
Q: data modeling with inheritance	Reece Hart	20:54
Re: simulate multiple primary keys	Lennin Caro	21:31

July 3, 2009

Thread	Author	Time
Re: Q: data modeling with inheritance	Nathan Boley	02:19
Installing plpython on 8.4	Scott Bailey	03:09
Re: Installing plpython on 8.4	Peter Eisentraut	08:37
Re: Problem search on text arrays, using the overlaps (&&) operator	Andreas Wenk	09:12
Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?	Joost Kraaijeveld	09:18
Group by on %like%	Jennifer Trey	09:44
Group by on %like%	Serge Fonville	09:51
Re: Vacation reply	Serge Fonville	09:58
Re: Group by on %like%	Guy Flaherty	10:32
Re: Group by on %like%	Guy Flaherty	10:37
How to use RETURN TABLE in Postgres 8.4	Michal Szymanski	10:52
Re: Group by on %like%	Dimitri Fontaine	10:53
Re: [GENERAL] Vacation reply	Bruce Momjian	13:36
Re: [GENERAL] Vacation reply	Serge Fonville	13:43
Re: Delete triggers order in delete cascade (pg 8.3.7).	Jasen Betts	13:47
REINDEX "is not a btree"	Vanessa Lopez	14:00
Re: [GENERAL] Vacation reply	Greg Sabino Mullane	14:10
unsubscribe-pattern-allmatching LISTNAME ALL	Raul Rojas	14:26
Re: Problem search on text arrays, using the overlaps (&&) operator	John Cheng	14:37
Re: How to use RETURN TABLE in Postgres 8.4	Tom Lane	15:46
Re: How to use RETURN TABLE in Postgres 8.4	Pavel Stehule	15:49
Re: Group by on %like%	nha	16:37
Re: How to use RETURN TABLE in Postgres 8.4	Michael Black	17:06
Store derived data or use view?	gvimrc	17:08
Re: Store derived data or use view?	Hartman, Matthew	17:46
Re: Q: data modeling with inheritance	David Fetter	18:29
Re: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?	ANdreas Wenk	19:24
Re: Store derived data or use view?	Martin Gainty	19:46
Re: PG_DUMP/RESTORE Would like an explanation of these (non-critical) errors	ANdreas Wenk	20:05
Re: Store derived data or use view?	Michael Black	22:23
Re: Installing plpython on 8.4	Scott Bailey	23:57

July 4, 2009

Thread	Author	Time
Re: Q: data modeling with inheritance	Reece Hart	00:37
Re: Q: data modeling with inheritance	Reece Hart	00:51
Re: Q: data modeling with inheritance	David Fetter	01:23
Pls help	Roseller A. Romanos	04:02
Re: Pls help	Pavel Stehule	04:40
Re: Pls help	Scott Marlowe	06:03
Re: Pls help	Pavel Stehule	06:12
Re: Pls help	Scott Marlowe	06:13
Re: Pls help	Pavel Stehule	06:22
Re: Pls help	Scott Marlowe	06:27
Re: Pls help	Scott Marlowe	06:27
Start automatically a function at startup of postgresql server	[email protected]	08:51
Re: Group by on %like%	Jennifer Trey	09:44
Re: REINDEX "is not a btree"	Craig Ringer	13:06
about pg_stat_get_db_xact_commit	abdelhak benmohamed	13:55
Re: Start automatically a function at startup of postgresql server	Gurjeet Singh	16:43
Re: Installing plpython on 8.4	Peter Eisentraut	16:50
Function Issue and casting	Juan Pablo Cook	17:47
Re: Function Issue and casting	Adrian Klaver	18:25
Function Issue and casting	Juan Pablo Cook	19:12
Documentation - PgAdmin	db.subscriptions	20:27
Will there be an official pg_migrator release?	Thomas Kellerer	21:03
Re: Pls help	justin	22:49
Re: Documentation - PgAdmin 📎	justin	22:58

July 5, 2009

Thread	Author	Time
Re: Will there be an official pg_migrator release?	Bruce Momjian	00:13
multiple rows by date using count(*)	Shad Keene	03:20
Re: Documentation - PgAdmin	Raymond O'Donnell	08:41
Re: multiple rows by date using count(*)	Andreas Kretschmer	09:25
Re: multiple rows by date using count(*)	Alban Hertroys	09:26
Postgres Plus Advanced Server and general Postgres compatibility?	Andre Lopes	11:19
Example of full text search ranking function somewhere?	Joost Kraaijeveld	12:12
Re: How to use RETURN TABLE in Postgres 8.4	Michal Szymanski	13:51
Re: Will there be an official pg_migrator release?	Thomas Kellerer	15:32
Re: Documentation - PgAdmin	Justin Graf	17:14
Re: Documentation - PgAdmin	Raymond O'Donnell	17:39
Re: Documentation - PgAdmin	Sachin Srivastava	18:22
Re: Documentation - PgAdmin	Guillaume Lelarge	20:00

July 6, 2009

Thread	Author	Time
GISVM Server pre-release available	Ricardo Pinho	00:49
COALESCE not filtering well.	Mohan Raj B	05:37
LIKE problem	Juan Pablo Cook	05:55
Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index	CM J	05:58
Re: LIKE problem	Pavel Stehule	06:15
Re: LIKE problem	A. Kretschmer	06:19
Re: [GENERAL] Documentation - PgAdmin	Guillaume Lelarge	06:57
howto determine rows count to be returned by DECLARE ... SELECT ...	Konstantin Izmailov	07:21
Re: Documentation - PgAdmin	Dave Page	07:33
Passing a table to function	sqlguru	11:27
Normalize INTERVAL ouput format in a db driver	Sebastien FLAESCH	11:49
Re: Postgres Plus Advanced Server and general Postgres compatibility?	Abbas	12:18
Re: Normalize INTERVAL ouput format in a db driver	Sebastien FLAESCH	12:25
Re: COALESCE not filtering well.	Greg Stark	12:54
Re: Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index	Tom Lane	14:59
Re: Upgrading 8.3 to 8.4 on Windows.	Tguru	15:40
Re: Problem search on text arrays, using the overlaps (&&) operator 📎	nha	16:12
Feistel cipher, shorter string and hex to int	Ivan Sergio Borgonovo	16:45
Windows installer for pg-8.4 confusion	Stuart McGraw	17:06
Re: Windows installer for pg-8.4 confusion	Andreas Wenk	17:22
Performance problem with low correlation data	Scara Maccai	17:32
Re: Windows installer for pg-8.4 confusion	Stuart McGraw	17:40
Re: Windows installer for pg-8.4 confusion	Dave Page	18:21
Re: Performance problem with low correlation data	Greg Stark	18:23
Added parameter for CREATE ROLE	Michael Gould	18:32
Re: Added parameter for CREATE ROLE	Raymond O'Donnell	18:40
Schema search_path and $user	Postgres User	18:41
Re: Schema search_path and $user	Tom Lane	19:19
Re: Schema search_path and $user	Postgres User	19:24
BUG #4903: Sugestion a db modele like mysql workbrench	Oscar Miguel Amezcua Estrella	19:47
Out of memory error	Paul Smith	20:21
Efficiently move data from one table to another, with FK constraints?	Rob W	20:22
Re: Windows installer for pg-8.4 confusion	Bruce Momjian	20:26
Re: Out of memory error	Tom Lane	20:34
Re: Out of memory error	Paul Smith	20:39
combine multiple row values in to one row	Lee Harr	21:29
Re: Problem search on text arrays, using the overlaps (&&) operator	John Cheng	23:17

July 7, 2009

Thread	Author	Time
Re: combine multiple row values in to one row	Ivan Sergio Borgonovo	00:22
Re: Out of memory error	Paul Ramsey	00:26
Re: Out of memory error	Paul Smith	01:45
Re: BUG #4903: Sugestion a db modele like mysql workbrench	Pavel Golub	06:17
Re: Performance problem with low correlation data	Scara Maccai	07:16
Sugestion a db modele like mysql workbrench	Andreas Wenk	07:33
Re: Normalize INTERVAL ouput format in a db driver	Albe Laurenz	08:49
Re: Out of memory error	Mark Cave-Ayland	08:59
Re: Feistel cipher, shorter string and hex to int	Daniel Verite	09:05
Re: Efficiently move data from one table to another, with FK constraints?	Albe Laurenz	09:12
Re: An example needed for Serializable conflict...	Albe Laurenz	09:36
Re: Feistel cipher, shorter string and hex to int	Daniel Verite	10:07
Re: An example needed for Serializable conflict...	durumdara	10:10
Re: An example needed for Serializable conflict...	Andres Freund	10:43
Re: Sugestion a db modele like mysql workbrench	Pavel Golub	11:00
Re: combine multiple row values in to one row	Hartman, Matthew	12:27
Re: Feistel cipher, shorter string and hex to int	Ivan Sergio Borgonovo	12:28
Re: Normalize INTERVAL ouput format in a db driver	Sebastien FLAESCH	13:04
Re: Sugestion a db modele like mysql workbrench	Andreas Wenk	13:54
Re: Bug in ecpg lib ?	Albe Laurenz	14:29
Table Partitioning : Having child tables in multiple database servers	Ransika de Silva	14:32
Re: Table Partitioning : Having child tables in multiple database servers	Ransika de Silva	15:38
Re: combine multiple row values in to one row	David Fetter	15:40
Re: combine multiple row values in to one row	David Fetter	15:43

Browse Archives

Prev | Next