Home > mailing lists

Mailing lists [pgsql-novice]

1 January 2005

19:09 Grant on multiple objects Jason Dixon
22:04 Re: Grant on multiple objects Bruno Wolff III
22:34 Re: Grant on multiple objects Jason Dixon

2 January 2005

06:38 LOOping clobbering variable K Anderson
08:07 Re: LOOping clobbering variable Michael Fuhr
08:16 Re: LOOping clobbering variable Stephan Szabo

3 January 2005

02:06 Re: LOOping clobbering variable K Anderson
02:47 Re: LOOping clobbering variable Michael Fuhr
18:50 Installation Jorge Pérez
19:42 Re: [despammed] Installation Andreas Kretschmer
20:30 Re: [despammed] Installation Jorge Pérez
21:08 Re: [despammed] Installation Afton & Ray Still
21:17 Re: [despammed] Installation Kretschmer Andreas

4 January 2005

01:56 Re: [despammed] Installation Jorge Pérez
02:05 checksumming data Can Burak Cilingir
03:59 postgresql for windows Ramon Orticio
04:14 Re: checksumming data Michael Fuhr
05:12 Creating a clean database Keith Worthington
06:47 Re: Creating a clean database Michael Fuhr
09:12 Re: [despammed] postgresql for windows Andreas Kretschmer
11:26 Re: checksumming data Can Burak Cilingir
13:53 perl DBI and SQL COPY Sean Davis
14:59 Re: perl DBI and SQL COPY Sean Davis
15:14 Re: Creating a clean database Keith Worthington
15:28 Day name, month name from a datetime field Deepa K
16:03 Re: [despammed] Day name, month name from a datetime field Andreas Kretschmer
18:11 Re: pg_config missing in install Sukhdeep Johar
18:14 Re: [despammed] Installation Jeff Eckermann
18:48 Re: checksumming data Michael Fuhr
19:53 Re: pg_config missing in install brew@theMode.com
20:20 Re: Creating a clean database Michael Fuhr

5 January 2005

01:16 Re: Creating a clean database Ennio-Sr
01:18 Re: Creating a clean database Keith Worthington
04:20 Re: Creating a clean database Michael Fuhr
08:23 Analysis Services supported by postgres? Jason Monserrate
08:36 posgrestsql for windows Ramon Orticio
08:40 java database and postgresql Ramon Orticio
08:43 postgresql or mysql or oracle? Ramon Orticio
11:30 Re: java database and postgresql Christian Poecher
20:18 Re: Analysis Services supported by postgres? Kretschmer Andreas
20:42 Re: cleaning up template1 Steven Klassen

6 January 2005

07:57 [Fwd: Day name, month name from a datetime field] Deepa K
08:43 Re: [Fwd: Day name, month name from a datetime field] Michael Fuhr
22:16 Static variables Ronnie Meier Ramos

7 January 2005

05:17 genetic algorithms Cima
11:36 Updating views : cannot figure out what goes wrong Dirk Cleenwerck
11:37 trigger for granting permission to select a table as soon it is created santosh dwivedi
12:51 Re: trigger for granting permission to select a table as soon it is created Michael Fuhr
14:11 Re: genetic algorithms Sean Davis
17:20 I'm a beginner Peeters Julien
18:23 Re: Updating views : cannot figure out what goes wrong Stephan Szabo
20:42 moving database to a new partition on disk sarlav kumar
21:23 count(*) index Tomka Gergely
21:41 Driver Information Please Julie Cottin
22:32 Re: count(*) index Bruno Wolff III

8 January 2005

00:23 Re: Duplicating A Row Jeffrey Melloy

9 January 2005

12:52 scripts Miguel Higuera
12:52 Updating views : cannot figure out what goes wrong Admin
12:52 Re: postgresql or mysql or oracle? Randolf Richardson
12:54 Re: genetic algorithms Predictor
12:56 .sql howto Ahmed Sarwar
12:57 trigger for granting permission to select a table as soon it is created santosh dwivedi
14:23 Re: .sql howto Kretschmer Andreas
19:00 Re: scripts Michael Fuhr
21:28 Re: postgresql or mysql or oracle? Bruno Wolff III
21:47 Re: postgresql or mysql or oracle? Tom Lane
23:54 Re: postgresql or mysql or oracle? Bruce Momjian

