Home > mailing lists

Mailing lists [pgsql-novice]

1 February 2003

00:14 Re: where is libpq.so Michiel Lange
02:46 Re: For each record in SELECT Andrew McMillan
04:36 Re: can only connect to localhost is postgresql Bruno Wolff III
09:25 Re: where is libpq.so Andres Ledesma

2 February 2003

02:21 Re: can only connect to localhost is postgresql Reshat Sabiq
03:19 I can't get results inside a C program. Jay G. Scott
03:19 Re: [SQL] For each record in SELECT Andrew J. Kopciuch
03:20 Setting of "D" or "PGDATA" option for data storage location John Tankersley
03:20 serial field starting at specific value Robert Mosher
03:20 Re: Database connection Jill Jensen
03:20 Re: PostgreSQL in Arabic Ruslan N. Balkin
04:13 Re: serial field starting at specific value Tom Lane
19:59 Limiting creation of databases Fabio Angeluci Martins
20:10 Can't connect to postgresql on win32 using Perl Ronald Schmidt
21:51 Re: Can't connect to postgresql on win32 using Perl Reshat Sabiq

3 February 2003

10:59 Creation of VIEWS not working.... Thomas Adam
11:46 Re: Postgresql with OOo Michelle Konzack
11:46 Re: Good books? Michelle Konzack
11:47 Re: Good books? Michelle Konzack
11:49 Re: Creation of VIEWS not working.... paul butler
12:05 Re: Creation of VIEWS not working.... paul butler
12:09 Re: Creation of VIEWS not working.... THANKS :-) Thomas Adam
12:18 Re: Creation of VIEWS not working.... THANKS :-) paul butler
12:25 Re: Can't connect to postgresql on win32 using Perl Ronald Schmidt
13:24 Database access problem : SOS mjoseph@inautix.com
13:50 Re: [ADMIN] Database access problem : SOS Tom Lane
16:31 Re: [BUGS] Problem when adding an existing primary key Josh Berkus
17:14 Re: Can't connect to postgresql on win32 using Perl Andrew McMillan
23:29 Re: Finding Postgres Version???? Jonathon Batson

4 February 2003

00:22 upgrade from 7.0 to 7.2 Nimesh Topiwala
00:36 Re: Finding Postgres Version???? Reshat Sabiq
00:44 object oriented features Antoine
02:32 Re: [ADMIN] Database access problem : SOS mjoseph@inautix.com
02:35 Re: [ADMIN] Database access problem : SOS Tom Lane
03:00 Mac OsX Glenn
05:18 Re: Mac OsX Jeffrey Melloy
05:52 Re: Finding Postgres Version???? Andrew McMillan
08:46 Re: Mac OsX Adam Witney
10:28 Large objects - SOS mjoseph@inautix.com
13:22 Re: upgrade from 7.0 to 7.2 brew@theMode.com
13:36 Re: Can't connect to postgresql on win32 using Perl Ronald Schmidt
14:08 PL/Perl on HPUX Petre Scheie
14:49 Re: Finding Postgres Version???? Steve Crawford
14:50 Cygwin postmaster.pid solution? Jon V
15:09 Re: Cygwin postmaster.pid solution? paul butler
15:11 Re: PL/Perl on HPUX Tom Lane
15:21 Re: Cygwin postmaster.pid solution? Jon V
16:07 Re: Cygwin postmaster.pid solution? paul butler
16:26 Re: Cygwin postmaster.pid solution? Jon V
17:19 Inserting / selecting rows with TIMESTAMP Claire De Longchamp
17:51 Re: PL/Perl on HPUX Petre Scheie
21:09 Re: Inserting / selecting rows with TIMESTAMP Tom Lane
21:25 the lock mechanism Sumaira Ali
21:49 Re: PL/Perl on HPUX Oliver Elphick
21:56 Re: the lock mechanism Oliver Elphick
22:08 Re: PL/Perl on HPUX David Nicely
23:10 proc.h and lock.h Sumaira Ali
23:26 locking granularity Chandralaksana Natalia
23:59 SQL Intersect like problem Dinesh V

