db.postgresql.sql (thread)

Re: Out of free buffers... HELP!, Tom Lane
performance on update table from a join, Jean-Luc Lachance
- Re: performance on update table from a join, Tom Lane
  - Re: performance on update table from a join, Jean-Luc Lachance
    - Re: performance on update table from a join, Tom Lane
    - Re: performance on update table from a join, Jean-Luc Lachance
join-performance problem, Wolfgang . Fuertbauer
- Re: join-performance problem, Stephan Szabo
- Re: join-performance problem, Tom Lane
Temporary table weirdness, Joseph Barillari
- Re: Temporary table weirdness, Bruce Momjian
- Re: Temporary table weirdness, Tom Lane
  - Re: Temporary table weirdness, Joseph Barillari
IN, EXISTS or ANY?, Josh Berkus
- Re: IN, EXISTS or ANY?, Tom Lane
  - Re: IN, EXISTS or ANY?, Josh Berkus
Casting dates, Joseph Barillari
- Re: Casting dates, Josh Berkus
  - Re: Casting dates, Joseph Barillari
pg_shadow password, Eduardo Gargiulo
- Re: pg_shadow password, Bruce Momjian
Function won't complete, Josh Berkus
- Re: Function won't complete, Tom Lane
- Re: Function won't complete, Josh Berkus
  - Re: Function won't complete, Tom Lane
    - Re: Function won't complete, Josh Berkus
  - convert from sybase to postgresql, Frank Morton
Trying to purchase an annual subscription to the CD distribution, Wayne Seward
Wierd query behaviour, Josh Berkus
- Re: Wierd query behaviour, Tom Lane
union query format, Robert Wynter
- Re: union query format, Joel Burton
- Re: union query format, Josh Berkus
How do I create unique IDs for an existing set of records, Nick Fankhauser
- Re: How do I create unique IDs for an existing set of records, Tom Lane
  - Re: How do I create unique IDs for an existing set of records, Nick Fankhauser
Wierd error for COPY command, Josh Berkus
- Re: Wierd error for COPY command, Tom Lane
  - Re: Wierd error for COPY command, Josh Berkus
    - Re: Wierd error for COPY command, Josh Berkus
    - Re: Wierd error for COPY command, PG Explorer
view on system tables upgrade?, Christoph Haller
- Re: view on system tables upgrade?, Tom Lane
  - view on system tables upgrade II, Christoph Haller
    - Re: view on system tables upgrade II, Tom Lane
abnormal size of the on-disk file., Rajesh Kumar Mallah
- Re: abnormal size of the on-disk file., Stephan Szabo
Collection of PostgreSQL Performance Tips, Brubaker, Shane
Use of indexes, Andre Schubert
- Re: Use of indexes, Christopher Kings-Lynne
copy command, Duncan Adams (DNS)
- Re: copy command, ARP
- Re: copy command, svilen
Proper quoting of \e, Helge Kreutzmann
Again: Identity not discovered by planner?, Daniel Lundin
- Re: Again: Identity not discovered by planner?, Tom Lane
Proper quoting of \e ?, Helge Kreutzmann
- Re: Proper quoting of \e ?, Bruce Momjian
  - Re: Proper quoting of \e ?, Helge Kreutzmann
    - Re: Proper quoting of \e ?, Joe Conway
HAVING - clause, Morten Sickel
- Re: HAVING - clause, Christoph Haller
  - Re: HAVING - clause, Bill Cunningham
Database Server in Recovery mode!, Rajesh Kumar Mallah
- followups : Database Server in Recovery mode!, Rajesh Kumar Mallah
- Re: Database Server in Recovery mode!, Rajesh Kumar Mallah
  - Re: Database Server in Recovery mode!, Stephan Szabo
    - Re: Database Server in Recovery mode!, Rajesh Kumar Mallah
Pl/pgSQL Question., Bruno Ricardo Sacco
- SELECT in a function != SELECT ?, Ian Morgan
  - Re: SELECT in a function != SELECT ?, Joe Conway
    - Re: SELECT in a function != SELECT ?, Jan Wieck
    - Re: SELECT in a function != SELECT ?, David Stanaway
- Pl/pgSQL Question., Bruno Ricardo Sacco
Connection authentication, Oleg Lebedev
- Re: Connection authentication, Bruce Momjian
  - Re: Connection authentication, Oleg Lebedev
    - Re: Connection authentication, Ron Peterson
