Postgresql General Discussion

• Thread Index

• Re: design help for performance
  • From: Misa Simic
• Re: Why vacumming performed on template1 with initdb command ?
  • From: Tom Lane
• Re: Escaping input from COPY
  • From: Roger Leigh
• Re: [partition table] python fetchall or fetchone function can not get the returning rows
  • From: Misa Simic
• Re: Escaping input from COPY
  • From: Josh Kupershmidt
• Re: fsync on ext4 does not work
  • From: Havasvölgyi Ottó
• Why vacumming performed on template1 with initdb command ?
  • From: Raghavendra
• [partition table] python fetchall or fetchone function can not get the returning rows
  • From: Xiaoning Xu
• Re: How to escape to quotes on Insert into?
  • From: Andre Lopes
• Re: design help for performance
  • From: Culley Harrelson
• Re: How to escape to quotes on Insert into?
  • From: Bill Moran
• How to escape to quotes on Insert into?
  • From: Andre Lopes
• Re: How to create database with default system locale is set to et_EE.UTF-8
  • From: Adrian Klaver
• Re: Postgres Logs question
  • From: akp geek
• [partition table] fetchall or fetchone function can not get the returning rows
  • From: Xiaoning Xu
• How to create database with default system locale is set to et_EE.UTF-8
  • From: Andrus
• Re: out of memory error with loading pg_dumpall
  • From: Tom Lane
• Re: can not use the column after rename
  • From: Tom Lane
• Re: out of memory error with loading pg_dumpall
  • From: Dara Olson
• Re: Cannot connect to 2nd cluster database remotely
  • From: devrim
• Re: can not use the column after rename
  • From: David Johnston
• Re: Cannot connect to 2nd cluster database remotely
  • From: Jacques Lamothe
• Re: Cannot connect to 2nd cluster database remotely
  • From: Devrim GÜNDÜZ
• Re: can not use the column after rename
  • From: Marti Raudsepp
• Cannot connect to 2nd cluster database remotely
  • From: Jacques Lamothe
• Re: can not use the column after rename
  • From: salah jubeh
• Re: can not use the column after rename
  • From: Simon Tokumine
• can not use the column after rename
  • From: salah jubeh
• Re: design help for performance
  • From: Marc Mamin
• Re: design help for performance
  • From: Alban Hertroys
• Re: out of memory error with loading pg_dumpall
  • From: Tom Lane
• Re: Escaping input from COPY
  • From: Adrian Klaver
• Re: design help for performance
  • From: Culley Harrelson
• Re: design help for performance
  • From: David Johnston
• Re: PostgreSQL server architecture
  • From: John R Pierce
• Re: design help for performance
  • From: Misa Simic
• Re: PostgreSQL server architecture
  • From: Craig Ringer
• design help for performance
  • From: Culley Harrelson
• Re: Escaping input from COPY
  • From: Josh Kupershmidt
• Re: Postgres Logs question
  • From: Chris Travers
• Re: General coding question
  • From: David Johnston
• Re: General coding question
  • From: jkells
• out of memory error with loading pg_dumpall
  • From: Dara Olson
• Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade
  • From: Tom Lane
• Re: PostgreSQL server architecture
  • From: Bill Moran
• Postgres Logs question
  • From: akp geek
• PostgreSQL server architecture
  • From: James B. Byrne
• Re: General coding question
  • From: Bill Moran
• Re: General coding question
  • From: David Johnston
• General coding question
  • From: jkells
• Re: segfault with plproxy
  • From: Filip Rembiałkowski
• Re: How To Handle Hung Connections
  • From: Mike Blackwell
• How To Handle Hung Connections
  • From: Carlos Mennens
• Re: pg_restore should restore the schema comments and the database properties
  • From: Adrian Klaver
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Joe Miller
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Alban Hertroys
• Re: pg_restore should restore the schema comments and the database properties
  • From: Alban Hertroys
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Merlin Moncure
• Re: Cisco Systems fail
  • From: Christian Ramseyer
• Re: segfault with plproxy
  • From: Marko Kreen
• Re: pg_restore should restore the schema comments and the database properties
  • From: Adrian Klaver
• Re: pg_restore should restore the schema comments and the database properties
  • From: Adrian Klaver
• Re: fsync on ext4 does not work
  • From: Greg Smith
• Re: using pg's internal timezone database?
  • From: Scott Marlowe
• pg_restore should restore the schema comments and the database properties
  • From: Daniel Migowski
• Re: fsync on ext4 does not work
  • From: Florian Weimer
• using pg's internal timezone database?
  • From: Louis-David Mitterrand
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Adrian Klaver
• Re: Feature Request: Better handling of foreign keys in DELETE statements
  • From: Hannes Erven
• Re: fsync on ext4 does not work
  • From: Havasvölgyi Ottó
• Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
  • From: Tom Lane
• Re: fsync on ext4 does not work
  • From: Havasvölgyi Ottó
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: MURAT KOÇ
• Re: indexes and tables
  • From: Alan Hodgson
• Re: Feature Request: Better handling of foreign keys in DELETE statements
  • From: Pavel Stehule
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Adrian Klaver
• Re: recovery_target_timeline and multiple slave behavior when master fails
  • From: Rick Pufky
• Re: Feature Request: Better handling of foreign keys in DELETE statements
  • From: Marti Raudsepp
• Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
  • From: Patrick Kevin McCaffrey
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Magnus Hagander
• Re: Feature Request: Better handling of foreign keys in DELETE statements
  • From: Pavel Stehule
• Re: Feature Request: Better handling of foreign keys in DELETE statements
  • From: Chris Angelico
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Alban Hertroys
• Re: fsync on ext4 does not work
  • From: Florian Weimer
• Feature Request: Better handling of foreign keys in DELETE statements
  • From: Daniel Migowski
• Re: fsync on ext4 does not work
  • From: Tomas Vondra
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: MURAT KOÇ
• fsync on ext4 does not work
  • From: Havasvölgyi Ottó
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Adrian Klaver
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Guillaume Lelarge
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Alban Hertroys
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: MURAT KOÇ
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: MURAT KOÇ
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Adrian Klaver
• Re: Changing Passwords as Encrypted not Clear-Text
  • From: Guillaume Lelarge
• Fwd: consecutive analyze calls with different column lists.
  • From: David Johnston
• Re: ignore duplicate key while using COPY?
  • From: Adrian Klaver
• consecutive analyze calls with different column lists.
  • From: Marc Mamin
• Re: Logical Aggregate Functions (eg ANY())
  • From: Merlin Moncure
• Changing Passwords as Encrypted not Clear-Text
  • From: MURAT KOÇ
• Re: segfault with plproxy
  • From: Filip Rembiałkowski
• Re: segfault with plproxy
  • From: Filip Rembiałkowski
• Escaping input from COPY
  • From: Roger Leigh
• Re: Logical Aggregate Functions (eg ANY())
  • From: Marti Raudsepp
• Re: segfault with plproxy
  • From: Marko Kreen
• Re: indexes and tables
  • From: Misa Simic
• Re: [pgeu-general] REMINDER: FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers
  • From: Emanuel Calvo
• Re: How to make a non-removable row in a table?
  • From: Thomas Markus
• Re: How to make a non-removable row in a table?
  • From: Капралов Александр
• Re: ignore duplicate key while using COPY?
  • From: David Johnston
• Re: How to make a non-removable row in a table?
  • From: Thomas Markus
• ignore duplicate key while using COPY?
  • From: Yan Chunlu
• How to make a non-removable row in a table?
  • From: Капралов Александр
• Re: pg_dump and pg_restore make data dir doubled size?
  • From: Yan Chunlu
• Re: indexes and tables
  • From: amit sehas
• Re: Logical Aggregate Functions (eg ANY())
  • From: Merlin Moncure
• Re: recovery_target_timeline and multiple slave behavior when master fails
  • From: Fujii Masao
• Re: indexes and tables
  • From: David Johnston
• Re: indexes and tables
  • From: David Johnston
• Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
  • From: Steve Atkins
• New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
  • From: Patrick Kevin McCaffrey
• indexes and tables
  • From: amit sehas
• recovery_target_timeline and multiple slave behavior when master fails
  • From: Rick Pufky
• pg_dump and pg_restore make data dir doubled size?
  • From: Yan Chunlu
• Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
  • From: Tom Lane
• Re: Performance question: Commit or rollback?
  • From: Chris Angelico
• Re: Performance question: Commit or rollback?
  • From: Chris Travers
• Performance question: Commit or rollback?
  • From: Chris Angelico
• Re: Logical Aggregate Functions (eg ANY())
  • From: Robert James
• Re: CREATE OR REPLACE AGGREGATE
  • From: Robert James
• segfault with plproxy
  • From: Filip Rembiałkowski
• Re: LOCK DATABASE
  • From: Josh Kupershmidt
• REMINDER: FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers
  • From: Andreas 'ads' Scherbaum
• New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
  • From: Patrick Kevin McCaffrey
• PQreset needs to be executed twice to really connect to the postgresql database
  • From: ChoonSoo Park
• disable autovacuum per-database?
  • From: Mike Blackwell
• Re: question about \encoding option of psql
  • From: Adrian Klaver
• Permission denied on relation
  • From: Radosław Smogura
• Re: Vacuum and Large Objects
  • From: Igor Neyman
• Re: question about \encoding option of psql
  • From: Xiaobo Gu
• Re: null tablespace?
  • From: Raghavendra
• Re: null tablespace?
  • From: Tony Capobianco
• Re: Philosophical question
  • From: Chris Angelico
• Re: Logical Aggregate Functions (eg ANY())
  • From: Marti Raudsepp
• Re: LOCK DATABASE
  • From: Scott Marlowe
• Re: null tablespace?
  • From: Raghavendra
• Re: Logical Aggregate Functions (eg ANY())
  • From: Kirill Simonov
• null tablespace?
  • From: Tony Capobianco
• Re: CREATE OR REPLACE AGGREGATE
  • From: Merlin Moncure
• CREATE OR REPLACE AGGREGATE
  • From: Robert James
• LOCK DATABASE
  • From: Eliot Gable
• Re: Logical Aggregate Functions (eg ANY())
  • From: Merlin Moncure
• Re: Streaming Replication Configuration
  • From: Raymond O'Donnell
• Re: Streaming Replication Configuration
  • From: Gabriele Bartolini
• Re: Streaming Replication Configuration
  • From: Gabriele Bartolini
• Re: Streaming Replication Configuration
  • From: Raymond O'Donnell
• Re: Double Denormalizing in Postgres
  • From: David Johnston
• Streaming Replication Configuration
  • From: Carlos Mennens
• Re: Double Denormalizing in Postgres
  • From: Pavel Stehule
• Re: Philosophical question
  • From: Scott Marlowe
• Double Denormalizing in Postgres
  • From: Robert James
• Re: Server/Data Migration Advice
  • From: Adrian Klaver
• Re: Server/Data Migration Advice
  • From: Carlos Mennens
• Logical Aggregate Functions (eg ANY())
  • From: Robert James
• Re: Server/Data Migration Advice
  • From: Raymond O'Donnell
• Re: Server/Data Migration Advice
  • From: Carlos Mennens
• Re: Correct syntax to create partial index on a boolean column
  • From: Jay Levitt
• Re: Correct syntax to create partial index on a boolean column
  • From: Tom Lane
• Re: Server/Data Migration Advice
  • From: Adrian Klaver
• Re: Correct syntax to create partial index on a boolean column
  • From: Mike Christensen
• Re: Server/Data Migration Advice
  • From: Carlos Mennens
• Re: question about \encoding option of psql
  • From: Adrian Klaver
• Re: Server/Data Migration Advice
  • From: Adrian Klaver
• Re: Correct syntax to create partial index on a boolean column
  • From: Craig Ringer
• Re: Server/Data Migration Advice
  • From: Bèrto ëd Sèra
• Re: Server/Data Migration Advice
  • From: Carlos Mennens
• Re: Philosophical question
  • From: Chris Travers
• Re: Controlling complexity in queries
  • From: Bèrto ëd Sèra
• Re: Philosophical question
  • From: Andreas
• Re: Controlling complexity in queries
  • From: Harald Fuchs
• Re: question about \encoding option of psql
  • From: Guillaume Lelarge
• Re: Philosophical question
  • From: Bèrto ëd Sèra
• Re: Correct syntax to create partial index on a boolean column
  • From: Albe Laurenz
• Re: Locking Tables & Backup Inquiry
  • From: Albe Laurenz
• Re: Correct syntax to create partial index on a boolean column
  • From: Alban Hertroys
• Re: Correct syntax to create partial index on a boolean column
  • From: Mike Christensen
• Re: question about \encoding option of psql
  • From: John R Pierce
• question about \encoding option of psql
  • From: Xiaobo Gu
• Re: Correct syntax to create partial index on a boolean column
  • From: Mike Christensen
• Re: Philosophical question
  • From: Chris Angelico
• Re: Philosophical question
  • From: Chris Travers
• Re: Philosophical question
  • From: Darren Duncan
• Correct syntax to create partial index on a boolean column
  • From: Mike Christensen
• Re: Philosophical question
  • From: Darren Duncan
• Re: Philosophical question
  • From: Chris Angelico
• Re: Controlling complexity in queries
  • From: Jay Levitt
• Re: Philosophical question
  • From: Edson Richter
• Re: Philosophical question
  • From: Craig Ringer
• Re: Vacuum and Large Objects
  • From: Craig Ringer
• Re: Philosophical question
  • From: Chris Travers
• Re: Philosophical question
  • From: Leif Biberg Kristensen
• Re: Controlling complexity in queries
  • From: Alban Hertroys
• Re: Philosophical question
  • From: David Owen
• Re: Philosophical question
  • From: Chris Angelico
• Re: when was pg_stat_reset() used in my server for the last time
  • From: Marti Raudsepp
• Re: Controlling complexity in queries
  • From: Jay Levitt
• Vacuum and Large Objects
  • From: Simon Windsor
• Re: why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org?
  • From: Magnus Hagander
• Re: Locking Tables & Backup Inquiry
  • From: Andy Colson
• Re: Locking Tables & Backup Inquiry
  • From: Carlos Mennens
• Re: Locking Tables & Backup Inquiry
  • From: Andy Colson
• Re: Locking Tables & Backup Inquiry
  • From: Carlos Mennens
• Re: Locking Tables & Backup Inquiry
  • From: Andy Colson
• Cisco Systems fail
  • From: Ray Stell
• Locking Tables & Backup Inquiry
  • From: Carlos Mennens
• Re: Philosophical question
  • From: Andreas
• Re: Philosophical question
  • From: Albe Laurenz
• Re: Controlling complexity in queries
  • From: Merlin Moncure
• Re: why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org?
  • From: Tom Lane
• Copying timeline history file to standby
  • From: senthilnathan
• Re: Postgresql connect into windows server
  • From: Yuriy Rusinov
• Re: Philosophical question
  • From: Chris Travers
• Re: Philosophical question
  • From: Craig Ringer
• Re: Philosophical question
  • From: Serge Fonville
• Philosophical question
  • From: Andreas
• Re: why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org?
  • From: Raymond O'Donnell
• why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org?
  • From: sunpeng
• when was pg_stat_reset() used in my server for the last time
  • From: AI Rumman
• Re: Postgresql connect into windows server
  • From: David Johnston
• : streaming replication on PG-9.1.1
  • From: Venkat Balaji
• Re: Postgresql connect into windows server
  • From: Yuriy Rusinov
• Re: Postgresql connect into windows server
  • From: John R Pierce
• Postgresql connect into windows server
  • From: Yuriy Rusinov
• Re: Having Issue Getting the Postgresql Service to Start
  • From: Craig Ringer
• Question about HoT updates and conditional indexes
  • From: Maxim Boguk
• PGDay.SoCal @ SCALE 10X
  • From: joe . conway
• PGDay.SoCal @ SCALE 10X
  • From: Joe Conway
• Re: Hope for a new PostgreSQL era?
  • From: Greg Smith
• Re: Controlling complexity in queries
  • From: Jay Levitt
• Re: query for all values linked to a field
  • From: anisoptera
• Re: query for all values linked to a field
  • From: Merlin Moncure
• query for all values linked to a field
  • From: anisoptera
• Re: order of (escaped) characters in regex range
  • From: Rob Marjot
• Re: order of (escaped) characters in regex range
  • From: Merlin Moncure
• Re: initdb with lc-collate=C
  • From: Scot Kreienkamp
• Re: order of (escaped) characters in regex range
  • From: David Johnston
• Re: order of (escaped) characters in regex range
  • From: Merlin Moncure
• Re: Having Issue Getting the Postgresql Service to Start
  • From: Sogard, Michael (DPS)
• Re: order of (escaped) characters in regex range
  • From: hubert depesz lubaczewski
• Re: order of (escaped) characters in regex range
  • From: InterRob
• Re: order of (escaped) characters in regex range
  • From: David Johnston
• Re: order of (escaped) characters in regex range
  • From: InterRob
• Re: order of (escaped) characters in regex range
  • From: Szymon Guz
• order of (escaped) characters in regex range
  • From: InterRob
• Re: WAL file accumulation on log shipping primary node
  • From: Dave Cramer
• Re: initdb with lc-collate=C
  • From: Tom Lane
• Re: WAL file accumulation on log shipping primary node
  • From: Dong Han
• Re: Hope for a new PostgreSQL era?
  • From: Jayadevan M
• Re: initdb with lc-collate=C
  • From: Scot Kreienkamp
• Re: WAL file accumulation on log shipping primary node
  • From: Dave Cramer
• Re: WAL file accumulation on log shipping primary node
  • From: Dong Han
• Re: Consecutive operators not recognized without whitespace
  • From: Tom Lane
• Re: Having Issue Getting the Postgresql Service to Start
  • From: Craig Ringer
• Consecutive operators not recognized without whitespace
  • From: Chris Angelico
• Re: initdb with lc-collate=C
  • From: Adrian Klaver
• Re: initdb with lc-collate=C
  • From: Adrian Klaver
• Re: initdb with lc-collate=C
  • From: Scot Kreienkamp
• Re: initdb with lc-collate=C
  • From: Adrian Klaver
• Re: initdb with lc-collate=C
  • From: Adrian Klaver
• Re: Statistics mismatch between n_live_tup and actual row count
  • From: Andreas Brandl
• initdb with lc-collate=C
  • From: Scot Kreienkamp
• psql latex and newlines
  • From: Wim Bertels
• Re: Problem installing PG9.1 using yum
  • From: Wojciech Strzałka
• Re: Question regarding authentication/login
  • From: Chris Deadlock
• Re: Server/Data Migration Advice
  • From: Carlos Mennens
• Re: Server/Data Migration Advice
  • From: Cédric Villemain
• Re: Server/Data Migration Advice
  • From: Andreas Kretschmer
• Server/Data Migration Advice
  • From: Carlos Mennens
• Re: Having Issue Getting the Postgresql Service to Start
  • From: Sogard, Michael (DPS)
• Re: sort order
  • From: Abraham, Danny
• Re: sort order
  • From: Adrian Klaver
• Re: sort order
  • From: Tom Lane
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Joe Miller
• Re: sort order
  • From: Abraham, Danny
• Re: sort order
  • From: Adrian Klaver
• Re: Having Issue Getting the Postgresql Service to Start
  • From: Sachin Srivastava
• Re: initdb locale WIN1252
  • From: Adrian Klaver
• Re: Controlling complexity in queries
  • From: Merlin Moncure
• Re: Problem installing PG9.1 using yum
  • From: devrim
• Having Issue Getting the Postgresql Service to Start
  • From: Sogard, Michael (DPS)
