Postgresql General Discussion

• Thread Index

• Help me with this multi-table query
  • From: Nilesh Govindarajan
• Re: PL/pgSQL & OVERLAPS operator
  • From: Tuo Pe
• Re: Before triggers and usage in partitioned tables
  • From: Albe Laurenz
• Re: pgreplay log file replayer released
  • From: Albe Laurenz
• Re: Before triggers and usage in partitioned tables
  • From: Sergio Ramazzina
• Re: strange
  • From: Grzegorz Jaśkiewicz
• Re: Before triggers and usage in partitioned tables
  • From: Scott Mead
• Re: strange
  • From: Filip Rembiałkowski
• Re: Creating a view: ERROR: rules on SELECT must have action INSTEAD SELECT
  • From: Filip Rembiałkowski
• Re: pgreplay log file replayer released
  • From: Dimitri Fontaine
• Re: PL/pgSQL & OVERLAPS operator
  • From: A. Kretschmer
• PL/pgSQL & OVERLAPS operator
  • From: Tuo Pe
• Re: db error messages when I try to debug with pgadmin
  • From: josep porres
• Before triggers and usage in partitioned tables
  • From: Sergio Ramazzina
• Re: pgreplay log file replayer released
  • From: Albe Laurenz
• Re: Replace null values
  • From: Ian Haywood
• Re: Replace null values
  • From: Nilesh Govindarajan
• Re: Replace null values
  • From: Nilesh Govindarajan
• Re: Replace null values
  • From: John R Pierce
• Re: Create a function that updates the record with and timestamps
  • From: A. Kretschmer
• Re: Replace null values
  • From: Nilesh Govindarajan
• Re: Replace null values
  • From: Nilesh Govindarajan
• Re: Replace null values
  • From: John R Pierce
• Replace null values
  • From: Nilesh Govindarajan
• Re: string functions and operators
  • From: John R Pierce
• string functions and operators
  • From: Neil Stlyz
• Re: Create a function that updates the record with and timestamps
  • From: Adrian Klaver
• Re: How to dump JUST procedures/funnctions?
  • From: Tony Wasson
• server-side extension in c++
  • From: Igor
• Re: pgreplay log file replayer released
  • From: Dimitri Fontaine
• Re: Create a function that updates the record with and timestamps
  • From: Chris Barnes
• Re: Postgresql error from interface
  • From: Tom Lane
• Postgresql error from interface
  • From: Bob Pawley
• Re: Create a function that updates the record with and timestamps
  • From: A. Kretschmer
• Re: strange
  • From: Szymon Guz
• Create a function that updates the record with and timestamps
  • From: Chris Barnes
• Re: Reducing excess files in pg_xlog
  • From: Tom Lane
• Re: Reducing excess files in pg_xlog
  • From: Thom Brown
• Re: strange
  • From: Tom Lane
• Avoiding deadlocks on mass delete / update
  • From: Роман Маширов
• Re: strange
  • From: Greg Smith
• Re: user variables in session
  • From: Merlin Moncure
• user variables in session
  • From: Igor Shevchenko
• Re: Reducing excess files in pg_xlog
  • From: Greg Smith
• Re: stopping processes, preventing connections
  • From: Dimitri Fontaine
• Re: Determining the OID of a certain type
  • From: Carsten Kropf
• Re: pgreplay log file replayer released
  • From: Greg Stark
• Re: Determining the OID of a certain type
  • From: Tom Lane
• Re: Daylight savings time confusion
  • From: Alban Hertroys
• Re: Determining the OID of a certain type
  • From: Carsten Kropf
• Re: Reducing excess files in pg_xlog
  • From: Thom Brown
• Re: Reducing excess files in pg_xlog
  • From: Tom Lane
• Re: Reducing excess files in pg_xlog
  • From: Thom Brown
• Warm Standby Setup Documentation
  • From: Ogden
• Re: Reducing excess files in pg_xlog
  • From: Tom Lane
• Reducing excess files in pg_xlog
  • From: Thom Brown
• Holger Kalbas
  • From: william wayne
• Re: Daylight savings time confusion
  • From: Rob Richardson
• Re: Determining the OID of a certain type
  • From: Tom Lane
• Re: How to dump JUST procedures/funnctions?
  • From: Tom Lane
• Determining the OID of a certain type
  • From: Carsten Kropf
• Re: AIX postgresql error
  • From: Albe Laurenz
• Re: Full Text Search: howto manage multiple languages ?
  • From: Cédric MOULLET
• Re: Restrict allowed database names?
  • From: Adrian von Bidder
• Re: Licence
  • From: Adrian von Bidder
• Re: Full Text Search: howto manage multiple languages ?
  • From: Oleg Bartunov
• Re: How to dump JUST procedures/funnctions?
  • From: Carlo Stonebanks
• How to add an external lib to PG
  • From: chaoyong wang
• Re: strange
  • From: Tom Lane
• DBT-2 Installation error
  • From: Megha
• Full Text Search: howto manage multiple languages ?
  • From: Cédric MOULLET
• strange
  • From: Szymon Guz
• Re: Licence
  • From: Lew
• unsubscribe
  • From: dev mas
• Re: Transaction table
  • From: Scott Marlowe
• Re: Problems with "CREATE CAST"
  • From: John Shott
• Re: Transaction table
  • From: John R Pierce
• Re: Problems with "CREATE CAST"
  • From: Tom Lane
• Re: Transaction table
  • From: Vick Khera
• Problems with "CREATE CAST"
  • From: John Shott
• Re: Restrict allowed database names?
  • From: Tom Lane
• Re: Restrict allowed database names?
  • From: Sergey Konoplev
• Re: Restrict allowed database names?
  • From: Daniel Verite
• Re: Restrict allowed database names?
  • From: Sergey Konoplev
• Re: stopping processes, preventing connections
  • From: Scott Marlowe
• Hans Samses
  • From: william wayne
• Re: stopping processes, preventing connections
  • From: Craig Ringer
