pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
query optimization question
  2002-11-05 00:19 UTC  terry@ashtonwoodshomes.com
` Re: query optimization question
  2002-11-06 13:56 UTC  terry@greatgulfhomes.com
` FW: query optimization question
  2002-11-06 14:01 UTC  terry@ashtonwoodshomes.com
` Re: FW: query optimization question
  2002-11-06 15:11 UTC  Richard Huxton <dev@archonet.com>
` Re: query optimization question
  2002-11-06 15:58 UTC  Christoph Haller <ch@rodos.fzk.de>
` Re: FW: query optimization question
  2002-11-06 16:22 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: FW: query optimization question
  2002-11-06 16:36 UTC  terry@ashtonwoodshomes.com
` Re: FW: query optimization question
  2002-11-06 16:44 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: query optimization question
  2002-11-06 16:44 UTC  Masaru Sugawara <rk73@sea.plala.or.jp>
` Re: query optimization question
  2002-11-06 17:10 UTC  terry@ashtonwoodshomes.com
` Re: query optimization question
  2002-11-06 17:11 UTC  Masaru Sugawara <rk73@sea.plala.or.jp>
` Re: query optimization question
  2002-11-07 08:57 UTC  Christoph Haller <ch@rodos.fzk.de>
` Re: query optimization question
  2002-11-07 23:18 UTC  terry@ashtonwoodshomes.com
` Re: query optimization question
  2002-11-08 10:01 UTC  Christoph Haller <ch@rodos.fzk.de>
` Re: query optimization question
  2002-11-08 14:22 UTC  Masaru Sugawara <rk73@sea.plala.or.jp>
  [15+ messages in thread]

PLpgSQL FOR IN EXECUTE question
  2002-11-07 14:35 UTC  Christoph Haller <ch@rodos.fzk.de>
` Re: PLpgSQL FOR IN EXECUTE question
  2002-11-07 16:13 UTC  Richard Huxton <dev@archonet.com>
` Re: PLpgSQL FOR IN EXECUTE question
  2002-11-07 18:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PLpgSQL FOR IN EXECUTE question
  2002-11-07 21:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: PLpgSQL FOR IN EXECUTE question
  2002-11-08 09:06 UTC  Christoph Haller <ch@rodos.fzk.de>
  [5+ messages in thread]

how to get the source table & field name of a view field
  2002-11-07 09:12 UTC  Prime Ho <ho@optimasoft.com.tw>
` Re: how to get the source table & field name of a view field
  2002-11-07 14:06 UTC  Christoph Haller <ch@rodos.fzk.de>
` Re: how to get the source table & field name of a view field
  2002-11-07 14:25 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: how to get the source table & field name of a view field
  2002-11-07 15:08 UTC  Ken Kennedy <kkennedy@kenzoid.com>
` Re: how to get the source table & field name of a view field
  2002-11-08 08:22 UTC  Christoph Haller <ch@rodos.fzk.de>
  [5+ messages in thread]

No promany key in parent table, how to use delete cascade?
  2002-11-08 06:19 UTC  Zhidian Du <duzhidian@hotmail.com>
` Re: No promany key in parent table, how to use delete cascade?
  2002-11-08 06:49 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  [2+ messages in thread]

Delete cascade for multi tables?
  2002-11-08 05:36 UTC  Zhidian Du <duzhidian@hotmail.com>

get source table.field name from view's field
  2002-11-08 05:17 UTC  Prime Ho <ho@optimasoft.com.tw>

Cannot assign ROWTYPE, RECORD variables in PL/pgSQL
  2002-11-06 22:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL
  2002-11-07 21:56 UTC  Neil Conway <neilc@samurai.com>
` Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL
  2002-11-07 22:57 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL
  2002-11-08 03:11 UTC  elein <elein@sbcglobal.net>
  [4+ messages in thread]

cast lo to oid
  2002-11-07 12:22 UTC  Nekta Katz <nekta_k@hotmail.com>
` Re: cast lo to oid
  2002-11-07 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cast lo to oid
  2002-11-08 00:11 UTC  Nekta Katz <nekta_k@hotmail.com>
` Re: cast lo to oid
  2002-11-08 00:24 UTC  Nekta Katz <nekta_k@hotmail.com>
  [4+ messages in thread]

Quartile (etc) ranking in a SQL statement?
  2002-11-07 18:16 UTC  Jeff Boes <jboes@nexcerpt.com>
` Re: Quartile (etc) ranking in a SQL statement?
  2002-11-07 20:50 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
  [2+ messages in thread]

Weird NULL behavior
  2002-11-07 11:41 UTC  Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: Weird NULL behavior
  2002-11-07 16:41 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Weird NULL behavior
  2002-11-07 19:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird NULL behavior
  2002-11-07 19:35 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Weird NULL behavior
  2002-11-07 20:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Copying a rowtype variable.
  2002-11-05 13:33 UTC  Rison, Stuart <srison@rvc.ac.uk>
