Home > mailing lists

Mailing lists [pgsql-novice]

1 January 2004

12:57 output of vacuumdb after upgrade to 7.4.1 Olaf Ferger
13:38 Re: stupid question rhkelly
14:16 Re: stupid question Tom Lane
14:37 Re: output of vacuumdb after upgrade to 7.4.1 Tom Lane
16:14 Re: stupid question rhkelly
16:33 Re: stupid question Tom Lane
17:33 Re: stupid question rhkelly
19:10 Re: stupid question Michael Glaesemann

3 January 2004

04:29 Question about Indexes... Alan T. Miller
06:46 Re: Question about Indexes... Aarni Ruuhimäki
18:19 Re: Question about Indexes... Tom Lane
18:31 Re: Question about Indexes... Andreas
18:37 Re: Question about Indexes... Andreas
19:19 Creating initial data bases G. Walsh
22:26 More on creating data bases for 4 distinct users G. Walsh

4 January 2004

00:45 Re: Creating initial data bases Bruce Momjian
00:46 Re: More on creating data bases for 4 distinct users Bruce Momjian
02:28 problem with connecting to postgresql server gavaneh
11:07 Re: problem with connecting to postgresql server Bruno LEVEQUE
15:50 vacuumdb output changed after upgrade from 7.3.4 to 7.4.1 Olaf Ferger
15:56 Re: multiline PL/Python function fails in *.sql rlasjunies@free.fr (Richard LASJUNIES)
15:57 Re: Question about Indexes... Sukellusseura Vesikot r.y.
15:57 Re: multiline PL/Python function fails in *.sql rlasjunies@free.fr (Richard LASJUNIES)
15:58 Creating data bases George Walsh
15:59 install gavaneh
16:00 Re: mysql_field_name equivalent CoL
16:34 Timestamp vs. Interval and formatting.... Dan Jewett
16:41 Re: Creating data bases
16:53 Re: Timestamp vs. Interval and formatting.... Michael Glaesemann
17:26 Re: install Aarni Ruuhimäki
21:31 Re: Timestamp vs. Interval and formatting.... Dan Jewett

5 January 2004

01:42 Re: multiline PL/Python function fails in *.sql Tom Lane
02:14 Re: Timestamp vs. Interval and formatting.... Michael Glaesemann
02:23 Re: Timestamp vs. Interval and formatting.... Michael Glaesemann
07:02 postgresql in windows gavaneh
13:07 Re: outer join question Maximilian Tyrtania
14:06 Re: postgresql in windows Andreas
16:55 checking update/insert return Marcus Andree S. Magalhaes
17:27 Re: checking update/insert return Bruno LEVEQUE
17:32 Re: checking update/insert return Oliver Elphick
18:41 Re: checking update/insert return Marcus Andree S. Magalhaes
18:51 Re: checking update/insert return Marcus Andree S. Magalhaes
20:20 Re: postgresql in windows vhikida@inreach.com

6 January 2004

06:32 Re: checking update/insert return Andrew McMillan
07:38 Disk usage Martin Hampl
11:48 Need smart sql Maximilian Tyrtania
12:49 Re: Need smart sql Bruno Wolff III
13:52 Integrity problem on 7.3.4 Rory Campbell-Lange
13:57 Re: Disk usage Bruce Momjian
14:02 Re: Integrity problem on 7.3.4 Tom Lane

7 January 2004

08:09 partial index on varchar-coloumn in 7.4.1 Martin Hampl
11:31 Re: partial index on varchar-coloumn in 7.4.1 Martin Hampl
11:31 Re: partial index on varchar-coloumn in 7.4.1 Tom Lane
13:15 Re: partial index on varchar-coloumn in 7.4.1 Stephan Szabo
13:18 Short notation for creating indices ? Andreas
14:11 Re: partial index on varchar-coloumn in 7.4.1 Martin Hampl
15:13 See how many connections Rob Sell
16:07 Re: See how many connections Tom Lane
18:36 Re: partial index on varchar-coloumn in 7.4.1 Tom Lane
21:07 Upgrade function problem - c language Cath Lawrence

8 January 2004