• Re: like operation in tsearch
  • From: Pavel Stehule
• Re: like operation in tsearch
  • From: AI Rumman
• Re: Help me with this tricky join
  • From: A. Kretschmer
• Re: How to dump JUST procedures/funnctions?
  • From: A. Kretschmer
• Re: Wordpress-Mu with postgresql
  • From: Nilesh Govindarajan
• Wordpress-Mu with postgresql
  • From: AI Rumman
• Re: How to dump JUST procedures/funnctions?
  • From: Carlo Stonebanks
• Re: like operation in tsearch
  • From: Oleg Bartunov
• like operation in tsearch
  • From: AI Rumman
• Re: Restrict allowed database names?
  • From: Steve Atkins
• Re: Restrict allowed database names?
  • From: Scott Mead
• Restrict allowed database names?
  • From: Adam Seering
• Re: Help me with this tricky join
  • From: Jay
• Re: stopping processes, preventing connections
  • From: Scott Marlowe
• Restrict allowed database names?
  • From: Adam Seering
• Re: stopping processes, preventing connections
  • From: Herouth Maoz
• Re: stopping processes, preventing connections
  • From: Scott Marlowe
• Re: stopping processes, preventing connections
  • From: Herouth Maoz
• Re: Transaction table
  • From: Scott Mead
• Re: Transaction table
  • From: Scott Marlowe
• Transaction table
  • From: Deepa Thulasidasan
• Re: How to dump JUST procedures/funnctions?
  • From: Andreas Kretschmer
• How to dump JUST procedures/funnctions?
  • From: Carlo Stonebanks
• Re: Help me with this tricky join
  • From: Andreas Kretschmer
• Locale problem
  • From: S Arvind
• Re: returns 0 row from plpgsql function
  • From: Pavel Stehule
• Re: MS Access 2007 update write conflict problem & resolution
  • From: Craig Ringer
• returns 0 row from plpgsql function
  • From: zhong ming wu
• Re: MS Access 2007 update write conflict problem & resolution
  • From: justin@xxxxxxxxxxxx
• Call for translations
  • From: Peter Eisentraut
• Re: MS Access 2007 update write conflict problem & resolution
  • From: Richard Broersma
• Re: Query inside a C-Function
  • From: Joe Conway
• Query inside a C-Function
  • From: Enzo Cappa
• Re: AIX postgresql error
  • From: Vikram Patil
• Re: MS Access 2007 update write conflict problem & resolution
  • From: justin@xxxxxxxxxxxx
• Re: Help me with this tricky join
  • From: Jay
• Help me with this tricky join
  • From: Jay
• Re: Order of Daily VACUUM, CLUSTER, REINDEX
  • From: Alvaro Herrera
• Re: Order of Daily VACUUM, CLUSTER, REINDEX
  • From: Leonardo F
• Postgres officially accepted in to 2010 Google Summer of Code program
  • From: Robert Treat
• MS Access 2007 update write conflict problem & resolution
  • From: Little, Douglas
• Re: Many-to-many problem
  • From: Raymond O'Donnell
• Re: Order of Daily VACUUM, CLUSTER, REINDEX
  • From: Grzegorz Jaśkiewicz
• Order of Daily VACUUM, CLUSTER, REINDEX
  • From: APseudoUtopia
• Creating a view: ERROR: rules on SELECT must have action INSTEAD SELECT
  • From: David Waddy
• Re: AIX postgresql error
  • From: Albe Laurenz
• Re: compile a program witn libpq64 (error LIBCMT.Lib...)
  • From: elekis
• Re: accounting package
  • From: SUNDAY A. OLUTAYO
• Re: Will multiple CPU cores be used for expensive query
  • From: Devrim GÜNDÜZ
• Will multiple CPU cores be used for expensive query
  • From: Allan Kamau
• Re: Many-to-many problem
  • From: Grant Allen
• Re: building a c function
  • From: Stuart McGraw
• AIX postgresql error
  • From: Vikram Patil
• Re: Many-to-many problem
  • From: Joe Conway
• Many-to-many problem
  • From: Raymond O'Donnell
• Re: database connections and presenting data on the web
  • From: John R Pierce
• Error de postgres con lenguaje C
  • From: Juan Nunez
• Re: Who is locking me?
  • From: Tim Bruce - Postgres
• Re: accounting package
  • From: Ovnicraft
• Re: Who is locking me?
  • From: Tom Lane
• [no subject]
  • From: Justin Graf
• Re: Who is locking me?
  • From: Bill Moran
• Who is locking me?
  • From: Abraham, Danny
• Re: accounting package
  • From: Roderick A. Anderson
• Re: accounting package
  • From: Scott Mead
• accounting package
  • From: Garry Saddington
• Re: database connections and presenting data on the web
  • From: Geoffrey
• Re: definitions of regexp functions required
  • From: Craig Ringer
• Re: tables getting bloated
  • From: Craig Ringer
• Re: database connections and presenting data on the web
  • From: Craig Ringer
• Re: definitions of regexp functions required
  • From: Albe Laurenz
• Re: tables getting bloated
  • From: Vick Khera
• Re: compile a program witn libpq64 (error LIBCMT.Lib...)
  • From: Ashesh Vashi
• compile a program witn libpq64 (error LIBCMT.Lib...)
  • From: elekis
• Re: tables getting bloated
  • From: akp geek
• Re: tables getting bloated
  • From: Devrim GÜNDÜZ
• tables getting bloated
  • From: akp geek
• Re: database connections and presenting data on the web
  • From: Yeb Havinga
• database connections and presenting data on the web
  • From: Geoffrey
• definitions of regexp functions required
  • From: Ehsan Haq
• Re: update ... set ... subquery
  • From: Alban Hertroys
• Re: update ... set ... subquery
  • From: John Smith
• Re: update ... set ... subquery
  • From: hubert depesz lubaczewski
• Re: building a c function
  • From: Carsten Kropf
