pgsql-general since 2008-12-25 00:00

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

Browse Archives

Prev | Next

Dec. 25, 2008

Thread	Author	Time
Re: pl/proxy and sequence generation	Asko Oja	01:36
Automatic CRL reload	Andrej Podzimek	05:51
get the array value?	Charles.Hou	06:15
Information about Pages, row versions of tables, indices	Gerhard Wiesinger	09:58
Re: Information about Pages, row versions of tables, indices	Pavel Stehule	10:50
Conditional commit inside functions	Gerhard Wiesinger	11:17
Re: Conditional commit inside functions	Pavel Stehule	12:58
Re: lack of consequence with domains and types	Grzegorz Jaśkiewicz	13:19
Re: Conditional commit inside functions	Asko Oja	13:23
Many temporal schemas appearred on my DB	Angel Alvarez	15:57
Re: Many temporal schemas appearred on my DB	Martijn van Oosterhout	16:17
Re: Many temporal schemas appearred on my DB	Angel Alvarez	16:27
get the array value?	Victor Nawothnig	20:06
Bgwriter and pg_stat_bgwriter.buffers_clean aspects	Dmitry Koterov	21:37
Bgwriter and pg_stat_bgwriter.buffers_clean aspects	Dmitry Koterov	21:43
Bgwriter and pg_stat_bgwriter.buffers_clean aspects	Dmitry Koterov	23:08

Dec. 26, 2008

Thread	Author	Time
Re: Conditional commit inside functions	Gerhard Wiesinger	08:25
Re: Information about Pages, row versions of tables, indices	Gerhard Wiesinger	08:29
Re: Information about Pages, row versions of tables, indices	Pavel Stehule	09:47
Re: Conditional commit inside functions	Pavel Stehule	09:52
Re: Conditional commit inside functions	Gerhard Wiesinger	09:57
Re: get the array value?	Pavel Stehule	10:03
Re: Conditional commit inside functions	Pavel Stehule	10:05
This is a limit-offset bug?	Emanuel Calvo Franco	11:52
Re: Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress	Emanuel Calvo Franco	13:45
count (DISTINCT expression [ , ... ] ) and documentation	Ivan Sergio Borgonovo	14:34
Re: count (DISTINCT expression [ , ... ] ) and documentation	Pavel Stehule	14:46
Re: count (DISTINCT expression [ , ... ] ) and documentation	Ivan Sergio Borgonovo	15:06
Re: count (DISTINCT expression [ , ... ] ) and documentation	Pavel Stehule	15:23
Re: This is a limit-offset bug?	Martijn van Oosterhout	16:46
Re: This is a limit-offset bug?	Emanuel Calvo Franco	17:17
Re: count (DISTINCT expression [ , ... ] ) and documentation	Ivan Sergio Borgonovo	18:14
Re: count (DISTINCT expression [ , ... ] ) and documentation	David Fetter	18:43
Re: count (DISTINCT expression [ , ... ] ) and documentation	Pavel Stehule	18:47
Re: count (DISTINCT expression [ , ... ] ) and documentation	Ivan Sergio Borgonovo	19:03
Re: count (DISTINCT expression [ , ... ] ) and documentation	David Fetter	20:04
Re: lack of consequence with domains and types	Grzegorz Jaśkiewicz	20:08
Re: lack of consequence with domains and types	Merlin Moncure	20:54
Re: lack of consequence with domains and types	Grzegorz Jaśkiewicz	20:57
Re: lack of consequence with domains and types	Merlin Moncure	21:10
WITH AS vs subselect was: count (DISTINCT expression [ , ... ] ) and documentation	Ivan Sergio Borgonovo	22:17

Dec. 27, 2008

