Home > mailing lists

Mailing lists [pgsql-novice]

1 July 2002

16:52 Re: command length? stev knowles

2 July 2002

01:06 Ultradev Sharon Cowling
06:37 modify table S.A.Pamungkas
06:44 Agregation Function Pierre-Yves LANDURE
10:40 Error Trapping -duplicate keys Steven D. Smith
11:00 Re: Error Trapping -duplicate keys Ludwig Lim
13:17 Re: Error Trapping -duplicate keys Tom Lane

3 July 2002

04:39 how to view table foreign keys/triggers? Karin Nila Huegele
05:13 Importing complete txt file with column names robert kraus
08:56 sequences what does ::text mean ? Henk Schets
09:17 Re: sequences what does ::text mean ? Ewald Geschwinde
09:55 Re: sequences what does ::text mean ? Oliver Elphick
09:58 Re: sequences what does ::text mean ? Andrew McMillan
11:28 Re: Importing complete txt file with column names Josh Jore
11:49 Re: sequences what does ::text mean ? Josh Jore
14:23 Re: how to view table foreign keys/triggers? Tom Lane
14:49 Re: sequences what does ::text mean ? Tom Lane
17:01 sequences what does ::text mean ? Henk Schets
17:54 Re: sequences what does ::text mean ? Josh Jore

4 July 2002

11:03 best match question: please help Raouf
12:53 Re: best match question: please help Manfred Koizar
13:54 KEYEXISTS function April L
14:45 Carraige Return issue caroline kenny
16:28 Re: KEYEXISTS function Tom Lane
18:49 user-defined functions/triggers; cannot dump Jason Friedman

5 July 2002

03:18 Re: user-defined functions/triggers; cannot dump Tom Lane
11:46 determining Inheritance among tables Kevin Hyde
11:46 limiting a select Chris Thompson
14:25 Re: determining Inheritance among tables Josh Jore
19:27 Re: determining Inheritance among tables Oliver Elphick
20:44 Re: limiting a select Oliver Elphick

6 July 2002

09:12 Starting with pl/pgsql.. Terry Yapt
10:35 Re: Carraige Return issue Andrew McMillan
11:32 Re: Starting with pl/pgsql.. Josh Jore
12:43 Re: Starting with pl/pgsql.. Terry Yapt
13:51 Re: Starting with pl/pgsql.. Josh Jore
17:01 Importing dbf files to postgresql John Dougherty
19:00 Re: Importing dbf files to postgresql Josh Jore
22:47 last 25 records from a dataset Brian Scandale

7 July 2002

02:05 Re: last 25 records from a dataset Jason Friedman
08:58 how to change rows to columns and vice versa? V R
17:58 Re: how to change rows to columns and vice versa? Terry Yapt
17:58 Re: Starting with pl/pgsql.. Terry Yapt

8 July 2002

04:37 Re: Starting with pl/pgsql.. Josh Jore
08:01 Re: Carraige Return issue caroline kenny
12:20 Re: determining Inheritance among tables Kevin Hyde
12:20 sql help Williams, Tim
19:17 Network Connection Problem Joe Osburn

9 July 2002

06:59 Re: Network Connection Problem Josh Berkus
13:12 Re: Network Connection Problem Tom Lane
14:42 pg_dump, restore and versioning sol
15:36 Re: pg_dump, restore and versioning Tom Lane
16:17 Server side functions Randy Neumann
16:25 Date Duration Numbers John Nix
16:33 Re: Date Duration Numbers Josh Berkus
16:45 Re: Date Duration Numbers Jason Earl
16:56 Re: Date Duration Numbers John Nix
17:02 views and rules Chad Thompson
17:53 oid2name Pam Wampler
21:26 Re: oid2name Tom Lane

10 July 2002

05:13 Re: Importing dbf files to postgresql denis@coralindia.com
05:16 Re: last 25 records from a dataset denis@coralindia.com
11:25 UDF examples. returning rows Vasco Amaral
11:25 Getting result set metadata without executing query? Marc Ramirez
12:46 Re: Getting result set metadata without executing query? Tom Lane
12:55 Re: oid2name Pam Wampler
13:06 Re: Getting result set metadata without executing query? Marc Ramirez
14:04 Translate problems Leandro Fanzone
20:57 web archiving Matt Price
21:21 Re: web archiving Philip Hallstrom