• Re: update ... set ... subquery
  • From: Szymon Guz
• Re: building a c function
  • From: Tom Lane
• update ... set ... subquery
  • From: John Smith
• building a c function
  • From: Stuart McGraw
• Re: stopping processes, preventing connections
  • From: Greg Smith
• Re: stopping processes, preventing connections
  • From: Tom Lane
• Re: Bulkdelete and Vacuum operations on custom index
  • From: Tom Lane
• DBT-2 Error
  • From: Chokshi, Meghaben
• Re: Unexpected result from selecting an aliased but non-existing column called "name"
  • From: Ian Barwick
• Re: app table names
  • From: Vick Khera
• db error messages when I try to debug with pgadmin
  • From: josep porres
• Re: stopping processes, preventing connections
  • From: Herouth Maoz
• Re: stopping processes, preventing connections
  • From: Craig Ringer
• Re: stopping processes, preventing connections
  • From: Herouth Maoz
• Bulkdelete and Vacuum operations on custom index
  • From: Carsten Kropf
• Re: stopping processes, preventing connections
  • From: Craig Ringer
• Re: return row from plpgsql?
  • From: zhong ming wu
• Re: Avoiding SQL injection in Dynamic Queries (in plpgsql)
  • From: Pavel Stehule
• Re: stopping processes, preventing connections
  • From: Herouth Maoz
• Re: Avoiding SQL injection in Dynamic Queries (in plpgsql)
  • From: Allan Kamau
• Re: Avoiding SQL injection in Dynamic Queries (in plpgsql)
  • From: Craig Ringer
• Avoiding SQL injection in Dynamic Queries (in plpgsql)
  • From: Allan Kamau
• Re: return row from plpgsql?
  • From: A. Kretschmer
• return row from plpgsql?
  • From: zhong ming wu
• Result order of Insert ... returning
  • From: fsfeel
• Re: app table names
  • From: Joshua D. Drake
• Re: app table names
  • From: Justin Graf
• Re: app table names
  • From: Vick Khera
• Answer to my own question
  • From: John Gage
• Re: app table names
  • From: Scott Marlowe
• Best ISP for Postgres
  • From: John Gage
• app table names
  • From: Jamie Kahgee
• Re: reuse data in existing data directory
  • From: Peter Schmidtke
• Re: UPDATE with JOIN not using index
  • From: Arnaud Lesauvage
• Re: UPDATE with JOIN not using index
  • From: Tom Lane
• Re: Move to core xml from contrib/xml2
  • From: Tom Lane
• Re: Move to core xml from contrib/xml2
  • From: Frank jansen
• Re: restoring a database to its initial state
  • From: Manlio Perillo
• Re: Daylight savings time confusion
  • From: Alvaro Herrera
• Re: UPDATE with JOIN not using index
  • From: Arnaud Lesauvage
• Re: UPDATE with JOIN not using index
  • From: Arnaud Lesauvage
• Re: UPDATE with JOIN not using index
  • From: tv
• Re: Text search
  • From: Chris Roffler
• Re: UPDATE with JOIN not using index
  • From: Arnaud Lesauvage
• Re: Text search
  • From: Richard Huxton
• Re: UPDATE with JOIN not using index
  • From: Tom Lane
• Re: UPDATE with JOIN not using index
  • From: Richard Huxton
• Re: hardware for a server
  • From: Bruce Momjian
• Re: UPDATE with JOIN not using index
  • From: Arnaud Lesauvage
• Re: UPDATE with JOIN not using index
  • From: Richard Huxton
• Re: Text search
  • From: Richard Huxton
• UPDATE with JOIN not using index
  • From: Arnaud Lesauvage
• Re: Text search
  • From: Chris Roffler
• Re: reuse data in existing data directory
  • From: Richard Huxton
• Re: Text search
  • From: Richard Huxton
• reuse data in existing data directory
  • From: Peter Schmidtke
• Text search
  • From: Chris Roffler
• Re: hardware for a server
  • From: Greg Smith
• Re: hardware for a server
  • From: Greg Smith
• Re: hardware for a server
  • From: Greg Smith
• Re: ERROR: Package compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm is not signed
  • From: Padmanabhan G
• Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)
  • From: Tom Lane
• Re: Daylight savings time confusion
  • From: Tom Lane
• Re: Daylight savings time confusion
  • From: Adrian Klaver
• Re: Daylight savings time confusion
  • From: Steve Crawford
• Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)
  • From: Joseph S
• Re: FW: 8.4.2 One Click Installer
  • From: Richard Huxton
• Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)
  • From: Richard Huxton
• Re: Move to core xml from contrib/xml2
  • From: Bruce Momjian
• Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)
  • From: Magnus Hagander
• Re: Daylight savings time confusion
  • From: Rob Richardson
• Re: Daylight savings time confusion
  • From: Justin Graf
• FW: 8.4.2 One Click Installer
  • From: Arnold, Sandra
• Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)
  • From: Joseph S
• Re: Installing Postgresql on Windows XP embedded
  • From: Magnus Hagander
• Re: hardware for a server
  • From: John R Pierce
• Re: Installing Postgresql on Windows XP embedded
  • From: John R Pierce
• Daylight savings time confusion
  • From: Rob Richardson
• Re: hardware for a server
  • From: Vick Khera
• Re: integer_datetime: 8.2/8.4 differences ?
  • From: Tom Lane
• Re: hardware for a server
  • From: Bruce Momjian
• Efficient "filter query" with positive and/or negative conditions
  • From: Anders Steinlein
• Re: Installing Postgresql on Windows XP embedded
  • From: John R Pierce
• integer_datetime: 8.2/8.4 differences ?
  • From: fkater@xxxxxxxxxxxxxx
• Re: Postgres 8.4 Segfault on xpath
  • From: Alvaro Herrera
• Re: hardware for a server
  • From: A B
• Re: libpq: compatibility with server versions
  • From: Vick Khera
• Re: libpq: compatibility with server versions
  • From: fkater@xxxxxxxxxxxxxx