Thread	Author	Time
Re: WITH AS vs subselect was: count (DISTINCT expression [ , ... ] ) and documentation	Tom Lane	00:13
"disappearing" rows in temp table, in recursing trigger	Eric Worden	03:15
Bind message has 6 results formats but query has 5 columns	J Ottery	05:47
Re: WITH AS vs subselect was: count (DISTINCT expression [ , ... ] ) and documentation	David Fetter	07:10
Re: "disappearing" rows in temp table, in recursing trigger	Craig Ringer	09:14
subselect and count (DISTINCT expression [ , ... ] ) performances	Ivan Sergio Borgonovo	11:14
Re: Automatic CRL reload	Alvaro Herrera	14:10
Weird query sort	Jeffrey Melloy	22:02

Dec. 28, 2008

Thread	Author	Time
Re: Weird query sort	Tom Lane	00:08
Finding foreign keys that are missing indexes 📎	plu tard	07:00
Re: having two database clusters?	Raymond O'Donnell	16:44
Re: Bind message has 6 results formats but query has 5 columns	Teemu Juntunen	18:22
Re: Finding foreign keys that are missing indexes	Tom Lane	21:31
timestamp differences	Garry Saddington	21:40
Re: timestamp differences	Adrian Klaver	21:53
Re: timestamp differences	Adrian Klaver	21:59
Re: Bgwriter and pg_stat_bgwriter.buffers_clean aspects	Greg Smith	22:04

Dec. 29, 2008

Thread	Author	Time
Re: Finding foreign keys that are missing indexes	plu 12	00:32
Re: Finding foreign keys that are missing indexes	Tom Lane	00:42
Re: having two database clusters?	Grzegorz Jaśkiewicz	10:43
open transaction?	blackwater dev	11:48
Re: open transaction?	Raymond O'Donnell	11:53
Re: open transaction?	Terry Lee Tucker	11:57
Re: open transaction?	Raymond O'Donnell	12:06
Re: encoding of PostgreSQL messages	Alvaro Herrera	12:07
Re: open transaction?	Pavel Stehule	12:22
[PGSQL 8.3.5] Use of a partial indexes	Reg Me Please	14:08
Re: [PGSQL 8.3.5] Use of a partial indexes	Gauthier, Dave	14:24
Re: [PGSQL 8.3.5] Use of a partial indexes	Reg Me Please	14:41
Re: [PGSQL 8.3.5] Use of a partial indexes	Scott Marlowe	15:33
Re: [PGSQL 8.3.5] Use of a partial indexes	Scott Ribe	15:36
Re: [PGSQL 8.3.5] Use of a partial indexes	Scott Marlowe	16:07
Re: [PGSQL 8.3.5] Use of a partial indexes	Scott Ribe	16:28
Re: [PGSQL 8.3.5] Use of a partial indexes	Scott Marlowe	17:07
Re: open transaction?	Bayless Kirtley	17:20
How can the error log be searched?	Rob Richardson	19:28
Re: How can the error log be searched?	Adrian Klaver	21:27
Query planner and foreign key constraints	Christian Schröder	23:13

Dec. 30, 2008

Thread	Author	Time
Re: Query planner and foreign key constraints	Filip Rembiałkowski	02:48
Load Image File From PostgreSQL DB	dbalinglung	06:44
Re: Load Image File From PostgreSQL DB	Julius Tuskenis	07:46
Re: Query planner and foreign key constraints	Christian Schröder	08:34
Re: [PGSQL 8.3.5] Use of a partial indexes	Reg Me Please	09:02
Re: Load Image File From PostgreSQL DB	dbalinglung	10:28
Re: Load Image File From PostgreSQL DB	dbalinglung	11:18
postgres block_size problem	Bhujbal, Santosh	12:28
Re: [PGSQL 8.3.5] Use of a partial indexes	Scott Marlowe	14:12
Re: [PGSQL 8.3.5] Use of a partial indexes	justin	14:18
Re: Load Image File From PostgreSQL DB	Albe Laurenz	15:39
Re: Load Image File From PostgreSQL DB	Julius Tuskenis	16:06
Re: [PGSQL 8.3.5] Use of a partial indexes	Reg Me Please	16:08
Slow Vacuum was: vacuum output question	Dan Armbrust	16:10
Re: Slow Vacuum was: vacuum output question	Scott Marlowe	16:19
Re: [PGSQL 8.3.5] Use of a partial indexes	Picavet Vincent	16:20
Re: Slow Vacuum was: vacuum output question	Dan Armbrust	16:32
Re: Slow Vacuum was: vacuum output question	Dan Armbrust	16:37
Re: Slow Vacuum was: vacuum output question	Scott Marlowe	16:47
Re: Slow Vacuum was: vacuum output question	Scott Marlowe	16:47
Re: Slow Vacuum was: vacuum output question	Andrew Sullivan	16:49
Re: Slow Vacuum was: vacuum output question	Dan Armbrust	17:14
Re: Slow Vacuum was: vacuum output question	Scott Marlowe	18:33
New shapshot RPMs (Dec 29, 2008) are ready for testing	Devrim GÜNDÜZ	20:12
Re: "disappearing" rows in temp table, in recursing trigger	Eric Worden	20:38
return X number of refcursors from a function	Derek Liang	22:33
Re: "disappearing" rows in temp table, in recursing trigger	Tom Lane	22:55

