Postgresql General Discussion

• Thread Index

• C-language functions: SRF question
  • From: Jorge Arevalo
• fulltext search stemming/ spelling problems
  • From: Corin
• Re: Cannot read block 348938 of pdbsynchtable
  • From: Ben Chobot
• Re: [offtopic] How do you name a table...
  • From: Justin Graf
• Cannot read block 348938 of pdbsynchtable
  • From: Utsav Turray
• Unable to uninstall postgres from Add/Remove programs
  • From: Jeffrey Ottery
• Re: [offtopic] How do you name a table...
  • From: Bill Moran
• Re: [offtopic] How do you name a table...
  • From: Karsten Hilbert
• Re: [offtopic] How do you name a table...
  • From: Yeb Havinga
• Modify standard PG type casts?
  • From: Łukasz Dejneka
• Re: [offtopic] How do you name a table...
  • From: Ian Barwick
• [offtopic] How do you name a table...
  • From: Ognjen Blagojevic
• Re: Extending PostGreSQL/PostGIS with an abstract data type.
  • From: Craig Ringer
• Re: Grant column level permissions
  • From: Michał Pawlikowski
• Re: Grant column level permissions
  • From: dipti shah
• Re: Grant column level permissions
  • From: dipti shah
• Re: Grant column level permissions
  • From: Michał Pawlikowski
• Re: Grant column level permissions
  • From: dipti shah
• Re: Grant column level permissions
  • From: dipti shah
• Re: Grant column level permissions
  • From: Michael Glaesemann
• Extending PostGreSQL/PostGIS with an abstract data type.
  • From: donia zheni
• Re: beginner problems with count(*)
  • From: A. Kretschmer
• beginner problems with count(*)
  • From: Me Self
• Re: Solid State Drives with PG
  • From: Yeb Havinga
• Grant column level permissions
  • From: dipti shah
• nice to have feature: default_index_tablespace
  • From: Marc Mamin
• Re: Internal PG functions, how to pass proper parameters?
  • From: Łukasz Dejneka
• Re: Solid State Drives with PG
  • From: Greg Smith
• Re: Unique cosntraint based on contents of a field?
  • From: Jaime Casanova
• Unique cosntraint based on contents of a field?
  • From: Warren Bell
• Re: Postgres 9 alpha 5 revised, stored proc
  • From: Andy Colson
• Re: Postgres 9 alpha 5 revised, stored proc
  • From: Tom Lane
• Postgres 9 alpha 5 revised, stored proc
  • From: Andy Colson
• Re: Solid State Drives with PG
  • From: Gordan Bobic
• Re: Solid State Drives with PG
  • From: John R Pierce
• Re: dump error parent table oid of pg_rewrite entry oid not found
  • From: Tom Lane
• Re: Solid State Drives with PG
  • From: Vick Khera
• Re: Internal PG functions, how to pass proper parameters?
  • From: Martijn van Oosterhout
• Re: Solid State Drives with PG
  • From: Merlin Moncure
• dump error parent table oid of pg_rewrite entry oid not found
  • From: Doug Kyle
• Re: Problem either with PostgreSQL or with PHP (SOLVED!)
  • From: Tuo Pe
• Re: Solid State Drives with PG
  • From: Vick Khera
• Re: Problems backing up
  • From: Tom Lane
• Re: count with high allocation
  • From: Pavel Stehule
• Re: Problems backing up
  • From: Sebastien Boisvert
• Res: count with high allocation
  • From: paulo matadr
• Re: count with high allocation
  • From: Pavel Stehule
• Re: count with high allocation
  • From: Scott Marlowe
• Res: count with high allocation
  • From: paulo matadr
• Re: Problem either with PostgreSQL or with PHP
  • From: Scott Marlowe
• Re: Problem either with PostgreSQL or with PHP
  • From: Frank Heikens
• Re: Problem either with PostgreSQL or with PHP
  • From: tv
• Re: Problem either with PostgreSQL or with PHP
  • From: Tom Lane
• Re: Problem either with PostgreSQL or with PHP
  • From: Scott Marlowe
• Problem either with PostgreSQL or with PHP
  • From: Tuo Pe
• Re: cursors from pl/pgsql
  • From: Marc Menem
• Internal PG functions, how to pass proper parameters?
  • From: Łukasz Dejneka
• can't connect to server on localhost - solved
  • From: Heine Ferreira
• Re: count with high allocation
  • From: Pavel Stehule
• Re: Postgres 9.0 and desktop heap usage in windows
  • From: Magnus Hagander
• Postgres 9.0 and desktop heap usage in windows
  • From: Heine Ferreira
• Res: count with high allocation
  • From: paulo matadr
• Re: count with high allocation
  • From: Tom Lane
• Re: default grant
  • From: Ing. Marcos Ortiz Valmaseda
• Re: count with high allocation
  • From: Scott Marlowe
• Re: count with high allocation
  • From: Pavel Stehule
• Re: default grant
  • From: Sim Zacks
• count with high allocation
  • From: paulo matadr
• Re: cursors from pl/pgsql
  • From: Merlin Moncure
• Re: desktop heap usage in windows
  • From: Magnus Hagander
• default grant
  • From: Sim Zacks
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: cursors from pl/pgsql
  • From: Pavel Stehule
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: "1-Click" installer problems
  • From: Craig Ringer
• cursors from pl/pgsql
  • From: Marc Menem
• Re: can't connect to server on localhost
  • From: Alban Hertroys