02:15 Re: Upgrade function problem - c language Tom Lane
03:17 pgsql 7.0 recovery to 7.4 Marcin Gil
06:29 Re: partial index on varchar-coloumn in 7.4.1 Martin Hampl
10:46 Re: pgsql 7.0 recovery to 7.4 Tom Lane
11:50 Re: pgsql 7.0 recovery to 7.4 Marcin Gil
12:15 Re: pgsql 7.0 recovery to 7.4 Tom Lane
13:39 Re: pl/pgSQL sequence question Tom Lane
14:48 Re: partial index on varchar-coloumn in 7.4.1 Bruno Wolff III
17:16 Re: partial index on varchar-coloumn in 7.4.1 Tom Lane

9 January 2004

03:42 Re: pgsql 7.0 recovery to 7.4 Marcin Gil
06:26 Strange Insert Problem Lola Lee
06:41 Re: Strange Insert Problem Bruno LEVEQUE
07:35 Re: Strange Insert Problem John K. Herreshoff
07:46 Re: Strange Insert Problem Lola Lee
15:45 Datestamps Bryan Irvine
16:25 Re: Datestamps Bruno Wolff III
16:52 Re: Datestamps Bruno Wolff III
17:12 Re: Datestamps Bryan Irvine
17:39 psql error: could not connect to server bartvde@xs4all.nl
17:39 Re: Datestamps Bruno Wolff III
17:41 Re: psql error: could not connect to server Bruno Wolff III
17:47 Re: Datestamps Steve Crawford
18:40 createdb bartvde@xs4all.nl
18:53 Re: createdb Bruno LEVEQUE
19:59 Re: Upgrade function problem - c language Andrew McMillan
20:12 Re: Upgrade function problem - c language Tom Lane
22:20 unsubscribe sibu xolo

10 January 2004

17:26 One big database or little separate ones? Dennis Veatch
18:16 Re: One big database or little separate ones? Bruno LEVEQUE
19:25 Re: One big database or little separate ones? Eric Frazier
22:38 Re: One big database or little separate ones?

11 January 2004

13:18 date comparison between perl and postgres hodges@xprt.net
13:26 Re: date comparison between perl and postgres hodges@xprt.net
14:39 Alter TABLE with Postgres 7.2 small.witch@gmx.de
14:47 Re: One big database or little separate ones? Allan Berger
15:20 Case sensitivity Dario Ottaviano
15:21 Get error during initdb Olaf Meding
15:21 Re: Strange Insert Problem Martin Atukunda
15:21 psql error: could not connect to server bartvde@xs4all.nl
15:21 Re: pl/pgSQL sequence question Stephen Shorrock
15:24 Re: partial index on varchar-coloumn in 7.4.1 Martin Hampl
15:33 Re: install Sukellusseura Vesikot r.y.
15:34 PQexec hangs, stuck on malloc_consolidate Tor Gunston
15:35 Disk usage Martin Hampl
16:03 Re: Alter TABLE with Postgres 7.2 Tom Lane
16:16 Re: Get error during initdb Tom Lane
16:18 Re: psql error: could not connect to server Tom Lane
16:43 Re: PQexec hangs, stuck on malloc_consolidate Tom Lane
23:28 Re: Get error during initdb George Weaver
23:38 Re: One big database or little separate ones? Andreas

12 January 2004

00:07 Re: PQexec hangs, stuck on malloc_consolidate Tor Gunston
01:23 Cluster in users home Russell Shaw
02:52 Delete from a table with JOIN Noel
10:35 Re: Delete from a table with JOIN Tom Lane
11:34 Connect error Russell Shaw
11:39 Re: date comparison between perl and postgres Bruno Wolff III
11:43 Re: Connect error Bill Moseley
12:04 Re: Connect error Bruno Wolff III
12:39 Re: Connect error Sai Hertz And Control Systems
12:53 Re: Connect error Rod K
13:29 Re: Connect error Bill Moseley
13:57 Re: Connect error Bruno Wolff III
14:22 Re: [Ignor Whois] Re: Connect error Bill Moseley
16:12 Re: [Ignor Whois] Re: Connect error Bruno Wolff III
19:59 Re: Connect error Bill Moseley
23:38 Re: Connect error Russell Shaw