Dec. 31, 2008

Thread	Author	Time
How to use index in strpos function	Tuan Hoang Anh	04:49
Re: How to use index in strpos function	Adam Rich	05:11
Re: [PGSQL 8.3.5] Use of a partial indexes	Reg Me Please	08:39
Re: return X number of refcursors from a function	Albe Laurenz	09:08
Re: Load Image File From PostgreSQL DB	Albe Laurenz	09:17
Re: Load Image File From PostgreSQL DB	Julius Tuskenis	09:36
Re: encoding of PostgreSQL messages	Karsten Hilbert	09:46
Re: encoding of PostgreSQL messages	Tom Lane	16:23
Re: encoding of PostgreSQL messages	Karsten Hilbert	16:57
Re: encoding of PostgreSQL messages	Peter Eisentraut	18:02
Re: encoding of PostgreSQL messages	Karsten Hilbert	18:16
Re: encoding of PostgreSQL messages	Tom Lane	18:23
Re: encoding of PostgreSQL messages	Karsten Hilbert	18:44
Re: encoding of PostgreSQL messages	Karsten Hilbert	18:48
pg_restore question (-T and -t)	Tony Caduto	21:49
General subselect question	Tim Hart	22:57

Jan. 1, 2009

Thread	Author	Time
Re: pg_restore question (-T and -t)	George Pavlov	01:21
Re: pg_restore question (-T and -t)	Martin Gainty	01:37
manage changes to views having depencies	Eric Worden	04:57
Re: manage changes to views having depencies	Scott Marlowe	05:09
Re: postgres block_size problem	Craig Ringer	06:20
How to cast a general record?	Gerhard Heift	13:41
Re: How to cast a general record?	Martin Gainty	14:36
Re: encoding of PostgreSQL messages	Peter Eisentraut	18:33

Jan. 2, 2009

Thread	Author	Time
Re: manage changes to views having depencies	Berend Tober	00:27
Re: How to cast a general record?	Albe Laurenz	07:41
Solution for tranaction independent logging in same database?	Gerhard Heift	08:53
Re: Bind message has 6 results formats but query has 5 columns	J Ottery	10:16
Re: Solution for tranaction independent logging in same database?	Robert Treat	15:01

Jan. 3, 2009

Thread	Author	Time
Unison Protein Database manuscript	Reece Hart	05:35
Re: auto insert data every one minute	searchelite	10:46
Re: auto insert data every one minute	Reg Me Please	11:07
getting elapsed query times	Aaron Burnett	14:36
restore problem with pg_dumpall dump (password authentication fail)	Kenneth Lundin	15:37
Re: restore problem with pg_dumpall dump (password authentication fail)	Tom Lane	16:40
Re: restore problem with pg_dumpall dump (password authentication fail)	Kenneth Lundin	18:43
Re: restore problem with pg_dumpall dump (password authentication fail)	Adrian Klaver	19:18
Per-user schemas with inherited skeleton.	alvarezp	20:59
Re: auto insert data every one minute	Tino Wildenhain	22:52
Timestamp shift when importing data	Jolles, Peter M (GE Infra, Energy)	22:59
Re: Timestamp shift when importing data	Jeremy Harris	23:24
Re: Timestamp shift when importing data	David Wilson	23:26

