Home > mailing lists

Mailing lists [pgsql-novice]

1 October 2003

07:26 SELECT syntax question - combining COUNT and DISTINCT Cath Lawrence
09:10 Re: SELECT syntax question - combining COUNT and DISTINCT paul@entropia.co.uk
09:28 Re: SELECT syntax question - combining COUNT and DISTINCT paul@entropia.co.uk
10:14 adressing column Stefan Leitich
11:24 adressing columns Stefan Leitich
12:52 Re: Schemas, and visibility of tables in MS-Query. Harry Broomhall
14:04 Re: Schemas, and visibility of tables in MS-Query. Jeff Eckermann
14:20 Re: Schemas, and visibility of tables in MS-Query. Harry Broomhall
14:49 Re: Schemas, and visibility of tables in MS-Query. Tom Lane
14:54 Re: SELECT syntax question - combining COUNT and DISTINCT Louise Cofield
15:04 Re: Schemas, and visibility of tables in MS-Query. Harry Broomhall
15:14 Ideal Hardware? Jason Hihn
16:53 text -> extracted list of words Nabil Sayegh
17:44 Re: Ideal Hardware? Josh Berkus
18:06 Re: SELECT syntax question - combining COUNT and DISTINCT Manfred Koizar
20:49 Anything like Oracle's "connect by" SQL? Tim Wright
21:58 Re: Anything like Oracle's "connect by" SQL? Nabil Sayegh
22:54 Strange Startup Behavior David Rickard

2 October 2003

00:21 Re: Ideal Hardware?
01:13 Re: Ideal Hardware? Josh Berkus
05:03 Re: Anything like Oracle's "connect by" SQL? Tom Lane
05:50 Re: Anything like Oracle's "connect by" SQL? Josh Berkus
07:18 Python gotcha with boolean variables Cath Lawrence
09:29 basket, eggs & NAS (was eggs Re: Ideal Hardware?) Ron Johnson
13:59 Re: Some Simple Questions Bruno LEVEQUE
13:59 erro while loading shared libraries: can't open libpq.so.3 Phil Campaigne
13:59 Can SQL return a threaded-comment-view result set? mvppetlab@yahoo.com (Chris)
13:59 PostgreSQL and .NET Williams, Quinton L
14:56 Re: Can SQL return a threaded-comment-view result set? Tom Lane
15:28 Re: Can SQL return a threaded-comment-view result set? Joe Conway
16:26 Re: PostgreSQL and .NET Josh Berkus
16:39 TREE STRUCTURES was: Can SQL return a threaded-comment-view result set? Josh Berkus
17:31 plperl db crash Nabil Sayegh
17:41 Re: plperl db crash Josh Berkus
20:49 Re: plperl db crash Oliver Elphick

3 October 2003

01:24 Re: plperl db crash Nabil Sayegh
04:25 Re: plperl db crash Oliver Elphick
06:49 Re: plperl db crash Oliver Elphick
14:53 Adding PL languages laster john.stacy@us.o-i.com (John)
14:59 Re: erro while loading shared libraries: can't open libpq.so.3 Bruno LEVEQUE
14:59 Re: plperl db crash Nabil Sayegh
15:42 Rounding Chris Boget
16:25 Re: Rounding Tom Lane
16:28 Re: Rounding Joe Conway
16:34 Re: Adding PL languages laster Joe Conway
17:22 Re: Rounding Josh Berkus
17:24 Re: plperl db crash Nabil Sayegh
17:52 cancel request in progress M. Bastin
18:03 Re: cancel request in progress Tom Lane
19:14 Re: plperl db crash Nabil Sayegh
19:41 importing data automatically Menke, Kurt
20:24 Re: importing data automatically Josh Berkus
23:19 Re: plperl db crash Nabil Sayegh
23:30 perlsub Nabil Sayegh

4 October 2003

06:21 Re: perlsub Oliver Elphick

5 October 2003

13:04 Re: perlsub Martin_vi_Lange@t-online.de (Martin Lange)
16:53 Re: perlsub Nabil Sayegh
17:24 Re: perlsub Daniel Staal

6 October 2003