5 February 2003

02:03 Re: locking granularity Bruno Wolff III
02:06 Re: SQL Intersect like problem Bruno Wolff III
04:27 Re: proc.h and lock.h Tom Lane
06:42 Need Help have problems Jose Guillermo Guzman
07:17 Re: Need Help have problems Hendrik Coetzee
08:10 Lock timeout detection in postgres 7.3.1 Muhammad Shariq Muzaffar
12:13 Unicode strings and data types Steve_Miller@sil.org
13:48 Postgres performace with large tables. Wim
14:26 Re: SQL Intersect like problem Bruno Wolff III
15:35 Re: PL/Perl on HPUX Petre Scheie
16:27 Re: SQL Intersect like problem Dinesh Visweswaraiah
16:39 Re: Inserting / selecting rows with TIMESTAMP Claire De Longchamp
17:02 How can I speed up with query? Scott Morrison
17:22 Re: How can I speed up with query? Chad Thompson
18:15 Re: PL/Perl on HPUX David Nicely
18:36 how can I tell it's postgresql data? Ricardo Anguiano
18:42 Re: how can I tell it's postgresql data? Mike Grommet
18:55 Re: How can I speed up with query? Greg Sabino Mullane
19:24 Re: Postgres performace with large tables. Andrew McMillan
19:37 keys missing in reference display in DbVisualizer Andreas Plesch
20:04 Re: how can I tell it's postgresql data? Ricardo Anguiano
21:34 how to create or run an sql script on pgsql ? Andres Ledesma
21:44 Re: how to create or run an sql script on pgsql ? simran
21:56 Re: how to create or run an sql script on pgsql ? Andres Ledesma
22:55 Re: How can I speed up with query? Andrew McMillan

6 February 2003

05:22 Re: SQL Intersect like problem Oliver Elphick
05:39 Re: Postgres performace with large tables. Wim
06:11 Re: Postgres performace with large tables. Andrew McMillan
06:48 Re: how can I tell it's postgresql data? Aarni Ruuhimäki
08:55 Re: Postgres performace with large tables. Wim
12:49 Re: how can I tell it's postgresql data? Tom Lane
13:28 Favorite Linux Editor for PostgreSQL Scripts? Steve_Miller@sil.org
13:39 Re: Favorite Linux Editor for PostgreSQL Scripts? Thomas Adam
13:45 Re: SQL Intersect like problem Dinesh Visweswaraiah
14:12 Re: Favorite Linux Editor for PostgreSQL Scripts? Aarni Ruuhimäki
14:20 Re: SQL Intersect like problem Bruno Wolff III
14:24 Re: Favorite Linux Editor for PostgreSQL Scripts?
14:30 Html output Molenda, Mark P
14:39 using copy to insert data. Jennifer Lee
14:55 Re: Favorite Linux Editor for PostgreSQL Scripts?/keyboards Steve_Miller@sil.org
15:05 Re: Favorite Linux Editor for PostgreSQL Scripts? brew@theMode.com
15:05 Re: Favorite Linux Editor for PostgreSQL Scripts? Steve_Miller@sil.org
15:25 Re: Favorite Linux Editor for PostgreSQL Scripts?
15:38 Re: Favorite Linux Editor for PostgreSQL Scripts? Rory Campbell-Lange
15:46 Re: Favorite Linux Editor for PostgreSQL Scripts? Jason Earl
15:47 Re: SQL Intersect like problem Dinesh Visweswaraiah
15:50 Re: using copy to insert data. Chad Thompson
16:13 Re: Html output Andrew McMillan
16:13 Re: using copy to insert data. Andrew McMillan
16:59 Re: Favorite Linux Editor for PostgreSQL Scripts? Steve Crawford
17:03 Re: [GENERAL] Creation of VIEWS not working.... Simon Mitchell
17:03 Re: [GENERAL] Large objects - SOS Nigel J. Andrews
17:03 Scott Morrison
17:03 Re: Favorite Linux Editor for PostgreSQL Scripts? Chris Thompson
17:03 Re: Html output Antti Haapala
17:03 Re: Html output Antti Haapala
17:03 Re: using copy to insert data. Antti Haapala
17:03 postgresql-contrib and perl Rickard Persson
17:03 keys missing in reference display in DbVisualizer Andreas Plesch
17:03 Database access problem : SOS mjoseph@inautix.com
18:03 Re: Doug Silver
18:44 Re: Tom Lane
20:38 Re: Scott Morrison
22:49 Re: Favorite Linux Editor for PostgreSQL Scripts? simran

