Mailing lists [pgsql-sql]

1 April 2007

• 05:09   Sequence vs Serial Daniel CAUNE
• 07:58   Re: Sequence vs Serial Scott Marlowe
• 18:51   Re: Sequence vs Serial Tom Lane

2 April 2007

• 08:02   Calling void functions Peter Eisentraut
• 13:23   Re: Calling void functions Daniel Caune
• 13:32   Re: Calling void functions A. Kretschmer
• 14:05   Update problem. Shavonne Marietta Wijesinghe
• 14:52   Update problem. Shavonne Marietta Wijesinghe
• 15:17   Re: Update problem. Andrew Sullivan
• 16:44   Re: Calling void functions Tom Lane
• 17:05   SQL4. I ask you to help in development (or critic). sql4-en.narod.ru
• 17:56   Maxusers MaxConnections 
• 22:46   Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Bruce Momjian
• 23:08   Re: Calling void functions Daniel CAUNE

3 April 2007

• 06:39   Very slow DELETE on 4000 rows of 55000 row table Bryce Nesbitt
• 07:04   Re: Very slow DELETE on 4000 rows of 55000 row table Tom Lane
• 07:12   Re: Update problem. Shavonne Marietta Wijesinghe
• 09:21   Serial Shavonne Marietta Wijesinghe
• 09:32   Re: Serial A. Kretschmer
• 10:01   Re: Serial Shavonne Marietta Wijesinghe
• 10:11   Re: Serial Milen A. Radev
• 10:14   Re: Serial A. Kretschmer
• 10:29   Re: Serial Shavonne Marietta Wijesinghe
• 10:40   Re: Serial A. Kretschmer
• 12:46   best way: diary functions. Gary Stainburn
• 12:55   LOCK command inside a TRANSACTION Carlos Santos
• 13:04   Using a variable as a view name in a select Wilkinson, Jim
• 13:16   Re: Using a variable as a view name in a select A. Kretschmer
• 13:53   Re: Using a variable as a view name in a select John Summerfield
• 13:57   Re: LOCK command inside a TRANSACTION Peter Eisentraut
• 14:17   Re: Serial Scott Marlowe
• 14:20   A long-running transaction John Summerfield
• 14:26   Re: Using a variable as a view name in a select Hilary Forbes
• 15:27   Re: Serial Richard Broersma Jr
• 16:16   Re: Update problem. Andrew Sullivan
• 16:38   Re: Using a variable as a view name in a select Hilary Forbes
• 17:18   Re: Using a variable as a view name in a select Wilkinson, Jim
• 17:42   plpgsql function question Karthikeyan Sundaram
• 18:18   Re: plpgsql function question Andreas Kretschmer
• 18:33   Re: plpgsql function question Karthikeyan Sundaram
• 18:36   Re: [pgsql-sql] Daily digest v1.2492 (19 messages) Steve Midgley
• 19:24   Re: plpgsql function question A. Kretschmer
• 20:14   Re: A long-running transaction Andrew Sullivan
• 20:27   Re: plpgsql function question John DeSoi
• 22:35   exception handling in postgres plpgsql Karthikeyan Sundaram
• 23:31   Re: exception handling in postgres plpgsql Joe

4 April 2007

• 00:24   Re: exception handling in postgres plpgsql Tom Lane
• 05:09   Re: plpgsql function question A. Kretschmer
• 06:19   Moving a simple function to pl/pgsql (Novice question) Paul Lambert
• 12:07   Generating dates prior to generate_series Roger Tannous
• 12:18   CPU statistics 
• 12:19   Re: plpgsql function question John DeSoi
• 12:32   Setting high performance on huge server 
• 12:56   Re: Setting high performance on huge server Claus Guttesen
• 13:07   Re: Moving a simple function to pl/pgsql (Novice question) Richard Broersma Jr
• 13:28   Solved - best way: diary functions. Gary Stainburn
• 13:55   Re: CPU statistics Peter Eisentraut
• 14:02   Re: CPU statistics Jonah H. Harris
• 22:20   Re: Moving a simple function to pl/pgsql (Novice question) Paul Lambert

5 April 2007

