Postgresql General Discussion

• Thread Index

• Re: Scratching my head why results are different between machines.
  • From: Greg Stark
• Re: The REAL cost of joins
  • From: Merlin Moncure
• Re: Scratching my head why results are different between machines.
  • From: Justin Graf
• Re: to_timestamp() and quarters
  • From: Asher Hoskins
• Re: Failed to run initdb: 128
  • From: Magnus Hagander
• Re: The REAL cost of joins
  • From: Craig Ringer
• Re: Larger volumes of chronologically ordered data and the planner
  • From: John Moran
• Re: The REAL cost of joins
  • From: Grzegorz Jaśkiewicz
• Re: Failed to run initdb: 128
  • From: Richard Huxton
• Re: Scratching my head why results are different between machines.
  • From: Richard Huxton
• Re: Scratching my head why results are different between machines.
  • From: Dave Page
• Re: The REAL cost of joins
  • From: Richard Huxton
• Re: Need to Reload a Dump File - Need to Delete the PGDATA directory Again?
  • From: John R Pierce
• Need to Reload a Dump File - Need to Delete the PGDATA directory Again?
  • From: Wang, Mary Y
• Re: Scratching my head why results are different between machines.
  • From: Scott Marlowe
• Re: Scratching my head why results are different between machines.
  • From: Scott Marlowe
• Re: Scratching my head why results are different between machines.
  • From: John R Pierce
• Re: Scratching my head why results are different between machines.
  • From: Greg Sabino Mullane
• Re: Scratching my head why results are different between machines.
  • From: Craig Ringer
• Re: Scratching my head why results are different between machines.
  • From: Craig Ringer
• Failed to run initdb: 128
  • From: Niranjan Maturi (nmaturi)
• Failed to run initdb: 128
  • From: Niranjan Maturi (nmaturi)
• Re: Scratching my head why results are different between machines.
  • From: Michael Gould
• ArgoUML SQL code generator for PostgreSQL
  • From: John Gage
• Re: Scratching my head why results are different between machines.
  • From: Justin Graf
• Re: The REAL cost of joins
  • From: Peter Hunsberger
• Re: PQntuples returns an int.
  • From: Guillaume Yziquel
• Re: Cacti + PostgreSQL Graphing
  • From: Marc G. Fournier
• Re: Scratching my head why results are different between machines.
  • From: Michael Gould
• The REAL cost of joins
  • From: Marcin Krol
• Re: Scratching my head why results are different between machines.
  • From: Michael Gould
• Re: Cacti + PostgreSQL Graphing
  • From: Marc G. Fournier
• Re: Auto VACUUM
  • From: Igor Neyman
• Re: Larger volumes of chronologically ordered data and the planner
  • From: Greg Smith
• Re: Raid 10 settings for optimal postgres performance?
  • From: Greg Smith
• Re: PQntuples returns an int.
  • From: Greg Sabino Mullane
• Re: Scratching my head why results are different between machines.
  • From: Justin Graf
• Scratching my head why results are different between machines.
  • From: Michael Gould
• Re: PQntuples returns an int.
  • From: Steve Atkins
• Re: Larger volumes of chronologically ordered data and the planner
  • From: Tom Lane
• Re: stopping processes, preventing connections
  • From: Josh Kupershmidt
• Larger volumes of chronologically ordered data and the planner
  • From: John Moran
• PQntuples returns an int.
  • From: Guillaume Yziquel
• Re: Auto VACUUM
  • From: akp geek
• Re: Auto VACUUM
  • From: Joao Ferreira gmail
• Re: Massive table bloat
  • From: Markus Wollny
• Auto VACUUM
  • From: akp geek
• Re: How to grant a user read-only access to a database?
  • From: Kevin Kempter
• Re: Work Mem Allocation Questions
  • From: Bill Moran
• Re: finding duplicate numbers in a select distinct statement
  • From: Terry
• Work Mem Allocation Questions
  • From: Brad Nicholson
• Raid 10 settings for optimal postgres performance?
  • From: Chris Barnes
• Re: stopping processes, preventing connections
  • From: Herouth Maoz
• Re: stopping processes, preventing connections
  • From: Josh Kupershmidt
• Re: Massive table bloat
  • From: Grzegorz Jaśkiewicz
• Re: Massive table bloat
  • From: Thom Brown
• Massive table bloat
  • From: Markus Wollny
• Re: disable triggers isolated to transaction only?
  • From: Richard Huxton
• Re: disable triggers isolated to transaction only?
  • From: Greg Sabino Mullane
• Re: bug in function arguments "recognition"
  • From: Ivan Sergio Borgonovo
• Re: bug in function arguments "recognition"
  • From: Ivan Sergio Borgonovo
• Re: LDAP Login Problem
  • From: Tom Robst
• Re: bug in function arguments "recognition"
  • From: Tom Lane
• Re: How to grant a user read-only access to a database?
  • From: Tom Lane
• Re: LDAP Login Problem
  • From: Magnus Hagander
• Re: How to grant a user read-only access to a database?
  • From: Thom Brown
• LDAP Login Problem
  • From: Tom Robst
• bug in function arguments "recognition"
  • From: Ivan Sergio Borgonovo
• Re: finding duplicate numbers in a select distinct statement
  • From: Grzegorz Jaśkiewicz
• Re: finding duplicate numbers in a select distinct statement
  • From: Terry
• Re: finding duplicate numbers in a select distinct statement
  • From: Grzegorz Jaśkiewicz
• Re: How to grant a user read-only access to a database?
  • From: Kevin Kempter
• finding duplicate numbers in a select distinct statement
  • From: Terry
• Re: FSM and VM file
  • From: akp geek