10 January 2005

15:16 Re: postgresql or mysql or oracle? Dick Davies
16:06 Re: postgresql or mysql or oracle? Dirk Cleenwerck
22:12 index problem Tomka Gergely
23:06 Re: index problem Michael Fuhr

11 January 2005

02:04 Conditionally altering tables Colin McGuigan
06:47 Re: Conditionally altering tables Mike G.
14:15 Major Problems with pg_dump KÖPFERL Robert
17:59 Re: Conditionally altering tables Colin McGuigan
18:12 Re: Major Problems with pg_dump Tom Lane
18:47 Re: Major Problems with pg_dump KÖPFERL Robert
20:19 Writing to dependent tables in a function Keith Worthington
20:31 Re: Major Problems with pg_dump Michael Fuhr
20:57 Re: Major Problems with pg_dump Tom Lane
21:38 DELETE & INSERT in a function Keith Worthington
22:08 Re: Writing to dependent tables in a function Tom Lane
22:17 Re: DELETE & INSERT in a function Vishal Kashyap @ [SaiHertz]
22:49 Re: Writing to dependent tables in a function Keith Worthington

12 January 2005

08:31 pgAdminIII for linux Ramon Orticio
08:42 Re: pgAdminIII for linux Mike G
10:31 postgresql.conf in windowsXP Ramon Orticio
10:36 postgresql documentation for windowsXP Ramon Orticio
15:44 Re: postgresql.conf in windowsXP John DeSoi
15:48 Re: postgresql documentation for windowsXP John DeSoi
16:02 rescue databases after upgrade? test@fredens.net
19:58 Re: Writing to dependent tables in a function Keith Worthington
21:56 FK relationships sarlav kumar
22:31 Re: FK relationships Michael Fuhr
23:07 Re: FK relationships sarlav kumar
23:42 Re: FK relationships Michael Fuhr

13 January 2005

00:01 Re: FK relationships sarlav kumar
00:23 Re: FK relationships Michael Fuhr
03:25 Ampersands in the output... Schuhmacher, Bret
03:52 Re: Ampersands in the output... Mitch Pirtle
04:29 Re: Ampersands in the output... Schuhmacher, Bret
05:50 pgadmin III in linux -where are the installed files located? Ramon Orticio
06:55 Re: pgadmin III in linux -where are the installed files located? Mitch Pirtle
11:03 Re: pgadmin III in linux -where are the installed files located? Aarni Ruuhimäki
11:34 Re: rescue databases after upgrade? Devrim GUNDUZ
16:35 Copying a database Lawrence Moran
16:56 Re: Copying a database Sean Davis
17:18 Re: Copying a database Michael Glaesemann
17:36 Re: Ampersands in the output... Jeff Eckermann
22:12 Re: Copying a database Bruno Wolff III

14 January 2005

08:13 postgres and pgamind3 for windows Ramon Orticio
08:17 pgadmin3 change language Ramon Orticio
11:55 Re: postgres and pgamind3 for windows Mike G
11:55 Re: pgadmin3 change language Alexander Borkowski
11:55 Re: postgres and pgamind3 for windows Alexander Borkowski
11:55 Re: postgres and pgamind3 for windows John DeSoi
17:39 query optimization help sarlav kumar
18:27 Re: [PERFORM] query optimization help sarlav kumar
20:43 N/A Keith Worthington
21:32 Re: N/A John DeSoi
21:36 SQL from shell script sarlav kumar
21:46 Re: SQL from shell script Sean Davis
22:13 Re: SQL from shell script sarlav kumar
22:27 Re: SQL from shell script Schuhmacher, Bret
22:33 Re: SQL from shell script Geoffrey
22:58 Re: SQL from shell script Michael Fuhr
23:05 Re: SQL from shell script Sean Davis
23:32 Re: SQL from shell script sarlav kumar

15 January 2005

05:48 Common question: what's wrong przygoda@klub.chip.pl
05:56 Re: postgresql or mysql or oracle? Christopher Browne
16:38 Re: Common question: what's wrong John DeSoi
17:00 Re: Common question: what's wrong Terry Lee Tucker

16 January 2005

10:37 Get DB Structure Hadi Saboohi
19:24 Re: Get DB Structure Steven Klassen

