Home > mailing lists

Mailing lists [pgsql-novice]

1 August 2003

00:43 Re: [PHP] Accessing Postgres db from apache using PHP Rod Taylor
00:45 Re: [PHP] Accessing Postgres db from apache using PHP Cornelia Boenigk
00:47 Re: [PHP] Accessing Postgres db from apache using PHP Rod Taylor
00:49 Unable to start postmaster David Choo
00:51 function that works only once... Niclas Hedell
00:53 Re: designing tables - sidetrack into arrays Andrew Vit
01:38 Re: Unable to start postmaster Tom Lane
02:10 Re: function that works only once... Stephan Szabo
11:19 which file of the RH9 jdbc provides Java2 functionality? Bob Hartung
12:53 merging 2 dumps Nabil Sayegh
14:59 Re: merging 2 dumps Nabil Sayegh
15:01 Re: merging 2 dumps Tom Lane
15:22 Re: merging 2 dumps Nabil Sayegh
15:51 Re: merging 2 dumps Nabil Sayegh

2 August 2003

02:17 Re: merging 2 dumps Nabil Sayegh
02:27 Re: merging 2 dumps Tom Lane
12:51 Re: pg 7.2.3 -> pg 7.3.3: pg_atoi error Mark Stosberg
16:45 Re: merging 2 dumps Nabil Sayegh

3 August 2003

19:44 Migration from MySQL, some difficulties with DESCRIBE and SHOW Wolfgang Draxinger
20:38 Re: Migration from MySQL, some difficulties with DESCRIBE and SHOW Eric Johnson

4 August 2003

07:24 Re: Migration from MySQL, some difficulties with DESCRIBE and SHOW paul butler
07:49 Re: pg 7.2.3 -> pg 7.3.3: pg_atoi error Marcin Gil
12:55 Delete duplicated rows papapep
13:08 Re: Delete duplicated rows Larry Rosenman
14:03 Re: Delete duplicated rows greg@turnstep.com
16:56 Re: merging 2 dumps / dumping only 1 schema Nabil Sayegh
17:27 Re: Delete duplicated rows papapep
19:42 Re: Migration from MySQL, some difficulties with DESCRIBE Francisco J Reyes

5 August 2003

11:15 Permission error Carmical Casey
11:19 Exponential display of values HK
14:23 Re: Permission error Tom Lane
15:10 pg_dump schema Nabil Sayegh
15:15 Re: pg_dump schema Nabil Sayegh
15:38 Re: pg_dump schema Tom Lane
16:39 Re: Exponential display of values Josh Berkus
16:45 Re: Exponential display of values Joe Conway
23:13 Re: Permission error Carmical Casey

6 August 2003

03:09 FUNCTION REPLACE() "does not exist" ? Tom Müller-Ackermann
03:31 ... Ritesh Bhatnagar
04:02 Re: FUNCTION REPLACE() "does not exist" ? Joe Conway
11:03 Re: Kaarel
13:03 Re: Permission error Carmical Casey
13:50 Re: Nabil Sayegh
15:58 Re: query string returned when no records matched LLOYD,DAN (HP-Boise,ex1)
21:13 does postgres access the raw disk device? Sally Gaddis
21:41 does postgres access the raw disk device? Sally Gaddis
21:50 Re: does postgres access the raw disk device? Tom Lane
23:10 database design Jennifer Vargas

7 August 2003