• Re: Problem installing PG9.1 using yum
  • From: Devrim GÜNDÜZ
• Re: Problem installing PG9.1 using yum
  • From: Wojciech Strzałka
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Cédric Villemain
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Mark Morgan Lloyd
• Re: Hope for a new PostgreSQL era?
  • From: Chris Curvey
• Re: Hope for a new PostgreSQL era?
  • From: Greg Smith
• Re: Hope for a new PostgreSQL era?
  • From: Greg Smith
• Re: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache?
  • From: Cédric Villemain
• Re: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache?
  • From: Raghavendra
• Re: Hope for a new PostgreSQL era?
  • From: Ondrej Ivanič
• Re: Hope for a new PostgreSQL era?
  • From: Jayadevan M
• Re: Problem installing PG9.1 using yum
  • From: devrim
• Re: Controlling complexity in queries
  • From: Craig Ringer
• Re: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache?
  • From: Craig Ringer
• Re: Controlling complexity in queries
  • From: David Johnston
• Controlling complexity in queries
  • From: Robert James
• Re: Denormalizing via SQL
  • From: David Johnston
• Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache?
  • From: Stefan Keller
• Denormalizing via SQL
  • From: Robert James
• Re: Hope for a new PostgreSQL era?
  • From: Eduardo Morras
• Re: Hope for a new PostgreSQL era?
  • From: Satoshi Nagayasu
• Re: Problem installing PG9.1 using yum
  • From: Devrim GÜNDÜZ
• Postgresql featured on Hacker News
  • From: Vincent Veyron
• Problem installing PG9.1 using yum
  • From: wstrzalka
• Re: Improve replication usability
  • From: Magnus Hagander
• initdb locale WIN1252
  • From: Abraham, Danny
• sort order
  • From: Abraham, Danny
• Improve replication usability
  • From: Andrew Armstrong
• Re: Hope for a new PostgreSQL era?
  • From: Greg Smith
• Re: Hope for a new PostgreSQL era?
  • From: Scott Marlowe
• Re: Hope for a new PostgreSQL era?
  • From: Craig Ringer
• Re: Why does aggregate query allow select of non-group by or aggregate values?
  • From: Jack Christensen
• Re: Statistics mismatch between n_live_tup and actual row count
  • From: Tom Lane
• Re: Statistics mismatch between n_live_tup and actual row count
  • From: Andreas Brandl
• Re: How could I find the last modified procedure in the database?
  • From: Jasen Betts
• Re: Question regarding authentication/login
  • From: Craig Ringer
• Re: Hope for a new PostgreSQL era?
  • From: Greg Smith
• Re: Why does aggregate query allow select of non-group by or aggregate values?
  • From: Adrian Klaver
• Re: Why does aggregate query allow select of non-group by or aggregate values?
  • From: David Johnston
• Re: Why does aggregate query allow select of non-group by or aggregate values?
  • From: Henry Drexler
• Why does aggregate query allow select of non-group by or aggregate values?
  • From: Jack Christensen
• Re: Is the a "magic number" for WAL files
  • From: Peter Geoghegan
• Re: OT DBA type question - GRANT PRIVILEGE
  • From: Andrew Sullivan
• Re: Is the a "magic number" for WAL files
  • From: Thom Brown
• Re: OT DBA type question - GRANT PRIVILEGE
  • From: Andrew Sullivan
• Is the a "magic number" for WAL files
  • From: Rob Sargent
• Re: OT DBA type question - GRANT PRIVILEGE
  • From: Scott Marlowe
• Re: OT DBA type question - GRANT PRIVILEGE
  • From: James B. Byrne
• Re: OT DBA type question - GRANT PRIVILEGE
  • From: James B. Byrne
• Re: Why is cast array integer[] <--> text[] is not immutable.
  • From: Tom Lane
• Re: Why is cast array integer[] <--> text[] is not immutable.
  • From: Phil Couling
• Re: How to configure the connection timeout in PostgreSQL 8.3
  • From: Frank Lanitz
• Re: Why is cast array integer[] <--> text[] is not immutable.
  • From: Tom Lane
• How to configure the connection timeout in PostgreSQL 8.3
  • From: Andre Lopes
• Re: Question regarding authentication/login
  • From: Adrian Klaver
• Re: Database system identifier via SELECT?
  • From: Chris Redekop
• Question regarding authentication/login
  • From: Chris Deadlock
• Re: Hope for a new PostgreSQL era?
  • From: Simon Riggs
• Re: Hope for a new PostgreSQL era?
  • From: Andreas 'ads' Scherbaum
• Why is cast array integer[] <--> text[] is not immutable.
  • From: Phil Couling
• Re: Hope for a new PostgreSQL era?
  • From: Simon Riggs
• Re:
  • From: Bèrto ëd Sèra
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Character encoding problems
  • From: John R Pierce
• Character encoding problems
  • From: Bruce Clay
• Re: Hope for a new PostgreSQL era?
  • From: Chris Travers
• Re: Function Question
  • From: Tom Lane
• Re: Hope for a new PostgreSQL era?
  • From: Craig Ringer
• Re: Hope for a new PostgreSQL era?
  • From: Craig Ringer
• Re: Hope for a new PostgreSQL era?
  • From: Rodger Donaldson
• Re: OT DBA type question - GRANT PRIVILEDGE
  • From: Craig Ringer
• Re: Hope for a new PostgreSQL era?
  • From: Chris Travers
• Re: Hope for a new PostgreSQL era?
  • From: Chris Travers
• Re: Hope for a new PostgreSQL era?
  • From: Rodger Donaldson
• Function Question
  • From: Jake Stride
• Re: Hope for a new PostgreSQL era?
  • From: Chris Travers
• Re: Statistics mismatch between n_live_tup and actual row count
  • From: Tom Lane
• Re: Clarification on CONTEXT: xlog redo xid assignment
  • From: kc5
• Re: OT DBA type question - GRANT PRIVILEDGE
  • From: Andy Colson
• Re: Database system identifier via SELECT?
  • From: Safari Code
• Re: Database system identifier via SELECT?
  • From: Scott Mead
• OT DBA type question - GRANT PRIVILEDGE
  • From: James B. Byrne
• Re: Database system identifier via SELECT?
  • From: Bruce Momjian
• Re: Database system identifier via SELECT?
  • From: David Johnston
• Re: Database system identifier via SELECT?
  • From: Joshua D. Drake
• Re: Database system identifier via SELECT?
  • From: Bruce Momjian
• Re: Clarification on CONTEXT: xlog redo xid assignment
  • From: Simon Riggs