` Re: [SQL] Copying a rowtype variable.
  2002-11-05 16:55 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Copying a rowtype variable.
  2002-11-06 21:30 UTC  Rison, Stuart <srison@rvc.ac.uk>
` Re: Copying a rowtype variable.
  2002-11-07 16:28 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: Copying a rowtype variable.
  2002-11-07 16:51 UTC  Rison, Stuart <srison@rvc.ac.uk>
  [5+ messages in thread]

Problem: Referential Integrity Constraints lost
  2002-11-06 12:41 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] Problem: Referential Integrity Constraints lost
  2002-11-06 12:53 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] Problem: Referential Integrity Constraints lost: Correction
  2002-11-06 14:10 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] Problem: Referential Integrity Constraints lost
  2002-11-06 16:25 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: [SQL] Problem: Referential Integrity Constraints lost
  2002-11-07 07:33 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] Problem: Referential Integrity Constraints lost
  2002-11-07 07:57 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] Problem: Referential Integrity Constraints lost
  2002-11-07 14:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] Problem: Referential Integrity Constraints lost
  2002-11-07 16:38 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  [8+ messages in thread]

primary keys
  1998-05-18 07:48 UTC  Perry Seleski <seleski@ronix.ptf.hro.nl>
` Re: [SQL] primary keys
  1998-05-18 12:29 UTC  Marin D <marin@iclub.techno-link.com>
` primary keys
  2002-11-06 14:18 UTC  Huub <v.niekerk@freeler.nl>
` Re: primary keys
  2002-11-07 13:54 UTC  terry@greatgulfhomes.com
` Re: primary keys
  2002-11-07 14:01 UTC  Rachel.Vaudron <rachel@lazaret.unice.fr>
` Re: primary keys
  2002-11-07 14:28 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: primary keys
  2002-11-07 14:29 UTC  Huub <v.niekerk@freeler.nl>
` Re: primary keys
  2002-11-07 14:35 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: primary keys
  2002-11-07 14:49 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: primary keys
  2002-11-07 15:12 UTC  Sangeetha Rao <srao@carolina.rr.com>
  [10+ messages in thread]

Re: [pgsql-sql] Daily Digest V1 #983
  2002-11-07 09:27 UTC  vist@systems.saab.se

Database Design tool
  2002-10-30 06:45 UTC  Viacheslav N Tararin <taras@dekasoft.com.ua>
` Re: Database Design tool
  2002-10-30 09:15 UTC  Bhuvan A <bhuvansql@myrealbox.com>
` Re: [SQL] Database Design tool
  2002-10-30 09:44 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Database Design tool
  2002-10-30 13:37 UTC  Diogo Biazus <diogo@ikono.com.br>
` Re: [SQL] Database Design tool
  2002-10-30 14:35 UTC  Johannes Lochmann <johannes.lochmann@chello.at>
` Re: [SQL] Database Design tool
  2002-10-30 15:30 UTC  Dan Hrabarchuk <dan@findatradenow.com>
` Re: [SQL] Database Design tool
  2002-10-30 20:42 UTC  Kevin Old <kold@carolina.rr.com>
` Re: Database Design tool
  2002-10-30 23:07 UTC  Wei Weng <wweng@kencast.com>
` Re: Database Design tool
  2002-10-30 23:43 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Design tool
  2002-10-30 23:52 UTC  Wei Weng <wweng@kencast.com>
` Re: Database Design tool
  2002-10-30 23:56 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Design tool
  2002-10-31 00:12 UTC  Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
` Re: [SQL] Database Design tool
  2002-11-04 21:00 UTC  Patrick Bakker <patrick@vanbelle.com>
` Re: [SQL] Database Design tool
  2002-11-04 21:01 UTC  Larry Rosenman <ler@lerctr.org>
` Re: [GENERAL] Database Design tool
  2002-11-05 11:46 UTC  Michael Ansley (UK) <Michael.Ansley@intec-telecom-systems.com>
` Re: [GENERAL] Database Design tool
  2002-11-05 14:00 UTC  Thomas Good <tomg@sqlclinic.net>
` Re: [GENERAL] Database Design tool
  2002-11-05 14:24 UTC  tony <tgrant@apps.tgds.net>
` Re: [GENERAL] Database Design tool
  2002-11-05 16:33 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] Database Design tool
  2002-11-05 16:50 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: [GENERAL] Database Design tool
  2002-11-05 18:19 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [GENERAL] Database Design tool
  2002-11-05 20:16 UTC  Kaare Rasmussen <kar@kakidata.dk>
` Re: [GENERAL] Database Design tool
  2002-11-05 21:17 UTC  Robert Treat <xzilla@users.sourceforge.net>
  [22+ messages in thread]

owner of type 'mmm' apperars to be invalid
  2002-11-05 05:57 UTC  cristi <cristi@dmhi.ct.ro>
` Re: owner of type 'mmm' apperars to be invalid
  2002-11-05 10:57 UTC  Richard Huxton <dev@archonet.com>
