Mailing lists [pgsql-novice]

1 December 2004

• 06:09   The slony1 Project FC3 rpm build fun Ted Kaczmarek
• 07:19   remove too much space between words of the string Akbar
• 11:19   Re: problematic upgrade Marcin Gil
• 17:37   Re: remove too much space between words of the string Bruno Wolff III
• 19:57   catch runtime errors Robert Wimmer
• 21:50   Data directory copies... Steve Tucknott
• 22:04   Re: Data directory copies... Tom Lane

2 December 2004

• 02:57   Re: views with parameters Thomas Hermann(Software)
• 05:15   Re: catch runtime errors Tom Lane
• 08:02   first try at postgres functions Kevin B.
• 08:20   Re: first try at postgres functions Michael Fuhr
• 08:26   BLOB Hasnul Fadhly bin Hasan
• 19:20   implementing tree structure BRN Sarma
• 20:00   Books Kim Kohen
• 20:05   Trigger Question Terry Lee Tucker
• 20:15   Re: Books M. Bastin
• 20:18   Re: Books Terry Lee Tucker
• 20:20   Re: implementing tree structure Sean Davis
• 20:43   Re: Trigger Question Tom Lane
• 22:39   Re: Books Bruno Wolff III
• 23:02   Re: first try at postgres functions Robert Wimmer

3 December 2004

• 07:44   Re: Books Hari Bhanujan
• 07:47   Re: windows version Fernando Santucci
• 09:03   Re: Books Bret Busby
• 15:07   order by for user defined types Kjetil Haaland
• 16:19   using a correlated subquery in update Sean Davis
• 19:15   Re: order by for user defined types Tom Lane
• 19:18   Postgre 8 beta 5 clayton
• 19:43   Re: using a correlated subquery in update Michael Fuhr
• 19:45   Re: Postgre 8 beta 5 M. Bastin
• 22:46   Re: using a correlated subquery in update Andrew Hammond
• 23:06   Re: using a correlated subquery in update Sean Davis

4 December 2004

• 00:22   Re: using a correlated subquery in update Michael Fuhr
• 02:16   multiple table join and sumation Keith Worthington
• 04:57   Null vs empty string Keith Worthington
• 06:12   Re: multiple table join and sumation Michael Fuhr
• 06:28   Re: Null vs empty string Michael Fuhr
• 07:15   Re: Null vs empty string Keith Worthington

6 December 2004

• 19:52   loading data Keith Worthington
• 20:28   Restoring A Dump As A Normal User Jeff Flowers
• 22:02   Import .sql file Sudhakar Kurumella
• 22:13   Re: Import .sql file Vishal Kashyap @ [SaiHertz]

7 December 2004

• 03:50   triggers, transactions and locks Colin Gillespie
• 03:53   DB start error message 
• 04:39   Re: DB start error message Aly Dharshi
• 07:23   message type 0x44 Neil
• 07:41   Re: DB start error message Tom Lane
• 08:13   Re: message type 0x44 Tom Lane
• 08:21   Re: triggers, transactions and locks Michael Fuhr
• 08:50   Re: message type 0x44 Neil
• 09:01   Re: message type 0x44 Tom Lane
• 13:12   Re: triggers, transactions and locks Colin Gillespie
• 13:55   Slow delete Colin Gillespie
• 14:09   Re: Slow delete Sean Davis

11 December 2004

• 01:05   Indexing Strategy Matthew Engelbert
• 01:16   Re: Slow delete Andrew Hammond
• 02:57   can't set sequence Keith Worthington
• 03:35   Version 8 & column order Kevin B.
• 04:11   Re: message type 0x44 Neil
• 04:14   Re: Import .sql file Vishal Kashyap @ [SaiHertz]
• 04:27   Get comment Douglas
• 05:08   Re: Slow delete Colin Gillespie
• 05:52   message type 0x44 - Again Neil
• 09:58   Re: can't set sequence Michael Fuhr
• 10:29   Re: Get comment Michael Fuhr
• 10:44   Re: Indexing Strategy Matthew Engelbert
• 10:44   Re: Version 8 & column order Michael Fuhr
• 10:59   Re: Indexing Strategy Josh Berkus
• 20:39   SQUID Log in PostgreSQL Vishal Kashyap @ [SaiHertz]
• 22:57   Re: SQUID Log in PostgreSQL Michael Fuhr

12 December 2004

• 01:52   check if column is NULL (php) Robert Wimmer
• 04:18   Re: check if column is NULL (php) Michael Fuhr
• 06:07   Re: can't set sequence Keith Worthington
• 06:22   Re: can't set sequence Michael Fuhr

