Postgresql General Discussion

• Thread Index

• Re: Controlling proliferation of postgres.exe processes
  • From: Scott Mead
• Re: Query optimizer & prepared statements
  • From: Chris
• Re: [GENERAL] Error ::- “ 'more' is not recognized as an internal or external command, operable program or batch file. “
  • From: raghu ram
• Re: Error ::- “ 'more' is not recognized as an internal or external command, operable program or batch file. “
  • From: Vibhor Kumar
• Error ::- “ 'more' is not recognized as an internal or external command, operable program or batch file. “
  • From: raghu ram
• Re: drawback of array vs join
  • From: Ivan Sergio Borgonovo
• Re: Controlling proliferation of postgres.exe processes
  • From: Bill Moran
• Re: Query optimizer & prepared statements
  • From: Emanuel Calvo Franco
• Controlling proliferation of postgres.exe processes
  • From: Radcon Entec
• Re: drawback of array vs join
  • From: Emanuel Calvo Franco
• Query optimizer & prepared statements
  • From: Jack Orenstein
• Separating raise notice lines
  • From: Radcon Entec
• Re: help with data recovery from injected UPDATE
  • From: Merlin Moncure
• Re: Replication
  • From: Emanuel Calvo Franco
• Re: Replication
  • From: Glyn Astill
• Re: Replication
  • From: Greg Sabino Mullane
• Re: Replication
  • From: Ray Stell
• Re: Replication
  • From: Thomas Kellerer
• Re: possible bug on age() function (8.2.4 , 8.3.6)
  • From: Tom Lane
• Re: Replication
  • From: Mike Christensen
• Re: Replication
  • From: Merlin Moncure
• possible bug on age() function (8.2.4 , 8.3.6)
  • From: Philippe Amelant
• Re: Please suggest me on my table design (indexes!)
  • From: DaNieL..!
• Re: Please suggest me on my table design (indexes!)
  • From: DaNieL..!
• Re: Explaining functions.
  • From: Hartman, Matthew
• Re: Replication
  • From: Scott Marlowe
• Re: Replication
  • From: Scott Marlowe
• Re: PANIC: cannot abort transaction 140578842, it was already committed
  • From: Tom Lane
• Re: Please suggest me on my table design (indexes!)
  • From: justin
• Re: Please suggest me on my table design (indexes!)
  • From: Chris Spotts
• Re: Please suggest me on my table design (indexes!)
  • From: DaNieL..!
• Re: [BUGS] Integrity check
  • From: Greg Stark
• Re: Replication
  • From: Ray Stell
• Re: Slight change in query leads to unexpected change in query plan
  • From: Jack Orenstein
• PANIC: cannot abort transaction 140578842, it was already committed
  • From: sergio nogueira
• Re: Explaining functions.
  • From: Chris Spotts
• Re: after vacuum analyze, explain still wrong
  • From: Greg Stark
• Re: Information about columns
  • From: Tom Lane
• drawback of array vs join
  • From: Ivan Sergio Borgonovo
• Re: Please suggest me on my table design (indexes!)
  • From: Grzegorz Jaśkiewicz
• Re: Information about columns
  • From: Dario Teixeira
• Re: Replication
  • From: Merlin Moncure
• Re: Explaining functions.
  • From: Dave Page
• Re: Cache lookup failed for type 70385664
  • From: Greg Stark
• Re: Please suggest me on my table design (indexes!)
  • From: DaNieL..!
• Re: [BUGS] Integrity check
  • From: David Fetter
• Re: Slight change in query leads to unexpected change in query plan
  • From: Tom Lane
• Re: Explaining functions.
  • From: Tom Lane
• Re: Slight change in query leads to unexpected change in query plan
  • From: Jack Orenstein
• Re: Explaining functions.
  • From: Hartman, Matthew
• Re: Information about columns
  • From: Tom Lane
• Re: [BUGS] Integrity check
  • From: Dave Page
• Re: [BUGS] Integrity check
  • From: David Fetter
• Re: Explaining functions.
  • From: Merlin Moncure
• Re: [BUGS] Integrity check
  • From: Dave Page
• Re: [BUGS] Integrity check
  • From: David Fetter
• Re: Information about columns
  • From: darioteixeira
• Re: [BUGS] Integrity check
  • From: Dave Page
• Re: Information about columns
  • From: Dario Teixeira
• Re: [BUGS] Integrity check
  • From: David Fetter
• Re: Replication
  • From: Gerry Reno
• About fastpath function call
  • From: Bruce YUAN
• Re: Inserting Values into Interval
  • From: BlackMage
• Explaining functions.
  • From: Hartman, Matthew
• Re: Replication
  • From: Jasen Betts
• Re: Graphical representation of query plans
  • From: Viktor Rosenfeld
• Re: Please suggest me on my table design (indexes!)
  • From: Grzegorz Jaśkiewicz
• Re: Please suggest me on my table design (indexes!)
  • From: DaNieL..!
• Please suggest me on my table design (indexes!)
  • From: DaNieL
• Re: after vacuum analyze, explain still wrong
  • From: Grzegorz Jaśkiewicz
• Re: after vacuum analyze, explain still wrong
  • From: Sim Zacks
• Re: after vacuum analyze, explain still wrong
  • From: Sim Zacks
• Re: Cache lookup failed for type 70385664
  • From: DelGurth
• Cache lookup failed for type 70385664
  • From: DelGurth
• Re: Replication
  • From: Grzegorz Jaśkiewicz
• Re: Replication
  • From: Devrim GÜNDÜZ
• Re: Replication
  • From: Grzegorz Jaśkiewicz
• Re: Replication
  • From: Devrim GÜNDÜZ
• Re: Replication
  • From: Devrim GÜNDÜZ