• 03:18   slow query Sumeet
• 04:17   Re: Very slow DELETE on 4000 rows of 55000 row table Bryce Nesbitt
• 04:46   Re: Very slow DELETE on 4000 rows of 55000 row table Richard Broersma Jr
• 05:11   Re: slow query A. Kretschmer
• 05:24   Re: Very slow DELETE on 4000 rows of 55000 row table Tom Lane
• 05:27   Re: slow query Tom Lane
• 05:36   Re: slow query A. Kretschmer
• 05:47   Re: slow query Tom Lane
• 08:38   Insert only if not found Shavonne Marietta Wijesinghe
• 08:53   Re: Insert only if not found A. Kretschmer
• 09:24   Re: Insert only if not found Shavonne Marietta Wijesinghe
• 09:47   Re: Insert only if not found Shavonne Marietta Wijesinghe
• 10:06   Re: Insert only if not found A. Kretschmer
• 13:33   Re: slow query Andrew Sullivan
• 14:32   LOG: unexpected EOF on client connection 
• 15:19   Another date range join problem Gary Stainburn
• 15:21   Re: LOG: unexpected EOF on client connection Tom Lane
• 15:24   Re: Generating dates prior to generate_series Scott Marlowe
• 16:04   SOLVED - Another date range join problem Gary Stainburn
• 17:42   auto vacuuming Sumeet
• 17:51   Re: auto vacuuming Alvaro Herrera
• 18:00   Re: auto vacuuming Sumeet
• 18:19   Re: auto vacuuming Alvaro Herrera
• 22:47   Re: Insert only if not found Roger Tannous

6 April 2007

• 07:09   Re: Insert only if not found Shavonne Marietta Wijesinghe
• 17:02   Update Field with function/data from other tables? paallen@attglobal.net
• 22:09   dropping a schema and cross-schema dependencies George Pavlov
• 23:39   Re: dropping a schema and cross-schema dependencies Tom Lane

7 April 2007

• 00:09   Re: dropping a schema and cross-schema dependencies George Pavlov
• 17:33   rowcount function in postgres??? Karthikeyan Sundaram
• 17:51   Re: rowcount function in postgres??? Michael Fuhr
• 17:54   Re: rowcount function in postgres??? Rodrigo De León

8 April 2007

• 17:03   MD5 sums of large objects Dirk Jagdmann
• 17:38   Re: MD5 sums of large objects Michael Fuhr
• 19:47   Question on pgpsql function Karthikeyan Sundaram
• 20:22   Re: Question on pgpsql function Adrian Klaver
• 23:20   Re: [ADMIN] Question on pgpsql function Tom Lane

9 April 2007

• 00:07   Re: MD5 sums of large objects Dirk Jagdmann
• 01:07   Re: MD5 sums of large objects Michael Fuhr
• 01:59   Another question in functions Karthikeyan Sundaram
• 06:41   new idea sql4-en.narod.ru
• 12:21   Re: new idea Andrew Sullivan
• 14:12   Re: new idea Erik Jones
• 14:15   Re: new idea Andrew Sullivan
• 14:24   Re: [ADMIN] Another question in functions Stephan Szabo
• 15:11   Re: MD5 sums of large objects Dirk Jagdmann
• 15:52   Re: new idea Erik Jones

10 April 2007

• 14:05   Question about undefinably query... A. Kretschmer
• 14:34   EXECUTE in a funtion to return a VIEW object ID Wilkinson, Jim
• 14:46   Re: Question about undefinably query... Tom Lane
• 16:42   Re: A long-running transaction John Summerfield
• 16:55   Re: A long-running transaction Andrew Sullivan
• 21:55   Re: A long-running transaction John Summerfield

11 April 2007

• 07:06   update from and left join Tomasz Myrta
• 13:34   Re: A long-running transaction Andrew Sullivan
• 14:24   Re: A long-running transaction John Summerfield
• 15:49   Re: A long-running transaction Andrew Sullivan
• 20:31   Urgent help in bit_string data type Karthikeyan Sundaram
• 21:44   Re: Urgent help in bit_string data type Joe
• 22:01   Re: [ADMIN] Urgent help in bit_string data type Karthikeyan Sundaram
• 23:02   Re: [ADMIN] Urgent help in bit_string data type Joe
• 23:29   Re: [ADMIN] Urgent help in bit_string data type Karthikeyan Sundaram

12 April 2007

• 04:07   Re: [ADMIN] Urgent help in bit_string data type Joe
• 04:32   Replace string PostgreSQL Admin
• 05:23   Re: Replace string A. Kretschmer
• 05:29   Re: Replace string Rodrigo De León
• 11:27   un-triviality is saved Dmitry Turin
• 12:05   ERROR: column "crc" does not exist 
• 12:15   Re: ERROR: column "crc" does not exist Bart Degryse
• 12:19   Re: ERROR: column "crc" does not exist A. Kretschmer
• 12:20   Re: ERROR: column "crc" does not exist George Weaver
• 12:21   Re: ERROR: column "crc" does not exist Andrew Sullivan
• 18:32   replace EXCEPT by JOIN T E Schmitz
• 19:51   Re: Replace string PostgreSQL Admin
• 22:44   question on plpgsql block Karthikeyan Sundaram

