pgsql-sql - August 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 6 7 8 9 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 1, 2007

Thread Author Time
could not [extend relation|write block N of temporary file|write to hash-join temporary file] Alessandra Bilardi 09:41
How do I connect postgres table structures and view structures to an existing svn repository? John Mitchell 14:07
Re: How do I connect postgres table structures and view structures to an existing svn repository? D'Arcy J.M. Cain 15:38
Re: How do I connect postgres table structures and view structures to an existing svn repository? John Mitchell 15:45
Re: How do I connect postgres table structures and view structures to an existing svn repository? D'Arcy J.M. Cain 16:14
Re: How do I connect postgres table structures and view structures to an existing svn repository? Scott Marlowe 16:46
Re: How do I connect postgres table structures and view structures to an existing svn repository? D'Arcy J.M. Cain 18:17
Re: How do I connect postgres table structures and view structures to an existing svn repository? Erik Jones 20:37
Authentification failed Judith 21:19

Aug. 2, 2007

Thread Author Time
Re: Authentification failed chester c young 00:48
Re: Authentification failed Scott Marlowe 00:52
Re: Alternative to INTERSECT Luiz K. Matsumura 01:46
GiST index implementation Elena Camossi 14:02
Foreign Key inter databases Dani Castaños 16:18
Re: Foreign Key inter databases Josh Tolley 19:23

Aug. 3, 2007

Thread Author Time
Re: Authentification failed Kenneth Gonsalves 01:15
Count of rows Paul Lambert 05:35
Re: Count of rows Christian Kindler 07:20
Re: Foreign Key inter databases Dani Castaños 07:24
Increment a sequence by more than one Steve Midgley 16:50
Re: Increment a sequence by more than one Michael Glaesemann 17:26
Re: Increment a sequence by more than one Scott Marlowe 19:01
Re: Increment a sequence by more than one Steve Midgley 19:28
Re: Increment a sequence by more than one Scott Marlowe 19:42
Re: Increment a sequence by more than one Scott Marlowe 19:45
Re: Foreign Key inter databases Erik Jones 19:50
Re: Increment a sequence by more than one Erik Jones 20:27
Re: Increment a sequence by more than one Michael Glaesemann 20:31
Re: Increment a sequence by more than one Michael Glaesemann 20:33
Race condition in resetting a sequence Steve Midgley 20:56

Aug. 4, 2007

Thread Author Time
Re: Race condition in resetting a sequence Tom Lane 00:01
Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file] Tom Lane 15:38
Re: Race condition in resetting a sequence Lew 19:33

Aug. 6, 2007

Thread Author Time
Re: Increment a sequence by more than one Peter Childs 07:00
Best Fit SQL query statement Kiran 08:57
Re: Increment a sequence by more than one Steve Midgley 12:20
Re: Best Fit SQL query statement Rodrigo De León 15:15
Using function like where clause Ranieri Mazili 19:44
Using function like where clause Ranieri Mazili 19:44
Re: [SQL] Using function like where clause Michael Glaesemann 19:57

Aug. 7, 2007

Thread Author Time
Restricting columns by users Ranieri Mazili 13:41
Adding NOT NULL columns in PostgreSQL 7.4? Michael Eshom 16:54
Range of caracters Wilton Wonrath 17:07
Re: Adding NOT NULL columns in PostgreSQL 7.4? Michael Glaesemann 17:49
Re: Range of caracters Ragnar 18:18
Re: [SQL] Using function like where clause Ragnar 18:20
Re: [SQL] Restricting columns by users Andrej Ricnik-Bay 18:27
Re: Using function like where clause Kev 19:18

Aug. 8, 2007

Thread Author Time
populate value of column novice 05:30
Re: populate value of column Phillip Smith 05:37
Re: populate value of column Michael Glaesemann 05:40
Re: populate value of column novice 05:50
Implementing an regex filter Enrico Weigelt 12:16
Re: Converting from MS Access field aliases Enrico Weigelt 12:28
Performance on writable views Enrico Weigelt 12:40
Re: Database synchronization Enrico Weigelt 13:15
Re: Implementing an regex filter Paul Lambert 22:13

Aug. 9, 2007

Thread Author Time
pg_trgm installation Arindam Hore 06:23
Indexing a field of type point David Cottingham 13:02
Indexing a field of type point David Cottingham 14:01
Re: Indexing a field of type point Tom Lane 17:33
PG won't use index on ORDER BY <expression> Andreas Joseph Krogh 18:18
Re: PG won't use index on ORDER BY <expression> Gregory Stark 20:00
Re: PG won't use index on ORDER BY <expression> Andreas Joseph Krogh 20:38
Re: PG won't use index on ORDER BY <expression> Rodrigo De León 20:57
Re: PG won't use index on ORDER BY <expression> Andreas Joseph Krogh 21:10
Re: PG won't use index on ORDER BY <expression> Andreas Joseph Krogh 22:15
Re: PG won't use index on ORDER BY <expression> Tom Lane 23:35