` Re: owner of type 'mmm' apperars to be invalid
  2002-11-05 13:03 UTC  cristi <cristi@dmhi.ct.ro>
` Re: owner of type 'mmm' apperars to be invalid
  2002-11-05 13:21 UTC  Richard Huxton <dev@archonet.com>
` Re: owner of type 'mmm' apperars to be invalid
  2002-11-05 14:32 UTC  cristi <cristi@dmhi.ct.ro>
` Re: owner of type 'mmm' apperars to be invalid
  2002-11-05 14:51 UTC  Richard Huxton <dev@archonet.com>
  [6+ messages in thread]

Referential integrity Freeze
  2002-11-04 23:37 UTC  Rudi Starcevic <rudi@oasis.net.au>
` Re: Referential integrity Freeze
  2002-11-05 00:05 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Referential integrity Freeze
  2002-11-05 00:16 UTC  Rudi Starcevic <rudi@oasis.net.au>
  [3+ messages in thread]

counting text matches - any recipes?
  2002-11-04 22:53 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
` Re: counting text matches - any recipes?
  2002-11-04 23:26 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Problem with Auto Increment
  2002-11-04 18:29 UTC  Ben Kassel <kasselb@nswccd.navy.mil>
` Re: Problem with Auto Increment
  2002-11-04 20:45 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  [2+ messages in thread]

Comparing Numeric and Double Precision (float8)..
  2002-11-04 08:11 UTC  Terry Yapt <pgsql@technovell.com>
` Re: Comparing Numeric and Double Precision (float8)..
  2002-11-04 13:45 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Comparing Numeric and Double Precision (float8)..
  2002-11-04 14:35 UTC  Terry Yapt <pgsql@technovell.com>
  [3+ messages in thread]

uniqueidentifier datatype for 7.3.X
  2002-11-03 09:53 UTC  "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
` Re: uniqueidentifier datatype for 7.3.X
  2002-11-03 16:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: uniqueidentifier datatype for 7.3.X
  2002-11-04 06:33 UTC  "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
  [3+ messages in thread]

Does this matter?
  2002-11-01 20:18 UTC  Wei Weng <wweng@kencast.com>
` Re: Does this matter?
  2002-11-01 20:23 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Does this matter?
  2002-11-01 20:52 UTC  Wei Weng <wweng@kencast.com>
` Re: Does this matter?
  2002-11-01 20:53 UTC  Philip Hallstrom <philip@adhesivemedia.com>
` Re: Does this matter?
  2002-11-01 21:10 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Does this matter?
  2002-11-01 22:00 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Does this matter?
  2002-11-01 22:00 UTC  Curtis Faith <curtis@galtair.com>
` Re: Does this matter?
  2002-11-01 22:01 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Does this matter?
  2002-11-04 04:08 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] Does this matter?
  2002-11-04 04:33 UTC  Wei Weng <wweng@kencast.com>
  [10+ messages in thread]

7.2.3: tuple is too big (max 8136)
  2002-11-01 13:33 UTC  pilsl@goldfisch.at
` Re: 7.2.3: tuple is too big (max 8136)
  2002-11-01 13:50 UTC  Doug McNaught <doug@mcnaught.org>
` Re: 7.2.3: tuple is too big (max 8136)
  2002-11-04 00:11 UTC  pilsl@goldfisch.at
` Re: 7.2.3: tuple is too big (max 8136)
  2002-11-04 00:19 UTC  Doug McNaught <doug@mcnaught.org>
` Re: 7.2.3: tuple is too big (max 8136)
  2002-11-04 00:38 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: 7.2.3: tuple is too big (max 8136)
  2002-11-04 02:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

Different size in the DATA directory
  2002-11-01 14:09 UTC  Maurício Sessue Otta <mauricio@cristorei.com.br>
` Re: Different size in the DATA directory
  2002-11-01 14:25 UTC  Maurício Sessue Otta <mauricio@cristorei.com.br>
` Re: Different size in the DATA directory
  2002-11-01 15:22 UTC  dima <_pppp@mail.ru>
` Re: Different size in the DATA directory
  2002-11-01 15:32 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Different size in the DATA directory
  2002-11-01 16:02 UTC  Tim Perdue <tim@perdue.net>
` Re: Different size in the DATA directory
  2002-11-02 03:48 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Different size in the DATA directory
  2002-11-02 14:33 UTC  Alexander M. Pravking <fduch@antar.bryansk.ru>
` Re: Different size in the DATA directory
  2002-11-03 01:20 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Different size in the DATA directory
  2002-11-03 12:19 UTC  Alexander M. Pravking <fduch@antar.bryansk.ru>
  [9+ messages in thread]

Timezone issue with date_part
  2002-11-02 06:56 UTC  Ken Kennedy <kkennedy@kenzoid.com>
` Re: Timezone issue with date_part
  2002-11-02 14:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Timezone issue with date_part
  2002-11-02 20:55 UTC  Ken Kennedy <kkennedy@kenzoid.com>
` Re: Timezone issue with date_part
  2002-11-02 21:21 UTC  Josh Berkus <josh@agliodbs.com>
  [4+ 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