13 January 2004

01:28 Re: Case sensitivity Oliver Elphick
01:33 Re: Cluster in users home Oliver Elphick
02:03 Re: Connect error Bill Moseley
05:17 Re: Connect error Russell Shaw
05:52 Re: Connect error Russell Shaw
06:02 PostgreSQL booting automaticaly Frederic Logghe
06:03 PostgreSQL booting automaticaly Frederic Logghe
06:13 Re: PostgreSQL booting automaticaly HK
07:34 Re: PostgreSQL booting automaticaly Aarni Ruuhimäki
09:29 Re: PostgreSQL booting automaticaly Eric S. Johansson
10:05 creating databases Marcel Wolf
10:18 Re: creating databases Devrim GUNDUZ
10:42 Re: PostgreSQL booting automaticaly Devrim GUNDUZ

14 January 2004

02:13 (no subject) Lduren02@aol.com
03:40 Re: (no subject) Bruno LEVEQUE
07:07 Re: (no subject) Aarni Ruuhimäki
10:23 SQL_ASCII / LATIN1 Aarni Ruuhimäki
10:48 probs with 7.3 -> 7.4 on debian glenn
11:09 Re: probs with 7.3 -> 7.4 on debian Oliver Elphick
11:14 Re: SQL_ASCII / LATIN1 Tom Lane
12:38 parser-error Ralf Bortfeldt
13:39 Trigger Question Terry Lee Tucker
14:06 Inheritance and foreign keys Daniel Harris
15:02 Re: Inheritance and foreign keys Stephan Szabo
15:24 Re: parser-error Tom Lane
20:48 Re: probs with 7.3 -> 7.4 on debian glenn
21:07 Re: SQL_ASCII / LATIN1 Aarni Ruuhimäki

15 January 2004

11:37 Re: Aarni Ruuhimäki

16 January 2004

13:26 failover Bryan Irvine
15:08 ECPG Chris
15:12 Re: failover Josh Berkus
20:49 changing start value of sequence after it was created... Alan T. Miller

17 January 2004

01:37 Re: changing start value of sequence after it was created... joseph speigle
09:59 unsubscribe sibu xolo
20:39 indexing date and timestamp fields... Alan T. Miller
23:29 Re: indexing date and timestamp fields... Tom Lane

18 January 2004

17:15 transactions in c api (libpq)? jaguar4096@yahoo.com (Dave)
17:19 query Ankur Arora
17:19 Meta data about object in postgres raghu_k_n@yahoo.com (Raghu)
17:20 New at this. Commissioning for the first time: sa92003@yahoo.com (Rob)
17:20 Re: New at this. Commissioning for the first time: raghu_k_n@yahoo.com (Raghu)
17:23 How can I select a comment on a column in a query? A u r k a
17:23 problem with function trigger jclaudio@capitol.fr
17:23 Re: plpython trigger Tom Brown
17:23 Discarding UNIQUE temporarily? Timo
17:23 Re: probs with 7.3 -> 7.4 on debian Oliver Elphick
17:25 installing postgre Lduren02@aol.com
17:26 Re: SQL_ASCII / LATIN1 Aarni Ruuhimäki
17:26 How to turn flat file to SQL dj00302003@yahoo.com (Jay Davis)
21:26 Re: How to turn flat file to SQL Josh Berkus

19 January 2004