• Re: How to grant a user read-only access to a database?
  • From: Merlin Moncure
• Re: FSM and VM file
  • From: Devrim GÜNDÜZ
• stopping processes, preventing connections
  • From: Herouth Maoz
• Re: FSM and VM file
  • From: Richard Huxton
• Re: FSM and VM file
  • From: akp geek
• Re: How to grant a user read-only access to a database?
  • From: Nilesh Govindarajan
• Re: createdb but revoke dropdb
  • From: Ben Eliott
• Re: FSM and VM file
  • From: Richard Huxton
• Re: createdb but revoke dropdb
  • From: Richard Huxton
• Fwd: createdb but revoke dropdb
  • From: Ben Eliott
• Re: SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?
  • From: Harvey, Allan AC
• Re: Trigger help - updates to column data with null values
  • From: Greg Fischer
• Re: Trigger help - updates to column data with null values
  • From: Craig Ringer
• Trigger help - updates to column data with null values
  • From: Greg Fischer
• Re: [SOLVED] SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?
  • From: Ozz Nixon
• SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?
  • From: Ozz Nixon
• Re: disable triggers isolated to transaction only?
  • From: Tom Lane
• Not all functions in schema pg_catalog are "visible"
  • From: Thomas Kellerer
• Re: FSM and VM file
  • From: akp geek
• Re: FSM and VM file
  • From: Scott Mead
• Re: FSM and VM file
  • From: Thomas Kellerer
• FSM and VM file
  • From: akp geek
• Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
  • From: Scott Marlowe
• Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
  • From: Scott Marlowe
• Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
  • From: Scott Marlowe
• Re: disable triggers isolated to transaction only?
  • From: Ben Chobot
• Re: Array columns vs normalized table
  • From: Lee Hachadoorian
• createdb but revoke dropdb
  • From: Ben Eliott
• Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
  • From: Chander Ganesan
• Re: Array columns vs normalized table
  • From: Scott Bailey
• Re: Array columns vs normalized table
  • From: Peter Hunsberger
• Re: Array columns vs normalized table
  • From: Pavel Stehule
• Re: tipo de dato
  • From: Said Ramirez
• disable triggers isolated to transaction only?
  • From: Vick Khera
• Array columns vs normalized table
  • From: Lee Hachadoorian
• Re: to_timestamp() and quarters
  • From: Scott Bailey
• tipo de dato
  • From: Miguel Angel Hernandez Moreno
• I suspend the subscription
  • From: maria teresa tarquino
• The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
  • From: Arnold, Sandra
• Re: How to grant a user read-only access to a database?
  • From: Said Ramirez
• Re: How to grant a user read-only access to a database?
  • From: Antonio Goméz Soto
• Re: to_timestamp() and quarters
  • From: A. Kretschmer
• Re: How to grant a user read-only access to a database?
  • From: Raymond O'Donnell
• Re: How to grant a user read-only access to a database?
  • From: Thom Brown
• Re: to_timestamp() and quarters
  • From: Tom Lane
• Re: How to grant a user read-only access to a database?
  • From: Antonio Goméz Soto
• Re: need a query
  • From: Pavel Stehule
• Re: How to grant a user read-only access to a database?
  • From: Craig Ringer
• Re: How to grant a user read-only access to a database?
  • From: Thom Brown
• need a query
  • From: AI Rumman
• Re: custom index
  • From: Simon Riggs
• Re: Putting index entries to XLog
  • From: Simon Riggs
• Re: How to grant a user read-only access to a database?
  • From: Nilesh Govindarajan
• Re: How to grant a user read-only access to a database?
  • From: Thom Brown
• How to grant a user read-only access to a database?
  • From: Antonio Goméz Soto
• to_timestamp() and quarters
  • From: Asher Hoskins
• Re: Hung postmaster (8.3.9)
  • From: Greg Stark
• Re: Optimizer: ranges and partial indices? Or use partitioning?
  • From: Adrian von Bidder
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: [SOLVED] Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: [SOLVED] Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• [SOLVED] Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Cacti + PostgreSQL Graphing
  • From: Brad Nicholson
• Re: Cacti + PostgreSQL Graphing
  • From: Marc G. Fournier
• Re: Cacti + PostgreSQL Graphing
  • From: Marc G. Fournier
• Re: Cannot remove prepared statement.
  • From: Tom Lane
• Re: Optimizer: ranges and partial indices? Or use partitioning?
  • From: Tom Lane
• Re: continuous copy/update one table to another
  • From: Tom Lane
• Cannot remove prepared statement.
  • From: Darryl Pye
• custom index
  • From: michael uwe maier
• Re: Confusion about users and roles
  • From: C. Bensend
• Re: current transaction id
  • From: A. Kretschmer
• current transaction id
  • From: AI Rumman
• Re: continuous copy/update one table to another
  • From: Adrian von Bidder
• Optimizer: ranges and partial indices? Or use partitioning?
  • From: Adrian von Bidder
• Re: continuous copy/update one table to another
  • From: Szymon Guz
• Re: continuous copy/update one table to another
  • From: Grzegorz Jaśkiewicz
• Re: continuous copy/update one table to another
  • From: Terry
• Re: continuous copy/update one table to another
  • From: Terry
• Re: Confusion about users and roles
  • From: Tom Lane
• Confusion about users and roles
  • From: C. Bensend
• Re: continuous copy/update one table to another
  • From: John R Pierce
• Re: continuous copy/update one table to another
  • From: Terry
• Re: continuous copy/update one table to another
  • From: Terry
• Re: continuous copy/update one table to another
  • From: John R Pierce
• Re: continuous copy/update one table to another
  • From: Szymon Guz
