Home > mailing lists

Mailing lists [pgsql-novice]

1 January 2004

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

3 January 2004

07:29 Question about Indexes... Alan T. Miller
09:46 Re: Question about Indexes... Aarni Ruuhimäki
21:19 Re: Question about Indexes... Tom Lane
21:31 Re: Question about Indexes... Andreas
21:37 Re: Question about Indexes... Andreas
22:19 Creating initial data bases G. Walsh

4 January 2004

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

5 January 2004

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

6 January 2004

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

7 January 2004

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

8 January 2004

00:07 Upgrade function problem - c language Cath Lawrence
05:15 Re: Upgrade function problem - c language Tom Lane
06:17 pgsql 7.0 recovery to 7.4 Marcin Gil
09:29 Re: partial index on varchar-coloumn in 7.4.1 Martin Hampl
13:46 Re: pgsql 7.0 recovery to 7.4 Tom Lane
14:50 Re: pgsql 7.0 recovery to 7.4 Marcin Gil
15:15 Re: pgsql 7.0 recovery to 7.4 Tom Lane
16:39 Re: pl/pgSQL sequence question Tom Lane
17:48 Re: partial index on varchar-coloumn in 7.4.1 Bruno Wolff III
20:16 Re: partial index on varchar-coloumn in 7.4.1 Tom Lane

9 January 2004

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

10 January 2004

01:20 unsubscribe sibu xolo
20:26 One big database or little separate ones? Dennis Veatch
21:16 Re: One big database or little separate ones? Bruno LEVEQUE
22:25 Re: One big database or little separate ones? Eric Frazier

11 January 2004

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

12 January 2004

02:28 Re: Get error during initdb George Weaver
02:38 Re: One big database or little separate ones? Andreas
03:07 Re: PQexec hangs, stuck on malloc_consolidate Tor Gunston
04:23 Cluster in users home Russell Shaw
05:52 Delete from a table with JOIN Noel
13:35 Re: Delete from a table with JOIN Tom Lane
14:34 Connect error Russell Shaw
14:39 Re: date comparison between perl and postgres Bruno Wolff III
14:43 Re: Connect error Bill Moseley
15:04 Re: Connect error Bruno Wolff III
15:39 Re: Connect error Sai Hertz And Control Systems
15:53 Re: Connect error Rod K
16:29 Re: Connect error Bill Moseley
16:57 Re: Connect error Bruno Wolff III
17:22 Re: [Ignor Whois] Re: Connect error Bill Moseley
19:12 Re: [Ignor Whois] Re: Connect error Bruno Wolff III
22:59 Re: Connect error Bill Moseley

13 January 2004

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

14 January 2004

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

15 January 2004

00:07 Re: SQL_ASCII / LATIN1 Aarni Ruuhimäki
14:37 Re: Aarni Ruuhimäki

16 January 2004

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

17 January 2004

04:37 Re: changing start value of sequence after it was created... joseph speigle
12:59 unsubscribe sibu xolo
23:39 indexing date and timestamp fields... Alan T. Miller

18 January 2004

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

19 January 2004

00:26 Re: How to turn flat file to SQL Josh Berkus
03:27 Re: New at this. Commissioning for the first time: Tom Lane
03:33 Re: installing postgre Tom Lane
04:19 Re: query Bruno Wolff III
06:51 Re: Discarding UNIQUE temporarily? Tom Lane
13:02 Re: Meta data about object in postgres glenn
14:41 Re: How can I select a comment on a column in a query? George Weaver
14:54 Re: How can I select a comment on a column in a query? Tom Lane
19:10 absolute beginner Lduren02@aol.com
19:19 Re: absolute beginner Rob Sell
19:50 Re: absolute beginner Tom Lane
21:36 timestamptz insert Seader, Cameron
22:05 Re: timestamptz insert Tom Lane

20 January 2004