• Re: Replication
  • From: Arndt Lehmann
• Re: Replication
  • From: Arndt Lehmann
• Re: Graphical representation of query plans
  • From: Dragan Sahpaski
• Re: after vacuum analyze, explain still wrong
  • From: Grzegorz Jaśkiewicz
• Re: after vacuum analyze, explain still wrong
  • From: Sim Zacks
• Re: Graphical representation of query plans
  • From: Viktor Rosenfeld
• Re: Why my queryes doesnt not use indexes?
  • From: Grzegorz Jaśkiewicz
• Re: Replication
  • From: Mike Christensen
• after vacuum analyze, explain still wrong
  • From: Sim Zacks
• Re: Replication
  • From: Arndt Lehmann
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Andrew Maclean
• Re: Hourly dates
  • From: Andrew Maclean
• Re: Trigger Function and backup
  • From: Arndt Lehmann
• Re: Replication
  • From: Craig Ringer
• Re: Replication
  • From: Scott Marlowe
• Re: Replication
  • From: Scott Marlowe
• Re: Replication
  • From: Craig Ringer
• Re: Replication
  • From: Conrad Lender
• Re: Replication
  • From: Gerry Reno
• Re: Select ranges based on sequential breaks
  • From: Joel Nothman
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Tom Lane
• Re: Replication
  • From: Scott Marlowe
• Re: Replication
  • From: Craig Ringer
• Re: Information about columns
  • From: Tom Lane
• Re: Replication
  • From: Gerry Reno
• Re: Trigger Function and backup
  • From: Andrew Smith
• Re: Replication
  • From: Craig Ringer
• Re: Replication
  • From: Tom Lane
• Re: Hourly dates
  • From: Steve Crawford
• Re: Replication
  • From: Gerry Reno
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Craig Ringer
• Re: Replication
  • From: Greg Smith
• Hourly dates
  • From: Andrew Maclean
• Re: Inserting Values into Interval
  • From: Tom Lane
• Re: Slight change in query leads to unexpected change in query plan
  • From: Tom Lane
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Andrew Maclean
• Re: Why my queryes doesnt not use indexes?
  • From: Sam Mason
• Re: Slight change in query leads to unexpected change in query plan
  • From: Sam Mason
• Re: Trigger Function and backup
  • From: Arndt Lehmann
• Why my queryes doesnt not use indexes?
  • From: DaNieL
• Inserting Values into Interval
  • From: BlackMage
• Re: Replication
  • From: Gerry Reno
• Re: Replication
  • From: Joshua D. Drake
• Re: Replication
  • From: Gerry Reno
• Re: Replication
  • From: Joshua D. Drake
• Re: Replication
  • From: Gerry Reno
• Re: Replication
  • From: Kevin Barnard
• Re: Replication
  • From: Joshua D. Drake
• Re: Information about columns
  • From: John DeSoi
• Slight change in query leads to unexpected change in query plan
  • From: Jack Orenstein
• Re: Select ranges based on sequential breaks
  • From: Mike Toews
• Replication
  • From: Gerry Reno
• Re: Compiling Pl/Java
  • From: Kris Jurka
• Compiling Pl/Java
  • From: Jorge Vidal - Disytel
• Re: Information about columns
  • From: Dario Teixeira
• Re: Select ranges based on sequential breaks
  • From: Scott Marlowe
• Re: Select ranges based on sequential breaks
  • From: Mike Toews
• Re: Information about columns
  • From: John DeSoi
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Tom Lane
• Re: Killing a data modifying transaction
  • From: William Temperley
• Re: Select ranges based on sequential breaks
  • From: Scott Marlowe
• Re: 8.2 instance that won't come up after shutdown
  • From: Scott Marlowe
• Re: Information about columns
  • From: Dario Teixeira
• Re: pl/sql resources for pl/pgsql?
  • From: Merlin Moncure
• Re: Select ranges based on sequential breaks
  • From: Joel Nothman
• Re: Build in spatial support vs. PostGIS
  • From: Johan Nel
• Re: Killing a data modifying transaction
  • From: Tom Lane
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Todd A. Cook
• Re: Killing a data modifying transaction
  • From: William Temperley
• Re: Select ranges based on sequential breaks
  • From: Joel Nothman
• 8.2 instance that won't come up after shutdown
  • From: Abraham, Danny
• Re: Killing a data modifying transaction
  • From: Tom Lane
• Killing a data modifying transaction
  • From: William Temperley
• Re: Information about columns
  • From: Pavel Stehule
• Re: Information about columns
  • From: Craig Ringer
• Information about columns
  • From: Dario Teixeira
• Re: running pg_dump from python
  • From: Dimitri Fontaine
• Re: Graphical representation of query plans
  • From: Grzegorz Jaśkiewicz
• Graphical representation of query plans
  • From: Viktor Rosenfeld
• Re: temp tables, sessions, pgpool and disk
  • From: Ivan Sergio Borgonovo
• Re: temp tables, sessions, pgpool and disk
  • From: Martijn van Oosterhout
• Re: What's wrong with this query?
  • From: Thomas Kellerer
• Re: temp tables, sessions, pgpool and disk
  • From: Ivan Sergio Borgonovo
• Re: What's wrong with this query?
  • From: Albe Laurenz
• Re: where is the table?
  • From: Albe Laurenz
• Re: What's wrong with this query?
  • From: Mike Christensen
• Re: What's wrong with this query?
  • From: Martin Gainty
• Re: What's wrong with this query?
  • From: Mike Christensen
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Craig Ringer
• Re: What's wrong with this query?
  • From: Martin Gainty
• Re: cursors, temp tables, dynamic sql technique (was and is: looping over a small record set over and over in a function)
  • From: Craig Ringer