• Re: continuous copy/update one table to another
  • From: David W Noon
• Re: continuous copy/update one table to another
  • From: John R Pierce
• continuous copy/update one table to another
  • From: Terry
• Re: Partial foreign keys
  • From: Tom Lane
• Re: Partial foreign keys
  • From: rihad
• Re: Absent output from psql
  • From: Tom Lane
• Re: Absent output from psql
  • From: Nilesh Govindarajan
• Absent output from psql
  • From: John Gage
• Re: Hung postmaster (8.3.9)
  • From: Tom Lane
• Re: regexp_replace: LF, CR, or tab
  • From: Bastiaan Wakkie
• Re: Putting index entries to XLog
  • From: Martijn van Oosterhout
• does writer process also write data to WAL log files ?
  • From: Thomas
• Re: Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Hung postmaster (8.3.9)
  • From: Greg Smith
• Hung postmaster (8.3.9)
  • From: Ed L.
• Re: Automatic index advisor?
  • From: Bill Karwin
• Re: trouble with to_char('L')
  • From: Bruce Momjian
• Partial foreign keys
  • From: rihad
• Re: Can not match 0 on bytea
  • From: Tom Lane
• Re: regexp_replace: LF, CR, or tab
  • From: Osvaldo Kussama
• Re: Can not match 0 on bytea
  • From: Daniel Verite
• Re: ERROR: value out of range: underflow
  • From: Anton Maksimenkov
• regexp_replace: LF, CR, or tab
  • From: seiliki
• Can not match 0 on bytea
  • From: seiliki
• Re: Automatic index advisor?
  • From: Greg Smith
• Re: Cacti + PostgreSQL Graphing
  • From: Greg Smith
• Automatic index advisor?
  • From: Bill Karwin
• Re: trouble with to_char('L')
  • From: Hiroshi Inoue
• Re: select issue with order v8.1
  • From: Scott Marlowe
• Re: select issue with order v8.1
  • From: Tom Lane
• Re: select issue with order v8.1
  • From: Terry
• Cacti + PostgreSQL Graphing
  • From: Marc G. Fournier
• Re: select issue with order v8.1
  • From: Scott Marlowe
• Re: select issue with order v8.1
  • From: Terry
• Re: ERROR: value out of range: underflow
  • From: Alvaro Herrera
• Re: Threads limit for postmaster
  • From: Magnus Hagander
• Threads limit for postmaster
  • From: Igor Neyman
• Re: ERROR: value out of range: underflow
  • From: Thom Brown
• Re: ERROR: value out of range: underflow
  • From: Raymond O'Donnell
• Re: C function to create tsquery not working
  • From: Ivan Sergio Borgonovo
• Re: ERROR: value out of range: underflow
  • From: Thom Brown
• ERROR: value out of range: underflow
  • From: Anton Maksimenkov
• Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
  • From: Greg Smith
• Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
  • From: John R Pierce
• Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
  • From: Albe Laurenz
• Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
  • From: A. Kretschmer
• Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
  • From: Wang, Mary Y
• Re: Two Versions of PostgreSQL Installed - How to uninstall one particular version
  • From: A. Kretschmer
• Two Versions of PostgreSQL Installed - How to uninstall one particular version
  • From: Wang, Mary Y
• Re: How to Output PSQL Errors to a Log File?
  • From: Wang, Mary Y
• Re: Problems with the Windows 8.4.1 upgrade from 8.3 on non-C drive
  • From: John Gage
• Re: Problems with the Windows 8.4.1 upgrade from 8.3 on non-C drive
  • From: Sachin Srivastava
• Re: trouble with to_char('L')
  • From: Bruce Momjian
• Re: trouble with to_char('L')
  • From: Hiroshi Inoue
• Re: trouble with to_char('L')
  • From: Bruce Momjian
• Re: trouble with to_char('L')
  • From: Tom Lane
• Re: trouble with to_char('L')
  • From: Bruce Momjian
• Re: trouble with to_char('L')
  • From: Tom Lane
• Re: trouble with to_char('L')
  • From: Bruce Momjian
• Re: After each row trigger NOT seeing data changes?
  • From: Bruce Momjian
• Problems with the Windows 8.4.1 upgrade from 8.3 on non-C drive
  • From: dtrobert
• Re: Tool for determining field usage of database tables
  • From: Scott Marlowe
• Re: Tool for determining field usage of database tables
  • From: Andy Yoder
• Re: Boolean partition constraint behaving strangely
  • From: Tom Lane
• Re: Tool for determining field usage of database tables
  • From: Allan Kamau
• pgsql input variables
  • From: Mark Vantzelfde
• Partition constraints behaving strangely
  • From: Dominik Sander
• Boolean partition constraint behaving strangely
  • From: Dominik Sander
• Re: Curious plperl behavior
  • From: Jeff
• Re: Performance comparison
  • From: Thomas Kellerer
• Re: Performance comparison
  • From: Greg Smith
• Tool for determining field usage of database tables
  • From: Andy Yoder
• Re: Restricting the CREATEROLE privilege
  • From: Alex Hunsaker
• Re: postgres password change
  • From: akp geek
• Re: postgres password change
  • From: akp geek
• Re: select issue with order v8.1
  • From: Terry
• Re: Restricting the CREATEROLE privilege
  • From: Wappler, Robert
• Re: postgres password change
  • From: paragasu
• Re: Missing clog, PITR
  • From: Patryk Sidzina
• Re: postgres password change
  • From: hubert depesz lubaczewski
• postgres password change
  • From: akp geek
• Re: Restricting the CREATEROLE privilege
  • From: Alex Hunsaker
• Putting index entries to XLog
  • From: Carsten Kropf