BLOB Feature Limits, Bullock, Dempsey
- Re: BLOB Feature Limits, Ian Morgan
Re: Upgrading PostgreSQL to 7.1.3, Rajesh Kumar Mallah
- Re: Upgrading PostgreSQL to 7.1.3, Gordon Clarke
- Re: Upgrading PostgreSQL to 7.1.3, Gordon Clarke
calling a pl/pgsql function with array in argument, Ruben Vivas
Date indexing, Ian Cass
- Re: Date indexing, Tom Lane
  - Re: Date indexing, Ian Cass
- Message not available
  - Re: Date indexing, Ian Cass
Cannot get to use index scan on a big table!, Rajesh Kumar Mallah
- Re: Cannot get to use index scan on a big table!, Stephan Szabo
  - Re: Cannot get to use index scan on a big table!, Rajesh Kumar Mallah
How to discover foreign keys (without pulling hair out), Ian Morgan
- Re: How to discover foreign keys (without pulling hair out), bob lapique
  - Re: How to discover foreign keys (without pulling hair out), Ian Morgan
efficient query help, Laurette Cisneros
- Re: efficient query help, Clinton Adams
- Re: efficient query help, Joel Burton
  - Re: efficient query help, Joel Burton
Identity not disvoered by planner?, Daniel Lundin
Is this a BUG? Is there anyone has the same problem?, jack
- Re: Is this a BUG? Is there anyone has the same problem?, Tom Lane
  - Is this a BUG? Is there anyone has the same problem?, jack
    - Re: Is this a BUG? Is there anyone has the same problem?, Tom Lane
    - Re: Is this a BUG? Is there anyone has the same problem?, David Stanaway
    - Re: Is this a BUG? Is there anyone has the same problem?, Tom Lane
    - Re: Is this a BUG? Is there anyone has the same problem?, Tom Lane
postgresql query to XML result, Rishabh Gupta
accept AD35- 6FA9 -9515, tulasi
- Re: accept AD35- 6FA9 -9515, Peter Eisentraut
- Re: accept AD35- 6FA9 -9515, postgresql
Trying to get query to work., Brian Kosick
Trying to get query to work, Brian Kosick
- Re: Trying to get query to work, Stephan Szabo
OpenFTS/tsearch and Postgresql 7.2.1, Rajesh Kumar Mallah
- Re: [OpenFTS-general] OpenFTS/tsearch and Postgresql 7.2.1, Oleg Bartunov
Query Praise!, Matthew Hagerty
How to log outputs from pl/pgsql into a file ?, Stéphane DEWITTE
- Re: How to log outputs from pl/pgsql into a file ?, Jie Liang
count different values in column?, Thorsten Wenzlaff
- Re: count different values in column?, Rajesh Kumar Mallah
how to get index scan at work?, Rajesh Kumar Mallah
- Re: how to get index scan at work?, Thomas Swan
  - Re: how to get index scan at work?, Rajesh Kumar Mallah
    - Re: how to get index scan at work?, Stephan Szabo
count different values in column, Albrecht Berger
- Re: count different values in column, Tod McQuillin
  - Re: count different values in column, Fduch the Pravking
- Re: count different values in column, Gautham S. Rao
- Re: count different values in column, Christoph Haller
Re: [DOCS] [GENERAL] Migrating Oracle to PostgreSQL, Roberto Mello
Re: SQL Holiday Calculations, Josh Berkus
Re: [GENERAL] Migrating Oracle to PostgreSQL, Leif Jensen
DISTINCT ON ... without distinct null values ?, Albrecht Berger
- Re: DISTINCT ON ... without distinct null values ?, Fduch the Pravking
Migrating Oracle to PostgreSQL, Makarov Gera x8521
- Re: Migrating Oracle to PostgreSQL, Karel Zak
(unknown), fredrik . samuelsson
SQL Query Optimization, Dav Coleman
- Re: SQL Query Optimization, Josh Berkus
  - Re: SQL Query Optimization, Tom Lane
  - Re: SQL Query Optimization, Dav Coleman
    - Re: SQL Query Optimization, Josh Berkus
    - Re: SQL Query Optimization, Richard Huxton