7 February 2003

06:02 "function has no parameter $1" - help. Michael Weaver
13:53 Re: greg@turnstep.com
16:53 Inaccurate results Chad Thompson
17:14 Re: Chad Thompson
17:21 Re: Inaccurate results greg@turnstep.com

8 February 2003

06:35 Re: Andrew McMillan
08:20 lock timeout in pgsql 7.3.1 Muhammad Shariq Muzaffar

10 February 2003

07:32 Transaction automatically rollback but why? Muhammad Shariq Muzaffar
17:10 Re: greg@turnstep.com
17:28 Re: Andrew McMillan
17:49 Re: greg@turnstep.com
20:50 Re: Scott Morrison
22:09 Characters To be Escaped in Perl Robert Mosher
22:41 Re: Tom Lane

11 February 2003

00:54 Re: Characters To be Escaped in Perl greg@turnstep.com
07:42 problem with pl/pgsql function unknown parameters Jules Alberts
15:50 Re: greg@turnstep.com
18:49 Problems installing CygIPC for PostgreSQL Steve_Miller@sil.org
18:59 Re: Problems installing CygIPC for PostgreSQL Ewald Geschwinde
19:00 Re: Problems installing CygIPC for PostgreSQL Steve_Miller@sil.org
20:47 view users Joel Lopez

12 February 2003

02:39 locale error César Eduardo Schneider
05:51 Re: locale error Tom Lane
08:53 How can i combine two columns Ville Jungman
09:39 Re: How can i combine two columns Peter Childs
10:28 Re: problem with pl/pgsql function unknown parameters Jules Alberts
10:38 Re: locale error César Eduardo Schneider
12:19 Re: view users Scott Morrison
13:30 Re: problem with pl/pgsql function unknown parameters Dmitry Tkach
16:09 psql: FATAL 1: IDENT authentication failed for user "phpuser" Joel Lopez
16:24 Re: psql: FATAL 1: IDENT authentication failed for user "phpuser" Joel Lopez
18:14 how to instal libpgtcl ang pgaccess Tcl stuff Peter Hunčár
18:14 view users Joel Lopez
21:08 session level locks Sumaira Ali

13 February 2003

08:10 Re: psql: FATAL 1: IDENT authentication failed for user Andrew McMillan
09:28 Re: view users Oliver Elphick
10:20 Backup method and vacuumdb guillermo schulman
10:28 Cygwin and C triggers Alan Clucas
11:59 accessing primary key slower than accessing non primary key??? HK
13:45 Re: accessing primary key slower than accessing non primary key??? Tom Lane
16:19 Using unixODBC/psqlODBC -- Guidelines/Tips/Manaul? Renê Salomão
23:04 Executing SQL commands in script files Susan Hoddinott
23:36 Returning result sets. Michael Weaver
23:49 Re: Executing SQL commands in script files Andres Ledesma
23:53 Re: Executing SQL commands in script files simran

14 February 2003