• Re: Before update trigger causing another after trigger to fire, returning NULL, causing before trigger to not update - does this make sense?
  • From: Tom Lane
• Before update trigger causing another after trigger to fire, returning NULL, causing before trigger to not update - does this make sense?
  • From: Susan Cassidy
• can't connect to server on localhost
  • From: Heine Ferreira
• Re: Temporal data storage
  • From: Jeff Davis
• Re: Connection Pooling
  • From: Merlin Moncure
• Re: Connection Pooling
  • From: David Kerr
• Re: Connection Pooling
  • From: David Kerr
• Re: Fuzzy string matching of product names
  • From: Andy Colson
• Re: Completely wrong row estimates
  • From: Björn Lindqvist
• Re: Completely wrong row estimates
  • From: Scott Mead
• Re: Completely wrong row estimates
  • From: Björn Lindqvist
• Re: Fuzzy string matching of product names
  • From: Peter Geoghegan
• Re: desktop heap usage in windows
  • From: John R Pierce
• Re: desktop heap usage in windows
  • From: Magnus Hagander
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: Connection Pooling
  • From: Scott Marlowe
• Re: Connection Pooling
  • From: Merlin Moncure
• Re: windows 7 compatiblity?
  • From: Dave Page
• Re: desktop heap usage in windows
  • From: John R Pierce
• Re: desktop heap usage in windows
  • From: Magnus Hagander
• Re: 'Anneal' <> 'Anneal'
  • From: Rob Richardson
• 'Anneal' <> 'Anneal'
  • From: Rob Richardson
• Re: Connection Pooling
  • From: David Kerr
• Re: desktop heap usage in windows
  • From: John R Pierce
• Re: windows 7 compatiblity?
  • From: John R Pierce
• Re: Fuzzy string matching of product names
  • From: Leif Biberg Kristensen
• Re: Fuzzy string matching of product names
  • From: Bill Moran
• Re: windows 7 compatiblity?
  • From: John R Pierce
• Re: Fuzzy string matching of product names
  • From: Peter Geoghegan
• Re: Fuzzy string matching of product names
  • From: George Silva
• Re: windows 7 compatiblity?
  • From: Garry Saddington
• Re: Fuzzy string matching of product names
  • From: Brian Modra
• Re: Fuzzy string matching of product names
  • From: Bill Moran
• Fuzzy string matching of product names
  • From: Peter Geoghegan
• Re: windows 7 compatiblity?
  • From: Frank Heikens
• desktop heap usage in windows
  • From: Heine Ferreira
• Re: windows 7 compatiblity?
  • From: Pavel Stehule
• windows 7 compatiblity?
  • From: Heine Ferreira
• Re: count function alternative in postgres
  • From: Tom Lane
• Re: count function alternative in postgres
  • From: Merlin Moncure
• Re: How to fix set-valued function called in contextthat cannot accept a set in earlier versions
  • From: Alban Hertroys
• Temporal data storage
  • From: Gerhard Heift
• Re: Null vs. Empty String in Postgres 8.3.8
  • From: Tim Landscheidt
• Re: How to fix set-valued function called in context that cannot accept a set in earlier versions
  • From: Andrus
• Re: How to fix set-valued function called in contextthat cannot accept a set in earlier versions
  • From: Andrus
• Re: How to fix set-valued function called in context that cannot accept a set in earlier versions
  • From: hubert depesz lubaczewski
• Re: How to fix set-valued function called in context that cannot accept a set in earlier versions
  • From: Andrus
• Re: join two tables without a key
  • From: Igor Neyman
• Re: How to fix set-valued function called in context that cannot accept a set in earlier versions
  • From: Merlin Moncure
• Re: How to fix set-valued function called in context that cannot accept a set in earlier versions
  • From: Kenichiro Tanaka
• Re: How to fix set-valued function called in context that cannot accept a set in earlier versions
  • From: hubert depesz lubaczewski
• How to fix set-valued function called in context that cannot accept a set in earlier versions
  • From: Andrus
• Uninstalling the pl/pgsql debugger
  • From: Raymond O'Donnell
• Re: Completely wrong row estimates
  • From: Magnus Hagander
• Re: Dynamic plpgsql help
  • From: Sreelatha G
• Re: Null vs. Empty String in Postgres 8.3.8
  • From: CaT
• Re: Null vs. Empty String in Postgres 8.3.8
  • From: Peter Hunsberger
• Re: Null vs. Empty String in Postgres 8.3.8
  • From: Scott Marlowe
• Re: Null vs. Empty String in Postgres 8.3.8
  • From: Wang, Mary Y
• Re: Null vs. Empty String in Postgres 8.3.8
  • From: Tom Lane
• Null vs. Empty String in Postgres 8.3.8
  • From: Wang, Mary Y
• Re: Completely wrong row estimates
  • From: Nilesh Govindarajan
• Re: Completely wrong row estimates
  • From: Rob Wultsch
• Completely wrong row estimates
  • From: Björn Lindqvist
• Re: Connection Pooling
  • From: Halil Türker Özdamar
• Re: How to configure the postmaster daemon so that it accepts TCP connections?
  • From: Tom Lane
• Re: Dynamic plpgsql help
  • From: Pavel Stehule
• Re: How to configure the postmaster daemon so that it accepts TCP connections?
  • From: Ankuj Gupta
• Domain for regular expressions?
  • From: Tim Landscheidt
• Re: How to configure the postmaster daemon so that it accepts TCP connections?
  • From: Scott Marlowe
