pgsql-sql since 2000-08-29 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

Aug. 29, 2000

Thread Author Time
Re: pg_attribute_relid_attnam_index problem after log disk filled up Tom Lane 00:48
Re: better way Renato De Giovanni 00:50
Re: Can I get this all in one query? Renato De Giovanni 01:12
Test Stuart Foster 03:29
Re: pg_attribute_relid_attnam_index problem after log disk filled up Palle Girgensohn 03:33
Fw: Viewing a function stuart 10:20
How do you detect row version changes in PostgreSQL? Craig Manley 10:46
performance on insert/update Jerome Raupach 12:09
Re: Argument variables for select Andreas Tille 12:28
Re: Re: Argument variables for select Keith Wong 13:33
Re: Re: Argument variables for select hlefebvre 13:59
Re: How do you detect row version changes in PostgreSQL? Tom Lane 14:04
Re: performance on insert/update Tom Lane 14:55
Viewing a function Stuart Foster 15:32
Re: Re: Argument variables for select Webb Sprague 15:36
Problems with complex queries ... J. Fernando Moyano 22:46
Re: Problems with complex queries ... Stephan Szabo 23:19
Re: Problems with complex queries ... Tom Lane 23:21

Aug. 30, 2000

Thread Author Time
Optimizing huge inserts/copy's Webb Sprague 00:04
Create Primary Key? Webb Sprague 00:37
HELP pg_proc is corrupted! Timothy Covell 00:41
Re: Create Primary Key? Stephan Szabo 01:10
Re: Optimizing huge inserts/copy's Jie Liang 01:39
Re: Create Primary Key? Jie Liang 01:50
Re: Optimizing huge inserts/copy's Stephan Szabo 01:55
Re: Create Primary Key + Massive Copy's? Webb Sprague 03:52
Re: Create Primary Key? D'Arcy J.M. Cain 11:42
Re: Create Primary Key? Stephan Szabo 14:52
function Normunds 15:54
Re: Optimizing huge inserts/copy's Jie Liang 16:22
Re: Viewing a function Ryan Williams 17:46
Re: Optimizing huge inserts/copy's Webb Sprague 18:57
Re: Optimizing huge inserts/copy's Jie Liang 19:20
Re: Optimizing huge inserts/copy's Stephan Szabo 20:06
Re: Optimizing huge inserts/copy's Tom Lane 20:22
7.0.2 questions on encoding and compilation pyz 21:03
Re: 7.0.2 questions on encoding and compilation Dana Hudes 21:22
Re: 7.0.2 questions on encoding and compilation Max Pyziur 21:31
Outer join statement ? Nasdaq 21:44
Re: Optimizing huge inserts/copy's Zlatko Calusic 22:13
Re: function Jan Wieck 22:14

Aug. 31, 2000

Thread Author Time
Re: function Ian Turner 01:50
Re: 7.0.2 questions on encoding and compilation Igor N. Avtaev 03:45
Re: Outer join statement ? Alexandru COSTIN 06:54
Auto increment Mads Jensen 18:22
optimal performance for inserts Rini Dutta 19:22

Sept. 1, 2000

Thread Author Time
Re: RE: Create table in functions Jan Wieck 02:36
Re: RE: Create table in functions Andreas Tille 12:44
Query-ing arrays Jon Lapham 15:27
Re: Query-ing arrays Stephan Szabo 16:07
Re: Query-ing arrays Jon Lapham 18:31

Sept. 3, 2000

Thread Author Time
Re: Week of the Year? Brian C. Doyle 11:25
Re: Week of the Year? John McKown 18:07

Sept. 4, 2000

Thread Author Time
Re: Auto increment Richard Rowell 01:24
Order by in stored functions Andreas Tille 05:18
Re: pg_hba.conf Christopher Sawtell 07:47
Re: pg_hba.conf drfrog 09:11
Re: pg_hba.conf Jan Wieck 10:19
drop sequence in transaction Ice Planet 12:15
Re: Order by in stored functions Tom Lane 16:10
pg_hba.conf Craig May 17:15
Re: pg_hba.conf Craig May 18:50

Sept. 5, 2000

Thread Author Time
Query on array-elements inside object Umashankar Kotturu 03:12
Re: Order by in stored functions Andreas Tille 06:26
array column -- do you really want this? Oliver Seidel 07:40
Protection of tables by group and not by users 📎 nicolas.michaud 09:22
Re: pg_hba.conf Craig May 11:11
Re: pg_hba.conf Craig May 11:28
Re: Re: Order by in stored functions Jie Liang 17:53
Re: Query on array-elements inside object Jie Liang 18:03
7.0.2: Arrays Larry Rosenman 19:56
Re: [HACKERS] 7.0.2: Arrays Kristofer Munn 20:22
Re: [HACKERS] 7.0.2: Arrays Larry Rosenman 20:30
Re: 7.0.2: Arrays Jie Liang 20:38

