pgsql-sql - June 2005

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 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

June 1, 2005

Thread Author Time
Re: Sum() rows Mark Dilger 01:09
Re: Sum() rows Mark Dilger 01:43
Re: Multiple SRF parameters from query Ramakrishnan Muralidharan 04:59
plpgsql dynamic record access 📎 Ganesh 06:54
Re: Sum() rows lucas 11:49
Unique keys on views dklugmann 11:58
Re: Sum() rows lucas 12:27
View unique rowid David Klugmann 13:53
Returning a Cross Tab record set from a function Marc Wrubleski 14:14
Re: View unique rowid Rafa Couto 14:53
Re: View unique rowid David Klugmann 15:17
Re: View unique rowid Achilleus Mantzios 15:21
How do write a query... Alain Reymond 16:00
Re: Sum() rows Bruno Wolff III 17:00
unsubscribe Cordova Juillerat Jorge Alejandro 17:28
unsubscribe Ing. Jhon Carrillo - Caracas, Venezuela 17:35
Release feature Marx Barbosa 19:56
Re: Release feature Jaime Casanova 20:05
Convert int to hex Fernando Grijalba 20:42

June 2, 2005

Thread Author Time
index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey 07:04
Re: Convert int to hex Richard Huxton 07:14
Re: Convert int to hex Ramakrishnan Muralidharan 09:17
Re: [SQL] index row size 2728 exceeds btree maximum, 2713 Ramakrishnan Muralidharan 09:40
Re: index row size 2728 exceeds btree maximum, 2713 Richard Huxton 09:58
Re: Convert int to hex Fernando Grijalba 10:04
Re: [SQL] index row size 2728 exceeds btree maximum, 2713 Martijn van Oosterhout 10:12
Re: [SQL] index row size 2728 exceeds btree maximum, 2713 Richard Huxton 10:43
Re: [SQL] index row size 2728 exceeds btree maximum, 2713 Ramakrishnan Muralidharan 11:13
plpgsql and triggers Bart Degryse 11:57
Re: [SQL] index row size 2728 exceeds btree maximum, 27 KÖPFERL Robert 12:08
Re: [SQL] index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey 12:18
Re: index row size 2728 exceeds btree maximum, 27 Bruno Wolff III 12:31
Re: index row size 2728 exceeds btree maximum, 2713 Bruno Wolff III 12:35
Re: [SQL] index row size 2728 exceeds btree maximum, 27 Richard Huxton 12:40
getting details about integrity constraint violation Markus Bertheau 15:25
Splitting a table for performance reasons KÖPFERL Robert 15:33
Re: [SQL] index row size 2728 exceeds btree maximum, 27 Jaime Casanova 15:48
Re: getting details about integrity constraint violation Tom Lane 16:32
Re: [SQL] index row size 2728 exceeds btree maximum, 27 Bruno Wolff III 16:35
Re: [SQL] index row size 2728 exceeds btree maximum, 27 Richard Huxton 17:00
Re: [SQL] index row size 2728 exceeds btree maximum, 27 Bruno Wolff III 19:33

June 3, 2005

Thread Author Time
Re: [SQL] index row size 2728 exceeds btree maximum, 27 Richard Huxton 07:22
Re: getting details about integrity constraint violation KÖPFERL Robert 08:00
Re: getting details about integrity constraint violation Markus Bertheau ☭ 09:00
'true'::TEXT::BOOLEAN Markus Bertheau ☭ 10:07
Re: 'true'::TEXT::BOOLEAN Achilleus Mantzios 11:20
Re: 'true'::TEXT::BOOLEAN Achilleus Mantzios 11:45
Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭ 11:52
Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭ 12:03
Re: 'true'::TEXT::BOOLEAN Michael Glaesemann 12:14
Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭ 12:23
Re: 'true'::TEXT::BOOLEAN Michael Glaesemann 12:28
Re: 'true'::TEXT::BOOLEAN Achilleus Mantzios 12:46
Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭ 13:07
CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END Markus Bertheau ☭ 13:17
Re: 'true'::TEXT::BOOLEAN doesn't work Markus Bertheau ☭ 13:43
Re: 'true'::TEXT::BOOLEAN Tom Lane 13:47
Re: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END Tom Lane 14:16
using a selected row as a function parameter Ami Ganguli 14:44
Re: 'true'::TEXT::BOOLEAN Bruno Wolff III 15:11
Re: using a selected row as a function parameter Tom Lane 15:15
Re: using a selected row as a function parameter Michael Fuhr 15:23
Re: 'true'::TEXT::BOOLEAN Tom Lane 15:28
Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭ 15:36
Re: 'true'::TEXT::BOOLEAN Bruno Wolff III 15:36
Re: getting details about integrity constraint violation PFC 18:42

