Mailing lists [pgsql-sql]
- Statistics Hunter, Ray
- Re: Statistics Bruce Momjian
- Re: Statistics Hunter, Ray
- Re: Statistics Marin Dimitrov
- optimyzing Mathieu Arnold
- Sub-Select in CASE Brian C. Doyle
- selecting records from a date range Dan Langille
- Re: selecting records from a date range Tom Lane
- Re: selecting records from a date range Dan Langille
- Re: selecting records from a date range Tom Lane
- Re: About temporary table jack
- Database Locations Keith Gray
- Re: optimyzing Masaru Sugawara
- vacuum full fails: Parent tuple was not found[7.2] george young
- Re: Database Locations Peter Eisentraut
- Re: Database Locations Tom Lane
- Re: vacuum full fails: Parent tuple was not found[7.2] Tom Lane
- Re: resetting sequence David Stanaway
- Vacuumdb - the real advantages Jairo Tcatchenco
- procedure support in 7.2 Marie Tuite
- Re: Left outer join with WHERE clause? Dan Langille
- Upgrading PostgreSQL to 7.1.3 Gordon Clarke
- Re: procedure support in 7.2 Dan Langille
- Old message Dan Langille
- Re: Upgrading PostgreSQL to 7.1.3 Peter Eisentraut
- Update in trigger Iklódi Lajos
- Date cristi69
- bytea or large object Jean-Christophe FABRE
- Logging option Samuel J. Sutjiono
- Primary and foreign key from system tables Jan Oravec
- Re: [PHP] bytea or large object Joe Conway
- Re: Primary and foreign key from system tables Stephan Szabo
- Re: Update in trigger Jan Wieck
- Re: Logging option Bruce Momjian
- Re: [GENERAL] Logging option Samuel J. Sutjiono
- Re: [GENERAL] Logging option Bruce Momjian
- date manipulation Travis Hoyt
- Re: bytea or large object Timothy_maguire@hartehanks.com
- Named column in a Function fails at ORDER BY (PgSQL 7.1) Bernd von den Brincken
- FULL JOIN with 3 or more tables Michael Adler
- Re: date manipulation Ewald Geschwinde
- Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) Tom Lane
- Re: date manipulation Josh Berkus
- Re: Cleaning up template 1 -> template0 cloning Josh Berkus
- Re: Cleaning up template 1 -> template0 cloning Josh Berkus
- Re: Cleaning up template 1 -> template0 cloning Tom Lane
- Re: Update in trigger Iklódi Lajos
- Re: bytea or large object Frank Joerdens
- Re: bytea or large object Frank Joerdens
- 16 parameter limit John Proctor
- Date cristi
- Rvsd. / Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) Bernd von den Brincken
- Re: FULL JOIN with 3 or more tables Masaru Sugawara
- Re: Update in trigger Jan Wieck
- md5 auth Kovacs Zoltan
- Re: Date Jan Wieck
- Re: Rvsd. / Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) Tom Lane
- Re: md5 auth Tom Lane
- Rule trouble (looks to me exactly like the example) Frank Joerdens
- Re: 16 parameter limit Josh Berkus
- Re: Rule trouble (looks to me exactly like the example) Tom Lane
- Re: 16 parameter limit Bruce Momjian
- Re: Rule trouble (looks to me exactly like the example) Tom Lane
- Re: Rule trouble (looks to me exactly like the example) Frank Joerdens
- LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Magnus Enbom
- Re: FULL JOIN with 3 or more tables Michael Adler
- Re: Rule trouble (looks to me exactly like the example) Tom Lane
- Re: 16 parameter limit Josh Berkus
- Re: 16 parameter limit Josh Berkus
- Re: 16 parameter limit Tom Lane
- intersect performance (PG 7.1.3 vs 7.2) d_nardini@btconnect.com
- Re: 16 parameter limit Josh Berkus
- Re: 16 parameter limit Tom Lane
- Re: 16 parameter limit Josh Berkus
- Re: 16 parameter limit Tom Lane
- Re: intersect performance (PG 7.1.3 vs 7.2) Tom Lane
- Re: 16 parameter limit Josh Berkus
- Re: 16 parameter limit Barry Lind
- Re: intersect performance (PG 7.1.3 vs 7.2) d_nardini@btconnect.com
- Re: intersect performance (PG 7.1.3 vs 7.2) Tom Lane
- Re: Rule trouble (looks to me exactly like the example) Frank Joerdens
- JOINS and non use of indexes Ian Cass
- Re: JOINS and non use of indexes Ian Cass
- best method for select within all dimensions of an array Jaume Teixi
- 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 Ian Cass
- Re: JOINS and non use of indexes Tom Lane
- 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
- replace NULL Kancha .
- Re: replace NULL Andreas Joseph Krogh
- Hierarchical Queries Gautham S. Rao
- Re: Hierarchical Queries Christopher Kings-Lynne
- Re: Scadinavian characters in regular expressions Tom Lane
- Re: Scadinavian characters in regular expressions Søren Vainio
- Re: Hierarchical Queries Roberto Mello
- type conversion? Peter Atkins
- Re: type conversion? Jean-Luc Lachance
- Re: type conversion? Stephan Szabo
- Yes! Thank you! Michael Teter
- Is there any Faster workaround ?? Rajesh Kumar Mallah
- Help To Out Isaac Mesa Florez
- 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
- new problem! Is there any Faster workaround ?? Rajesh Kumar Mallah
- Re: Scadinavian characters in regular expressions Tatsuo Ishii
- Re: Help To Out Christopher Kings-Lynne
- Re: replace NULL Gaetano Mendola
- Postgresql goes into recovery mode .... Rajesh Kumar Mallah
- Re: replace NULL Torbjörn Andersson
- Re: new problem! Is there any Faster workaround ?? Jeff Eckermann
- Re: Postgresql goes into recovery mode .... Jeff Eckermann
- How to use an index on a bigint column Pierre-Andre Michel
- How to use an index on a bigint column Pierre-Andre Michel
- Re: Postgresql goes into recovery mode .... Jean-Luc Lachance
- Functions in Postgres gordoncl@optusnet.com.au
- Re: Functions in Postgres Peter Eisentraut
- crypt question (search mail list) Keith Gray
- Re: crypt question (search mail list) jeff fitzmyers
- Re: Postgresql goes into recovery mode .... Rajesh Kumar Mallah
- Re: new problem! Is there any Faster workaround ?? Rajesh Kumar Mallah
- Date format cristi69
- Re: Date format Tubagus Nizomi
- REPOST: Trouble with SQL conversion Richard Ellerbrock
- Problem With A Rule
- Transactional vs. Read-only (Retrieval) database Samuel J. Sutjiono
- Re: REPOST: Trouble with SQL conversion Christopher Kings-Lynne
- using output of a subselect in LIKE/ILIKE Rajesh Kumar Mallah
- Re: REPOST: Trouble with SQL conversion Richard Ellerbrock
- Re: Postgresql goes into recovery mode .... Jeff Eckermann
- Re: using output of a subselect in LIKE/ILIKE Jeff Eckermann
- Re: Problem With A Rule Tom Lane
- Re: using output of a subselect in LIKE/ILIKE Rajesh Kumar Mallah
- 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
- Inserting values into numeric fields Eric Carpenter
- Re: Transactional vs. Read-only (Retrieval) database Josh Berkus
- Re: Inserting values into numeric fields Jason Earl
- how to get more detailed error messages? Markus Wagner
- Problem With A Rule (clear version)
- Re: Transactional vs. Read-only (Retrieval) database Samuel J. Sutjiono
- PL/PGSQL question on transactions Dan Schwitalla
- Re: PL/PGSQL question on transactions Christopher Kings-Lynne
- Re: Functions in Postgres Peter Eisentraut
- Re: PL/PGSQL question on transactions Jie Liang
- Re: Functions in Postgres Tom Lane
- Re: Transactional vs. Read-only (Retrieval) database Josh Berkus
- Re: Problem With A Rule (clear version) Tom Lane
- Re: how to get more detailed error messages? Tom Lane
- Re: Functions in Postgres Jan Wieck
- Re: Functions in Postgres Jan Wieck
- Re: how to get more detailed error messages? Josh Berkus
- Re: Functions in Postgres Tom Lane
- Proposal: New Mailing List Josh Berkus
- Re: Functions in Postgres Jan Wieck
- Re: Functions in Postgres Tom Lane
- Re: Functions in Postgres Jan Wieck
- Re: Problem With A Rule (clear version)
- Re: Proposal: New Mailing List Rajesh Kumar Mallah
- deletions on master table takes for ever... Rajesh Kumar Mallah
- Re: deletions on master table takes for ever... Stephan Szabo
- to_char problem postgresql
- Re: to_char problem Tom Lane
- data order problem jack
- Re: data order problem Josh Berkus
- Re: data order problem Tom Lane
- Re: data order problem jack
- case statement in group by clause Dorian Taylor
- Re: How slow is DISTINCT? Michael Contzen
- How to use an index on a bigint column Pierre-Andre Michel
- Optimizer for IN (..) ? / Re: Thank you ! Re: Is there any Faster workaround ?? Bernd von den Brincken
- oid and oidvector Camila Rocha
- Re: [GENERAL] Transactional vs. Read-only (Retrieval) database Jean-Michel POURE
- Re: Functions in Postgres Gordon Clarke
- Re: [GENERAL] how to get more detailed error messages? Richard Emberson
- Date format cristi
- How to get more detailed error messages? Markus Wagner
- Re: case statement in group by clause Tom Lane
- Re: How slow is DISTINCT? Tom Lane
- Re: Thank you ! Re: Is there any Faster workaround ?? Roberto Mello
- Re: data order problem Josh Berkus
- Large or Small tables? Edipo Elder Fernandes de Melo
- Re: data order problem Stephan Szabo
- Re: oid and oidvector Bruce Momjian
- MAX(column1),MAX(column2),... Bjarte Aagnes
- Re: MAX(column1),MAX(column2),... Josh Berkus
- Re: MAX(column1),MAX(column2),... Travis Hoyt
- Re: oid and oidvector Tom Lane
- Re: oid and oidvector Bruce Momjian
- Re: oid and oidvector Tom Lane
- please advise on column data type jack
- Re: How slow is DISTINCT? Christopher Kings-Lynne
- Re: please advise on column data type Josh Berkus
- Re: please advise on column data type Tom Lane
- help - JOIN problem chief_87@yahoo.com (KeithR)
- Re: help - JOIN problem Josh Berkus
- My is degraded after two weeks Fernando Carvalho
- Need some help with dates Stéphane DEWITTE
- Re: Need some help with dates Gautham S. Rao
- How to reset sequences on pre-7.1 Matteo Beccati
- Need some help in dates Stéphane DEWITTE
- 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 Miguel Carvalho
- Re: How to reset sequences on pre-7.1 Tom Lane
- Re: Need some help with dates Josh Berkus
- Help with conversions (suite) Stéphane DEWITTE
- Re: My is degraded after two weeks Stephan Szabo
- Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian
- Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian
- now() does not change within a transaction Christoph Haller
- Migrating Oracle to PostgreSQL Makarov Gera x8521
- SQL Query Optimization Dav Coleman
- fredrik.samuelsson@ey.se
- Re: now() does not change within a transaction Karel Zak
- Re: Migrating Oracle to PostgreSQL Karel Zak
- DISTINCT ON ... without distinct null values ? Albrecht Berger
- Re: SQL Query Optimization Josh Berkus
- Re: now() does not change within a transaction Bruce Momjian
- Re: SQL Query Optimization Tom Lane
- Re: [GENERAL] Migrating Oracle to PostgreSQL Leif Jensen
- Re: SQL Query Optimization Dav Coleman
- Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck
- Re: SQL Holiday Calculations Josh Berkus
- Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian
- Re: SQL Query Optimization Josh Berkus
- Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck
- Re: DISTINCT ON ... without distinct null values ? Fduch the Pravking
- Re: [DOCS] [GENERAL] Migrating Oracle to PostgreSQL Roberto Mello
- count different values in column Albrecht Berger
- Re: count different values in column Tod McQuillin
- Re: count different values in column Gautham S. Rao
- Re: count different values in column Christoph Haller
- Re: count different values in column Fduch the Pravking
- how to get index scan at work? Rajesh Kumar Mallah
- Re: how to get index scan at work? Thomas Swan
- Re: call the same pl/pgsql procedure twice in the same connection Richard Huxton
- Re: SQL Query Optimization Richard Huxton
- count different values in column? Thorsten Wenzlaff
- How to log outputs from pl/pgsql into a file ? Stéphane DEWITTE
- Re: how to get index scan at work? Rajesh Kumar Mallah
- Re: how to get index scan at work? Stephan Szabo
- Re: How to log outputs from pl/pgsql into a file ? Jie Liang
- Query Praise! Matthew Hagerty
- Re: count different values in column? Rajesh Kumar Mallah
- OpenFTS/tsearch and Postgresql 7.2.1 Rajesh Kumar Mallah
- Trying to get query to work Brian Kosick
- Trying to get query to work. Brian Kosick
- accept AD35- 6FA9 -9515 tulasi
- postgresql query to XML result Rishabh Gupta
- Re: accept AD35- 6FA9 -9515 Peter Eisentraut
- Re: [OpenFTS-general] OpenFTS/tsearch and Postgresql 7.2.1 Oleg Bartunov
- Re: Trying to get query to work Stephan Szabo
- Is this a BUG? Is there anyone has the same problem? jack
- Re: accept AD35- 6FA9 -9515 postgresql
- Re: Is this a BUG? Is there anyone has the same problem? Tom Lane
- 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
- 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
- efficient query help Laurette Cisneros
- Re: efficient query help Clinton Adams
- How to discover foreign keys (without pulling hair out) Ian Morgan
- Cannot get to use index scan on a big table! Rajesh Kumar Mallah
- Date indexing Ian Cass
- Re: Date indexing Tom Lane
- Re: Date indexing Ian Cass
- Re: Date indexing Ian Cass
- Re: Cannot get to use index scan on a big table! Stephan Szabo
- calling a pl/pgsql function with array in argument Ruben Vivas
- Re: Is this a BUG? Is there anyone has the same problem? Tom Lane
- 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: Upgrading PostgreSQL to 7.1.3 Rajesh Kumar Mallah
- Re: Cannot get to use index scan on a big table! Rajesh Kumar Mallah
- BLOB Feature Limits Bullock, Dempsey
- Re: efficient query help Joel Burton
- Re: efficient query help Joel Burton
- Re: BLOB Feature Limits Ian Morgan
- Connection authentication Oleg Lebedev
- Pl/pgSQL Question. Bruno Ricardo Sacco
- SELECT in a function != SELECT ? Ian Morgan
- Re: SELECT in a function != SELECT ? Joe Conway
- 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
- HAVING - clause Morten Sickel
- Proper quoting of \e ? Helge Kreutzmann
- Re: HAVING - clause Christoph Haller
- Re: How to discover foreign keys (without pulling hair out) bob lapique
- Again: Identity not discovered by planner? Daniel Lundin
- Proper quoting of \e Helge Kreutzmann
- Pl/pgSQL Question. Bruno Ricardo Sacco
- Re: SELECT in a function != SELECT ? Jan Wieck
- Re: Database Server in Recovery mode! Stephan Szabo
- Re: Connection authentication Bruce Momjian
- Re: Proper quoting of \e ? Bruce Momjian
- Re: Proper quoting of \e ? Helge Kreutzmann
- Re: Proper quoting of \e ? Joe Conway
- Re: SELECT in a function != SELECT ? David Stanaway
- Re: Again: Identity not discovered by planner? Tom Lane
- Re: How to discover foreign keys (without pulling hair out) Ian Morgan
- copy command Duncan Adams (DNS)
- Re: copy command ARP
- Re: HAVING - clause Bill Cunningham
- Re: copy command svilen@iname.com
- Re: Database Server in Recovery mode! Rajesh Kumar Mallah
- Use of indexes Andre Schubert
- Re: Use of indexes Christopher Kings-Lynne
- Collection of PostgreSQL Performance Tips Brubaker, Shane
- abnormal size of the on-disk file. Rajesh Kumar Mallah
- view on system tables upgrade? Christoph Haller
- Wierd error for COPY command Josh Berkus
- How do I create unique IDs for an existing set of records Nick Fankhauser
- Re: view on system tables upgrade? Tom Lane
- Re: Wierd error for COPY command Tom Lane
- 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
- Re: Wierd error for COPY command Josh Berkus
- Re: Wierd error for COPY command Josh Berkus
- Re: Wierd error for COPY command PG Explorer
- union query format Robert Wynter
- Re: Connection authentication Oleg Lebedev
- Wierd query behaviour Josh Berkus
- Re: union query format Josh Berkus
- Re: Connection authentication Ron Peterson
- Trying to purchase an annual subscription to the CD distribution Wayne Seward
- Re: union query format Joel Burton
- Function won't complete Josh Berkus
- Re: Wierd query behaviour Tom Lane
- Re: Function won't complete Tom Lane
- pg_shadow password Eduardo Gargiulo
- Re: pg_shadow password Bruce Momjian
- Re: Function won't complete Josh Berkus
- Re: Function won't complete Tom Lane
- Re: Function won't complete Josh Berkus
- Casting dates Joseph Barillari
- IN, EXISTS or ANY? Josh Berkus
- Re: IN, EXISTS or ANY? Tom Lane
- Re: IN, EXISTS or ANY? Josh Berkus
- Temporary table weirdness Joseph Barillari
- view on system tables upgrade II Christoph Haller
- Trying to purchase an annual subscription to the CD distribution Wayne Seward
- Re: Upgrading PostgreSQL to 7.1.3 Gordon Clarke
- Re: Upgrading PostgreSQL to 7.1.3 Gordon Clarke
- Re: view on system tables upgrade II Tom Lane
- Re: Temporary table weirdness Bruce Momjian
- Re: Temporary table weirdness Tom Lane
- Re: Casting dates Josh Berkus
- Re: Temporary table weirdness Joseph Barillari
- Re: Casting dates Joseph Barillari
- Re: abnormal size of the on-disk file. Stephan Szabo
- convert from sybase to postgresql Frank Morton
- join-performance problem Wolfgang.Fuertbauer@ebewe.com
- Re: join-performance problem Stephan Szabo
- Re: join-performance problem 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
- Re: Out of free buffers... HELP! Tom Lane