13 December 2004

• 04:05   Re: message type 0x44 Hari Bhanujan
• 04:10   basic download and setup questions Raymond Still
• 04:16   how to create a composite type as return type for a Function as Table Source Tjibbe Rijpma
• 05:09   Re: how to create a composite type as return type for a Stephan Szabo
• 05:39   Re: how to create a composite type as return type for a Function as Table Source Tom Lane
• 16:12   Re: basic download and setup questions John DeSoi
• 19:29   INSERT question sarlav kumar
• 19:38   Re: INSERT question Bruno Wolff III
• 19:48   Re: INSERT question Tom Lane
• 20:21   Re: Get comment Michael Fuhr
• 21:31   Re: INSERT question sarlav kumar

14 December 2004

• 03:32   How to create a (recursive) function that get all parents from: a tree with loops in it. Tjibbe Rijpma
• 08:54   Changing debug levels in postgresql Deepa K
• 12:44   timestamps Martin Atukunda
• 13:15   Re: [despammed] timestamps Andreas Kretschmer
• 19:35   Re: timestamps Steven Klassen

15 December 2004

• 00:33   Re: basic download and setup questions Afton & Ray Still
• 00:34   Query Optimization sarlav kumar
• 01:22   Re: timestamps Martin Atukunda
• 05:12   status variables Keith Worthington
• 05:32   Re: Indexing Strategy Josh Berkus
• 06:00   Re: status variables Michael Fuhr
• 06:40   Re: status variables Keith Worthington
• 08:30   postgresql compile errors Nigel Pegus
• 08:33   How to creata a recursive function for tree with loops in it Tjibbe Rijpma
• 08:36   How to creata a recursive function for tree with loops in it Tjibbe Rijpma
• 08:41   tsearch2 installation problem Sam
• 14:32   Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X Lola Lee
• 15:40   Re: postgresql compile errors Geoffrey
• 17:02   Re: function returning a row Kjetil Haaland
• 17:38   \d output to a file sarlav kumar
• 18:04   Re: [despammed] \d output to a file Andreas Kretschmer
• 18:16   Re: function returning a row Joe Conway
• 18:17   Re: \d output to a file Geoffrey
• 18:24   Re: [despammed] \d output to a file Geoffrey
• 19:23   Re: [despammed] \d output to a file Kretschmer Andreas
• 19:51   Re: \d output to a file Tom Lane
• 20:06   Re: function returning a row Michael Fuhr
• 21:16   Re: \d output to a file Kretschmer Andreas
• 23:11   Re: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X John DeSoi
• 23:24   Re: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X Lola Lee

16 December 2004

• 07:06   Re: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X John DeSoi
• 18:11   pl/pgsql and returns timestamp type Terry Yapt
• 19:47   Re: pl/pgsql and returns timestamp type Tom Lane
• 20:10   Re: basic download and setup questions Afton & Ray Still
• 21:01   Re: pl/pgsql and returns timestamp type Michael Fuhr
• 22:18   Re: basic download and setup questions George Weaver
• 23:11   Re: basic download and setup questions John DeSoi
• 23:11   Re: basic download and setup questions John DeSoi

17 December 2004

• 00:34   Re: basic download and setup questions Luiz K. Matsumura
• 02:02   language "plpgsql" does not exist Keith Worthington
• 02:40   Re: basic download and setup questions Afton & Ray Still
• 02:44   Re: language "plpgsql" does not exist Terry Lee Tucker
• 02:48   Re: language "plpgsql" does not exist Michael Fuhr
• 03:12   Re: language "plpgsql" does not exist Keith Worthington
• 03:27   Re: basic download and setup questions Afton & Ray Still
• 03:51   PERFORM statement question Keith Worthington
• 03:53   Re: basic download and setup questions John DeSoi
• 04:08   Re: PERFORM statement question Tom Lane
• 04:23   Re: PERFORM statement question Keith Worthington
• 07:06   FUNCTION, TRIGGER and best practices Keith Worthington
• 08:44   Re: FUNCTION, TRIGGER and best practices Josh Berkus
• 09:52   Re: FUNCTION, TRIGGER and best practices Michael Fuhr
• 10:32   Reading across databases Steve Tucknott
• 10:49   Re: [despammed] Reading across databases Andreas Kretschmer
• 10:57   Re: Reading across databases Michael Fuhr
• 11:04   Re: [despammed] Reading across databases Steve Tucknott
• 12:08   Re: [despammed] Reading across databases Michael Fuhr
• 12:28   Re: [despammed] Reading across databases Andreas Kretschmer
• 17:54   Problem with pl/perl in postgresql 8.0rc1 Robert Boone
• 18:34   Re: Problem with pl/perl in postgresql 8.0rc1 Kretschmer Andreas
• 19:04   Re: Problem with pl/perl in postgresql 8.0rc1 Robert Boone
• 20:14   Re: Problem with pl/perl in postgresql 8.0rc1 Michael Fuhr
• 20:23   Re: Problem with pl/perl in postgresql 8.0rc1 Tom Lane
• 20:53   Re: Problem with pl/perl in postgresql 8.0rc1 Devrim GUNDUZ
• 22:30   Re: how to echo SQL commands in the output of a script Andreas Kretschmer

