Home > mailing lists

Mailing lists [pgsql-novice]

1 September 2003

01:36 ORDER BY question Luis H.
05:24 returning Setof Record glenn
05:49 Re: returning Setof Record Avi Schwartz
06:59 Re: ORDER BY question Bruno Wolff III
13:48 Re: ORDER BY question Luis H.
16:12 starting up database server + user postgres Jennifer Liu
17:22 Re: ORDER BY question Williams, Travis L, NEO
19:04 Re: ORDER BY question Bruno Wolff III
19:10 Re: starting up database server + user postgres Bruno Wolff III
19:32 Re: ORDER BY question Luis H.
21:07 Re: starting up database server + user postgres Tom Lane

2 September 2003

03:50 Re: starting up database server + user postgres mathan
04:35 Restoring the database Cody Phanekham
06:29 Re: Restoring the database Tomka Gergely
06:45 SELECT woes Kevin Waterson
07:35 Re: SELECT woes Jeffrey Melloy
08:52 Re: SELECT woes Kevin Waterson
10:16 Re: SELECT woes Rasputin
12:36 Using shared memory with postgresql Mariano M. Gonzalez
14:44 Re: SELECT woes Jeffrey Melloy
15:24 Using COPY Juan Francisco Diaz
15:40 Re: Using COPY Nabil Sayegh
17:03 Re: Using COPY Tom Lane
18:50 Re: Can Postgresql run in MS Windows Al Hulaton

3 September 2003

05:08 setting next value of an established sequence glenn
05:11 Re: setting next value of an established sequence Tom Lane
06:31 Re: Using COPY Tomka Gergely
08:59 Revoke access on pg_user Oliver Fromme
13:52 Re: Revoke access on pg_user Tom Lane
17:18 Configure Errors--Missing Libraries? David Rickard
19:57 Modyifying a column's datatype Louise Cofield
22:01 Lock and read next Girish Bajaj
22:08 Re: Modyifying a column's datatype Ron Johnson
22:58 Re: Modyifying a column's datatype Jeff Eckermann
22:59 Re: Lock and read next Ron Johnson
23:17 Re: Modyifying a column's datatype Stephan Szabo
23:23 Using NOT IN Juan Francisco Diaz

4 September 2003

