pgsql-general since 2012-07-23 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

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

July 23, 2012

Thread Author Time
PL/pgSQL - Help or advice please on using unbound cursors Andrew Hastie 10:35
Re: PL/pgSQL - Help or advice please on using unbound cursors Pavel Stehule 11:14
Problem with 9.1 streaming replication Georges Racinet 12:09
Re: postgres 9 bind address for replication Robert Haas 15:34
General guidance: Levenshtein distance versus other similarity algorithms Rachel Owsley 16:55
Re: Pg_ctl promote -- wait for slave to be promoted fully ? Manoj Govindassamy 17:54
postgres 9 bind address for replication Adam Crews 18:23
Re: postgres 9 bind address for replication Andrew Dunstan 18:45
Reporting tool for Npgsql Marcus Túlio Ramos 18:53
meaning of "waiting" column in pg_stat_activity? Chris Curvey 20:13
Re: meaning of "waiting" column in pg_stat_activity? Guillaume Lelarge 20:46

July 24, 2012

Thread Author Time
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Jeff Davis 00:48
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Craig Ringer 01:16
Re: postgres 9 bind address for replication Adam Crews 02:02
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) Jasen Betts 08:39
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Marcin Mańk 09:31
can't compile twitter_fdw Maximilian Tyrtania 10:34
how to connect to oracle database Pawel Kopka 11:49
Re: how to connect to oracle database Pavel Stehule 12:03
Roles with empty password (probably bug in libpq and in psql as well). Dmitriy Igrishin 12:41
Re: Roles with empty password (probably bug in libpq and in psql as well). Guillaume Lelarge 13:16
Re: Roles with empty password (probably bug in libpq and in psql as well). Dmitriy Igrishin 13:36
Re: Roles with empty password (probably bug in libpq and in psql as well). Guillaume Lelarge 13:40
Re: Roles with empty password (probably bug in libpq and in psql as well). Dmitriy Igrishin 13:48
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Craig Ringer 13:48
9.1.4: pg_restore: couldn't uncompress data? Larry Rosenman 13:50
Re: Roles with empty password (probably bug in libpq and in psql as well). Dmitriy Igrishin 14:00
Re: Roles with empty password (probably bug in libpq and in psql as well). David Johnston 14:18
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Scott Marlowe 14:20
Re: Roles with empty password (probably bug in libpq and in psql as well). Adrian Klaver 14:31
Re: Roles with empty password (probably bug in libpq and in psql as well). Tom Lane 14:36
Problem using a pl/pgsql function to populate a geometry column with x, y data Mark Wynter 14:39
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Tom Lane 14:45
Re: Roles with empty password (probably bug in libpq and in psql as well). Dmitriy Igrishin 14:48
Re: Roles with empty password (probably bug in libpq and in psql as well). Tom Lane 16:14
Re: Roles with empty password (probably bug in libpq and in psql as well). Dmitriy Igrishin 16:53
insert binary data into a table column with psql jkells 20:28
Pg 9.1: Do I need to run vacuum analyze instead vacuum full? Edson Richter 20:36
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? François Beausoleil 21:15
Re: insert binary data into a table column with psql John R Pierce 21:22
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? John R Pierce 21:23
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? Edson Richter 21:29
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? Edson Richter 21:29
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? Edson Richter 21:30
Re: insert binary data into a table column with psql Lonni J Friedman 21:37
Smaller data types use same disk space McGehee, Robert 22:21
Re: Problem using a pl/pgsql function to populate a geometry column with x, y data - SOLVED Mark Wynter 23:01
Re: Problem using a pl/pgsql function to populate a geometry column with x, y data - SOLVED Mark Wynter 23:16
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? Anthony Bull 23:43

July 25, 2012

Thread Author Time
Re: Pg 9.1: Do I need to run vacuum analyze instead vacuum full? Scott Marlowe 00:02
Re: Smaller data types use same disk space Adrian Klaver 00:46
Re: Smaller data types use same disk space Steve Crawford 00:54
Re: insert binary data into a table column with psql jtkells 01:43
Re: Smaller data types use same disk space Tom Lane 02:00
Re: insert binary data into a table column with psql Tom Lane 02:16
Re: insert binary data into a table column with psql Lonni J Friedman 02:24
Mutable tables Jeff Davis 04:49
Re: insert binary data into a table column with psql Thomas Kellerer 07:12
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Marcin Mańk 07:41
Re: Odd corruption issue reported on dba.stackexchange.com, need advice Marcin Mańk 07:47
Full text search ts_heading strange result Johann Spies 08:26
how to calculate or know seq_scan scan how many blocks every time leo xu 11:38
Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding Alexander Law 11:54
Re: PL/pgSQL - Help or advice please on using unbound cursors Andrew Hastie 13:35
upgrade causes psql to not work BJ Freeman 14:57
Re: upgrade causes psql to not work Merlin Moncure 15:16
Re: upgrade causes psql to not work BJ Freeman 15:48
Re: Smaller data types use same disk space McGehee, Robert 16:09
Install pgbench on the client server.Please helps thanks. leaf_yxj 16:16
Re: upgrade causes psql to not work Merlin Moncure 16:42
Re: upgrade causes psql to not work Merlin Moncure 16:42
BI tools and postgresql Mark Phillips 17:41
Re: BI tools and postgresql Henry Drexler 18:07
Re: General guidance: Levenshtein distance versus other similarity algorithms Merlin Moncure 18:31
Re: General guidance: Levenshtein distance versus other similarity algorithms Rachel Owsley 20:15
Re: Smaller data types use same disk space Tom Lane 20:35
Re: BI tools and postgresql Mark Phillips 20:49
Re: BI tools and postgresql Seref Arikan 21:12
Re: Smaller data types use same disk space Gavin Flower 21:17
Re: Smaller data types use same disk space Mike Christensen 22:20
Re: Smaller data types use same disk space Merlin Moncure 22:49
Re: Full text search ts_heading strange result Tom Lane 23:04
Re: Smaller data types use same disk space Tom Lane 23:12

