Home > mailing lists

Mailing lists [pgsql-sql]

1 March 2001

00:02 Re: int2+float8 problems Tom Lane
02:26 Re: plpgsql notify trigger Yury Don
02:53 Re: Help needed -> ERROR: record arow has no field description Justin Clift
03:22 Re: [PHP] novice question Josh Berkus
03:29 Re: int2+float8 problems guard
05:38 Re: int2+float8 problems Oliver Elphick
07:00 Re: Array as parameter in plpgSQL functions Christopher Sawtell
10:05 BufTableDelete: BufferLookup table corrupted Blaise Carrupt
13:58 Re: BufTableDelete: BufferLookup table corrupted Blaise Carrupt
14:05 Re: BufTableDelete: BufferLookup table corrupted Tom Lane
16:16 Weird NOT IN effect with NULL values Frank Joerdens
16:51 Re: Weird NOT IN effect with NULL values Josh Berkus
16:57 Re: Weird NOT IN effect with NULL values Bruce Momjian
17:07 Re: Weird NOT IN effect with NULL values Peter Eisentraut
17:28 Re: Weird NOT IN effect with NULL values Stephan Szabo
17:45 Re: Weird NOT IN effect with NULL values Ken Kline
17:52 Re: Weird NOT IN effect with NULL values Tom Lane
18:46 Re: Weird NOT IN effect with NULL values Bruce Momjian

2 March 2001

10:41 Re: why the DB file size does not reduce when 'delete' the data in DB? Martin A. Marques
10:54 Re: [HACKERS] why the DB file size does not reduce when 'delete' the data in DB? The Hermit Hacker
11:20 Help creating rules/triggers/functions Blaise Carrupt
11:43 Re: create function w/indeterminate number of args? Andrew Perrin
11:59 Help needed -> ERROR: record arow has no field description Justin Clift
12:01 Insert into VIEW ??? Jacek Zagorski
12:05 SQL copy from csv with explicit field ordering Terry Fielder
12:41 why the DB file size does not reduce when 'delete' the data in DB? Jaruwan Laongmal
13:00 lo_import for storing Blobs Laurent
14:26 union & subqueries Martin Lillepuu
14:27 Re: [HACKERS] why the DB file size does not reduce when 'delete' the data in DB? Hannu Krosing
14:41 Re: dates in functions Salvador Mainé
14:48 dates in functions Salvador Mainé
14:49 RE: Help creating rules/triggers/functions Sondaar Roelof
14:59 Re: [HACKERS] why the DB file size does not reduce when 'delete' the data in DB? Thomas Lockhart
15:13 Re: SQL copy from csv with explicit field ordering Peter Eisentraut
15:18 Re: Help creating rules/triggers/functions Stephan Szabo
15:49 Re: union & subqueries Tom Lane
16:14 Database Question Tangorre, Michael T.
16:58 Temp Tables & Connection Pooling Gerald Gutierrez
18:49 Re: Temp Tables & Connection Pooling David Olbersen

3 March 2001

04:44 Re: Help needed -> ERROR: record arow has no field description Tom Lane
07:30 Re: Help creating rules/triggers/functions Jan Wieck
07:34 Re: lo_import for storing Blobs pgsql-sql
13:34 Re: Insert into VIEW ??? Richard Huxton
13:34 Re: Temp Tables & Connection Pooling Richard Huxton
13:41 Re: Temp Tables & Connection Pooling Gerald Gutierrez

4 March 2001

01:05 Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? The Hermit Hacker
02:30 Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT Gerald Gutierrez
02:35 Gerald Gutierrez
14:59 How to describe a field in the table ??? Boulat Khakimov
15:30 Two way encryption in PG??? Boulat Khakimov
23:35 Re: Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT Gerald Gutierrez

5 March 2001

00:05 Re: From mailing list: PL/PGSQL returning recordset Josh Berkus
00:06 Re: Two way encryption in PG??? David Olbersen
05:18 Re: Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT Richard Huxton
12:21 Re: Two way encryption in PG??? Boulat Khakimov
14:20 Re: dates in functions George Moga
14:38 Re: Two way encryption in PG??? clayton cottingham
16:24 Re: Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT Jie Liang
16:29 Re: Jie Liang
16:59 count number of weeks??
16:59 How do I use text script containing SQL? Jeff S.
17:10 Re: How do I use text script containing SQL? clayton cottingham
17:16 Re: How do I use text script containing SQL? David Olbersen
17:20 random Jelle Ouwerkerk
17:51 pl/pgsql and returning rows wade
18:51 Re: random Tom Lane
19:00 Optimizing Query Justin Long
19:05 Re: PL/SQL-to-PL/PgSQL-HOWTO beta Available Bruce Momjian
19:06 Re: random Bruce Momjian
19:08 Re: Optimizing Query Bruce Momjian
19:23 Re: random Tom Lane
19:29 Re: random Stephan Szabo
19:29 Re: random Bruce Momjian
19:40 Re: random Tom Lane
19:49 Re: Optimizing Query Mathijs Brands
19:59 Re: Optimizing Query Bruce Momjian
20:04 Re: random Bruce Momjian
20:07 Extending PostgreSQL Using C Boulat Khakimov
20:10 Re: Optimizing Query Justin Long
20:13 Re: Optimizing Query Justin Long
20:22 Re: How do I use text script containing SQL? Mathijs Brands
20:38 Re: Optimizing Query Justin Long
20:39 Clustering (was Re: Optimizing Query) Mathijs Brands
20:56 How to count elements in an array? Grant
20:59 Re: Optimizing Query Michael Fork
21:19 Re: Two way encryption in PG??? Mathijs Brands
21:25 Re: Optimizing Query Mathijs Brands
21:40 Re: [DOCS] Extending PostgreSQL Using C Tom Lane
21:54 Vacuum. Grant
22:03 Re: [DOCS] Extending PostgreSQL Using C Boulat Khakimov
23:44 Re: How do I use text script containing SQL? Jie Liang