11 July 2002

13:28 Re: Getting result set metadata without executing query? Tom Ansley
13:37 Re: Getting result set metadata without executing query? Tom Lane
15:56 Re: views and rules Masaru Sugawara
16:56 Re: views and rules Chad Thompson
17:51 Re: web archiving Matt Price
17:52 Re: Translate problems Manuel Sugawara
17:57 Re: Translate problems Leandro Fanzone
18:02 Re: Translate problems Manuel Sugawara
18:13 Re: web archiving Ron Johnson
21:33 SET CONSTRAINTS question... Michael Paesold
21:55 update multiple columns Juliet May
22:10 Re: update multiple columns Oliver Kohll
22:12 Re: update multiple columns Juliet May
22:19 Re: update multiple columns Michael Paesold
22:24 Re: update multiple columns Juliet May

12 July 2002

11:11 Newbie Stupid Question Simopoulos
13:03 pg_xlog question Pam Wampler
14:30 Re: pg_xlog question Tom Lane
14:39 Re: Newbie Stupid Question Henshall, Stuart - WCP
15:13 Transactional sql Chad Thompson
15:44 Re: Transactional sql Jason Earl
16:46 Re: Newbie Stupid Question AarniRuuhimäki / Megative Tmi / KYMI.com

13 July 2002

19:53 Question regarding contrib/fulltextindexing Derek Barrett
23:17 Re: Question regarding contrib/fulltextindexing Andrew McMillan

14 July 2002

11:31 Multiple table insert using a CSV list as the data source Norman Khine
15:26 Re: Multiple table insert using a CSV list as the data source Norman Khine
19:34 Re: Multiple table insert using a CSV list as the data Andrew McMillan
20:11 Re: Multiple table insert using a CSV list as the datasource Norman Khine
20:17 Re: Multiple table insert using a CSV list as the datasource Bruno Wolff III
20:21 Re: Multiple table insert using a CSV list as the datasource Chris Palmer
20:29 Re: Multiple table insert using a CSV list as the datasource Bruno Wolff III
20:42 Re: Multiple table insert using a CSV list as the datasource Norman Khine
21:41 Re: Question regarding contrib/fulltextindexing Derek Barrett
22:39 Re: Question regarding contrib/fulltextindexing Andrew McMillan

15 July 2002

02:07 Re: Question regarding contrib/fulltextindexing Derek Barrett
07:15 POSTGRESQL for WINDOWS NT4 Elsa LARREUR
10:57 Re: Newbie Stupid Question AarniRuuhimäki / Megative Tmi / KYMI.com
11:40 CREATE DB --> How create virgin db?? Elsa LARREUR
11:40 How can I tell what port my postgreSQL server is running on? KRB
11:40 removing specific duplicates Al Arduengo
11:40 Multiple table insert using a CSV list as the data source Norman Khine
13:23 Re: removing specific duplicates Josh Jore
15:16 Re: POSTGRESQL for WINDOWS NT4 Josh Berkus
15:21 Re: POSTGRESQL for WINDOWS NT4 Hillensbeck, Preston
16:35 Re: removing specific duplicates Ron Johnson
17:46 Seeding Chad Thompson
17:57 Re: How can I tell what port my postgreSQL server is running on? Hano de la Rouviere

16 July 2002

02:57 Problems linking to libpq Jim Morcombe
15:04 Re: [SQL] Seeding Peter Eisentraut
15:05 Can't link to libpq Jim Morcombe
16:31 Re: Seeding Chad Thompson
17:38 Re: Seeding Ron Johnson
17:45 How do only allow one group access to my database Søren Neigaard
18:38 Re: Seeding Chad Thompson
20:14 Automatic update of table, does not update web site Norman Khine
20:53 Re: Automatic update of table, does not update web site Josh Berkus

17 July 2002