• Re: How to configure the postmaster daemon so that it accepts TCP connections?
  • From: Ankuj Gupta
• Dynamic plpgsql help
  • From: Scott Geller
• Re: How to configure the postmaster daemon so that it accepts TCP connections?
  • From: Scott Marlowe
• How to configure the postmaster daemon so that it accepts TCP connections?
  • From: Ankuj Gupta
• Re: ERROR: cache lookup failed for relation X
  • From: raghavendra t
• Re: ERROR: cache lookup failed for relation X
  • From: raghavendra t
• Re: Connection Pooling
  • From: Merlin Moncure
• Re: Connection Pooling
  • From: Lew
• Re: How to implement word wrap
  • From: Andrus
• Re: any built-in function to get time in seconds?
  • From: Scott Bailey
• Re: count function alternative in postgres
  • From: Scott Bailey
• Re: ERROR: cache lookup failed for relation X
  • From: Tom Lane
• Re: ERROR: cache lookup failed for relation X
  • From: justin@xxxxxxxxxxxx
• ERROR: cache lookup failed for relation X
  • From: raghavendra t
• Re: count function alternative in postgres
  • From: Tom Lane
• count function alternative in postgres
  • From: junaidmalik14
• count function alternative in postgres
  • From: junaid malik
• Re: Advice on webbased database reporting
  • From: Boszormenyi Zoltan
• Re: join two tables without a key
  • From: Andreas Kretschmer
• Re: join two tables without a key
  • From: Raymond O'Donnell
• Re: join two tables without a key
  • From: Dino Vliet
• Re: join two tables without a key
  • From: Jeremy Harris
• Re: join two tables without a key
  • From: Raymond O'Donnell
• join two tables without a key
  • From: Dino Vliet
• Re: Performance statistics
  • From: Craig Ringer
• Re: Advice on webbased database reporting
  • From: Brian Modra
• Re: warm standby possible with 8.1?
  • From: zhong ming wu
• Re: any built-in function to get time in seconds?
  • From: Adrian Klaver
• any built-in function to get time in seconds?
  • From: zhong ming wu
• Re: Table space question
  • From: Kevin Kempter
• Table space question
  • From: akp geek
• Re: Lifekeeper
  • From: Greg Sabino Mullane
• Re: Advice on webbased database reporting
  • From: Leif Biberg Kristensen
• HW and performances
  • From: Ivan Sergio Borgonovo
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: Igor Neyman
• Advice on webbased database reporting
  • From: Davor J.
• Re: "1-Click" installer problems
  • From: Sachin Srivastava
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: "1-Click" installer problems
  • From: Sachin Srivastava
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: John R Pierce
• Re: "1-Click" installer problems
  • From: Sachin Srivastava
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: John R Pierce
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: John Gage
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: How to setup a column constraint for an integer type? Default 0 if not defined
  • From: John R Pierce
• How to setup a column constraint for an integer type? Default 0 if not defined
  • From: Wang, Mary Y
• Re: Accessing Windows install of PostgreSQL via cygwin
  • From: Filip Rembiałkowski
• Accessing Windows install of PostgreSQL via cygwin
  • From: nerdydork
• Re: Wikipedia entry - AmigaOS port - error?
  • From: Glyn Astill
• Re: temporary table
  • From: Amol Chiplunkar
• Re: Wikipedia entry - AmigaOS port - error?
  • From: Tom Lane
• Re: Wikipedia entry - AmigaOS port - error?
  • From: Glyn Astill
• Re: [Solved] 8.3 Stats Collector Stuck at 100% CPU
  • From: Josh Kupershmidt
• Re: Array value syntax and escaping
  • From: Peter Bex
• temporary table
  • From: Szymon Guz
• Re: Array value syntax and escaping
  • From: Tom Lane
• Re: transaction control in pl/pgsql
  • From: Merlin Moncure
• Re: [Solved] 8.3 Stats Collector Stuck at 100% CPU
  • From: Tom Lane
• Re: [Solved] 8.3 Stats Collector Stuck at 100% CPU
  • From: Josh Kupershmidt
• Array value syntax and escaping
  • From: Peter Bex
• Lifekeeper
  • From: Brad Nicholson
• Re: PostgreSQL on Windows
  • From: Mark Vantzelfde
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Adrian Klaver
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Joshua D. Drake
• Re: Wikipedia entry - AmigaOS port - error?
  • From: Tom Lane
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Scott Marlowe
• Re: "1-Click" installer problems
  • From: John Gage
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Dave Page
• Anyone using RubyRep replication?
  • From: Ozz Nixon
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: David E. Wheeler
• Wikipedia entry - AmigaOS port - error?
  • From: Glyn Astill
• Re: Postgres 9.1 - Release Theme
  • From: tv
• Re: transaction control in pl/pgsql
  • From: Alban Hertroys
• Re: [Solved] 8.3 Stats Collector Stuck at 100% CPU
  • From: Tom Lane
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Alvaro Herrera
• Re: pgreplay log file replayer released
  • From: Greg Smith
• Performance statistics
  • From: Michael Gould
• Re: transaction control in pl/pgsql
  • From: Birgit Laggner
• Re: PgCluster
  • From: Thom Brown
• Re: "1-Click" installer problems
  • From: Massa, Harald Armin
• Re: postgres vs mysql conventional wisdom
  • From: Thom Brown
• PgCluster
  • From: mike stanton
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: transaction control in pl/pgsql
  • From: Alban Hertroys