• Re: C function to create tsquery not working
  • From: Pavel Stehule
• Re: C function to create tsquery not working
  • From: Ivan Sergio Borgonovo
• Re: Global Temp Table
  • From: A. Kretschmer
• Re: SELECT only those values of table B which have a value in table A
  • From: Stefan Schwarzer
• Global Temp Table
  • From: Shameem Ahamed
• Re: SELECT only those values of table B which have a value in table A
  • From: Michal Politowski
• Re: helo
  • From: Wappler, Robert
• SELECT only those values of table B which have a value in table A
  • From: Stefan Schwarzer
• Re: Performance comparison
  • From: Thomas Kellerer
• Restricting the CREATEROLE privilege
  • From: Wappler, Robert
• Re: Performance comparison
  • From: Martijn van Oosterhout
• Re: select issue with order v8.1
  • From: Scott Marlowe
• Re: select issue with order v8.1
  • From: Tom Lane
• select issue with order v8.1
  • From: Terry
• Re: archive_timeout in postgresql.conf
  • From: Greg Smith
• Re: Missing clog, PITR
  • From: Greg Smith
• Re: Possible causes for database corruption and solutions
  • From: Greg Smith
• Re: Performance comparison
  • From: Greg Smith
• Re: How to get the permissions assigned to user?
  • From: Alex Hunsaker
• Re: how to clear server log
  • From: Ben Chobot
• Re: pg_buffercache's usage count
  • From: Ben Chobot
• Performance comparison
  • From: Martijn van Oosterhout
• Re: Cast char to number
  • From: Richard Huxton
• Re: Curious plperl behavior
  • From: Tom Lane
• Re: Cast char to number
  • From: Bill Moran
• Re: Cast char to number
  • From: Raymond O'Donnell
• Re: Curious plperl behavior
  • From: Richard Huxton
• Re: Cast char to number
  • From: Christine Penner
• Re: Curious plperl behavior
  • From: Tom Lane
• Re: Curious plperl behavior
  • From: Richard Huxton
• Re: Curious plperl behavior
  • From: Tom Lane
• Re: Cast char to number
  • From: Scott Marlowe
• Re: Cast char to number
  • From: Tom Lane
• Re: Cast char to number
  • From: Joshua D. Drake
• Re: Curious plperl behavior
  • From: Jeff
• Re: Cast char to number
  • From: Richard Huxton
• Re: Cast char to number
  • From: Scott Marlowe
• Re: Cast char to number
  • From: Bill Moran
• Re: Cast char to number
  • From: Bill Moran
• Re: Cast char to number
  • From: Joshua D. Drake
• Re: Cast char to number
  • From: Daniel Verite
• Re: Cast char to number
  • From: Richard Huxton
• Re: Cast char to number
  • From: Raymond O'Donnell
• Re: Cast char to number
  • From: Christine Penner
• Re: Cast char to number
  • From: Bill Moran
• Cast char to number
  • From: Christine Penner
• Re: pg_buffercache's usage count
  • From: Greg Smith
• Re: bugs reporting
  • From: Raymond O'Donnell
• Re: Npgsql connection string editor?
  • From: Francisco Figueiredo Jr.
• Re: how to clear server log
  • From: Amy Smith
• bugs reporting
  • From: Mitesh Patel
• Re: select t.name from tbl t (where "name" is not a column name)
  • From: Joe Conway
• C function manipulating tsquery doesn't work with -O2
  • From: Ivan Sergio Borgonovo
• archive_timeout in postgresql.conf
  • From: akp geek
• Re: select t.name from tbl t (where "name" is not a column name)
  • From: Igor Neyman
• Re: PostgreSQL install fails with 1603 error
  • From: A. Kretschmer
• PostgreSQL install fails with 1603 error
  • From: Mitesh Patel
• Re: Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column
  • From: Alvaro Herrera
• Re: pg_buffercache's usage count
  • From: Alvaro Herrera
• Curious plperl behavior
  • From: Jeff
• Re: "make check" failed on 8.4.2 install
  • From: Daniel Verite
• Re: "make check" failed on 8.4.2 install
  • From: adam_pgsql
• Transaction isolation when applying DDLs
  • From: Luigi Antognini
• Re: Explaining duplicate rows in spite of unique index
  • From: Albe Laurenz
• Re:
  • From: Albe Laurenz
• Re: Not able to change the owner of function
  • From: Albe Laurenz
• Re: pg_buffercache's usage count
  • From: Greg Smith
• Re: typecaste object to array
  • From: Lew
• Re: Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column
  • From: John Gage
• Re: Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column
  • From: Tom Lane
• Re: Trying to get a C function built with MSVC
  • From: Magnus Hagander
• Re: Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column
  • From: Bret S. Lambert
• Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column
  • From: John Gage
• Re: Not able to change the owner of function
  • From: Jignesh Shah
• Re: Not able to change the owner of function
  • From: Frank Heikens
• Re: [NOVICE] Not able to change the owner of function
  • From: Jignesh Shah
• How to get the permissions assigned to user?
  • From: Jignesh Shah
• Not able to change the owner of function
  • From: Jignesh Shah
• Re: SET Role doesn't work from Security Definer Function...
  • From: dipti shah
• Re: Minor systax error but not able to resolve it...
  • From: dipti shah
• Re: how do I do dump and restore without bugging with constraint?
  • From: Thillai Selvan
• Re: Sorting performance vs. MySQL
  • From: Baron Schwartz
• Re: select t.name from tbl t (where "name" is not a column name)
  • From: Joe Conway
• Re: how do I do dump and restore without bugging with constraint?
  • From: Net Tree Inc.