01:53 Rules and users Cath Lawrence
04:21 database design sources James Buster
04:42 starting Postgres with TCP/IP enabled Sol
04:59 Re: starting Postgres with TCP/IP enabled Jean-Christian Imbeault
05:06 Re: starting Postgres with TCP/IP enabled A.Bhuvaneswaran
05:20 Re: starting Postgres with TCP/IP enabled Sol
05:46 authentication question Cath Lawrence
06:26 Re: [PHP] authentication question Cath Lawrence
08:01 Re: [PHP] authentication question Robby Russell
08:03 Re: [PHP] authentication question Christopher Kings-Lynne
11:28 [NEWBIE] FATAL 1: IDENT authentication failed for user "admin" Alexandre Touret
11:53 Re: [NEWBIE] FATAL 1: IDENT authentication failed for Wim
12:33 Re: [NEWBIE] FATAL 1: IDENT authentication failed for Alexandre Touret
12:37 Re: [NEWBIE] FATAL 1: IDENT authentication failed for Wim
13:41 Re: Rules and users Tom Lane
14:05 Re: [PHP] authentication question Tom Lane
14:12 Creating a table: UNIQUE constraint matching given keys for referenced table "xy" not found Jason Hihn
14:22 Re: Creating a table: UNIQUE constraint matching given keys for referenced table "xy" not found Bruno Wolff III
14:41 Re: Creating a table: UNIQUE constraint matching given keys for referenced table "xy" not found Tom Lane
15:42 Re: Creating a table: UNIQUE constraint matching given keys Jason Hihn
15:46 Re: database design Josh Berkus
16:22 Re: database design Jason Hihn
18:31 Testing gateway Marc G. Fournier
19:12 Performance Bryan Irvine
19:34 Function and Tables Privilege Iande
19:40 Re: Function and Tables Privilege Jason Hihn
20:14 Re: Function and Tables Privilege Stephan Szabo
20:27 Re: Function and Tables Privilege Iande
20:35 Re: Function and Tables Privilege Iande
20:41 Re: Function and Tables Privilege Avi Schwartz
20:49 Re: Function and Tables Privilege Iande
21:01 Re: Performance Josh Berkus

8 August 2003

03:47 Upgrading from 7.1.3 to 7.2.3 Jodie
11:27 COPY and text encodings M. Bastin
11:49 retrieving db info Marcin Gil
11:59 Re: retrieving db info Wim
13:54 Re: Performance János Löbb
14:09 Re: Upgrading from 7.1.3 to 7.2.3 Tom Lane
18:31 Re: COPY and text encodings Bruce Momjian
21:54 Freshly created user cannot connect Thiemo Kellner

9 August 2003

13:10 Upgrade 7.2 to 7.3 James Williams
14:23 Query about Boolean Data Type Richard Hurst
14:29 CURRENT TIME causes server to shutdown connection John T. Yocum
15:23 Re: Query about Boolean Data Type Bruno Wolff III
15:28 Re: CURRENT TIME causes server to shutdown connection Tom Lane
15:33 Re: Query about Boolean Data Type Tom Lane
15:44 Auto_Increment Stephane Pinel
15:50 Re: Upgrade 7.2 to 7.3 Tom Lane
15:51 Re: Query about Boolean Data Type Larry Rosenman
16:12 Re: Upgrade 7.2 to 7.3 Bruno Wolff III
16:21 Re: Auto_Increment Peter Childs
20:33 Re: CURRENT TIME causes server to shutdown connection John T. Yocum
21:13 deletion and many-to-one Jennifer Vargas
22:11 Re: deletion and many-to-one Stephan Szabo
23:01 Re: Auto_Increment Ron Johnson
23:17 Re: CURRENT TIME causes server to shutdown connection Tom Lane

10 August 2003

08:04 Re: Upgrade 7.2 to 7.3 James Williams
13:25 Ordering Error Jason Davis
13:52 Re: Ordering Error Nabil Sayegh
14:46 array_in: Need to specify Dimension problem Jun Queano
15:48 Re: Ordering Error Tom Lane
15:52 Re: array_in: Need to specify Dimension problem Tom Lane
22:14 PostgreSQL to MSDE conversion help JSavage@data-mate.com (Savage)

11 August 2003

06:31 Re: PostgreSQL to MSDE conversion help Kaarel
09:21 getting PostgreSQL version from TCP/IP client M. Bastin
13:04 Re: getting PostgreSQL version from TCP/IP client Steve McAllister
13:25 Re: getting PostgreSQL version from TCP/IP client M. Bastin
14:54 Re: getting PostgreSQL version from TCP/IP client Steve McAllister
15:02 error: table does not exist jun queano
16:27 Re: error: table does not exist Stephan Szabo
16:28 Re: error: table does not exist Bryan Bulten

12 August 2003

17:50 Re: Auto_Increment Jason Hihn
19:21 Maximum Number of Function Arguments Bradley J. Bartram
20:13 Re: Maximum Number of Function Arguments Josh Berkus
20:27 Re: Maximum Number of Function Arguments Bradley J. Bartram
22:44 Am I entering a world of pain... Aled Morris
22:52 Re: Am I entering a world of pain... Stephan Szabo
23:01 Re: Am I entering a world of pain... Tom Lane