• postgres vs mysql conventional wisdom
  • From: Ron Mayer
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: Peter Geoghegan
• Large Object leakage
  • From: Harald Fuchs
• Re: prevent connection using pgpass.conf
  • From: Alban Hertroys
• Re: transaction control in pl/pgsql
  • From: Grzegorz Jaśkiewicz
• Re: transaction control in pl/pgsql
  • From: Birgit Laggner
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: transaction control in pl/pgsql
  • From: Pavel Stehule
• Re: transaction control in pl/pgsql
  • From: Grzegorz Jaśkiewicz
• transaction control in pl/pgsql
  • From: Birgit Laggner
• Re: "1-Click" installer problems
  • From: Thomas Kellerer
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: Magnus Hagander
• Re: prevent connection using pgpass.conf
  • From: Magnus Hagander
• Re: Re : Re : Re : Re : Select in temporary table
  • From: Alban Hertroys
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Magnus Hagander
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: Sachin Srivastava
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: Prevent users to drop triggers applied on table
  • From: Alban Hertroys
• Re: prevent connection using pgpass.conf
  • From: John R Pierce
• Re: prevent connection using pgpass.conf
  • From: Guillaume Lelarge
• Re: prevent connection using pgpass.conf
  • From: Christophe Dore
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Ilya Kosmodemiansky
• Re : Re : Re : Re : Select in temporary table
  • From: Sylvain Lara
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: gabriele.bartolini
• Re: Postgres 9.1 - Release Theme
  • From: Gerd Koenig
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Dave Page
• Re: [HACKERS] Postgres 9.1 - Release Theme
  • From: Thom Brown
• Re: "1-Click" installer problems
  • From: Dave Page
• Postgres 9.1 - Release Theme
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: Dave Page
• Re: "1-Click" installer problems
  • From: John R Pierce
• Re: Prevent users to drop triggers applied on table
  • From: dipti shah
• Re: "1-Click" installer problems
  • From: Thomas Kellerer
• Re: Prevent users to drop triggers applied on table
  • From: John R Pierce
• Re: Re : Re : Re : Select in temporary table
  • From: jose javier parra sanchez
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: Get the list of permissions on schema for current user
  • From: Jignesh Shah
• Re : Re : Re : Select in temporary table
  • From: Sylvain Lara
• Prevent users to drop triggers applied on table
  • From: dipti shah
• Re: "1-Click" installer problems
  • From: Thomas Kellerer
• Re : Re : Select in temporary table
  • From: Sylvain Lara
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Faheem Mitha
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Re: "1-Click" installer problems
  • From: Nikhil G. Daddikar
• Get the list of permissions on schema for current user
  • From: dipti shah
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: "1-Click" installer problems
  • From: Joshua D. Drake
• Re: "1-Click" installer problems
  • From: Craig Ringer
• Re: "1-Click" installer problems
  • From: Craig Ringer
• "1-Click" installer problems
  • From: Nikhil G. Daddikar
• [Solved] 8.3 Stats Collector Stuck at 100% CPU
  • From: Josh Kupershmidt
• REINDEX Question
  • From: raghavendra t
• Re: Windows build missing tcl "UNKNOWN" support
  • From: Carlo Stonebanks
• Re: Windows build missing tcl "UNKNOWN" support
  • From: Tom Lane
• Re : Select in temporary table
  • From: Sylvain Lara
• Re: Running vacuum after delete does not remove all space allocated
  • From: Scott Marlowe
• Re: Select in temporary table
  • From: Bill Moran
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Bruce Momjian
• Select in temporary table
  • From: Sylvain Lara
• Running vacuum after delete does not remove all space allocated
  • From: Chris Barnes
• Windows build missing tcl "UNKNOWN" support
  • From: Carlo Stonebanks
• Re: prevent connection using pgpass.conf
  • From: Raymond O'Donnell
• Re: prevent connection using pgpass.conf
  • From: Joshua D. Drake
• prevent connection using pgpass.conf
  • From: Christophe Dore
• Re: using gist index with dual-temporal timestamp values
  • From: Andreas Kretschmer
• using gist index with dual-temporal timestamp values
  • From: Anssi Kääriäinen
• Re: Res: COPY ERROR
  • From: Albe Laurenz
• Re: Running Windows on a Mac partition
  • From: Craig Ringer
• Re: Running Windows on a Mac partition
  • From: Joshua Berry
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Raymond O'Donnell
• Re: Force PostgreSQL to query a custom index structure
  • From: Tom Lane
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Tom Lane
• Enc: Res: COPY ERROR
  • From: paulo matadr
• Res: COPY ERROR
  • From: paulo matadr
• Re: plPgSQL + CDIR/INET types ...
  • From: Harald Fuchs
• Re: [NOVICE] Connect to postgresql database using Perl
  • From: Sean Davis
• Re: User action accounting
  • From: Guillaume Lelarge
• Re: Connect to postgresql database using Perl
  • From: dipti shah
• Re: Connect to postgresql database using Perl
  • From: John R Pierce
• Force PostgreSQL to query a custom index structure
  • From: Carsten Kropf
• Re: Connect to postgresql database using Perl
  • From: dipti shah
• Re: Connect to postgresql database using Perl
  • From: Pavel Stehule
• Connect to postgresql database using Perl
  • From: dipti shah
• Re: Running Windows on a Mac partition
  • From: John Gage