01:54 Re: Executing SQL commands in script files Josh Berkus
01:54 Passing arrays Michael Weaver
02:16 Re: [SQL] Passing arrays Josh Berkus
05:54 Re: [SQL] Passing arrays Michael Weaver
07:10 Re: Cygwin and C triggers Alan Clucas
07:12 change year in timestamp list DB
07:41 Re: Executing SQL commands in script files ...sorry ..mail was emty.. Andres Ledesma
07:46 Re: Generating the db script file .... Andres Ledesma
12:10 Displaying from a script guillermo schulman
14:21 Re: change year in timestamp greg@turnstep.com
15:28 Re: [SQL] Passing arrays Joe Conway
15:36 Re: [SQL] Returning result sets. Joe Conway
15:36 Re: [SQL] Passing arrays Achilleus Mantzios
15:36 Re: [SQL] Passing arrays Stephan Szabo
15:37 Re: change year in timestamp brew@theMode.com
15:43 Re: Executing SQL commands in script files Josh Berkus
15:51 Re: Generating the db script file .... brew@theMode.com
17:30 Accessing PostgreSQL from a remote host ? Stéphane Pinel
18:38 Re: Accessing PostgreSQL from a remote host ? Josh Berkus
19:39 Importing Postgres 7.1.1 DBs into Postgres 7.3.2 Adam Bultman
19:48 Re: Accessing PostgreSQL from a remote host ? Stéphane Pinel
21:52 Re: Accessing PostgreSQL from a remote host ? Josh Berkus
22:06 Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2 Tom Lane

15 February 2003

18:35 Libpq error: Undefined symbols ? Stéphane Pinel
19:02 Re: [INTERFACES] Libpq error: Undefined symbols ? Tom Lane

16 February 2003

15:23 question on 'create domain' Denis Grannell
15:42 Re: question on 'create domain' Bruno Wolff III
17:02 libpq: illegal reference to symbol: _BIO_free Stéphane Pinel
17:39 Re: libpq: illegal reference to symbol: _BIO_free Stéphane Pinel
18:06 Re: question on 'create domain' Denis Grannell

17 February 2003

04:04 Select-into, count error (stored function). Michael Weaver
04:21 Re: Select-into, count error (stored function). Tom Lane
06:08 How to copy database Sudheesh Krishnankutty
06:25 Re: How to copy database Aarni Ruuhimäki
12:37 Re: How to copy database David C.Oshel
12:46 MySQL comparable syntax for PostgreSQL Ben Clewett
14:04 Change the current database programatically guillermo schulman
14:35 How to remove old pg RPMs? Patrick Hatcher
14:50 Re: How to remove old pg RPMs? Josh Trutwin
15:35 Re: MySQL comparable syntax for PostgreSQL Bruno Wolff III
16:13 Dynamic IP - pg_hba Dirk Hamstra
17:37 Re: How to remove old pg RPMs? Patrick Hatcher
18:19 Re: MySQL comparable syntax for PostgreSQL Andrew McMillan
18:44 Re: MySQL comparable syntax for PostgreSQL Bruno Wolff III
19:05 Re: MySQL comparable syntax for PostgreSQL douggorley@shaw.ca
19:06 meaningful trigger descriptions Jason S. Friedman
20:15 Re Dynamic IP - pg_hba Dirk Hamstra
21:10 Multiple Return Values? Steve_Miller@sil.org
22:01 Re: Multiple Return Values? Josh Berkus
22:07 Re: Re Dynamic IP - pg_hba Josh Berkus

18 February 2003

01:11 Re: MySQL comparable syntax for PostgreSQL Bruno Wolff III
02:03 Problem regarding starting PostgreSQL 7.3.1 on Windows 2000 Professional Dhaval Patel
11:17 Granting permission for users to create users... Ben Clewett
12:04 Re: Granting permission for users to create users... Bruno Wolff III
13:12 Re: Change the current database programatically greg@turnstep.com
13:55 Re: Multiple Return Values? Steve_Miller@sil.org
15:35 postgres back up full And incremental Luis BsAsSoft
15:35 Accessing PostgreSQL from a remote host Stéphane Pinel
15:35 Dynamic IP - pg_hba Dirk Hamstra
15:35 Ordering rows in a table David Härdeman
15:35 question on "create domain" Denis Grannell
15:35 base36 sequence ninja
19:14 null value in date field Jeff Deroshia
19:14 Re: Accessing PostgreSQL from a remote host Andrew McMillan
19:26 Re: Ordering rows in a table Andrew McMillan
22:25 Re: null value in date field Josh Berkus

