Home > mailing lists

Mailing lists [pgsql-novice]

1 March 2002

01:01 Re: How does one determine which columns are constrained PRIMARY KEY? denis@coralindia.com
05:09 sorting order Bertil Wergelius
05:55 Re: sorting order Oliver Elphick
06:15 timestamp value Ivan Horvath
11:21 Copy Database Structure Christopher A. Goodfellow
11:54 Re: Copy Database Structure Jeff Self
12:31 Re: Copy Database Structure Christopher A. Goodfellow
12:32 Re: timestamp value Josh Berkus
12:40 Re: sorting order Bertil Wergelius
12:51 Re: COPY function and error log Josh Berkus
18:04 select into ...outfile Clinton Adams
18:38 Re: select into ...outfile Oliver Elphick

2 March 2002

17:13 Select statement question ebp
17:25 ERD or UML tool thiemo
17:39 Re: ERD or UML tool Salvatore Sferrazza
17:53 Re: Select statement question Doug Silver
18:17 Re: select statement... daq
18:24 Re: [SQL] using LIMIT only on primary table daq
22:26 Duplicates Question ebp
22:38 Re: Duplicates Question Josh Berkus

4 March 2002

02:49 Re: timestamp value Ivan Horvath
04:02 Re: Duplicates Question denis@coralindia.com
04:02 Re: Select statement question denis@coralindia.com
04:20 Re: timestamp value Oliver Elphick
04:50 Re: timestamp value Ivan Horvath
05:15 Re: timestamp value Oliver Elphick
05:40 Re: timestamp value Ivan Horvath
08:19 PL/pgSQL syntax documentation rob
08:48 Re: PL/pgSQL syntax documentation Oliver Elphick
09:27 Re: PL/pgSQL syntax documentation Oliver Elphick
10:17 querying a table for its primary key Damon Fasching
10:18 LIKE with no wildcards problem John J. Allison
10:29 LIKE with no wildcards problem John J. Allison
10:51 committing a type to never change rob
11:03 Re: ERD or UML tool Masse Jacques
11:55 Re: Unicode and PGAccess Frank Holt
12:39 Re: Unicode and PGAccess Josh Berkus
14:08 Do Stored Procedures exist (Besides FUNCTIONs) Art Nicewick
14:19 Primary Key error ebp
14:19 Primary Key problem ebp
14:49 Migrate an Oracle Table with CLOB datatype olivier de bardonneche
15:00 Re: phppgadmin pgsql@digitalmindgames.com
15:39 Re: Do Stored Procedures exist (Besides FUNCTIONs) Josh Berkus
16:33 Re: Do Stored Procedures exist (Besides FUNCTIONs) Josh Berkus
16:35 Re: Do Stored Procedures exist (Besides FUNCTIONs) Art Nicewick
16:41 Re: Primary Key problem Oliver Elphick
17:41 Re: Do Stored Procedures exist (Besides FUNCTIONs) Joshua b. Jore
19:28 index item size 4496 exceeds maximum 2713 Jon Hassen
19:30 Re: index item size 4496 exceeds maximum 2713 Josh Berkus
19:58 Re: Do Stored Procedures exist (Besides FUNCTIONs) Clinton Adams
22:14 executemany with select Damon Fasching

5 March 2002

00:02 Optimizer and Indexes with Joins Hargis
00:46 Re: Optimizer and Indexes with Joins Tom Lane
13:00 Re: Optimizer and Indexes with Joins Frank Bax
16:58 Re: LIKE with no wildcards problem Andrew McMillan

6 March 2002

01:57 Re: index item size 4496 exceeds maximum 2713 Andrew McMillan
04:50 referential integrity for insert Ivan Horvath
05:14 Re: index item size 4496 exceeds maximum 2713 ghaverla@freenet.edmonton.ab.ca
11:36 Re: index item size 4496 exceeds maximum 2713 Tom Lane
11:38 pg equivalent to MS SQL exec command Ugly Hippo
14:02 Re: referential integrity for insert Josh Berkus
15:06 Re: pg equivalent to MS SQL exec command Josh Berkus
15:19 Fun with SQL Josh Berkus
22:50 Postmaster with -i Faudzy Sulaiman
23:01 Re: Postmaster with -i Chris

7 March 2002