00:35 long deletes :( Pls help Noel
00:46 Re: long deletes :( Pls help Noel
01:39 Re: long deletes :( Pls help Tom Lane
01:48 Re: long deletes :( Pls help Tom Lane
05:12 CREATEDB failure Paul Bauer
08:46 Re: CREATEDB failure Oliver Fromme

21 January 2004

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

22 January 2004

12:30 Using OLD on INSERT Paul Makepeace
13:28 executing backup remotly Iandé Coutinho
13:32 Re: Using OLD on INSERT Terry Lee Tucker
13:54 Re: Using OLD on INSERT Terry Lee Tucker
14:26 Re: Using OLD on INSERT Marcus Andree S. Magalhaes
14:49 Re: executing backup remotly Tom Lane
21:38 HowTo configure and compile with openssl and jdbc on RedHat Enterprise 3? chris@goforit.de
22:19 Re: HowTo configure and compile with openssl and jdbc on Bruno LEVEQUE
22:48 Re: HowTo configure and compile with openssl and jdbc on chris@goforit.de

23 January 2004

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

24 January 2004

12:25 error when configuring postgresql7.4 -> ./src/template/linux Peggy Go
20:04 Re: error when configuring postgresql7.4 -> ./src/template/linux Tom Lane

25 January 2004

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

26 January 2004

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

27 January 2004

09:32 db security; user identification Marcin Gil
09:41 unexpected eof Marcin Gil
10:04 Re: postgre-7.4 and readline-4.3 /solaris 8 Patrice Durosay
10:51 Re: db security; user identification Martin Atukunda
12:22 Re: db security; user identification Marcin Gil
12:55 Re: db security; user identification Martin Atukunda
12:57 Re: db security; user identification Bruno Wolff III
12:58 Increase stored proc. parameters max count
13:26 Re: db security; user identification Marcin Gil
14:10 Re: unexpected eof Eddie Roosenmaallen
15:51 Re: db security; user identification Tom Lane
21:07 Querying the system catalog Marcel Wolf
21:56 Re: Querying the system catalog Bruno LEVEQUE
22:15 Re: Querying the system catalog Andre Dubuc

28 January 2004

01:04 SELECT INTO but append not create new table - How? Alan T. Miller
01:28 Re: SELECT INTO but append not create new table - How? Tom Lane
01:41 Re: SELECT INTO but append not create new table - How? Alan T. Miller
04:07 Install or Bust - pgsql on Red Hat 9 Phil Seretti
05:08 Re: Install or Bust - pgsql on Red Hat 9 Aarni Ruuhimäki
07:10 Re: Install or Bust - pgsql on Red Hat 9 Martin Atukunda
07:15 Re: db security; user identification Marcin Gil
07:23 Re: unexpected eof Marcin Gil
07:37 Re: db security; user identification Marcin Gil
11:43 pl/pgsql Function Problem Reinhard Hnat
14:21 Re: db security; user identification Tom Lane
15:05 List of tables Marcel Wolf
15:24 Re: pl/pgsql Function Problem Stephan Szabo
15:42 Re: List of tables George Weaver
18:01 Re: db security; user identification Bruno Wolff III
19:18 Setting date and time George Weaver
20:09 Russian characters Aarni Ruuhimäki

29 January 2004

03:25 Re: Russian characters Reshat Sabiq
03:55 Re: Setting date and time Manuel Sugawara
04:02 Re: Russian characters Manuel Sugawara
10:50 Re: Russian characters Aarni Ruuhimäki
11:18 COPY command cannot access file... Alan T. Miller
11:36 Re: COPY command cannot access file... HK
12:13 Re: COPY command cannot access file... Bruno Wolff III
12:39 Re: Setting date and time George Weaver
15:37 Re: Setting date and time Manuel Sugawara
15:47 Re: Setting date and time Tom Lane
16:30 Re: Setting date and time George Weaver
17:00 Re: Setting date and time Tom Lane

30 January 2004

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

31 January 2004

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