• Move to core xml from contrib/xml2
  • From: Frank jansen
• Re: libpq: compatibility with server versions
  • From: Vick Khera
• Re: Installing Postgresql on Windows XP embedded
  • From: Jeffrey Ottery
• Re: Postgres 8.4 Segfault on xpath
  • From: Frank jansen
• Re: Unable to connect to Postgres database from email marketing software on the same host
  • From: A. Kretschmer
• Re: Options for fsync?
  • From: Greg Smith
• Re: Unable to connect to Postgres database from email marketing software on the same host
  • From: Major Services
• Re: hardware for a server
  • From: Greg Smith
• Re: Unable to connect to Postgres database from email marketing software on the same host
  • From: A. Kretschmer
• Re: Unable to connect to Postgres database from email marketing software on the same host
  • From: Major Services
• Fwd: Unable to connect to Postgres database from email marketing software on the same host
  • From: Major Services
• Re: Postgres 8.4 Segfault on xpath
  • From: Magnus Hagander
• Re: Unable to connect to Postgres database from email marketing software on the same host
  • From: Raymond O'Donnell
• Re: Unable to connect to Postgres database from email marketing software on the same host
  • From: A. Kretschmer
• Unable to connect to Postgres database from email marketing software on the same host
  • From: Major Services
• Re: Postgres 8.4 Segfault on xpath
  • From: Dimitri Fontaine
• Postgres 8.4 Segfault on xpath
  • From: Frank jansen
• Re: libpq: compatibility with server versions
  • From: Albe Laurenz
• Faicng problem while creating system DSN
  • From: itishree sukla
• Re: Yikes: ERROR: out of memory
  • From: Albe Laurenz
• Re: Installing Postgresql on Windows XP embedded
  • From: Dave Page
• Re: $libdir/plugins/plugin_debugger.dll
  • From: Dave Page
• Re: Yikes: ERROR: out of memory
  • From: Martijn van Oosterhout
• Re: How can I create a database at a different path and not accessible by others
  • From: John R Pierce
• How can I create a database at a different path and not accessible by others
  • From: Rekha Ravi Pai
• Installing Postgresql on Windows XP embedded
  • From: Jeffrey Ottery
• Yikes: ERROR: out of memory
  • From: Carlo Stonebanks
• $libdir/plugins/plugin_debugger.dll
  • From: Carlo Stonebanks
• Re: OIDs depending data -- how to dump/restore?
  • From: Adrian Klaver
• Re: unexplained autovacuum to prevent wraparound
  • From: Gordon Shannon
• Re: OIDs depending data -- how to dump/restore?
  • From: fkater@xxxxxxxxxxxxxx
• Re: Re: Is there any easy way to determine a default value specified for table column?
  • From: Tom Lane
• Re: Is there any easy way to determine a default value specified for table column?
  • From: Thomas Kellerer
• Re: OIDs depending data -- how to dump/restore?
  • From: Adrian Klaver
• Is there any easy way to determine a default value specified for table column?
  • From: Belka Lambda
• Re: hardware for a server
  • From: Vick Khera
• Re: OIDs depending data -- how to dump/restore?
  • From: Raymond O'Donnell
• OIDs depending data -- how to dump/restore?
  • From: fkater@xxxxxxxxxxxxxx
• Re: unexplained autovacuum to prevent wraparound
  • From: Alvaro Herrera
• Re: Options for fsync?
  • From: John R Pierce
• Options for fsync?
  • From: A B
• Re: unexplained autovacuum to prevent wraparound
  • From: Gordon Shannon
• libpq: compatibility with server versions
  • From: fkater@xxxxxxxxxxxxxx
• Re: ERROR: Package compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm is not signed
  • From: Lacey Powers
• Re: restoring a database to its initial state
  • From: Tom Lane
• Re: restoring a database to its initial state
  • From: Adrian von Bidder
• Re: restoring a database to its initial state
  • From: Pavel Stehule
• restoring a database to its initial state
  • From: Manlio Perillo
• Hints for postgresql package recompilation (FIXED)
  • From: Angel
• explicit cast for null::bigint
  • From: Ivan Sergio Borgonovo
• Re: hardware for a server
  • From: Scott Marlowe
• hardware for a server
  • From: A B
• Re: Function with DEFAULT arguments
  • From: Pavel Stehule
• Re: How to remove superuser
  • From: John R Pierce
• Re: How to remove superuser
  • From: Bruce Momjian
• Re: How to remove superuser
  • From: John R Pierce
• How to remove superuser
  • From: Harry Gold
• Re: unexplained autovacuum to prevent wraparound
  • From: Gordon Shannon
• Re: Function with DEFAULT arguments
  • From: dario.ber@xxxxxxxxx
• Re: unexplained autovacuum to prevent wraparound
  • From: Joshua D. Drake
• Re: unexplained autovacuum to prevent wraparound
  • From: Gordon Shannon
• Re: unexplained autovacuum to prevent wraparound
  • From: Alvaro Herrera
• unexplained autovacuum to prevent wraparound
  • From: Gordon Shannon
• static build from source on windows
  • From: Jan
• Re: ERROR: invalid byte sequence for encoding "UTF8":0x93 Error
  • From: Wang, Mary Y
• Re: ERROR: invalid byte sequence for encoding "UTF8":0x93 Error
  • From: Wang, Mary Y
• Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
  • From: Alvaro Herrera
• Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
  • From: Wang, Mary Y
• Re: Joining one-to-one and one-to-many tables
  • From: Jeff Ross
• [RFC] Comments on PostPic project
  • From: Domenico Rotiroti
• Re: Function with DEFAULT arguments
  • From: Tom Lane
• [RFC] Comments on PostPic project
  • From: Domenico Rotiroti
• Re: Function with DEFAULT arguments
  • From: Scott Bailey
• Re: Function with DEFAULT arguments
  • From: Tom Lane