07:54 insert rows into view Ivan Horvath
08:10 Re: insert rows into view daq
08:13 Re: insert rows into view daq
08:35 Duplicates Question. Anthony Estevez
08:36 Formatting Anthony Estevez
09:11 ANSI SQL Somayaji, Rajashekhara
09:44 Re: insert rows into view Ivan Horvath
09:52 Index item size 4496 exceeds maximum 2713 Jon Hassen
10:12 Primary Key error Anthony Estevez
11:28 wierd error Travis Hoyt
11:45 create remote table with sort of index... Al-Haddad, Mohammad J
14:08 Re: wierd error Tom Lane
14:08 Re: wierd error Oliver Elphick
14:42 Re: index item size 4496 exceeds maximum 2713 Jon Hassen
15:05 SQL error 'Unable to identify an operator = for type numeric?' Patrick Hatcher
15:10 starting the postmaster Brian
16:47 Bad Query?? Extremely slow response Patrick Hatcher
17:20 Re: starting the postmaster John Taylor
20:16 Re: starting the postmaster Brian

8 March 2002

02:50 Size of the Postgres DB Yannick ALLUSSE
03:45 Re: starting the postmaster John Taylor
05:18 Good tutorial wanted... wim
06:33 Re: Good tutorial wanted... Masse Jacques
06:36 Re: Bad Query?? Extremely slow response Andrew McMillan
07:25 Grand group rights ? Bo Lorentsen
10:11 Re: SQL error 'Unable to identify an operator = for type Joel Burton
11:27 Re: Size of the Postgres DB Josh Berkus
11:28 Re: Good tutorial wanted... Josh Berkus
12:05 Re: Bad Query?? Extremely slow response Patrick Hatcher
12:19 Conditional constraint? Nick Haw
12:25 FATAL 1: Database template0 not accepting connection? Patrick Hatcher
13:24 Re: Good tutorial wanted... Robert J. Sanford, Jr.
13:38 Re: Conditional constraint? Josh Berkus
14:05 Re: starting the postmaster Brian
14:38 Re: FATAL 1: Database template0 not accepting connection? Joel Burton
14:40 Re: [GENERAL] Conditional constraint? Joel Burton
15:00 Re: FATAL 1: Database template0 not accepting connection? Patrick Hatcher
15:56 Re: Good tutorial wanted... Brett W. McCoy
16:15 Re: Good tutorial wanted... Joel Burton
16:21 Re: Good tutorial wanted... Robert J. Sanford, Jr.

10 March 2002

13:09 create database, user Thorsten Haude
13:58 Re: create database, user Oliver Elphick
14:17 Re: create database, user Josh Berkus
14:53 Re: create database, user Thorsten Haude
14:58 Re: create database, user Josh Berkus

11 March 2002

06:13 Slow performance... wim
07:05 Re: Slow performance... PGMailList
11:50 Re: Slow performance... Josh Berkus
13:00 Re: Slow performance... PG Explorer
20:17 Installing tsearch Jon Hassen
20:48 export everything to text file Jim Lanford
20:53 Re: Installing tsearch Tom Lane

12 March 2002

00:28 Re: export everything to text file Josh Berkus
09:43 Encrypting text in postgresql John Taylor
10:05 Re: Encrypting text in postgresql Einar Karttunen
11:39 Re: Installing tsearch Jon Hassen
14:07 Re: Size of the Postgres DB Josh Berkus
18:40 Re: Installing tsearch Tom Lane
20:03 Re: Size of the Postgres DB Stephan Szabo
20:13 Database is shutting down Anshuman Kanwar
23:16 7.1 -> 7.2 on Debian ghaverla@freenet.edmonton.ab.ca

13 March 2002

04:17 Re: 7.1 -> 7.2 on Debian Oliver Elphick
08:18 Postmaster with -i Faudzy Sulaiman
08:23 Character Arrays, getline, cin.get... Stephane Pinard
08:43 Size of the empty database Yannick ALLUSSE
08:47 PostgreSQL cannot run. Yingrui Chen
09:31 Re: starting the postmaster Brian Scandale
09:51 Re: PostgreSQL cannot run. John Taylor
11:17 Re: Postmaster with -i Henshall, Stuart - WCP
11:19 Re: Postmaster with -i Oliver Elphick
11:37 Re: starting the postmaster John Taylor
12:00 Re: Size of the empty database Henshall, Stuart - WCP
16:00 Re: Slow performance... Hano de la Rouviere
16:32 Sparc/Solaris2.6 Postgresql 7.1.3 Binary? Nicolas Boretos
17:26 Excluding null values Sharon Cowling
20:07 Re: Excluding null values Josh Berkus
20:40 Nested groups thiemo

14 March 2002

10:47 simple previous / next form in PHP Jules Alberts

15 March 2002

17:39 7.2 compile problem on HP/UX Richard Ray
18:16 Re: 7.2 compile problem on HP/UX Tom Lane
19:58 Function problem Patrick Hatcher
21:47 Re: Function problem Patrick Hatcher
21:50 Re: Function problem Josh Berkus
22:20 Re: Function problem Patrick Hatcher