Sept. 6, 2000

Thread Author Time
8K Limit, and Replication Poet/Joshua Drake 05:41
Re: 8K Limit, and Replication Karel Zak 07:01
Re: Trigger Mike Baroukh 10:24
Re: Trigger Chris Ryan 12:18
Re: Trigger 📎 Chris Ryan 12:40
Cascading Deletes Craig May 17:21
Re: Protection of tables by group and not by users Jie Liang 17:41
Re: Cascading Deletes Stephan Szabo 17:50
Re: Cascading Deletes Jie Liang 18:12
Re: Auto increment Mads Jensen 18:34
Re: [SQL] Re: 7.0.2 questions on encoding and compilation Max Pyziur 19:04
RE: 7.0.2 questions on encoding and compilation Max Pyziur 19:07
Re: [SQL] Re: 7.0.2 questions on encoding and compilation Dana Hudes 19:10
crypt function Francisco André Barbosa Neto 19:39
Trigger Craig May 20:27

Sept. 7, 2000

Thread Author Time
Re: [SQL] Re: 7.0.2 questions on encoding and compilation Igor N. Avtaev 03:40
Re: Cascading Deletes K Parker 04:23
Re: crypt function Ian Turner 05:44
Database Link Gerhard Dieringer 11:27
Re: Join Kristofer Munn 14:03
Antw: Join Gerhard Dieringer 14:25
Foresee any problems with this? postgres-failover (long) Ingram, Bryan 15:15

Sept. 8, 2000

Thread Author Time
Join Craig May 00:59

Sept. 9, 2000

Thread Author Time
Creating an aggregate function Roberto Mello 07:48
Porting from mysql to psql (UNIX_TIMESTAMP()?) Zlatko Calusic 11:02
Re: Porting from mysql to psql (UNIX_TIMESTAMP()?) Rommel B. Abaya 11:25
Re: Porting from mysql to psql (UNIX_TIMESTAMP()?) Zlatko Calusic 12:30
Re: [SQL] Porting from mysql to psql (UNIX_TIMESTAMP()?) Tom Lane 16:59
Re: Creating an aggregate function Tom Lane 21:03

Sept. 10, 2000

Thread Author Time
"ORDER BY" issue - is this a bug? Max Pyziur 18:19

Sept. 11, 2000

Thread Author Time
Re: [BUGS] "ORDER BY" issue - is this a bug? Tom Lane 00:35
Re: [BUGS] "ORDER BY" issue - is this a bug? Max Pyziur 01:06
Re: [BUGS] "ORDER BY" issue - is this a bug? Tom Lane 01:50
Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug? Max Pyziur 03:16
Isolation and Concurrency in PG functions? Roberto Mello 05:02
what utilities do i need for postgres on solaris 7 ?? Dronamraju Rajesh 06:51
Re: what utilities do i need for postgres on solaris 7 ?? 📎 Mario Farias-Elinos Baez 07:23
need asap: bg_BG locale for FreeBSD Oleg Bartunov 07:40
Tree structure Trewern, Ben 12:27
making two columns out of one Frank Bax 13:34
Re: need asap: bg_BG locale for FreeBSD Palle Girgensohn 13:51
Re: need asap: bg_BG locale for FreeBSD Oleg Bartunov 14:32
Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug? Lamar Owen 14:43
Re: Isolation and Concurrency in PG functions? Tom Lane 16:01
Re: Tree structure Albert REINER 16:25
Re: Tree structure 📎 Zeljko Trogrlic 16:30
How can I select all of the tables with field name 'area'? G. Anthony Reina 23:37
RE: How can I select all of the tables with field name 'area'? Stuart Foster 23:56

Sept. 12, 2000

Thread Author Time
Re: How can I select all of the tables with field name 'area'? G. Anthony Reina 00:34
This is A test Please Delete Hector Banda 00:53
Re: How can I select all of the tables with field name 'area'? Darrin Ladd 01:15
Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug? Max Pyziur 03:03
Re: Tree structure Zeljko Trogrlic 10:51
RE: Tree structure Trewern, Ben 14:52
Weighted Searching Mitch Vincent 16:22
Re: [SQL] Weighted Searching Stephan Szabo 16:41
Odd stuff Jie Liang 18:52
Re: Weighted Searching Josh Berkus 19:51

Sept. 13, 2000