Aug. 10, 2007

Thread Author Time
Re: PG won't use index on ORDER BY <expression> Tom Lane 01:35
Re: PG won't use index on ORDER BY <expression> Gregory Stark 03:10
Returnd Refcurser (<unnamed portal x> not fetchable Christian Kindler 05:57
Re: Returnd Refcurser (<unnamed portal x> not fetchable Penchalaiah P. 06:05
Re: Returnd Refcurser (<unnamed portal x> not fetchable Christian Kindler 06:16
Re: Returnd Refcurser (<unnamed portal x> not fetchable Tom Lane 06:26
Re: Returnd Refcurser (<unnamed portal x> not fetchable Michael Fuhr 06:31
Re: Returnd Refcurser (<unnamed portal x> not fetchable Christian Kindler 06:35
Re: Best Fit SQL query statement hubert depesz lubaczewski 07:59
Re: [SQL] Using function like where clause hubert depesz lubaczewski 08:00
Join optimization Pablo Barrón 09:51
Install two different versions of postgres which should run in parallel Loredana Curugiu 11:33
Re: [NOVICE] Install two different versions of postgres which should run in parallel Sean Davis 11:46
Re: Install two different versions of postgres which should run in parallel Giuseppe Sacco 12:44
Index usage in order by with multiple columns in order-by-clause Andreas Joseph Krogh 14:53
Re: Install two different versions of postgres which should run in parallel Gerardo Herzig 15:11
Re: [SQL] Install two different versions of postgres which should run in parallel Scott Marlowe 15:21
Re: [NOVICE] Install two different versions of postgres which should run in parallel Oliver Elphick 16:12
Re: Best Fit SQL query statement Fernando Hevia 19:40
Re: Race condition in resetting a sequence Scott Marlowe 21:00
Re: Index usage in order by with multiple columns in order-by-clause Tom Lane 21:30
foreign key pointing to diff schema? gherzig 22:15
Re: foreign key pointing to diff schema? Scott Marlowe 22:23
Re: foreign key pointing to diff schema? gherzig 22:37
Re: Best Fit SQL query statement hubert depesz lubaczewski 22:59

Aug. 11, 2007

Thread Author Time
Re: Best Fit SQL query statement Rodrigo De León 01:13
Re: Performance on writable views Heikki Linnakangas 07:42
Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 07:43
Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 07:45
Re: Trigger Procedure Error: NEW used in query that is not in a rule Pavel Stehule 08:16
Re: Best Fit SQL query statement hubert depesz lubaczewski 09:06
Re: Index usage in order by with multiple columns in order-by-clause Andreas Joseph Krogh 09:22
Re: Performance on writable views Joshua D. Drake 13:58
Re: Trigger Procedure Error: NEW used in query that is not in a rule Tom Lane 15:50
Re: Trigger Procedure Error: NEW used in query that is not in a rule Pavel Stehule 16:10
Re: Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 18:45
Re: Index usage in order by with multiple columns in order-by-clause hubert depesz lubaczewski 19:05
Re: Trigger Procedure Error: NEW used in query that is not in a rule hubert depesz lubaczewski 19:07
Re: Index usage in order by with multiple columns in order-by-clause Andreas Joseph Krogh 19:45
Re: Index usage in order by with multiple columns in order-by-clause Tom Lane 19:55
Re: Index usage in order by with multiple columns in order-by-clause Andreas Joseph Krogh 20:14

Aug. 12, 2007

Thread Author Time
Re: Trigger Procedure Error: NEW used in query that is not in a rule Lew 11:33

Aug. 13, 2007

Thread Author Time
Re: Install two different versions of postgres which should run in parallel Loredana Curugiu 08:19
Re: Install two different versions of postgres which should run in parallel Giuseppe Sacco 09:11
Re: Install two different versions of postgres which should run in parallel Gerardo Herzig 13:14
Re: [NOVICE] Install two different versions of postgres which should run in parallel Tom Lane 13:37
Comparing two slices within one table efficiently Ken Simpson 17:58
Re: Comparing two slices within one table efficiently chester c young 18:45
Re: Comparing two slices within one table efficiently Andrew Kroeger 19:25
how to moce back in refcursor Christian Kindler 19:29
Re: Comparing two slices within one table efficiently Christian Kindler 19:34
Re: Comparing two slices within one table efficiently Tom Lane 19:37
Re: Comparing two slices within one table efficiently Ken Simpson 19:42
Re: how to moce back in refcursor Tom Lane 19:55
Getting pk of the most recent row, in a group by Bryce Nesbitt 20:05
Re: Getting pk of the most recent row, in a group by Rodrigo De León 20:16
Re: Getting pk of the most recent row, in a group by Michael Glaesemann 20:19
Re: Performance on writable views Jim Nasby 22:17
Re: Getting pk of the most recent row, in a group by Terry Fielder 23:19

Aug. 14, 2007

Thread Author Time
Re: how to move back in refcursor Christian Kindler 06:17
Re: [NOVICE] Install two different versions of postgres which should run in parallel Loredana Curugiu 07:37
Re: Authentification failed Bryce Nesbitt 08:30
Re: Authentification failed Terry Fielder 11:40
Re: Best Fit SQL query statement Fernando Hevia 13:59
When is a shared library unloaded? Jon Horsman 18:42
Re: When is a shared library unloaded? Tom Lane 19:34

Aug. 15, 2007

Thread Author Time
Re: populate value of column Phillip Smith 03:15
Re: Install two different versions of postgres which should run in parallel Markus Schaber 11:58
Re: [JDBC] Install two different versions of postgres which should run in parallel Loredana Curugiu 12:42
Re: When is a shared library unloaded? Jon Horsman 13:16
Re: Trigger Procedure Error: NEW used in query that is not in a rule Decibel! 18:28
Boolean without default declared Jon Collette 18:46
Re: Boolean without default declared Richard Broersma Jr 19:23
Re: Boolean without default declared Richard Broersma Jr 19:36
Problem with phone list. Mike Diehl 20:28
Re: Problem with phone list. Rodrigo De León 20:49
Re: Problem with phone list. Fernando Hevia 20:58
Re: Problem with phone list. Richard Broersma Jr 21:00
Re: Problem with phone list. Michael Glaesemann 21:04
Re: Boolean without default declared Tom Lane 21:48

Aug. 16, 2007

Thread Author Time
Re: Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 00:05
Re: Problem with phone list. Mike Diehl 06:11
Re: [SQL] Embedded C++ with ecpg? Jean-David Beyer 13:05
Starting autovacuum in postgresql-8.1.9 Jean-David Beyer 13:20
Re: Starting autovacuum in postgresql-8.1.9 Alvaro Herrera 13:28
Re: Problem with phone list. Fernando Hevia 13:56
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Michael Glaesemann 15:35
SUPERUSER vs CREATEUSER causes foul 'code smell' Joshua_Kramer 15:36
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Rodrigo De León 15:41
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Peter Eisentraut 15:47
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Tom Lane 16:43

Aug. 17, 2007

Thread Author Time
Limited number of polygon function arguments Franz Mühlbauer 17:07
Sequences problem Judith 21:33
Re: Sequences problem Andrew Sullivan 21:49
Re: Sequences problem Scott Marlowe 21:50

Aug. 18, 2007

Thread Author Time
Re: Limited number of polygon function arguments Tom Lane 05:15
Join query help novice 05:35
Join query help Raj A 06:11
Re: Limited number of polygon function arguments Franz Mühlbauer 09:26
there is already a transaction in progress ? Jean-David Beyer 12:16
Re: there is already a transaction in progress ? Jean-David Beyer 16:36

Aug. 20, 2007

Thread Author Time
TRIGGERS and FUNCTIONS ashok raj 04:56
Re: TRIGGERS and FUNCTIONS Richard Broersma Jr 11:21
Re: When is a shared library unloaded? Jon Horsman 15:47

Aug. 21, 2007

Thread Author Time
Re: Join query help novice 00:52
Re: Join query help Michael Glaesemann 01:04
Re: Join query help novice 01:21
Re: Join query help Michael Glaesemann 01:27
Re: Join query help novice 01:33
Re: [SQL] Join query help Michael Glaesemann 01:35
Re: Join query help Michael Glaesemann 01:36
wrong answer A. R. Van Hook 13:09
Re: wrong answer Richard Huxton 13:23
Join question tyrrill_ed 17:48
Re: Join question Richard Broersma Jr 19:16
Re: Join question Richard Broersma Jr 19:18
SELECT syntax synopsis: column_definition? Richard Broersma Jr 19:34
Re: Join question Michael Glaesemann 21:16
Make a SQL statement not run trigger Jon Collette 21:26
Re: Make a SQL statement not run trigger Rodrigo De León 21:51
Re: Make a SQL statement not run trigger Jon Collette 22:04
Re: Make a SQL statement not run trigger Scott Marlowe 22:07
Re: Make a SQL statement not run trigger Thomas Kellerer 22:24
Re: Make a SQL statement not run trigger Jon Collette 22:44
Re: Make a SQL statement not run trigger Jon Collette 22:49
Re: Make a SQL statement not run trigger Scott Marlowe 23:01
Re: SELECT syntax synopsis: column_definition? Michael Glaesemann 23:04
Re: SELECT syntax synopsis: column_definition? Michael Glaesemann 23:17
Re: SELECT syntax synopsis: column_definition? Gregory Stark 23:53

Aug. 22, 2007

Thread Author Time
Re: SELECT syntax synopsis: column_definition? Scott Marlowe 01:42
Re: SELECT syntax synopsis: column_definition? Alvaro Herrera 01:55
Re: SELECT syntax synopsis: column_definition? Richard Broersma Jr 03:10

Browse Archives

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