00:06 Re: Problems linking to libpq Andrew McMillan
05:02 Re: Problems linking to libpq Jim Morcombe
06:21 ERA model generator Dusan Juhas
08:15 Re: Problems linking to libpq Rasputin
09:56 Sort with ORDER BY gives wrong results with german Umlaut charact ers Stumbaum, Rainer
10:46 special accents in text columns Henk Schets
10:58 special accents in text columns Henk Schets
14:43 Re: Sort with ORDER BY gives wrong results with german Umlaut charact ers Tom Lane
15:17 Re: Newbie Stupid Question AarniRuuhimäki / Megative Tmi / KYMI.com
15:22 Re: Newbie Stupid Question AarniRuuhimäki / Megative Tmi / KYMI.com
15:48 mirroring databases April L
15:53 Re: mirroring databases D. Duccini
15:59 Help: Dumb newbie locked himself out! Balazs Wellisch
16:24 Re: Help: Dumb newbie locked himself out! Tom Lane
16:36 Re: mirroring databases April L
17:06 Re: Help: Dumb newbie locked himself out! Balazs Wellisch
18:52 Re: Help: Dumb newbie locked himself out! Tom Lane
19:44 How do I only allow one group access to my database Søren Neigaard

18 July 2002

01:34 Re: Problems linking to libpq Jason Davis
01:40 Re: Problems linking to libpq Jim Morcombe
02:43 Re: Problems linking to libpq Jim Morcombe
09:12 UNICODE error AarniRuuhimäki / Megative Tmi / KYMI.com
09:43 Re: Problems linking to libpq Rasputin
11:06 Re: Seeding Peter Eisentraut
11:43 Re: mirroring databases Henshall, Stuart - WCP
15:12 Headcount: Anyone successfully using PHP/Postgres/AOLServer in production? Derek Barrett
15:43 Foreign key error paul butler
16:33 Re: special accents in text columns Josh Berkus
19:03 Re: mirroring databases D. Duccini
20:31 Re: Newbie Stupid Question AarniRuuhimäki / Megative Tmi / KYMI.com
22:10 Re: UNICODE error Josh Berkus

19 July 2002

01:10 Re: mirroring databases Derek Barrett
02:33 Re: mirroring databases April L
03:44 varchar return data split into int4? Patrick Hatcher
06:10 Pb using ?# operator with polygons Pierre-Yves LANDURE
11:20 Connect to PostgreSQL using TCP/IP Stéphane Pinel
11:20 Inquiry data
11:20 problem using ?# operator on polygon Pierre-Yves Landuré
11:38 Re: Connect to PostgreSQL using TCP/IP Derek Barrett
12:13 Re: Connect to PostgreSQL using TCP/IP Ludwig Lim
12:18 Arrays and FFTW Alessandro Baretta
14:26 Adventures in PostgreSQL Josh Berkus
15:20 Re: Arrays and FFTW Josh Berkus
15:25 Re: Inquiry Josh Berkus
15:35 Re: Newbie Stupid Question AarniRuuhimäki / Megative Tmi / KYMI.com
18:03 Jeffrey Trueblood
18:08 Re: Josh Berkus

22 July 2002

08:46 URGENT! pg_dump doesn't work! Wim
10:08 Re: [GENERAL] URGENT! pg_dump doesn't work! Wim
11:35 Re: [GENERAL] URGENT! pg_dump doesn't work! Nigel J. Andrews
13:06 Generating custom statistics rows puzzler...left join on parts of intervals? Ken Corey
14:20 Re: use vi mode in psql Rory Campbell-Lange
15:19 Re: Josh Berkus
15:43 Re: [GENERAL] URGENT! pg_dump doesn't work! Nigel J. Andrews
15:43 Re: Generating custom statistics rows puzzler...left join kenc
19:19 Re: [GENERAL] URGENT! pg_dump doesn't work! Tom Lane
19:40 Memory problems Patrick Hatcher
20:05 Re: Memory problems Andrew McMillan

23 July 2002

02:59 table move across databases Duncan Sargeant
03:30 Re: table move across databases Ron Johnson
07:49 Re: table move across databases Andrew McMillan
11:26 Re: [GENERAL] URGENT! pg_dump doesn't work! Nigel J. Andrews
14:31 Re: [GENERAL] URGENT! pg_dump doesn't work! Tom Lane
18:07 large table and temp space. Molenda, Mark P
18:15 help with failure to connect over a network sibusiso xolo

24 July 2002