Jan. 4, 2009

Thread	Author	Time
Re: Query planner and foreign key constraints	Christian Schröder	09:44
Re: PostgreSQL 8.4 download?	Thomas Kellerer	10:33
What determines the cost of an index scan?	Christian Schröder	10:35
Re: auto insert data every one minute	Christophe Chauvet	10:36
Description of transaction model for indexes	Gerhard Wiesinger	11:09
Re: What determines the cost of an index scan?	Martin Gainty	16:59
SPI_ERROR_CONNECT in plperl function	Christian Schröder	20:18
Re: What determines the cost of an index scan?	Gregory Stark	20:47
Re: SPI_ERROR_CONNECT in plperl function	Tom Lane	23:28

Jan. 5, 2009

Thread	Author	Time
waiting on index drop	Rikard Pavelic	00:02
Re: waiting on index drop	Tom Lane	00:36
Re: getting elapsed query times	Craig Ringer	03:01
Re: Per-user schemas with inherited skeleton.	Craig Ringer	04:05
Re: What determines the cost of an index scan?	Craig Ringer	04:24
Re: Timestamp shift when importing data	Jolles, Peter M (GE Infra, Energy)	13:29
Mailing list ?	Mohamed	13:43
Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..	Mohamed	13:49
Vacuum problems	Scot Kreienkamp	14:46
Re: Timestamp shift when importing data	Adrian Klaver	15:09
Re: Vacuum problems	Grzegorz Jaśkiewicz	15:46
Re: Vacuum problems	Grzegorz Jaśkiewicz	16:19
Re: Vacuum problems	Scot Kreienkamp	16:21
Re: Vacuum problems	Scott Marlowe	16:35
Re: Mailing list ?	Scott Marlowe	16:35
Re: does postgres has the same limitation as MySQL?	Chris Browne	17:05
Re: Vacuum problems	Scot Kreienkamp	17:15
Re: Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..	Sam Mason	17:19
Insert into partion table without logic statement	Jolles, Peter M (GE Infra, Energy)	17:26
Re: Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..	Oleg Bartunov	17:27
Re: Vacuum problems	Tom Lane	18:04
Re: Vacuum problems	Scot Kreienkamp	18:29
Re: Vacuum problems	Scott Marlowe	18:36
Re: Vacuum problems	Scott Marlowe	18:40
Re: does postgres has the same limitation as MySQL?	Jonah H. Harris	18:53
Re: Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..	Mohamed	19:19

Jan. 6, 2009

Thread	Author	Time
Re: Per-user schemas with inherited skeleton.	Octavio Alvarez	00:09
Re: lesslog "incorrect resource manager data checksum."	Koichi Suzuki	00:33
Re: Per-user schemas with inherited skeleton.	alvarezp	00:33
Re: Description of transaction model for indexes	Erik Jones	00:41
Replication on windows	Tuan Hoang Anh	03:52
Re: Per-user schemas with inherited skeleton.	Craig Ringer	05:39
ERROR: failed to find conversion function from "unknown" to text	Gurjeet Singh	06:23
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text	Pavel Stehule	06:30
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text	Gurjeet Singh	06:37
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text	Pavel Stehule	06:45
H2 database	Pascal Cohen	08:16
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text	Gurjeet Singh	09:04
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text	Scott Marlowe	09:13
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text	Gurjeet Singh	09:24
Re: H2 database	Scott Marlowe	09:27
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text	Scott Marlowe	09:29
Re: Bgwriter and pg_stat_bgwriter.buffers_clean aspects	Dmitry Koterov	11:23

Browse Archives

Prev | Next