• Re: [ADMIN] how do I do dump and restore without bugging with constraint?
  • From: Net Tree Inc.
• select t.name from tbl t (where "name" is not a column name)
  • From: raf
• Trying to get a C function built with MSVC
  • From: Bryan Montgomery
• Re: pg_buffercache's usage count
  • From: Ben Chobot
• pg_buffercache's usage count
  • From: Ben Chobot
• Re: COPY command character set
  • From: Bruce Momjian
• Re: "make check" failed on 8.4.2 install
  • From: Tom Lane
• Re: how to clear server log
  • From: Reid Thompson
• Re:
  • From: Reid Thompson
• Re: how to clear server log
  • From: Ben Chobot
• Re: COPY command character set
  • From: Peter Headland
• Npgsql connection string editor?
  • From: Radcon Entec
• how to clear server log
  • From: Amy Smith
• [no subject]
  • From: Shu Ho
• Re: Minor systax error but not able to resolve it...
  • From: Richard Huxton
• Re: "make check" failed on 8.4.2 install
  • From: adam_pgsql
• Re: "make check" failed on 8.4.2 install
  • From: Tom Lane
• Re: FOREIGN KEY composite_type.its_field REFERENCES ....
  • From: Tom Lane
• Re: SET Role doesn't work from Security Definer Function...
  • From: dipti shah
• Re: tuning bgwriter in 8.4.2
  • From: Greg Smith
• Re: Minor systax error but not able to resolve it...
  • From: dipti shah
• FOREIGN KEY composite_type.its_field REFERENCES ....
  • From: Belka Lambda
• Re: Sorting performance vs. MySQL
  • From: Alex Hunsaker
• Re: pg_dump new version
  • From: Wang, Mary Y
• Re: [ADMIN] how do I do dump and restore without bugging with constraint?
  • From: Net Tree Inc.
• Re: Re: [ADMIN] how do I do dump and restore without bugging with constraint?
  • From: Net Tree Inc.
• Re: tuning bgwriter in 8.4.2
  • From: Ben Chobot
• Re: Minor systax error but not able to resolve it...
  • From: Tom Lane
• Re: pg_dump new version
  • From: Tom Lane
• Re: SET Role doesn't work from Security Definer Function...
  • From: Alvaro Herrera
• Re: Subqueries or Joins? Problems with multiple table query
  • From: Stefan Schwarzer
• Re: Subqueries or Joins? Problems with multiple table query
  • From: A. Kretschmer
• Re: Subqueries or Joins? Problems with multiple table query
  • From: A. Kretschmer
• Re: Re: [ADMIN] how do I do dump and restore without bugging with constraint?
  • From: Richard Huxton
• Re: Subqueries or Joins? Problems with multiple table query
  • From: Stefan Schwarzer
• Re: Subqueries or Joins? Problems with multiple table query
  • From: A. Kretschmer
• Re: Subqueries or Joins? Problems with multiple table query
  • From: Thom Brown
• Re: Subqueries or Joins? Problems with multiple table query
  • From: Stefan Schwarzer
• Re: Alternative to UPDATE (As COPY to INSERT)
  • From: Richard Huxton
• Re: Subqueries or Joins? Problems with multiple table query
  • From: Thom Brown
• Re: Subqueries or Joins? Problems with multiple table query
  • From: Stefan Schwarzer
• Re: pg_dump new version
  • From: Alban Hertroys
• Re: Alternative to UPDATE (As COPY to INSERT)
  • From: Alban Hertroys
• Re: Subqueries or Joins? Problems with multiple table query
  • From: A. Kretschmer
• Re: Minor systax error but not able to resolve it...
  • From: Richard Huxton
• Re: Subqueries or Joins? Problems with multiple table query
  • From: Thom Brown
• Subqueries or Joins? Problems with multiple table query
  • From: Stefan Schwarzer
• Minor systax error but not able to resolve it...
  • From: dipti shah
• Re: pg_dump: aborting because of version mismatch
  • From: Magnus Hagander
• Re: Implementing an Index Access Method in PG 8.4
  • From: Carsten Kropf
• Re: pg_dump: aborting because of version mismatch
  • From: Net Tree Inc.
• Re: Implementing an Index Access Method in PG 8.4
  • From: Greg Stark
• Re: Sorting performance vs. MySQL
  • From: Greg Stark
• Implementing an Index Access Method in PG 8.4
  • From: Carsten Kropf
• Re: SET Role doesn't work from Security Definer Function...
  • From: dipti shah
• Re: pg_dump: aborting because of version mismatch
  • From: Magnus Hagander
• pg_dump: aborting because of version mismatch
  • From: Net Tree Inc.
• Re: Sorting performance vs. MySQL
  • From: Yeb Havinga
• pg_dump new version
  • From: Oliver Kohll - Mailing Lists
• Alternative to UPDATE (As COPY to INSERT)
  • From: Yan Cheng CHEOK
• Re: Sorting performance vs. MySQL
  • From: John Gage
• Re: [ADMIN] how do I do dump and restore without bugging with constraint?
  • From: Net Tree Inc.
• "make check" failed on 8.4.2 install
  • From: adam_pgsql
• Re: typecaste object to array
  • From: John R Pierce
• Re: Sorting performance vs. MySQL
  • From: Greg Stark
• Explaining duplicate rows in spite of unique index
  • From: Albe Laurenz
• typecaste object to array
  • From: beulah prasanthi
• Re: Missing clog, PITR
  • From: Patryk Sidzina
• Re: How to Output PSQL Errors to a Log File?
  • From: Devrim GÜNDÜZ
• Re: Table Column Retrieval
  • From: Scott Marlowe
• Re: How to Output PSQL Errors to a Log File?
  • From: Wang, Mary Y