• Re: Running Windows on a Mac partition
  • From: John Gage
• Re: Running Windows on a Mac partition
  • From: Craig Ringer
• Re: Running Windows on a Mac partition
  • From: John Gage
• Re: User action accounting
  • From: Craig Ringer
• Unsubscribe
  • From: Wojtek
• Re: plPgSQL + CDIR/INET types ...
  • From: Steve Atkins
• plPgSQL + CDIR/INET types ...
  • From: Marc G. Fournier
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Adrian Klaver
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Steve Atkins
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Jeff Davis
• Re: pgfoundry registration
  • From: Jeff Davis
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Adrian Klaver
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Wang, Mary Y
• Re: Migration - not null default '0' -> not null default 0 - confused
  • From: Adrian Klaver
• Migration - not null default '0' -> not null default 0 - confused
  • From: Wang, Mary Y
• Re: Running Windows on a Mac partition
  • From: Scott Marlowe
• Re: Running Windows on a Mac partition
  • From: Joshua Berry
• Re: Running Windows on a Mac partition
  • From: Scott Marlowe
• Running Windows on a Mac partition
  • From: John Gage
• Re: Converting time interval to double precision of time unit
  • From: Mike Toews
• Re: Converting time interval to double precision of time unit
  • From: Tom Lane
• Re: Wiki Updates - 9.0
  • From: Greg Smith
• Re: Wiki Updates - 9.0
  • From: Raymond O'Donnell
• Wiki Updates - 9.0
  • From: Tyler Hains
• Re: set statement_timeout does not work
  • From: Scott Marlowe
• Re: Converting time interval to double precision of time unit
  • From: Alban Hertroys
• Re: set statement_timeout does not work
  • From: Jun Wang
• Re: User action accounting
  • From: Steve Atkins
• Re: Dblink vs calling a function that returns void
  • From: Tom Lane
• Re: User action accounting
  • From: Andy Colson
• Converting time interval to double precision of time unit
  • From: Mike Toews
• Re: Dblink vs calling a function that returns void
  • From: Merlin Moncure
• Re: User action accounting
  • From: Joshua Berry
• Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
  • From: moataz Elmasry
• Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
  • From: moataz Elmasry
• Re: User action accounting
  • From: Andy Colson
• Re: hstore equality-index performance question
  • From: Tom Lane
• Re: hstore equality-index performance question
  • From: Stefan Keller
• User action accounting
  • From: Joshua Berry
• Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
  • From: Andy Colson
• Re: different behaviour between select and delete when constraint_exclusion = partition
  • From: Tom Lane
• Re: Processor speed relative to postgres transactions per second
  • From: Merlin Moncure
• createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
  • From: moataz Elmasry
• createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
  • From: moataz Elmasry
• different behaviour between select and delete when constraint_exclusion = partition
  • From: Marc Cousin
• Re: Running/cumulative count using windows
  • From: A. Kretschmer
• Running/cumulative count using windows
  • From: Oliver Kohll - Mailing Lists
• Get the list of permissions on schema for current user
  • From: dipti shah
• Re: insert into test_b (select * from test_a) with different column order
  • From: Szymon Guz
• Emphasizing "current item" in subclass of QAbstractItemView
  • From: Davor J.
• Re: How to implement word wrap
  • From: Alban Hertroys
• Re: insert into test_b (select * from test_a) with different column order
  • From: Ole Tange
• Re: Get the list of permissions/privileges on schema
  • From: dipti shah
• Re: How to implement word wrap
  • From: Andrus
• Re: COPY ERROR
  • From: Albe Laurenz
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Faheem Mitha
• set statement_timeout does not work
  • From: Jun Wang
• Re: Floating point exception in initdb
  • From: Vikram Patil
• Re: Floating point exception in initdb
  • From: Tom Lane
• Re: Floating point exception in initdb
  • From: Vikram Patil
• Re: Floating point exception in initdb
  • From: Tom Lane
• Floating point exception in initdb
  • From: Vikram Patil
• Re: hstore equality-index performance question
  • From: Sergey Konoplev
• Re: hstore equality-index performance question
  • From: Stefan Keller
• COPY ERROR
  • From: paulo matadr
• Re: Side effect of synchronous_commit = off
  • From: Arthur Turrini
• Re: playr (or similar tool)?
  • From: Greg Smith
• Re: Processor speed relative to postgres transactions per second
  • From: Greg Smith
• Re: How long will the query take
  • From: John Gage
• Re: PostgreSQL on Windows
  • From: Mark Vantzelfde
• Re: How to give security to pg_catalogs
  • From: raghavendra t
• Re: PostgreSQL on Windows
  • From: Raymond O'Donnell
• Re: Processor speed relative to postgres transactions per second
  • From: Scott Marlowe
• PostgreSQL on Windows
  • From: Mark Vantzelfde
• Re: How to perform text merge
  • From: Harald Fuchs
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Re: How long will the query take
  • From: Bill Moran
• Re: Processor speed relative to postgres transactions per second
  • From: Steve Atkins
• Re: How to implement word wrap
  • From: Thom Brown
• Re: How to implement word wrap
  • From: Andreas Kretschmer
• Re: How to implement word wrap
  • From: Thom Brown
• Re: Warm Standby Setup Documentation
  • From: Ogden
• Processor speed relative to postgres transactions per second
  • From: Chris Barnes
• How to implement word wrap
  • From: Andrus
• Re: How long will the query take
  • From: Andreas Kretschmer