• Re: Hope for a new PostgreSQL era?
  • From: Joshua D. Drake
• Re: Hope for a new PostgreSQL era?
  • From: John R Pierce
• Re: Hope for a new PostgreSQL era?
  • From: Joshua D. Drake
• Re: Hope for a new PostgreSQL era?
  • From: John R Pierce
• Clarification on CONTEXT: xlog redo xid assignment
  • From: kc5
• Re: Hope for a new PostgreSQL era?
  • From: Joshua D. Drake
• Database system identifier via SELECT?
  • From: Chris Redekop
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Hope for a new PostgreSQL era?
  • From: Merlin Moncure
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Nicholson, Brad (Toronto, ON, CA)
• Statistics mismatch between n_live_tup and actual row count
  • From: Andreas Brandl
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Hope for a new PostgreSQL era?
  • From: Andrew Sullivan
• Re: concat(NULL,NULL) returns empty string
  • From: Pavel Stehule
• concat(NULL,NULL) returns empty string
  • From: Ingmar Brouns
• Re: Hope for a new PostgreSQL era?
  • From: Merlin Moncure
• Re: Fwd: postgres 9.0.4 Streaming related question ..
  • From: akp geek
• Re: Hope for a new PostgreSQL era?
  • From: Marc Cousin
• Re: Hope for a new PostgreSQL era?
  • From: Merlin Moncure
• Re: Hope for a new PostgreSQL era?
  • From: Satoshi Nagayasu
• Re: Hope for a new PostgreSQL era?
  • From: Andrew Sullivan
• Re: Hope for a new PostgreSQL era?
  • From: Craig Ringer
• Re: Hope for a new PostgreSQL era?
  • From: Tomas Vondra
• Re: Hope for a new PostgreSQL era?
  • From: Simon Riggs
• Re: Hope for a new PostgreSQL era?
  • From: Craig Ringer
• Re: Very slow table
  • From: Szymon Guz
• Error while vacuuming table
  • From: Nikhil G. Daddikar
• Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade
  • From: Joseph Shraibman
• Re: [pgadmin-support] Help for Migration
  • From: Mamatha_Kagathi_Chan
• Very slow table
  • From: Richard Weiss
• Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade
  • From: Tom Lane
• Re: Hope for a new PostgreSQL era?
  • From: Chris Travers
• pg crash shortly after 9.1.1 -> 9.1.2 upgrade
  • From: Joseph Shraibman
• Re: Hope for a new PostgreSQL era?
  • From: Scott Marlowe
• Hope for a new PostgreSQL era?
  • From: Rodrigo E. De León Plicet
• Query Slowdown after upgrade from 9.1.1 to 9.1.2
  • From: Jason Long
• Re: dblink performance
  • From: Merlin Moncure
• Re: Tables creation date and time
  • From: Pavel Stehule
• Re: dblink performance
  • From: Marc Mamin
• Re: dblink performance
  • From: Merlin Moncure
• Re: dblink performance
  • From: Bruno Lavoie
• Re: dblink performance
  • From: Marc Mamin
• Re: Tables creation date and time
  • From: Scott Marlowe
• Re: dblink performance
  • From: Merlin Moncure
• Tables creation date and time
  • From: Prashant Bharucha
• Re: Fwd: postgres 9.0.4 Streaming related question ..
  • From: Ben Chobot
• Fwd: postgres 9.0.4 Streaming related question ..
  • From: akp geek
• Slow COMMIT statements
  • From: Felix Feinhals
• Re: [pgadmin-support] Help for Migration
  • From: Mamatha_Kagathi_Chan
• Re: [pgadmin-support] Help for Migration
  • From: Mamatha_Kagathi_Chan
• Re: [pgadmin-support] Help for Migration
  • From: Mamatha_Kagathi_Chan
• dblink performance
  • From: Alex Bible
• Re: making "\pset pager off" the default
  • From: Scott Marlowe
• Re: is there example of update skript?
  • From: Cédric Villemain
• Re: making "\pset pager off" the default
  • From: Gauthier, Dave
• Expanding a VARCHAR on a large table that has inherited subtables ...
  • From: Paulo Correia
• Re: making "\pset pager off" the default
  • From: Adrian Klaver
• making "\pset pager off" the default
  • From: Gauthier, Dave
• Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
  • From: Tomas Vondra
• Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
  • From: Gene Poole
• postgres 9.0.4 Streaming relate question ..
  • From: akp geek
• Re: [pgadmin-support] Help for Migration
  • From: Guillaume Lelarge
• Re: [pgadmin-support] Help for Migration
  • From: Guillaume Lelarge
• is there example of update skript?
  • From: Pavel Stehule
• Re: [pgadmin-support] Help for Migration
  • From: Craig Ringer
• Re: Queries take long long(10 sec.) time running
  • From: Tomas Vondra
• Re: Queries take long long(10 sec.) time running
  • From: Andre Lopes
• Re: [pgadmin-support] Help for Migration
  • From: Craig Ringer
• Re: Queries take long long(10 sec.) time running
  • From: John R Pierce
• Re: Queries take long long(10 sec.) time running
  • From: Tomas Vondra
• Queries take long long(10 sec.) time running
  • From: Andre Lopes
• Re: [pgadmin-support] Help for Migration
  • From: Alban Hertroys
• Re: Installing different PostgreSQL versions in parallel
  • From: Rafael Ostertag
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Achilleas Mantzios
• Re: [pgadmin-support] Help for Migration
  • From: Craig Ringer
• upgrading tsearch2: how to call function in trigger
  • From: robert
• Re: [pgadmin-support] Help for Migration
  • From: Mamatha_Kagathi_Chan
• Re: Installing different PostgreSQL versions in parallel
  • From: John R Pierce
• Re: Installing different PostgreSQL versions in parallel
  • From: Rafael Ostertag
• Re: [BUGS] BUG #6325: Useless Index updates
  • From: Craig Ringer
• Re: Installing different PostgreSQL versions in parallel
  • From: John R Pierce
• Re: psql query gets stuck indefinitely
  • From: tamanna madaan
• Re: Installing different PostgreSQL versions in parallel
  • From: raghu ram
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Esmin Gracić
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Rob Sargent
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Larry Rosenman
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Joe Miller
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Scott Marlowe
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Rob Sargent
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Glyn Astill
• Re: Foreign keys question (performance)
  • From: Adrian Klaver
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Bèrto ëd Sèra
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Torello Querci
• Re: PostgreSQL DBA in SPAAAAAAAACE
  • From: Merlin Moncure
• Re: Foreign keys question (performance)
  • From: David Johnston
• PostgreSQL DBA in SPAAAAAAAACE
  • From: Joe Miller