6 March 2001

00:14 Re: count number of weeks?? Christopher Sawtell
00:22 MySQLs Describe emulator! Boulat Khakimov
00:55 Re: [GENERAL] MySQLs Describe emulator! Tom Lane
02:11 Re: Optimizing Query Tom Lane
02:39 No Documentation for to_char(INTERVAL, mask) Josh Berkus
02:53 Re: How to count elements in an array? Josh Berkus
03:13 Re: No Documentation for to_char(INTERVAL, mask) Grant
06:14 Re: No Documentation for to_char(INTERVAL, mask) Karel Zak
07:08 Problems with RULE Jens Hartwig
10:39 Comparing dates Markus Fischer
12:19 Re: [GENERAL] MySQLs Describe emulator! Boulat Khakimov
12:23 Re: Optimizing Query Justin Long
12:26 Re: Comparing dates patrick.jacquot@anpe.fr
12:55 Re: MySQLs Describe emulator! Karel Zak
13:03 Re: Comparing dates dev@archonet.com
13:15 Re: Comparing dates Michael Fork
13:41 platform independend db access? Markus Wagner
13:42 Re: Temp Tables & Connection Pooling Ian Harding
13:54 RE: Help creating rules/triggers/functions Sondaar Roelof
13:57 Re: [GENERAL] Re: MySQLs Describe emulator! Boulat Khakimov
14:00 Re: Optimizing Query Tom Lane
14:01 Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? xuyifeng
14:10 Re: [GENERAL] Re: MySQLs Describe emulator! Karel Zak
14:11 Re: Re: [GENERAL] MySQLs Describe emulator! Michael Fork
14:25 Re: platform independend db access? clayton cottingham
14:34 Re: Problems with RULE dev@archonet.com
15:01 Permissons on database Boulat Khakimov
15:12 Re: Permissons on database Oliver Elphick
15:16 Re: [GENERAL] Re: MySQLs Describe emulator! Alfred Perlstein
15:23 Re: No Documentation for to_char(INTERVAL, mask) Josh Berkus
15:27 Quick question MySQL --> PgSQL Josh Berkus
15:34 Re: Permissons on database dev@archonet.com
16:09 Re: Quick question MySQL --> PgSQL Brett W. McCoy
16:34 Re: Problems with RULE dev@archonet.com
16:43 Re: Quick question MySQL --> PgSQL The Hermit Hacker
16:45 Re: Quick question MySQL --> PgSQL clayton cottingham
17:04 Re: Quick question MySQL --> PgSQL dev@archonet.com
17:05 Re: Quick question MySQL --> PgSQL Bruce Momjian
17:20 Date question Boulat Khakimov
17:30 RE: Date question Francis Solomon
17:33 Re: Date question Michael Fork
17:37 Re: Comparing dates Jie Liang
17:40 Re: [GENERAL] Date question Peter Eisentraut
17:53 Re: How do I use text script containing SQL? Andrew Perrin
18:08 Re: [BUGS] Mis-firing of rules with a WHERE condition Tom Lane
18:12 Re: Date question Jie Liang
18:17 Re: Problems with RULE Tom Lane
18:35 Re: Date question clayton cottingham
21:42 Undefined symbol Boulat Khakimov
21:46 Re: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? Mathijs Brands
22:10 Re: Re: [GENERAL] Re: MySQLs Describe emulator! Mathijs Brands
22:47 Re: Undefined symbol Mathijs Brands

7 March 2001

01:15 Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? The Hermit Hacker
01:33 Re: Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? Tatsuo Ishii
02:40 Query Limitations Keith Gray
03:03 Re: Query Limitations Bruce Momjian
04:02 On Clusters Mark Kirkwood
05:35 AW: Problems with RULE Jens Hartwig
05:37 AW: Problems with RULE Jens Hartwig
07:07 Re: Re: [GENERAL] Re: MySQLs Describe emulator! Karel Zak
08:23 Re: No Documentation for to_char(INTERVAL, mask) Karel Zak
08:34 Re: Problems with RULE Richard Huxton
09:38 Re: Quick question MySQL --> PgSQL Grigoriy G. Vovk
09:43 Re: random Tomek Zielonka
10:56 Re: random Tomek Zielonka
12:06 sql functions and triggers Andrzej Roszkowski
12:29 Re: sql functions and triggers Karel Zak
14:39 Re: No Documentation for to_char(INTERVAL, mask) Josh Berkus
14:44 Re: AW: Problems with RULE Tom Lane
14:55 Re: [DOCS] Extending PostgreSQL Using C Tom Lane
15:01 AW: Problems with RULE Jens Hartwig
15:10 how to get info of function Jie Liang
16:05 how to reload a function Jie Liang
16:15 Re: No Documentation for to_char(INTERVAL, mask) Thomas Lockhart
16:23 Newbie: execute function error! John GM
16:45 Re: [GENERAL] Re: MySQLs Describe emulator! Michelle Murrain
16:57 Re: No Documentation for to_char(INTERVAL, mask) Thomas Lockhart
16:57 Re: Re: why the DB file size does not reduce when 'delete'the data in DB? Thomas Lockhart
17:07 RE: [GENERAL] Date question Mike Mascari
17:10 Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? Xu Yifeng
17:40 work on rows Rachel Coin
18:41 Re: Permissons on database Roland Roberts
19:52 Re: work on rows dev@archonet.com
19:53 Re: Newbie: execute function error! dev@archonet.com
21:06 quotes in pl/pgsql Najm Hashmi
21:21 A query that doesn't work on 7.1 Kyle
21:34 Re: quotes in pl/pgsql clayton cottingham
22:08 Re: A query that doesn't work on 7.1 Tom Lane
22:40 Re: quotes in pl/pgsql Justin Clift
23:08 Re: quotes in pl/pgsql Roberto Mello