Thread Author Time
Re: making two columns out of one Frank Bax 00:40
PLSQL Paulo Roberto Siqueira 02:05
Re: [SQL] Weighted Searching Oleg Bartunov 03:07
Optimizing Multiply Joins ??? Meszaros Attila 14:16
work on some tables in the same time. Jerome Raupach 14:40
Re: Optimizing Multiply Joins ??? Tom Lane 15:36
Re: PLSQL Josh Berkus 15:46
Re: work on some tables in the same time. Ian Turner 15:48
Re: work on some tables in the same time. Jerome Raupach 15:58
Re: work on some tables in the same time. Ian Turner 16:14
Re: work on some tables in the same time. Stephan Szabo 16:39
Re: PLSQL Jie Liang 16:59
Re: Optimizing Multiply Joins ??? Meszaros Attila 19:22
Re: Optimizing Multiply Joins ??? Tom Lane 20:48
Group by within table joins 📎 Bernie Huang 22:54
Re: Group by within table joins Josh Berkus 23:19
Re: Group by within table joins Jie Liang 23:28

Sept. 14, 2000

Thread Author Time
Web Hosts (off-topic) Tim Quinlan 04:57
Re: Optimizing Multiply Joins ??? Meszaros Attila 15:46
Re: Optimizing Multiply Joins ??? Tom Lane 16:21
Re: Optimizing Multiply Joins ??? Meszaros Attila 16:59
Re: Web Hosts (off-topic) Peter Mount 19:04
left and outer joins? Michael Teter 19:18
Re: Optimizing Multiply Joins ??? Tom Lane 19:35
Re: left and outer joins? Stephan Szabo 19:39

Sept. 15, 2000

Thread Author Time
demo of using large objects interface in php danny 02:57
get table schema in psql? Michael Teter 08:47
Error with DISTINCT Jerome Raupach 09:03
Re: get table schema in psql? Patrik Kudo 09:42
Re: get table schema in psql? Michael Teter 09:49
Re: get table schema in psql? Rommel B. Abaya 12:29
Re: Error with DISTINCT Tom Lane 14:13
Where to get benchmark testing Stuart Foster 15:24
New operators 📎 Kyle 15:55
Re: get table schema in psql? Jie Liang 21:29
Re: Error with DISTINCT Jie Liang 21:36
Re: get table schema in psql? Roderick A. Anderson 23:53

Sept. 16, 2000

Thread Author Time
installing pgaccess Keith Wong 04:00
Re: installing pgaccess Tom Lane 05:49
All function parameters become NULL if one is? Joel Burton 22:47

Sept. 17, 2000

Thread Author Time
Does optimizer know about 'constant' expressions? Philip Warner 08:43
Re: installing pgaccess Peter Eisentraut 13:03
Re: Does optimizer know about 'constant' expressions? Tom Lane 18:16
Re: All function parameters become NULL if one is? Peter Eisentraut 20:37

Sept. 18, 2000

Thread Author Time
shmget fails for min buffers of postmaster also on solaris 7 ..... Dronamraju Rajesh 07:53
Re: shmget fails for min buffers of postmaster also on solaris 7 ..... Thomas Mack 08:32
info about tables Jie Liang 17:05
Division 📎 Bernie Huang 22:47
Re: Division Jie Liang 23:24

Sept. 19, 2000

Thread Author Time
sum of agreggates in one SELECT? Louis-David Mitterrand 10:58
RE: sum of agreggates in one SELECT? Stuart Foster 15:28
Re: sum of agreggates in one SELECT? Tom Lane 17:27
Repeatable reads Michael Richards 17:48
RE: Repeatable reads Mikheev, Vadim 18:06
Re: sum of agreggates in one SELECT? John McKown 18:17
Re: sum of agreggates in one SELECT? Louis-David Mitterrand 20:06
Re: Repeatable reads Tom Lane 20:27
Foreign Keys Help Delete! Timothy Covell 23:49

Sept. 20, 2000

Thread Author Time
Re: [GENERAL] Foreign Keys Help Delete! Josh Berkus 00:08
Re: [SQL] Foreign Keys Help Delete! Stephan Szabo 00:37
Re: [GENERAL] Foreign Keys Help Delete! Jie Liang 01:19
Re: sum of agreggates in one SELECT? Louis-David Mitterrand 06:44
no ORDER BY in subselects? Louis-David Mitterrand 13:23
ERROR: replace_vars_with_subplan_refs (!?) Louis-David Mitterrand 13:25
Re: no ORDER BY in subselects? Tom Lane 14:41
Re: no ORDER BY in subselects? Philip Warner 14:43
Re: ERROR: replace_vars_with_subplan_refs (!?) Tom Lane 14:43
Re: [GENERAL] Foreign Keys Help Delete! Josh Berkus 15:38

Browse Archives

Prev | Next