13 August 2003

03:04 VI key strokes glenn
09:07 Re: error: table does not exist jun queano
09:46 Re: VI key strokes Rory Campbell-Lange
13:55 pqgetresultset problem P.Harikrishnan
15:14 Re: pqgetresultset problem Stephan Szabo
15:36 How to easily spot Foreign keys Harry Broomhall
15:39 Re: How to easily spot Foreign keys Stephan Szabo
15:50 Re: How to easily spot Foreign keys Harry Broomhall
16:05 Re: How to easily spot Foreign keys Jason Hihn
16:06 Re: How to easily spot Foreign keys Nabil Sayegh
16:11 Re: How to easily spot Foreign keys Nabil Sayegh
16:11 Re: How to easily spot Foreign keys Stephan Szabo
19:23 postgres on AIX Gerard MacNeil
19:25 Searching Tables
19:56 Re: postgres on AIX Tom Lane
20:05 Re: postgres on AIX Randy Neumann
22:04 Re: Searching Tables Ron Johnson
23:01 How can I index a substring attribute? Thiemo Kellner
23:24 Re: How can I index a substring attribute? Stephan Szabo

14 August 2003

00:15 drop/add fk in transaction Nabil Sayegh
00:36 Re: drop/add fk in transaction Stephan Szabo
00:41 Re: drop/add fk in transaction Nabil Sayegh
02:24 Re: drop/add fk in transaction Stephan Szabo
05:13 Large object - what's happening? Cath Lawrence
05:22 Re: How can I index a substring attribute? Thiemo Kellner
06:17 Ho to test Miscellaneous Functions mathan
09:58 Re: pqgetresultset problem P.Harikrishnan
10:27 Re: drop/add fk in transaction Nabil Sayegh
12:08 Re: pqgetresultset problem Stephan Szabo
13:19 User/login questions Jason Hihn
13:39 Fast deletes Jason Hihn
13:51 Re: User/login questions Tom Lane
13:54 Re: Fast deletes Tom Lane
14:17 Re: Fast deletes Nabil Sayegh
15:52 Re: User/login questions Jason Hihn
18:06 Re: User/login questions Tom Lane
23:22 Re: Large object - what's happening? Warwick Hunter
23:41 Qualified Names Girish Bajaj

15 August 2003

01:17 COLLATE Juan Francisco Diaz
01:51 Re: Large object - what's happening? Cath Lawrence
06:01 Re: COLLATE Stephan Szabo
10:40 currval/sequence cristi
13:03 using procedural languages... Aled Morris
13:10 Re: currval/sequence Jason Hihn
14:11 Re: currval/sequence Nabil Sayegh
21:32 Re: using procedural languages... Josh Berkus

16 August 2003

19:32 Compile error in function big_mafa
19:43 Re: Compile error in function big_mafa
19:50 Re: Compile error in function Stephan Szabo
20:08 Re: Compile error in function big_mafa

17 August 2003

20:11 a: queries across databases b: plperl Wayne M. Syvinski
20:52 Re: a: queries across databases b: plperl Nabil Sayegh
22:51 Re: Large object - what's happening? Warwick Hunter

18 August 2003

00:07 Re: a: queries across databases b: plperl Tom Lane
00:29 Re: a: queries across databases b: plperl Wayne M. Syvinski
12:43 Re: a: queries across databases b: plperl Tom Lane
13:17 Re: a: queries across databases b: plperl Jason Hihn
14:38 Re: a: queries across databases b: plperl Tom Lane
15:26 Re: a: queries across databases b: plperl Jason Hihn
16:04 Array Data Type jun queano
16:20 Re: Array Data Type Devrim GUNDUZ
16:25 changing records in inherited tables Adrian Holovaty
16:30 Re: Array Data Type Jason Hihn
17:13 Re: Array Data Type Adam Witney
17:20 Fw: Array Data Type jun queano
17:42 Re: a: queries across databases b: plperl Tom Lane
19:00 Nie ma mnie w biurze Lukasz Feldman
19:07 Re: a: queries across databases b: plperl Wayne M. Syvinski
19:38 Re: Nie ma mnie w biurze Jason Hihn
21:03 Re: Nie ma mnie w biurze Tom Lane
21:26 Ivan Čaplovič je na dovolenke. icaplovic@gamo.sk
22:51 GUI tools for Posgresql and database files Raigo77@solo.delfi.ee (Raigo)
23:03 Re: GUI tools for Posgresql and database files Josh Berkus
23:07 Re: GUI tools for Posgresql and database files Bryan Irvine

