pgsql-sql - February 2002

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Feb. 1, 2002

Thread Author Time
Re: Difference between Access97 and PostgreSQL Christopher Kings-Lynne 00:29
Re: Difference between Access97 and PostgreSQL Henshall, Stuart - WCP 10:15
Compare with CHAR Tomas Eriksson 12:59
Re: test the existence of a database Steve Brett 13:29
Re: Index Management Steve Brett 13:32
pg_vlock / vacuum 📎 David M. Richter 14:36
syntax for using function parameter in to_char Kevin Barrett 17:57
Re: Compare with CHAR Josh Berkus 19:41
NOTICE: Vacuum: can not process indices, views and certain system tables Diehl, Jeffrey 20:25
Re: Again about foreign keys and inheritance Stephan Szabo 20:36
Re: What's wrong with this function - "returns setof" Tom Lane 20:36
Re: pg_vlock / vacuum Tom Lane 20:39
Re: syntax for using function parameter in to_char Josh Berkus 20:40
Re: NOTICE: Vacuum: can not process indices, views and certain system tables Tom Lane 21:19
Array slice subscripts (was Re: [SQL] plpgsql function with more than one array argument) Tom Lane 21:56

Feb. 2, 2002

Thread Author Time
Fractional Results Paulo J. Matos 01:26
Re: Fractional Results Tom Lane 04:39
casting question A. Van Hook 15:20
Re: test the existence of a database Steve Boyle (Roselink) 16:38
Re: casting question Stephan Szabo 18:58

Feb. 4, 2002

Thread Author Time
temporary tables, plpgsql and yes i bet this has been asked before Murray Prior Hobbs 10:32
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 14:13
Re: casting question Jeff Eckermann 15:05
Re: temporary tables, plpgsql and yes i bet this has been asked before Tom Lane 15:47
Re: temporary tables, plpgsql and yes i bet this has been asked Jan Wieck 20:06
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:15
Re: temporary tables, plpgsql and yes i bet this has been asked Tom Lane 20:25
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:27
Re: temporary tables, plpgsql and yes i bet this has been asked Tom Lane 20:39
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:43
Re: temporary tables, plpgsql and yes i bet this has been asked Tom Lane 20:47
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:50
Re: temporary tables, plpgsql and yes i bet this has been asked Jan Wieck 21:13

Feb. 5, 2002

Thread Author Time
Database ownership Rudi 03:28
Re: Timestamp output Barry Lind 10:59
RULES - Difference between DO and DO INSTEAD Luis Sousa 11:26
Execute some of the elements of the RULE without a plan to the VIEW Luis Sousa 12:18
=?ISO-8859-1?Q?Privil=E9gios_s?=obre colunas Sandro Joel Eller 13:02
Re: Privil?gios sobre colunas Roberto Mello 15:03
WAL filling up disk Roberto Mello 16:54
indexes Isabelle Brette 17:05
Re: WAL filling up disk Chris Ruprecht 17:23
Re: WAL filling up disk Tom Lane 17:28
Re: indexes Chris Ruprecht 17:50
Re: WAL filling up disk Chris Ruprecht 18:00
Re: WAL filling up disk Tom Lane 18:18
Re: RULES - Difference between DO and DO INSTEAD Josh Berkus 18:20
Re: WAL filling up disk Josh Berkus 20:53
Re: WAL filling up disk Tom Lane 21:49
practical limitations to number of postgres user accounts Murray Prior Hobbs 22:37
Re: Database ownership Rudi 22:49

Feb. 6, 2002

Thread Author Time
Re: indexes Isabelle Brette 09:50
Re: indexes Stephan Szabo 15:29
Query with Parameters Evil Azrael 16:53
Re: WAL filling up disk Vivek Khera 17:28
Re: Query with Parameters Ian Barwick 17:57
Re: Query with Parameters Jeff Eckermann 19:24
JOIN between three *simple* tables ... Marc G. Fournier 20:47
Re: JOIN between three *simple* tables ... Tom Lane 21:14
Re: JOIN between three *simple* tables ... Marc G. Fournier 21:41

Feb. 7, 2002

