pgsql-sql since 2007-07-24 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

July 24, 2007

Thread Author Time
Re: Database Synchronization Jyoti Seth 07:45
is there a 'table' data type in pg? Louis-David Mitterrand 12:42
Re: is there a 'table' data type in pg? Gregory Stark 14:10
Re: is there a 'table' data type in pg? Louis-David Mitterrand 14:23
Re: is there a 'table' data type in pg? Peter Childs 14:33
inheriting a rule or a trigger? Louis-David Mitterrand 14:37

July 25, 2007

Thread Author Time
Database synchronization Jyoti Seth 10:12
Re: Database synchronization Richard Huxton 10:24
Re: Database synchronization Jyoti Seth 10:40
Re: Database synchronization Richard Huxton 12:39
Assistance with a trigger Paul Lambert 22:29
Re: Assistance with a trigger chester c young 23:23

July 26, 2007

Thread Author Time
Re: Assistance with a trigger Paul Lambert 00:26
Re: Database synchronization Jyoti Seth 04:50
Re: The nested view from hell - Restricting a subquerry Bryce Nesbitt 07:30
How to cast, if type has spaces in the name Bryce Nesbitt 07:33
Re: How to cast, if type has spaces in the name A. Kretschmer 07:39
Re: How to cast, if type has spaces in the name A. Kretschmer 07:42
Tunning PostgreSQL performance for views on Windows Ranieri Mazili 14:26
Re: Tunning PostgreSQL performance for views on Windows Bill Moran 14:49
Re: How to cast, if type has spaces in the name Stephan Szabo 15:00
Re: Tunning PostgreSQL performance for views on Windows Harald Armin Massa 15:17

July 27, 2007

Thread Author Time
unique index on fields with possible null values Dmitry Ruban 00:59
Join question Paul Lambert 01:33
problem join chester c young 01:39
Re: Join question Phillip Smith 01:46
Re: Join question Phillip Smith 01:48
Re: Join question Paul Lambert 02:18
Re: unique index on fields with possible null values Tom Lane 02:49
Re: calling webservice through postgresql function Dmitry Turin 06:40
strange result for select * from table where id=random()*900 Stefan Zweig 07:48
Re: strange result for select * from table where id=random()*900 Tommy Gildseth 07:56
Re: strange result for select * from table where id=random()*900 Achilleas Mantzios 08:12
Re: strange result for select * from table where id=random()*900 Kristo Kaiv 09:23
Re: Tunning PostgreSQL performance for views on Windows Merlin Moncure 13:38
Re: problem join Osvaldo Rosario Kussama 15:47
group by range of values Carol Cheung 19:05
Re: group by range of values Jon Sime 19:25
Re: group by range of values Rodrigo De León 19:28
Re: group by range of values Pavel Stehule 19:30
Re: group by range of values Rodrigo De León 19:31
Re: group by range of values Michael Glaesemann 20:43

July 28, 2007

Thread Author Time
raise exception and transaction handling Marcin Krawczyk 20:54

July 29, 2007

Thread Author Time
Re: raise exception and transaction handling Michal Kedziora 11:33
increment the primary key value without using sequences roopa perumalraja 12:00
Re: increment the primary key value without using sequences Michael Glaesemann 13:37

July 30, 2007

Thread Author Time
Migration from SQLite Help (Left Join) Mitchell Vincent 02:28
Re: Migration from SQLite Help (Left Join) Nis Jørgensen 05:30
Re: raise exception and transaction handling Bart Degryse 08:07
hi Penchalaiah P. 08:11
Re: [SQL] Tunning PostgreSQL performance for views on Windows Lewis Cunningham 12:22
Connection Limit Jon Horsman 21:29
Table-name as parameter to plpgsql Andreas Joseph Krogh 21:35
Re: Connection Limit Jon Horsman 21:41
Re: Connection Limit Andrew Sullivan 21:51
Re: Connection Limit Scott Marlowe 22:20

July 31, 2007

Thread Author Time
Re: Table-name as parameter to plpgsql Milen A. Radev 00:34
alter table table add column Ronald Rojas 04:19
Re: [NOVICE] alter table table add column Michael Glaesemann 04:32
Re: [NOVICE] alter table table add column Ronald Rojas 05:23
Re: Migration from SQLite Help (Left Join) Tom Lane 05:34
Re: [NOVICE] alter table table add column Michael Glaesemann 05:56
Re: alter table table add column Oliver Elphick 06:25
Re: [NOVICE] alter table table add column Ronald Rojas 06:37
Re: [NOVICE] alter table table add column Peter Childs 07:54
Re: alter table table add column Nis Jørgensen 07:56
Re: Database synchronization Jyoti Seth 08:02
Re: Database synchronization Richard Huxton 08:22
Re: calling webservice through postgresql function Dmitry Turin 13:08
Re: Database synchronization Andrew Sullivan 13:36
Alternative to INTERSECT Andreas Joseph Krogh 17:30
Re: Alternative to INTERSECT Josh Trutwin 18:52
Re: Connection Limit Jon Horsman 19:06
Re: Alternative to INTERSECT Andreas Joseph Krogh 19:45
Re: Alternative to INTERSECT Rodrigo De León 20:30
Re: Alternative to INTERSECT Stephan Szabo 21:09

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

Browse Archives

Prev | Next