• R: Re: Function with DEFAULT arguments
  • From: dario.ber@xxxxxxxxx
• Re: Unable to call functions defined in XML2 contrib
  • From: Franclin Foping
• Re: Function with DEFAULT arguments
  • From: hubert depesz lubaczewski
• Function with DEFAULT arguments
  • From: dario.ber@xxxxxxxxx
• Re: Unable to call functions defined in XML2 contrib
  • From: Tom Lane
• Re: beginning and ending of sessions
  • From: Guillaume Lelarge
• Re: Postgres GIS Question
  • From: akp geek
• Re: REVOKE ... FROM everybody?
  • From: Alvaro Herrera
• beginning and ending of sessions
  • From: jody
• Unable to call functions defined in XML2 contrib
  • From: Franclin Foping
• REVOKE ... FROM everybody?
  • From: Adrian von Bidder
• Re: querying the value of the previous row
  • From: John R Pierce
• Re: querying the value of the previous row
  • From: A. Kretschmer
• querying the value of the previous row
  • From: Chris Velevitch
• Re: dst question
  • From: jgirvin
• recuperar nodo en estado 3
  • From: Miguel Angel Hernandez Moreno
• PgEast Hotel discount deadline today!
  • From: Joshua D. Drake
• Re: createdb: ... duplicate key value violates unique constraint "pg_database_datname_index"
  • From: Dave Vitek
• createdb: ... duplicate key value violates unique constraint "pg_database_datname_index"
  • From: Dave Vitek
• Re: Joining one-to-one and one-to-many tables
  • From: Garrett Murphy
• Re: Naming conventions for lots of stored procedures
  • From: Pavel Stehule
• Re: kernel version impact on PostgreSQL performance
  • From: Cyril Scetbon
• Re: Small install (w/ pSQLODBC support) needed.
  • From: Sachin Srivastava
• Joining one-to-one and one-to-many tables
  • From: Jeff Ross
• Small install (w/ pSQLODBC support) needed.
  • From: Ozz Nixon
• Re: Naming conventions for lots of stored procedures
  • From: Gerhard Heift
• Re: log_statement and syslog severity
  • From: Greg Smith
• Re: Naming conventions for lots of stored procedures
  • From: Chris Travers
• Re: Replacing an index item
  • From: Tom Lane
• Re: instaling ossp-uuid
  • From: Devrim GÜNDÜZ
• instaling ossp-uuid
  • From: dunasoft
• Re: Naming conventions for lots of stored procedures
  • From: Justin Graf
• Re: how to remove super user
  • From: Ashesh Vashi
• Re: how to remove super user
  • From: Filip Rembiałkowski
• how to remove super user
  • From: Jowad Bouzian
• Replacing an index item
  • From: Carsten Kropf
• Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes
  • From: Greg Smith
• Re: Statement Triggers
  • From: A. Kretschmer
• Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes
  • From: Magnus Hagander
• Re: Finding duplicates only.
  • From: A. Kretschmer
• Re: dst question
  • From: Tom Lane
• Re: Naming conventions for lots of stored procedures
  • From: Chris Travers
• Re: crosstab functionality for postgres 8.1.4
  • From: Tom Lane
• Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes
  • From: Phillip Berry
• Re: Naming conventions for lots of stored procedures
  • From: Justin Graf
• Re: crosstab functionality for postgres 8.1.4
  • From: Merlin Moncure
• dst question
  • From: jgirvin
• Finding duplicates only.
  • From: Greenhorn
• Re: log_statement and syslog severity
  • From: Bruce Momjian
• Naming conventions for lots of stored procedures
  • From: Chris Travers
• crosstab functionality for postgres 8.1.4
  • From: Amol Chiplunkar
• Re: log_statement and syslog severity
  • From: dennis jenkins
• Re: Connection timeouts from pgAdmin
  • From: Lee Hachadoorian
• Re: Licence
  • From: Steve Crawford
• Re: How to? Timestamp with timezone.
  • From: Steve Crawford
• Re: regexp_replace puzzle
  • From: David W Noon
• Re: log_statement and syslog severity
  • From: Ben Chobot
• Statement Triggers
  • From: Gordan Bobic
• Re: Licence
  • From: Bill Moran
• Re: Licence
  • From: Thom Brown
• Licence
  • From: Jonathan Tripathy
• Re: regexp_replace puzzle
  • From: Osvaldo Kussama
• Re: How to? Timestamp with timezone.
  • From: Alvaro Herrera
• regexp_replace puzzle
  • From: Harald Fuchs
• Re: make available C extensions to others
  • From: Dimitri Fontaine
• make available C extensions to others
  • From: Ivan Sergio Borgonovo
• Re: Urgent help needed- alias name in update statement
  • From: Albe Laurenz
• Re: How to? Timestamp with timezone.
  • From: Andre Lopes
• Re: log_statement and syslog severity
  • From: Magnus Hagander
• Re: log_statement and syslog severity
  • From: Stuart Bishop
• Re: managing tablespaces like files?
  • From: Sam Carleton
• Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes
  • From: Scott Marlowe
• Re: error: C preprocessor "/lib/cpp" fails sanity check
  • From: Peter Eisentraut
• SAS Raid10 vs SATA II Raid10 - many small reads and writes
  • From: Phillip Berry
• Re: error: C preprocessor "/lib/cpp" fails sanity check
  • From: John R Pierce
• error: C preprocessor "/lib/cpp" fails sanity check
  • From: AI Rumman
• Re: Postgresql 8.1
  • From: Ben Chobot
• Postgresql 8.1
  • From: AI Rumman
• Re: log_statement and syslog severity
  • From: Bruce Momjian
• subscribe
  • From: Andrew Boag
• Re: How to? Timestamp with timezone.
  • From: Alvaro Herrera
• Re: warm standby possible with 8.1?
  • From: Greg Smith
• Re: How to? Timestamp with timezone.
  • From: John R Pierce
• Re: How to? Timestamp with timezone.
  • From: Andre Lopes