• Re: What's wrong with this query?
  • From: Steve Atkins
• Re: What's wrong with this query?
  • From: Thomas Kellerer
• What's wrong with this query?
  • From: Mike Christensen
• Re: cursors, temp tables, dynamic sql technique (was and is: looping over a small record set over and over in a function)
  • From: Ivan Sergio Borgonovo
• Loading long lat values converting degrees to decimal values
  • From: Dave Potts
• subscribe-set pgsql-general digest
  • From: Michael Fraley
• Re: default data sort
  • From: David Fetter
• default data sort
  • From: Michael Fraley
• default data sort
  • From: Michael Fraley
• Re: Postgres - uuid-ossp error
  • From: Tom Lane
• Re: Implicit conversion/comparision of timestamp with and without timezone
  • From: Tom Lane
• Postgres - uuid-ossp error
  • From: Adalberto Costa
• Re: Build in spatial support vs. PostGIS
  • From: Stephen Frost
• Re: cursors, temp tables, dynamic sql technique (was and is: looping over a small record set over and over in a function)
  • From: Craig Ringer
• Re: Build in spatial support vs. PostGIS
  • From: Pavel Stehule
• Re: Implicit conversion/comparision of timestamp with and without timezone
  • From: Gerhard Wiesinger
• Build in spatial support vs. PostGIS
  • From: Assaf Lavie
• cursors, temp tables, dynamic sql technique (was and is: looping over a small record set over and over in a function)
  • From: Ivan Sergio Borgonovo
• Re: Implicit conversion/comparision of timestamp with and without timezone
  • From: Richard Huxton
• Re: pl/sql resources for pl/pgsql?
  • From: Peter Eisentraut
• Re: looping over a small record set over and over in a function
  • From: Craig Ringer
• Implicit conversion/comparision of timestamp with and without timezone
  • From: Gerhard Wiesinger
• Re: pl/sql resources for pl/pgsql?
  • From: Pavel Stehule
• Re: pl/sql resources for pl/pgsql?
  • From: Merlin Moncure
• Benetl, a free ETL tool for files using postgreSQL, is out in version 2.8
  • From: benoît carpentier
• where is the table?
  • From: sergio nogueira
• Re: looping over a small record set over and over in a function
  • From: John DeSoi
• Re: Dynamic table
  • From: Hartman, Matthew
• Re: looping over a small record set over and over in a function
  • From: Ivan Sergio Borgonovo
• Re: running pg_dump from python
  • From: Jasen Betts
• Re: Disaster recovery (server died)
  • From: Madison Kelly
• Re: Disaster recovery (server died)
  • From: Alan McKay
• Re: looping over a small record set over and over in a function
  • From: Alban Hertroys
• Re: pl/sql resources for pl/pgsql?
  • From: Gurjeet Singh
• Re: How to use PQfn() in libpq library?
  • From: Bruce YUAN
• Re: pl/sql resources for pl/pgsql?
  • From: Jasen Betts
• Re: Disaster recovery (server died)
  • From: Uwe C. Schroeder
• Re: Dynamic table
  • From: Jasen Betts
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Craig Ringer
• Re: connecting to a remote pq always require a password
  • From: Jasen Betts
• Re: Disaster recovery (server died)
  • From: Scott Marlowe
• Re: Disaster recovery (server died)
  • From: Madison Kelly
• Re: Disaster recovery (server died)
  • From: Miguel Miranda
• Re: Disaster recovery (server died)
  • From: Madison Kelly
• Re: Disaster recovery (server died)
  • From: Alan Hodgson
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Todd A. Cook
• Disaster recovery (server died)
  • From: Miguel Miranda
• Re: Invalid statement name (null) in line ## - what am I doing wrong ?
  • From: leif
• looping over a small record set over and over in a function
  • From: Ivan Sergio Borgonovo
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Tom Lane
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Stefan Kaltenbrunner
• Re: postgresql-8.3.7 unexpected connection closures
  • From: justin
• Re: How to use PQfn() in libpq library?
  • From: Alvaro Herrera
• Re: postgresql-8.3.7 unexpected connection closures
  • From: justin
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Scott Marlowe
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Pavel Stehule
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Leif B. Kristensen
• Re: How to use PQfn() in libpq library?
  • From: Bruce YUAN
• Re: Invalid statement name (null) in line ## - what am I doing wrong ?
  • From: Albe Laurenz
• Re: How to use PQfn() in libpq library?
  • From: Tom Lane
• How to use PQfn() in libpq library?
  • From: Bruce YUAN
• Re: Invalid statement name (null) in line ## - what am I doing wrong ?
  • From: leif
• Re: Invalid statement name (null) in line ## - what am I doing wrong ?
  • From: Albe Laurenz
• Re: postgres -- monitor and suggestions
  • From: Gerd König
• Re: Maintaining user roles and permissions in Postgres - general question
  • From: Richard Huxton
• Issue with WAL recovery in windows
  • From: Nishkarsh
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Andrew Maclean
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Craig Ringer
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Tom Lane
• Re: Maintaining user roles and permissions in Postgres - general question
  • From: Scott Marlowe
• Re: Maintaining user roles and permissions in Postgres - general question
  • From: John R Pierce
• Re: Invalid statement name (null) in line ## - what am I doing wrong ?
  • From: leif
• Maintaining user roles and permissions in Postgres - general question
  • From: Postgres User
• Re: Invalid statement name (null) in line ## - what am I doing wrong ?
  • From: Martin Gainty
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Craig Ringer
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Andrew Maclean
• Invalid statement name (null) in line ## - what am I doing wrong ?
  • From: leif
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Craig Ringer
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Andrew Maclean
• Re: postgresql-8.3.7 unexpected connection closures
  • From: Craig Ringer