19 August 2003

21:48 Installing plpgsql proc language Juan F Diaz

20 August 2003

05:35 Re: Installing plpgsql proc language christoph.dellavalle@goetheanum.ch
12:59 Re: Installing plpgsql proc language Juan F Diaz
16:48 Installing plpgsql language Juan F Diaz
18:25 Re: Installing plpgsql proc language Tom Lane
19:34 Help with pg_restore dan
20:20 Pls help - Limiting query results by percentage of results Brian G. Huber
21:20 Re: Pls help - Limiting query results by percentage of results Josh Berkus
21:29 Re: Starting PostgreSQL 7.3.4 server with Webmin Gaetano Mendola
21:47 Re: Pls help - Limiting query results by percentage of results Tom Lane
22:25 Starting PostgreSQL 7.3.4 server with Webmin Raigo77@solo.delfi.ee (Raigo)
23:27 Re: database design Michael Grant

21 August 2003

05:07 Re: Starting PostgreSQL 7.3.4 server with Webmin Aarni Ruuhimäki
07:20 Re: Starting PostgreSQL 7.3.4 server with Webmin mathan
15:00 one-to-one Michael Grant
17:03 Re: one-to-one Josh Berkus
18:35 Re: one-to-one Adrian Holovaty
18:48 Re: one-to-one Jason Hihn
19:44 Counting table/row access Leslie Valmadre
19:45 Re: one-to-one Josh Berkus
19:56 Re: Counting table/row access Josh Berkus
21:05 Help with plpgsql Juan F Diaz
21:15 Re: Help with plpgsql Josh Berkus
21:18 Re: Help with plpgsql David Olbersen
22:41 logging Nabil Sayegh

22 August 2003

00:58 Re: one-to-one Michael Grant
01:25 Re: Database theory (was Re: one-to-one) Josh Berkus
01:42 Re: one-to-one Josh Berkus
11:32 c-function returns multiple rows Kirill Krasnosselov
13:20 Re: c-function returns multiple rows Stephan Szabo
13:53 Re: c-function returns multiple rows Tom Lane
20:38 Clusters and pgsql Luis Hernán Otegui
23:03 Possible to create table name with a variable? Temp tables? Godshall Michael
23:13 Re: Possible to create table name with a variable? Temp Stephan Szabo

23 August 2003

14:41 Re: Clusters and pgsql Ron Johnson
15:54 Re: Clusters and pgsql Aarni Ruuhimäki
16:53 Re: Clusters and pgsql Stephan Szabo
16:56 dump with nice comments Tomka Gergely
16:58 Re: dump with nice comments Tomka Gergely
21:44 Re: c-function returns multiple rows Joe Conway

24 August 2003

10:13 Porting from MSSQL Server Hans Jorgensen
16:19 Cursors Michael Guerin
16:38 Re: Porting from MSSQL Server Stephan Szabo
16:45 Re: Cursors Stephan Szabo
21:11 Clusters and pgsql Luis Hernán Otegui
21:11 logging Nabil Sayegh

25 August 2003

03:41 Re: Clusters and pgsql dalgoda@ix.netcom.com (Mike Castle)
08:16 interval in days Tomka Gergely
14:46 Re: interval in days Tom Lane
16:08 Number of rows in a table Louise Cofield
16:15 Re: Number of rows in a table Tomka Gergely
16:19 Re: Number of rows in a table Jason Hihn
16:19 Re: Number of rows in a table paul butler
16:21 Unsubscribe Gaitor, Jim
16:24 Re: Number of rows in a table Nabil Sayegh
16:47 Way to tell what SQL is currently running? Patrick Hatcher
16:51 doc on searching, and sorting Luis H.
16:56 unsubscribe WillyLinux -
16:56 Returning SETOF RECORD Juan F Diaz
17:10 Re: doc on searching, and sorting Nabil Sayegh
17:14 Re: Way to tell what SQL is currently running? Tomka Gergely
17:41 Re: Number of rows in a table Ron Johnson
17:44 Re: Way to tell what SQL is currently running? Patrick Hatcher
17:50 Re: Way to tell what SQL is currently running? Stephan Szabo
18:19 Re: Returning SETOF RECORD Stephan Szabo
19:32 doc on searching, and sorting Luis Hernandez
19:33 Re: doc on searching, and sorting Nabil Sayegh
23:24 Re: Way to tell what SQL is currently running? CoL