July 26, 2012

Thread Author Time
Re: Smaller data types use same disk space Craig Ringer 00:13
View definition and schema search path bug or expected behaviour? Chris Bartlett 02:25
Re: View definition and schema search path bug or expected behaviour? Adrian Klaver 02:37
Re: View definition and schema search path bug or expected behaviour? Chris Bartlett 02:47
Re: View definition and schema search path bug or expected behaviour? Adrian Klaver 02:51
Re: View definition and schema search path bug or expected behaviour? Chris Bartlett 03:19
Re: FATAL: no pg_hba.conf entry for host “::1” saleem 06:11
Re: Full text search ts_heading strange result Johann Spies 06:14
Re: Full text search ts_heading strange result Craig Ringer 08:19
Re: Smaller data types use same disk space Marc Mamin 08:27
Re: Full text search ts_heading strange result Johann Spies 08:55
File system level backup Manoj Agarwal 10:39
Re: BI tools and postgresql Chris Curvey 12:17
Re: BI tools and postgresql Seref Arikan 12:45
Re: BI tools and postgresql Peter Bex 13:07
Re: BI tools and postgresql Gabriele Bartolini 13:21
Re: Reporting tool for Npgsql Vincent Veyron 13:46
Re: BI tools and postgresql Vincent Veyron 14:04
Re: View definition and schema search path bug or expected behaviour? Adrian Klaver 14:14
Re: BI tools and postgresql Vincent Veyron 14:34
Re: Full text search ts_heading strange result Tom Lane 14:41
WAL tuning advice Joseph Marlin 14:59
Re: BI tools and postgresql Merlin Moncure 15:02
FATAL : could not read directory base": Invalid argument Abraham, Danny 15:27
Re: Smaller data types use same disk space Mike Christensen 16:02
Re: how to calculate or know seq_scan scan how many blocks every time leo xu 16:05
Re: Smaller data types use same disk space Merlin Moncure 16:12
Re: Smaller data types use same disk space Tom Lane 16:19
Re: Smaller data types use same disk space Mike Christensen 16:20
Re: PostgreSQL limitations question Bruce Momjian 16:37
Re: Smaller data types use same disk space Merlin Moncure 16:42
Re: Smaller data types use same disk space Daniel Verite 17:08
Re: upgrade causes psql to not work BJ Freeman 17:59
Re: BI tools and postgresql Vincent Veyron 18:04
Re: File system level backup Lonni J Friedman 18:36
Re: File system level backup Thomas Kellerer 18:45
Re: PostgreSQL limitations question Bartosz Dmytrak 21:06
Re: PostgreSQL limitations question Jaime Casanova 21:27
log select access Little, Douglas 21:32
Re: log select access Merlin Moncure 21:59
postgres maintenance db hartrc 22:07
Schema-only dump dumps no constraints, no triggers Marek Kielar 23:09
Re: Replication/cloning: rsync vs modification dates? Bruce Momjian 23:53
Re: Replication/cloning: rsync vs modification dates? Chris Angelico 23:57

July 27, 2012