18 December 2004

• 10:18   how to echo SQL commands in the output of a script Gino Lucrezi
• 10:19   Re: [PERFORM] Query Optimization Andrew Lazarus
• 10:20   Re: [PERFORM] \d output to a file Gary Cowell
• 10:23   Postgresql candra
• 10:23   Re: [PERFORM] \d output to a file Ragnar Hafstað
• 10:23   Re: Problem with pl/perl in postgresql 8.0rc1 Robert Boone
• 10:25   Problem with pl/perl in postgresql 8.0rc1 Robert Boone
• 10:32   Re: [PERFORM] \d output to a file Grega Bremec
• 11:09   Re: Postgresql Michael Fuhr
• 11:48   Copying pg_control file Deepa K
• 12:37   Re: Copying pg_control file Kretschmer Andreas
• 13:12   Re: Copying pg_control file Deepa K
• 14:01   Re: Copying pg_control file Kretschmer Andreas
• 14:43   Re: how to echo SQL commands in the output of a script George Weaver
• 20:55   Re: Copying pg_control file Tom Lane

19 December 2004

• 00:38   version 8 Tomka Gergely
• 00:57   Re: version 8 Josh Berkus
• 03:05   Front end? Afton & Ray Still
• 07:27   Re: Front end? John DeSoi
• 08:23   Fw: Front end? Afton & Ray Still
• 08:32   Re: Front end? John DeSoi

20 December 2004

• 03:07   Querying now() A Gilmore
• 03:45   Re: Front end? M. Bastin
• 03:47   Re: Querying now() Tom Lane
• 03:57   Re: Querying now() Michael Glaesemann
• 05:36   Re: Querying now() A Gilmore
• 07:02   Drop does not always drop Bruce Badger
• 17:40   Postgres version change - pg_dump sarlav kumar
• 17:54   Re: [despammed] Postgres version change - pg_dump Andreas Kretschmer
• 18:02   Re: Fw: Front end? Jeff Eckermann
• 18:17   pg_dumpall with oids/blobs Marcin Gil
• 18:18   create user with password sarlav kumar
• 18:22   Re: Drop does not always drop Tom Lane
• 18:24   Re: create user with password Devrim GUNDUZ
• 18:25   Re: create user with password Marcin Gil
• 18:25   Re: create user with password Marcin Gil
• 18:35   Re: Postgres version change - pg_dump Bruno Wolff III
• 19:21   Re: pg_dumpall with oids/blobs Kretschmer Andreas
• 20:34   Re: Postgres version change - pg_dump sarlav kumar
• 20:51   Connection problem with 8 Beta 5 George Weaver
• 21:10   Re: Connection problem with 8 Beta 5 Tom Lane
• 21:32   Re: Postgres version change - pg_dump Kretschmer Andreas
• 22:00   Re: Connection problem with 8 Beta 5 George Weaver

21 December 2004

• 00:58   CAST and timestamp Keith Worthington
• 01:26   slony replication sarlav kumar
• 02:53   Re: SQUID Log in PostgreSQL Steve Crawford
• 03:32   Re: CAST and timestamp Tom Lane
• 06:23   Inheritance Hasnul Fadhly bin Hasan
• 06:47   Re: Inheritance Tom Lane
• 06:48   Re: CAST and timestamp Keith Worthington
• 07:04   Re: CAST and timestamp Tom Lane
• 07:09   Re: CAST and timestamp Mike G
• 07:15   Re: CAST and timestamp Tom Lane
• 07:33   Re: CAST and timestamp Mike G
• 08:42   Re: slony replication Christopher Browne
• 08:42   Re: how to echo SQL commands in the output of a script Gino Lucrezi
• 08:43   Re: [PERFORM] Postgres version change - pg_dump Stefan Weiss
• 10:36   Re: Drop does not always drop Bruce Badger
• 10:36   Re: pg_dumpall with oids/blobs Marcin Gil
• 11:24   Re: Inheritance Tjibbe Rijpma
• 15:28   How to get day of week? Lloyd Dieter
• 15:42   Re: [despammed] How to get day of week? Andreas Kretschmer
• 16:24   Re: CAST and timestamp Geoffrey
• 16:28   Re: [despammed] How to get day of week? Lloyd Dieter
• 17:27   Using a timestamp in a WHERE clause Keith Worthington
• 17:34   Re: CAST and timestamp Keith Worthington
• 17:42   Re: Inheritance Bruno Wolff III
• 17:56   FOUND variable Keith Worthington
• 18:18   Re: FOUND variable Terry Lee Tucker
• 19:32   Re: [despammed] How to get day of week? Michael Fuhr
• 20:24   syntax error in function Keith Worthington
• 20:47   Re: syntax error in function Tom Lane
• 21:05   Re: syntax error in function Keith Worthington
• 21:41   Re: SQUID Log in PostgreSQL Vishal Kashyap @ [SaiHertz]