8 March 2001

00:03 Re: A query that doesn't work on 7.1 Tom Lane
03:00 postgresql beta-4,5 BUG guard
04:16 Buglet? Christopher Sawtell
06:12 How to build this field juerg.rietmann@pup.ch
08:36 Re: No Documentation for to_char(INTERVAL, mask) Karel Zak
11:52 Re: How to build this field Christof Glaser
13:44 Re: Buglet? Tom Lane
14:18 How to drop an trigger Frank Joerdens
14:21 Re: No Documentation for to_char(INTERVAL, mask) Josh Berkus
14:41 Re: How to drop an trigger Frank Joerdens
14:48 Re: quotes in pl/pgsql 0n variable type text or varchar Najm Hashmi
15:08 Re: Re: How to drop an trigger Frank Joerdens
15:37 Writing SQL functions in Postgres Boulat Khakimov
15:45 Re: How to build this field Christof Glaser
15:51 Re: Re: How to drop an trigger Tom Lane
17:05 Re: Writing SQL functions in Postgres dev@archonet.com
18:01 Access tables inside pl/pgsql functions Michael Davis
21:22 explain EXPLAIN? David Olbersen
22:33 Re: A query that doesn't work on 7.1 Kyle
22:39 Re: A query that doesn't work on 7.1 Tom Lane

9 March 2001

02:50 perl dbd Ken Kline
03:18 List Concatination Josh Berkus
09:35 Re: List Concatination Richard Huxton
13:07 Re: perl dbd Johan Van den Brande
14:21 from PosgreSQL 7.1b3 to 7.0.3 Najm Hashmi
14:21 cannot get CREATE TABLE AS to work Creager, Robert S
14:25 Re: List Concatination Tom Lane
14:42 Re: from PosgreSQL 7.1b3 to 7.0.3 Tom Lane
14:56 Re: cannot get CREATE TABLE AS to work Josh Berkus
15:01 Re: cannot get CREATE TABLE AS to work Peter Eisentraut
15:02 Re: List Concatination Josh Berkus
15:06 Re: cannot get CREATE TABLE AS to work Josh Berkus
15:10 Re: cannot get CREATE TABLE AS to work Josh Berkus
15:14 Re: cannot get CREATE TABLE AS to work Tom Lane
16:37 Re: cannot get CREATE TABLE AS to work Josh Berkus
18:16 Re: cannot get CREATE TABLE AS to work Stephan Szabo
19:01 RE: cannot get CREATE TABLE AS to work Creager, Robert S
19:27 RE: cannot get CREATE TABLE AS to work Stephan Szabo
20:02 Optimization via explicit JOINs David Olbersen
20:15 Re: Optimization via explicit JOINs Stephan Szabo
20:49 Re: Optimization via explicit JOINs David Olbersen
21:10 Re: Optimization via explicit JOINs Stephan Szabo
21:56 Re: Optimization via explicit JOINs David Olbersen
22:57 Re: from PosgreSQL 7.1b3 to 7.0.3 Christopher Sawtell
23:57 Re: Optimization via explicit JOINs Stephan Szabo

10 March 2001

00:06 Re: Optimization via explicit JOINs David Olbersen
00:18 Re: Optimization via explicit JOINs Stephan Szabo
00:19 Re: Optimization via explicit JOINs Stephan Szabo
01:04 Re: Optimization via explicit JOINs Tom Lane
20:05 recompiling to use gnu readline? Andrew Perrin
20:52 Re: recompiling to use gnu readline? Peter Eisentraut

11 March 2001

18:41 PL/PgSQL and NULL Andrew Perrin
19:29 Re: PL/PgSQL and NULL Peter Eisentraut
20:19 Re: PL/PgSQL and NULL Ross J. Reedstrom
22:00 Re: PL/PgSQL and NULL Andrew Perrin
23:58 Re: PL/PgSQL and NULL Jie Liang

12 March 2001

14:34 Max Conncection limit? Najm Hashmi
15:46 Re: Max Conncection limit? Frank Joerdens
17:50 Re: Comparing dates David Lynn
18:02 Poor document!! Noodle
18:11 default value syntax - pg compared to? Emils Klotins
18:15 SQL problem Salvador Mainé
18:24 Re: SQL problem Kevin T. Manley \(Home\)
18:32 Re: [DOCS] Extending PostgreSQL Using C Nishad Prakash
18:35 Re:Comparing Dates Josh Berkus
18:44 help chard
18:45 Re: [DOCS] Extending PostgreSQL Using C Hannu Krosing
18:51 Re: default value syntax - pg compared to? Josh Berkus
19:01 I need an aggregate with 2 parameters Salvador Mainé
19:02 ecpg on 7.0 Jia L Han
19:09 help chard
19:35 Re: I need an aggregate with 2 parameters Michael Fork
20:49 Re: help Stephan Szabo
21:20 Re: I need an aggregate with 2 parameters Tom Lane
21:22 Re: help Tom Lane
23:07 Cannot declare arrays? Josh Berkus
23:24 SQL Dummy Needs Help Alder
23:46 Re: SQL Dummy Needs Help Andrew Perrin
23:47 How does this query work.....? RbrtBrn3@aol.com
23:51 error joining 2 views containing GROUP BYs david morgan