11:17 Advantage of using cursors... Wim
13:25 Database Users and Permissions Søren Neigaard
15:04 Migration from MSSQL to PGSQL Jeffrey Trueblood
15:09 Re: Database Users and Permissions Bruno Wolff III
15:57 Re: Migration from MSSQL to PGSQL Ewald Geschwinde
16:06 Re: Migration from MSSQL to PGSQL Josh Berkus
16:28 Security, IP and username restrictions Tuomas Vanhanen
16:28 maximum size of psql query file Jules Alberts
16:28 Problem connecting to Postgresql and creating databases Technosol
16:28 Help with Array? Joe Miller
16:28 Killing postgres processes. Adam Bultman
16:28 Re: Migration from MSSQL to PGSQL Derek Barrett
16:32 Re: Problem connecting to Postgresql and creating databases Derek Barrett
16:34 Re: Security, IP and username restrictions Derek Barrett
16:45 Re: Security, IP and username restrictions Josh Berkus
16:47 Re: maximum size of psql query file Josh Berkus
19:38 Re: Killing postgres processes. Tom Lane
22:37 extract text and store in postgres Jesús López
23:07 Re: extract text and store in postgres Ron Johnson

25 July 2002

02:58 Re: table move across databases Duncan Sargeant
06:30 Trigger question denis@coralindia.com
08:46 Add value in an Array Jerome Chochon
10:29 Re: Trigger question Josh Jore
11:23 Advantage of using cursors... Wim
11:28 extract data and store Jesús López
12:25 Re: Advantage of using cursors... Ludwig Lim
12:45 Compiling a user C function in 7.2.1 John Gunther
12:58 ... J.T. Hartzler
13:58 Re: Salustiano Villanueva
14:16 Re: extract data and store AarniRuuhimäki / Megative Tmi / KYMI.com
14:34 Re: Compiling a user C function in 7.2.1 Tom Lane
14:37 Re: Tom Lane
15:39 Re: extract data and store AarniRuuhimäki / Megative Tmi / KYMI.com
16:00 Re: extract data and store AarniRuuhimäki / Megative Tmi / KYMI.com
16:02 Re: extract data and store Jesús López
16:02 Re: extract data and store Jesús López
16:02 Re: J.T. Hartzler
22:58 howto connect OO to pgsql- with data-insertion access. sibusiso xolo

26 July 2002

11:24 order by int Duncan Adams (DNS)
13:03 initdb initialization problem Daniel L Banta
13:23 Re: order by int Henshall, Stuart - WCP
13:44 Re: order by int Duncan Adams (DNS)

27 July 2002

00:46 Alter column Thiemo Kellner
01:26 some questions Ludwig Lim
10:03 Re: some questions Bruno Wolff III
19:47 functions tom wa

28 July 2002

12:31 Re: Compiling a user C function in 7.2.1 John Gunther
12:38 Re: Compiling a user C function in 7.2.1 John Gunther
16:12 Re: Compiling a user C function in 7.2.1 Tom Lane
18:31 Re: Compiling a user C function in 7.2.1 John Gunther

29 July 2002

06:04 Re: Compiling a user C function in 7.2.1 Tom Lane
11:19 Auto-incrementing field Jim Steil
11:58 Still problems with pg_dump ad \dt... Wim
13:28 Re: Auto-incrementing field Bruno Wolff III
15:15 Altering psqlodbc.h Jillian Carroll
15:55 Re: Auto-incrementing field AarniRuuhimäki / Megative Tmi / KYMI.com

30 July 2002

05:11 Re: Trigger question denis@coralindia.com
05:11 Re: Auto-incrementing field denis@coralindia.com
14:58 Changing Database Name James Kelty
15:05 Re: Changing Database Name Manuel Sugawara
18:35 initdb initialization problem Daniel L Banta
18:35 delete other similar entries with timestamp <= timestamp+15min? knut.suebert@web.de
19:21 Very slow query Chad Thompson
20:02 Re: Very slow query Josh Berkus
20:48 Re: Very slow query Ron Johnson
21:59 Re: Very slow query Josh Berkus

31 July 2002

07:38 Re: delete other similar entries with timestamp <= times Henshall, Stuart - WCP
07:50 Re: Very slow query Henshall, Stuart - WCP
17:26 Re: Very Slow Query Josh Berkus
18:25 Re: Very Slow Query Chad Thompson
20:03 Error Configuring PLPERL on PQSQL Jeffrey Trueblood
23:45 pg_restore not working Patrick Hatcher