• Re: Foreign keys question (performance)
  • From: Phoenix Kiula
• Re: [BUGS] BUG #6325: Useless Index updates
  • From: Gregg Jaskiewicz
• Re: [BUGS] BUG #6325: Useless Index updates
  • From: Daniel Migowski
• Re: How to retrieve rows with empty value in numeric(12,8) columns
  • From: Bèrto ëd Sèra
• Re: How to retrieve rows with empty value in numeric(12,8) columns
  • From: Alban Hertroys
• Re: How to retrieve rows with empty value in numeric(12,8) columns
  • From: Raymond O'Donnell
• Re: How to retrieve rows with empty value in numeric(12,8) columns
  • From: Adarsh Sharma
• Re: How to retrieve rows with empty value in numeric(12,8) columns
  • From: Adarsh Sharma
• How to retrieve rows with empty value in numeric(12,8) columns
  • From: Adarsh Sharma
• Re: pg_standby: How to check in which state the server is currently?
  • From: Frank Lanitz
• Re: Regarding licensing of Postgresql
  • From: Craig Ringer
• Re: High-Concurrency GiST in postgreSQL
  • From: Andy Colson
• Re: High-Concurrency GiST in postgreSQL
  • From: C. Mundi
• Re: High-Concurrency GiST in postgreSQL
  • From: Andy Colson
• Re: High-Concurrency GiST in postgreSQL
  • From: John R Pierce
• Re: High-Concurrency GiST in postgreSQL
  • From: John R Pierce
• Re: High-Concurrency GiST in postgreSQL
  • From: C. Mundi
• Re: disallow SET WORK_MEM
  • From: Tom Lane
• Re: High-Concurrency GiST in postgreSQL
  • From: Andy Colson
• Re: disallow SET WORK_MEM
  • From: Bruce Momjian
• Installing different PostgreSQL versions in parallel
  • From: Rafael Ostertag
• disallow SET WORK_MEM
  • From: Andreas Kretschmer
• High-Concurrency GiST in postgreSQL
  • From: C. Mundi
• Re: pl/pgsql and arrays[]
  • From: Pavel Stehule
• Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Francisco Figueiredo Jr.
• Re: pl/pgsql and arrays[]
  • From: Tom Lane
• Re: pg_standby: How to check in which state the server is currently?
  • From: Cédric Villemain
• Re: pg_standby: How to check in which state the server is currently?
  • From: Ray Stell
• Re: plpgsql question
  • From: Adrian Klaver
• plpgsql question
  • From: Gauthier, Dave
• Re: Regarding licensing of Postgresql
  • From: Gregg Jaskiewicz
• Re: Regarding licensing of Postgresql
  • From: Andrew Sullivan
• Re: Regarding licensing of Postgresql
  • From: Jayashankar K B
• Re: odbc_fdw
  • From: Florian Schwendener
• Re: FATAL: the database system is starting up
  • From: Dave Cramer
• FATAL: the database system is starting up
  • From: Dave Cramer
• Re: Regarding licensing of Postgresql
  • From: Craig Ringer
• Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Craig Ringer
• pg_standby: How to check in which state the server is currently?
  • From: Frank Lanitz
• Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Cédric Villemain
• Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Filip Rembiałkowski
• Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Albe Laurenz
• Re: Regarding licensing of Postgresql
  • From: John R Pierce
• Re: odbc_fdw
  • From: Albe Laurenz
• Re: Regarding licensing of Postgresql
  • From: John R Pierce
• Regarding licensing of Postgresql
  • From: Jayashankar K B
• Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Mike Christensen
• Re: psql query gets stuck indefinitely
  • From: tamanna madaan
• Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Craig Ringer
• Re: pl/pgsql and arrays[]
  • From: Pavel Stehule
• Re: pl/pgsql and arrays[]
  • From: Maxim Boguk
• Re: pl/pgsql and arrays[]
  • From: Pavel Stehule
• Re: WITH and WITH RECURSIVE in single query
  • From: Maxim Boguk
• Re: WITH and WITH RECURSIVE in single query
  • From: David Johnston
• Re: Questions about setting an array element value outside of the update
  • From: Tom Lane
• What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
  • From: Mike Christensen
• pl/pgsql and arrays[]
  • From: Maxim Boguk
• Re: Questions about setting an array element value outside of the update
  • From: David Johnston
• Re: WITH and WITH RECURSIVE in single query
  • From: Maxim Boguk
• Re: WITH and WITH RECURSIVE in single query
  • From: David Johnston
• Questions about setting an array element value outside of the update
  • From: Maxim Boguk
• Re: WITH and WITH RECURSIVE in single query
  • From: Tom Lane
• WITH and WITH RECURSIVE in single query
  • From: Maxim Boguk
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Tom Lane
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Tomas Vondra
• Re: Shared memory usage in PostgreSQL 9.1
  • From: sfrost
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Stephen Frost
• Re: Weird behavior: deleted row still in index?
  • From: Phoenix Kiula
• Re: Weird behavior: deleted row still in index?
  • From: Szymon Guz
• Re: Weird behavior: deleted row still in index?
  • From: Alban Hertroys
• Re: Foreign keys question (performance)
  • From: Phoenix Kiula
• Weird behavior: deleted row still in index?
  • From: Phoenix Kiula
• Re: Foreign keys question (performance)
  • From: Alban Hertroys
• Foreign keys question (performance)
  • From: Phoenix Kiula
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: How to get Place Names from Lat Lon
  • From: Josh Kupershmidt
• Re: [ADMIN] returning results from plsql function to plpythonu function
  • From: c k
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: [ADMIN] returning results from plsql function to plpythonu function
  • From: Lou Picciano
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: [ADMIN] returning results from plsql function to plpythonu function
  • From: c k
• Re: [ADMIN] returning results from plsql function to plpythonu function
  • From: c k
• Re: [ADMIN] returning results from plsql function to plpythonu function
  • From: Lou Picciano
• returning results from plsql function to plpythonu function
  • From: c k
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Tom Lane
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
  • From: Oleg Serov
• Re: How to convert HEX to ASCII?
  • From: Torsten Zühlsdorff
• Re: Shared memory usage in PostgreSQL 9.1
  • From: Tomas Vondra
• Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
  • From: Tomas Vondra
• Shared memory usage in PostgreSQL 9.1
  • From: Christoph Zwerschke
• Re: Oddball data distribution giving me planner headaches
  • From: Harald Fuchs
• Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
  • From: Craig Ringer
• Re: PostgreSQL 9.0 and asynchronous replication through VPN
  • From: Edson Richter
• Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
  • From: Andre Lopes
• Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
  • From: John R Pierce
• Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
  • From: Andre Lopes
• Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
  • From: John R Pierce
• Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
  • From: Adrian Klaver
• Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
  • From: David Johnston
• Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok.
  • From: Andre Lopes
• Re: Oddball data distribution giving me planner headaches
  • From: Jeff Amiel
• Re: weird negative seconds on checkpoint message.
  • From: Ing.Edmundo.Robles.Lopez
• Re: weird negative seconds on checkpoint message.
  • From: Adrian Klaver
• weird negative seconds on checkpoint message.
  • From: Ing.Edmundo.Robles.Lopez
• Re: Oddball data distribution giving me planner headaches
  • From: Jeff Amiel
• Re: Oddball data distribution giving me planner headaches
  • From: Jeff Amiel
• Re: Oddball data distribution giving me planner headaches
  • From: David Johnston
• Re: Oddball data distribution giving me planner headaches
  • From: Tom Lane
• Re: Oddball data distribution giving me planner headaches
  • From: Jeff Amiel
• Re: \dT+ does not give elements ?
  • From: Tom Lane
• Re: Oddball data distribution giving me planner headaches
  • From: David Johnston
• Re: Oddball data distribution giving me planner headaches
  • From: Jeff Amiel
• Re: Oddball data distribution giving me planner headaches
  • From: David Johnston
• Re: How to convert HEX to ASCII?
  • From: Pavel Stehule
• Re: How to convert HEX to ASCII?
  • From: Merlin Moncure
• Re: Oddball data distribution giving me planner headaches
  • From: Jeff Amiel
• Re: Oddball data distribution giving me planner headaches
  • From: David Johnston
• Oddball data distribution giving me planner headaches
  • From: Jeff Amiel
• \dT+ does not give elements ?
  • From: Gauthier, Dave
• Re: How to convert HEX to ASCII?
  • From: Pavel Stehule
• Re: How to convert HEX to ASCII?
  • From: Merlin Moncure
• Re: How to convert HEX to ASCII?
  • From: Pavel Stehule
• Re: How to convert HEX to ASCII?
  • From: Merlin Moncure
• Re: How to convert HEX to ASCII?
  • From: Marti Raudsepp
• sql statements using access frontend
  • From: Gavin Mitchell
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Magnus Hagander
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Merlin Moncure
• Re: odbc_fdw
  • From: fschwend
• Re: How to convert HEX to ASCII?
  • From: Merlin Moncure
• Re: order by, within a plpgsql fx
  • From: Tom Lane
• order by, within a plpgsql fx
  • From: david.sahagian
• Re: How to convert HEX to ASCII?
  • From: Torsten Zuehlsdorff
• Re: sql statements using access frontend
  • From: Richard Huxton
• Re: Query Optimizer makes a poor choice
  • From: Tyler Hains
• sql statements using access frontend
  • From: Gavin Mitchell
• Re: How to convert HEX to ASCII?
  • From: Damien Churchill
• How to convert HEX to ASCII?
  • From: Torsten Zuehlsdorff
• Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
  • From: Oleg Serov
• Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
  • From: Venkat Balaji
• Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
  • From: Oleg Serov
• Postgresql + corrupted disk = data loss. (Need help for database recover)
  • From: Oleg Serov
• Re: Query Optimizer makes a poor choice
  • From: Marcin Mańk
• Re: returning rows from an implicit JOIN where results either exist in both tables OR only one table
  • From: Lonni J Friedman
• Re: psql -1 with multiple files?
  • From: Jay Levitt
• Re: psql -1 with multiple files?
  • From: Steve Crawford
• psql -1 with multiple files?
  • From: Jay Levitt
• Re: returning rows from an implicit JOIN where results either exist in both tables OR only one table
  • From: David Johnston
• returning rows from an implicit JOIN where results either exist in both tables OR only one table
  • From: Lonni J Friedman
• Re: recursive inner trigger call
  • From: Red Light
• Re: recursive inner trigger call
  • From: Bèrto ëd Sèra
• Re: recursive inner trigger call
  • From: David Johnston
• Re: psql query gets stuck indefinitely
  • From: tamanna madaan
• Problem with binary data transfer format of TEXT in 8.4
  • From: Gracjan Polak
• How to get Place Names from Lat Lon
  • From: Adarsh Sharma
• Conditional left join
  • From: Amitabh Kant
• Replication issue
  • From: Jim Buttafuoco
• Re: How to restore the table space tar files created by pg_basebackup?
  • From: Samba
• Streaming Replication Over SSL
  • From: Samba
• Re: Conditional left join
  • From: Alban Hertroys
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Tomas Vondra
• Re: psql query gets stuck indefinitely
  • From: Tomas Vondra
• Re: How to restore the table space tar files created by pg_basebackup?
  • From: Magnus Hagander
• Re: Streaming Replication Over SSL
  • From: Magnus Hagander
• session hang for same row update
  • From: AI Rumman
• Re: session hang for same row update
  • From: Adrian Klaver
• Re: Problem with custom aggregates and record pseudo-type
  • From: Tom Lane
• Re: recursive inner trigger call
  • From: Gauthier, Dave
• recursive inner trigger call
  • From: Red Light
• Re: recursive inner trigger call
  • From: Red Light
