pgsql-sql since 2000-07-18 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 18, 2000

Thread Author Time
Database authentication and configuration Carolyn Lu Wong 02:01
Re: Select by priority Prasanth A. Kumar 02:37
strange error message Gerhard Dieringer 06:29
describe table in 7.0.2 Tubagus Nizomi 07:00
using a self referencing table drfrog 16:05
Re: Median Jan Wieck 19:35
Re: Median Tom Lane 21:43
Re: Database authentication and configuration Peter Eisentraut 21:45

July 19, 2000

Thread Author Time
Re: using a self referencing table andrew 00:19
Re: Median Thomas Lockhart 02:12
out-subject : thanks Patrick Coulombe 02:15
Can I create a function that returns many records? Joel Burton 17:13
Re: Can I create a function that returns many records? Tom Lane 18:21
Re: Database authentication and configuration Rodger Donaldson 21:46

July 20, 2000

Thread Author Time
Order by in Select 📎 Bernie Huang 00:25
Re: Order by in Select Stephan Szabo 00:38
synchronizing databases Nathan Young 00:55
from not null field to nullable field? Carolyn Lu Wong 06:13
primary key question Carolyn Lu Wong 07:26
Re: primary key question Wim Ceulemans 07:45
Re: from not null field to nullable field? Wim Ceulemans 07:55
test Emils Klotins 08:53
Re: primary key question omid omoomi 14:03
Nested Aggregates? John 16:02

July 21, 2000

Thread Author Time
referencing serials Markus Wagner 07:41
test Ange Michel POZZO 08:31
Re: test Jerome Alet 08:49
problem with view and case - please help Ange Michel POZZO 08:50
Re: problem with view and case - please help Volker Paul 09:10
Re: referencing serials Emils Klotins 09:13
Re: [BUGS] problem with view and case - please help Jan Wieck 11:02
using OID as primary key Markus Wagner 11:47
Re: using OID as primary key Jan Wieck 11:57
Re: using OID as primary key D'Arcy J.M. Cain 13:58
Re: problem with view and case - please help Tom Lane 14:27
Re: [SQL] problem with view and case - please help Ange Michel POZZO 14:41
Timestamp indexes Mitch Vincent 14:52
Re: problem with view and case - please help DalTech - CTE 15:06
Re: Timestamp indexes Tom Lane 15:15
Re: Timestamp indexes Mitch Vincent 15:53
password encryption Silesky Marketing Inc, Support 16:08
Re: Timestamp indexes Tom Lane 17:26
Re: [SQL] password encryption Roderick A. Anderson 17:30
Re: Timestamp indexes Mitch Vincent 17:40
Re: Timestamp indexes Tom Lane 17:46
Why do I need to set UPDATE permissions for fkey check? Jon Lapham 19:36
Re: Why do I need to set UPDATE permissions for fkey check? Stephan Szabo 21:00
Re: Why do I need to set UPDATE permissions for fkey check? Jon Lapham 21:39
create function - user permissions Markus Wagner 23:44

July 22, 2000

Thread Author Time
Re: create function - user permissions Tom Lane 06:03
query optimazation & starting postmaster with -B option sathya priya 08:34
Re: Why do I need to set UPDATE permissions for fkey check? Jan Wieck 09:01
Re: create function - user permissions Jan Wieck 09:11
Re: query optimazation & starting postmaster with -B option Mitch Vincent 22:41

July 24, 2000

Thread Author Time
Is there any way to speed up PL/TCL functions? Robert B. Easter 05:15
Re: Is there any way to speed up PL/TCL functions? Tom Lane 06:04
Alter table with arrays igor 13:54
altering column constraints 📎 Kyle 16:30
Re: Alter table with arrays Tom Lane 16:41
TCL updates 📎 Kyle 17:00
Select by priority again 📎 Bernie Huang 18:20
Re: Select by priority again D'Arcy J.M. Cain 19:20
Re: Select by priority again 📎 Bernie Huang 21:15
RULES on PostgreSQL Jesus Aneiros 22:25
Re: password encryption Aaron Sethman 22:37
Re: TCL updates Jan Wieck 22:47
Views on Unions Zot O'Connor 23:09

July 25, 2000