17 January 2005

05:11 postgresql8 for windowsXP Ramon Orticio
05:36 creating and updating tables using pgadminIII Ramon Orticio
07:27 Re: postgresql8 for windowsXP Mike G.
08:05 Re: postgresql8 for windowsXP Afton & Ray Still
09:19 Backup database and logs Prasanna Srinivasan Venkatasubramanian
13:47 Re: N/A KÖPFERL Robert
13:59 Change the name of the database Sylvain Brohée
14:20 Re: Change the name of the database Chris Mair
14:22 Re: [despammed] Change the name of the database Andreas Kretschmer
14:38 LOG: unexpected EOF on client connection Prasanna Srinivasan Venkatasubramanian
15:26 Re: Common question: what's wrong Adie
16:30 Sql query as input variable in a PL/pgsql function? Tjibbe Rijpma
16:58 Re: Sql query as input variable in a PL/pgsql function? Sean Davis
18:43 Re: Change the name of the database Tom Lane

18 January 2005

01:08 Re: Updating views : cannot figure out what goes wrong Jaime Casanova
02:42 How the get variables out of a plggsql RECORD by column number Tjibbe Rijpma
05:16 can't add connection to server in windowsXP using pgadminIII Ramon Orticio
05:58 Re: can't add connection to server in windowsXP using Afton & Ray Still
15:06 Re: can't add connection to server in windowsXP using pgadminIII Keith Worthington
16:06 Re: can't add connection to server in windowsXP using pgadminIII Luiz K. Matsumura
16:54 Change database encoding Luiz K. Matsumura
17:41 Re: How the get variables out of a plggsql RECORD by column number Jeff Eckermann
21:36 generating dynamic queries using pl/pgsql sarlav kumar
21:54 Re: How the get variables out of a plggsql RECORD by column number Keith Worthington

19 January 2005

08:30 dropdb command not working. Pradeepkumar, Pyatalo (IE10)
09:01 Re: generating dynamic queries using pl/pgsql K Anderson
09:02 Re: dropdb command not working. Michael Fuhr
12:11 reinstalled postgresql-8.0.0-rc5-2 Ramon Orticio
13:06 Re: How the get variables out of a plggsql RECORD by column number Tjibbe Rijpma
17:12 8.0 release Keith Worthington
17:17 rhdb to v8 upgrade procedure Keith Worthington
17:26 Re: rhdb to v8 upgrade procedure Devrim GUNDUZ
17:30 Re: 8.0 release Devrim GUNDUZ
18:09 How to "COPY schema1.table TO schema2.table" ? Andreas Neumann
19:27 Re: How the get variables out of a plggsql RECORD by column number Jeff Eckermann
19:42 Re: rhdb to v8 upgrade procedure Keith Worthington

20 January 2005

03:32 log file Keith Worthington
05:12 password authentication always failed Akbar
05:22 Re: log file Michael Fuhr
06:12 grant all the database object automatically Akbar
08:31 Re: grant all the database object automatically Mike G.
08:36 Re: How to "COPY schema1.table TO schema2.table" ? Mike G.
08:39 Re: reinstalled postgresql-8.0.0-rc5-2 Mike G.
08:46 Re: password authentication always failed Mike G.
10:35 7.4.x to 8.0 upgrade process Marcin Gil
13:21 permissions problem? ann hedley
13:57 Re: password authentication always failed Akbar
14:13 Re: permissions problem? Sean Davis
14:26 Re: permissions problem? ann hedley
14:50 Re: permissions problem? ann hedley
15:29 Re: How to "COPY schema1.table TO schema2.table" ? Andreas Neumann
16:21 Re: 7.4.x to 8.0 upgrade process Sean Davis
16:36 pg_hba.conf and upgrade Sean Davis
17:46 Re: pg_hba.conf and upgrade Jeff Eckermann
18:22 Re: 7.4.x to 8.0 upgrade process Marcin Gil
18:32 Re: 7.4.x to 8.0 upgrade process Sean Davis
19:01 postgresql log file on fc2 Kevin B.
19:10 Strange User Problem
19:18 Re: postgresql log file on fc2 Sean Davis
19:30 Re: Strange User Problem Sean Davis
19:37 Re: Strange User Problem
20:40 Re: generating dynamic queries using pl/pgsql sarlav kumar
20:51 Re: generating dynamic queries using pl/pgsql Sean Davis
23:28 What Do I Need to Get Started with PostreSQL for Win32 (version 8.0) Van Ingen, Lane
23:55 Re: What Do I Need to Get Started with PostreSQL for Win32 (version 8.0) Tjibbe Rijpma
23:58 Re: What Do I Need to Get Started with PostreSQL for Win32 (version 8.0) Sean Davis