11:08 Getting "connectby" installed Tim Wright
11:26 large objects and database size Marcin Gil
12:42 Re: Getting "connectby" installed Nabil Sayegh
13:13 Re: Getting "connectby" installed Tim Wright
14:14 problems restoring 7.2.1 databases sibusiso xolo
14:17 Re: perlsub Jeff Eckermann
14:47 Re: perlsub Nabil Sayegh
16:29 Filtering duplicated row with a trigger papapep
16:41 Re: Filtering duplicated row with a trigger Bruno Wolff III
16:44 Re: Filtering duplicated row with a trigger Nabil Sayegh
16:55 Re: [personal] Re: Filtering duplicated row with a trigger papapep
17:16 Re: [personal] Re: Filtering duplicated row with a trigger Josh Berkus
17:19 Re: [personal] Re: Filtering duplicated row with a trigger Nabil Sayegh
17:27 Re: [personal] Re: Filtering duplicated row with a trigger Bruno Wolff III
17:27 Re: [personal] Re: Filtering duplicated row with a trigger papapep
17:33 Re: [personal] Re: Filtering duplicated row with a trigger Bruno Wolff III
17:38 Re: [personal] Re: Filtering duplicated row with a trigger papapep
17:45 Re: [personal] Re: Filtering duplicated row with a trigger Josh Berkus
17:55 Re: [personal] Re: Filtering duplicated row with a trigger Bruno Wolff III

7 October 2003

00:23 Re: Filtering duplicated row with a trigger Partha Sur
04:19 Re: Getting "connectby" installed Joe Conway
08:15 Re: [personal] Re: Filtering duplicated row with a trigger papapep
15:24 Re: Getting "connectby" installed Tim Wright
18:16 Re: perlsub Nabil Sayegh
18:16 problems retrieving images in 7.3.4 sibusiso xolo
18:39 Full Outer Join with dates as index? Bruche,ME (pgr)
18:55 Re: 7.4Beta2 installation not finding OpenSSL Bruno LEVEQUE
18:55 Re: SELECT syntax question - combining COUNT and DISTINCT zmilos@sympatico.ca (zhix)
18:56 Trigger return value Brian Slinn
18:58 Re: SELECT syntax question - combining COUNT and DISTINCT zmilos@sympatico.ca (zhix)
18:58 Re: 7.4Beta2 installation not finding OpenSSL Bruno LEVEQUE
18:59 Copy table structure Anshuman Kanwar
19:00 Re: importing data automatically Menke, Kurt
19:01 dropping users that start with ';' Gatts
19:05 Serial Column Tweaking David Rickard
19:05 Re: Full Outer Join with dates as index? Stephan Szabo
19:09 Re: Copy table structure Louise Cofield
19:28 Re: Serial Column Tweaking Bruno Wolff III
19:47 Re: perlsub Jeff Eckermann
19:56 Re: Trigger return value Josh Berkus
20:52 Re: dropping users that start with ';' Josh Berkus
21:18 Re: perlsub Oliver Elphick
21:50 Re: perlsub Jeff Eckermann
22:17 Re: perlsub Jeff Eckermann
22:25 Dropping Databases David Rickard
22:59 Re: Dropping Databases Josh Berkus

8 October 2003

01:59 Insert Unique Systems Administrator
03:27 Re: perlsub Tom Lane
07:02 Re: Copy table structure paul@entropia.co.uk
07:31 Re: Copy table structure Peter Childs
13:32 Re: Copy table structure Chris Boget
14:03 Re: Copy table structure Oliver Elphick
14:10 Re: perlsub Jeff Eckermann

9 October 2003

14:39 Problem with pg_user (somewhat urgent) Oliver Fromme
17:26 Using a function to delete rows Derrick Betts
17:33 Re: Using a function to delete rows Godshall Michael
17:43 Re: Using a function to delete rows Oliver Fromme

10 October 2003

12:40 output parameters in functions? Aled Morris
17:29 Foreign key error... Derrick Betts
17:32 Re: output parameters in functions? Josh Berkus
18:17 Re: Foreign key error... Oliver Fromme

11 October 2003

17:20 Re: dropping users that start with ';' Bruno LEVEQUE

12 October 2003

16:41 Deleting blob data with LargeObject Java API David Benoff

13 October 2003

22:59 Equivalent of Oracle next_day function David Rickard

14 October 2003