Thread Author Time
[Fwd: inserting integer in Table] Thomas SMETS 02:02
command in C++ Jerome Raupach 16:28
RE: primary key question Pablo Niklas 16:37
Re: command in C Michael Richards 18:13
pg_dump sathya priya 22:14
Index selection on a large table Michael Richards 23:03
Re: pg_dump Tom Lane 23:05
Re: [SQL] Index selection on a large table Tom Lane 23:30
Change attribute of a column 📎 Bernie Huang 23:34

July 26, 2000

Thread Author Time
Exec query Jerome Raupach 10:55
Re: Change attribute of a column Volker Paul 12:01
optimize sql pgsql-sql 14:11
Re: optimize sql Ross J. Reedstrom 15:51

July 27, 2000

Thread Author Time
Re(2): optimize sql pgsql-sql 02:40
Classes, Inheritance, and Children Thomas Swan 07:06
Large text insertion Vladimir Terziev 08:30
Re: Classes, Inheritance, and Children Oliver Elphick 09:01
Re: Large text insertion Jan Wieck 09:39
Antw: Re: Large text insertion Gerhard Dieringer 11:20
RE: Re(2): optimize sql Henry Lafleur 13:15
Compile Jerome Raupach 13:48
Aggregates and Primary Keys Itai Zukerman 14:00
Conditional rule? André Næss 14:43
Re: Conditional rule? Itai Zukerman 15:05
Automatic Deletes? Itai Zukerman 15:12
Re: Conditional rule? Tom Lane 15:36
Re: Conditional rule? André Næss 17:21
Re: Conditional rule? André Næss 18:01
Re: Conditional rule? Robert B. Easter 18:55
Re: Conditional rule? Robert B. Easter 19:06
how to r/w blob field in php danny 21:34
Re: Conditional rule? Jan Wieck 22:16
BLOBs 📎 Bernie Huang 22:19

July 28, 2000

Thread Author Time
Re: RE: Re(2): optimize sql pgsql-sql 02:27
Transactions Carolyn Lu Wong 08:21
Re: Conditional rule? André Næss 09:32
Re: BLOBs André Næss 09:40
Re: Conditional rule? Itai Zukerman 11:04
Re: Conditional rule? André Næss 11:46
Re: Conditional rule? Tom Lane 15:13
RE: RE: Re(2): optimize sql Henry Lafleur 16:18
two table comparison: find a mismatch? Web Manager 20:54
Re: two table comparison: find a mismatch? Ross J. Reedstrom 21:44
Re: Transactions John McKown 23:06

July 29, 2000

Thread Author Time
Re: Conditional rule? Robert B. Easter 01:35
Re: Conditional rule? André Næss 13:19
Just 'sql'? Itai Zukerman 13:29
Localization support Max Pyziur 17:55
Re: Conditional rule? Robert B. Easter 19:27

July 30, 2000

Thread Author Time
view's rule -> update dbalazs 16:23

July 31, 2000

Thread Author Time
Indices and time spans Itai Zukerman 13:44
Re: Indices and time spans Tom Lane 14:49
result in a variable? Jerome Raupach 15:43
Re: Indices and time spans Itai Zukerman 16:07
Simple concatenation in select query Sandis 19:48
RE: Simple concatenation in select query Henry Lafleur 21:05
Re: Simple concatenation in select query Tom Lane 21:05
What's ETA for read/write Views? Timothy Covell 23:59

Aug. 1, 2000

Thread Author Time
Re: What's ETA for read/write Views? Tom Lane 01:33
copy with libpq? Jerome Raupach 08:25
Re: New book on Postgres Christopher Sawtell 08:47
on line numbers, drop table errors, and log files Jon Lapham 13:56
PL/Tcl Roberto Mello 17:43
Re: on line numbers, drop table errors, and log files Michael Richards 18:32
SQL Question Daryl Herzmann 20:38

Aug. 2, 2000

Thread Author Time
Antw: SQL Question Gerhard Dieringer 07:32
Re: on line numbers, drop table errors, and log files Jon Lapham 13:02
Time Aggregates Itai Zukerman 13:41
Re: Time Aggregates Thomas Lockhart 15:27
Re: Time Aggregates David Lloyd-Jones 15:37
Re: Time Aggregates Itai Zukerman 15:52
postgresql and java2 JavierG 20:20
Re: on line numbers, drop table errors, and log files Michael Richards 21:42
Re: on line numbers, drop table errors, and log files Tom Lane 21:54