June 4, 2005

Thread Author Time
Tsearch2 headline usage Rajesh Kumar Mallah 11:26
Re: Multiple SRF parameters from query Federico Pedemonte 16:19
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Bruce Momjian 17:52
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Joe Conway 21:01
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Bruce Momjian 22:52

June 5, 2005

Thread Author Time
Re: Multiple SRF parameters from query Michael Fuhr 00:52

June 6, 2005

Thread Author Time
Re: plpgsql and triggers Michael Fuhr 02:30
Re: How do write a query... KÖPFERL Robert 10:06
how to store more than 3 MB of character data in Postgres Varchar field Vadivel Subramaniam 10:17
Re: Returning a Cross Tab record set from a function KÖPFERL Robert 10:20
Re: how to store more than 3 MB of character data in Postgres Richard Huxton 10:48
Re: how to store more than 3 MB of character data in Postgres Richard Huxton 11:46
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Markus Bertheau ☭ 14:17
Re: how to store more than 3 MB of character data in Postgres Varchar field Tom Lane 14:31
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Tom Lane 14:44
Re: What is faster? Richard Huxton 14:45
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {} Markus Bertheau ☭ 14:54
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Joe Conway 15:39
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {} Joe Conway 15:50
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. Joe Conway 15:58
Re: What is faster? Richard Huxton 16:09
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] Markus Bertheau ☭ 16:12
Re: How do write a query... Bruno Wolff III 16:21
What is faster? ON.KG 16:25
SQL equivalent to nested loop Markus Bertheau ☭ 16:52
Re: What is faster? ON.KG 17:02
Re: SQL equivalent to nested loop KÖPFERL Robert 18:08
Re: SQL equivalent to nested loop Markus Bertheau 23:16

June 7, 2005

Thread Author Time
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. Joe Conway 01:24
preventing deletion of a row Kenneth Gonsalves 05:29
datestyle syntax Kenneth Gonsalves 05:31
Re: preventing deletion of a row Nick Johnson 05:59
large object support in PostGres 7.4 Vadivel Subramaniam 06:20
Re: What is faster? Achilleus Mantzios 06:40
Re: large object support in PostGres 7.4 Volkan YAZICI 06:41
Re: preventing deletion of a row Kenneth Gonsalves 06:43
to listadmin Kenneth Gonsalves 07:00
Re: What is faster? ON.KG 07:28
Re: to listadmin Richard Huxton 08:05
Re: to listadmin Kenneth Gonsalves 08:24
Re: to listadmin Achilleus Mantzios 08:29
Re: SQL equivalent to nested loop KÖPFERL Robert 08:58
Can we stop that? KÖPFERL Robert 09:26
rule or trigger? M.D.G. Lange 10:28
Re: rule or trigger? Stephan Szabo 13:54
Re: to listadmin Tom Lane 14:36
Re: rule or trigger? Richard Huxton 15:41
Re: to listadmin Bruno Wolff III 20:06

June 8, 2005

Thread Author Time
Experience with splitting a Table transparently KÖPFERL Robert 10:30
Cursor need it? Lucas Hernndez 14:44
Re: How do write a query... Bruno Wolff III 14:47
Re: Cursor need it? KÖPFERL Robert 15:23
access to new/old in dynamic sql for audit table Jay Parker 15:54
Re: access to new/old in dynamic sql for audit table Tom Lane 16:27
Re: plpgsql dynamic record access Rajesh Kumar Mallah 17:20
Rule David Hofmann 19:51
Re: Rule Bruno Wolff III 20:06
Re: Rule David Hofmann 20:53
SELECT very slow Thomas Kellerer 21:46
Re: Rule Keith Worthington 21:50
[Fwd: RE: Re: Rule] Keith Worthington 22:44

June 9, 2005

Thread Author Time
Re: SELECT very slow Tom Lane 00:06
Re: SELECT very slow Alain 01:13
Indices and user defined operators Dmitri Bichko 02:23
Re: Indices and user defined operators Tom Lane 04:01
Re: Indices and user defined operators Tom Lane 05:27
Re: SELECT very slow Thomas Kellerer 06:56
Re: SELECT very slow Thomas Kellerer 06:58
rejecting characters in a field Kenneth Gonsalves 07:06
Re: rejecting characters in a field Gnanavel Shanmugam 07:15
Re: [despammed] rejecting characters in a field Andreas Kretschmer 07:18
Re: [despammed] rejecting characters in a field Michael Glaesemann 07:23
Re: Indices and user defined operators Richard Huxton 07:27
Re: SELECT very slow Volkan YAZICI 07:31
Re: [despammed] rejecting characters in a field Bruno Wolff III 08:29
Re: [despammed] rejecting characters in a field Andreas Kretschmer 08:39
Re: SELECT very slow Thomas Kellerer 11:30