• Re: Dblink vs calling a function that returns void
  • From: Tom Lane
• Re: Splitting text column tomultiple rows
  • From: Pavel Stehule
• Re: How long will the query take
  • From: Bill Moran
• Re: help
  • From: Raymond O'Donnell
• Re: How long will the query take
  • From: A. Kretschmer
• Re: Splitting text column tomultiple rows
  • From: Andrus
• Re: best practice in archiving CDR data
  • From: David Fetter
• Re: ***SPAM*** Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• [no subject]
  • From: 赤松 建司
• Dblink vs calling a function that returns void
  • From: Boszormenyi Zoltan
• Re: ***SPAM*** Re: Splitting text column to multiple rows
  • From: Andrus
• help
  • From: 赤松 建司
• How long will the query take
  • From: John Gage
• Re: Splitting text column to multiple rows
  • From: Tom Lane
• Re: optimizing import of large CSV file into partitioned table?
  • From: Rick Casey
• Re: best practice in archiving CDR data
  • From: Edgardo Portal
• Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• Re: Splitting text column to multiple rows
  • From: Tom Lane
• Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• Re: Splitting text column to multiple rows
  • From: Andrus
• Re: insert into test_b (select * from test_a) with different column order
  • From: Leif Biberg Kristensen
• Re: Splitting text column to multiple rows
  • From: Andrus
• Re: Splitting text column to multiple rows
  • From: Andrus
• Re: Splitting text column to multiple rows
  • From: Tom Lane
• Re: How to give security to pg_catalogs
  • From: Tom Lane
• insert into test_b (select * from test_a) with different column order
  • From: Ole Tange
• Re: optimizing import of large CSV file into partitioned table?
  • From: Dimitri Fontaine
• Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• Re: Splitting text column to multiple rows
  • From: Andrus
• Re: [pgsql-general] looking for a powerful frontend/teport generator
  • From: Oliver Kohll - Mailing Lists
• Re: best practice in archiving CDR data
  • From: Juan Backson
• Re: best practice in archiving CDR data
  • From: A. Kretschmer
• best practice in archiving CDR data
  • From: Juan Backson
• Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• How to give security to pg_catalogs
  • From: raghavendra t
• Re: Splitting text column to multiple rows
  • From: Andrus
• Re: hstore equality-index performance question
  • From: Sergey Konoplev
• Re: one null value in array isnt allowed???
  • From: Wappler, Robert
• one null value in array isnt allowed???
  • From: Armand Turpel
• Re: need a query
  • From: Ognjen Blagojevic
• Re: need a query
  • From: Timo Klecker
• Re: need a query
  • From: Florent THOMAS
• need a query
  • From: AI Rumman
• looking for a powerful frontend/teport generator
  • From: Clemens Eisserer
• Re: Why index occupy less amount of space than the table with same structure.
  • From: Alban Hertroys
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Re: Connection Pooling
  • From: Wappler, Robert
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Faheem Mitha
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Faheem Mitha
• Re: Simultaneous write requests
  • From: Greg Smith
• Re: Warm Standby Setup Documentation
  • From: Greg Smith
• Re: Warm Standby Setup Documentation
  • From: Greg Smith
• Simultaneous write requests
  • From: Vitali Xevet
• Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• Re: Moving data directory from one server to another
  • From: Ehsan Haq
• Re: Why index occupy less amount of space than the table with same structure.
  • From: Tadipathri Raghu
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Andy Colson
• Re: optimizing import of large CSV file into partitioned table?
  • From: Nagy Zoltan
• Re: Warm Standby Setup Documentation
  • From: Yar Tykhiy
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Andy Colson
• Re: warm standby possible with 8.1?
  • From: Yar Tykhiy
• Re: Using readline for frequently used queries
  • From: Tim Landscheidt
• Re: optimizing import of large CSV file into partitioned table?
  • From: Filip Rembiałkowski
• hstore equality-index performance question
  • From: Stefan Keller
• Re: Connection Pooling
  • From: David Kerr
• Re: How to generate a valid postgre TIMESTAMP with PHP?
  • From: APseudoUtopia
• Re: How many Mandatory Process are there in Postgres
  • From: Guillaume Lelarge
• Re: Achieving ordered update
  • From: Bopolissimus Platypus Jr
• Re: Splitting text column to multiple rows
  • From: Andrus
• Re: How to perform text merge
  • From: Andrus
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Faheem Mitha
• Re: optimizing import of large CSV file into partitioned table?
  • From: Thom Brown
• Re: How to generate a valid postgre TIMESTAMP with PHP?
  • From: Scott Marlowe
• optimizing import of large CSV file into partitioned table?
  • From: Rick Casey
• How to generate a valid postgre TIMESTAMP with PHP?
  • From: Andre Lopes
• Re: How to perform text merge
  • From: Alban Hertroys
• Re: Splitting text column to multiple rows
  • From: Pavel Stehule
• How to perform text merge
  • From: Andrus
• Splitting text column to multiple rows
  • From: Andrus
• Re: How many Mandatory Process are there in Postgres
  • From: Scott Marlowe
• Re: simultaneously reducing both memory usage and runtime for a query
  • From: Tom Lane
• Re: Why index occupy less amount of space than the table with same structure.
  • From: Alban Hertroys
• Designing Postgres Security Model
  • From: dipti shah
• Why index occupy less amount of space than the table with same structure.
  • From: Tadipathri Raghu
• Re: How many Mandatory Process are there in Postgres
  • From: Tadipathri Raghu