• postgresql-8.3.7 unexpected connection closures
  • From: Andrew Maclean
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Tom Lane
• Re: running pg_dump from python
  • From: Erik Jones
• Re: Could not reattach to shared memory
  • From: Bruce Momjian
• Re: Question re 2 aggregates from 1 query
  • From: Scott Ribe
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Todd A. Cook
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Alan McKay
• Re: Question re 2 aggregates from 1 query
  • From: Chris Spotts
• Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Vick Khera
• Re: Question re 2 aggregates from 1 query
  • From: Scott Ribe
• Question re 2 aggregates from 1 query
  • From: Scott Ribe
• Re: SET TIMEZONE doesn't affect to SELECT statement
  • From: Mike Christensen
• SET TIMEZONE doesn't affect to SELECT statement
  • From: POST
• Re: connecting to a remote pq always require a password
  • From: Lennin Caro
• Re: postgres -- monitor and suggestions
  • From: Grzegorz Jaśkiewicz
• postgres -- monitor and suggestions
  • From: Sim Zacks
• Re: connecting to a remote pq always require a password
  • From: John DeSoi
• connecting to a remote pq always require a password
  • From: David Shen
• Re: Too many postgres instances
  • From: Bill Moran
• Too many postgres instances
  • From: Sam Wun
• Re: issue with lo_lseek - it returns 4
  • From: Konstantin Izmailov
• Re: Some strange bug with drop table with slony cluster
  • From: Tom Lane
• Re: Some strange bug with drop table with slony cluster
  • From: Scott Marlowe
• Re: issue with lo_lseek - it returns 4
  • From: Tom Lane
• Re: used for large media files
  • From: justin
• Re: Some strange bug with drop table with slony cluster
  • From: Tom Lane
• Re: how to cancel a query in progress
  • From: Tom Lane
• Re: issue with lo_lseek - it returns 4
  • From: Konstantin Izmailov
• Re: issue with lo_lseek - it returns 4
  • From: Konstantin Izmailov
• partitioning example
  • From: Scott Marlowe
• Some strange bug with drop table with slony cluster
  • From: Maxim Boguk
• Re: Naming functions with reserved words
  • From: artacus
• Re: GiST or GIN, I feel like I am doing something wrong
  • From: Oleg Bartunov
• issue with lo_lseek - it returns 4
  • From: Konstantin Izmailov
• Re: GiST or GIN, I feel like I am doing something wrong
  • From: Aaron
• Re: how to cancel a query in progress
  • From: Whit Armstrong
• Re: used for large media files
  • From: Steve Atkins
• Re: how to cancel a query in progress
  • From: Tom Lane
• Re: Playing with set returning functions in SELECT list - behaviour intended?
  • From: Tom Lane
• Re: how to cancel a query in progress
  • From: Whit Armstrong
• Re: used for large media files
  • From: Mike Kay
• Re: GiST or GIN, I feel like I am doing something wrong
  • From: Tom Lane
• Re: how to cancel a query in progress
  • From: Tom Lane
• Re: Naming functions with reserved words
  • From: Tom Lane
• Re: Custom Fields Database Architecture
  • From: David Fetter
• Re: Playing with set returning functions in SELECT list - behaviour intended?
  • From: Albe Laurenz
• Could not reattach to shared memory
  • From: Tuan Hoang Anh
• FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
  • From: Todd A. Cook
• Re: Playing with set returning functions in SELECT list - behaviour intended?
  • From: Tom Lane
• Re: Playing with set returning functions in SELECT list - behaviour intended?
  • From: David Fetter
• Re: Naming functions with reserved words
  • From: David Fetter
• GiST or GIN, I feel like I am doing something wrong
  • From: Aaron
• how to cancel a query in progress
  • From: Whit Armstrong
• Re: used for large media files
  • From: Bill Moran
• used for large media files
  • From: Mike Kay
• Re: simulating high load for vacuum full
  • From: Bill Moran
• Re: Data merging problem
  • From: Thomas Kellerer
• Naming functions with reserved words
  • From: Scott Bailey
• Re: PostgreSQL server NOT STARTED
  • From: John R Pierce
• simulating high load for vacuum full
  • From: Ivan Sergio Borgonovo
• PostgreSQL server NOT STARTED
  • From: Chandra Sekar R
• Re: Dynamic table
  • From: A B
• Re: Data merging problem
  • From: John R Pierce
• Data merging problem
  • From: subodh chaudhari
• Re: nagios -- number of postgres connections
  • From: Rafael Martinez
• Re: nagios -- number of postgres connections
  • From: Rafael Martinez
• Re: nagios -- number of postgres connections
  • From: Scott Mead
• Re: nagios -- number of postgres connections
  • From: Jeff Frost
• Re: nagios -- number of postgres connections
  • From: Scott Mead
• Re: nagios -- number of postgres connections
  • From: John R Pierce
• nagios -- number of postgres connections
  • From: Whit Armstrong
• Re: Dynamic table
  • From: Erik Jones
• Re: 10 TB database
  • From: Scott Marlowe
• Re: 10 TB database
  • From: Grzegorz Jaśkiewicz
• Re: 10 TB database
  • From: Greg Smith
• Re: ResultSet is FORWARD_ONLY.
  • From: Andy Colson
• Re: 10 TB database
  • From: Michelle Konzack
• Re: Amazon EC2 | Any recent developments
  • From: Just Someone
• Re: Amazon EC2 | Any recent developments
  • From: Greg Smith
• Re: Amazon EC2 | Any recent developments
  • From: Just Someone
• Re: 10 TB database
  • From: Greg Smith
• Re: 10 TB database
  • From: Greg Smith