13 April 2007

• 00:39   setting up a mirroring or replication database Karthikeyan Sundaram
• 00:50   Re: setting up a mirroring or replication database Phillip Smith
• 01:03   Re: A long-running transaction John Summerfield
• 06:28   Re: question on plpgsql block A. Kretschmer
• 07:56   We all are looped on Internet: request + transport = invariant Dmitry Turin
• 11:27   How can I know if a row is Locked? Carlos Santos
• 11:49   Re: How can I know if a row is Locked? A. Kretschmer
• 11:49   Re: A long-running transaction Andrew Sullivan
• 11:49   Re: How can I know if a row is Locked? Marcin Stępnicki
• 15:09   Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan
• 16:20   Re: A long-running transaction Andrew Sullivan
• 16:51   Re: A long-running transaction Joe
• 17:01   Re: A long-running transaction Andrew Sullivan

16 April 2007

• 22:58   quesion on functions calling from php Karthikeyan Sundaram

17 April 2007

• 06:08   Re: quesion on functions calling from php Tommy Gildseth
• 18:54   Floating point type to store numbers Radhika Sambamurti
• 19:05   Re: Floating point type to store numbers Andrew Sullivan
• 19:11   Re: Floating point type to store numbers Milen A. Radev
• 19:18   Re: Floating point type to store numbers Richard Broersma Jr
• 20:28   Re: Floating point type to store numbers Radhika Sambamurti
• 20:33   Re: Floating point type to store numbers Radhika Sambamurti
• 20:36   Re: Floating point type to store numbers Radhika Sambamurti
• 20:53   Re: Floating point type to store numbers Andrew Sullivan
• 22:10   Re: Floating point type to store numbers Milen A. Radev

18 April 2007

• 18:36   equiv of ascii() function for unicode? Stuart McGraw
• 18:36   slowness when subselect uses DISTINCT Stuart McGraw
• 22:44   Re: slowness when subselect uses DISTINCT Phillip Smith

19 April 2007

• 06:06   Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
• 06:26   Re: We all are looped on Internet: request + transport = invariant Andrej Ricnik-Bay
• 13:48   Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan
• 14:20   Re: slowness when subselect uses DISTINCT Stuart McGraw
• 18:34   Doing a conditional insert/update Markus Holzer
• 18:55   Re: Doing a conditional insert/update Andrew Sullivan
• 18:59   Re: Doing a conditional insert/update Rodrigo De León
• 22:52   Re: slowness when subselect uses DISTINCT Phillip Smith

20 April 2007

• 05:15   many 'OR' in WHERE-condition A. Kretschmer
• 09:05   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 11:03   Re: many 'OR' in WHERE-condition Richard Huxton
• 11:14   Re: We all are looped on Internet: request + transport = invariant Richard Huxton
• 11:15   Re: We all are looped on Internet: request + transport = invariant Bart Degryse
• 11:29   Re: many 'OR' in WHERE-condition A. Kretschmer
• 11:59   Re: many 'OR' in WHERE-condition Richard Huxton
• 12:19   Retrieve month from date Rohit Khare
• 12:21   Re: many 'OR' in WHERE-condition A. Kretschmer
• 12:29   Re: Retrieve month from date Bart Degryse
• 12:35   Re: Retrieve month from date A. Kretschmer
• 12:43   Re: We all are looped on Internet: request + transport = invariant Joe
• 12:50   Re: We all are looped on Internet: request + transport = invariant Richard Huxton
• 13:21   Re: We all are looped on Internet: request + transport = invariant Joe
• 13:39   Re: We all are looped on Internet: request + transport= invariant Achilleas Mantzios
• 14:13   Function to return a multiple colmn table or view Wilkinson, Jim
• 14:32   Re: Function to return a multiple colmn table or view Richard Huxton
• 14:46   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 15:52   Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan
• 15:56   Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 16:13   Re: Retrieve month from date RPK
• 16:33   Re: Retrieve month from date Rodrigo De León
• 16:49   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 17:01   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 17:30   Re: Retrieve month from date RPK
• 17:43   Re: Retrieve month from date A. Kretschmer
• 17:46   Re: Retrieve month from date Scott Marlowe
• 19:19   Question on interval Wei Weng
• 19:29   Re: Question on interval Rodrigo De León
• 19:35   Re: Question on interval Michael Glaesemann
• 20:11   Re: Question on interval Scott Marlowe

21 April 2007

• 01:03   Re: Question on interval Steve Crawford
• 23:47   Split String Into Multiple Records Aaron Bono