• simultaneously reducing both memory usage and runtime for a query
  • From: Faheem Mitha
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Re: How can I import a perl module into a plperl function ?
  • From: hubert depesz lubaczewski
• How can I import a perl module into a plperl function ?
  • From: Grillo Grillo
• Re: Get the list of permissions/privileges on schema
  • From: dipti shah
• Re: Connection Pooling
  • From: John R Pierce
• Re: Connection Pooling
  • From: Allan Kamau
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Connection Pooling
  • From: David Kerr
• Re: Warm Standby Setup Documentation
  • From: Bryan Murphy
• Re: R: round(x) function
  • From: Tom Lane
• R: round(x) function
  • From: Gaietti, Mauro (SELEX GALILEO Guest, Italy)
• Re: Solid State Drives with PG
  • From: Merlin Moncure
• Re: Solid State Drives with PG
  • From: Brad Nicholson
• Re: Storing data on a regular lat/lon grid
  • From: Merlin Moncure
• Re: Solid State Drives with PG
  • From: Merlin Moncure
• Storing data on a regular lat/lon grid
  • From: Mike Charles
• Re: Warm Standby Setup Documentation
  • From: Ogden
• Re: Solid State Drives with PG
  • From: Greg Smith
• Re: Warm Standby Setup Documentation
  • From: Greg Smith
• Moving data directory from one server to another
  • From: Ehsan Haq
• Re: Error 42501 permission denied for schema
  • From: Tom Lane
• Re: Does anyone use in ram postgres database?
  • From: Chris Barnes
• Re: round(x) function
  • From: Justin Graf
• Re: Does anyone use in ram postgres database?
  • From: John R Pierce
• Re: round(x) function
  • From: Tom Lane
• round(x) function
  • From: Gaietti, Mauro (SELEX GALILEO Guest, Italy)
• Re: Solid State Drives with PG (was: in RAM DB)
  • From: Merlin Moncure
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Rajan, Pavithra
• Re: Does anyone use in ram postgres database?
  • From: John Gage
• Re: Large index operation crashes postgres
  • From: Paul Ramsey
• Re: Large index operation crashes postgres
  • From: Tom Lane
• Re: Error 42501 permission denied for schema
  • From: akp geek
• Re: Error 42501 permission denied for schema
  • From: Tom Lane
• Re: Does anyone use in ram postgres database?
  • From: Ozz Nixon
• Re: Does anyone use in ram postgres database?
  • From: Merlin Moncure
• Error 42501 permission denied for schema
  • From: akp geek
• Re: Does anyone use in ram postgres database?
  • From: John Gage
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Rajan, Pavithra
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Timo Klecker
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Grzegorz Jaśkiewicz
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Szymon Guz
• Using readline for frequently used queries
  • From: Tim Landscheidt
• Solid State Drives with PG (was: in RAM DB)
  • From: Alan McKay
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Timo Klecker
• Re: Does anyone use in ram postgres database?
  • From: Gordan Bobic
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Grzegorz Jaśkiewicz
• Re: Does anyone use in ram postgres database?
  • From: Alan McKay
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Thom Brown
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Timo Klecker
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Rajan, Pavithra
• Re: Need help on updating an entire column with a list of values, I have.
  • From: Szymon Guz
• Re: Does anyone use in ram postgres database?
  • From: Ozz Nixon
• Re: Does anyone use in ram postgres database?
  • From: Alan McKay
• Need help on updating an entire column with a list of values, I have.
  • From: Rajan, Pavithra
• Re: Does anyone use in ram postgres database?
  • From: Alan McKay
• How to write Rules on a View to allow all actions as in the physical table?
  • From: Andre Lopes
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Invitation to connect on LinkedIn
  • From: Paresh Masani
• Re: Avoiding deadlocks on mass delete / update
  • From: Роман Маширов
• Re: Problem with Memory Leak
  • From: Tom Lane
• Re: How to retrieve List of Tables in a Database using...
  • From: Yogi Yang 007
• Re: Problem with Memory Leak
  • From: Pete Kay
• Re: How many Mandatory Process are there in Postgres
  • From: Scott Marlowe
• Re: How many Mandatory Process are there in Postgres
  • From: Tadipathri Raghu
• Re: Problem with Memory Leak
  • From: Tom Lane
• Problem with Memory Leak
  • From: Pete Kay
• Geoffrey Gowey wants to stay in touch on LinkedIn
  • From: Geoffrey Gowey
• Re: Get the list of permissions/privileges on schema
  • From: John R Pierce
• Re: Performing FETCH ALL from a SCROLL CURSOR failing to return results
  • From: Tom Lane
• Performing FETCH ALL from a SCROLL CURSOR failing to return results
  • From: Eliot Gable
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Re: Does anyone use in ram postgres database?
  • From: Scott Marlowe
• Re: Does anyone use in ram postgres database?
  • From: Merlin Moncure
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Does anyone use in ram postgres database?
  • From: Chris Barnes
• Re: How many Mandatory Process are there in Postgres
  • From: Scott Mead
• Re: tables getting bloated
  • From: akp geek
• Re: How many Mandatory Process are there in Postgres
  • From: tv
• Re: How many Mandatory Process are there in Postgres
  • From: Tadipathri Raghu
• Re: find a string contained in an attribute
  • From: Pavel Stehule
• Re: find a string contained in an attribute
  • From: Karina Guardado
• Re: data type to store a lot of text and tables of data
  • From: Karina Guardado