Aug. 3, 2000

Thread Author Time
What is happening? Carolyn Lu Wong 05:13
a question about dates and timestamp Ange Michel POZZO 08:24
Re: a question about dates and timestamp Karel Zak 08:58
Re: a question about dates and timestamp Ange Michel POZZO 09:30
Re: a question about dates and timestamp Karel Zak 10:39
Re: What is happening? The Hermit Hacker 11:41
Extracting data by months Antti Linno 13:49
Re: What is happening? Tom Lane 15:05
Re: a question about dates and timestamp Tom Lane 15:20
PL/pgSQL evaluation order Mark Volpe 15:30
Re: PL/pgSQL Mark Volpe 15:33
Re: SQL (table transposition) Mark Volpe 15:46
SQL (table transposition) Dana.Reed 17:24
A question about indexes... Alexaki Sofia 17:51
Re: Extracting data by months John McKown 19:23
Re: A question about indexes... Tom Lane 20:21
Re: PL/pgSQL evaluation order Mark Volpe 21:52

Aug. 4, 2000

Thread Author Time
Recursive SQL database 03:13
Re: Extracting data by months Daniel Kalchev 05:53
Re: SQL (table transposition) Volker Paul 07:30
Re: Extracting data by months Sandis 07:40
Strange strategy with COALESCE? Philip Warner 09:35
Re: A question about indexes... Alexaki Sofia 10:02
RE: SQL (table transposition) Henry Lafleur 12:57
Re: Extracting data by months Daniel Kalchev 13:24
Re: Extracting data by months Karel Zak 14:46
Database in recovery mode Michael Richards 18:48
Re: What's ETA for read/write Views? Peter Eisentraut 21:59

Aug. 6, 2000

Thread Author Time
Re: A question about indexes... Tom Lane 05:33
Re: Database in recovery mode Tom Lane 05:45
Rules, Select, Union Itai Zukerman 23:32

Aug. 7, 2000

Thread Author Time
Re: Rules, Select, Union Tom Lane 01:09
Functions too slow, even with iscachable? Ang Chin Han 09:11
Re: Functions too slow, even with iscachable? Philip Warner 09:57
Re: Functions too slow, even with iscachable? Philip Warner 12:12
Subselect and limit/order? Philip Warner 14:43
Re: Functions too slow, even with iscachable? Ross J. Reedstrom 14:47
Re: Functions too slow, even with iscachable? Tom Lane 14:58
Re: Functions too slow, even with iscachable? Philip Warner 15:07
Changing user passwords Rob van der Leek 15:17
Re: Functions too slow, even with iscachable? Tom Lane 15:52
foreign key take too much time to check Jie Liang 19:39
Re: foreign key take too much time to check Mark Volpe 19:57
PL/pgSQL Jie Liang 20:00

Aug. 8, 2000

Thread Author Time
Re: Subselect and limit/order? Philip Warner 04:10
Re: Subselect and limit/order? Philip Warner 06:24
Re: Changing user passwords Nagy Laszlo Zsolt , KLTE TTK pm1 12:59
Re: Changing user passwords Rob van der Leek 13:38
returning a recordset with pl/pgsql Keith Wong 14:29
Re: Changing user passwords 📎 Bernie Huang 15:53

Aug. 9, 2000

Thread Author Time
Re: Functions too slow, even with iscachable? Ang Chin Han 06:50
Aggregate functions, fast! (long) Ang Chin Han 06:53
Re: Aggregate functions, fast! (long) Ang Chin Han 07:33
any tool "return query results to a grid " luc00 13:31
Rules aren't doing what I expect Mark Volpe 16:04

Aug. 10, 2000

Thread Author Time
Re: Rules aren't doing what I expect Ang Chin Han 02:18
Re: Rules aren't doing what I expect Mark Volpe 14:22

Aug. 11, 2000

Thread Author Time
Problem with SQL query (eats swap) Mailing List Expander 02:46
Re: Rules aren't doing what I expect Tom Lane 14:10

Browse Archives

Prev | Next