21 January 2005

00:08 Re: What Do I Need to Get Started with PostreSQL for Win32 (version 8.0) John DeSoi
02:22 Error Help Daniel Blavos
03:09 Re: grant all the database object automatically Bruno Wolff III
04:27 Re: pg_hba.conf and upgrade Mike G.
07:34 Problems with PL/pgSQL and LIKE statement Paul Murphy
07:37 Karim Mardhani
07:41 Error Help Daniel Blavos
07:41 Re: Problem with pl/perl in postgresql Iain
07:43 Windows 2000 Pro Error on Install Shaun McGuile
07:44 hoe to connect postgres database thru perl sudheer raghav
07:45 Postgresql on windows Subha
07:58 Re: Problems with PL/pgSQL and LIKE statement Schuhmacher, Bret
08:01 Re: Windows 2000 Pro Error on Install Mike G.
08:09 Re: How to "COPY schema1.table TO schema2.table" ? Mike G.
08:27 Re: Postgresql on windows John DeSoi
10:19 Re: John DeSoi
11:09 Re: grant all the database object automatically Akbar
11:13 Re: Windows 2000 Pro Error on Install Shaun McGuile
14:08 Re: hoe to connect postgres database thru perl Sean Davis
14:11 Re: Sean Davis
14:14 Re: grant all the database object automatically Sean Davis
15:59 Re: pg_hba.conf and upgrade Sean Davis
16:47 Re: grant all the database object automatically John DeSoi
17:53 Re: grant all the database object automatically George Weaver
17:57 Re: Error Help Jeff Eckermann
18:53 Re: grant all the database object automatically John DeSoi
19:00 Re: generating dynamic queries using pl/pgsql sarlav kumar
19:12 Re: generating dynamic queries using pl/pgsql Sean Davis
19:19 Re: How to "COPY schema1.table TO schema2.table" ? Andreas Neumann
19:26 Re: grant all the database object automatically George Weaver
19:44 Re: generating dynamic queries using pl/pgsql sarlav kumar
19:48 Re: Aly Dharshi
19:53 Re: generating dynamic queries using pl/pgsql Sean Davis
20:28 Re: How to "COPY schema1.table TO schema2.table" ? Michael Fuhr
20:39 Re: How to "COPY schema1.table TO schema2.table" ? Mike G.
21:15 Windows 8.0 Install Failure Van Ingen, Lane
23:56 Primary keys and indexes Keith Worthington

22 January 2005

00:09 Re: Primary keys and indexes Bruno Wolff III
01:50 Upgrade from v8rc5 to 8.0.0 fails Keith Worthington
02:14 Re: generating dynamic queries using pl/pgsql John DeSoi
02:15 SQL and DB Connection Question (Interfacing with PHP)
05:37 Re: Upgrade from v8rc5 to 8.0.0 fails Michael Fuhr
06:30 Re: SQL and DB Connection Question (Interfacing with PHP) Michael Fuhr
08:53 Re: Windows 8.0 Install Failure Mike G.
09:08 Re: Windows 2000 Pro Error on Install Mike G.

23 January 2005

01:46 problems importing a dbf file - dbf2pg broken? Andy Bernat
03:30 Re: Upgrade from v8rc5 to 8.0.0 fails Keith Worthington

24 January 2005

09:46 find column names from query Afton & Ray Still
11:42 Re: find column names from query Michael Fuhr
11:51 Re: find column names from query Tjibbe Rijpma
17:12 Re: find column names from query Afton & Ray Still
18:47 Re: find column names from query Michael Fuhr
18:59 Re: find column names from query Afton & Ray Still

25 January 2005