00:28 Re: Lock and read next Girish Bajaj
02:06 Re: Configure Errors--Missing Libraries? Tom Lane
02:13 Errors on restoring a 7.1.2 dump to 7.3.3 Stuart Woodward
02:54 order by, but eliminating dupes LH
02:55 Editing functions glenn
03:13 Re: order by, but eliminating dupes Bruno Wolff III
03:23 Re: Using NOT IN Tom Lane
03:47 Re: Errors on restoring a 7.1.2 dump to 7.3.3 Tom Lane
05:13 Re: Errors on restoring a 7.1.2 dump to 7.3.3 Stuart Woodward
05:27 Powergres (was Re: Errors on restoring a 7.1.2 dump to 7.3.3) Ron Johnson
06:07 Re: Modyifying a column's datatype Aarni Ruuhimäki
06:13 Re: order by, but eliminating dupes Jeffrey Melloy
06:15 Re: Errors on restoring a 7.1.2 dump to 7.3.3 Jeffrey Melloy
06:57 Re: Powergres (was Re: Errors on restoring a 7.1.2 dump to 7.3.3) Tom Lane
08:54 postfix+pgsql = unexpected EOF Marcin Gil
09:13 Re: Powergres (was Re: Errors on restoring a 7.1.2 dump Ron Johnson
16:13 Postgres dump & restore madness Marcus Andree S. Magalhaes
16:23 Re: Postgres dump & restore madness Nabil Sayegh
16:29 Re: Postgres dump & restore madness Stephan Szabo
18:26 unsubscribe Luis Hernán Otegui
19:55 Re: Number of rows in a table Christopher Browne
19:55 Re: using dates in pgsql Tyler Colbert
19:57 Revoke access on pg_user Oliver Fromme
19:57 Re: ORDER BY question Nabil Sayegh
20:46 Re: Configure Errors--Missing Libraries? David Rickard
21:20 SLOW pG performance Juan Francisco Diaz
22:00 Re: SLOW pG performance Stephan Szabo
22:34 Re: SLOW pG performance Juan Francisco Diaz
22:37 Re: Configure Errors--Missing Libraries? Tom Lane
22:51 Re: SLOW pG performance Stephan Szabo

5 September 2003

12:40 Database Encoding Brad Rhine
13:04 unregister Luis Hernán Otegui
13:51 PostgreSQL setup and help files Shekar
16:10 Re: Database Encoding M. Bastin
16:18 PostgreSQL Server Status M. Bastin
20:16 psql will not run David Rickard
21:40 Re: psql will not run Tom Lane
21:45 Re: psql will not run Oliver Elphick

6 September 2003

07:24 Re: Database Encoding Reshat Sabiq
18:39 Reloading data Damon Courtney
21:35 Re: Reloading data Ron Johnson

7 September 2003

01:06 Re: Reloading data Tom Lane

8 September 2003

06:21 Smitha V. Babu
09:46 How to insert non-english characters to the db? Andreas Fromm
10:17 Re: How to insert non-english characters to the db? M. Bastin
10:44 Re: How to insert non-english characters to the db? Oliver Fromme
13:21 Postgresql does not see its files HEEEELP! Marcin Gil
15:29 Re: Postgresql does not see its files HEEEELP! Tom Lane
15:40 Fw: SQL Error: pqReadData() -- read() failed: errno=0 No error Derrick Betts
15:59 Re: Fw: SQL Error: pqReadData() -- read() failed: errno=0 No error Tom Lane
16:07 Re: Fw: SQL Error: pqReadData() -- read() failed: errno=0 No error Derrick Betts
17:35 Identifying index files David Rickard
17:41 Re: Identifying index files Bruce Momjian
20:29 Modifying pg_shadow? Jason Hihn
20:48 Re: Modifying pg_shadow? Tom Lane
22:38 Re: How to insert non-english characters to the db? Andreas Fromm
22:54 Re: How to insert non-english characters to the db? Tom Lane

9 September 2003

06:01 Re: How to insert non-english characters to the db? Tomka Gergely
08:05 Re: How to insert non-english characters to the db? Andreas Fromm
08:24 Re: How to insert non-english characters to the db? Tomka Gergely
13:18 Re: Modifying pg_shadow? Jason Hihn
13:37 Re: Modifying pg_shadow? Oliver Fromme
13:57 Re: Modifying pg_shadow? Jason Hihn
14:00 Re: Modifying pg_shadow? Bruce Momjian
15:00 Re: How to insert non-english characters to the db? Tom Lane
15:28 Re: Modifying pg_shadow? Tom Lane
15:31 Re: Modifying pg_shadow? Tom Lane
15:56 Re: Modifying pg_shadow? Oliver Fromme
16:10 Re: Modifying pg_shadow? Jason Hihn
16:24 Re: Modifying pg_shadow? Tom Lane
17:04 Concatenating string fields with GROUP BY clause Brian G. Huber
17:08 Re: Modifying pg_shadow? Jason Hihn
17:12 Re: Concatenating string fields with GROUP BY clause Godshall Michael
17:27 Re: Concatenating string fields with GROUP BY clause Jason Hihn
17:32 Re: Concatenating string fields with GROUP BY clause Brian G. Huber
17:52 Re: Concatenating string fields with GROUP BY clause Jeffrey Melloy
18:05 Re: Concatenating string fields with GROUP BY clause Brian G. Huber
19:20 Re: Modifying pg_shadow? Oliver Fromme
19:58 Re: Concatenating string fields with GROUP BY clause Jason Hihn
20:17 Re: Modifying pg_shadow? Jason Hihn
20:30 Most efficient way of selecting by date? Simon Willison
20:48 Re: Modifying pg_shadow? Oliver Fromme
20:55 Re: Most efficient way of selecting by date? Bruno Wolff III
21:08 How to opimize the insertion of data Juan Francisco Diaz

10 September 2003

00:28 Mickey
02:03 psql - interactive chakkara rangarajan
02:05 SQL Error: pqReadData() -- read() failed: errno=0 No error Derrick Betts
02:47 Re: Concatenating string fields with GROUP BY clause Gaetano Mendola
06:03 Re: How to opimize the insertion of data Alberto Caso
07:46 Rép. : How to opimize the insertion of data Erwan DUROSELLE
09:24 Re: R駱. Stuart Woodward
09:30 Re: Aarni Ruuhimäki
10:13 Which files belong to which database? Oliver Fromme
10:21 Re: Oliver Elphick
10:34 Re: Crombleholme, Roy
10:49 Re: Which files belong to which database? Oliver Elphick
12:55 Search for data in a similar field in a related table, too szucs
13:00 Re: Search for data in a similar field in a related table, too Bruno Wolff III
13:03 Lyris and Postgres Mickey
13:13 Re: Lyris and Postgres Jason Hihn
16:09 Re: Which files belong to which database? Stephan Szabo
17:06 phone number list Bryan Irvine
17:14 how many records Bryan Irvine
17:25 Re: phone number list
17:27 Re: phone number list Louise Cofield
17:28 Re: how many records Louise Cofield
17:33 Re: how many records Simon Willison
17:35 Re: phone number list Oliver Elphick
17:36 Re: how many records Oliver Elphick
17:38 Re: RÈp. : How to opimize the insertion of M. Bastin
17:39 Re: how many records M. Bastin
19:16 Re: RÈp. : How to opimize the Juan Francisco Diaz
19:22 Re: phone number list Bryan Irvine
19:46 Re: phone number list Adrian Holovaty
20:21 Re: phone number list Bryan Irvine
20:22 Re: phone number list Bruno Wolff III
20:28 Macro substitution in Postgres Louise Cofield

11 September 2003

01:17 Re: how many records Stuart Woodward
01:44 Re: how many records Bruno Wolff III
02:35 Invalid Blob length Derrick Betts
13:34 Re: Invalid Blob length Jason Hihn
13:50 Re: Most efficient way of selecting by date? Ron Johnson
14:11 Re: phone number list Jeff Eckermann
14:27 Re: Invalid Blob length Godshall Michael

12 September 2003

09:29 Synchronising two (identical) databases Noel
10:06 FAQ: missing answers M. Bastin
10:11 Finding connected users M. Bastin
10:31 Re: FAQ: missing answers Oliver Elphick
12:03 Slow VACUUM Wim
13:00 operation logging Marcin Gil
13:10 Re: operation logging Wim
14:14 Re: Finding connected users Tom Lane
14:21 Re: Slow VACUUM Tom Lane
15:01 Re: operation logging Ron Johnson
15:53 Re: Finding connected users Patrick Hatcher
21:02 Standard in must be a tty White, Benjamin

13 September 2003

03:22 Re: Standard in must be a tty Tom Lane
05:55 Re: Standard in must be a tty A.Bhuvaneswaran
20:12 Postgresql 'backend closed the channelunexpectedly' - how to re-install? Jim Byrne (NTL)
23:22 Re: Postgresql 'backend closed the channelunexpectedly' - how to re-install? Tom Lane

14 September 2003

19:49 User Customization Files Tony Colson
20:08 Re: Concatenating string fields with GROUP BY clause stork@vnet.hu (Vajda Gabor)
20:08 Re: operation logging marcin.gil@mail.vernet.pl
20:13 Re: Search for data in a similar field in a related table, too szucs
20:17 Error: The database does not exist on the server Steve Bond
23:04 Re: Error: The database does not exist on the server Jeffrey Melloy
23:08 Re: Error: The database does not exist on the server Oliver Elphick

15 September 2003

05:05 How to access service using LAN santoso berkah
05:17 Re: How to access service using LAN Tom Lane
05:45 Re: How to access service using LAN Tom Lane
12:51 Re: Error: The database does not exist on the server Steve Bond
12:51 Connection String in ASP.NET application Roslyn Teo
13:06 Re: Error: The database does not exist on the server Wim
14:17 Re: Search for data in a similar field in a related table, too Bruno Wolff III
17:26 Vacuum runs in a loop? Wim
17:31 recursive call to function returning SETOF Max Nachlinger
17:47 Re: Vacuum runs in a loop? Tom Lane
18:22 Re: recursive call to function returning SETOF Stephan Szabo
18:25 Re: Vacuum runs in a loop? Wim
19:59 how to find duplicates key Christian Valverde
20:38 Re: how to find duplicates key Heath Tanner

16 September 2003

03:32 FATAL errors a plenty Mickey
04:11 Re: FATAL errors a plenty Tom Lane
06:40 [novice]unsubscribe shilpi jain
06:48 [novice]unsubscribe Sanjeev Sharma (Kinera)
12:57 (no subject) john tankersley
13:05 Re: operation logging Ron Johnson
15:12 Re: Connection String in ASP.NET application Robert Treat
15:29 Re: FATAL errors a plenty Louise Cofield
15:30 DTS Juan Francisco Diaz
16:18 [ANN] Eduphant M. Bastin
16:34 Re: [ANN] Eduphant Masse Jacques
18:32 Re: [ANN] Eduphant M. Bastin
18:37 Query cancelled errors David Rickard
18:46 Re: Query cancelled errors Tom Lane
19:00 Re: Query cancelled errors David Rickard
19:09 Re: Query cancelled errors Tom Lane
19:16 Re: Search for data in a similar field in a related table, too szucs
19:26 Re: Query cancelled errors Tom Lane
19:28 Re: Query cancelled errors Jason Hihn
19:36 Re: Query cancelled errors Jason Hihn
20:33 Problems starting PostgreSQL on Suse 8.2 James Nichols

17 September 2003

03:09 Synchronising databases replication Noel
13:55 Schemas, and visibility of tables in MS-Query. Harry Broomhall
19:43 Re: Connection String in ASP.NET application wireless200@yahoo.com (wireless)

18 September 2003

05:17 tutorial for win32 programming Smitha V. Babu
08:56 Re: tutorial for win32 programming Harry Broomhall
10:00 Re: tutorial for win32 programming M. Bastin
10:07 Re: tutorial for win32 programming christoph.dellavalle@goetheanum.ch
19:20 More Query Cancelled Matters David Rickard
19:51 Re: More Query Cancelled Matters Tom Lane
23:39 Re: How to set up postgres user santoso berkah

19 September 2003

14:21 Calling a plpgsql function using a trigger in pgadmin III Jonathan Montgomery
23:11 Postgresql startup script on RH9 Balazs Wellisch
23:27 Re: Postgresql startup script on RH9 Oliver Fromme
23:46 Re: Postgresql startup script on RH9 Tom Lane
23:53 Re: Postgresql startup script on RH9 Balazs Wellisch

20 September 2003

00:20 Re: Postgresql startup script on RH9 Rod K
00:20 Re: Postgresql startup script on RH9 Balazs Wellisch
23:15 Re: How to set up postgres user santoso berkah

22 September 2003

00:41 Create tables based on another table Anshuman Kanwar
06:17 Re: Create tables based on another table Oliver Elphick
13:14 Re: DTS Aled Morris
16:38 Replication Bryan Irvine
21:34 Referencing multiple primary keys from a single table. Daniel Staal
22:06 Re: Referencing multiple primary keys from a single table. Stephan Szabo
22:23 Re: Referencing multiple primary keys from a single Daniel Staal
22:27 Re: Referencing multiple primary keys from a single table. Bruno Wolff III

23 September 2003

01:30 Re: Replication Noel
14:07 Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE? Glenn_Wiens@via-christi.org
15:14 Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE? Joe Conway
22:10 Concatenating Juan Francisco Diaz

24 September 2003

00:31 Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE? Bruno LEVEQUE
00:34 Re: Referencing multiple primary keys from a single table. Bruno LEVEQUE
02:04 Re: Concatenating Heath Tanner
12:54 Badly placed ()'s Juan Francisco Diaz
13:55 Forget mi last message Juan Francisco Diaz
16:45 Learning pl/pgsql - good sources? simon@villages.co.uk (simon)

25 September 2003

03:25 Re: Learning pl/pgsql - good sources? Josh Berkus
06:41 transaction log location Marcin Gil
07:32 Re: transaction log location Peter Childs
07:36 Re: transaction log location Marcin Gil
11:20 Re: Learning pl/pgsql - good sources? Kaarel
13:31 Re: transaction log location Tom Lane
15:10 Cache lookup error Juan Francisco Diaz
15:34 Calling a function within a function - plpsql Godshall Michael
15:57 Function return type does not match Juan Francisco Diaz
17:11 Backing Up a Postgres database... Jonathan Telep
17:15 Ranking? Sjors
17:19 Difficult select statement Owen Funkhouser
17:24 Group does not exist. Bob Jarman
17:26 Re: Group does not exist. Bruce Momjian
17:30 Re: Difficult select statement Stephan Szabo
17:41 Re: Backing Up a Postgres database... Bruno Wolff III
17:44 Fw: Difficult select statement Derrick Betts
17:55 Re: Function return type does not match Gaetano Mendola
17:57 Re: Function return type does not match Heath Tanner
19:11 Re: Function return type does not match Juan Francisco Diaz
19:15 Re: Backing Up a Postgres database... Ron Johnson
20:10 Re: Calling a function within a function - plpsql Tom Lane
20:48 Re: Concurrency control
21:27 Re: Ranking? Manfred Koizar
22:29 Re: Function return type does not match Heath Tanner
22:47 Re: Calling a function within a function - plpsql Godshall Michael
22:54 Re: Backing Up a Postgres database... vijay
23:03 Re: Cache lookup error Tom Lane

26 September 2003

01:12 installing 7.3.4 with java sibusiso xolo
05:34 Re: Backing Up a Postgres database... Aarni Ruuhimäki
07:04 Re: installing 7.3.4 with java Geschwinde
19:06 Re: installing 7.3.4 with java sibusiso xolo

27 September 2003

03:24 createuser problem Partha Sur
03:34 Fw: createuser problem (7.3.2) Partha Sur
05:12 Re: createuser problem Stephan Szabo
05:27 Re: createuser problem Oliver Elphick
05:42 Re: createuser problem Tom Lane
19:40 Views and confidentiality Reshat Sabiq
20:25 Re: Views and confidentiality Josh Berkus

28 September 2003

13:18 SQL Syntax problem Doris Bernloehr
16:23 Re: SQL Syntax problem Tom Lane

29 September 2003

11:41 Foreign keys and null Oliver Fromme
12:44 Re: Foreign keys and null Oliver Fromme
14:51 Computed columns and functions? David Benoff
15:47 Re: Foreign keys and null Tom Lane
15:55 Re: Computed columns and functions? Bruno Wolff III
16:37 Some Simple Questions Williams, Quinton L
16:37 Re: Ranking? Sjors
17:05 SQL Syntax problem Doris Bernloehr
17:05 Re: SQL Syntax problem Bruno LEVEQUE
17:14 Re: Some Simple Questions Bruno Wolff III
17:48 Re: Computed columns and functions? Josh Berkus
20:56 Install question Mickey
21:05 Re: Install question Mickey
21:53 Re: Install question Oliver Elphick
22:17 Re: Install question Tom Lane
22:19 Re: Install question Tom Lane