• Re: 10 TB database
  • From: Greg Smith
• Re: 10 TB database
  • From: Martin Gainty
• Re: Dynamic table
  • From: Sam Mason
• Re: Amazon EC2 | Any recent developments
  • From: David Kerr
• Re: 10 TB database
  • From: Todd Lieberman
• Re: pg_relation_size, relation does not exist
  • From: Frank Heikens
• Re: pg_relation_size, relation does not exist
  • From: Magnus Hagander
• Re: Custom Fields Database Architecture
  • From: Richard Broersma
• Re: pg_relation_size, relation does not exist
  • From: Frank Heikens
• Re: pg_relation_size, relation does not exist
  • From: Tom Lane
• Re: Playing with set returning functions in SELECT list - behaviour intended?
  • From: Tom Lane
• Re: Trigger Function and backup
  • From: Merlin Moncure
• Re: Dynamic table
  • From: A B
• Re: Dynamic table
  • From: A B
• Re: Dynamic table
  • From: Greg Stark
• Re: pg_relation_size, relation does not exist
  • From: Whit Armstrong
• Re: Custom Fields Database Architecture
  • From: Greg Stark
• Re: pg_relation_size, relation does not exist
  • From: Frank Heikens
• Re: Dynamic table
  • From: A B
• pg_relation_size, relation does not exist
  • From: Whit Armstrong
• Re: Trigger Function and backup
  • From: Nishkarsh
• Playing with set returning functions in SELECT list - behaviour intended?
  • From: Albe Laurenz
• Re: Dynamic table
  • From: Sam Mason
• Re: 10 TB database
  • From: Pedro Doria Meunier
• Re: Rounding incompatibility
  • From: Havasvölgyi Ottó
• Re: 10 TB database
  • From: Michelle Konzack
• ResultSet is FORWARD_ONLY.
  • From: S Arvind
• Re: How can I interpolate psql variables in function bodies?
  • From: Albe Laurenz
• Dynamic table
  • From: A B
• Re: Postgres 8.2 Memory Tuning
  • From: Eduardo Morras
• Re: Postgres 8.2 Memory Tuning
  • From: CM J
• Re: integer only sposix/regex
  • From: Steve Atkins
• integer only sposix/regex
  • From: rodeored
• Re: Custom Fields Database Architecture
  • From: Sim Zacks
• Re: pl/sql resources for pl/pgsql?
  • From: Pavel Stehule
• Re: Perf differences between timestamp and timestamp with timezone
  • From: Bruce Momjian
• Re: Perf differences between timestamp and timestamp with timezone
  • From: Mike Christensen
• Re: Amazon EC2 | Any recent developments
  • From: Just Someone
• Re: Perf differences between timestamp and timestamp with timezone
  • From: Bruce Momjian
• Perf differences between timestamp and timestamp with timezone
  • From: Mike Christensen
• pl/sql resources for pl/pgsql?
  • From: gvimrc
• Re: DB Migration 8.4 -> 8.3
  • From: Eoghan Murray
• Re: DB Migration 8.4 -> 8.3
  • From: Tom Lane
• Re: Amazon EC2 | Any recent developments
  • From: David Kerr
• How can I interpolate psql variables in function bodies?
  • From: J. Greg Davidson
• Re: DB Migration 8.4 -> 8.3
  • From: Glyn Astill
• DB Migration 8.4 -> 8.3
  • From: Eoghan Murray
• Re: Custom Fields Database Architecture
  • From: David Fetter
• Re: 10 TB database
  • From: Brent Wood
• Re: Custom Fields Database Architecture
  • From: Stefan Keller
• Re: Select ranges based on sequential breaks
  • From: David Wilson
• Re: interval is ignored
  • From: Tom Lane
• interval is ignored
  • From: rodeored
• Re: interval is ignored
  • From: rodeored
• Select ranges based on sequential breaks
  • From: Mike Toews
• Re: cygwin and postgresql
  • From: James B. Byrne
• Re: Amazon EC2 | Any recent developments
  • From: Just Someone
• Re: 10 TB database
  • From: Dann Corbit
• Re: Amazon EC2 | Any recent developments
  • From: David Kerr
• Re: horizontal sharding
  • From: Scott Marlowe
• Amazon EC2 | Any recent developments
  • From: AJAY A
• Re: 10 TB database
  • From: Alvaro Herrera
• Re: horizontal sharding
  • From: Jim Mlodgenski
• Re: horizontal sharding
  • From: John R Pierce
• Re: horizontal sharding
  • From: Jim Mlodgenski
• Re: Trigger Function and backup
  • From: Merlin Moncure
• Re: cygwin and postgresql
  • From: Scott Marlowe
• Re: String Manipulation
  • From: Christine Penner
• Re: Custom Fields Database Architecture
  • From: David Goodenough
• Re: Trigger Function and backup
  • From: Vick Khera
• Re: horizontal sharding
  • From: David Fetter
• Re: Custom Fields Database Architecture
  • From: David Fetter
• Re: Rounding incompatibility
  • From: Dave Page
• Custom Fields Database Architecture
  • From: Gnanam
• horizontal sharding
  • From: mobiledreamers
• Re: Rounding incompatibility
  • From: Gurjeet Singh
• Re: Rounding incompatibility
  • From: Tom Lane
• Re: cygwin and postgresql
  • From: James B. Byrne
• Re: help with data recovery from injected UPDATE
  • From: Merlin Moncure
• Re: 10 TB database
  • From: Whit Armstrong
• Re: 10 TB database
  • From: Grzegorz Jaśkiewicz
• 10 TB database
  • From: Artur
• Re: running pg_dump from python
  • From: Jasen Betts
• Re: cygwin and postgresql
  • From: Jasen Betts