now() does not change within a transaction, Christoph Haller
- Re: now() does not change within a transaction, Karel Zak
- Re: now() does not change within a transaction, Bruce Momjian
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?, Bruce Momjian
Re: call the same pl/pgsql procedure twice in the same connection, Bruce Momjian
- Re: call the same pl/pgsql procedure twice in the same connection, Jan Wieck
  - Re: call the same pl/pgsql procedure twice in the same connection, Bruce Momjian
    - Re: call the same pl/pgsql procedure twice in the same connection, Jan Wieck
    - Re: call the same pl/pgsql procedure twice in the same connection, Bruce Momjian
    - Re: call the same pl/pgsql procedure twice in the same connection, Jan Wieck
    - Re: call the same pl/pgsql procedure twice in the same connection, Bruce Momjian
  - Re: call the same pl/pgsql procedure twice in the same connection, Richard Huxton
Help with conversions (suite), Stéphane DEWITTE
Need some help in dates, Stéphane DEWITTE
How to reset sequences on pre-7.1, Matteo Beccati
- Re: How to reset sequences on pre-7.1, Tom Lane
Need some help with dates, Stéphane DEWITTE
- Re: Need some help with dates, Gautham S. Rao
  - Re: Need some help with dates, Stéphane DEWITTE
    - Re: Need some help with dates, Gautham S. Rao
    - Re: Need some help with dates, Stéphane DEWITTE
    - Re: Need some help with dates, Josh Berkus
- Re: Need some help with dates, Miguel Carvalho
My is degraded after two weeks, Fernando Carvalho
- Re: My is degraded after two weeks, Stephan Szabo
help - JOIN problem, KeithR
- Re: help - JOIN problem, Josh Berkus
please advise on column data type, jack
- Re: please advise on column data type, Josh Berkus
  - Re: please advise on column data type, Tom Lane
Large or Small tables?, Edipo Elder Fernandes de Melo
Date format, cristi
Re: Functions in Postgres, Gordon Clarke
- Re: Functions in Postgres, Peter Eisentraut
  - Re: Functions in Postgres, Tom Lane
    - Re: Functions in Postgres, Jan Wieck
    - Re: Functions in Postgres, Tom Lane
    - Re: Functions in Postgres, Jan Wieck
    - Re: Functions in Postgres, Tom Lane
    - Re: Functions in Postgres, Jan Wieck
  - Re: Functions in Postgres, Jan Wieck
oid and oidvector, Camila Rocha
- Re: oid and oidvector, Bruce Momjian
  - Re: oid and oidvector, Tom Lane
    - Re: oid and oidvector, Bruce Momjian
    - Re: oid and oidvector, Tom Lane
Re: How slow is DISTINCT?, Michael Contzen
- Re: How slow is DISTINCT?, Tom Lane
- Re: How slow is DISTINCT?, Christopher Kings-Lynne
case statement in group by clause, Dorian Taylor
- Re: case statement in group by clause, Tom Lane
data order problem, jack
- Re: data order problem, Josh Berkus
  - Re: data order problem, Tom Lane
  - Re: data order problem, jack
    - Re: data order problem, Josh Berkus
    - MAX(column1),MAX(column2),..., Bjarte Aagnes
    - Re: MAX(column1),MAX(column2),..., Josh Berkus
    - Re: MAX(column1),MAX(column2),..., Travis Hoyt
    - Re: data order problem, Stephan Szabo
to_char problem, postgresql
- Re: to_char problem, Tom Lane
deletions on master table takes for ever..., Rajesh Kumar Mallah
- Re: deletions on master table takes for ever..., Stephan Szabo
Proposal: New Mailing List, Josh Berkus
- Re: Proposal: New Mailing List, Rajesh Kumar Mallah
PL/PGSQL question on transactions, Dan Schwitalla
- Re: PL/PGSQL question on transactions, Christopher Kings-Lynne
- Re: PL/PGSQL question on transactions, Jie Liang
Problem With A Rule (clear version), cnliou
- Re: Problem With A Rule (clear version), Tom Lane
- Re: Problem With A Rule (clear version), cnliou
how to get more detailed error messages?, Markus Wagner
- Re: how to get more detailed error messages?, Tom Lane
  - Re: how to get more detailed error messages?, Josh Berkus
  - Re: [GENERAL] how to get more detailed error messages?, Richard Emberson