• Re: How to? Timestamp with timezone.
  • From: Tom Lane
• Re: Postgres GIS Question
  • From: Jeff Davis
• Re: Discovering Postgres Server from Windows Clients
  • From: Vick Khera
• Postgres GIS Question
  • From: akp geek
• Discovering Postgres Server from Windows Clients
  • From: imageguy
• Re: kernel version impact on PostgreSQL performance
  • From: Rodger Donaldson
• How to? Timestamp with timezone.
  • From: Andre Lopes
• Re: [pgsql-ru-general] Deleting Large Objects
  • From: Serguei Mokhov
• Re: obsessive-compulsive vacuum behavior
  • From: Ben Chobot
• Re: Not all functions in schema pg_catalog are "visible"
  • From: Alvaro Herrera
• Re: \copy command: how to define a tab character as the delimiter
  • From: Adrian Klaver
• Re: Update view/table rule order of operations or race condition
  • From: Dan Fitzpatrick
• Re: \copy command: how to define a tab character as the delimiter
  • From: Tom Lane
• PostgreSQL Conference East, Hotel Discount Deadline
  • From: Joshua D. Drake
• Re: \copy command: how to define a tab character as the delimiter
  • From: Thomas Kellerer
• Re: Update view/table rule order of operations or race condition
  • From: Tom Lane
• Re: question on 8.4.2 build postgres C functions
  • From: Tom Lane
• Re: Update view/table rule order of operations or race condition
  • From: Dan Fitzpatrick
• Re: \copy command: how to define a tab character as the delimiter
  • From: Raymond O'Donnell
• Re: question on 8.4.2 build postgres C functions
  • From: Tom Lane
• Re: \copy command: how to define a tab character as the delimiter
  • From: Thomas Kellerer
• Re: DROP column: documentation unclear
  • From: Tom Lane
• question on 8.4.2 build postgres C functions
  • From: Steve Coleman
• Re: Trying to get a C function built with MSVC
  • From: Bryan Montgomery
• Re: \copy command: how to define a tab character as the delimiter
  • From: Tom Lane
• Re: DROP column: documentation unclear
  • From: Harald Fuchs
• \copy command: how to define a tab character as the delimiter
  • From: Thomas Kellerer
• Re: kernel version impact on PostgreSQL performance
  • From: Greg Smith
• Update view/table rule order of operations or race condition
  • From: Dan Fitzpatrick
• Re: How many file descriptors does postgres need?
  • From: Tom Lane
• Re: Entering a character code in a query
  • From: John Gage
• Re: How many file descriptors does postgres need?
  • From: Steve Atkins
• Re: autovacuum question
  • From: Scot Kreienkamp
• How many file descriptors does postgres need?
  • From: Royce Ausburn
• Re: autovacuum question
  • From: Bryan Montgomery
• Re: autovacuum question
  • From: Scot Kreienkamp
• Re: autovacuum question
  • From: Scott Mead
• Re: log_statement and syslog severity
  • From: Greg Sabino Mullane
• Re: managing tablespaces like files?
  • From: Justin Graf
• Re: autovacuum question
  • From: Scot Kreienkamp
• Re: autovacuum question
  • From: Scott Mead
• Re: autovacuum question
  • From: Scott Marlowe
• Re: autovacuum question
  • From: Scot Kreienkamp
• Re: autovacuum question
  • From: Greg Stark
• Re: has_schema_privilege function
  • From: Greg Stark
• Re: Urgent help needed- alias name in update statement
  • From: Raymond O'Donnell
• Re: Urgent help needed- alias name in update statement
  • From: Adrian Klaver
• Re: Unexpected result from selecting an aliased but non-existing column called "name"
  • From: Adrian Klaver
• Urgent help needed- alias name in update statement
  • From: venkatrao . b
• Re: autovacuum question
  • From: Scot Kreienkamp
• Re: Entering a character code in a query
  • From: Albe Laurenz
• Re: Libpq: copy file to bytea column
  • From: Albe Laurenz
• warm standby possible with 8.1?
  • From: zhong ming wu
• Re: Can we overload = operator to word numeric = text
  • From: venkatrao . b
• Re: Can we overload = operator to word numeric = text
  • From: Pavel Stehule
• has_schema_privilege function
  • From: Jignesh Shah
• Can we overload = operator to word numeric = text
  • From: venkatrao . b
• Re: kernel version impact on PostgreSQL performance
  • From: Rodger Donaldson
• has_schema_privilege function
  • From: dipti shah
• Unexpected result from selecting an aliased but non-existing column called "name"
  • From: Ian Barwick
• Re: Is it possible to findout actual owner of table?
  • From: dipti shah
• Re: Is it possible to findout actual owner of table?
  • From: John R Pierce
• Re: Is it possible to findout actual owner of table?
  • From: dipti shah
• Re: kernel version impact on PostgreSQL performance
  • From: John R Pierce
• Re: kernel version impact on PostgreSQL performance
  • From: Greg Smith
• Re: [NOVICE] How to read oracle table's data from postgre
  • From: Greg Smith
• Re: Is it possible to findout actual owner of table?
  • From: John R Pierce
• Re: Is it possible to findout actual owner of table?
  • From: dipti shah
• How to save existing permissions on schema and later on restore it?
  • From: dipti shah
• Re: Is it possible to findout actual owner of table?
  • From: Tom Lane
• Is it possible to findout actual owner of table?
  • From: dipti shah
• Re: managing tablespaces like files?
  • From: Sam Carleton
• Re: autovacuum question
  • From: Tom Lane
• Re: autovacuum question
  • From: Scot Kreienkamp
• Re: autovacuum question
  • From: Scott Mead
• Re: managing tablespaces like files?
  • From: Scott Mead
• Re: managing tablespaces like files?
  • From: Tom Lane
• Re: managing tablespaces like files?
  • From: Sam Carleton
• Re: managing tablespaces like files?
  • From: John R Pierce
• autovacuum question
  • From: Scot Kreienkamp