• Re: how do I do dump and restore without bugging with constraint?
  • From: Scott Marlowe
• Re: How to Output PSQL Errors to a Log File?
  • From: Nilesh Govindarajan
• Re: How to Output PSQL Errors to a Log File?
  • From: John R Pierce
• Re: How to Output PSQL Errors to a Log File?
  • From: Joshua D. Drake
• How to Output PSQL Errors to a Log File?
  • From: Wang, Mary Y
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Alex Hunsaker
• Re: Sorting performance vs. MySQL
  • From: Scott Marlowe
• Re: how do I do dump and restore without bugging with constraint?
  • From: Net Tree Inc.
• Re: Sorting performance vs. MySQL
  • From: Tom Lane
• Re: Sorting performance vs. MySQL
  • From: Tom Lane
• Re: COPY command character set
  • From: Bruce Momjian
• Re: COPY command character set
  • From: Tom Lane
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: comment on constraint
  • From: Bruce Momjian
• Re: COPY command character set
  • From: Bruce Momjian
• Re: how do I do dump and restore without bugging with constraint?
  • From: John R Pierce
• Re: [ADMIN] how do I do dump and restore without bugging with constraint?
  • From: Kevin Grittner
• how do I do dump and restore without bugging with constraint?
  • From: Net Tree Inc.
• Re: Table Column Retrieval
  • From: Joshua Tolley
• Table Column Retrieval
  • From: dmp
• Anyone interested in a San Diego Postgres Users Group (SD-PUG)?
  • From: Joe Conway
• Re: Sorting performance vs. MySQL
  • From: Alex Hunsaker
• Re: tuning bgwriter in 8.4.2
  • From: Greg Smith
• Re: Sorting performance vs. MySQL
  • From: Scott Marlowe
• Re: Sorting performance vs. MySQL
  • From: Scott Marlowe
• Re: tuning bgwriter in 8.4.2
  • From: Ben Chobot
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Igor Neyman
• Re: Sorting performance vs. MySQL
  • From: Tom Lane
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Scott Marlowe
• Re: Sorting performance vs. MySQL
  • From: Tom Lane
• Re: Sorting performance vs. MySQL
  • From: Yeb Havinga
• Re: SET Role doesn't work from Security Definer Function...
  • From: Tom Lane
• Re: Info about concurrent sequential scans
  • From: Daniele Varrazzo
• Re: Missing clog, PITR
  • From: Richard Huxton
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Info about concurrent sequential scans
  • From: Andreas Kretschmer
• Re: Sorting performance vs. MySQL
  • From: Scott Marlowe
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Info about concurrent sequential scans
  • From: Bruce Momjian
• Re: Sorting performance vs. MySQL
  • From: Scott Marlowe
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Complex SELECT Statement help needed
  • From: flashbangpop
• Re: Sorting performance vs. MySQL
  • From: Frank Heikens
• Re: Sorting performance vs. MySQL
  • From: Scott Marlowe
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Alvaro Herrera
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Info about concurrent sequential scans
  • From: Daniele Varrazzo
• Re: Sorting performance vs. MySQL
  • From: Frank Heikens
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Alvaro Herrera
• Re: Sorting performance vs. MySQL
  • From: Alban Hertroys
• Re: Sorting performance vs. MySQL
  • From: Frank Heikens
• Re: Questions regarding SET option.
  • From: Pavel Stehule
• Re: Questions regarding SET option.
  • From: Jignesh Shah
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: Sorting performance vs. MySQL
  • From: Richard Broersma
• Re: Complex SELECT Statement help needed
  • From: Raymond O'Donnell
• Re: Sorting performance vs. MySQL
  • From: Frank Heikens
• Complex SELECT Statement help needed
  • From: flashbangpop
• Re: Sorting performance vs. MySQL
  • From: Pavel Stehule
• SET Role doesn't work from Security Definer Function...
  • From: dipti shah
• Re: Questions regarding SET option.
  • From: Pavel Stehule
• Sorting performance vs. MySQL
  • From: Yang Zhang
• Re: What is unsecure postgres languages? How to disable them?
  • From: Scott Bailey
• Re: Questions regarding SET option.
  • From: Jignesh Shah
• Re: Performance cost of a sort-merge join
  • From: Yang Zhang
• Re: [BUGS] helo
  • From: Kevin Grittner
• Re: What is unsecure postgres languages? How to disable them?
  • From: dipti shah
• Re: [BUGS] helo
  • From: Kris Jurka
• Re: Un successful Restoration of DATA using WAL files
  • From: Bruce Momjian
• Re: Performance cost of a sort-merge join
  • From: Tom Lane
• Performance cost of a sort-merge join
  • From: Yang Zhang
• Re: helo
  • From: Allan Kamau
• Re: tsearch2 gives NOTICE: word is too long
  • From: Albe Laurenz
• Re: text search in 8.1
  • From: Albe Laurenz
• Re: What is unsecure postgres languages? How to disable them?
  • From: Albe Laurenz
• Re: Questions regarding SET option.
  • From: Albe Laurenz
• Re: ECPG: No multidimensional array support for simple data types
  • From: Boszormenyi Zoltan
• ECPG: No multidimensional array support for simple data types
  • From: mike stanton
• pgsql exception.
  • From: Ravi
• Re: Asynchronous queries - processing listen (notify) in a procedural language
  • From: Merlin Moncure
• tsearch2 gives NOTICE: word is too long
  • From: AI Rumman
• Re: What is unsecure postgres languages? How to disable them?
  • From: Tino Wildenhain
• Re: Questions regarding SET option.
  • From: Pavel Stehule