19 February 2003

05:24 Re: base36 sequence Tom Lane
11:31 getting integer info. Mark Molenda
11:52 Re: getting integer info. Jeff Deroshia
16:07 Foriegn key to Union query or two tables Phillip J. Allen
16:31 Re: Foriegn key to Union query or two tables Bruno Wolff III
18:25 Re: null value in date field Keith Keller
18:25 Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2 Adam Bultman
18:25 null value in date field Jeff Deroshia
19:03 Re: null value in date field Jeff Deroshia
19:22 Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2 Tom Lane
21:05 User Problem In PostgreSQL On Mac OS X Robert Prather

20 February 2003

15:49 dynamic queiries Correia, Carla

21 February 2003

02:43 problem returning setof records glenn
02:49 help with select * from functionname() ? glenn
03:26 Re: help with select * from functionname() ? Tom Lane
04:17 \pset pager cristi
05:41 Re: \pset pager Andrew McMillan
17:50 PostgreSQL for Windows Hadjar Dalila
18:24 help with select * from functionname() ? glenn
21:23 foreing key .. reference.. Andres Ledesma

22 February 2003

07:24 Re: foreing key .. reference.. Andrew McMillan
08:56 Re: foreing key .. reference..thanks a lot ... Andres Ledesma

23 February 2003

11:49 User Problem In PostgreSQL on Mac OS X Robert Prather
18:40 Re: User Problem In PostgreSQL on Mac OS X brew@theMode.com
18:54 Re: User Problem In PostgreSQL on Mac OS X David C.Oshel
23:23 Re: User Problem In PostgreSQL on Mac OS X Robert Prather

24 February 2003

00:13 Why would this crash my server glenn
00:46 Substring & escape Character Michael Weaver
00:48 Re: Why would this crash my server Tom Lane
01:09 Re: Substring & escape Character Tom Lane
01:17 Re: Why would this crash my server glenn
01:23 Re: Why would this crash my server Tom Lane
07:48 GPL Licence Ben Clewett
08:41 Re: GPL Licence Ben Clewett
08:42 Re: GPL Licence Andrew McMillan
08:48 Re: Substring & escape Character Michael Weaver
08:57 Wrapping text Wim
12:40 Re: User Problem In PostgreSQL on Mac OS X David C.Oshel
16:49 Re: Wrapping text Josh Berkus
16:58 pq_flush: send() failed: Broken pipe Chad Thompson
17:25 Re: pq_flush: send() failed: Broken pipe Josh Berkus
18:10 Re: pq_flush: send() failed: Broken pipe Chad Thompson
23:57 Re: User Problem In PostgreSQL on Mac OS X Robert Prather

25 February 2003

08:32 creating a createuserfunction. Michael Weaver
15:38 Re: User Problem In PostgreSQL on Mac OS X Adam Witney
16:57 Re: pq_flush: send() failed: Broken pipe Chad Thompson

27 February 2003

01:17 Postgres and recursion glenn
04:46 Re: Postgres and recursion Tom Lane
10:41 adding data to tables with sequences Jennifer Lee
12:29 Function Comit Aspire Something
13:13 Re: adding data to tables with sequences Tom Lane
14:08 initdb hangs even though ipc-daemon is running? Tom Gilbert
14:28 initdb hangs even though ipc-daemon is running? Tom Gilbert
15:26 Re: initdb hangs even though ipc-daemon is running? Aspire Something
15:44 Re: Function Comit Josh Berkus
16:38 initdb "file not found" Warren Massengill
16:44 Re: Function Comit Aspire Something
17:27 Re: initdb "file not found" Bill Colls
18:48 usage on blobs Antoine
19:47 Re: usage on blobs Aspire Something
20:05 Re: usage on blobs Aarni Ruuhimäki
20:12 Re: Function Comit Josh Berkus
22:56 Re: Function Comit Tom Lane
23:01 Re: initdb "file not found" Warren Massengill

28 February 2003

17:34 something's screwy with this list Joel Rodrigues