Postgresql General Discussion

• Thread Index

• Getting listed on "Community Guide to PostgreSQL GUI Tools"
  • From: Thomas Kellerer
• Re: "Could not open relation XXX: No such file or directory"
  • From: Alan Millington
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Craig Ringer
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Jorge Daine Quiambao
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Jorge Daine Quiambao
• Re: Improving Full text performance
  • From: Oleg Bartunov
• Re: bytea corruption?
  • From: Nathan Jahnke
• Re: Improving Full text performance
  • From: Ries van Twisk
• Improving Full text performance
  • From: xaviergxf
• Re: "Could not open relation XXX: No such file or directory"
  • From: Craig Ringer
• Re: bytea corruption?
  • From: Tim Landscheidt
• Re: Problem with bacula and 8.3/8.4
  • From: Arturo Pérez
• Re: Comparing arrays of composite types
  • From: Alban Hertroys
• bytea corruption?
  • From: Nathan Jahnke
• Re: Comparing arrays of composite types
  • From: Tom Lane
• Re: Schema diff tool?
  • From: David Kerr
• Re: export a schema / import as new schema
  • From: David Kerr
• Re: Schema diff tool?
  • From: Miroslav S(ulc
• Re: Schema diff tool?
  • From: Joshua Tolley
• Re: export a schema / import as new schema
  • From: Boyd, Craig
• Re: Schema diff tool?
  • From: David Kerr
• Re: Comparing arrays of composite types
  • From: Merlin Moncure
• Re: join from array or cursor
  • From: Sam Mason
• Re: export a schema / import as new schema
  • From: David Kerr
• Re: Questions about encoding between two databases
  • From: Archibald Zimonyi
• Comparing arrays of composite types
  • From: Alban Hertroys
• Re: "Number of columns exceed limit" on a hierarchy of views
  • From: Alvaro Herrera
• Re: Schema diff tool?
  • From: Boyd, Craig
• Re: export a schema / import as new schema
  • From: Joshua D. Drake
• export a schema / import as new schema
  • From: David Kerr
• Re: Questions about encoding between two databases
  • From: Alvaro Herrera
• Re: Schema diff tool?
  • From: Boyd, Craig
• Re: Schema diff tool?
  • From: David Kerr
• Re: Questions about encoding between two databases
  • From: Archibald Zimonyi
• Schema diff tool?
  • From: David Kerr
• Postgres bug #4907 : stored procedures and changed tables
  • From: Chris Barnes
• Re: "Number of columns exceed limit" on a hierarchy of views
  • From: Eric Schwarzenbach
• Re: join from array or cursor
  • From: Merlin Moncure
• Re: join from array or cursor
  • From: Sam Mason
• Re: New database or New Schema?
  • From: David Fetter
• Re: Out of memory on pg_dump
  • From: Martin Gainty
• Re: Questions about encoding between two databases
  • From: Tom Lane
• Re: Error inserting data to bytea column in 8.4
  • From: Sam Mason
• Re: Error inserting data to bytea column in 8.4
  • From: Greg Stark
• Re: Questions about encoding between two databases
  • From: Archibald Zimonyi
• New database or New Schema?
  • From: Eric Comeau
• Re: pl/pgsql loop thru columns names
  • From: Scott Bailey
• Re: Out of memory on pg_dump
  • From: Tom Lane
• Re: join from array or cursor
  • From: Tom Lane
• Error inserting data to bytea column in 8.4
  • From: Andrus Moor
• Re: Out of memory on pg_dump
  • From: Chris Hopkins
• Re: join from array or cursor
  • From: Sam Mason
• "Number of columns exceed limit" on a hierarchy of views
  • From: David Waller
• Re: Out of memory on pg_dump
  • From: Tom Lane
• Re: DB Design Advice
  • From: Merlin Moncure
• Re: join from array or cursor
  • From: Merlin Moncure
• Re: Questions about encoding between two databases
  • From: Archibald Zimonyi
• Re: join from array or cursor
  • From: Sam Mason
• Re: join from array or cursor
  • From: Merlin Moncure
• Re: "ownership" of sequences, pseudo random unique id
  • From: Tom Lane
• Re: Questions about encoding between two databases
  • From: Adrian Klaver
• Re: "Number of columns exceed limit" on a hierarchy of views
  • From: Tom Lane
• Re: join from array or cursor
  • From: Greg Stark
• Re: join from array or cursor
  • From: Greg Stark
• Re: Temp table or normal table for performance?
  • From: Grzegorz Jaśkiewicz
• Re: Temp table or normal table for performance?
  • From: Ivan Sergio Borgonovo
• "Number of columns exceed limit" on a hierarchy of views
  • From: David Waller
• Re: join from array or cursor
  • From: John DeSoi
• Re: Generating random unique alphanumeric IDs
  • From: Daniel Verite
• Re: join from array or cursor
  • From: Sam Mason
• Re: DB Design Advice
  • From: Bill Moran
• Re: Wich the best way to control the logic of a web application?
  • From: Jasen Betts
• Re: question about /etc/init.d/postgresql in PGDG
  • From: Devrim GÜNDÜZ
• Questions about encoding between two databases
  • From: Archibald Zimonyi
• Re: "ownership" of sequences, pseudo random unique id
  • From: Ivan Sergio Borgonovo
• bayesian classification over tsvector
  • From: Ivan Sergio Borgonovo
• Re: DB Design Advice
  • From: stoneg64@xxxxxxxxxx
• Re: "Could not open relation XXX: No such file or directory"
  • From: Yaroslav Tykhiy
• Re: DB Design Advice
  • From: John R Pierce
• DB Design Advice
  • From: stoneg64@xxxxxxxxxx
• Re: join from array or cursor
  • From: Scott Bailey
• Re: "Could not open relation XXX: No such file or directory"
  • From: Seth Gordon
• Re: question about /etc/init.d/postgresql in PGDG
  • From: Tom Lane
• Re: Postgre RAISE NOTICE and PHP
  • From: Clemens Schwaighofer
• join from array or cursor
  • From: John DeSoi
• Re: R: Field's position in Table
  • From: Scott Marlowe
• Re: R: Field's position in Table
  • From: Yaroslav Tykhiy
• Re: "Could not open relation XXX: No such file or directory"
  • From: Yaroslav Tykhiy
• Enc: Res: Function for replace
  • From: paulo matadr
• Re: Regarding installing & starting Postgres on Windows
  • From: John R Pierce
• Re: Function for replace
  • From: Sam Mason
• Function for replace
  • From: paulo matadr
• Regarding installing & starting Postgres on Windows
  • From: Vikram Patil
• locking/waiting queries
  • From: Kevin Kempter
• Out of memory on pg_dump
  • From: Chris Hopkins
• Re: "ownership" of sequences, pseudo random unique id
  • From: Alvaro Herrera
• Re: unique index for periods
  • From: Jeff Davis
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Craig Ringer
• German ispell dictionary: error parsing affix file
  • From: Christof König
• Re: unique index for periods
  • From: Tom Lane
• Re: Temp table or normal table for performance?
  • From: Martijn van Oosterhout
• Re: Generating random unique alphanumeric IDs
  • From: Ivan Sergio Borgonovo
• Re: unique index for periods
  • From: Greg Stark
• Connection name on ECPGdeallocate ?
  • From: leif
• Re: Monitoring the sequence cycles
  • From: Greg Sabino Mullane
• Re: Clustering with enough work_mem: copy heap in mem?
  • From: Scara Maccai
• Re: Clustering with enough work_mem: copy heap in mem?
  • From: Alvaro Herrera
• Re: Clustering with enough work_mem: copy heap in mem?
  • From: Scara Maccai
• Re: Clustering with enough work_mem: copy heap in mem?
  • From: Scott Marlowe
• Clustering with enough work_mem: copy heap in mem?
  • From: Scara Maccai
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Tom Lane
• Re: unique index for periods
  • From: Tom Lane
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Scott Marlowe
• Re: Temp table or normal table for performance?
  • From: Jasen Betts
• Re: PL/PGSQL: why IF test the whole condition before failing or not?
  • From: Jasen Betts
• Re: Postgre RAISE NOTICE and PHP
  • From: Sam Mason
• Re: Postgre RAISE NOTICE and PHP
  • From: Jasen Betts
• Re: Best database model for canvassing (and analysing) opinion
  • From: Sebastian Tennant
• Re: Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Karsten Hilbert
• Re: Postgre RAISE NOTICE and PHP
  • From: Jasen Betts
• Re: multiple paramters in aggregate function
  • From: Karsten Hilbert
• Re: Generating random unique alphanumeric IDs
  • From: Thom Brown
• Re: multiple paramters in aggregate function
  • From: Sim Zacks
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Karsten Hilbert
• Re: multiple paramters in aggregate function
  • From: Karsten Hilbert
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Jasen Betts
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Jorge Daine Quiambao
• Re: ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Scott Marlowe
• "ownership" of sequences, pseudo random unique id
  • From: Ivan Sergio Borgonovo
• Re: unique index for periods
  • From: Harald Fuchs
• Re: R: Field's position in Table
  • From: Sam Mason
• Re: Generating random unique alphanumeric IDs
  • From: Ivan Sergio Borgonovo
• Re: Temp table or normal table for performance?
  • From: Sam Mason
• Generate LaTeX doc from PostgreSQL (autodoc)?
  • From: Wolfgang Keller
• Re: R: Field's position in Table
  • From: vinny
• R: Field's position in Table
  • From: Scara Maccai
• Re: Field's position in Table
  • From: John R Pierce
• ERROR: could not access file "$libdir/xxid": No such file or directory
  • From: Jorge Daine Quiambao
• Field's position in Table
  • From: Kalai R
• Re: multiple paramters in aggregate function
  • From: Sim Zacks
• Re: multiple paramters in aggregate function
  • From: Sim Zacks
• unique index for periods
  • From: Gerhard Heift
• Re: Problem with bacula and 8.3/8.4
  • From: Craig Ringer
• Re: Postgre RAISE NOTICE and PHP
  • From: Clemens Schwaighofer
• Re: Postgre RAISE NOTICE and PHP
  • From: Randal L. Schwartz
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Greg Smith
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Greg Smith
• Re: Temp table or normal table for performance?
  • From: Stephen Cook
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Greg Smith
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Alvaro Herrera
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Sanjay Arora
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Tom Lane
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Sanjay Arora
• Re: Postgre RAISE NOTICE and PHP
  • From: David Fetter
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Tom Lane
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Sanjay Arora
• Re: Help interpreting pg_stat_bgwriter output
  • From: Jaime Casanova
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Sanjay Arora
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Adrian Klaver
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Merlin Moncure
• Re: Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Greg Stark
• Stock Market Price Data & postgreSQL? HELLPPP Please
  • From: Sanjay Arora
• Re: Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Alvaro Herrera
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Greg Stark
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Alvaro Herrera
• Re: Changing owner of pg_toast tables
  • From: Tom Lane
• Re: Changing owner of pg_toast tables
  • From: Glen Jarvis
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Alban Hertroys
• Re: pg_restore returns always error if backup is greater than 2 GB
  • From: Tom Lane
• Re: Postgre RAISE NOTICE and PHP
  • From: Scott Marlowe
• Re: Requesting help on PostgreSQL Replication
  • From: Greg Sabino Mullane
• Re: Monitoring the sequence cycles
  • From: Marc Mamin
• Re: Wich the best way to control the logic of a web application?
  • From: Christophe Pettus
• Re: index "pg_authid_rolname_index" is not a btree
  • From: Tom Lane
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Karsten Hilbert
• Re: Wich the best way to control the logic of a web application?
  • From: Sam Mason
• Re: question about /etc/init.d/postgresql in PGDG
  • From: Greg Smith
• Re: index "pg_authid_rolname_index" is not a btree
  • From: Andrus Moor
• Re: Postgre RAISE NOTICE and PHP
  • From: Clemens Schwaighofer
• Problem with bacula and 8.3/8.4
  • From: Arturo Pérez
• Wich the best way to control the logic of a web application?
  • From: Andre Lopes
• Re: question about /etc/init.d/postgresql in PGDG
  • From: Scott Marlowe
• Re: Monitoring the sequence cycles
  • From: Sam Mason
• Re: "Could not open relation XXX: No such file or directory"
  • From: Scott Marlowe
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Alban Hertroys
• Re: text type has no default operator class for GIN?
  • From: Tom Lane
• Re: index "pg_authid_rolname_index" is not a btree
  • From: Tom Lane
• Re: text type has no default operator class for GIN?
  • From: Bob Gobeille
• Re: text type has no default operator class for GIN?
  • From: Sam Mason
• Re: Postgre RAISE NOTICE and PHP
  • From: Randal L. Schwartz
• Re: Function Logging
  • From: Adrian Klaver
• Re: Postgre RAISE NOTICE and PHP
  • From: Michael Glaesemann
• Monitoring the sequence cycles
  • From: Marc Mamin
• Re: index "pg_authid_rolname_index" is not a btree
  • From: Andrus Moor
• Re: "Could not open relation XXX: No such file or directory"
  • From: Craig Ringer
• Re: A history procedure that prevents duplicate entries
  • From: Alban Hertroys
• "Could not open relation XXX: No such file or directory"
  • From: Alan Millington
• SPI_ERROR_CONNECT within pl/pgsql PG 8.4
  • From: Omar Bettin
• pg_restore returns always error if backup is greater than 2 GB
  • From: Andrus Moor
• Re: PQgetlength vs. octet_length()
  • From: Albe Laurenz
• Re: Idle processes chewing up CPU?
  • From: Craig Ringer
• Re: question about /etc/init.d/postgresql in PGDG
  • From: Devrim GÜNDÜZ
• Re: pl/pgsql loop thru columns names
  • From: Pavel Stehule
• Temp table or normal table for performance?
  • From: Stephen Cook
• pl/pgsql loop thru columns names
  • From: Dilyan Berkovski
• question about /etc/init.d/postgresql in PGDG
  • From: Scott Marlowe
• Re: Idle processes chewing up CPU?
  • From: Brendan Hill
• Re: Idle processes chewing up CPU?
  • From: Craig Ringer
• Re: Idle processes chewing up CPU?
  • From: Brendan Hill
• Re: 2 versions of Postgres on the same machine
  • From: Sachin Srivastava
• Re: Function Logging
  • From: Craig Ringer
• Re: text type has no default operator class for GIN?
  • From: Tom Lane
• Re: text type has no default operator class for GIN?
  • From: Sam Mason
• Re: Postgre RAISE NOTICE and PHP
  • From: Adam Rich
• Re: text type has no default operator class for GIN?
  • From: Bob Gobeille
• text type has no default operator class for GIN?
  • From: Bob Gobeille
• Re: Access Control System - Design
  • From: John R Pierce
• Re: index "pg_authid_rolname_index" is not a btree
  • From: Alvaro Herrera
• Re: Any justification for sequence table vs. native sequences?
  • From: Tom Lane
• Re: PL/PGSQL: why IF test the whole condition before failing or not?
  • From: Tom Lane
• PL/PGSQL: why IF test the whole condition before failing or not?
  • From: Suporte PK
• Access Control System - Design
  • From: Andre Lopes
• Re: Postgre RAISE NOTICE and PHP
  • From: Scott Marlowe
• Re: Any justification for sequence table vs. native sequences?
  • From: Bill Moran
• Re: Any justification for sequence table vs. native sequences?
  • From: Stuart McGraw
• Fwd: PQgetlength vs. octet_length()
  • From: Michael Clark
• Any justification for sequence table vs. native sequences?
  • From: Doug Gorley
• Re: Unit conversion database (was: multiple paramters in aggregate function)
  • From: Alban Hertroys
• Re: PQgetlength vs. octet_length()
  • From: Greg Stark
• PQgetlength vs. octet_length()
  • From: Michael Clark
• Re: Postgre RAISE NOTICE and PHP
  • From: Randal L. Schwartz
• Re: 2 versions of Postgres on the same machine
  • From: Devrim GÜNDÜZ
• Postgre RAISE NOTICE and PHP
  • From: Andre Lopes
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• Re: Configuration Question
  • From: Tom Lane
• Re: Configuration Question
  • From: Terry Lee Tucker
• Re: Configuration Question
  • From: Martin Gainty
• Re: Function Logging
  • From: Adrian Klaver
• Re: design, plpgsql and sql injection in dynamically generated sql
  • From: Pavel Stehule
• Re: Best database model for canvassing (and analysing) opinion
  • From: Sam Mason
• Re: There are procedures in Postgres 8.3?
  • From: Pavel Stehule
• Re: There are procedures in Postgres 8.3?
  • From: Sam Mason
• index "pg_authid_rolname_index" is not a btree
  • From: Andrus Moor
• Re: Best database model for canvassing (and analysing) opinion
  • From: John R Pierce
• There are procedures in Postgres 8.3?
  • From: Andre Lopes
• Re: multiple paramters in aggregate function
  • From: Alban Hertroys
• Re: Best database model for canvassing (and analysing) opinion
  • From: Sam Mason
• Re: design, plpgsql and sql injection in dynamically generated sql
  • From: Ivan Sergio Borgonovo
• Re: 2 versions of Postgres on the same machine
  • From: Sam Mason
• Re: comparing NEW and OLD (any good this way?)
  • From: Sam Mason
• Re: design, plpgsql and sql injection in dynamically generated sql
  • From: Pavel Stehule
• Configuration Question
  • From: Terry Lee Tucker
• Re: design, plpgsql and sql injection in dynamically generated sql
  • From: Ivan Sergio Borgonovo
• Re: psql command line editor
  • From: Jasen Betts
• Re: 2 versions of Postgres on the same machine
  • From: John R Pierce
• 2 versions of Postgres on the same machine
  • From: wstrzalka
• Best database model for canvassing (and analysing) opinion
  • From: Sebastian Tennant
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• Re: multiple paramters in aggregate function
  • From: Sim Zacks
• Re: Function Logging
  • From: Andrew Bartley
• Re: Get most recent message between users?
  • From: nick
• Re: Get most recent message between users?
  • From: Steve Crawford
• Re: Failover, Wal Logging, and Multiple Spares
  • From: Greg Stark
• Re: Get most recent message between users?
  • From: Sam Mason
• Get most recent message between users?
  • From: Nick
• Re: Failover, Wal Logging, and Multiple Spares
  • From: Yaroslav Tykhiy
• Re: Failover, Wal Logging, and Multiple Spares
  • From: Bryan Murphy
• Re: Rapid Seek Devices (feature request)
  • From: Greg Stark
• Re: Function Logging
  • From: Andrew Bartley
• Re: Rapid Seek Devices (feature request)
  • From: NTPT
• Re: ERROR: attempted to delete invisible tuple
  • From: Bryan Murphy
• Re: ERROR: attempted to delete invisible tuple
  • From: Greg Stark
• Re: binary timestamp conversion
  • From: Sam Mason
• SQL and pl/pgsql parser in Haskell
  • From: Jake Wheat
• Re: psql command line editor
  • From: Bob Gobeille
• Re: psql command line editor
  • From: Bob Gobeille
• Re: psql command line editor
  • From: kbarnard@xxxxxxxxxxxxxxxx
• Re: psql command line editor
  • From: Steve Atkins
• Re: psql command line editor
  • From: Bob Gobeille
• Re: psql command line editor
  • From: Alvaro Herrera
• Re: psql command line editor
  • From: Bob Gobeille
• Re: Rapid Seek Devices (feature request)
  • From: Jeremy Harris
• Re: ERROR: attempted to delete invisible tuple
  • From: Tom Lane
• Re: plpython return setof and yield
  • From: Nuno Mota
• Re: plpython return setof and yield
  • From: Nuno Mota
• Re: psql command line editor
  • From: Alvaro Herrera
• Re: Pgbench tool download
  • From: Josh Kupershmidt
• Re: ERROR: attempted to delete invisible tuple
  • From: Bryan Murphy
• Re: plpython return setof and yield
  • From: Adrian Klaver
• Re: ERROR: attempted to delete invisible tuple
  • From: Greg Stark
• Re: ERROR: attempted to delete invisible tuple
  • From: Greg Stark
• Re: psql command line editor
  • From: Bob Gobeille
• Re: pg_autovacuum exceptions question
  • From: Tom Lane
• Re: plpython return setof and yield
  • From: Nuno Mota
• Re: ERROR: attempted to delete invisible tuple
  • From: Tom Lane
• psql command line editor
  • From: Bob Gobeille
• Re: pg_autovacuum exceptions question
  • From: Chris Bowlby
• Re: ERROR: attempted to delete invisible tuple
  • From: Bryan Murphy
• Re: ERROR: attempted to delete invisible tuple
  • From: Tom Lane
• Re: pg_autovacuum exceptions question
  • From: Alvaro Herrera
• Re: ERROR: attempted to delete invisible tuple
  • From: Bryan Murphy
• pg_autovacuum exceptions question
  • From: Chris Bowlby
• Re: ERROR: attempted to delete invisible tuple
  • From: Bryan Murphy
• Re: ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC
  • From: Alvaro Herrera
• Re: binary timestamp conversion
  • From: Alvaro Herrera
• Re: ERROR: attempted to delete invisible tuple
  • From: Greg Stark
• Re: Function Logging
  • From: Alvaro Herrera
• Pgbench tool download
  • From: Chris Barnes
• Re: design, plpgsql and sql injection in dynamically generated sql
  • From: Sam Mason
• ERROR: attempted to delete invisible tuple
  • From: Bryan Murphy
• Re: Generating random unique alphanumeric IDs
  • From: Sam Mason
• Re: comparing NEW and OLD (any good this way?)
  • From: Sam Mason
• Re: plpython return setof and yield
  • From: Adrian Klaver
• Re: Generating random unique alphanumeric IDs
  • From: Harald Fuchs
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• Re: Generating random unique alphanumeric IDs
  • From: Sam Mason
• Re: ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC
  • From: utsav.turray
• Re: Generating random unique alphanumeric IDs
  • From: Jasen Betts
• Re: design, plpgsql and sql injection in dynamically generated sql
  • From: Pavel Stehule
• design, plpgsql and sql injection in dynamically generated sql
  • From: Ivan Sergio Borgonovo
• Re: Generating random unique alphanumeric IDs
  • From: Daniel Verite
• binary timestamp conversion
  • From: David De Maeyer
• Re: Requesting help on PostgreSQL Replication
  • From: Jorge Daine Quiambao
• synchronize two pg databases
  • From: leopay
• Re: Requesting help on PostgreSQL Replication
  • From: Scott Marlowe
• Re: plpgsql function to validate e-mail
  • From: Pavel Stehule
• Requesting help on PostgreSQL Replication
  • From: Jorge Daine Quiambao
• I: Re: totally different plan when using partitions
  • From: Scara Maccai
• Re: Database Security
  • From: Albe Laurenz
• Re: plpgsql function to validate e-mail
  • From: Peter Eisentraut
• Re: plpgsql function to validate e-mail
  • From: David Fetter
• Database Security
  • From: Kalai R
• Re: plpgsql function to validate e-mail
  • From: Pavel Stehule
• Re: plpgsql function to validate e-mail
  • From: David Fetter
• Re: Generating random unique alphanumeric IDs
  • From: Scott Marlowe
• Re: Function Logging
  • From: Andrew Bartley
• Re: Function Logging
  • From: Craig Ringer
• Re: plpgsql function to validate e-mail
  • From: Pavel Stehule
• Function Logging
  • From: Andrew Bartley
• Re: plpgsql function to validate e-mail
  • From: Lew
• Re: Rapid Seek Devices (feature request)
  • From: Craig Ringer
• Function Logging
  • From: Andrew Bartley
• Failover, Wal Logging, and Multiple Spares
  • From: Bryan Murphy
• Database Security
  • From: Kalai R
• Re: Generating random unique alphanumeric IDs
  • From: Sam Mason
• Re: plpgsql function to validate e-mail
  • From: Tom Lane
• plpython return setof and yield
  • From: Nuno Mota
• Re: Generating random unique alphanumeric IDs
  • From: Alvaro Herrera
• Re: 8.4 rpm packaging problem?
  • From: Alvaro Herrera
• Re: Generating random unique alphanumeric IDs
  • From: Bob Gobeille
• Re: 8.4 rpm packaging problem?
  • From: Devrim GÜNDÜZ
• Re: 8.4 rpm packaging problem?
  • From: Alvaro Herrera
• Re: 8.4 rpm packaging problem?
  • From: Devrim GÜNDÜZ
• 8.4 rpm packaging problem?
  • From: Stuart McGraw
• Re: plpgsql function to validate e-mail
  • From: Raymond O'Donnell
• plpgsql function to validate e-mail
  • From: Andre Lopes
• Re: bigint to ip
  • From: Dimitri Fontaine
• Re: Generating random unique alphanumeric IDs
  • From: Scott Ribe
• Re: Generating random unique alphanumeric IDs
  • From: Lew
• Re: A history procedure that prevents duplicate entries
  • From: Madison Kelly
• Rapid Seek Devices (feature request)
  • From: NTPT
• Re: Generating random unique alphanumeric IDs
  • From: Sam Mason
• Re: Generating random unique alphanumeric IDs
  • From: Ivan Sergio Borgonovo
• Re: A history procedure that prevents duplicate entries
  • From: Bastiaan Wakkie
• Re: Generating random unique alphanumeric IDs
  • From: Thom Brown
• Re: Generating random unique alphanumeric IDs
  • From: Sam Mason
• Re: A history procedure that prevents duplicate entries
  • From: Alban Hertroys
• Generating random unique alphanumeric IDs
  • From: Thom Brown
• Re: [Q] parsing out String array
  • From: Sam Mason
• Re: [Q] parsing out String array
  • From: toreason
• A history procedure that prevents duplicate entries
  • From: Madison Kelly
• Re: [Q] parsing out String array
  • From: Sam Mason
• Re: [Q] parsing out String array
  • From: V S P
• Re: licensing/distribution of DLL's question
  • From: Alvaro Herrera
• licensing/distribution of DLL's question
  • From: Jim Michaels
• Re: Proxy for postgres
  • From: Martin Spinassi
• Re: pgstatindex
  • From: Sam Mason
• Re: Proxy for postgres
  • From: John R Pierce
• Re: [HACKERS] \copy: unexpected response (4)
  • From: Neil Best
• Re: Proxy for postgres
  • From: Martin Spinassi
• Re: [HACKERS] \copy: unexpected response (4)
  • From: Tom Lane
• Re: Proxy for postgres
  • From: John R Pierce
• Re: Proxy for postgres
  • From: Martin Spinassi
• Re: Function doesn't work properly
  • From: Alban Hertroys
• Re: Proxy for postgres
  • From: John R Pierce
• Re: Proxy for postgres
  • From: Said Ramirez
• Re: Proxy for postgres
  • From: Emanuel Calvo Franco
• Proxy for postgres
  • From: Martin Spinassi
• Function doesn't work properly
  • From: Ing. Eris J. Gómez
• Re: Getting database data from the PostgreSQL file system
  • From: Greg Stark
• Re: Getting database data from the PostgreSQL file system
  • From: Serge Fonville
• Re: [HACKERS] \copy: unexpected response (4)
  • From: Neil Best
• Re: [HACKERS] \copy: unexpected response (4)
  • From: Neil Best
• Getting database data from the PostgreSQL file system
  • From: Ewgenij Sokolovski
• Re: mail alert
  • From: Sam Mason
• Re: FILLFACTOR for GIN indexes in 8.3.7
  • From: Teodor Sigaev
• Re: pgstatindex
  • From: Tom Lane
• Re: adding a nullable col could rewrite the whole table?
  • From: Scara Maccai
• Re: Index utilization
  • From: Emanuel Calvo Franco
• Re: adding a nullable col could rewrite the whole table?
  • From: Sam Mason
• pgstatindex
  • From: paulo matadr
• Re: Table as parameter
  • From: Grzegorz Jaśkiewicz
• R: Table as parameter
  • From: Scara Maccai
• adding a nullable col could rewrite the whole table?
  • From: Scara Maccai
• Table as parameter
  • From: Alex Paulo
• Re: PQoidValue - isn't it for...?
  • From: Jasen Betts
• Re: Does derby have an embedded Mode like Derby ?
  • From: Jasen Betts
• Re: Does derby have an embedded Mode like Derby ?
  • From: Jasen Betts
• FILLFACTOR for GIN indexes in 8.3.7
  • From: Marc Mamin
• Re: bigint to ip
  • From: Jasen Betts
• Re: 8.4.0 bug - failure to enforce a foreign key constraint
  • From: Radoslaw Zielinski *EXTERN*
• Re: drop key translation
  • From: A. Kretschmer
• Re: totally different plan when using partitions
  • From: Scara Maccai
• Re: drop key translation
  • From: Chris
• Re: totally different plan when using partitions
  • From: Richard Huxton
• drop key translation
  • From: Skylar Saveland
• Re: totally different plan when using partitions
  • From: Scara Maccai
• Re: 8.4.0 bug - failure to enforce a foreign key constraint
  • From: Albe Laurenz
• Video from the August 11, 2009 SFPUG meeting available
  • From: Christophe Pettus
• Re: mail alert
  • From: Ow Mun Heng
• Re: max_allowed_packet equivalent in Postgres?
  • From: Greg Stark
• Re: comparing NEW and OLD (any good this way?)
  • From: Sam Mason
• Re: max_allowed_packet equivalent in Postgres?
  • From: Sam Mason
• Re: max_allowed_packet equivalent in Postgres?
  • From: Greg Stark
• Re: plperl function
  • From: Emanuel Calvo Franco
• Re: comparing NEW and OLD (any good this way?)
  • From: Greg Stark
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• plperl function
  • From: Janet Jacobsen
• Re: max_allowed_packet equivalent in Postgres?
  • From: Sam Mason
• Re: max_allowed_packet equivalent in Postgres?
  • From: Greg Smith
• Re: max_allowed_packet equivalent in Postgres?
  • From: Bruce Momjian
• max_allowed_packet equivalent in Postgres?
  • From: Alan McKay
• Re: PostgreSQL for Firefox Bookmarks?
  • From: Shane Ambler
• Re: Simulate count result are distinct between 8.3 and 8.4
  • From: Emanuel Calvo Franco
• Re: Selecting rows by content of array type field
  • From: Sam Mason
• Re: Encoding question when dumping/restoring databases for upgrade
  • From: Tom Lane
• Encoding question when dumping/restoring databases for upgrade
  • From: arsi
• Selecting rows by content of array type field
  • From: mito
• Re: 8.4.0 bug - failure to enforce a foreign key constraint
  • From: Radoslaw Zielinski
• Index utilization
  • From: kbarnard
• Re: Can I get Field informations from system tables?
  • From: Sam Mason
• Re: PostgreSQL for Firefox Bookmarks?
  • From: Greg Smith
• Re: PostgreSQL for Firefox Bookmarks?
  • From: Joshua D. Drake
• Re: array syntax and geometric type syntax
  • From: Sam Mason
• Re: totally different plan when using partitions
  • From: Tom Lane
• Re: PostgreSQL for Firefox Bookmarks?
  • From: Philip Rhoades
• Re: array syntax and geometric type syntax
  • From: Dan Halbert
• Re: comparing NEW and OLD (any good this way?)
  • From: Pavel Stehule
• Re: totally different plan when using partitions
  • From: Richard Huxton
• Re: Looping through string constants
  • From: Sam Mason
• Re: array syntax and geometric type syntax
  • From: Sam Mason
• Re: array syntax and geometric type syntax
  • From: Scott Bailey
• Re: Looping through string constants
  • From: Scott Bailey
• Re: totally different plan when using partitions
  • From: Scara Maccai
• Re: comparing NEW and OLD (any good this way?)
  • From: Sam Mason
• Can I get Field informations from system tables?
  • From: Durumdara
• array syntax and geometric type syntax
  • From: Dan Halbert
• Re: totally different plan when using partitions
  • From: Alvaro Herrera
• Re: PostgreSQL for Firefox Bookmarks?
  • From: Devrim GÜNDÜZ
• Re: PostgreSQL for Firefox Bookmarks?
  • From: Roderick A. Anderson
• Re: totally different plan when using partitions + request
  • From: Scara Maccai
• Re: totally different plan when using partitions + request
  • From: Richard Huxton
• PostgreSQL for Firefox Bookmarks?
  • From: Philip Rhoades
• Re: totally different plan when using partitions
  • From: Scara Maccai
• Re: multiple paramters in aggregate function
  • From: Alvaro Herrera
• Re: totally different plan when using partitions
  • From: Alvaro Herrera
• Re: multiple paramters in aggregate function
  • From: Scara Maccai
• Re: multiple paramters in aggregate function
  • From: Sim Zacks
• Re: 8.4.0 bug - failure to enforce a foreign key constraint
  • From: Grzegorz Jaśkiewicz
• Re: difficulty running pg on XP as appl.
  • From: Magnus Hagander
• Re: multiple paramters in aggregate function
  • From: Alban Hertroys
• Re: difficulty running pg on XP as appl.
  • From: Garry Saddington
• 8.4.0 bug - failure to enforce a foreign key constraint
  • From: Radoslaw Zielinski
• difficulty running pg on XP as appl.
  • From: PG Subscriber
• R: multiple paramters in aggregate function
  • From: Scara Maccai
• Re: totally different plan when using partitions + request
  • From: Scara Maccai
• multiple paramters in aggregate function
  • From: Sim Zacks
• Re: Looping through string constants
  • From: Sam Mason
• Re: totally different plan when using partitions
  • From: Richard Huxton
• Re: totally different plan when using partitions
  • From: Scara Maccai
• Re: Help interpreting pg_stat_bgwriter output
  • From: Greg Smith
• Re: totally different plan when using partitions
  • From: Richard Huxton
• R: totally different plan when using partitions
  • From: Scara Maccai
• Re: [Q] parsing out String array
  • From: Scott Bailey
• Re: Looping through string constants
  • From: Scott Bailey
• [Q] parsing out String array
  • From: V S P
• Re: trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport
  • From: Alvaro Herrera
• Re: Simulate count result are distinct between 8.3 and 8.4
  • From: Shoaib Mir
• Re: Looping through string constants
  • From: David Kerr
• Re: trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport
  • From: Aleksey Tsalolikhin
• Re: Simulate count result are distinct between 8.3 and 8.4
  • From: Chris
• Re: Looping through string constants
  • From: Tim Landscheidt
• Re: trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport
  • From: Tom Lane
• Re: Looping through string constants
  • From: Tom Lane
• trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport
  • From: Aleksey Tsalolikhin
• Looping through string constants
  • From: David Kerr
• Simulate count result are distinct between 8.3 and 8.4
  • From: Emanuel Calvo Franco
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• Re: synchronous_commit and mvcc
  • From: Andy Colson
• Re: synchronous_commit and mvcc
  • From: Greg Stark
• synchronous_commit and mvcc
  • From: Kelly Burkhart
• Re: comparing NEW and OLD (any good this way?)
  • From: Sam Mason
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• Re: comparing NEW and OLD (any good this way?)
  • From: Sam Mason
• Re: comparing NEW and OLD (any good this way?)
  • From: Merlin Moncure
• Re: comparing NEW and OLD (any good this way?)
  • From: Daniel Verite
• Re: Best way to "mask" password in DBLINK
  • From: Tom Lane
• Re: Adding ACL notion to existing tables
  • From: Bruno Baguette
• Re: comparing NEW and OLD (any good this way?)
  • From: Sam Mason
• totally different plan when using partitions
  • From: Scara Maccai
• plpython.dll dependencies
  • From: Alan Millington
• Re: comparing NEW and OLD (any good this way?)
  • From: Willy-Bas Loos
• Re: ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC
  • From: Richard Huxton
• Re: PQoidValue - isn't it for...?
  • From: Magnus Hagander
• Re: Best way to "mask" password in DBLINK
  • From: Tommy Gildseth
• Re: Best way to "mask" password in DBLINK
  • From: Ow Mun Heng
• PQoidValue - isn't it for...?
  • From: Jim Michaels
• Re: Best way to "mask" password in DBLINK
  • From: Magnus Hagander
• Re: Best way to "mask" password in DBLINK
  • From: Ow Mun Heng
• Re: NOTICE: there is no transaction in progress
  • From: Richard Huxton
• Re: Best way to "mask" password in DBLINK
  • From: Magnus Hagander
• Re: Best way to "mask" password in DBLINK
  • From: Tommy Gildseth
• Re: Best way to "mask" password in DBLINK
  • From: Ow Mun Heng
• Re: Best way to "mask" password in DBLINK
  • From: Tommy Gildseth
• Best way to "mask" password in DBLINK
  • From: Ow Mun Heng
• Windows 7 and SSPI
  • From: Adam Ruth
• Help interpreting pg_stat_bgwriter output
  • From: sam mulube
• Re: Race hazard deleting using CTID?
  • From: Peter Headland
• Re: Does PERFORM hold a lock?
  • From: Alvaro Herrera
• Re: Race hazard deleting using CTID?
  • From: Tom Lane
• Race hazard deleting using CTID?
  • From: Peter Headland
• Does PERFORM hold a lock?
  • From: Peter Headland
• Re: mail alert
  • From: Christophe Pettus
• Re: mail alert
  • From: John R Pierce
• Re: Need help with libpq and PQexec
  • From: David Wilson
• mail alert
  • From: Jan Verheyden
• Re: keepalive problem with libpg connection
  • From: Merlin Moncure
• keepalive problem with libpg connection
  • From: Juan Backson
• Re: Need help with libpq and PQexec[RESOLVEd]
  • From: Juan Backson
• Need help with libpq and PQexec
  • From: Juan Backson
• Re: PQstatus does not seem to work
  • From: Juan Backson
• Re: xlog flus not satisfied
  • From: Ow Mun Heng
• Re: xlog flus not satisfied
  • From: Tom Lane
• xlog flus not satisfied
  • From: Ow Mun Heng
• Re: NOTICE: there is no transaction in progress
  • From: Shoaib Mir
• Re: Accessing a database form another database
  • From: Kobus Wolvaardt
• Re: libpq
  • From: Scott Ribe
• Re: Postgres memory question
  • From: Kobus Wolvaardt
• Re: Accessing a database form another database
  • From: Guy Rouillier
• Re: Postgres memory question
  • From: Scott Marlowe
• Re: Postgres memory question
  • From: Allan Kamau
• Re: Postgres memory question
  • From: Bill Moran
• Re: libpq
  • From: Merlin Moncure
• Re: libpq
  • From: Jim Michaels
• Re: PQstatus does not seem to work
  • From: Tim Hart
• Re: using COPY and PARTITON
  • From: Scott Marlowe
• Re: Postgres memory question
  • From: Vick Khera
• Re: PQstatus does not seem to work
  • From: Sam Mason
• Re: PQstatus does not seem to work
  • From: Tom Lane
• Re: Accessing a database form another database
  • From: David Fetter
• Re: NOTICE: there is no transaction in progress
  • From: John R Pierce
• Accessing a database form another database
  • From: Bill Thoen
• PQstatus does not seem to work
  • From: Juan Backson
• NOTICE: there is no transaction in progress
  • From: Rodrick Hales
• Re: Postgresql Backups
  • From: sub_woofer
• Re: Multiple foreign keys with the same name and information_schema
  • From: Jonathan Tapicer
• Re: Multiple foreign keys with the same name and information_schema
  • From: Tom Lane
• Multiple foreign keys with the same name and information_schema
  • From: Jonathan Tapicer
• Re: Postgres memory question
  • From: Bill Moran
• R: batch inserts in python & libpq
  • From: Scara Maccai
• Re: psql crashing - don't know why
  • From: Martijn van Oosterhout
• Re: using COPY and PARTITON
  • From: cjm1010
• ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC
  • From: utsav.turray
• Re: using COPY and PARTITON
  • From: Wojtek
• Re: using COPY and PARTITON
  • From: Scott Marlowe
• using COPY and PARTITON
  • From: cjm1010
• Re: psql crashing - don't know why
  • From: Shoaib Mir
• Re: Postgres memory question
  • From: John R Pierce
• Re: psql crashing - don't know why
  • From: Scott Marlowe
• psql crashing - don't know why
  • From: Brent Wood
• Re: Postgres memory question
  • From: Kobus Wolvaardt
• Re: Disable databse listing for non-superuser (\l) ?
  • From: Bruce Momjian
• Re: Postgres memory question
  • From: John R Pierce
• Re: Postgres memory question
  • From: Rainer Bauer
• Re: Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487
  • From: Magnus Hagander
• Re: Postgres memory question
  • From: Scott Marlowe
• Re: libpq
  • From: Scott Ribe
• Postgres memory question
  • From: Kobus Wolvaardt
• Re: bigint to ipaddress
  • From: Camilo Sperberg
• Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487
  • From: Abraham, Danny
• Postgres memory question
  • From: Kobus Wolvaardt
• bigint to ip
  • From: Mindaugas G.
• bigint to ipaddress
  • From: Mindaugas G.
• Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487
  • From: Abraham, Danny
• Re: Arrays and LIKE
  • From: David
• libpq
  • From: Jim Michaels
• Re: psql and Emacs on Windows
  • From: Wenjian Yang
• Re: A compare and/or sync. database structure?
  • From: Sualeh Fatehi
• Re: Postgresql Backups
  • From: Vick Khera
• Re: Arrays and LIKE
  • From: Sam Mason
• Re: 'a' = any( $${'a','x'} )
  • From: Vyacheslav Kalinin
• Re: duplicate key violates unique constraint
  • From: Filip Rembiałkowski
• Re: 'a' = any( $${'a','x'} )
  • From: Greg Stark
• 'a' = any( $${'a','x'} )
  • From: Jasen Betts
• Re: Arrays and LIKE
  • From: Jasen Betts
• duplicate key violates unique constraint
  • From: sweta
• Re: Arrays and LIKE
  • From: Andreas Kretschmer
• Arrays and LIKE
  • From: David
• Re: smart or dumb partition?
  • From: Bob Gobeille
• Adding ACL notion to existing tables
  • From: Bruno Baguette
• Re: Make check fails on 8.3.7
  • From: Tom Lane
• Re: smart or dumb partition?
  • From: Greg Stark
• smart or dumb partition?
  • From: Bob Gobeille
• Re: Make check fails on 8.3.7
  • From: Tom Lane
• Re: Make check fails on 8.3.7
  • From: Tom Lane
• Re: Make check fails on 8.3.7
  • From: Christine Desmuke
• Re: [HACKERS] \copy: unexpected response (4)
  • From: Tom Lane
• Re: Changing referenced primary key column type
  • From: Tom Lane
• Re: \copy: unexpected response (4)
  • From: Neil Best
• Changing referenced primary key column type
  • From: Andrus Moor
• Re: Postgresql Backups
  • From: Ray Stell
• Re: Postgresql Backups
  • From: Scott Marlowe
• Re: Getting linux $USER (and perhaps other env vars) in PL/pg-sql?
  • From: Sam Mason
• Getting linux $USER (and perhaps other env vars) in PL/pg-sql?
  • From: Gauthier, Dave
• Re: psql and Emacs on Windows
  • From: Bill Bartlett
• 2nd call for papers (PostgreSQL West)
  • From: Joshua D. Drake
• Re: \copy: unexpected response (4)
  • From: Tom Lane
• Re: psql and Emacs on Windows
  • From: Joshua D. Drake
• Re: psql and Emacs on Windows
  • From: Sam Mason
• Re: \copy: unexpected response (4)
  • From: Tom Lane
• psql and Emacs on Windows
  • From: Wenjian Yang
• Re: \copy: unexpected response (4)
  • From: Neil Best
• Re: \copy: unexpected response (4)
  • From: Tom Lane
• Re: using the schema in postbooks
  • From: John
• \copy: unexpected response (4)
  • From: Neil Best
• Re: using the schema in postbooks
  • From: John
• Re: using the schema in postbooks
  • From: Scott Mead
• Re: batch inserts in python & libpq
  • From: Sam Mason
• Re: using the schema in postbooks
  • From: Adrian Klaver
• using the schema in postbooks
  • From: John
• batch inserts in python & libpq
  • From: Scara Maccai
• Re: Make check fails on 8.3.7
  • From: Alban Hertroys
• Re: What happens when syslog gets blocked?
  • From: decibel
• Re: Make check fails on 8.3.7
  • From: Christine Desmuke
• Re: Idle processes chewing up CPU?
  • From: Brendan Hill
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Josh Trutwin
• Re: Foreign Key Deferrable Misunderstanding or Bug?
  • From: Stephan Szabo
• Re: Foreign Key Deferrable Misunderstanding or Bug?
  • From: Tom Lane
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Merlin Moncure
• Foreign Key Deferrable Misunderstanding or Bug?
  • From: Paul Rogers
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Michael Glaesemann
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Josh Trutwin
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Josh Trutwin
• Re: What happens when syslog gets blocked?
  • From: Bill Moran
• Re: JOIN a UNION
  • From: david.schruth
• Re: JOIN a UNION
  • From: Pavel Stehule
• Re: JOIN a UNION
  • From: David Fetter
• Re: What happens when syslog gets blocked?
  • From: Tom Lane
• Re: JOIN a UNION
  • From: Pavel Stehule
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Merlin Moncure
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Pavel Stehule
• Re: JOIN a UNION
  • From: david.schruth
• JOIN a UNION
  • From: david.schruth
• Re: Empty Updates, ON UPDATE triggers and Rules
  • From: Jeff Davis
• Re: Constraint between 2 tables and taking a coherent snapshot of both
  • From: decibel