Thread Author Time
type aliases in 7.0.3 Christopher Kings-Lynne 00:46
pg_shadow / pg_user Rudi 01:51
Re: pg_shadow / pg_user Christopher Kings-Lynne 02:05
Re: pg_shadow / pg_user Rudi 02:15
Re: pg_shadow / pg_user Bruce Momjian 02:31
Nested Transactions John Hasler 13:13
Re: Nested Transactions Bruce Momjian 17:00
How do you return more than one variable in a plpgsql function? Mark Nielsen 20:43
Looking for the correct solution for a generic problem. Frank Joerdens 20:52
Re: Looking for the correct solution for a generic problem. Mark Nielsen 20:53
Re: Help with a SQL query Mark Nielsen 21:02
Re: Looking for the correct solution for a generic problem. Stephan Szabo 21:31
Re: Looking for the correct solution for a generic problem. Tom Lane 21:50
Re: Looking for the correct solution for a generic problem. Frank Joerdens 22:04
ALTER TABLE and dropping a column Frank Joerdens 22:25
Re: ALTER TABLE and dropping a column Josh Berkus 23:22

Feb. 8, 2002

Thread Author Time
Re: How do you return more than one variable in a plpgsql function? Vincent AE Scott 02:13
Re: Help with a SQL query Bill Cunningham 03:47
Multiprocessor support for 7.2 📎 David M. Richter 09:05
Re: Multiprocessor support for 7.2 Bruce Momjian 14:02

Feb. 9, 2002

Thread Author Time
Adding a New Composite Constraint to an Existing Table. Bhuvan A 10:28
Re: Adding a New Composite Constraint to an Existing Table. MindTerm 12:57
Re: Adding a New Composite Constraint to an Existing Table. Stephan Szabo 17:43

Feb. 10, 2002

Thread Author Time
SQL Help - multi values James Carrier 06:34
Re: SQL Help - multi values Oleg Bartunov 08:49
Re: SQL Help - multi values Bruno Wolff III 16:04
Re: SQL Help - multi values Greg Sabino Mullane 17:53
Re: SQL Help - multi values Andrew G. Hammond 20:33
Re: SQL Help - multi values David Stanaway 22:43

Feb. 11, 2002

Thread Author Time
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 01:00
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Brent Verner 01:42
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 02:24
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu 📎 Brent Verner 03:49
Sequences Hunter, Ray 13:43
Re: SQL Help - multi values James Carrier 14:17
Re: Sequences Markus Bertheau 14:22
Re: Sequences Bruno Wolff III 14:36
Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 15:07
Re: Sequences Hunter, Ray 15:12
Join Statements T Conti 15:15
Re: Sequences mallah 15:19
Re: Sequences mallah 15:38
Re: Sequences Bruno Wolff III 15:51
Re: Sequences 📎 Chris Ruprecht 17:25
Re: Oracle "Jobs" in PostgreSQL Andrew G. Hammond 17:54
Re: Oracle "Jobs" in PostgreSQL Thomas Good 18:30
UNION and rows improperly unified: query optimization question Henry House 20:05
Support for bulk reads/writes ? charlie 20:06
Re: Support for bulk reads/writes ? Andrew Perrin 20:24
Re: Support for bulk reads/writes ? David Stanaway 22:58

Feb. 12, 2002

Thread Author Time
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 00:49
Re: UNION and rows improperly unified: query optimization question Tom Lane 01:18
help importing external excel file RPI 01:33
obtaining row number of select Keith Keller 02:23
Re: Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 04:09
Re: Oracle "Jobs" in PostgreSQL David Stanaway 04:30
Sequencing Problem in Transaction.. Bhuvan A 05:25
Storing text data in databases. mallah 05:39
Re: Sequencing Problem in Transaction.. Christopher Kings-Lynne 06:02
Re: Storing text data in databases. Christopher Kings-Lynne 06:04
Re: Sequencing Problem in Transaction.. Stephan Szabo 06:21
Re: Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 06:56
Re: Sequencing Problem in Transaction.. Bhuvan A 13:40
SQL request to retrieve the type of columns Jean-Max Reymond 15:45
Re: SQL request to retrieve the type of columns Vivek Khera 15:52
Re: Storing text data in databases. Josh Berkus 16:22
Re: Sequencing Problem in Transaction.. Bruce Momjian 17:16
Re: SQL request to retrieve the type of columns Andrew G. Hammond 17:40
pg_atoi error Oleg Lebedev 21:08
Re: pg_atoi error Oleg Lebedev 21:35
Re: UNION and rows improperly unified: query optimization question Jean-Luc Lachance 22:49

