Home > mailing lists

Mailing lists [pgsql-novice]

1 March 2005

06:39 Re: Using upper() / decode() together Ross Gohlke
10:24 Re: Import csv file into multiple tables in Postgres Todd Lewis
17:53 Anyarray with mixed data types inside of a PL/PLSQL function parameter Christian Hofmann
20:04 Re: Import csv file into multiple tables in Postgres Keith Worthington
20:33 Please help Kumar S
20:56 Re: Please help Sean Davis
21:03 Re: Please help Kumar S
21:27 Re: Anyarray with mixed data types inside of a PL/PLSQL function parameter Tom Lane
21:41 Re: Please help
21:58 Re: Please help Sean Davis
23:39 Form Design Advice
23:53 Re: Form Design Advice Sean Davis

2 March 2005

00:25 Re: Form Design Advice
00:32 difference between varchar and varchar[] in pgadmin3 (and maybe postgres, too)
00:41 Fwd: [GENERAL] Novice Question Sean Davis
01:00 Re: Form Design Advice Frank Bax
01:01 Re: Form Design Advice Keith Worthington
04:43 Re: Form Design Advice
04:53 Re: Form Design Advice
05:39 Re: difference between varchar and varchar[] in pgadmin3 (and George Weaver
08:55 Database Name Envbop
15:23 Re: Form Design Advice Ross Gohlke
20:48 Embed SQL in C GMX
21:44 User right management concerning functions Christian Hofmann
22:55 Re: Form Design Advice

3 March 2005

03:23 Blasted Errors on everything. Daniel Blavos
20:06 Re: Blasted Errors on everything.
23:12 Re: Import csv file into multiple tables in Postgres Deepblues
23:48 Re: Import csv file into multiple tables in Postgres Sean Davis

4 March 2005

00:20 Re: Form Design Advice Bruno Wolff III
09:12 Re: Form Design Advice Ross Gohlke
14:21 Help on Trigger functions Pradeepkumar, Pyatalo (IE10)
17:27 Re: User right management concerning functions Bruno Wolff III
17:56 Re: Import csv file into multiple tables in Postgres Bruno Wolff III
17:58 Re: Help on Trigger functions Keith Worthington
18:01 Re: Form Design Advice Bruno Wolff III
19:25 Re: Form Design Advice Ross Gohlke
19:32 Re: Form Design Advice Colin McGuigan
19:46 Re: Form Design Advice Ross Gohlke
20:35 Re: Form Design Advice Geoffrey
20:46 Re: Form Design Advice Bruno Wolff III
21:05 Re: Form Design Advice Mike Ellsworth

5 March 2005

00:57 undefined function: pg_connect() Kunal
00:57 Re: PL/Pgsql or PL/Python? Stuart Bishop
00:59 PostgreSQL installation problem on Windows XP Home Hagop H.
01:00 SQL embedded in C AniLAN
01:01 gmake fails with 7.2.2 Paul Comitz
02:52 Re: Form Design Advice
02:57 Re: Form Design Advice
06:49 Re: PostgreSQL installation problem on Windows XP Home Afton & Ray Still
07:55 Re: gmake fails with 7.2.2 Tom Lane
09:34 Re: Form Design Advice Bruno Wolff III
22:40 Currval question and confusion Kumar S
23:05 Re: Currval question and confusion Michael Fuhr

6 March 2005

08:29 background jobs Kumar S
10:11 Getting started - Interfacing questions David
15:20 Re: Getting started - Interfacing questions Sean Davis
16:20 Re: Getting started - Interfacing questions John DeSoi
16:21 Database drivers Philip Pinkerton
16:28 Re: background jobs Michael Fuhr
19:05 Re: background jobs Kumar S
21:20 Re: background jobs Sean Davis
21:56 Python modules for PL/Python? Wolfgang Keller
22:26 Re: Python modules for PL/Python? Michael Fuhr

7 March 2005

02:09 Re: Getting started - Interfacing questions David
02:09 Re: Getting started - Interfacing questions David
05:04 Error in transaction... Log file Kumar S
06:44 Re: Error in transaction... Log file Michael Fuhr
07:08 Re: Embed SQL in C Michael Fuhr
07:10 Re: Embed SQL in C Michael Fuhr
09:40 Re: Python modules for PL/Python? Wolfgang Keller
10:33 Re: [INTERFACES] Python modules for PL/Python? Michael Fuhr
17:13 Re: Getting started - Interfacing questions Sean Davis
18:28 Re: background jobs Eduardo Vázquez Rodríguez

8 March 2005

01:28 Primary key constraints Kumar S
02:51 Re: Primary key constraints Sean Davis
07:20 Re: [ADMIN] PostgreSQL installation problem on Windows XP Home Bearden Barnes
07:20 QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database NetSuporte
07:23 Re: [ADMIN] PostgreSQL installation problem on Windows XP Home Magnus Hagander
07:24 Need some install help .....pgsql8.0.1 on Suse Linux 9.2 pro John Phillips
07:43 Constructors in clases cima
08:31 Re: Getting started - Interfacing questions David
09:53 Re: Getting started - Interfacing questions John DeSoi
10:05 Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database John DeSoi
10:07 Re: [ADMIN] PostgreSQL installation problem on Windows XP Home Afton & Ray Still
10:25 Re: Constructors in clases Michael Fuhr
17:48 Foreign key error, please help. Kumar S
17:57 Re: Foreign key error, please help. Stephan Szabo
18:15 Re: Getting started - Interfacing questions David
18:58 Re: Getting started - Interfacing questions John DeSoi
19:02 Re: Getting started - Interfacing questions Sean Davis
19:58 Re: Getting started - Interfacing questions brew@theMode.com
20:27 Re: Getting started - Interfacing questions
20:38 Re: Getting started - Interfacing questions Bruno Wolff III
22:36 lfcr with plpgsql Derrick Betts

9 March 2005

00:30 Re: lfcr with plpgsql Michael Fuhr
01:12 Re: lfcr with plpgsql Derrick Betts
03:42 Re: lfcr with plpgsql Michael Fuhr
05:07 Re: lfcr with plpgsql Derrick Betts
05:33 Re: lfcr with plpgsql Michael Fuhr
05:44 Re: lfcr with plpgsql Derrick Betts
05:59 Re: Getting started - Interfacing questions brew@theMode.com
06:56 Defining functions accepting sets Keith Worthington
08:31 Re: Getting started - Interfacing questions David
08:31 Re: Getting started - Interfacing questions David
08:31 Re: Getting started - Interfacing questions David
08:31 Re: Getting started - Interfacing questions David
08:31 Re: Getting started - Interfacing questions David
11:26 Re: Getting started - Interfacing questions Bruno Wolff III
14:07 Re: lfcr with plpgsql Sean Davis
16:58 Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database John DeSoi
17:47 Re: Foreign key error, please help. Kumar S
18:05 Re: Foreign key error, please help. Bruno Wolff III
18:20 When are trigger function results committed Keith Worthington
18:25 Re: When are trigger function results committed Tom Lane
18:26 Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database John DeSoi
18:58 Re: Foreign key error, please help. Stephan Szabo
20:14 Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database John DeSoi
20:39 Storing Documents
20:42 VERY basic psql and schema question Sean Davis
20:55 Exporting Tables Sean
21:01 Re: Foreign key error, please help.
21:39 Re: VERY basic psql and schema question John DeSoi
21:49 Re: Exporting Tables John DeSoi
22:17 currval and select statements Kumar S
22:29 Re: VERY basic psql and schema question Sean Davis
22:36 Re: Storing Documents Mitch Pirtle

10 March 2005

00:02 Duplication error . please help. Kumar S
00:37 Re: Duplication error . please help. Sean Davis
01:48 Re: Getting started - Interfacing questions
04:09 Re: Storing Documents John DeSoi
05:06 Re: Getting started - Interfacing questions David

11 March 2005

19:45 complex queries Kumar S
20:47 Re: [GENERAL] MS Access to PostgreSQL Michael Fuhr
20:53 Re: complex queries Sean Davis

12 March 2005

01:41 Acccessing individual array elements form plpgsql Celia McInnis
01:46 Re: Acccessing individual array elements form plpgsql Tom Lane
02:27 Re: Acccessing individual array elements form plpgsql Celia McInnis
03:44 Re: Acccessing individual array elements form plpgsql Tom Lane
09:44 Compiling Data Type Sandy Eggi Martedi
23:54 Re: complex queries Todd Lewis

14 March 2005

05:23 Acessing array element from plpgsql Celia McInnis
05:24 Re: [JDBC] [GENERAL] MS Access to PostgreSQL Ragnar Hafstað
05:24 VB + PostgreSQL 8 Peter Denis Harari
05:25 Exporting Tables Sean Montague
05:25 MS Access to PostgreSQL William Shatner
05:26 preoblem in jdbc postgresql and tomcat java unix
05:26 sql question Steven Verhoeven
05:26 Exporting Tables Sean Montague
05:26 Re: [GENERAL] MS Access to PostgreSQL Shelby Cain
05:26 Re: [JDBC] [GENERAL] MS Access to PostgreSQL Brian Gunning
05:26 Exporting tables Rerun
05:38 Re: [GENERAL] sql question Vincent Hikida
05:42 Re: [GENERAL] sql question Vincent Hikida
18:50 set-returning function in pg 7.4.6 Raphael Bauduin
18:55 Re: set-returning function in pg 7.4.6 Stephan Szabo
19:07 Re: set-returning function in pg 7.4.6 Michael Fuhr
23:40 Problem: Joining each column of a "one row query" with the result of a "many row query" Christian Hofmann

15 March 2005

15:49 check row before insert SG Edwards
16:39 Re: check row before insert Bruno Wolff III

16 March 2005

00:32 fetching text file from internet Dario Billo
01:36 Next and previous sequence values Christopher Nehren
01:38 Re: fetching text file from internet Bruce Momjian
01:42 Re: fetching text file from internet Michael Fuhr
01:53 plpgsql allowing null fields in insert commands? Celia McInnis
02:01 Re: Next and previous sequence values Michael Fuhr
03:22 Re: fetching text file from internet Schuhmacher, Bret
04:38 Re: Next and previous sequence values Christopher Nehren
06:15 Uploading large files cima
07:06 Re: Uploading large files Michael Fuhr
11:28 Re: Uploading large files Aarni Ruuhimäki
14:18 Re: fetching text file from internet Sean Davis
16:08 Re: plpgsql allowing null fields in insert commands? John DeSoi
17:08 Re: plpgsql allowing null fields in insert commands? Stephan Szabo
20:32 XML and Postgres Greg Lindstrom
22:06 Re: plpgsql allowing null fields in insert commands? Celia McInnis
23:22 Re: plpgsql allowing null fields in insert commands? Stephan Szabo

17 March 2005

04:10 Re: plpgsql allowing null fields in insert commands? Celia McInnis
10:53 Re: XML and Postgres brew@theMode.com
14:52 Re: XML and Postgres Sean Davis
17:46 Re: XML and Postgres Greg Lindstrom
19:03 what is and who owns postgresql type of questions Si Chen
19:15 Re: XML and Postgres brew@theMode.com
20:36 Re: XML and Postgres brew@theMode.com
20:55 Re: what is and who owns postgresql type of questions Tom Lane
21:37 Re: XML and Postgres Sean Davis
23:02 Re: XML and Postgres George Weaver

18 March 2005

02:06 Multidimensional arrays in plpgsql Celia McInnis
02:33 Re: Multidimensional arrays in plpgsql Tom Lane
05:18 Question on simulating Enum Data type Morgan Kita
05:39 Re: Question on simulating Enum Data type Michael Glaesemann
05:58 Re: Question on simulating Enum Data type Tom Lane
06:38 Reference and arrays Cima
09:18 seeking soln.ERROR:;Http status:404 resource not found uday kumar
16:08 Re: Reference and arrays Michael Glaesemann
18:29 Destination table by variable? Erik Dahlstrand
18:39 Re: Destination table by variable? Afton & Ray Still
18:45 Re: [despammed] Destination table by variable? Andreas Kretschmer
18:49 Re: [despammed] Re: Destination table by variable? Andreas Kretschmer
18:54 Re: [despammed] Re: Destination table by variable? Kretschmer Andreas
20:06 Re: [despammed] Re: Destination table by variable? Afton & Ray Still
21:23 Re: Multidimensional arrays in plpgsql Celia McInnis
21:26 Re: Multidimensional arrays in plpgsql Tom Lane
21:33 Array of Objects Cima
22:12 Re: [despammed] Destination table by variable? Erik Dahlstrand
22:32 Re: Multidimensional arrays in plpgsql Celia McInnis
22:35 Re: Array of Objects Tom Lane
22:44 Re: Multidimensional arrays in plpgsql Tom Lane
23:23 Query optimization Ryan Riehle

19 March 2005

00:41 output a single and double quote in a string Keith Worthington
00:57 Re: Query optimization Tom Lane
01:42 Re: Question on simulating Enum Data type Morgan Kita
02:10 Best way to input data Morgan Kita
02:13 Re: output a single and double quote in a string George Weaver
04:30 Re: Best way to input data Sean Davis
05:56 Re: output a single and double quote in a string Michael Fuhr
07:15 Re: output a single and double quote in a string George Weaver
07:38 Re: Question on simulating Enum Data type Tom Lane
10:41 Re: [despammed] Destination table by variable? Andreas Kretschmer
14:35 error when installing postgresql 8.0.1 in Windows XP Akbar
15:50 error http status 404: unable to locate resource uday kumar

20 March 2005

07:17 where's the gap in the sequence ? Zouari Fourat
08:30 Re: where's the gap in the sequence ? Bruno Wolff III
08:57 Re: where's the gap in the sequence ? Michael Fuhr
14:20 Unix installation Freddy Rolland

21 March 2005

06:08 Re: [GENERAL] MS Access to PostgreSQL Edward Macnaghten
06:11 environment variables Walker, Jed S
06:12 Postgre and attachments Chris Winfield-Blum
06:15 Re: [GENERAL] preoblem in jdbc postgresql and tomcat David Gagnon
06:16 Re: [GENERAL] sql question Klint Gore
06:17 Re: [GENERAL] sql question Russell Smith
07:04 Re: environment variables Michael Fuhr
07:09 Re: environment variables Tom Lane
17:20 Re: output a single and double quote in a string Keith Worthington
20:36 timestamp group by bug??? Celia McInnis
20:57 Re: timestamp group by bug??? Tom Lane
23:49 .pgpass file Walker, Jed S

22 March 2005

00:26 Re: .pgpass file Michael Fuhr
00:59 Re: .pgpass file Walker, Jed S
03:31 Re: .pgpass file John DeSoi
04:49 Advice on custom data types Morgan Kita
06:25 Select Interval in plpgsql Derrick Betts
08:52 Re: Select Interval in plpgsql John DeSoi
14:41 Compiling 8.0.1 on Ubuntu AMD_64 Tim Bowden
17:34 String to float conversion raffaele.lazzaro@tiscali.it
17:52 Re: .pgpass file Walker, Jed S
20:32 Re: timestamp group by bug??? Celia McInnis
21:19 Re: Compiling 8.0.1 on Ubuntu AMD_64 Tom Lane
21:48 dump & create with a cron job Jack Miller
21:54 Re: timestamp group by bug??? Tom Lane
22:17 Re: dump & create with a cron job Tom Lane
22:37 Re: dump & create with a cron job Keith Worthington

23 March 2005

06:12 Re: Compiling 8.0.1 on Ubuntu AMD_64 Tim Bowden
08:43 pgsql.so Cima
09:08 Deleting data bases and tables? Cima
09:39 grant problem Rajarshi Mukherjee
09:42 Re: Deleting data bases and tables? Michael Fuhr
09:58 Re: grant problem Michael Fuhr
10:10 pgsql.so Cima
10:43 solution to Delete databases and tables Cima
16:42 Re: pgsql.so Gordon Haverland
16:45 Re: solution to Delete databases and tables Michael Fuhr
21:41 8.0 installs ok, but then... Jon Allen
22:15 Re: 8.0 installs ok, but then... Tom Lane

24 March 2005

00:48 Re: 8.0 installs ok, but then... Jon Allen
01:18 Re: 8.0 installs ok, but then... Tom Lane
09:36 cleanup of template1 Cima
22:42 Strange Problem
22:54 Re: Strange Problem Tom Lane
23:21 install pgaccess under windows xp luckydavid@optusnet.com.au
23:48 Re: install pgaccess under windows xp Afton & Ray Still

25 March 2005

02:30 psql questions Walker, Jed S
03:07 Re: psql questions John DeSoi
09:11 install pgaccess under windows xp luckydavid@optusnet.com.au
09:27 Re: install pgaccess under windows xp luckydavid@optusnet.com.au
09:47 stored procedures? Cima
12:00 Re: stored procedures? Masse Jacques
16:52 Re: stored procedures? John DeSoi
18:23 Re: psql questions Walker, Jed S
20:39 outputting everything from psql to a file Walker, Jed S
22:45 Re: outputting everything from psql to a file Tom Lane
22:51 Re: outputting everything from psql to a file Walker, Jed S

26 March 2005

00:41 tDOM compilation Brian Hennessey
01:04 using ksh for postgres user on linux? Walker, Jed S
16:04 Re: outputting everything from psql to a file John DeSoi
16:50 Re: psql questions John DeSoi

27 March 2005

03:14 initial password Stephen Choularton
19:15 Re: Compiling 8.0.1 on Ubuntu AMD_64 vladimir
19:15 I'd Like To See Permissions Granted Marubayashi, Roy (Mission Systems)
19:15 Time Conversion Ryan Sommers
19:15 Re: [pgsql-advocacy] Function which gives back the nearest neighbours Christopher Kings-Lynne
19:17 Function which gives back the nearest neighbours of a requested value Virgile Beddok
19:18 Re: install pgaccess under windows xp Michelle Konzack
19:18 tDOM compilation Brian Hennessey
19:18 Re: [GENERAL] MS Access to PostgreSQL William Shatner
19:19 Windows 2000 Installation Issue Marc Ayres
19:38 Re: I'd Like To See Permissions Granted Bruno Wolff III
20:06 Re: Time Conversion Tom Lane
20:20 Re: [pgsql-advocacy] Function which gives back the nearest neighbours Bruno Wolff III
20:32 Re: [pgsql-advocacy] Function which gives back the nearest neighbours Tom Lane
23:27 initial password Stephen Choularton

28 March 2005

00:41 using psql Stephen Choularton
06:41 how to connect to posgresql 8 using vb Ramon Orticio
17:39 Re: using psql John DeSoi
19:56 Re: [pgsql-advocacy] Function which gives back the nearest neighbours Bruno Wolff III
21:05 Re: [pgsql-advocacy] Function which gives back the nearest neighbours Bruno Wolff III
21:23 Re: [pgsql-advocacy] Function which gives back the nearest Joe Conway

29 March 2005

02:36 Re: initial password Bruce Momjian
03:31 relation between tables Mauricio Siqueira de Oliveira
04:50 Re: relation between tables Michael Fuhr
06:11 Re: relation between tables Todd Lewis
09:38 Re: Windows 2000 Installation Issue John DeSoi
11:34 cannot makedb Stephen Choularton
11:42 Re: cannot makedb Andrei Reinus
16:42 Re: cannot makedb Van Ingen, Lane
18:56 oracle tools Terry.Arnold@Bull.com
19:34 Re: cannot makedb Tom Lane
20:50 Calling Stored Procedures from PHP Cima
22:41 Re: Calling Stored Procedures from PHP John DeSoi
22:46 Re: [despammed] Calling Stored Procedures from PHP Andreas Kretschmer
22:48 Connecting to database using pg_connect
22:49 Drawing schema Kumar S
23:16 Re: Drawing schema Sean Davis

30 March 2005

05:13 making contact via perl Stephen Choularton
07:16 Re: making contact via perl John DeSoi
09:37 Re: Connecting to database using pg_connect John DeSoi
19:31 Quote Question Greg Lindstrom
20:22 Re: Quote Question John DeSoi
21:14 Re: Quote Question Michael Fuhr
22:07 rpm install issues - RHE3 Chris Jensen
22:30 how to ignore accents? Celia McInnis
22:58 Re: rpm install issues - RHE3 Geoffrey
23:07 Re: rpm install issues - RHE3 Tom Lane

31 March 2005

03:56 Re: how to ignore accents? Ennio-Sr
04:42 Re: how to ignore accents? Michael Fuhr
05:02 Test Noel Faux
07:13 Loss of data and info from system tables!! Noel Faux
07:23 Re: how to ignore accents? Jaime Casanova
07:49 Re: Loss of data and info from system tables!! Michael Fuhr
08:41 Re: Loss of data and info from system tables!! Noel Faux
09:08 Re: Loss of data and info from system tables!! Michael Fuhr
09:09 Re: Loss of data and info from system tables!! Tom Lane
09:52 Re: Loss of data and info from system tables!! Noel Faux
14:41 Re: rpm install issues - RHE3 Devrim GUNDUZ
15:59 Boolean search Kim Kohen
17:40 Re: how to ignore accents? Celia McInnis
20:29 Re: how to ignore accents? Michael Fuhr
20:52 Re: Boolean search Michael Fuhr
21:31 Re: rpm install issues - RHE3 Chris Jensen
22:33 Re: how to ignore accents? Ennio-Sr
23:25 Re: how to ignore accents? Michael Fuhr