pgsql-sql - April 2007

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 16 17 18 19 20 21 22 23 24 25 26 27 30

April 1, 2007

Thread Author Time
Sequence vs Serial Daniel CAUNE 04:01
Re: Sequence vs Serial Scott Marlowe 07:58
Re: Sequence vs Serial Tom Lane 18:51

April 2, 2007

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

April 3, 2007

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

April 4, 2007

Thread Author Time
Re: [SQL] exception handling in postgres plpgsql Tom Lane 00:24
Re: plpgsql function question A. Kretschmer 05:01
Moving a simple function to pl/pgsql (Novice question) Paul Lambert 06:19
Generating dates prior to generate_series Roger Tannous 12:00
Re: plpgsql function question John DeSoi 12:19
CPU statistics ezequias 12:36
Setting high performance on huge server ezequias 12:49
Re: Setting high performance on huge server Claus Guttesen 12:55
Re: Moving a simple function to pl/pgsql (Novice question) Richard Broersma Jr 13:06
Re: exception handling in postgres plpgsql Igor Neyman 13:17
Solved - best way: diary functions. Gary Stainburn 13:27
Re: CPU statistics Peter Eisentraut 13:54
Re: CPU statistics Jonah H. Harris 14:02
Re: Moving a simple function to pl/pgsql (Novice question) Paul Lambert 22:20

April 5, 2007

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

April 6, 2007

Thread Author Time
Re: Insert only if not found Shavonne Marietta Wijesinghe 07:10
Update Field with function/data from other tables? paallen 16:57
dropping a schema and cross-schema dependencies George Pavlov 22:09
Re: dropping a schema and cross-schema dependencies Tom Lane 23:39

April 7, 2007

Thread Author Time
Re: dropping a schema and cross-schema dependencies George Pavlov 00:05
rowcount function in postgres??? Karthikeyan Sundaram 17:33
Re: rowcount function in postgres??? Michael Fuhr 17:51
Re: [SQL] rowcount function in postgres??? Rodrigo De León 17:54
Re: rowcount function in postgres??? Uwe C. Schroeder 18:58

April 8, 2007

Thread Author Time
MD5 sums of large objects Dirk Jagdmann 17:03
Re: MD5 sums of large objects Michael Fuhr 17:37
Question on pgpsql function Karthikeyan Sundaram 19:47
Re: [SQL] Question on pgpsql function Adrian Klaver 20:22
Re: Question on pgpsql function Tom Lane 23:20

April 9, 2007

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

April 10, 2007

Thread Author Time
Question about undefinably query... A. Kretschmer 14:05
EXECUTE in a funtion to return a VIEW object ID Wilkinson, Jim 14:34
Re: Question about undefinably query... Tom Lane 14:46
Re: A long-running transaction John Summerfield 16:41
Re: A long-running transaction Andrew Sullivan 16:55
Replace string PostgreSQL Admin 20:40
Re: A long-running transaction John Summerfield 21:54

April 11, 2007

Thread Author Time
update from and left join Tomasz Myrta 07:06
Re: A long-running transaction Andrew Sullivan 13:34
Re: A long-running transaction John Summerfield 14:23
Re: A long-running transaction Andrew Sullivan 15:49
Urgent help in bit_string data type Karthikeyan Sundaram 20:30
Re: [SQL] Urgent help in bit_string data type Joe 21:44
Re: [SQL] Urgent help in bit_string data type Karthikeyan Sundaram 22:01
Re: [SQL] Urgent help in bit_string data type Joe 23:00
Re: [SQL] Urgent help in bit_string data type Karthikeyan Sundaram 23:29

April 12, 2007

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

April 13, 2007

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

April 16, 2007

Thread Author Time
i have prolem can you help me saytinh 03:48
quesion on functions calling from php Karthikeyan Sundaram 22:58

April 17, 2007

Thread Author Time
Re: quesion on functions calling from php Tommy Gildseth 06:08
Floating point type to store numbers Radhika Sambamurti 18:53
Re: Floating point type to store numbers Andrew Sullivan 19:04
Re: Floating point type to store numbers Milen A. Radev 19:10
Re: Floating point type to store numbers Richard Broersma Jr 19:18
Re: Floating point type to store numbers Radhika Sambamurti 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 Andrew Sullivan 20:53
Re: Floating point type to store numbers Milen A. Radev 22:09

April 18, 2007

Thread Author Time
Windows postgres Senthil 08:42
Retrieve month from date in SQl query RPK 17:36
slowness when subselect uses DISTINCT Stuart McGraw 18:16
equiv of ascii() function for unicode? Stuart McGraw 18:16
Re: slowness when subselect uses DISTINCT Phillip Smith 22:43

April 19, 2007

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

April 20, 2007

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 16 17 18 19 20 21 22 23 24 25 26 27 30