• Re: Postgres 8.2 Memory Tuning
  • From: Massa, Harald Armin
• Postgres 8.2 Memory Tuning
  • From: CM J
• Rounding incompatibility
  • From: Havasvölgyi Ottó
• Re: Trigger Function and backup
  • From: Havasvölgyi Ottó
• Trigger Function and backup
  • From: Nishkarsh
• Re: WITH RECURSIVE clause -- all full and partial paths
  • From: aryoo
• Re: Postgres connectivity problem.
  • From: John R Pierce
• Postgres connectivity problem.
  • From: Bhujbal, Santosh
• Re: citext.so
  • From: Sim Zacks
• Re: help with data recovery from injected UPDATE
  • From: Craig Ringer
• Re: Opinions on how to Integrate Transactions
  • From: Craig Ringer
• Re: Opinions on how to Integrate Transactions
  • From: Tomas Vondra
• Re: running pg_dump from python
  • From: Tom Lane
• Re: running pg_dump from python
  • From: Garry Saddington
• Re: running pg_dump from python
  • From: Scott Mead
• running pg_dump from python
  • From: Garry Saddington
• Re: cygwin and postgresql
  • From: James B. Byrne
• Re: cygwin and postgresql
  • From: James B. Byrne
• Re: cygwin and postgresql
  • From: Scott Marlowe
• Re: cygwin and postgresql
  • From: Tom Lane
• Re: cygwin and postgresql
  • From: James B. Byrne
• Re: cygwin and postgresql
  • From: Tom Lane
• cygwin and postgresql
  • From: James B. Byrne
• Re: help with data recovery from injected UPDATE
  • From: Gus Gutoski
• Opinions on how to Integrate Transactions
  • From: APseudoUtopia
• Re: terminating connection because of crash of another server process
  • From: Tom Lane
• terminating connection because of crash of another server process
  • From: sergio nogueira
• Re: Escaping regular expressions in plperl
  • From: Tom Lane
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Peter Eisentraut
• citext.so
  • From: Sim Zacks
• Re: citext.so
  • From: Sim Zacks
• Escaping regular expressions in plperl
  • From: Toomas Vendelin
• Re: accessing anyarray elements
  • From: Tom Lane
• Re: How to store text files in the postgresql?
  • From: Alban Hertroys
• Re: Maintenance database SQL_ASCII
  • From: Alban Hertroys
• Re: String Manipulation
  • From: Alban Hertroys
• Re: How to know the indexes on a Table
  • From: Frank Heikens
• Re: How to store text files in the postgresql?
  • From: Craig Ringer
• Re: How to store text files in the postgresql?
  • From: Craig Ringer
• Re: Very slow searching in a table with more than 10 millions recovered records from a backup file...
  • From: Craig Ringer
• Re: Very slow searching in a table with more than 10 millions recovered records from a backup file...
  • From: zxo102 ouyang
• Maintenance database SQL_ASCII
  • From: Brad Schick
• Re: String Manipulation
  • From: Sam Mason
• Re: String Manipulation
  • From: Christine Penner
• accessing anyarray elements
  • From: Michael Glaesemann
• Re: String Manipulation
  • From: Sam Mason
• Re: WITH RECURSIVE clause -- all full and partial paths
  • From: David Fetter
• Re: String Manipulation
  • From: Christine Penner
• Re: String Manipulation
  • From: Sam Mason
• String Manipulation
  • From: Christine Penner
• Re: search for partial dates
  • From: Scott Marlowe
• Re: WITH RECURSIVE clause -- all full and partial paths
  • From: Harald Fuchs
• Re: search for partial dates
  • From: Sam Mason
• Re: Behavior of NpgsqlDataReader in NpgSql 1 and NpgSql 2
  • From: Francisco Figueiredo Jr.
• Behavior of NpgsqlDataReader in NpgSql 1 and NpgSql 2
  • From: Nishkarsh
• Re: Having trouble restoring our backups
  • From: Bryan Murphy
• Re: Having trouble restoring our backups
  • From: Bryan Murphy
• Re: How to store text files in the postgresql?
  • From: Alan Hodgson
• WITH RECURSIVE clause -- all full and partial paths
  • From: aryoo
• Re: How to store text files in the postgresql?
  • From: Scott Ribe
• Re: Having trouble restoring our backups
  • From: Alan Hodgson
• Re: How to store text files in the postgresql?
  • From: Alan Hodgson
• Having trouble restoring our backups
  • From: Bryan Murphy
• Re: [HACKERS] PostgreSQL installation
  • From: Emanuel Calvo Franco
• Re: How to store text files in the postgresql?
  • From: Andy Colson
• Re: How to store text files in the postgresql?
  • From: Scott Ribe
• Re: How to store text files in the postgresql?
  • From: Greg Stark
• Re: search for partial dates
  • From: James B. Byrne
• Re: How to store text files in the postgresql?
  • From: Emanuel Calvo Franco
• Re: How to store text files in the postgresql?
  • From: Andy Colson
• Re: Finding time of last pg_stat_reset
  • From: Bruce Momjian
• Re: Libpq on windows
  • From: Jasen Betts
• Re: Libpq on windows
  • From: Jasen Betts
• Re: help with data recovery from injected UPDATE
  • From: Chris Spotts
• Re: Libpq on windows
  • From: Jasen Betts
• Re: How to store text files in the postgresql?
  • From: Yaroslav Tykhiy
• Re: Very slow searching in a table with more than 10 millions recovered records from a backup file...
  • From: Grzegorz Jaśkiewicz
• Very slow searching in a table with more than 10 millions recovered records from a backup file...
  • From: zxo102 ouyang
• Finding time of last pg_stat_reset
  • From: Tommy Gildseth