22 December 2004

• 00:13   JOIN columns with no data Keith Worthington
• 00:23   Re: JOIN columns with no data George Weaver
• 00:55   Re: How to get day of week? Jeffrey Melloy
• 06:38   extracting min date and grouping Keith Worthington
• 06:50   Re: syntax error in function Mike G.
• 08:55   Problem with ALIAS? Keith Worthington
• 09:53   Re: extracting min date and grouping Michael Fuhr
• 10:07   Re: Problem with ALIAS? Michael Fuhr
• 15:35   Encoding problems gustavo.oliveira
• 17:40   Re: Problem with ALIAS? Keith Worthington
• 19:08   Re: Problem with ALIAS? Tom Lane
• 19:37   Re: Encoding problems Tom Lane

23 December 2004

• 23:57   Extracting data where a column is max Keith Worthington

24 December 2004

• 00:42   Re: Extracting data where a column is max George Weaver
• 00:53   Re: Front end? Afton & Ray Still
• 01:16   Re: Front end? Taber, Mark
• 01:18   Re: Front end? Taber, Mark
• 01:21   Re: Front end? Sean Davis
• 07:33   Re: Front end? 
• 07:52   Re: Extracting data where a column is max Michael Fuhr
• 10:09   Re: Front end? brew@theMode.com
• 17:20   Re: [PERFORM] Postgres version change - pg_dump Christopher Kings-Lynne
• 17:27   Re: [PERFORM] Postgres version change - pg_dump Iain

26 December 2004

• 22:32   Fixable? cache lookup failed for type Michael Guerin

27 December 2004

• 19:33   Problems installing on Linux Adam
• 19:44   Re: Problems installing on Linux Devrim GUNDUZ
• 20:00   Re: Extracting data where a column is max Keith Worthington
• 20:19   Re: Extracting data where a column is max Keith Worthington
• 20:33   user defined data type problem while dumping? sarlav kumar
• 20:57   Re: user defined data type problem while dumping? Tom Lane
• 21:04   Query returns 0 for subsequent columns Keith Worthington
• 21:18   Re: Query returns 0 for subsequent columns Keith Worthington
• 21:45   Rewritten queries Keith Worthington
• 22:00   Re: Rewritten queries Jaime Casanova
• 22:04   Re: Rewritten queries Jaime Casanova
• 22:42   Re: Rewritten queries Tom Lane
• 22:49   Re: Rewritten queries Jaime Casanova
• 23:50   Re: Extracting data where a column is max Bruno Wolff III

28 December 2004

• 08:31   Calculating the difference between result columns Keith Worthington
• 13:57   help with - psql: FATAL: Password authentication failed for user "gforge" Sukhdeep Johar
• 18:01   Re: Calculating the difference between result columns Tom Lane
• 19:41   Re: Calculating the difference between result columns Sudamericano

29 December 2004

• 02:58   Re: [PERFORM] user defined data type problem while dumping? Alexander Borkowski
• 07:02   Re: [PERFORM] slony replication Robert Treat
• 21:33   Creating a database with pg_restore Keith Worthington
• 22:05   Re: Creating a database with pg_restore Tom Lane

30 December 2004

• 02:11   Re: [PERFORM] INSERT question george young
• 02:12   Re: help with - psql: FATAL: Password authentication failed for user "gforge" boyd

31 December 2004

• 06:09   ERROR: relation "managers" does not exist Mark Edward Smith
• 06:11   adding a new data to existing psql table from comma del file sloftus
• 07:06   Re: ERROR: relation "managers" does not exist Michael Fuhr
• 08:38   Re: adding a new data to existing psql table from comma del file Michael Fuhr