02:49 MS SQL Server <-> PostgreSQL data migration _that_ _actually_ _works_? Wolfgang Keller
03:00 extracting date from timestamp Keith Worthington
03:46 Re: extracting date from timestamp Alexander Borkowski
03:47 Re: extracting date from timestamp Tom Lane
04:44 Formatting a month in query output Rodolfo J. Paiz
04:49 SQL and function reference? Rodolfo J. Paiz
04:57 Output HTML, or just a handle? Rodolfo J. Paiz
04:59 Removing a user's password Rodolfo J. Paiz
05:05 recommended programming language for postgresql Ramon Orticio
05:44 Re: Output HTML, or just a handle? Alexander Borkowski
05:48 Re: SQL and function reference? Alexander Borkowski
05:51 Re: recommended programming language for postgresql Sean Davis
05:53 Re: recommended programming language for postgresql Jason Dixon
05:54 Re: Output HTML, or just a handle? Jason Dixon
05:56 Re: recommended programming language for postgresql Alexander Borkowski
05:57 Re: SQL and function reference? Sean Davis
05:57 Re: SQL and function reference? Jason Dixon
05:58 Re: Formatting a month in query output Sean Davis
05:59 Re: Formatting a month in query output Alexander Borkowski
05:59 Re: Output HTML, or just a handle? Sean Davis
06:08 Re: Output HTML, or just a handle? Alexander Borkowski
06:48 Re: Removing a user's password Tom Lane
08:03 Re: extracting date from timestamp Michael Fuhr
08:23 programming language for postgresql Ramon Orticio
09:07 Re: programming language for postgresql Noel Faux
10:35 Re: programming language for postgresql brew@theMode.com
13:08 Help with concurrent insertions. Pradeepkumar, Pyatalo (IE10)
14:29 Re: programming language for postgresql Sean Davis
17:07 Re: programming language for postgresql Glenn Davy
18:49 Re: programming language for postgresql Jeff Eckermann
19:10 Re: SQL and function reference? Rodolfo J. Paiz
19:33 Re: SQL and function reference? Rodolfo J. Paiz
19:36 Re: recommended programming language for postgresql Rodolfo J. Paiz
19:40 Re: Formatting a month in query output Sean Davis
19:41 Re: Removing a user's password Rodolfo J. Paiz
19:56 Re: recommended programming language for postgresql Jason Dixon
20:01 Re: SQL and function reference? Michael Fuhr
20:20 Re: Problems with PL/pgSQL and LIKE statement Paul Murphy
20:31 BatchMove with PostgreSQL Márcio Vinícius
20:31 Re: Help with concurrent insertions. Christopher Browne
20:31 How to create Geo Types from numeric? Klaus
20:32 Installing dblink Mike Disbrow
20:33 Re: recommended programming language for postgresql Hari Bhanujan
20:33 Restore postgres database problem Inpreet Singh
20:33 How to update dependent tables AND design considerations Klaus
20:35 Re: How to create Geo Types from numeric? Klaus W.
20:36 Postgres database access problem Inpreet Singh
20:47 Re: How to create Geo Types from numeric? Michael Fuhr
20:49 Re: [despammed] Installing dblink Andreas Kretschmer
20:50 Re: programming language for postgresql M. Bastin
21:00 Re: How to create Geo Types from numeric? Tom Lane
21:12 Re: Installing dblink Devrim GUNDUZ
21:23 Re: BatchMove with PostgreSQL Michael Fuhr
21:55 Re: programming language for postgresql Gustavo Pinsard
22:02 Re: BatchMove with PostgreSQL M. Bastin
22:19 Re: postgresql or mysql or oracle? Gustavo Pinsard

26 January 2005

01:23 Resetting sequence Keith Worthington
02:05 Re: Resetting sequence Michael Fuhr
12:23 printing reports for posgresql Ramon Orticio
12:46 Re: [despammed] printing reports for posgresql Andreas Kretschmer
19:07 Re: Error Help Jeff Eckermann
19:39 Re: SQL and function reference? Rodolfo J. Paiz
19:58 Re: SQL and function reference? Rodolfo J. Paiz
20:18 Re: Formatting a month in query output Rodolfo J. Paiz
20:19 Two copies of every mail! Rodolfo J. Paiz
20:36 Re: Two copies of every mail! Tom Lane
21:10 Re: Two copies of every mail! Marc G. Fournier
21:17 Re: Two copies of every mail! Rodolfo J. Paiz
22:07 DB Crash, recoverable? Michael Guerin
22:54 Re: DB Crash, recoverable? Tom Lane
22:57 Postgres 8.0 on FAT32 Eduardo Vázquez Rodríguez
23:08 Re: DB Crash, recoverable? Michael Guerin
23:10 Re: DB Crash, recoverable? Tom Lane