• Retrieving performance information on a query
  • From: Karl Denninger
• Re: search for partial dates
  • From: Leif B. Kristensen
• Re: When to use cascading deletes?
  • From: Leif B. Kristensen
• Re: listing relations
  • From: Greg Smith
• Re: Postgres auditing features
  • From: Alvaro Herrera
• Re: search for partial dates
  • From: Andy Colson
• Re: help with data recovery from injected UPDATE
  • From: Scott Marlowe
• Re: Postgres auditing features
  • From: Greg Smith
• Re: listing relations
  • From: Brandon Metcalf
• Re: listing relations
  • From: Tom Lane
• Re: search for partial dates
  • From: Scott Marlowe
• Re: listing relations
  • From: Brandon Metcalf
• Re: listing relations
  • From: Raymond O'Donnell
• Re: listing relations
  • From: Brandon Metcalf
• Re: search for partial dates
  • From: Tom Lane
• Re: search for partial dates
  • From: Christophe
• search for partial dates
  • From: James B. Byrne
• Re: listing relations
  • From: Tom Lane
• Re: When to use cascading deletes?
  • From: Russ Brown
• listing relations
  • From: Brandon Metcalf
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Joshua D. Drake
• Re: help with data recovery from injected UPDATE
  • From: Chris Spotts
• Re: Function: Change data while walking through records
  • From: stevesub
• Re: help with data recovery from injected UPDATE
  • From: Gus Gutoski
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Josh Berkus
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Dave Page
• Re: queries on xmin
  • From: Marko Kreen
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Joshua D. Drake
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Josh Berkus
• Re: Array Parameters in EXECUTE
  • From: Sim Zacks
• Re: When to use cascading deletes?
  • From: Eric Schwarzenbach
• Re: queries on xmin
  • From: Matt Amos
• Postgres auditing features
  • From: SHARMILA JOTHIRAJAH
• Re: Wither 8.3 doc's on cast operator for domain data types?
  • From: Tom Lane
• Wither 8.3 doc's on cast operator for domain data types?
  • From: Steven Lembark
• Re: When to use cascading deletes?
  • From: Richard Broersma
• Re: [pgsql-general] Daily digest v1.9081 (14 messages)
  • From: David Fetter
• Re: help with data recovery from injected UPDATE
  • From: Merlin Moncure
• Re: Libpq on windows
  • From: Andy Colson
• Re: Libpq on windows
  • From: Andy Colson
• Re: Libpq on windows
  • From: Phil Longstaff
• Re: help with data recovery from injected UPDATE
  • From: Vick Khera
• Re: queries on xmin
  • From: Marko Kreen
• Re: Libpq on windows
  • From: Andy Colson
• Re: queries on xmin
  • From: Marko Kreen
• Re: Postgres Pg_connect PHP
  • From: Vyacheslav Kalinin
• Re: Libpq on windows
  • From: Phil Longstaff
• Re: Postgres Pg_connect PHP
  • From: A B
• Re: Libpq on windows
  • From: Phil Longstaff
• Re: Postgres Pg_connect PHP
  • From: Dimitri Fontaine
• Re: queries on xmin
  • From: Matt Amos
• Re: queries on xmin
  • From: Matt Amos
• Re: queries on xmin
  • From: Brett Henderson
• Re: queries on xmin
  • From: Greg Stark
• Re: Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
  • From: Pavel Stehule
• Re: queries on xmin
  • From: Brett Henderson
• Re: When to use cascading deletes?
  • From: Greg Stark
• Re: When to use cascading deletes?
  • From: Sim Zacks
• Re: Array Parameters in EXECUTE
  • From: Sim Zacks
• Re: When to use cascading deletes?
  • From: Steve Clark
• Re: queries on xmin
  • From: Marko Kreen
• Re: queries on xmin
  • From: Greg Stark
• Re: Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
  • From: hubert depesz lubaczewski
• Re: Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
  • From: Pavel Stehule
• Re: When to use cascading deletes?
  • From: David
• queries on xmin
  • From: Matt Amos
• Re: Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
  • From: hubert depesz lubaczewski
• Re: Array Parameters in EXECUTE
  • From: Shakil Shaikh
• Re: When to use cascading deletes?
  • From: Alban Hertroys
• Re: Array Parameters in EXECUTE
  • From: Pavel Stehule
• Array Parameters in EXECUTE
  • From: Shakil Shaikh
• sort by update
  • From: Sim Zacks
• When to use cascading deletes?
  • From: David
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Dave Page
• Re: Libpq on windows
  • From: Albe Laurenz
• Re: Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
  • From: Pavel Stehule
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Chris
• Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Josh Berkus
• Re: "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Christophe
• Re: Libpq on windows
  • From: Andy Colson
• Re: "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Chris
• "Rails and PostgreSQL" now up on media.postgresql.org
  • From: Christophe
• Libpq on windows
  • From: Phil Longstaff
• Re: help with data recovery from injected UPDATE
  • From: Tom Lane
• help with data recovery from injected UPDATE
  • From: Gus Gutoski
• Re: Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
  • From: Tom Lane
• Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
  • From: Atul Chojar
• Re: fulltext search udf
  • From: Andreas Wenk
• Re: Average connections
  • From: Pedro Doria Meunier
• Re: fulltext search udf
  • From: Tom Lane
• fulltext search udf
  • From: Andreas Wenk
• Re: Average connections
  • From: Bill Moran
• Re: Average connections
  • From: Brad Nicholson
• Re: Average connections
  • From: Pedro Doria Meunier
• Re: Upgrade from Postgres 8.2.4 to 8.3.5
  • From: Tom Lane
• Re: Average connections
  • From: Bill Moran
• Average connections
  • From: Pedro Doria Meunier