• TypeCast: util.list to array type
  • From: beulah prasanthi
• Questions regarding SET option.
  • From: Jignesh Shah
• helo
  • From: beulah prasanthi
• What is unsecure postgres languages? How to disable them?
  • From: dipti shah
• Missing clog, PITR
  • From: Patryk Sidzina
• Re: text search in 8.1
  • From: AI Rumman
• Re: text search in 8.1
  • From: David Fetter
• text search in 8.1
  • From: AI Rumman
• Re: change path of /tmp/.s.PGSQL.5432
  • From: Nilesh Govindarajan
• Re: change path of /tmp/.s.PGSQL.5432
  • From: Devrim GÜNDÜZ
• change path of /tmp/.s.PGSQL.5432
  • From: AI Rumman
• Re: Question on RETURNS TABLE example in PostgreSQL documentation
  • From: Pavel Stehule
• Re: Asynchronous queries - processing listen (notify) in a procedural language
  • From: Merlin Moncure
• Question on RETURNS TABLE example in PostgreSQL documentation
  • From: Yan Cheng Cheok
• Re: Asynchronous queries - processing listen (notify) in a procedural language
  • From: Tom Lane
• Re: Asynchronous queries - processing listen (notify) in a procedural language
  • From: Merlin Moncure
• Re: Timing Race
  • From: Adrian Klaver
• Timing Race
  • From: Dennis Gearon
• Re: How to count the number of items in an Array?
  • From: Andre Lopes
• Re: How to count the number of items in an Array?
  • From: Andreas Kretschmer
• Re: How to count the number of items in an Array?
  • From: Andre Lopes
• Re: How to count the number of items in an Array?
  • From: Andreas Kretschmer
• Re: pgpool error, pid not found!
  • From: Tatsuo Ishii
• Re: How to count the number of items in an Array?
  • From: Andre Lopes
• Re: How to count the number of items in an Array?
  • From: Andreas Kretschmer
• Re: Asynchronous queries - processing listen (notify) in a procedural language
  • From: Pavel Stehule
• Asynchronous queries - processing listen (notify) in a procedural language
  • From: Petr Chmelar
• How to count the number of items in an Array?
  • From: Andre Lopes
• Re: PostgreSQL fails to start
  • From: Reid Thompson
• Re: PostgreSQL fails to start
  • From: Reid Thompson
• Re: PostgreSQL fails to start
  • From: John Gage
• Re: PostgreSQL fails to start
  • From: Massa, Harald Armin
• Re: PostgreSQL fails to start
  • From: Heddon's Gate Hotel
• Re: Transactions, How to?
  • From: Andre Lopes
• Re: Transactions, How to?
  • From: Andreas Kretschmer
• Transactions, How to?
  • From: Andre Lopes
• Re: Procedures
  • From: Raymond O'Donnell
• Re: DDL trigger kind functionality in PostGreSQL
  • From: Greg Stark
• Re: Procedures
  • From: Nilesh Govindarajan
• Re: Procedures
  • From: Thomas Kellerer
• Re: Procedures
  • From: Raymond O'Donnell
• Re: Procedures
  • From: Nilesh Govindarajan
• Re: Procedures
  • From: Raymond O'Donnell
• Re: Procedures
  • From: Nilesh Govindarajan
• Re: Procedures
  • From: Thomas Kellerer
• Re: Procedures
  • From: Nilesh Govindarajan
• Re: Procedures
  • From: John R Pierce
• Procedures
  • From: Nilesh Govindarajan
• A new log analysis tool for Postgres is available
  • From: Baron Schwartz
• Re: How can I get the English version?
  • From: Nils Gösche
• Re: How can I get the English version?
  • From: Thomas Kellerer
• Re: How can I get the English version?
  • From: Nils Gösche
• Re: How can I get the English version?
  • From: Thomas Kellerer
• How can I get the English version?
  • From: Nils Gösche
• Sr. Linux Systems Architect - CentOS, PostgresSQL/pgPool-II, Apache Server, Python, Bacula
  • From: WordStream
• When making ODBC remote connection, which executable is called?
  • From: Nim Li
• Re: Possible causes for database corruption and solutions
  • From: Bruce Momjian
• Re: Doubts about oid
  • From: Vick Khera
• Re: GROUP BY column alias?
  • From: Tom Lane
• Re: GROUP BY column alias?
  • From: David Fetter
• Re: Compiling .pgc programs gives error
  • From: Tom Lane
• Compiling .pgc programs gives error
  • From: mike stanton
• Re: PostgreSQL fails to start
  • From: Raymond O'Donnell
• PostgreSQL fails to start
  • From: Heddon's Gate Hotel
• Re: Setting a table to be ignored by autovacuum
  • From: Chris Barnes
• Re: Doubts about oid
  • From: Alvaro Herrera
• Re: How to get the users name from users group?
  • From: Jignesh Shah
• Re: Getting number of affected row after performing update
  • From: Alban Hertroys
• Re: Setting a table to be ignored by autovacuum
  • From: Alban Hertroys
• Re: PERFORM not working properly, please help..
  • From: wilczarz1
• Re: PERFORM not working properly, please help..
  • From: Pavel Stehule
• Re: PERFORM not working properly, please help..
  • From: Raymond O'Donnell
• Re: PERFORM not working properly, please help..
  • From: Florent THOMAS
• Re: How to get the users name from users group?
  • From: Magnus Hagander
• Re: PERFORM not working properly, please help..
  • From: wilczarz1
• Re: PERFORM not working properly, please help..
  • From: wilczarz1
• set line number / input file name in psql
  • From: Adrian von Bidder
• Re: PERFORM not working properly, please help..
  • From: Pavel Stehule