June 10, 2005

Thread Author Time
Permission denied for language pltclu Dinesh Pandey 07:10
Re: [SQL] Permission denied for language pltclu Michael Glaesemann 07:28
Re: [SQL] Permission denied for language pltclu Dinesh Pandey 07:33
Re: [SQL] Permission denied for language pltclu Richard Huxton 08:28
Re: [SQL] Permission denied for language pltclu Dinesh Pandey 08:38
Re: [SQL] Permission denied for language pltclu Michael Glaesemann 09:02
Re: [SQL] Permission denied for language pltclu Richard Huxton 09:11
Re: [SQL] Permission denied for language pltclu Dinesh Pandey 09:34
Re: [SQL] Permission denied for language pltclu Dinesh Pandey 09:51
How-to suggestions to views KÖPFERL Robert 10:12
Re: [SQL] Permission denied for language pltclu Richard Huxton 10:16
Re: [SQL] Permission denied for language pltclu Michael Glaesemann 10:26
Re: [SQL] Permission denied for language pltclu Sean Davis 10:31
Re: [SQL] Permission denied for language pltclu Michael Glaesemann 10:32
Re: [SQL] Permission denied for language pltclu Tino Wildenhain 10:37
Re: [SQL] Permission denied for language pltclu Dinesh Pandey 10:45
Re: [SQL] Permission denied for language pltclu Richard Huxton 10:51
Re: [SQL] Permission denied for language pltclu Tino Wildenhain 11:09
Re: [SQL] Permission denied for language pltclu Tino Wildenhain 11:10

June 11, 2005

Thread Author Time
Re: How do write a query... Mischa Sandberg 03:35

June 12, 2005

Thread Author Time
Looking for info on 8.1 features, and some examples Larry Meadors 04:23
predicate locking Daniel Roth 10:39
Re: predicate locking Tom Lane 15:04
AYUDA CON LA INSTALACION DEL POSTGRESQL Steph Frias 20:56

June 13, 2005

Thread Author Time
Re: predicate locking Daniel Roth 02:16
Re: predicate locking Tom Lane 03:04
Re: duplicate key violates unique constraint Richard Huxton 14:43
Re: duplicate key violates unique constraint Csaba Nagy 14:45
Re: duplicate key violates unique constraint Csaba Nagy 15:22
Re: duplicate key violates unique constraint Richard Huxton 15:49
Re: duplicate key violates unique constraint Csaba Nagy 15:58
Re: duplicate key violates unique constraint Richard Huxton 16:03
duplicate key violates unique constraint ON.KG 16:22
Re: Aggregate Functions Template postgres 21:52

June 14, 2005

Thread Author Time
Re: getting details about integrity constraint violation Greg Sabino Mullane 03:39
Spam Re: read it immediately 📎 alessio 05:38
Re: getting details about integrity constraint violation Markus Bertheau 05:46
WHY transaction waits for another transaction? Vilinski Vladimir 11:12
foreign key on pg_shadow M.D.G. Lange 11:34
Re: SELECT very slow PFC 12:26
Re: foreign key on pg_shadow Tom Lane 13:37
Set Membership operator -- test group membership Sophie Yang 19:08
Re: Set Membership operator -- test group membership Igor Katrayev 19:27

June 15, 2005

Thread Author Time
Re: getting details about integrity constraint violation Greg Sabino Mullane 02:06
update syntax Praveen Raja 11:39
Converting varchar to bool KÖPFERL Robert 12:14
Re: update syntax Bruno Prévost 12:22
Re: update syntax Praveen Raja 12:35
Re: update syntax Bruno Prévost 12:49
Re: Converting varchar to bool Bruno Wolff III 14:31
Re: update syntax Bruno Wolff III 14:34
Re: SELECT very slow Thomas Kellerer 18:05
Re: SELECT very slow PFC 20:04
Re: SELECT very slow Thomas Kellerer 22:08
Dynamic PL/pgSQL Ruediger Herrmann 22:10
cursor "<unnamed portal 1>" does not exist Vsevolod (Simon) Ilyushchenko 22:45

June 16, 2005

Thread Author Time
funny update, say update 1, updated 1 added 2nd. Neil Dugan 03:38

Browse Archives

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