Feb. 13, 2002

Thread Author Time
remove Srikanth Rao 16:28
Time Intervals Michael Richards 16:53
How long does it take? Torbj=?ISO-8859-1?B?9g==?=rn Andersson 19:14
Re: Time Intervals Jason Earl 19:23
Re: How long does it take? clayton cottingham 19:36
Re: Time Intervals Michael Richards 19:37
Re: How long does it take? Tom Lane 21:43
Re: Time Intervals Tom Lane 21:50

Feb. 14, 2002

Thread Author Time
Re: How long does it take? Frank Bax 02:12
synchronise 2 db pgsql ? Laurent Patureau 10:09
Re: How long does it take? Torbj=?ISO-8859-1?B?9g==?=rn Andersson 10:18
trigger on table Graham Vickrage 12:17
Re: trigger on table Hano de la Rouviere 12:27
Re: trigger on table PGExplorer 12:28
Re: trigger on table Karel Zak 12:43
Re: How long does it take? Ross J. Reedstrom 16:43
Is this the most efficent way to child nodes off a N-ary node database? Christian Brink 18:52
Money type and kylix Eduardo 19:23
Index not being used Matthew Price 19:33
pre-alpha release of OpenFTS (perl version) is available for testing Oleg Bartunov 19:36
Re: Is this the most efficent way to child nodes off a N-ary Oleg Bartunov 19:37
nexval error duplicate key ron 19:55
Front and Back End Hunter, Ray 21:02
Re: Front and Back End Josh Berkus 21:33
Re: Index not being used Josh Berkus 21:38
Re: Index not being used Matthew Price 22:04
Re: Index not being used Josh Berkus 22:38
Re: Index not being used Stephan Szabo 23:08

Feb. 15, 2002

Thread Author Time
Re: Index not being used Tom Lane 00:46
Re: trigger on table Christopher Kings-Lynne 01:04
Re: Index not being used Christopher Kings-Lynne 01:23
Re: [SQL] Front and Back End Christopher Kings-Lynne 01:24
Re: nexval error duplicate key Lee Harr 01:27
Docs for all the schema functions Christopher Kings-Lynne 01:32
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu David Terrell 02:08
Re: Index not being used Tom Lane 03:52
Re: Index not being used Christopher Kings-Lynne 04:06
creating an index on a function Nick Fankhauser 14:26
Re: creating an index on a function Brent Verner 15:42
Re: creating an index on a function Tom Lane 16:00
create index on function - why? Wei Weng 16:25
Re: creating an index on a function Nick Fankhauser 16:27
Re: create index on function - why? Nick Fankhauser 16:33
Re: create index on function - why? Tom Lane 16:46
Re: create index on function - why? Bruno Wolff III 17:01
SQL For smarties Graham Vickrage 17:14
Re: create index on function - why? Luis Sousa 17:22
current connections and queries david blood 17:27
Re: SQL For smarties Bill Cunningham 17:35
Re: SQL For smarties Tom Lane 17:51
Re: create index on function - why? David Huselid 18:01
Re: create index on function - why? Tom Lane 18:15
Problem with self-join updates... Benoit Menendez 18:39
Re: Problem with self-join updates... Stephan Szabo 18:51
Re: synchronise 2 db pgsql ? knut.suebert 21:37
[No subject] GB Clark 21:51
Sorry about the no subject message... GB Clark 21:55

Feb. 16, 2002

Thread Author Time
No Interval Conversion Function in 7.2?!!? Josh Berkus 00:20
Re: No Interval Conversion Function in 7.2?!!? Tom Lane 00:33
Re: No Interval Conversion Function in 7.2?!!? Tom Lane 00:55
Re: SELECT... FOR UPDATE David Griffiths 01:49
Re: Christopher Kings-Lynne 04:36
Re: UNION and rows improperly unified: query optimization question Marshall Spight 07:25
Psql & Readline Josh Berkus 16:38
Re: Psql & Readline Tom Lane 17:40
More problems with 7.2 & functions Josh Berkus 18:10
Re: Join Statements Mark Nielsen 18:30
Re: More problems with 7.2 & functions Tom Lane 18:37
Re: More problems with 7.2 & functions Josh Berkus 18:52

Browse Archives

Prev | Next