• Re: How many Mandatory Process are there in Postgres
  • From: tv
• How many Mandatory Process are there in Postgres
  • From: Tadipathri Raghu
• pgfoundry registration
  • From: Krzysztof Nienartowicz
• Re: Achieving ordered update
  • From: Thom Brown
• Achieving ordered update
  • From: Allan Kamau
• Re: What datatype should I use to store an IP Address?
  • From: Devrim GÜNDÜZ
• Re: What datatype should I use to store an IP Address?
  • From: Michał Pawlikowski
• What datatype should I use to store an IP Address?
  • From: Andre Lopes
• Re: Get the list of permissions/privileges on schema
  • From: dipti shah
• Re: Get the list of permissions/privileges on schema
  • From: Ashesh Vashi
• Re: Get the list of permissions/privileges on schema
  • From: Sergey Konoplev
• Re: Get the list of permissions/privileges on schema
  • From: Ashesh Vashi
• Get the list of permissions/privileges on schema
  • From: dipti shah
• Re: Side effect of synchronous_commit = off
  • From: Guillaume Lelarge
• Re: Revoking CREATE TABLE
  • From: Adrian von Bidder
• Side effect of synchronous_commit = off
  • From: Yan Cheng CHEOK
• Re: find a string contained in an attribute
  • From: Pavel Stehule
• Re: Large index operation crashes postgres
  • From: Frans Hals
• Re: How to retrive List of Tables in a Database using...
  • From: John R Pierce
• Re: How to retrive List of Tables in a Database using...
  • From: Scott Mead
• Re: How to retrive List of Tables in a Database using...
  • From: John R Pierce
• Re: "\d pg_class" fails in PG 8.4
  • From: Tadipathri Raghu
• Re: How to retrive List of Tables in a Database using...
  • From: Tadipathri Raghu
• Re: "\d pg_class" fails in PG 8.4
  • From: Tom Lane
• How to retrive List of Tables in a Database using...
  • From: Yogi Yang 007
• "\d pg_class" fails in PG 8.4
  • From: Tadipathri Raghu
• boualem guechtouli
  • From: william wayne
• Re: data type to store a lot of text and tables of data
  • From: Raymond O'Donnell
• Re: data type to store a lot of text and tables of data
  • From: Karina Guardado
• Re: How to dump JUST procedures/funnctions?
  • From: Carlo Stonebanks
• Re: data type to store a lot of text and tables of data
  • From: Raymond O'Donnell
• Re: data type to store a lot of text and tables of data
  • From: Raymond O'Donnell
• Re: data type to store a lot of text and tables of data
  • From: Karina Guardado
• Re: data type to store a lot of text and tables of data
  • From: Raymond O'Donnell
• Re: data type to store a lot of text and tables of data
  • From: Szymon Guz
• data type to store a lot of text and tables of data
  • From: Karina Guardado
• Re: find a string contained in an attribute
  • From: Karina Guardado
• Re: find a string contained in an attribute
  • From: Szymon Guz
• find a string contained in an attribute
  • From: Karina Guardado
• Re: Large index operation crashes postgres
  • From: Paul Ramsey
• Re: Large index operation crashes postgres
  • From: Tom Lane
• Large index operation crashes postgres
  • From: Frans Hals
• Re: Fw: Clipping values
  • From: Ovid
• question (or feature-request): over ( partition by ... order by LIMIT N)
  • From: A. Kretschmer
• Re: Revoking CREATE TABLE
  • From: Tony Webb
• Re: Fw: Clipping values
  • From: Tom Lane
• Re: Revoking CREATE TABLE
  • From: Tom Lane
• Fw: Clipping values
  • From: Ovid
• Re: Revoking CREATE TABLE
  • From: Tony Webb
• Clipping values
  • From: Ovid
• Re: Revoking CREATE TABLE
  • From: Tom Lane
• Revoking CREATE TABLE
  • From: Tony Webb
• Re: Warm Standby Setup Documentation
  • From: Bryan Murphy
• Re: Out of Memory during Insert
  • From: Tom Lane
• Re: Concatenate [solved]
  • From: Frank jansen
• Re: Concatenate
  • From: Merlin Moncure
• Re: Concatenate
  • From: Albe Laurenz
• Re: Out of Memory during Insert
  • From: Thom Brown
• Out of Memory during Insert
  • From: yue peng
• Re: Help me with this multi-table query
  • From: Nilesh Govindarajan
• Concatenate
  • From: Frank jansen
• Re: PL/pgSQL & OVERLAPS operator (SOLVED!)
  • From: Tuo Pe
• Re: Help me with this multi-table query
  • From: Dean Rasheed
• Re: Help me with this multi-table query
  • From: Nilesh Govindarajan
• Re: Avoiding deadlocks on mass delete / update
  • From: Craig Ringer
• Re: server-side extension in c++
  • From: Craig Ringer
• Re: Help me with this multi-table query
  • From: Dean Rasheed
• Re: Fwd: Before triggers and usage in partitioned tables
  • From: Tom Lane
• [SPAM] Re: pgreplay log file replayer released
  • From: Ben Chobot
• Re: strange
  • From: Tom Lane
• Re: PL/pgSQL & OVERLAPS operator
  • From: Tom Lane
• 2nd set of PostgreSQL 9.0 Alpha4 RPMs are available
  • From: Devrim GÜNDÜZ
• Fwd: Before triggers and usage in partitioned tables
  • From: Sergio Ramazzina