00:27 Re: New at this. Commissioning for the first time: Tom Lane
00:33 Re: installing postgre Tom Lane
01:19 Re: query Bruno Wolff III
03:51 Re: Discarding UNIQUE temporarily? Tom Lane
10:02 Re: Meta data about object in postgres glenn
11:41 Re: How can I select a comment on a column in a query? George Weaver
11:54 Re: How can I select a comment on a column in a query? Tom Lane
16:10 absolute beginner Lduren02@aol.com
16:19 Re: absolute beginner Rob Sell
16:50 Re: absolute beginner Tom Lane
18:36 timestamptz insert Seader, Cameron
19:05 Re: timestamptz insert Tom Lane
21:35 long deletes :( Pls help Noel
21:46 Re: long deletes :( Pls help Noel
22:39 Re: long deletes :( Pls help Tom Lane
22:48 Re: long deletes :( Pls help Tom Lane

20 January 2004

02:12 CREATEDB failure Paul Bauer
05:46 Re: CREATEDB failure Oliver Fromme

21 January 2004

14:53 Re: Problem with pg_hba.conf file in Postgres 7.3 April Carvalho
16:11 Re: Problem with pg_hba.conf file in Postgres 7.3 Tom Lane
16:51 passwords Chris
17:13 Re: passwords Tom Lane

22 January 2004

09:30 Using OLD on INSERT Paul Makepeace
10:28 executing backup remotly Iandé Coutinho
10:32 Re: Using OLD on INSERT Terry Lee Tucker
10:54 Re: Using OLD on INSERT Terry Lee Tucker
11:26 Re: Using OLD on INSERT Marcus Andree S. Magalhaes
11:49 Re: executing backup remotly Tom Lane
18:38 HowTo configure and compile with openssl and jdbc on RedHat Enterprise 3? chris@goforit.de
19:19 Re: HowTo configure and compile with openssl and jdbc on Bruno LEVEQUE
19:48 Re: HowTo configure and compile with openssl and jdbc on chris@goforit.de
21:28 Hierarchal data Bill Moseley
23:29 Re: HowTo configure and compile with openssl and jdbc on Tom Lane

23 January 2004

02:33 Re: Hierarchal data Douglas Trainor
02:57 Re: Hierarchal data Bill Moseley
03:02 Re: HowTo configure and compile with openssl and jdbc on Tom Lane
05:01 Problem with initdb. Locale? Christian Poecher
06:05 using external .sql files from shell script ? Francois PUSSAULT
09:54 7.4.1 template1 Aarni Ruuhimäki
11:01 pg_atoi error LIANHE SHAO
11:11 Re: pg_atoi error Bruno Wolff III
11:27 Re: Problem with initdb. Locale? Tom Lane
12:15 Re: 7.4.1 template1 Tom Lane
12:21 Re: pg_atoi error Bruno Wolff III
12:55 Re: Problem with pg_hba.conf file in Postgres 7.3 April Carvalho
13:03 Re: Problem with pg_hba.conf file in Postgres 7.3 Tom Lane
13:35 Re: pg_atoi error LIANHE SHAO
13:56 Re: pg_atoi error Bruno Wolff III
13:59 Re: pg_atoi error Tom Lane
14:18 Re: 7.4.1 template1 Aarni Ruuhimäki
19:12 Re: Problem with pg_hba.conf file in Postgres 7.3 Oliver Elphick

24 January 2004

09:25 error when configuring postgresql7.4 -> ./src/template/linux Peggy Go
17:04 Re: error when configuring postgresql7.4 -> ./src/template/linux Tom Lane
23:46 Multiway associations Russell Shaw

25 January 2004

01:05 Re: Multiway associations Michael Glaesemann
01:20 Re: Problem with pg_hba.conf file in Postgres 7.3 Bruce Momjian
01:24 Re: Multiway associations Russell Shaw
02:33 Re: Multiway associations Michael Glaesemann
07:06 Primary key efficiency Russell Shaw
07:19 Re: Primary key efficiency V i s h a l Kashyap @ [Sai Hertz And Control Systems]
12:41 Re: Hierarchal data Bill Moseley
12:58 Re: Hierarchal data Joe Conway
15:03 Re: Hierarchal data Bill Moseley
16:09 Re: Primary key efficiency Tom Lane
20:01 Re: Primary key efficiency Russell Shaw
20:34 Re: Primary key efficiency Tom Lane

26 January 2004

13:03 Global variables for plpgsql stored procedures
14:45 postgre-7.4 and readline-4.3 /solaris 8 Patrice Durosay
16:00 Re: postgre-7.4 and readline-4.3 /solaris 8 Tom Lane
16:19 Re: Problem with pg_hba.conf file in Postgres 7.3 April Carvalho
16:26 Re: Hierarchal data glenn
16:37 Database creation Marcel Wolf
16:40 Re: Problem with pg_hba.conf file in Postgres 7.3 Oliver Elphick
16:53 Re: Database creation Bruno LEVEQUE
16:53 Re: Database creation Jeff Eckermann
17:31 Re: Problem with pg_hba.conf file in Postgres 7.3 April Carvalho
17:54 Re: Problem with pg_hba.conf file in Postgres 7.3 Oliver Elphick
18:26 Another issue with pg_hba.conf file & dumpall April Carvalho

27 January 2004

06:32 db security; user identification Marcin Gil
06:41 unexpected eof Marcin Gil
07:04 Re: postgre-7.4 and readline-4.3 /solaris 8 Patrice Durosay
07:51 Re: db security; user identification Martin Atukunda
09:22 Re: db security; user identification Marcin Gil
09:55 Re: db security; user identification Martin Atukunda
09:57 Re: db security; user identification Bruno Wolff III
09:58 Increase stored proc. parameters max count
10:26 Re: db security; user identification Marcin Gil
11:10 Re: unexpected eof Eddie Roosenmaallen
12:51 Re: db security; user identification Tom Lane
18:07 Querying the system catalog Marcel Wolf
18:56 Re: Querying the system catalog Bruno LEVEQUE
19:15 Re: Querying the system catalog Andre Dubuc
22:04 SELECT INTO but append not create new table - How? Alan T. Miller
22:28 Re: SELECT INTO but append not create new table - How? Tom Lane
22:41 Re: SELECT INTO but append not create new table - How? Alan T. Miller

28 January 2004

01:07 Install or Bust - pgsql on Red Hat 9 Phil Seretti
02:08 Re: Install or Bust - pgsql on Red Hat 9 Aarni Ruuhimäki
04:10 Re: Install or Bust - pgsql on Red Hat 9 Martin Atukunda
04:15 Re: db security; user identification Marcin Gil
04:23 Re: unexpected eof Marcin Gil
04:37 Re: db security; user identification Marcin Gil
08:43 pl/pgsql Function Problem Reinhard Hnat
11:21 Re: db security; user identification Tom Lane
12:05 List of tables Marcel Wolf
12:24 Re: pl/pgsql Function Problem Stephan Szabo
12:42 Re: List of tables George Weaver
15:01 Re: db security; user identification Bruno Wolff III
16:18 Setting date and time George Weaver
17:09 Russian characters Aarni Ruuhimäki

29 January 2004

00:25 Re: Russian characters Reshat Sabiq
00:55 Re: Setting date and time Manuel Sugawara
01:02 Re: Russian characters Manuel Sugawara
07:50 Re: Russian characters Aarni Ruuhimäki
08:18 COPY command cannot access file... Alan T. Miller
08:36 Re: COPY command cannot access file... HK
09:13 Re: COPY command cannot access file... Bruno Wolff III
09:39 Re: Setting date and time George Weaver
12:37 Re: Setting date and time Manuel Sugawara
12:47 Re: Setting date and time Tom Lane
13:30 Re: Setting date and time George Weaver
14:00 Re: Setting date and time Tom Lane

30 January 2004

18:42 Re: Install or Bust - pgsql on Red Hat 9 Markus Bertheau

31 January 2004

02:52 Restore Dataset Scott Taylor
02:54 Database installation query (PostgreSQL 7.4) Saket Bagade
03:13 Emailing a list of users when a record is entered in the database. nick.tew@budgens.co.uk (Nick Tew)
03:15 Method Question Ben Burkhart
03:16 'select nextval('seq_name');' in a function ? Pragati Kenkare
03:20 Can a user change their own password? chris@zenmgt.com
03:26 error when running ./configure Peggy Go
03:47 Re: Emailing a list of users when a record is entered in the database. Derrick Betts
11:23 Re: 'select nextval('seq_name');' in a function ? Stephan Szabo
11:50 Re: Method Question Stephan Szabo
13:07 Re: Method Question Tom Lane
16:22 "[" is a nuisance... Michael J. Conroy
18:42 Q: Reclaiming deleted space in data files Lawrence Smith
19:09 Re: Q: Reclaiming deleted space in data files Tom Lane
20:08 Re: "[" is a nuisance... Tom Lane
21:42 simple update closes connection. why? joseph speigle
22:02 Re: simple update closes connection. why? joseph speigle
22:44 Re: simple update closes connection. why? Tom Lane