pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPinning a table into memory
2002-10-04 16:46 UTC David Blood <david@matraex.com>
` Re: Pinning a table into memory
2002-10-04 18:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Pinning a table into memory
2002-10-08 13:32 UTC Jan Wieck <JanWieck@Yahoo.com>
[3+ messages in thread]
Probs "compiling" a function
2002-10-08 02:14 UTC gordoncl@optusnet.com.au
` Re: Probs "compiling" a function
2002-10-08 08:32 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
Debug information
2002-10-07 23:01 UTC Rafal Kedziorski <rafcio@polonium.de>
Get A Tree from a table
2002-10-06 05:37 UTC Scott Yaung <gzscott2001@yahoo.ca>
` Re: Get A Tree from a table
2002-10-07 16:40 UTC Josh Berkus <josh@agliodbs.com>
` Re: Get A Tree from a table
2002-10-07 16:54 UTC Joe Conway <mail@joeconway.com>
[3+ messages in thread]
enforcing with unique indexes..
2002-10-05 06:49 UTC Rajesh Kumar Mallah. <mallah@trade-india.com>
` Re: enforcing with unique indexes..
2002-10-05 07:18 UTC Rajesh Kumar Mallah. <mallah@trade-india.com>
` Re: enforcing with unique indexes..
2002-10-05 14:13 UTC dev@archonet.com
` Re: enforcing with unique indexes..
2002-10-07 15:55 UTC Jean-Luc Lachance <jllachan@nsd.ca>
[4+ messages in thread]
Need some SQL help
2002-10-06 15:41 UTC Brian Ward <brian0@verizon.net>
` Re: Need some SQL help
2002-10-07 12:27 UTC Dan Langille <dan@langille.org>
[2+ messages in thread]
How slow is distinct - 2nd
2002-10-01 12:18 UTC Michael Contzen <Michael.Contzen@dohle.com>
` Re: How slow is distinct - 2nd
2002-10-04 14:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How slow is distinct - 2nd
2002-10-04 15:31 UTC Bruno Wolff III <bruno@wolff.to>
` Re: How slow is distinct - 2nd
2002-10-07 12:21 UTC Michael Contzen <mcontzen@dohle.com>
[4+ messages in thread]
Re: [HACKERS] cross-posts (was Re: Large databases,
2002-10-07 11:50 UTC Larry Rosenman <ler@lerctr.org>
` Re: [HACKERS] cross-posts (was Re: Large databases,
2002-10-07 12:01 UTC Michael Paesold <mpaesold@gmx.at>
` Re: [HACKERS] cross-posts (was Re: Large databases,
2002-10-07 12:04 UTC Larry Rosenman <ler@lerctr.org>
[3+ messages in thread]
cross-posts (was Re: Large databases, performance)
2002-10-07 03:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
Suggestion: md5/crypt functions in sql
2002-10-06 15:57 UTC Aasmund Midttun Godal <postgresql@aasmund.com>
` Re: Suggestion: md5/crypt functions in sql
2002-10-06 16:26 UTC Joe Conway <mail@joeconway.com>
` Re: Suggestion: md5/crypt functions in sql
2002-10-06 22:51 UTC Dan Langille <dan@langille.org>
[3+ messages in thread]
problem with subqueries
2002-10-05 22:19 UTC pete@phillipsfamily.freeserve.co.uk
` Re: problem with subqueries
2002-10-06 01:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem with subqueries
2002-10-06 01:02 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: problem with subqueries
2002-10-06 11:13 UTC pete@phillipsfamily.freeserve.co.uk
` Re: problem with subqueries
2002-10-06 16:18 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
[5+ messages in thread]
sum-function
1999-10-22 23:34 UTC Christian Guenther <guenther@laokoon.IN-Berlin.DE>
` Re: [SQL] sum-function
1999-10-23 04:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] sum-function
1999-10-23 16:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` sum function
2002-10-04 21:01 UTC Dagoberto Torres <francisco99@codetel.net.do>
[4+ messages in thread]
arrays
1998-09-22 23:40 UTC Brook Milligan <brook@trillium.NMSU.Edu>
` arrays
1999-12-01 22:34 UTC Marcin Mazurek - Multinet SA - Poznan <m.mazurek@multinet.pl>
` Re: [SQL] arrays
1999-12-02 10:20 UTC Karel Zak - Zakkr <zakkr@zf.jcu.cz>
` Re: [SQL] arrays
1999-12-02 11:01 UTC Marcin Mazurek - Multinet SA - Poznan <m.mazurek@multinet.pl>
` Re: [SQL] arrays
1999-12-02 11:11 UTC Karel Zak - Zakkr <zakkr@zf.jcu.cz>
` Re: [SQL] arrays
1999-12-04 02:23 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: [SQL] arrays
1999-12-04 09:31 UTC Stephen Davies <scldad@sdc.com.au>
` Re: [SQL] arrays
1999-12-04 14:02 UTC John M. Flinchbaugh <glynis@butterfly.hjsoft.com>
` Re: [SQL] arrays
1999-12-04 15:05 UTC neko@kredit.sth.szif.hu
` Re: [SQL] arrays
1999-12-04 17:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] arrays
1999-12-04 19:45 UTC kaiq@realtyideas.com
` Arrays
2000-12-31 21:29 UTC Albert REINER <areiner@tph.tuwien.ac.at>
` Re: Arrays
2000-12-31 22:28 UTC Oleg Bartunov <oleg@sai.msu.su>
` Arrays
2001-01-11 18:06 UTC Sharmad Naik <sharmad@im.eth.net>
` Re: [SQL] arrays
2002-09-30 00:12 UTC Mike Sosteric <mikes@athabascau.ca>
` Re: [SQL] arrays
2002-09-30 12:29 UTC Bruno Wolff III <bruno@wolff.to>
` Re: [SQL] arrays
2002-09-30 12:38 UTC Mike Sosteric <mikes@athabascau.ca>
` Re: [SQL] arrays
2002-09-30 13:18 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] arrays
2002-09-30 13:57 UTC Bruno Wolff III <bruno@wolff.to>
` Re: [SQL] arrays
2002-09-30 14:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] arrays
2002-09-30 15:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] arrays
2002-09-30 15:59 UTC Dan Langille <dan@langille.org>
` Re: [GENERAL] arrays
2002-09-30 16:09 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] arrays
2002-09-30 16:10 UTC Dan Langille <dan@langille.org>
` Re: [GENERAL] arrays
2002-09-30 16:30 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] arrays
2002-09-30 17:04 UTC Mike Sosteric <mikes@athabascau.ca>
` Re: [GENERAL] arrays
2002-09-30 17:18 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] arrays
2002-09-30 17:24 UTC Mike Sosteric <mikes@athabascau.ca>
` Re: [GENERAL] arrays
2002-09-30 17:29 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] arrays
2002-09-30 18:11 UTC Mike Sosteric <mikes@athabascau.ca>
` Re: [GENERAL] arrays
2002-09-30 18:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] arrays
2002-09-30 18:24 UTC Mike Sosteric <mikes@athabascau.ca>
` Re: [SQL] arrays
2002-10-01 07:49 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [GENERAL] arrays
2002-10-01 17:43 UTC Roland Roberts <roland@astrofoto.org>
` Re: [SQL] arrays
2002-10-01 17:52 UTC Josh Berkus <josh@agliodbs.com>
` Re: [SQL] arrays
2002-10-04 16:08 UTC scott.marlowe <scott.marlowe@ihs.com>
[36+ messages in thread]
rows in order
2002-09-30 18:29 UTC Camila Rocha <camilarrocha@hotmail.com>
` Re: rows in order
2002-10-04 13:36 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: rows in order
2002-10-04 13:37 UTC Richard Huxton <dev@archonet.com>
` Re: rows in order
2002-10-04 15:05 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: rows in order
2002-10-04 15:51 UTC Joe Conway <mail@joeconway.com>
[5+ messages in thread]
Can Postgres cache a table in memory?
2002-10-03 14:03 UTC Kevin Traub <ktraub@verizon.net>
` Re: Can Postgres cache a table in memory?
2002-10-04 13:14 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: Can Postgres cache a table in memory?
2002-10-04 13:35 UTC Richard Huxton <dev@archonet.com>
` Re: Can Postgres cache a table in memory?
2002-10-04 14:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Can Postgres cache a table in memory?
2002-10-04 15:34 UTC Josh Berkus <josh@agliodbs.com>
[5+ messages in thread]
Rule creation
2002-10-03 19:34 UTC Edoardo Causarano <curious.dot.corn.at.katamail.dot.com@postgresql.org>
` Re: Rule creation
2002-10-04 14:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
please help with converting a view in oracle into postgresql readably code
2002-10-02 03:46 UTC Matthew Geddert <geddert@yahoo.com>
` please help with converting a view in oracle into postgresql readably code
2002-10-02 05:41 UTC mgeddert <mgeddert@mbseminary.com>
` Re: please help with converting a view in oracle into postgresql readably code
2002-10-02 06:12 UTC Roberto Mello <rmello@cc.usu.edu>
` Re: please help with converting a view in oracle into postgresql readably code
2002-10-04 14:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Re: [SQL] CURRENT_TIMESTAMP
2002-09-23 19:02 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-23 20:36 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-23 20:41 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-23 20:49 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-23 20:53 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-23 20:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 00:11 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 00:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 00:37 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-24 01:19 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 01:53 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 02:01 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 02:20 UTC John Hasler <john@dhh.gt.org>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 03:17 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 03:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 03:37 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 03:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 03:52 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-24 08:33 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 09:16 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 09:37 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 09:44 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 11:44 UTC Haller Christoph <Christoph.Haller@rodos.fzk.de>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 12:08 UTC Christoph Haller <ch@rodos.fzk.de>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 13:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-24 14:55 UTC Roland Roberts <roland@astrofoto.org>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 15:05 UTC Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 15:07 UTC Ross J. Reedstrom <reedstrm@rice.edu>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 15:10 UTC Ross J. Reedstrom <reedstrm@rice.edu>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 15:19 UTC Ross J. Reedstrom <reedstrm@rice.edu>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 15:27 UTC John Hasler <john@dhh.gt.org>
` Re: [GENERAL] CURRENT_TIMESTAMP
2002-09-24 16:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-24 21:48 UTC Roland Roberts <roland@astrofoto.org>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-24 21:56 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-25 06:54 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-27 17:29 UTC Roland Roberts <roland@astrofoto.org>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 03:28 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 03:47 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 03:51 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 04:10 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 04:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 19:43 UTC Josh Berkus <josh@agliodbs.com>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 20:38 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 20:47 UTC Josh Berkus <josh@agliodbs.com>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-29 21:27 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 03:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 04:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 16:20 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 17:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 18:37 UTC Jean-Luc Lachance <jllachan@nsd.ca>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 18:47 UTC Jean-Luc Lachance <jllachan@nsd.ca>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 18:49 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] CURRENT_TIMESTAMP
2002-09-30 21:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-03 20:18 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-03 22:03 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-03 22:15 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-03 23:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-03 23:58 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-04 00:41 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-04 05:03 UTC Oliver Elphick <olly@lfix.co.uk>
` Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
2002-10-04 05:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
[61+ messages in thread]
order by x DESC, y ASC indexing problem
2002-10-04 02:07 UTC Vincent-Olivier Arsenault <vincent@up4c.com>
` Re: order by x DESC, y ASC indexing problem
2002-10-04 02:30 UTC Josh Berkus <josh@agliodbs.com>
` Re: order by x DESC, y ASC indexing problem
2002-10-04 03:09 UTC Bruno Wolff III <bruno@wolff.to>
` Re: order by x DESC, y ASC indexing problem
2002-10-04 03:12 UTC Bruno Wolff III <bruno@wolff.to>
` Re: order by x DESC, y ASC indexing problem
2002-10-04 03:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
use [PERF] instead of
2002-10-03 21:12 UTC Jean-Luc Lachance <jllachan@nsd.ca>
drop constraint primary key
2002-10-03 16:06 UTC Marie G. Tuite <marie.tuite@edisonaffiliates.com>
` Re: drop constraint primary key
2002-10-03 17:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Formatting current_time output
2002-10-03 14:46 UTC Thomas Good <tomg@sqlclinic.net>
` Re: Formatting current_time output
2002-10-03 15:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: Formatting current_time output
2002-10-03 15:10 UTC Thomas Good <tomg@sqlclinic.net>
` Re: Formatting current_time output
2002-10-03 15:22 UTC Charles H. Woloszynski <chw@clearmetrix.com>
` Re: Formatting current_time output
2002-10-03 15:28 UTC Karel Zak <zakkr@zf.jcu.cz>
` Re: Formatting current_time output
2002-10-03 15:28 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
[6+ messages in thread]
Updating from select
2002-10-02 17:11 UTC Thrasher <thrasher@fibers.upc.es>
` Re: Updating from select
2002-10-02 17:45 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: Updating from select
2002-10-03 08:18 UTC Thrasher <thrasher@fibers.upc.es>
[3+ messages in thread]
split function for pl/pgsql
2002-10-02 10:30 UTC Frederic Logier <fred@az-informatique.com>
` Re: split function for pl/pgsql
2002-10-02 15:44 UTC Joe Conway <mail@joeconway.com>
` Re: split function for pl/pgsql
2002-10-02 16:54 UTC Frederic Logier <fred@az-informatique.com>
` Re: split function for pl/pgsql
2002-10-03 03:14 UTC Joe Conway <mail@joeconway.com>
[4+ messages in thread]
schedule of v7.3
2002-10-02 19:06 UTC Jie Liang <jie@stbernard.com>
` Re: schedule of v7.3
2002-10-02 21:24 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[2+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox