Home > mailing lists

Mailing lists [pgsql-novice]

1 March 2002

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

2 March 2002

20:13 Select statement question ebp
20:25 ERD or UML tool thiemo
20:39 Re: ERD or UML tool Salvatore Sferrazza
20:53 Re: Select statement question Doug Silver
21:17 Re: select statement... daq
21:24 Re: [SQL] using LIMIT only on primary table daq

3 March 2002

01:26 Duplicates Question ebp
01:38 Re: Duplicates Question Josh Berkus

4 March 2002

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

5 March 2002

01:14 executemany with select Damon Fasching
03:02 Optimizer and Indexes with Joins Hargis
03:46 Re: Optimizer and Indexes with Joins Tom Lane
16:00 Re: Optimizer and Indexes with Joins Frank Bax
19:58 Re: LIKE with no wildcards problem Andrew McMillan

6 March 2002

04:57 Re: index item size 4496 exceeds maximum 2713 Andrew McMillan
07:50 referential integrity for insert Ivan Horvath
08:14 Re: index item size 4496 exceeds maximum 2713 ghaverla@freenet.edmonton.ab.ca
14:36 Re: index item size 4496 exceeds maximum 2713 Tom Lane
14:38 pg equivalent to MS SQL exec command Ugly Hippo
17:02 Re: referential integrity for insert Josh Berkus
18:06 Re: pg equivalent to MS SQL exec command Josh Berkus
18:19 Fun with SQL Josh Berkus

7 March 2002

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

8 March 2002

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

10 March 2002

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

11 March 2002

09:13 Slow performance... wim
10:05 Re: Slow performance... PGMailList
14:50 Re: Slow performance... Josh Berkus
16:00 Re: Slow performance... PG Explorer
23:17 Installing tsearch Jon Hassen
23:48 export everything to text file Jim Lanford
23:53 Re: Installing tsearch Tom Lane

12 March 2002

03:28 Re: export everything to text file Josh Berkus
12:43 Encrypting text in postgresql John Taylor
13:05 Re: Encrypting text in postgresql Einar Karttunen
14:39 Re: Installing tsearch Jon Hassen
17:07 Re: Size of the Postgres DB Josh Berkus
21:40 Re: Installing tsearch Tom Lane
23:03 Re: Size of the Postgres DB Stephan Szabo
23:13 Database is shutting down Anshuman Kanwar

13 March 2002

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

14 March 2002

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

15 March 2002

20:39 7.2 compile problem on HP/UX Richard Ray
21:16 Re: 7.2 compile problem on HP/UX Tom Lane
22:58 Function problem Patrick Hatcher

16 March 2002

00:47 Re: Function problem Patrick Hatcher
00:50 Re: Function problem Josh Berkus
01:20 Re: Function problem Patrick Hatcher
19:10 Re: Function problem Josh Berkus

17 March 2002

12:38 Re: create database, user Thorsten Haude
14:33 Re: create database, user Thorsten Haude
19:44 Re: Database is shutting down Tom Lane
20:40 Re: Excluding null values Josh Berkus

18 March 2002

11:58 Estimating Database Disk Space Richard A Lough
13:43 Re: Estimating Database Disk Space Tom Lane
16:46 Re: Estimating Database Disk Space Richard A Lough
16:53 pg_restore has error message 7 Richard A Lough
17:54 Re: Estimating Database Disk Space Tom Lane

19 March 2002

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

20 March 2002

02:54 Re: Paging & Buffering Josh Berkus
02:57 Re: No postgresql.conf in 7.0.2 Josh Berkus
02:58 Re: Approximate string matching? Josh Berkus
11:27 Question about index extensions. Dmitry Tkach
16:09 installing procedural language Masse Jacques
19:28 Re: Estimating Database Disk Space Richard A Lough
19:43 Re: Estimating Database Disk Space Tom Lane
20:14 perl/DBI transaction rollback of sequences Doug Silver
20:36 Re: [SQL] few admin questions Josh Berkus
20:40 Re: perl/DBI transaction rollback of sequences Chris
20:58 Re: Approximate string matching? Joshua b. Jore
21:08 Re: Approximate string matching? Josh Berkus

21 March 2002

06:47 rules over multiple tables Daniel Grob
09:09 Re: Conditional constraint? Nick Haw
11:48 switching between insert and update Travis Hoyt
14:20 Re: rules over multiple tables Josh Berkus
19:11 What is object-relational? Joshua b. Jore

22 March 2002

02:09 Re: postmaster start options on RedHat 7.1 hodges@xprt.net
07:22 Visio ODBC winnt Linux question Duncan Adams (DNS)
10:37 configuration Al-Haddad, Mohammad J
12:18 Re: rules over multiple tables Daniel Grob
13:38 Re: rules over multiple tables Tom Lane
15:29 Re: What is object-relational? Josh Berkus
17:49 Re: Visio ODBC winnt Linux question John Taylor

23 March 2002

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

24 March 2002

20:52 Re: Reference to Inherited Table Chris

25 March 2002

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

26 March 2002

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

27 March 2002

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

28 March 2002

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

30 March 2002

00:02 CURRENT_USER thiemo
02:14 Re: CURRENT_USER Tom Lane
07:19 Strange insert thiemo
22:57 Upgrading - How? pg sql

31 March 2002

00:47 Backup ljsharpe
01:30 Re: Backup Jason Friedman
06:34 Grant select on view thiemo
13:18 Re: Grant select on view Tom Lane