16 March 2002

16:10 Re: Function problem Josh Berkus

17 March 2002

09:38 Re: create database, user Thorsten Haude
11:33 Re: create database, user Thorsten Haude
16:44 Re: Database is shutting down Tom Lane
17:40 Re: Excluding null values Josh Berkus

18 March 2002

08:58 Estimating Database Disk Space Richard A Lough
10:43 Re: Estimating Database Disk Space Tom Lane
13:46 Re: Estimating Database Disk Space Richard A Lough
13:53 pg_restore has error message 7 Richard A Lough
14:54 Re: Estimating Database Disk Space Tom Lane

19 March 2002

00:09 Fwd: Query results Trevor Morrison
00:58 rename a table name Bai Yan
04:42 Triggers in postgres Rob
06:03 Re: rename a table name Henshall, Stuart - WCP
06:13 Re: Triggers in postgres Oliver Elphick
06:27 Re: Triggers in postgres Henshall, Stuart - WCP
12:02 Re: Fwd: Query results Jason Earl
13:08 Re: rename a table name Joel Burton
13:13 Re: Fwd: Query results Joel Burton
13:48 undefined reference to `PgConnection type_info function' Stein Eldar Johnsen
17:36 Data Page Al-Haddad, Mohammad J
17:57 Approximate string matching? Joshua b. Jore
18:15 Re: Data Page Josh Berkus
18:29 No postgresql.conf in 7.0.2 Ludwig Lim
18:33 Difference between Postgres now() and date Doug Silver
23:54 Re: Paging & Buffering Josh Berkus
23:57 Re: No postgresql.conf in 7.0.2 Josh Berkus
23:58 Re: Approximate string matching? Josh Berkus

20 March 2002

08:27 Question about index extensions. Dmitry Tkach
13:09 installing procedural language Masse Jacques
16:28 Re: Estimating Database Disk Space Richard A Lough
16:43 Re: Estimating Database Disk Space Tom Lane
17:14 perl/DBI transaction rollback of sequences Doug Silver
17:36 Re: [SQL] few admin questions Josh Berkus
17:40 Re: perl/DBI transaction rollback of sequences Chris
17:58 Re: Approximate string matching? Joshua b. Jore
18:08 Re: Approximate string matching? Josh Berkus

21 March 2002

03:47 rules over multiple tables Daniel Grob
06:09 Re: Conditional constraint? Nick Haw
08:48 switching between insert and update Travis Hoyt
11:20 Re: rules over multiple tables Josh Berkus
16:11 What is object-relational? Joshua b. Jore
23:09 Re: postmaster start options on RedHat 7.1 hodges@xprt.net

22 March 2002

04:22 Visio ODBC winnt Linux question Duncan Adams (DNS)
07:37 configuration Al-Haddad, Mohammad J
09:18 Re: rules over multiple tables Daniel Grob
10:38 Re: rules over multiple tables Tom Lane
12:29 Re: What is object-relational? Josh Berkus
14:49 Re: Visio ODBC winnt Linux question John Taylor

23 March 2002

07:22 Reference to Inherited Table Thorsten Haude
10:34 Re: Estimating Database Disk Space Richard A Lough
12:09 Re: Estimating Database Disk Space Tom Lane

24 March 2002

17:52 Re: Reference to Inherited Table Chris

25 March 2002

04:18 Can I see a content of function Masakazu Ichimura
04:43 Re: Can I see a content of function Oliver Elphick
10:06 Re: rules over multiple tables Daniel Grob
10:21 Re: rules over multiple tables Henshall, Stuart - WCP
15:10 Searching for all records but integer field is causing problems Brian Johnson
16:37 Re: Searching for all records but integer field is causing Jason Earl
20:16 Return value of function Masakazu Ichimura

26 March 2002

09:20 Retrieving archives Richard Ray
13:14 2 different DB schem in one workstation Al-Haddad, Mohammad J

27 March 2002

06:10 Synchronizing databases Rob
06:38 Re: Visio ODBC winnt Linux question denis@coralindia.com
11:43 Re: Synchronizing databases Josh Berkus
17:41 Export query result to text file? Patrick Hatcher

28 March 2002

00:47 Re: Export query result to text file? denis@coralindia.com

29 March 2002

21:02 CURRENT_USER thiemo
23:14 Re: CURRENT_USER Tom Lane

30 March 2002

04:19 Strange insert thiemo
19:57 Upgrading - How? pg sql
21:47 Backup ljsharpe
22:30 Re: Backup Jason Friedman

31 March 2002

03:34 Grant select on view thiemo
10:18 Re: Grant select on view Tom Lane