00:15 Re: Equivalent of Oracle next_day function Steve Crawford
00:20 SQL from PLPerl Systems Administrator
00:57 Re: Problem with pg_user (somewhat urgent) Tom Lane
02:30 Re: SQL from PLPerl Josh Berkus
03:23 Re: SQL from PLPerl Joe Conway
16:41 get diagnostics not supported by ecpg? Slava Gorski
16:41 Re: Can SQL return a threaded-comment-view result set? mvppetlab@yahoo.com (Chris)
16:41 Re: previous & next buttons Bruno LEVEQUE
16:42 Off Topic Bob Jarman
16:42 previous & next buttons Psybar Phreak
16:49 Re: Off Topic Bryan Irvine
23:45 authentication totally baffles this novice Eric S. Johansson

15 October 2003

02:27 Re: authentication totally baffles this novice Bruno Wolff III
06:50 Going mad with python pygresql, where is postgres.h??? Cath Lawrence
15:45 Re: Going mad with python pygresql, where is postgres.h??? Tom Lane
19:13 Running Postgresql Bantamess
20:00 Re: SQL from PLPerl Sebastian Riedel
21:23 Re: Running Postgresql Aarni Ruuhimäki

16 October 2003

06:14 variable date precision christoph.dellavalle@goetheanum.ch
08:36 trying to install phpPGAdmin ... Desmond Coughlan
11:34 MSAccess Problem Smitha V. Babu
11:45 Re: MSAccess Problem Peter Childs
11:49 Re: MSAccess Problem Wim
12:52 Re: trying to install phpPGAdmin ... Robert Treat
14:05 Question Mariano M. Gonzalez
14:24 Re: MSAccess Problem Jeff Eckermann
16:46 Access Privileges David Rickard
17:04 Re: variable date precision Bruno Wolff III
17:30 Date Formats and Conversions David Rickard
17:33 Re: Access Privileges Bruno Wolff III
17:38 Re: Date Formats and Conversions Bruno Wolff III

17 October 2003

20:08 Trouble creating a survey database dbaxter7@yahoo.com (Dave)
20:08 scaleable design for multiple value tuple records devicenull@linuxmail.org (dev o'null)
23:45 Combining text fields Doug Silver

18 October 2003

00:07 Re: Combining text fields Josh Berkus
01:39 Re: scaleable design for multiple value tuple Daniel Staal
02:56 Re: scaleable design for multiple value tuple Josh Berkus
13:28 Re: Combining text fields Nabil Sayegh

19 October 2003

09:33 Getting up and running on Red Hat 9 Paul Linehan

20 October 2003

00:33 HTML to access a database Evan Panagiotopoulos
10:50 Re: [personal] HTML to access a database papapep
12:18 Re: [personal] HTML to access a database Bruno LEVEQUE
14:04 SSL Error Susan Evans
19:36 Cross-classified table Alexander Pucher
20:38 Re: Cross-classified table Bruno LEVEQUE

21 October 2003

11:31 Re: Cross-classified table Muhyiddin A.M Hayat
12:03 Custom function problems Michael Glaesmann
12:10 Many joins: monthly summaries S-L--O--W Michael Glaesmann
15:32 Re: Custom function problems Stephan Szabo
16:49 Re: Many joins: monthly summaries S-L--O--W Josh Berkus
17:11 Re: Custom function problems Tom Lane
17:28 Re: Many joins: monthly summaries S-L--O--W Tom Lane
19:16 Almost relational PostgreSQL (was: one-to-one) Michael Glaesmann
20:13 Re: Almost relational PostgreSQL (was: one-to-one) Josh Berkus

22 October 2003

02:16 Loading speed Cath Lawrence
06:27 Re: Almost relational PostgreSQL (was: one-to-one) Michael Glaesmann
07:59 Re: Loading speed Oliver Elphick
14:35 Re: Loading speed Tom Lane
15:12 How to deal with smaller xlogs? big_mafa
16:57 Re: How to deal with smaller xlogs? Tom Lane
17:08 Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Michael Glaesmann
17:45 Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Tom Lane
17:56 Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Josh Berkus
18:35 Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Michael Glaesmann
18:55 index usage Andrei Ivanov
19:18 Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Tom Lane
19:23 Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Josh Berkus
19:40 Re: index usage Tom Lane
20:01 advice Andrei Ivanov
20:30 Re: advice Josh Berkus
21:56 Update rule on multiple tables fails? w fm3
22:49 Re: advice Tom Lane

23 October 2003

00:33 Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Michael Glaesmann
02:54 Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W) Tom Lane
08:13 do large objects retain after drop database? Marcin Gil
13:36 Re: do large objects retain after drop database? Tom Lane
16:42 Connection timeout? MaFa
19:17 libpq creid
20:23 Re: libpq Bruno LEVEQUE