• How to get the users name from users group?
  • From: Jignesh Shah
• Re: Getting number of affected row after performing update
  • From: Richard Huxton
• Re: Not able to access schema functions and table...
  • From: dipti shah
• Re: Not able to access schema functions and table...
  • From: Richard Huxton
• Re: Not able to access schema functions and table...
  • From: Guillaume Lelarge
• Not able to access schema functions and table...
  • From: dipti shah
• Getting number of affected row after performing update
  • From: Yan Cheng Cheok
• Re: System Log is logging row number -1 is out of range 0..-1
  • From: Tom Lane
• System Log is logging row number -1 is out of range 0..-1
  • From: Naoko Reeves
• Re: GROUP BY column alias?
  • From: Tom Lane
• Re: GROUP BY column alias?
  • From: Lew
• Re: Doubts about oid
  • From: Jayadevan M
• Re: Doubts about oid
  • From: John R Pierce
• Re: Doubts about oid
  • From: Scott Marlowe
• Re: Doubts about oid
  • From: Jayadevan M
• Re: pgpool error, pid not found!
  • From: Tatsuo Ishii
• Re: GROUP BY column alias?
  • From: Eric B. Ridge
• Re: GROUP BY column alias?
  • From: Scott Bailey
• Re: Persistent identifiers for Postgres users
  • From: Alvaro Herrera
• Re: GROUP BY column alias?
  • From: Eric B. Ridge
• Re: SQL select return into PSQL variables.
  • From: Reid Thompson
• Re: GROUP BY column alias?
  • From: Scott Bailey
• GROUP BY column alias?
  • From: Eric B. Ridge
• Re: Setting a table to be ignored by autovacuum
  • From: Chris Barnes
• Re: Setting a table to be ignored by autovacuum
  • From: Alvaro Herrera
• Re: PERFORM not working properly, please help..
  • From: Raymond O'Donnell
• Re: PERFORM not working properly, please help..
  • From: Pavel Stehule
• PERFORM not working properly, please help..
  • From: wilczarz1
• Re: Setting a table to be ignored by autovacuum
  • From: Chris Barnes
• Re: Setting a table to be ignored by autovacuum
  • From: Josh Kupershmidt
• Re: Setting a table to be ignored by autovacuum
  • From: Richard Huxton
• Setting a table to be ignored by autovacuum
  • From: Chris Barnes
• Re: Trying to add a type modifier to user created type
  • From: Carsten Kropf
• Re: SQL select return into PSQL variables.
  • From: Vick Khera
• Re: Trying to add a type modifier to user created type
  • From: Tom Lane
• Re: errmsg and multi-byte strings.
  • From: Tom Lane
• SQL select return into PSQL variables.
  • From: Little, Douglas
• Re: Doubts about oid
  • From: Adrian Klaver
• errmsg and multi-byte strings.
  • From: Ivan Sergio Borgonovo
• Re: Define permissions at database level
  • From: dipti shah
• Re: Define permissions at database level
  • From: Richard Huxton
• Re: Define permissions at database level
  • From: dipti shah
• Re: Define permissions at database level
  • From: Richard Huxton
• Re: Define permissions at database level
  • From: dipti shah
• Re: Define permissions at database level
  • From: Richard Huxton
• Re: define transaction within pg/psql. Necessary?
  • From: Antonio Goméz Soto
• Re: Define permissions at database level
  • From: dipti shah
• Re: define transaction within pg/psql. Necessary?
  • From: Richard Huxton
• Re: define transaction within pg/psql. Necessary?
  • From: Grzegorz Jaśkiewicz
• Re: Define permissions at database level
  • From: Richard Huxton
• define transaction within pg/psql. Necessary?
  • From: Antonio Goméz Soto
• Re: One solution for Packages in Postgre
  • From: venkatrao . b
• Re: One solution for Packages in Postgre
  • From: Dimitri Fontaine
• Re: Trying to add a type modifier to user created type
  • From: Yeb Havinga
• Re: about effective_cache_size
  • From: Greg Smith
• Define permissions at database level
  • From: dipti shah
• Re: about effective_cache_size
  • From: A. Kretschmer
• Re: One solution for Packages in Postgre
  • From: Jayadevan M
• about effective_cache_size
  • From: AI Rumman
• One solution for Packages in Postgre
  • From: venkatrao . b
• Trying to add a type modifier to user created type
  • From: Carsten Kropf
• Re: Howto analyse sql statement.
  • From: Tatsuo Ishii
• Re: pgpool error, pid not found!
  • From: Tatsuo Ishii
• returning records from plpython
  • From: Scott Bailey
• DDL trigger kind functionality in PostGreSQL
  • From: dipti shah
• Doubts about oid
  • From: Jayadevan M
• Re: pg_database_size(oid)
  • From: Greg Smith
• Re: tuning bgwriter in 8.4.2
  • From: Greg Smith
• Re: tuning bgwriter in 8.4.2
  • From: Ben Chobot
• Re: tuning bgwriter in 8.4.2
  • From: Greg Smith
• Re: dump of 700 GB database
  • From: karsten vennemann
• Re: dump of 700 GB database
  • From: Scott Marlowe
• Re: dump of 700 GB database
  • From: karsten vennemann
• Re: ERROR: permission denied to finish prepared transaction
  • From: David Kerr
• Reading a table with composite type, into it equivalent c structure
  • From: mike stanton
• Re: pg_database_size(oid)
  • From: Reid Thompson
• Re: pg_database_size(oid)
  • From: Tom Lane
• pg_database_size(oid)
  • From: Dhimant Patel
• Re: COPY FROM wish list
  • From: Dimitri Fontaine