- How to get more detailed error messages?, Markus Wagner
using output of a subselect in LIKE/ILIKE, Rajesh Kumar Mallah
- Re: using output of a subselect in LIKE/ILIKE, Jeff Eckermann
  - Re: using output of a subselect in LIKE/ILIKE, Rajesh Kumar Mallah
Transactional vs. Read-only (Retrieval) database, Samuel J. Sutjiono
- Re: Transactional vs. Read-only (Retrieval) database, Josh Berkus
  - Re: Transactional vs. Read-only (Retrieval) database, Samuel J. Sutjiono
    - Re: Transactional vs. Read-only (Retrieval) database, Josh Berkus
- Re: [GENERAL] Transactional vs. Read-only (Retrieval) database, Jean-Michel POURE
Problem With A Rule, cnliou
- Re: Problem With A Rule, Tom Lane
- Inserting values into numeric fields, Eric Carpenter
  - Re: Inserting values into numeric fields, Jason Earl
REPOST: Trouble with SQL conversion, Richard Ellerbrock
- Re: REPOST: Trouble with SQL conversion, Christopher Kings-Lynne
- Re: REPOST: Trouble with SQL conversion, Richard Ellerbrock
- Re: REPOST: Trouble with SQL conversion, Christopher Kings-Lynne
- Re: REPOST: Trouble with SQL conversion, Richard Ellerbrock
- Re: REPOST: Trouble with SQL conversion, Richard Ellerbrock
How to use an index on a bigint column, Pierre-Andre Michel
- How to use an index on a bigint column, Pierre-Andre Michel
- How to use an index on a bigint column, Pierre-Andre Michel
Postgresql goes into recovery mode ...., Rajesh Kumar Mallah
- Re: Postgresql goes into recovery mode ...., Jeff Eckermann
  - Re: Postgresql goes into recovery mode ...., Jean-Luc Lachance
- Re: Postgresql goes into recovery mode ...., Jeff Eckermann
Help To Out, Isaac Mesa Florez
- Re: Help To Out, Christopher Kings-Lynne
Is there any Faster workaround ??, Rajesh Kumar Mallah
- Re: Is there any Faster workaround ??, David Stanaway
- Re: Is there any Faster workaround ??, Jean-Luc Lachance
  - Thank you ! Re: Is there any Faster workaround ??, Rajesh Kumar Mallah
    - Optimizer for IN (..) ? / Re: Thank you ! Re: Is there any Faster workaround ??, Bernd von den Brincken
    - Re: Thank you ! Re: Is there any Faster workaround ??, Roberto Mello
- new problem! Is there any Faster workaround ??, Rajesh Kumar Mallah
  - Re: new problem! Is there any Faster workaround ??, Jeff Eckermann
Yes! Thank you!, Michael Teter
type conversion?, Peter Atkins
- Re: type conversion?, Stephan Szabo
- Re: type conversion?, Jean-Luc Lachance
Hierarchical Queries, Gautham S. Rao
- Re: Hierarchical Queries, Christopher Kings-Lynne
- Re: Hierarchical Queries, Roberto Mello
replace NULL, Kancha .
- Re: replace NULL, Andreas Joseph Krogh
- Re: replace NULL, Gaetano Mendola
  - Re: replace NULL, Torbjörn Andersson
Scadinavian characters in regular expressions, Søren Vainio
- Re: Scadinavian characters in regular expressions, Andreas Joseph Krogh
- Re: Scadinavian characters in regular expressions, Søren Vainio
  - Re: Scadinavian characters in regular expressions, Andreas Joseph Krogh
  - Re: Scadinavian characters in regular expressions, Tom Lane
- Re: Scadinavian characters in regular expressions, Søren Vainio
  - Re: Scadinavian characters in regular expressions, Tatsuo Ishii
best method for select within all dimensions of an array, Jaume Teixi
JOINS and non use of indexes, Ian Cass
- Re: JOINS and non use of indexes, Ian Cass
- Re: JOINS and non use of indexes, Christopher Kings-Lynne
  - Re: JOINS and non use of indexes, Ian Cass
- Re: JOINS and non use of indexes, Tom Lane
  - Re: JOINS and non use of indexes, Ian Cass
    - Re: JOINS and non use of indexes, Tom Lane
  - Re: JOINS and non use of indexes, Ian Cass
Re: Rule trouble (looks to me exactly like the example), Frank Joerdens
Re: [SQL] intersect performance (PG 7.1.3 vs 7.2), Tom Lane