26 August 2003

05:48 Converting VARCHAR to DECIMAL or NUMERIC Juan Francisco Diaz
05:49 Using RECORD returning functions with JDBC Juan Francisco Diaz
05:57 Re: Number of rows in a table Tom Lane
05:58 INSERT INTO foo (col1,col2,...,coln) not working Juan Francisco Diaz
06:06 Re: INSERT INTO foo (col1,col2,...,coln) not working Stephan Szabo
06:07 Re: Converting VARCHAR to DECIMAL or NUMERIC Stephan Szabo
15:43 How come PGsql function can only handle 3 params? Juan Francisco Diaz
16:57 where to find list of special words Andreas Fromm
18:15 Using PostgreSQL with PHP / Scope an Lifetime of $result Martin Ziebart
18:54 Re: Using PostgreSQL with PHP / Scope an Lifetime of $result Luis H.
19:10 Can the following be done? Juan Francisco Diaz
19:20 Re: Using PostgreSQL with PHP / Scope an Lifetime of $re Eft, Aaron
19:43 Re: Can the following be done? Stephan Szabo
19:47 Re: Using PostgreSQL with PHP / Scope an Lifetime of $result Luis H.
21:12 Database names and pg_dump David Rickard

28 August 2003

02:10 Re: Database names and pg_dump Bruno Wolff III
02:19 Re: Database names and pg_dump Tomka Gergely
02:44 Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts Stuart Woodward
03:06 Simple queries take forever to run Michael Guerin
03:16 Returning SETOF INTEGER mystery... Juan Francisco Diaz
03:19 Re: Database names and pg_dump Ron Johnson
03:21 Re: Database names and pg_dump Tom Lane
03:22 Returning a setof integer Juan Francisco Diaz
03:36 Re: Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts Tom Lane
03:59 Re: Returning SETOF INTEGER mystery... Tom Lane
04:20 using dates in pgsql JohnH
04:23 Re: Database names and pg_dump Bruno LEVEQUE
04:31 Re: using dates in pgsql Tom Lane
09:06 Re: using dates in pgsql Ron Johnson
10:07 From which version was DROP ... CASCADE supported? Stuart Woodward
13:41 Re: using dates in pgsql Tom Lane
14:14 Re: using dates in pgsql Ron Johnson
14:37 Unsubscribe WillyLinux -
21:57 Force Lock Girish Bajaj

29 August 2003

02:09 select items, and max id Luis H.
02:28 Re: Force Lock Bruno Wolff III
02:31 Re: select items, and max id Bruno Wolff III
02:31 How does it work Browne, George (AT-Atlanta)
02:37 Re: How does it work Luis H.
02:39 Boolean variables... Cath Lawrence
02:44 Re: select items, and max id Luis H.
02:51 Re: select items, and max id Bruno Wolff III
02:59 Re: select items, and max id Nabil Sayegh
03:32 Re: Boolean variables... Tom Lane
15:22 "PostgreSQL now has working, tested, scalable replication!" Nabil Sayegh

30 August 2003

00:43 synonym and design tool chakkara rangarajan
00:45 Re: Boolean variables... Herbie McDuck
01:09 Re: Database names and pg_dump Bruce Momjian
01:41 Re: Database names and pg_dump Bruce Momjian
01:54 Re: synonym and design tool Bruno Wolff III
02:49 Re: synonym and design tool Tom Lane
16:46 Re: Boolean variables... Bruce Momjian
21:37 Re: Boolean variables... Tom Lane
23:43 Re: Can Postgresql run in MS Windows Gaetano Mendola

31 August 2003

04:00 inserting records from a file Kelly
04:08 Re: inserting records from a file Joe Conway
18:27 Re: inserting records from a file paul butler
21:08 Can Postgresql run in MS Windows chrizkoh@yahoo.com (Christopher Koh)
22:18 Re: Can Postgresql run in MS Windows Luis H