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

Thread Author Time
Re: data from the table is getting dropped when I am restarting my application after making changes in the objects created in my application in play Adrian Klaver 00:43
Re: Trouble with NEW Adrian Klaver 00:47
Re: main log encoding problem Tom Lane 01:42
Re: main log encoding problem Tatsuo Ishii 01:57
Re: problem with dblink and "drop owned by" Tom Lane 02:15
Odd corruption issue reported on dba.stackexchange.com, need advice Craig Ringer 03:35
Re: Segmentation fault Craig Ringer 03:50
Re: data from the table is getting dropped when I am restarting my application after making changes in the objects created in my application in play Craig Ringer 03:55
Re: main log encoding problem Craig Ringer 04:22
Re: Segmentation fault Amod Pandey 05:52
Re: Problem running "ALTER TABLE...", ALTER TABLE waiting Sergey Konoplev 06:03
Re: Segmentation fault Craig Ringer 06:34
Re: main log encoding problem Alexander Law 06:37
Re: Trouble with NEW Alban Hertroys 06:53
Re: main log encoding problem Alexander Law 07:23
Re: main log encoding problem Tatsuo Ishii 07:24
Re: main log encoding problem Tatsuo Ishii 07:49
GENERATED columns Daniel McGreal 08:04
Re: main log encoding problem Alexander Law 08:12
Re: main log encoding problem Alexander Law 08:21
Re: main log encoding problem Tatsuo Ishii 08:28
Re: main log encoding problem Alexander Law 08:40
Re: main log encoding problem Tatsuo Ishii 08:54
Re: [GENERAL] main log encoding problem Alban Hertroys 08:58
Re: [GENERAL] main log encoding problem Alban Hertroys 09:01
Re: How to stop a query younus 09:17
Re: main log encoding problem Alexander Law 09:33
Synchronization Master -> Slave Edson Richter 11:35
Synchronization Master -> Slave (on slow connetion) Edson Richter 11:45
Re: [GENERAL] main log encoding problem Alexander Law 11:50
Re: [GENERAL] main log encoding problem Alban Hertroys 12:16
Re: Synchronization Master -> Slave (on slow connetion) Sergey Konoplev 12:27
Re: Synchronization Master -> Slave (on slow connetion) Sergey Konoplev 12:30
Re: main log encoding problem Craig Ringer 12:31
Re: [GENERAL] main log encoding problem Craig Ringer 12:37
Re: problem with dblink and "drop owned by" James W. Wilson 12:53
Handling error during async query Daniele Varrazzo 13:13
Re: Trouble with NEW Bob Pawley 13:43
Re: Trouble with NEW Adrian Klaver 13:50
Re: GENERATED columns Tom Lane 14:37
Re: Synchronization Master -> Slave Sergey Konoplev 15:15
Re: Trouble with NEW Bob Pawley 15:41
Re: How to stop a query Atri Sharma 16:07
Re: How to stop a query Scott Marlowe 16:21
Re: How to stop a query younus 16:25
Re: How to stop a query Younus 16:30
Default value of serial fields changes after restore Luiz Damim 16:37
Re: Trouble with NEW Adrian Klaver 17:26
Re: Trouble with NEW David Johnston 18:26
Re: Trouble with NEW Adrian Klaver 19:13
Re: Default value of serial fields changes after restore Tom Lane 19:13
Re: Default value of serial fields changes after restore Scott Marlowe 19:19
Re: Default value of serial fields changes after restore Tom Lane 19:32
High CPU on read-only streaming replication server Nick 20:23
Re: High CPU on read-only streaming replication server Nick 20:44
postgres 9 bind address for replication Adam Crews 20:56
Re: High CPU on read-only streaming replication server Nick 21:11

July 20, 2012

Thread Author Time
Problem setting environmental variables for postgresql or plpythonu Mark Wynter 00:57
Re: How to stop a query 📎 Martin French 06:59
Re: Problem setting environmental variables for postgresql or plpythonu Albe Laurenz 07:44
I cannot insert bengali character in UTF8 AI Rumman 10:30
Re: data from the table is getting dropped when I am restarting my application after making changes in the objects created in my application in play Craig Ringer 10:32
Re: I cannot insert bengali character in UTF8 Peter Geoghegan 10:40
Get DB Size by row Benjamin Adams 12:27
Re: I cannot insert bengali character in UTF8 Christian Ullrich 13:11
Select Rows With Only One of Two Values Rich Shepard 15:53
Re: Select Rows With Only One of Two Values Chris Angelico 16:15
Re: Select Rows With Only One of Two Values [RESOLVED] Rich Shepard 16:21
Re: Select Rows With Only One of Two Values [RESOLVED] Chris Angelico 16:25
Re: Select Rows With Only One of Two Values [RESOLVED] Andreas Kretschmer 16:33
Re: Select Rows With Only One of Two Values [RESOLVED] Thomas Kellerer 16:37
big database resulting in small dump Ilya Ivanov 18:05
Re: big database resulting in small dump Lonni J Friedman 18:09
Re: big database resulting in small dump Tom Lane 18:23
Re: big database resulting in small dump Lonni J Friedman 18:26
Re: big database resulting in small dump Ilya Ivanov 18:37
Re: big database resulting in small dump Tom Lane 18:46
Pg_ctl promote -- wait for slave to be promoted fully ? Manoj Govindassamy 19:28
A Better Way? (Multi-Left Join Lookup) David Johnston 20:30
Re: A Better Way? (Multi-Left Join Lookup) Tom Lane 20:46
Re: Select Rows With Only One of Two Values Alban Hertroys 20:52
Re: A Better Way? (Multi-Left Join Lookup) Alban Hertroys 21:02
Re: A Better Way? (Multi-Left Join Lookup) 📎 David Johnston 21:37
Re: A Better Way? (Multi-Left Join Lookup) David Johnston 21:49
Re: I cannot insert bengali character in UTF8 AI Rumman 22:26
Re: A Better Way? (Multi-Left Join Lookup) Tom Lane 22:51
Re: A Better Way? (Multi-Left Join Lookup) David Johnston 23:38

July 21, 2012

Thread Author Time
Re: big database resulting in small dump Craig Ringer 01:41
Re: Select Rows With Only One of Two Values Chris Angelico 01:55
Re: Pg_ctl promote -- wait for slave to be promoted fully ? Chris Angelico 01:57
search_path reset on error (making it not reset) [email protected] 04:42
postgres 9 bind address for replication Adam Crews 05:24
Re: search_path reset on error (making it not reset) Craig Ringer 08:07
Why is an ISO-8859-8 database allowing values not within that set? Herouth Maoz 08:59
Re: High CPU on read-only streaming replication server Craig Ringer 10:22
Re: Get DB Size by row Bill Moran 11:03
postgresql ask for someparameters leo xu 11:22
Re: Why is an ISO-8859-8 database allowing values not within that set? Craig Ringer 12:36
Re: A Better Way? (Multi-Left Join Lookup) Tom Lane 17:36
Re: A Better Way? (Multi-Left Join Lookup) Tom Lane 21:47

July 22, 2012

Thread Author Time
Re: A Better Way? (Multi-Left Join Lookup) David Johnston 00:48
Re: Why is an ISO-8859-8 database allowing values not within that set? Herouth Maoz 07:58
Re: Why is an ISO-8859-8 database allowing values not within that set? Craig Ringer 12:07
How to ;ist all table foreign key dependency relationships Berend Tober 15:53

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

Browse Archives

Prev | Next