Thread Author Time
Re: [GENERAL] Where is diskchecker.pl ? Bruce Momjian 00:35
Re: FATAL : could not read directory base": Invalid argument Craig Ringer 00:38
Re: how to calculate or know seq_scan scan how many blocks every time Craig Ringer 00:40
Re: [GENERAL] Where is diskchecker.pl ? Josh Berkus 01:05
Re: [GENERAL] Where is diskchecker.pl ? Josh Berkus 01:07
Re: [GENERAL] Where is diskchecker.pl ? Bruce Momjian 01:11
Re: Replication/cloning: rsync vs modification dates? Bruce Momjian 01:12
Re: [GENERAL] Where is diskchecker.pl ? 📎 Bruce Momjian 01:26
Re: Where is diskchecker.pl ? Bruce Momjian 01:27
答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time leoxu 02:04
Re: upgrade causes psql to not work Adrian Klaver 02:32
Re: Schema-only dump dumps no constraints, no triggers Adrian Klaver 02:46
Re: 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time Craig Ringer 03:00
Re: postgres maintenance db Ondrej Ivanič 04:06
Re: Replication/cloning: rsync vs modification dates? Chris Angelico 04:13
Terminating a rogue connection Mark Morgan Lloyd 08:27
Re: Terminating a rogue connection Chris Angelico 08:33
Re: Terminating a rogue connection Bèrto ëd Sèra 08:41
Re: Terminating a rogue connection Mark Morgan Lloyd 09:09
Re: postgres maintenance db Guillaume Lelarge 09:38
Re: BI tools and postgresql Jacqui Caren 10:13
information_schema.referential_constraints broken? Igor Neyman 13:26
Switching from OSX to Linux, multi-line queries in \copy don't work anymore Ryan Kelly 13:28
Re: Switching from OSX to Linux, multi-line queries in \copy don't work anymore Craig Ringer 13:49
Re: Switching from OSX to Linux, multi-line queries in \copy don't work anymore Mark Morgan Lloyd 14:06
Re: Switching from OSX to Linux, multi-line queries in \copy don't work anymore Ryan Kelly 14:19
Re: Terminating a rogue connection Chris Angelico 14:21
Re: Switching from OSX to Linux, multi-line queries in \copy don't work anymore Ryan Kelly 14:27
Re: information_schema.referential_constraints broken? Igor Neyman 14:47
Re: Terminating a rogue connection Mark Morgan Lloyd 15:17
Adding users connection via SSL Mark Morgan Lloyd 15:22
fgets failure in Solaris after patching Stephan, Richard 15:23
Re: postgres maintenance db Steve Crawford 16:15
Re: Schema-only dump dumps no constraints, no triggers Marek Kielar 16:32
Re: information_schema.referential_constraints broken? Tom Lane 16:57
REINDEX and COPY is wainting since Jun 21! Ing.Edmundo.Robles.Lopez 16:59
can we avoid pg_basebackup on planned switches? Ben Chobot 17:00
Re: Switching from OSX to Linux, multi-line queries in \copy don't work anymore Tom Lane 17:06
Re: fgets failure in Solaris after patching Tom Lane 17:21
Re: REINDEX and COPY is wainting since Jun 21! Alan Hodgson 17:26
Re: BI tools and postgresql Daoud Abdelmonem Faleh 17:35
Re: Switching from OSX to Linux, multi-line queries in \copy don't work anymore Merlin Moncure 17:56
Re: fgets failure in Solaris after patching Stephan, Richard 18:13
Re: REINDEX and COPY is wainting since Jun 21! Ing.Edmundo.Robles.Lopez 18:27
Re: REINDEX and COPY is wainting since Jun 21! Ing.Edmundo.Robles.Lopez 18:29
Re: fgets failure in Solaris after patching Tom Lane 19:25
Postgresql Developer Privileges hartrc 19:30
Re: Postgresql Developer Privileges John R Pierce 19:48
Re: Schema-only dump dumps no constraints, no triggers Adrian Klaver 23:10
Trim not working (PostgreSQL 9.1.2 on Win64) Edson Richter 23:58

July 28, 2012

Thread Author Time
Trim not working (PostgreSQL 9.1.2 on Win64) Edson Richter 00:04
Elegant method of accessing N-dimension array in C function Bborie Park 00:49
Re: Trim not working (PostgreSQL 9.1.2 on Win64) Edson Richter 01:42
Re: FATAL : could not read directory base": Invalid argument Christian Ullrich 12:30
Re: BI tools and postgresql Mark Phillips 16:39
Re: Trim not working (PostgreSQL 9.1.2 on Win64) Adrian Klaver 16:46
Re: Replication/cloning: rsync vs modification dates? Bruce Momjian 21:54
Re: Trim not working (PostgreSQL 9.1.2 on Win64) Edson Richter 22:20
Re: Trim not working (PostgreSQL 9.1.2 on Win64) Tom Lane 22:41
Re: Trim not working (PostgreSQL 9.1.2 on Win64) Adrian Klaver 23:18

July 29, 2012

Thread Author Time
Re: Trim not working (PostgreSQL 9.1.2 on Win64) Edson Richter 00:53
Re: Trim not working (PostgreSQL 9.1.2 on Win64) Edson Richter 01:24
array_length of an empty array John R Pierce 08:03
Re: BI tools and postgresql Vincent Veyron 09:56
Re: Schema-only dump dumps no constraints, no triggers Marek Kielar 10:29
Re: BI tools and postgresql Alban Hertroys 10:47
Re: BI tools and postgresql Jacqui Caren 11:00
Re: BI tools and postgresql Vincent Veyron 12:16
Re: array_length of an empty array Ryan Kelly 13:55
Re: array_length of an empty array Tom Lane 15:10
password help Guillermo Echevarria Quintana-Gurt 18:30
Enums documentation "glitch" Edson Richter 18:48
Re: Enums documentation "glitch" Edson Richter 18:56

Browse Archives

Prev | Next