13 March 2001

00:13 Re: Re: [GENERAL] MySQLs Describe emulator! Patrick Welche
00:15 Re: default value syntax - pg compared to? Carl van Tast
00:37 Re: SQL Dummy Needs Help Cliff Crawford
00:52 Re: Use of the LIMIT clause ? Tom Lane
01:03 Re: How does this query work.....? Stephan Szabo
01:49 Re: SQL Dummy Needs Help Cliff Crawford
02:21 Re: error joining 2 views containing GROUP BYs Tom Lane
05:20 != and <> operators Patrik Kudo
06:40 Re: Poor document!! Richard Huxton
09:56 my pgsql error? Christopher Sawtell
10:43 copy a record from one table to another (archive) juerg.rietmann@pup.ch
11:04 Re: my pgsql error? Richard Huxton
11:19 Re: my pgsql error? Christof Glaser
11:34 Re: copy a record from one table to another (archive) Richard Huxton
12:28 default value syntax - pg compared to? emils@mail.grafton.lv
12:42 psql win32 version datactrl
12:52 Silly question about numbering of rows? Ken Corey
13:04 Fwd: Silly question about numbering of rows? Ken Corey
13:13 Re: Permissons on database Rob Arnold
13:17 Re: != and <> operators Tom Lane
13:59 Re: Re: Use of the LIMIT clause ? Richard Poole
14:18 Re: != and <> operators Patrik Kudo
14:35 Re: SQL Dummy Needs Help Ross J. Reedstrom
16:49 Re: error joining 2 views containing GROUP BYs david morgan
17:40 Re: Fwd: Silly question about numbering of rows? Peter Eisentraut
19:43 Re: my pgsql error? Christopher Sawtell

14 March 2001