27 January 2005

00:32 Re: DB Crash, recoverable? Michael Guerin
00:32 Re: Postgres 8.0 on FAT32 Josh Berkus
00:35 Re: DB Crash, recoverable? Tom Lane
01:09 Re: Postgres 8.0 on FAT32 Eduardo Vázquez Rodríguez
02:22 Re: Postgres database access problem
02:26 Re: SQL and function reference? Alexander Borkowski
02:35 Re: SQL and function reference? Tom Lane
02:36 Re: Formatting a month in query output Alexander Borkowski
03:42 Re: Two copies of every mail! Rodolfo J. Paiz
04:00 Re: Formatting a month in query output Rodolfo J. Paiz
04:32 Re: Formatting a month in query output Alexander Borkowski
04:40 Re: Formatting a month in query output Rodolfo J. Paiz
05:04 Re: Formatting a month in query output Alexander Borkowski
08:14 Re: Two copies of every mail! Bruno Wolff III
08:34 Re: Two copies of every mail! Tom Lane
09:11 Re: Two copies of every mail! John DeSoi
11:00 Compilation error on Solaris for Postgres-8.0.0 Rajan Bhide
12:31 Re: recommended programming language for postgresql Peter Lavender
16:26 How PostGre keeps datastorage files Dmitry Konnov
16:50 Re: How PostGre keeps datastorage files Sean Davis
17:13 Re: next question Sean Davis
17:53 Re: Two copies of every mail! Tom Lane
17:57 Re: Compilation error on Solaris for Postgres-8.0.0 Tom Lane
19:15 Re: Two copies of every mail! John DeSoi

28 January 2005

00:09 pg_attribute table Afton & Ray Still
03:03 Re: pg_attribute table Tom Lane
03:48 Can't Get Going in psql Van Ingen, Lane
07:10 Re: Can't Get Going in psql John DeSoi
17:27 How to get hold of postgres sql Justus Mugbeh
17:47 Re: How to get hold of postgres sql John DeSoi
19:51 Creating A Tablespace in PostgreSQL 8.0 for Windows Van Ingen, Lane
20:35 Re: Creating A Tablespace in PostgreSQL 8.0 for Windows Van Ingen, Lane
23:58 How To Create DATETIME Data Types in A Table Van Ingen, Lane

29 January 2005

00:13 Re: How To Create DATETIME Data Types in A Table John DeSoi
00:15 Re: How To Create DATETIME Data Types in A Table Bruno Wolff III
02:25 Order by and words beginning with capitals Tjibbe Rijpma
03:15 Re: Order by and words beginning with capitals Tom Lane
14:11 History question. Please name all clones of PostGre Dmitry Konnov

30 January 2005

00:37 Re: Postgres database access problem Inpreet Singh
00:37 distinct vs group by Ron Mayer
01:08 Re: distinct vs group by Bruno Wolff III
01:14 Re: distinct vs group by Tom Lane
01:16 Re: Postgres database access problem Tom Lane

31 January 2005

18:36 pgAdminIII and User Grants
18:48 Re: function returning a row Kjetil Haaland
20:24 Re: function returning a row Tom Lane
21:38 Date / Time Data Type Van Ingen, Lane
21:53 How to learn Postgres? Tomas Eroles i Forner
22:03 Re: Date / Time Data Type Frank Bax
22:05 Re: Date / Time Data Type Tom Lane
22:14 Re: Date / Time Data Type Van Ingen, Lane
22:15 Re: How to learn Postgres? Terry Lee Tucker
22:15 Last ID Problem
22:28 Re: Last ID Problem Vishal Kashyap @ [SaiHertz]
22:38 Re: Last ID Problem
22:48 Re: How to learn Postgres? Michael Fuhr
22:55 Re: Last ID Problem Mitch Pirtle
23:19 Re: Last ID Problem Vishal Kashyap @ [SaiHertz]