pgsql-sql since 2005-06-03 00:00

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 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
PostgreSQL and Delphi 6 Postgres Admin 03:49
SELECT with sum on groups ORDERING by the subtotals grupos 03:56
Re: SELECT with sum on groups ORDERING by the subtotals Gnanavel Shanmugam 04:25
Re: PostgreSQL and Delphi 6 Postgres Admin 12:09
Function does not return, but gives error.. M.D.G. Lange 12:26
Re: Function does not return, but gives error.. Gnanavel Shanmugam 12:34
Re: Function does not return, but gives error.. M.D.G. Lange 12:39
Re: Function does not return, but gives error.. M.D.G. Lange 12:43
Re: Function does not return, but gives error.. Michael Fuhr 12:47
Re: [SQL] PostgreSQL and Delphi 6 grupos 12:54
Re: SELECT with sum on groups ORDERING by the subtotals grupos 13:07
Re: SELECT with sum on groups ORDERING by the subtotals Gnanavel Shanmugam 13:28
Re: [SQL] PostgreSQL and Delphi 6 grupos 13:29
Re: SELECT very slow Scott Marlowe 14:00
Re: funny update, say update 1, updated 1 added 2nd. Jim Buttafuoco 14:05
Re: SELECT very slow Thomas Kellerer 14:45
Re: cursor "<unnamed portal 1>" does not exist Andrew Sullivan 14:54
Re: [SQL] PostgreSQL and Delphi 6 grupos 15:04
Re: SELECT with sum on groups ORDERING by the subtotals grupos 15:10
Re: SELECT very slow PFC 15:29
Re: SELECT very slow Thomas Kellerer 15:33
Re: [SQL] PostgreSQL and Delphi 6 Din Adrian 17:11
Re: [SQL] Returning a Cross Tab record set from a function Marc Wrubleski 17:16
Re: SELECT with sum on groups ORDERING by the subtotals Greg Sabino Mullane 19:01
UPDATEABLE VIEWS ... Examples? Marc G. Fournier 21:05
Re: PostgreSQL and Delphi 6 Din Adrian 22:31
Re: [SQL] PostgreSQL and Delphi 6 Din Adrian 23:11
Re: [SQL] PostgreSQL and Delphi 6 Din Adrian 23:38

June 17, 2005

Thread Author Time
Re: UPDATEABLE VIEWS ... Examples? elein 01:04
Re: UPDATEABLE VIEWS ... Examples? Dmitri Bichko 01:33
Re: UPDATEABLE VIEWS ... Examples? Michael Fuhr 02:07
Still getting autoreplies from list member Michael Fuhr 03:16
Re: Still getting autoreplies from list member Dmitri Bichko 03:30
Re: Still getting autoreplies from list member Kenneth Gonsalves 03:53
Putting an INDEX on a boolean field? Marc G. Fournier 04:14
Re: Putting an INDEX on a boolean field? David Dick 04:35
Re: Putting an INDEX on a boolean field? Tom Lane 04:41
Re: Putting an INDEX on a boolean field? Marc G. Fournier 05:04
Re: Putting an INDEX on a boolean field? Jaime Casanova 05:42
substr or char_length problem Fatih Cerit 10:01
Re: [despammed] substr or char_length problem Andreas Kretschmer 10:25

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