08:26 Re: my pgsql error? Richard Huxton
11:02 Re: copy a record from one table to another (archive) darcy@druid.net (D'Arcy J.M. Cain)
11:10 pgsql-sql
11:21 Re(2): Permissons on database pgsql-sql
12:50 Re: my pgsql error? Tom Lane
13:02 ... Alexaki Sofia
13:17 PL/pgSQL "compilation error" Tim Perdue
14:19 Re: PL/pgSQL "compilation error" Bruce Momjian
14:28 Re: PL/pgSQL "compilation error" Tom Lane
14:59 Re: PL/pgSQL "compilation error" Tom Lane
15:04 Re: PL/pgSQL "compilation error" Tim Perdue
15:04 Re: PL/pgSQL "compilation error" Josh Berkus
15:06 Re: PL/pgSQL "compilation error" Bruce Momjian
15:06 Re: Richard Huxton
15:07 Re: PL/pgSQL "compilation error" Richard Huxton
15:19 Re: PL/pgSQL "compilation error" Bruce Momjian
15:26 Re: pl/Perl Jie Liang
15:30 Re: PL/pgSQL "compilation error" Peter Eisentraut
15:51 Rule/currval() issue Tim Perdue
15:53 Re: my pgsql error? Roland Roberts
16:14 need to join successive log entries into one George Young
16:18 Re: Rule/currval() issue Andrew Perrin
16:24 Re: Rule/currval() issue Tom Lane
16:32 Re: Rule/currval() issue Tim Perdue
16:34 Re: Rule/currval() issue Tom Lane
16:56 RE: Rule/currval() issue Creager, Robert S
18:09 Re: Rule/currval() issue Tom Lane
19:01 FETCH ... INTO in PL/pgSQL Josh Berkus
19:07 Re: need to join successive log entries into one Oliver Elphick
20:10 Re: PL/pgSQL "compilation error" Richard H
20:15 Re: need to join successive log entries into one Richard H
20:28 Re: pl/Perl Richard H
20:41 Re: need to join successive log entries into one George Young
20:42 PIVOT of data Srikanth Rao
21:01 Re: need to join successive log entries into one Ross J. Reedstrom
21:06 Re: PIVOT of data Oliver Elphick
23:19 Re: psql win32 version datactrl

15 March 2001

00:35 Re: PL/pgSQL "compilation error" Bruce Momjian
01:17 Re: Re: psql win32 version Christopher Sawtell
01:27 Re: PIVOT of data Tim Perdue
03:04 Re: PIVOT of data Josh Berkus
06:14 Re: need to join successive log entries into one Richard Huxton
09:40 Some questions about PLpgSql datactrl
11:54 Help with UPDATE syntax Jeff Putsch
11:54 How to cast text to cidr/inet Sondaar Roelof
12:10 RE: Some questions about PLpgSql Sondaar Roelof
13:59 Re: Help with UPDATE syntax Tom Lane
14:00 RE: Help with UPDATE syntax Michael Davis
14:16 Re: PL/PgSQL and NULL Jan Wieck
14:24 Re: Some questions about PLpgSql Josh Berkus
14:33 Re: List Concatination Josh Berkus
14:35 Re: Some questions about PLpgSql Tom Lane
15:02 Re: List Concatination Tom Lane
17:37 VACUUM kills Index Scans ?! Gerald Gutierrez
17:58 Re: VACUUM kills Index Scans ?! Gerald Gutierrez
18:14 Re: Normalization is always good? Josh Berkus
18:28 Re: VACUUM kills Index Scans ?! Tom Lane
18:40 Re: VACUUM kills Index Scans ?! Stephan Szabo
19:09 Re: VACUUM kills Index Scans ?! Gerald Gutierrez
19:22 Re: PL/pgSQL "compilation error" Jan Wieck
19:22 Contribute to the PL/pgSQL CookBook !! Roberto Mello
19:24 Re: pl/Perl Jan Wieck
19:41 Re: FETCH ... INTO in PL/pgSQL Jan Wieck
20:49 Contribute to the PL/pgSQL CookBook !! Roberto Mello
21:13 Re: RE: Help with UPDATE syntax Richard Huxton
21:28 Re: Normalization is always good? jkakar@expressus.com
22:42 Re: Re: Normalization is always good? Christof Glaser

16 March 2001

02:19 Re: Re: Normalization is always good? Josh Berkus
05:14 Re: List Concatination Richard H
14:47 Re: List Concatination Josh Berkus
15:09 Re: List Concatination Josh Berkus
16:22 SQL3 support Mourad EL HADJ MIMOUNE
17:34 update table sequence e.ellenkamp@copernicus-it.nl (Egbert Ellenkamp)
17:37 Re: List Concatination Tom Lane
18:26 Re: update table sequence Ross J. Reedstrom
21:10 Oracle to PostgreSQL help: What is (+) in Oracle select? Christopher Audley
21:49 RE: Oracle to PostgreSQL help: What is (+) in Oracle select? Michael Davis
22:10 Re: Oracle to PostgreSQL help: What is (+) in Oracle select? Joe Conway
22:19 Re: Oracle to PostgreSQL help: What is (+) in Oracle select? Richard Poole

18 March 2001

10:14 Select very slow... Fernando Eduardo B. L. e Carvalho
16:46 Re: Select very slow... David Olbersen
17:25 Re: update table sequence Tom Lane
18:12 Trigger problem jreniz
23:39 Re: What do I do with this error? Josh Berkus

19 March 2001

01:10 Re: What do I do with this error? Tom Lane
01:11 hierarchical order equivalent Grant Furick
02:10 Re: What do I do with this error? Josh Berkus
02:21 Re: What do I do with this error? Stephan Szabo
02:22 Re: What do I do with this error? Tom Lane
07:10 Re: hierarchical order equivalent Karel Zak
08:18 MultiByte strings Tubagus Nizomi
08:55 postgres DB temporary on NT juerg.rietmann@pup.ch
10:04 Re: MultiByte strings Richard H
10:07 handling special characters in sql strings Markus Wagner
12:54 Re: handling special characters in sql strings tjk@tksoft.com
12:56 Re: MultiByte strings tjk@tksoft.com
13:30 Re: postgres DB temporary on NT Ross J. Reedstrom
15:12 Re: What do I do with this error? Josh Berkus
15:22 Re: What do I do with this error? Tom Lane
15:46 Re: What do I do with this error? Tom Lane
15:50 serial type question postgresql
15:58 request for tutorial on plsql Sarathi, Vijai (CAP)
16:04 Re: What do I do with this error? Tom Lane
16:11 Invalid (null) int8, can't convert to float8 Tim Pizey
17:00 Re: Invalid (null) int8, can't convert to float8 Tom Lane
17:12 Re: What do I do with this error? Tom Lane
17:20 Re: What do I do with this error? Josh Berkus
17:27 Re: What do I do with this error? Josh Berkus
17:34 Re: serial type question Stephan Szabo
19:58 Postgres & XML Najm Hashmi
20:22 Re: Postgres & XML clayton cottingham
20:24 Re: Postgres & XML Peter Eisentraut
20:45 Re: Postgres & XML Frank Joerdens
20:48 Manual Trigger Creation Josh Berkus
21:03 Re: Manual Trigger Creation Stephan Szabo
21:34 Re: Manual Trigger Creation Josh Berkus
21:37 count() and multiple tables Joseph Shraibman
21:49 Re: Manual Trigger Creation Tom Lane
21:49 Re: Manual Trigger Creation Stephan Szabo
22:02 Re: count() and multiple tables Josh Berkus
22:18 Re: Select very slow... Joseph Shraibman
22:18 Re: count() and multiple tables Joseph Shraibman
22:19 Re: count() and multiple tables Stephan Szabo
22:48 Re: Invalid (null) int8, can't convert to float8 Tim Pizey
23:24 Re: count() and multiple tables Stephan Szabo

20 March 2001

00:12 Re: VACUUM kills Index Scans ?! Joseph Shraibman
02:46 Re: count() and multiple tables Josh Berkus
05:06 Re: serial type question Richard Huxton
06:52 Categories and subcategories Rachel Coin
07:14 Re: Select very slow Mark Kirkwood
10:57 postmaster not starting on my MS WIN NT juerg.rietmann@pup.ch
13:44 Re: Categories and subcategories Josh Berkus
14:52 Categories and subcategories : more details Rachel Coin
15:44 Re: Categories and subcategories : more details Josh Berkus
18:14 triggered data change violation Cedar Cox
18:23 Re: Re: Use of the LIMIT clause ? Bruce Momjian
18:39 Re: [HACKERS] triggered data change violation Tom Lane
18:56 Re: [HACKERS] triggered data change violation Cedar Cox
19:04 Re: [HACKERS] triggered data change violation Peter Eisentraut
19:15 Re: [HACKERS] triggered data change violation Tom Lane
19:19 Re: Re: [HACKERS] triggered data change violation Bruce Momjian
19:20 Re: Re: Use of the LIMIT clause ? Tom Lane
19:36 Re: Re: Use of the LIMIT clause ? Bruce Momjian
22:03 I cannot vacuum Jie Liang
22:44 Re: I cannot vacuum Tom Lane

21 March 2001

02:23 pltcl - returning row(s) Jae Hwang
02:35 Maybe a Bug, maybe bad SQL Daryl Herzmann
03:20 Re: Maybe a Bug, maybe bad SQL Bruce Momjian
03:24 grant under sql92 Vladislav Breus
03:28 help pgsql 7.1beta & delphi guard
03:32 help pgsql 7.1beta & delphi guard
03:35 Re: Maybe a Bug, maybe bad SQL Grant
03:47 Re: Maybe a Bug, maybe bad SQL Tom Lane
05:32 how do I find which ... datactrl
10:06 Re: Maybe a Bug, maybe bad SQL darcy@druid.net (D'Arcy J.M. Cain)
11:08 Complex Query Help Brian C. Doyle
11:20 Re: Maybe a Bug, maybe bad SQL Bruce Momjian
13:41 Re: Maybe a Bug, maybe bad SQL Cedar Cox
13:43 Re: Maybe a Bug, maybe bad SQL Ross J. Reedstrom
13:46 Re: how do I find which ... Cedar Cox
13:50 Re: Maybe a Bug, maybe bad SQL Bruce Momjian
17:35 rows equal Marios Moutzouris
17:45 Toggle a Bit type ie not field Peter Morgan
17:49 LEFT JOIN Grant Furick
18:11 FULL JOIN Ligia Pimentel
18:13 Error when selecting rows from a temporary table in ODBC Ligia Pimentel
18:27 Re: Toggle a Bit type ie not field Brent Verner
19:12 Re: [ADMIN] Re: I cannot vacuum Jie Liang
20:02 CHAR or VARCHAR Martin A. Marques
22:05 Re: Re: psql win32 version datactrl
22:27 Re: CHAR or VARCHAR Peter J. Schoenster
22:28 Re: CHAR or VARCHAR Josh Berkus
23:22 Re: CHAR or VARCHAR Stephan Szabo
23:40 Re: Error when selecting rows from a temporary table in ODBC Hiroshi Inoue

22 March 2001

00:55 Re: [ADMIN] Re: I cannot vacuum Tom Lane
01:22 Re: Maybe a Bug, maybe bad SQL Tom Lane
02:11 Re: Error when selecting rows from a temporary table in ODBC Tom Lane
02:25 Re: FULL JOIN Tom Lane
07:11 database log datactrl
09:14 Re: CHAR or VARCHAR Martin A. Marques
10:15 String REPLACE function Joel Burton
11:03 Re: Re: psql win32 version Jack
11:12 Re: CHAR or VARCHAR Karel Zak
11:13 creating "job numbers" postgresql
11:41 Re: creating "job numbers" jdassen@cistron.nl (J.H.M. Dassen (Ray))
11:46 Re: creating "job numbers" Andrew Perrin
12:03 how to build this string ? juerg.rietmann@pup.ch
12:04 Re: creating "job numbers" Richard Huxton
12:18 Foreign key referencing subclasses. Johannes Grødem
12:50 Birthday search. Antti Linno
13:04 Re: how to build this string ? Richard Huxton
13:05 Re: CHAR or VARCHAR Tom Lane
15:09 Re: Foreign key referencing subclasses. Christof Glaser
15:27 Re: Birthday search. Jason Earl
15:30 Re: CHAR or VARCHAR Stephan Szabo
15:33 Re: Foreign key referencing subclasses. Stephan Szabo
18:52 Re: creating "job numbers" Jan Wieck

23 March 2001

01:11 drop table in PL/pgSQL datactrl
05:15 trigger output to a file pgsql-sql
08:25 SOME PL/PGSQL PROBLEMS datactrl
09:35 Btree index on varchar Alexaki Sofia
11:09 Re: creating "job numbers" postgresql
11:51 Re: Foreign key referencing subclasses. Johannes Grødem
12:04 Re: SOME PL/PGSQL PROBLEMS Richard H
13:15 RE: creating "job numbers" postgresql
14:04 Re: creating "job numbers" Tom Lane
14:30 Re: Btree index on varchar Tom Lane
16:04 Re: drop table in PL/pgSQL Jie Liang
16:40 Re: creating "job numbers" Jan Wieck
16:46 Re: SOME PL/PGSQL PROBLEMS Jie Liang
17:36 Re: trigger output to a file Jan Wieck
17:39 Re: drop table in PL/pgSQL Roberto Mello
18:04 Re: drop table in PL/pgSQL Jie Liang
18:24 Re: trigger output to a file Andrew Perrin

24 March 2001

02:48 how do I check if a temporary table exists? datactrl
03:55 Serials. Grant
09:21 Re: rows equal Richard H
12:05 Re: Serials. darcy@druid.net (D'Arcy J.M. Cain)
12:06 Re: Serials. Richard Huxton
12:16 Re: how do I check if a temporary table exists? darcy@druid.net (D'Arcy J.M. Cain)
12:16 Re: Serials. Mathijs Brands
12:23 Re: Serials. Peter Eisentraut
14:20 all views in database broken at once Andrew Perrin
14:40 Re: how do I check if a temporary table exists? Tom Lane
14:44 Re: how do I check if a temporary table exists? Bruce Momjian
15:07 Re: all views in database broken at once Tom Lane
19:56 Re: Serials. Grant
22:36 Re: all views in database broken at once Andrew Perrin
22:50 Re: all views in database broken at once Tom Lane
22:57 Re: all views in database broken at once Mathijs Brands

25 March 2001

00:40 Re: Serials. Dan Lyke
03:37 Re: all views in database broken at once Tom Lane
11:07 Re: all views in database broken at once Jan Wieck
15:14 Re: all views in database broken at once Mathijs Brands
17:22 Re: String REPLACE function Bruno Wolff III
17:22 Help Mohamed ebrahim
17:35 Re: CHAR or VARCHAR Peter J. Schoenster
17:46 Limit clause is not working in Postgresql7.0.2 Ricky
17:54 Help Mohamed ebrahim
18:02 Re: Help Roberto Mello
18:10 Re: Help Brett W. McCoy
18:11 Re: Help Peter Eisentraut
18:28 Re: Help Joe Conway
19:14 Re: CHAR or VARCHAR Tom Lane
22:06 Re: Serials. Grant
22:30 About Raise Exception datactrl

26 March 2001

00:06 Hi there, having problems with the following: Jens Philipsen
00:14 Re(2): trigger output to a file pgsql-sql
00:20 Datatypes in Embedded SQL Mic
00:24 about raise exception Jack
01:38 Re: Hi there, having problems with the following: Stephan Szabo
01:40 Re: about raise exception Stephan Szabo
02:02 Re: About Raise Exception Jie Liang
02:03 Re: about raise exception Jie Liang
02:11 Re: CHAR or VARCHAR Josh Berkus
04:04 Re: Help Richard Huxton
05:43 requesting help Mohamed ebrahim
05:54 Re: requesting help Poul L. Christiansen
06:22 SQL Date help waheed_rahuman
06:43 Calling Java from psql (was Re: requesting help) Mathijs Brands
07:39 Functions and Triggers Norbert Schollum
07:43 Re: SQL Date help Karel Zak
08:37 Still don't know how to build this string ? juerg.rietmann@pup.ch
10:34 Re: Still don't know how to build this string ? Richard Huxton
10:34 Re: Functions and Triggers Richard Huxton
11:38 Help Mohamed ebrahim
12:49 Re: Still don't know how to build this string ? Michael Fork
13:41 is it me or trigger side effects Najm Hashmi
13:47 Re: Functions and Triggers Cedar Cox
13:56 Re: Help Joe Conway
15:02 RE: Still don't know how to build this string ? Jeff Eckermann
15:10 Re: is it me or trigger side effects Stephan Szabo
16:04 paging A. Van Hook
16:51 Re: paging Peter Eisentraut
17:04 Re: Calling Java from psql (was Re: requesting help) Peter Eisentraut
17:45 Re: Calling Java from psql (was Re: requesting help) Mathijs Brands
17:48 Re: Help selkovjr@mcs.anl.gov
17:59 pl/pgsql and returning rows wade
18:01 Function Vanished Josh Berkus
18:13 Implicit/Explicit casting of the unknown type Stephen Jackson
18:28 Re: Help Cedar Cox
18:28 Re: is it me or trigger side effects Cedar Cox
19:09 Re: Function Vanished Tom Lane
19:25 Re: Function Vanished Josh Berkus
19:27 serial type; race conditions jkakar@expressus.com
19:36 Re: Function Vanished Tom Lane
19:47 Re: serial type; race conditions Bruce Momjian
23:54 ÁY¼gªº§t¸q S.F. Lee

27 March 2001

01:58 Re: Function Vanished Justin Clift
06:46 Re: pl/pgsql and returning rows Richard Huxton
07:48 Re: Still don't know how to build this string ? how to concat ?? juerg.rietmann@pup.ch
08:07 Re: Still don't know how to build this string ? juerg.rietmann@pup.ch
09:48 Re: all views in database broken at once Jan Wieck
09:58 Re: Functions and Triggers Jan Wieck
11:04 Upgrading from 6.2 to 7 Sean Weissensee
11:26 Re: Re: Still don't know how to build this string ? how to concat ?? Andy Corteen
13:35 Re: Upgrading from 6.2 to 7 Tom Lane
14:08 Re: Re: Still don't know how to build this string ? how to concat ?? Andy Corteen
15:12 Re: Re: Still don't know how to build this string ? how to concat ?? tjk@tksoft.com
16:54 RE: AY Gerald Gutierrez

17:31 Replace into...? Diehl, Jeffrey
17:59 Re: Replace into...? Peter Eisentraut
18:06 Re: Replace into...? Tom Lane
18:29 RE: Replace into...? Diehl, Jeffrey
19:10 possible row locking bug in 7.0.3 & 7.1 Forest Wilkinson
19:43 RE: pl/pgsql and returning rows Jeff Eckermann
19:51 Re: RE: pl/pgsql and returning rows Bruce Momjian
20:21 Re: RE: pl/pgsql and returning rows Bruce Momjian
21:14 Re: possible row locking bug in 7.0.3 & 7.1 Tom Lane
21:34 Re: Re: psql win32 version Christopher Sawtell
21:38 Re: Re: psql win32 version Christopher Sawtell
21:54 Re: Re: psql win32 version Josh Berkus
22:15 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Philip Warner
22:30 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Tom Lane

28 March 2001

04:08 Re: possible row locking bug in 7.0.3 & 7.1 Forest Wilkinson
04:11 Re: possible row locking bug in 7.0.3 & 7.1 Tom Lane
04:17 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Hiroshi Inoue
08:39 Re: RE: pl/pgsql and returning rows Richard Huxton
09:22 DELETE FROM fails with error chris Günther
11:30 Killing Postmaster Graham Vickrage
11:50 Re: Killing Postmaster Poul L. Christiansen
12:43 Re: Killing Postmaster Poul L. Christiansen
13:16 counting distinct rows on more than one column Dirk Lutzebaeck
13:54 RE: counting distinct rows on more than one column Michael Ansley
14:08 Re: DELETE FROM fails with error Josh Berkus
14:42 Re: counting distinct rows on more than one column Michael Fork
15:02 Re: DELETE FROM fails with error Tom Lane
15:05 Re: counting distinct rows on more than one column Tom Lane
16:19 Oracle -> Postgresql migration Douglas Brunton
16:59 Re: Oracle -> Postgresql migration Roberto Mello
16:59 Function with now() | time 'now' | etc... edipoelder@ig.com.br
17:22 Re: Function with now() | time 'now' | etc... Tom Lane
17:33 Re: counting distinct rows on more than one column Dirk Lutzebaeck
17:52 Re: counting distinct rows on more than one column Tom Lane
18:06 Re: DELETE FROM fails with error Stephan Szabo
18:43 RE: counting distinct rows on more than one column Jeff Eckermann
20:28 Re: RE: counting distinct rows on more than one column Jim Ballard
20:52 SELECT ... FOR UPDATE Marcos Minshew
21:44 Self-Referencing David Olbersen
22:07 Can a SELECT block? Gerald Gutierrez
22:22 Re: Can a SELECT block? Tom Lane

29 March 2001

03:13 3 options Patrick Coulombe
06:49 Escaping \ Martijn van Dijk
07:50 Re: Calling Java from psql (was Re: requesting help) Peter Mount
07:52 Re: Self-Referencing Christof Glaser
08:32 Re: Calling Java from psql (was Re: requesting help) Peter Mount
10:00 Re: Self-Referencing Cedar Cox
10:01 Re: SELECT ... FOR UPDATE Cedar Cox
10:14 Re: Function with now() | time 'now' | etc... Cedar Cox
11:04 Re: Escaping \ Richard Huxton
12:06 Re: Calling Java from psql (was Re: requesting help) Mathijs Brands
12:32 Re: serial type; race conditions postgresql
12:36 Re: serial type; race conditions Bruce Momjian
12:46 Re: serial type; race conditions Andrew Perrin
13:04 Re: serial type; race conditions Michael Fork
13:52 Re: Calling Java from psql (was Re: requesting help) clayton cottingham
14:10 Re: Escaping \ Tom Lane
14:26 inconsistent functionality with LIKE operator Phuong Ma
14:55 Re: Calling Java from psql (was Re: requesting help) Peter Eisentraut
15:00 Re: inconsistent functionality with LIKE operator Tom Lane
15:23 Re: Calling Java from psql (was Re: requesting help) Tom Lane
16:43 Update taking forever Graham Vickrage
16:47 RE: serial type; race conditions Jeff Eckermann
17:04 Re: Calling Java from psql (was Re: requesting help) Peter Eisentraut
18:02 Possible 7.1RC1 bug Kyle
18:43 Re: Escaping \ Cedar Cox
19:55 pg_dump error plus RelationBuildTriggers: 1 record(s) not found for rel links Najm Hashmi
23:46 RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Mikheev, Vadim

30 March 2001

00:12 date_part bug? Salvador Mainé
00:21 ... Md. Intekhab Alam
01:03 RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Philip Warner
02:14 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Hiroshi Inoue
02:50 RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Philip Warner
04:15 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Tom Lane
04:32 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Philip Warner
08:26 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Hiroshi Inoue
09:21 'Include' function in SQL scripts Alessio Bragadini
10:13 Max Size of a text field Koen Antonissen
10:29 Re: serial type; race conditions darcy@druid.net (D'Arcy J.M. Cain)
11:35 Function x returns opaque in error typeidTypeRelid Sondaar Roelof
11:54 Help with 'now', now(), timestamp 'now', ... edipoelder@ig.com.br
12:03 Re: Killing Postmaster A James Lewis
12:09 Error in the date field (with NULL value...).Thanks! Maurizio Ortolan
12:19 Re: Killing Postmaster A James Lewis
12:34 Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP Marcin Kowalski
13:13 RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Mikheev, Vadim
13:29 Re: [PATCHES] Error in the date field (with NULL value...).Thanks! Thomas Lockhart
13:31 RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Mikheev, Vadim
13:34 Re: Untitled Ian Harding
13:40 primary key scans in sequence bernd
13:54 Re: Calling Java from psql (was Re: requesting help) A James Lewis
14:00 Re: 'Include' function in SQL scripts Peter Eisentraut
14:00 Max Size of a text field Koen Antonissen
14:12 RE: Help with 'now', now(), timestamp 'now', ... Trewern, Ben
14:24 Error in the date field (with NULL value...).Thanks! Maurizio Ortolan
14:35 Help with 'now', now(), timestamp 'now', ... Daniel Wickstrom
14:44 Re: Max Size of a text field Peter Eisentraut
14:48 RE: Max Size of a text field Trewern, Ben
15:05 Error on Drop table Najm Hashmi
15:09 Re: primary key scans in sequence Richard Poole
15:09 TypeCreate: type links already defined Najm Hashmi
15:12 Re: primary key scans in sequence Peter Eisentraut
15:16 Re: Possible 7.1RC1 bug Tom Lane
15:53 Re: Possible 7.1RC1 bug Josh Berkus
17:39 Vacuum Error Tim Perdue
19:30 RE: Error in the date field (with NULL value...).Thanks! Gerald Gutierrez
21:47 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Forest Wilkinson
22:01 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Tom Lane

31 March 2001

03:33 Re: Possible 7.1RC1 bug Tom Lane
05:56 Library Management System Sharmad Naik
12:00 Re: date_part bug? Richard Huxton
12:03 Re: Function x returns opaque in error typeidTypeRelid Richard Huxton
22:18 Re: Vacuum Error Tom Lane