• Re: managing tablespaces like files?
  • From: Sam Carleton
• Re: managing tablespaces like files?
  • From: Sam Carleton
• Re: DROP column: documentation unclear
  • From: Martijn van Oosterhout
• Re: managing tablespaces like files?
  • From: John R Pierce
• Re: managing tablespaces like files?
  • From: John R Pierce
• managing tablespaces like files?
  • From: Sam Carleton
• DROP column: documentation unclear
  • From: Adrian von Bidder
• Re: Enterprise DB's windows package and upgrading windows.
  • From: Dave Page
• Enterprise DB's windows package and upgrading windows.
  • From: John Moran
• Re: 8.3.10 Changes
  • From: Tom Lane
• ERROR: Package compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm is not signed
  • From: Padmanabhan G
• 2 questions to ask
  • From: chaoyong wang
• 8.3.10 Changes
  • From: Brad Nicholson
• Entering a character code in a query
  • From: John Gage
• Re: obsessive-compulsive vacuum behavior
  • From: Tom Lane
• PostgreSQL RPM sets for 9.0 Alpha4 released
  • From: Devrim GÜNDÜZ
• Re: Libpq: copy file to bytea column
  • From: seiliki
• Re: Libpq: copy file to bytea column
  • From: seiliki
• Re: XML Index again
  • From: Chris Roffler
• Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
  • From: Michał Pawlikowski
• Re: XML Index again
  • From: Alban Hertroys
• Re: XML Index again
  • From: Chris Roffler
• Re: How to find out if row was modified by EXECUTE UPDATE ...
  • From: Pavel Stehule
• How to find out if row was modified by EXECUTE UPDATE ...
  • From: A B
• Re: XML Index again
  • From: Alban Hertroys
• Re: XML Index again
  • From: Alban Hertroys
• Re: XML Index again
  • From: Chris Roffler
• Re: Failed to run initdb: 128
  • From: Magnus Hagander
• Re: Failed to run initdb: 128
  • From: Richard Huxton
• Fwd: postgresql 8.2 startup script
  • From: Alban Hertroys
• 2 questions when using vs2005 to debug PG
  • From: chaoyong wang
• Re: Foreign key behavior different in a function and outside
  • From: Richard Huxton
• Re: FSM and VM file
  • From: Richard Huxton
• Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table.
  • From: Allan Kamau
• Re: Transaction wraparound problem with database postgres
  • From: Scott Marlowe
• Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
  • From: Albe Laurenz
• Re: Transaction wraparound problem with database postgres
  • From: Markus Wollny
• Re: kernel version impact on PostgreSQL performance
  • From: Albe Laurenz
• Re: Libpq: copy file to bytea column
  • From: Albe Laurenz
• Re: [NOVICE] How to read oracle table's data from postgre
  • From: Scott Marlowe
• Re: obsessive-compulsive vacuum behavior
  • From: Scott Marlowe
• Re: obsessive-compulsive vacuum behavior
  • From: Scott Marlowe
• Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table.
  • From: Scott Marlowe
• obsessive-compulsive vacuum behavior
  • From: Ben Chobot
• Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table.
  • From: Allan Kamau
• Re: [NOVICE] How to read oracle table's data from postgre
  • From: Devrim GÜNDÜZ
• Re: How to read oracle table's data from postgre
  • From: John R Pierce
• How to read oracle table's data from postgre
  • From: venkatrao . b
• Re: psql uses default user from kerberos ticket not the current user
  • From: Tom Lane
• Re: postgresql 8.2 startup script
  • From: Vick Khera
• psql uses default user from kerberos ticket not the current user
  • From: Dmitry Litvintsev
• Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table.
  • From: Scott Marlowe
• Re: Transaction wraparound problem with database postgres
  • From: Scott Marlowe
• Re: Transaction wraparound problem with database postgres
  • From: Markus Wollny
• ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
  • From: Wang, Mary Y
• Re: postgresql 8.2 startup script
  • From: Alban Hertroys
• Evaluation of Postgresql using DBT2
  • From: Megha
• postgresql 8.2 startup script
  • From: Aleksandar Sosic
• Evaluation of Postgresql using DBT2
  • From: Megha
• Re: timestamp literal out of line
  • From: Thomas Kellerer
• Re: should I reindex the table of more than 10 millions rows regularly when more data are inserted?
  • From: Szymon Guz
• should I reindex the table of more than 10 millions rows regularly when more data are inserted?
  • From: zxo102 ouyang
• Re: timestamp literal out of line
  • From: Tom Lane
• Re: accessing the words in a full text index
  • From: Dimitri Fontaine
• timestamp literal out of line
  • From: Martijn van Oosterhout
• Re: XML Index again
  • From: Chris
• accessing the words in a full text index
  • From: Massa, Harald Armin
• Re: XML Index again
  • From: Alban Hertroys
• Re: compare two schemas
  • From: Devrim GÜNDÜZ
• Re: non intuitive behaviour of DROP TABLE IF EXISTS
  • From: Adrian von Bidder
• compare two schemas
  • From: AI Rumman
• XML Index again
  • From: Chris Roffler
• Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table.
  • From: Allan Kamau
• Re: log_statement and syslog severity
  • From: Bruce Momjian
• Re: XML performance tuning
  • From: Bruce Momjian
• Re: non intuitive behaviour of DROP TABLE IF EXISTS
  • From: Bruce Momjian
• Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
  • From: Tom Lane
• Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
  • From: Scott Ribe
• Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
  • From: Tom Lane
• Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
  • From: Dimitri Fontaine
• Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
  • From: Wang, Mary Y
• Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
  • From: Tom Lane
• Re: 9.0 VACUUM FULL vs. ALTER TABLE?
  • From: Tom Lane
• Filesysstems
  • From: Adrian von Bidder
• Libpq: copy file to bytea column
  • From: seiliki
• Re: [NOVICE] How to find details of arguments in all functions in postgre - One solution
  • From: Michael Wood