• problem with restore: collision id`s lob
  • From: Hellmuth Vargas
• Re: Problem with custom aggregates and record pseudo-type
  • From: Maxim Boguk
• Re: Strange problem with turning WAL archiving on
  • From: Albe Laurenz
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Tomas Vondra
• Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS?
  • From: Sergey Konoplev
• Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS?
  • From: Sergey Konoplev
• Re: How to restore the table space tar files created by pg_basebackup?
  • From: Venkat Balaji
• Problem with custom aggregates and record pseudo-type
  • From: Maxim Boguk
• Re: Using a domain
  • From: Tom Lane
• Using a domain
  • From: Daniele Varrazzo
• Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS?
  • From: David Johnston
• Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS?
  • From: Craig Ringer
• Re: Query Optimizer makes a poor choice
  • From: Tomas Vondra
• Re: Extending the volume size of the data directory volume
  • From: Scott Mead
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Filip Rembiałkowski
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Tomas Vondra
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Merlin Moncure
• Re: odbc_fdw
  • From: Florian Schwendener
• Re: odbc_fdw
  • From: Florian Schwendener
• Re: Query Optimizer makes a poor choice
  • From: Tyler Hains
• Re: Extending the volume size of the data directory volume
  • From: panam
• Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
  • From: Tom Lane
• Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
  • From: Reid Thompson
• Re: Strange problem with turning WAL archiving on
  • From: Rodrigo Gonzalez
• Re: PostgreSQL 9.0 and asynchronous replication through VPN
  • From: Edson Richter
• Re: Strange problem with turning WAL archiving on
  • From: Tomas Vondra
• Re: Strange problem with turning WAL archiving on
  • From: BK
• Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS?
  • From: Sergey Konoplev
• How to restore the table space tar files created by pg_basebackup?
  • From: Samba
• Re: Strange problem with turning WAL archiving on
  • From: Albe Laurenz
• Re: DDL & DML Logging doesn't work for calling functions
  • From: Albe Laurenz
• Re: PostgreSQL 9.0 and asynchronous replication through VPN
  • From: John DeSoi
• Re: odbc_fdw
  • From: Eduardo Morras
• Re: DDL & DML Logging doesn't work for calling functions
  • From: MURAT KOÇ
• Re: odbc_fdw
  • From: Albe Laurenz
• PostgreSQL 9.0 and asynchronous replication through VPN
  • From: Edson Richter
• Strange problem with turning WAL archiving on
  • From: BK
• : pg_compresslog (pglesslog)
  • From: Venkat Balaji
• Re: DDL & DML Logging doesn't work for calling functions
  • From: Albe Laurenz
• Re: odbc_fdw
  • From: Albe Laurenz
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Heiko Wundram
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Magnus Hagander
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Heiko Wundram
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Heiko Wundram
• Re: tricking EXPLAIN?
  • From: Shigeru Hanada
• Re: Extending the volume size of the data directory volume
  • From: panam
• Re: Extending the volume size of the data directory volume
  • From: panam
• Re: Extending the volume size of the data directory volume
  • From: Craig Ringer
• Re: Extending the volume size of the data directory volume
  • From: Scott Marlowe
• Re: Extending the volume size of the data directory volume
  • From: panam
• Re: Query Optimizer makes a poor choice
  • From: Tomas Vondra
• Re: Query Optimizer makes a poor choice
  • From: Tomas Vondra
• Re: Query Optimizer makes a poor choice
  • From: Tomas Vondra
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Tom Lane
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Filip Rembiałkowski
• Re: Query Optimizer makes a poor choice
  • From: Tomas Vondra
• Re: Query Optimizer makes a poor choice
  • From: Tomas Vondra
• Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Heiko Wundram
• Re: Query Optimizer makes a poor choice
  • From: Filip Rembiałkowski
• Re: Query Optimizer makes a poor choice
  • From: Tyler Hains
• Re: Query Optimizer makes a poor choice
  • From: Tyler Hains
• DDL & DML Logging doesn't work for calling functions
  • From: MURAT KOÇ
• Re: Query Optimizer makes a poor choice
  • From: Scott Marlowe
• Re: Extending the volume size of the data directory volume
  • From: Filip Rembiałkowski
• Re: initdb failure on Windows 2003
  • From: Filip Rembiałkowski
• Re: Query Optimizer makes a poor choice
  • From: Filip Rembiałkowski
• Query Optimizer makes a poor choice
  • From: Tyler Hains
• Re: stored function data structures - difficulty
  • From: Pavel Stehule
• Re: stored function data structures - difficulty
  • From: J.V.
• Re: Sporadic query not returning anything..how to diagnose?
  • From: Heiko Wundram
• Sporadic query not returning anything..how to diagnose?
  • From: Phoenix Kiula
• Re: immutable functions
  • From: Tom Lane
• initdb failure on Windows 2003
  • From: Mike Wylde
• Re: PLPGSQL: How can I get the effected rows when use "execute" command in function
  • From: Ernesto Quiniones
• Re: PLPGSQL: How can I get the effected rows when use "execute" command in function
  • From: Pavel Stehule
• PLPGSQL: How can I get the effected rows when use "execute" command in function
  • From: Muiz
• Limiting number of connections to PostgreSQL per IP (not per DB/user)?
  • From: Heiko Wundram
• immutable functions
  • From: Andy Chambers
• Re: Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?
  • From: Ronan Dunklau
• Re: psql query gets stuck indefinitely
  • From: tamanna madaan
• Re: odbc_fdw
  • From: Albe Laurenz
• Re: Lengthy deletion
  • From: Tom Lane
• Re: Lengthy deletion
  • From: Herouth Maoz
• Re: Lengthy deletion
  • From: Tom Lane
• Lengthy deletion
  • From: Herouth Maoz
• Re: psql query gets stuck indefinitely
  • From: Craig Ringer
• odbc_fdw
  • From: fschwend
• Re: Stored function debugging help
  • From: John R Pierce
• Re: psql query gets stuck indefinitely
  • From: tamanna madaan
• Re: psql query gets stuck indefinitely
  • From: Craig Ringer
• Re: psql query gets stuck indefinitely
  • From: Craig Ringer
• Extending the volume size of the data directory volume
  • From: panam
• Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?
  • From: Stefan Keller
• Re: Stored function debugging help
  • From: Alban Hertroys
• Re: Stored function debugging help
  • From: JavaNoobie
• Re: tricking EXPLAIN?
  • From: Wim Bertels
• Re: tricking EXPLAIN?
  • From: Szymon Guz
• tricking EXPLAIN?
  • From: Wim Bertels
• Re: How to add conversion between LATIN1 and WIN1251 ?
  • From: Condor
• Re: Stored function debugging help
  • From: John R Pierce
• psql query gets stuck indefinitely
  • From: tamanna madaan
• Stored function debugging help
  • From: JavaNoobie
• Re: reading build config.log --> possible bug?
  • From: Rob Sargentg
• Re: reading build config.log --> possible bug?
  • From: Tom Lane
• reading build config.log --> possible bug?
  • From: Rob Sargentg
• Re: Way to create unique constraint in Postgres even with null columns
  • From: David Johnston
• Re: Way to create unique constraint in Postgres even with null columns
  • From: Thomas Kellerer
• Re: Way to create unique constraint in Postgres even with null columns
  • From: Mike Christensen
• Re: Way to create unique constraint in Postgres even with null columns
  • From: David Johnston
• Re: Way to create unique constraint in Postgres even with null columns
  • From: Mike Christensen
• Re: Way to create unique constraint in Postgres even with null columns
  • From: Thomas Kellerer
• Re: Way to create unique constraint in Postgres even with null columns
  • From: Pavel Stehule
• Way to create unique constraint in Postgres even with null columns
  • From: Mike Christensen
• Re: text search synonym dictionary anomaly with numbers
  • From: Richard Greenwood
• PostgreSQL poster
  • From: Ivan Voras
• Re: text search synonym dictionary anomaly with numbers
  • From: Richard Greenwood
• Re: text search synonym dictionary anomaly with numbers
  • From: Oleg Bartunov
• Re: General performance/load issue
  • From: Tomas Vondra
• Re: CPU move
  • From: frank