24 October 2003

07:09 derive the sequence name of a column Mel Jamero
17:55 Installing on Red Hat 9? Paul Linehan
17:56 Novice dumb questions. Ed Fair
18:00 how to create a multi columns return function ? jclaudio@capitol.fr
18:28 Re: Getting up and running on Red Hat 9 Eric S. Johansson

25 October 2003

00:34 Re: how to create a multi columns return function ? Jordan S. Jones
05:30 selection limit cristi
09:05 Re: selection limit Muhyiddin A.M Hayat
20:41 Re: advice Paul Ganainm
21:55 libpq.dll and SSL Tony and Bryn Reina

26 October 2003

13:06 Re: Novice dumb questions. Ed Fair

27 October 2003

02:38 Re: derive the sequence name of a column Bruno Wolff III
11:00 Using older machines with PostgreSQL? Paul Ganainm
12:26 Re: Using older machines with PostgreSQL? Peter Childs
12:45 Re: Using older machines with PostgreSQL? Tomka Gergely
15:14 Re: Using older machines with PostgreSQL? Paul Ganainm
15:22 Re: Using older machines with PostgreSQL? Peter Childs
15:53 Deadlock Detection vardi@cs.rice.edu (Moshe Vardi)
16:04 Re: Deadlock Detection Josh Berkus
16:09 Re: selection limit Anis W. Nugroho

28 October 2003

00:01 foxpro to postgresql7.1 Gerard M. Operana
03:06 Re: foxpro to postgresql7.1 Josh Berkus
04:25 Re: foxpro to postgresql7.1 Ron Johnson
05:13 Jailed postgres Paul Bauer
13:10 Re: Jailed postgres Marc G. Fournier
20:52 logging messages this time Eric S. Johansson
23:05 Postgres and Crystal Reports David Rickard
23:45 Re: Postgres and Crystal Reports Williams, Travis L, NEO

29 October 2003

03:31 Re: Postgres and Crystal Reports Godshall Michael
11:30 pg_dump bug? Thilo Hille
12:43 foxpro to postgresql 7.x Jim Beckstrom
13:34 Re: pg_dump bug? Tom Lane
15:15 Re: logging messages this time Tom Lane
16:27 Re: foxpro to postgresql 7.x Josh Berkus
16:58 Capturing vacuum output David Rickard
17:47 Re: logging messages this time Eric S. Johansson
18:31 Re: logging messages this time Ennio-Sr
18:45 Re: logging messages this time Tom Lane
19:09 Re: logging messages this time Eric S. Johansson
20:54 Re: logging messages this time Oliver Elphick
21:35 Re: Capturing vacuum output Tom Lane

30 October 2003

05:35 Re: derive the sequence name of a column Mel Jamero
13:38 [OT] Unable to access PostgreSQL mailing list archive Ennio-Sr
14:18 Re: derive the sequence name of a column Stephan Szabo
14:42 Re: [OT] Unable to access PostgreSQL mailing list archive Tom Lane
17:35 Re: [OT] Unable to access PostgreSQL mailing list archive Ennio-Sr

31 October 2003

06:08 Re: derive the sequence name of a column Mel Jamero
14:51 Re: derive the sequence name of a column Stephan Szabo
18:48 installation problem Michael Kennett
18:52 Tool to generate input forms? Kurt Derichs
18:52 Re: derive the sequence name of a column Stephan Szabo
18:52 Re: [OT] Unable to access PostgreSQL mailing list archive Oleg Bartunov
18:52 CREATE TYPE for case insensitive text and varchar Daniel Migowski
18:54 Re: Viewing linked large postgres tables with Access: Running out of memory esimbo@openlinksw.co.uk (Emmon Simbo)
18:56 Trobuble Installing Postgres on an XP Machine Paul R. Sand
18:56 Change contraint in a table description Williams, Quinton L
18:56 help from Portugal Pedro Miguel Guedes
18:56 setting up the user postgres on mac osx Byron Amerson
18:57 Re: installation problem Larry Rosenman
18:59 Viewing linked large postgres tables with Access: Running out of memory iant@the-wire.com (moonman)
20:20 memory usage Tomka Gergely
20:27 help from Portugal Aarni Ruuhimäki
20:31 Re: installation problem Tom Lane
20:38 Re: help from Portugal Bruno LEVEQUE
21:39 Re: setting up the user postgres on mac osx Jeffrey Melloy