• Re: Upgrade from Postgres 8.2.4 to 8.3.5
  • From: Nykolyn, Andrew P (AS)
• Re: limit table to one row
  • From: Jasen Betts
• Re: Postgres's Performance degrades after heavy db operation
  • From: Bill Moran
• Re: Postgres's Performance degrades after heavy db operation
  • From: Scott Marlowe
• Re: Postgres's Performance degrades after heavy db operation
  • From: Preeti Khurana
• Mogwai ER-DesignerNG 1.7-SNAPSHOT available
  • From: Mirko Sertic
• Re: INTERVAL SECOND limited to 59 seconds?
  • From: Ron Mayer
• Re: INTERVAL SECOND limited to 59 seconds?
  • From: Tom Lane
• Re: INTERVAL SECOND limited to 59 seconds?
  • From: Ron Mayer
• Re: INTERVAL SECOND limited to 59 seconds?
  • From: Tom Lane
• Re: INTERVAL SECOND limited to 59 seconds?
  • From: Tom Lane
• Re: aliases for sequences and other DB objects?
  • From: Alvaro Herrera
• Re: aliases for sequences and other DB objects?
  • From: Frank Heikens
• Re: Duplicate key issue in a transaction block
  • From: Ioana Danes
• aliases for sequences and other DB objects?
  • From: Agoston Postgres
• Re: Postgres Pg_connect PHP
  • From: Vyacheslav Kalinin
• Re: Postgres Pg_connect PHP
  • From: Vyacheslav Kalinin
• Re: Postgres Pg_connect PHP
  • From: Tory M Blue
• Re: Postgres Pg_connect PHP
  • From: Vyacheslav Kalinin
• Re: Postgres Pg_connect PHP
  • From: Joshua D. Drake
• Postgres Pg_connect PHP
  • From: Tory M Blue
• Re: type cast in index
  • From: Linos
• Re: type cast in index
  • From: Tom Lane
• Re: type cast in index
  • From: Alvaro Herrera
• Re: type cast in index
  • From: Chris Spotts
• Re: Can postgresql store its data on raw device now?
  • From: Chris Browne
• Re: limit table to one row
  • From: Octavio Alvarez
• type cast in index
  • From: Linos
• Re: postgres getting slow under heavy load though autivacuum is enabled
  • From: Vick Khera
• Re: postgres getting slow under heavy load though autivacuum is enabled
  • From: Dimitri Fontaine
• Re: limit table to one row
  • From: Brandon Metcalf
• Re: limit table to one row
  • From: Grzegorz Jaśkiewicz
• Re: column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!
  • From: Stephan Szabo
• Re: limit table to one row
  • From: Brandon Metcalf
• Re: column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!
  • From: G. Allegri
• Re: limit table to one row
  • From: Grzegorz Jaśkiewicz
• Re: column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!
  • From: G. Allegri
• Re: column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!
  • From: Richard Huxton
• Re: postgres getting slow under heavy load though autivacuum is enabled
  • From: Bill Moran
• Re: limit table to one row
  • From: Brandon Metcalf
• column name gets substitudes inside an execute statement of a trigger function. how to avoid it?!
  • From: G. Allegri
• Re: Why lots of temp schemas are being created
  • From: Merlin Moncure
• Re: Can postgresql store its data on raw device now?
  • From: Merlin Moncure
• Re: postgres getting slow under heavy load though autivacuum is enabled
  • From: Grzegorz Jaśkiewicz
• postgres getting slow under heavy load though autivacuum is enabled
  • From: tamanna madaan
• Re: Move PGdata to a different drive
  • From: Jasen Betts
• Re: limit table to one row
  • From: Jasen Betts
• Re: Block_Size on NTFS
  • From: Bruce Momjian
• Re: Block_Size on NTFS
  • From: postgresqlgeneral . domain . thewild_codata
• Re: Block_Size on NTFS
  • From: postgresqlgeneral . domain . thewild_codata
• Re: Block_Size on NTFS
  • From: Craig Ringer
• Re: Sum of multiplied deltas
  • From: Martin Gainty
• Re: Block_Size on NTFS
  • From: Bruce Momjian
• Re: Text search without dictionary ?
  • From: Oleg Bartunov
• Re: Sum of multiplied deltas
  • From: Marc Mamin
• Text search without dictionary ?
  • From: Marc Mamin
• Block_Size on NTFS
  • From: postgresqlgeneral . domain . thewild_codata
• Re: Can postgresql store its data on raw device now?
  • From: Dave Page
• Re: Can postgresql store its data on raw device now?
  • From: Gurjeet Singh
• Can postgresql store its data on raw device now?
  • From: Lizzy M
• Re: Move PGdata to a different drive
  • From: Yaroslav Tykhiy
• Re: Why lots of temp schemas are being created
  • From: Craig Ringer
• Re: INTERVAL SECOND limited to 59 seconds?
  • From: Ron Mayer
• Streaming SFPUG: PostgreSQL & Rails June 9 (tommorrow)
  • From: Josh Berkus
• Re: max execution time of query
  • From: Chris
• Re: Sum of multiplied deltas
  • From: Daniel Verite
• Foreign Key Unique Constraint can be dropped
  • From: Vlado Moravec
• Re: Function: Change data while walking through records
  • From: Albe Laurenz
• Entering time into postgresql
  • From: BlackMage
• Re: invalid byte sequence for encoding "UTF8": 0xab
  • From: Albe Laurenz
• PL/PGSQL
  • From: Jordi Martínez
• Re: PostgreSQL and XA Distributed Transaction Protocol
  • From: Albe Laurenz
• Re: Adding the host name to the PgSQL shell
  • From: Roderick A. Anderson
• Re: Server admin for Clients ?
  • From: Albe Laurenz