pgsql-sql since 2005-06-07 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 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
Re: Putting an INDEX on a boolean field? Erik Aronesty 10:40
Re: substr or char_length problem Michael Fuhr 12:06
how can i UPDATE without dead rows 📎 csepinek 13:08
Re: UPDATEABLE VIEWS ... Examples? Bricklen Anderson 14:54
Re: how can i UPDATE without dead rows Richard Huxton 16:09
Re: SELECT with sum on groups ORDERING by the subtotals grupos 17:15

June 18, 2005

Thread Author Time
partial index on non default tablespace syntax Rajesh Kumar Mallah 16:54
Re: partial index on non default tablespace syntax Michael Fuhr 17:27
Re: partial index on non default tablespace syntax Tom Lane 17:40

June 19, 2005

Thread Author Time
Re: partial index on non default tablespace syntax Rajesh Kumar Mallah 06:21
Re: [SQL] Set Membership operator -- test group membership Oleg Bartunov 08:48
Re: Dynamic PL/pgSQL PFC 10:36
Re: Looking for info on 8.1 features, and some examples Michael Fuhr 14:27
Re: WHY transaction waits for another transaction? Tom Lane 15:05
Re: WHY transaction waits for another transaction? Michael Fuhr 15:58
Re: WHY transaction waits for another transaction? Michael Fuhr 16:22
Re: Putting an INDEX on a boolean field? Tom Lane 18:46

June 20, 2005

Thread Author Time
accessing database without a persistent connection mohammad izwan ibrahim 03:11
Re: accessing database without a persistent connection Michael Fuhr 04:37
Re: AYUDA CON LA INSTALACION DEL POSTGRESQL Nahum Castro 04:37
Re: UPDATEABLE VIEWS ... Examples? David Pradier 07:16
Re: UPDATEABLE VIEWS ... Examples? Jaime Casanova 07:24
Re: UPDATEABLE VIEWS ... Examples? David Pradier 07:27
Re: UPDATEABLE VIEWS ... Examples? Michael Glaesemann 07:37
Re: UPDATEABLE VIEWS ... Examples? David Pradier 07:56
FW: help with serial Luca Rasconi 09:33
info Luca Rasconi 09:45
Re: [despammed] info Andreas Kretschmer 09:57
Re: info Richard Huxton 10:08
Re: FW: help with serial Richard Huxton 10:10
Re: info Theodore Petrosky 12:29
SQL repr of bytea val Markus Bertheau ☭ 13:47
Array in plpgsql with composite type grupos 16:31
Re: UPDATEABLE VIEWS ... Examples? Din Adrian 20:49
Re: Array in plpgsql with composite type Michael Fuhr 23:36

June 21, 2005

Thread Author Time
Re: SQL repr of bytea val Michael Fuhr 00:12
SELECT INTO returning more than one row Zac 09:54
customising serial type Kenneth Gonsalves 10:01
Re: customising serial type Krasimir Dimitrov 10:07
Re: customising serial type Michael Glaesemann 10:23
ENUM like data type MRB 15:20
Re: customising serial type Stefan Becker 16:34

June 22, 2005

Thread Author Time
Re: scroll cursor bug or me? Sim Zacks 08:22
cross-table reference Mukesh Ghatiya 09:26
Alias to a type Veikko Mäkinen 11:27
Re: Alias to a type Achilleus Mantzios 11:42
Re: Alias to a type Sean Davis 12:04
Re: Alias to a type Richard Huxton 12:07
Re: Alias to a type Achilleus Mantzios 12:14
Re: Alias to a type Bruno Wolff III 12:18
Re: Alias to a type Veikko Mäkinen 13:14
Re: Alias to a type KÖPFERL Robert 14:42
after delete trigger behavior Russell Simpkins 16:06

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