• How to find details of arguments in all functions in postgre - One solution
  • From: venkatrao . b
• 9.0 VACUUM FULL vs. ALTER TABLE?
  • From: Noah Misch
• Re: Optimizations
  • From: Craig Ringer
• What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?
  • From: Wang, Mary Y
• Re: need some advanced books on Postgres
  • From: Pedro Doria Meunier
• Re: For Loop using row_data to increase performance
  • From: Alban Hertroys
• Re: character confusion
  • From: Tom Lane
• Re: Restore Data Encountered the ERROR: literal carriage return found in data Error
  • From: Wang, Mary Y
• Re: kernel version impact on PostgreSQL performance
  • From: Greg Smith
• Re: Foreign key behavior different in a function and outside
  • From: Mridula Mahadevan
• Re: kernel version impact on PostgreSQL performance
  • From: John R Pierce
• Re: kernel version impact on PostgreSQL performance
  • From: Scott Marlowe
• log_statement and syslog severity
  • From: G Dutton
• kernel version impact on PostgreSQL performance
  • From: Cyril Scetbon
• Re: need some advanced books on Postgres
  • From: Thomas
• Re: For Loop using row_data to increase performance
  • From: John777
• kernel version impact on PostgreSQL performance
  • From: Cyril Scetbon
• For Loop using row_data to increase performance
  • From: John777
• character confusion
  • From: Steve Crawford
• XML performance tuning
  • From: Chris Roffler
• Re: Auto VACUUM
  • From: akp geek
• Re: Auto VACUUM
  • From: Joao Ferreira gmail
• Re: Xpath Index in PostgreSQL
  • From: Chris Roffler
• Re: select issue with order v8.1
  • From: Adrian Klaver
• Re: FSM and VM file
  • From: akp geek
• Re: Auto VACUUM
  • From: akp geek
• Re: Xpath Index in PostgreSQL
  • From: Chris Roffler
• Re: Optimizations
  • From: Ogden
• Re: Restore Data Encountered the ERROR: literal carriage return found in data Error
  • From: Tom Lane
• Re: need some advanced books on Postgres
  • From: Tom Lane
• Re: ERROR: row is too big: size 8176, maximum size 8160
  • From: Tom Lane
• Re: Xpath Index in PostgreSQL
  • From: Tom Lane
• Xpath Index in PostgreSQL
  • From: Chris Roffler
• Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?
  • From: venkatrao . b
• Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?
  • From: Thomas Kellerer
• Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?
  • From: Devrim GÜNDÜZ
• Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?
  • From: Pavel Stehule
• Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?
  • From: venkatrao . b
• Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?
  • From: Vibhor Kumar
• Re: Is there any oracle user_source table equivalent in postgre?
  • From: Thomas Kellerer
• Is there any oracle user_source table equivalent in postgre?
  • From: venkatrao . b
• Re: Foreign key behavior different in a function and outside
  • From: Richard Huxton
• Re: Restore Data Encountered the ERROR: literal carriage return found in data Error
  • From: Richard Huxton
• Re: join from multiple tables
  • From: Grzegorz Jaśkiewicz
• Re: ERROR: row is too big: size 8176, maximum size 8160
  • From: Albe Laurenz
• Re: need some advanced books on Postgres
  • From: Richard Huxton
• Re: Failed to run initdb: 128
  • From: Richard Huxton
• Re: ERROR: row is too big: size 8176, maximum size 8160
  • From: Scott Marlowe
• Re: Optimizations
  • From: Craig Ringer
• Optimizations
  • From: Ogden
• Re: ERROR: row is too big: size 8176, maximum size 8160
  • From: Albe Laurenz
• Re: need some advanced books on Postgres
  • From: Adrian von Bidder
• Re: Foreign key behavior different in a function and outside
  • From: Mridula Mahadevan
• Re: Foreign key behavior different in a function and outside
  • From: Tom Lane
• need some advanced books on Postgres
  • From: Thomas
• Re: Optimal database table optimization method
  • From: John R Pierce
• Foreign key behavior different in a function and outside
  • From: Mridula Mahadevan
• Restore Data Encountered the ERROR: literal carriage return found in data Error
  • From: Wang, Mary Y
• Re: Optimal database table optimization method
  • From: Dann Corbit
• Re: join from multiple tables
  • From: Terry
• Re: select issue with order v8.1
  • From: Terry
• Re: Connection timeouts from pgAdmin
  • From: Lee Hachadoorian
• Re: Connection timeouts from pgAdmin
  • From: John R Pierce
• Connection timeouts from pgAdmin
  • From: Lee Hachadoorian
• Re: Optimal database table optimization method
  • From: Adrian von Bidder
• Re: Failed to run initdb: 128
  • From: Niranjan Maturi (nmaturi)
• Re: Optimal database table optimization method
  • From: John R Pierce
• Re: Can you set the date output format (to_char style) per session?
  • From: Joshua Johnston
• Re: Can you set the date output format (to_char style) per session?
  • From: Pavel Stehule
• Can you set the date output format (to_char style) per session?
  • From: Joshua Johnston
• Re: join from multiple tables
  • From: Terry
• Optimal database table optimization method
  • From: Roger Tannous
• Re: The REAL cost of joins
  • From: Simon Riggs
• Re: join from multiple tables
  • From: Terry
• Re: join from multiple tables
  • From: Thom Brown
• join from multiple tables
  • From: Terry
• Re: ERROR: row is too big: size 8176, maximum size 8160
  • From: Andreas Kretschmer
• ERROR: row is too big: size 8176, maximum size 8160
  • From: DimitryASuplatov
• Re: Scratching my head why results are different between machines.
  • From: Scott Marlowe
• non intuitive behaviour of DROP TABLE IF EXISTS
  • From: Manlio Perillo
• Re: Auto VACUUM
  • From: Joshua D. Drake
• Re: Scratching my head why results are different between machines.
  • From: Justin Graf
• Re: Auto VACUUM
  • From: akp geek