22 April 2007

• 02:13   Re: Split String Into Multiple Records Tom Lane
• 02:18   Re: Split String Into Multiple Records Aaron Bono

23 April 2007

• 04:19   Re: Floating point type to store numbers Lew
• 04:19   Retrieve month from date in SQl query RPK
• 04:19   Regular Expression Data Type Richard Doust
• 04:19   Windows postgres Senthil
• 04:20   i have prolem can you help me saytinh
• 04:35   Re: Windows postgres Paul Lambert
• 06:47   Re: We all are looped on Internet: request +transport = invariant Bart Degryse
• 07:00   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Bart Degryse
• 07:41   Re: Retrieve month from date in SQl query Michael Fuhr
• 08:18   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 10:18   Re: We all are looped on Internet: request+transport = invariant Bart Degryse
• 11:57   Re: We all are looped on Internet: request + transport = invariant Joe
• 15:10   plperlu hash problem Bart Degryse
• 23:12   Large journal as psql table. Good idea? Triggering. Bryce Nesbitt
• 23:27   Large journal as psql table. Good idea? Triggering. Phillip Smith

24 April 2007

• 00:56   Re: Large journal as psql table. Good idea? Triggering. chester c young
• 11:55   Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 11:57   Fwd: Re[2]: We all are looped on Internet: request+transport = invariant Dmitry Turin
• 11:58   Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 12:12   How to get text representation of composite value? David Flegl
• 12:28   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 12:32   Re: Fwd: Re[2]: We all are looped on Internet:request+transport = invariant Dmitry Turin
• 12:39   hi Penchalaiah P.
• 12:43   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Richard Huxton
• 12:45   Re: hi Wilkinson, Jim
• 13:07   Re: hi David Flegl
• 13:56   Re: We all are looped on Internet: request + transport = invariant Joe
• 14:46   Re: hi Ragnar
• 15:55   Re: Function to return a multiple colmn table or view Richard Huxton
• 16:41   Re: hi Stephan Szabo
• 21:00   plpgsql array looping Richard Albright

25 April 2007

• 01:26   Query Join Performance Aaron Bono
• 04:47   Re: hi saji varghese
• 05:16   Re: hi Phillip Smith
• 07:47   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 08:55   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Richard Huxton
• 09:02   Which function transform x,y to latitude/longitude? Nemo Terry
• 09:34   Re: We all are looped on Internet: request + transport = invariant Joe
• 13:38   Re: plpgsql array looping John DeSoi
• 13:54   Re: plpgsql array looping Richard Albright
• 14:17   Re: Which function transform x,y to latitude/longitude? Michael Fuhr
• 18:02   Re: Query Join Performance Richard Huxton
• 18:10   sql wrapped plpgsql set returning function Richard Albright
• 18:32   Re: sql wrapped plpgsql set returning function Tom Lane
• 18:45   Re: sql wrapped plpgsql set returning function Richard Albright
• 19:36   Re: sql wrapped plpgsql set returning function Richard Albright
• 20:40   Re: Query Join Performance Aaron Bono
• 22:24   Re: Query Join Performance Tom Lane

26 April 2007

• 00:57   Re: Query Join Performance Aaron Bono
• 03:09   Re: Query Join Performance Alvaro Herrera
• 04:11   Re: Which function transform x,y to latitude/longitude? Nemo Terry
• 04:41   Add constraint for number of chars PostgreSQL Admin
• 05:25   Re: Add constraint for number of chars Tom Lane
• 07:07   plperlu hash problem Bart Degryse
• 08:29   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 08:31   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 08:33   Re: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 08:44   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Richard Huxton
• 09:33   Re: plperlu hash problem Richard Huxton
• 10:28   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 11:53   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Andrew Sullivan
• 12:09   Re: We all are looped on Internet: request + transport = invariant Joe
• 12:44   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Richard Huxton
• 16:58   Re: We all are looped on Internet: request + transport = invariant Adam Tauno Williams

27 April 2007

• 00:10   Selecting rows with "static" ordering Steve Midgley
• 00:28   Re: Selecting rows with "static" ordering Phillip Smith
• 00:35   Re: Selecting rows with "static" ordering chester c young
• 00:47   Re: Selecting rows with "static" ordering Aaron Bono
• 04:02   Re: Selecting rows with "static" ordering Peter Childs
• 13:42   Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin
• 14:12   Re: Selecting rows with "static" ordering Kevin Hunter

30 April 2007

• 14:06   Recursive query for Product Tree devil live
• 14:54   NEW to plpythonu function? David Flegl
• 23:59   Dynamic prepare possible in plpgsql? Collin Peters