Home > mailing lists

Mailing lists [pgsql-novice]

1 February 2005

00:02 Re: Last ID Problem
01:50 Re: Last ID Problem Mitch Pirtle
02:33 Re: Last ID Problem
03:58 Re: Last ID Problem Mitch Pirtle
04:39 Re: Last ID Problem Michael Fuhr
04:46 Re: Last ID Problem Michael Fuhr
04:54 Re: pgAdminIII and User Grants Mike G.
04:55 Re: Last ID Problem Mitch Pirtle
05:09 Re: pgAdminIII and User Grants Alexander Borkowski
05:56 Function to blame? Michael Guerin
06:35 Arrays of user-defined data types in other user-defined data types James DeMond
07:33 Re: Function to blame? Tom Lane
08:20 Re: Arrays of user-defined data types in other user-defined data types Tom Lane
08:30 Re: Last ID Problem Michael Fuhr
08:56 Re: Last ID Problem Tom Lane
09:50 Re: Last ID Problem Michael Fuhr
10:05 Re: Last ID Problem Tom Lane
16:03 LC_CTYPE question Schuhmacher, Bret
16:36 Re: LC_CTYPE question Schuhmacher, Bret
17:18 Re: function returning a row Kjetil Haaland
19:08 Re: [HACKERS] Last ID Problem Tom Lane

2 February 2005

01:51 Re: [HACKERS] Last ID Problem Tom Lane
12:41 how to know which object depend of it? Akbar
13:02 Accessing insert values in triggers Hasnul Fadhly bin Hasan
16:45 Re: how to know which object depend of it? graeme
17:00 some help William Dominguez
17:58 Re: some help Rodolfo J. Paiz
18:24 Re: some help Mitch Pirtle
18:50 Re: how to know which object depend of it? Tom Lane
20:27 Re: Last ID Problem Bruce Momjian
22:59 Re: How to "COPY schema1.table TO schema2.table" ? Tim Goodaire
23:10 Re: some help Rodolfo J. Paiz
23:22 pgsql and adodb's genID() for unique id sequence...
23:31 Re: pgsql and adodb's genID() for unique id sequence...
23:42 Re: pgsql and adodb's genID() for unique id sequence... Mitch Pirtle

3 February 2005

00:32 Calling psql from a bat file on windows? Oisin Glynn
01:05 Re: grant all the database object automatically Andrew Hammond
04:13 Re: How to "COPY schema1.table TO schema2.table" ? Michael Fuhr
05:02 Re: Calling psql from a bat file on windows? John DeSoi
08:28 Re: some help Rodolfo J. Paiz
08:32 Re: Arrays of user-defined data types in other user-defined James DeMond
08:35 Re: [HACKERS] Last ID Problem Neil Conway
08:36 Re: [HACKERS] Last ID Problem Joshua D. Drake
08:36 DB Error: connect failed Rodolfo J. Paiz
08:37 Re: [HACKERS] Last ID Problem Neil Conway
08:38 Re: [HACKERS] Last ID Problem John Hansen
08:39 Re: [HACKERS] Last ID Problem John Hansen
08:40 Re: [HACKERS] Last ID Problem John Hansen
08:41 Batch Insert tables Jeremiah Knoche
08:42 Vacuum strategy for a frequently rebooted system? Ron Mayer
08:47 Re: [HACKERS] Last ID Problem John Hansen
08:47 Re: [HACKERS] Last ID Problem Alvaro Herrera
09:04 Re: DB Error: connect failed Rodolfo J. Paiz
09:07 Re: Batch Insert tables Michael Glaesemann
09:13 Re: DB Error: connect failed Rodolfo J. Paiz
09:42 Re: DB Error: connect failed Tom Lane
11:02 Re: [PERFORM] Accessing insert values in triggers Michael Fuhr
12:53 Scripting a pg_dumpall/pg_dump backup using bash or perl Gavin Henry
13:12 Re: Scripting a pg_dumpall/pg_dump backup using bash or perl Kretschmer Andreas
17:39 Re: Scripting a pg_dumpall/pg_dump backup using bash or perl Tom Lane
18:28 Can't change LC_CTYPE/locale Schuhmacher, Bret
18:38 Re: DB Error: connect failed [SOLVED] Rodolfo J. Paiz
19:29 Re: Can't change LC_CTYPE/locale Tom Lane
19:45 Re: Can't change LC_CTYPE/locale Schuhmacher, Bret
22:04 Help with subselect (first time) Rodolfo J. Paiz

4 February 2005

00:26 Upgraded to 8.0.1: Initdb troubles Mike
03:32 Storing latitude and longitude Rodolfo J. Paiz
04:17 Temp table exists test?? Michael Guerin
04:25 Re: Calling psql from a bat file on windows? Todd Lewis
04:31 Re: Storing latitude and longitude Michael Fuhr
04:48 Re: Storing latitude and longitude Rodolfo J. Paiz
05:35 how to generate printed output of queries Ramon Orticio
05:36 Re: Temp table exists test?? Michael Fuhr
05:44 Re: Temp table exists test?? Michael Guerin
05:54 Re: how to generate printed output of queries Mike G.
06:19 Re: Temp table exists test?? Tom Lane
06:52 Re: Temp table exists test?? Michael Fuhr
07:12 Re: Temp table exists test?? Michael Guerin
07:16 Re: Temp table exists test?? Michael Guerin
09:36 Installation tool Bruce Rowe
09:37 Need help creating a stored procedure T- Bone
10:02 Re: Installation tool John DeSoi
10:17 Re: Need help creating a stored procedure John DeSoi
15:08 perl script for uniprot SG Edwards
15:30 Re: perl script for uniprot Sean Davis
16:30 Using a preprocessor for constants in SQL Arthur van Dorp
16:38 Information schema question Sean Davis
16:45 Re: Storing latitude and longitude Bruno Wolff III
16:53 Re: Using a preprocessor for constants in SQL Frank Bax
17:06 Re: Using a preprocessor for constants in SQL Arthur van Dorp
17:13 Re: Calling psql from a bat file on windows? Oisin Glynn
17:29 Re: Using a preprocessor for constants in SQL Arthur van Dorp
17:38 Re: [despammed] Re: Using a preprocessor for constants in SQL Andreas Kretschmer
18:35 Re: [despammed] Re: Using a preprocessor for constants in Arthur van Dorp
20:25 Trigger/copy issue Sean Davis
21:27 Re: Trigger/copy issue Tom Lane
22:28 Re: Temp table exists test?? William Yu

5 February 2005

02:48 Re: Help with subselect (first time) Rodolfo J. Paiz
04:44 Re: Help with subselect (first time) Sean Davis
06:41 Re: Help with subselect (first time) Rodolfo J. Paiz
07:02 OLE DB Jorge Pérez
18:46 Re: Help with subselect (first time) Bruno Wolff III
19:12 Converting value to array Sean Davis
19:42 Re: Converting value to array Michael Fuhr
20:10 Re: Converting value to array Tom Lane

7 February 2005

04:31 Re: Function to blame? Michael Guerin
04:38 Re: Function to blame? Tom Lane
08:23 simple query question Akbar
09:42 Re: simple query question Michael Fuhr
14:18 Re: simple query question John K. Herreshoff
14:34 Stuck in "group by" aggregate hell Schuhmacher, Bret
14:58 multiple sampling from tables and saving output David Orme
17:14 Re: Stuck in "group by" aggregate hell Stephan Szabo
17:37 Re: Stuck in "group by" aggregate hell Schuhmacher, Bret
17:57 Percent of update completed Colin McGuigan
18:26 password expiration interval DAVANNE Eric - NTR
18:55 Re: multiple sampling from tables and saving output Tom Lane
19:00 Re: Percent of update completed Tom Lane
19:26 Re: simple query question Michael Fuhr
21:41 Re: Percent of update completed Colin McGuigan

8 February 2005

06:03 "failed to set permission on the installed files" Ramon Orticio
11:11 Autocommit Hasnul Fadhly bin Hasan

9 February 2005

08:50 Text type versus Varchar(n) Kevin Crenshaw
09:09 ECPG: Structure definitions in header files Poul Jensen
09:11 Problem with alias/case in query T. Steneker
09:12 table name as function argument? Les Carter
09:14 psql regular expression matching POSIX John Zwiebel
09:14 Re: psql regular expression matching POSIX John Zwiebel
09:15 Duration betweeen 2 timestamps phil campaigne
09:15 pg_hba.cong edit Luis Cuenca
09:16 Borland C++ Teddy
09:56 Re: table name as function argument? John DeSoi
10:40 Re: Text type versus Varchar(n) Michael Fuhr
12:56 Finding column using SQL query. Rajan Bhide
13:14 Re: Finding column using SQL query.
14:04 Re: Duration betweeen 2 timestamps Schuhmacher, Bret
14:11 Re: Finding column using SQL query. Rajan Bhide
14:34 Re: RE: Finding column using SQL query.
14:43 Re: Finding column using SQL query. Rajan Bhide
14:56 RE: Finding column using SQL query.
15:10 Re: Finding column using SQL query. Rajan Bhide
17:51 Re: Problem with alias/case in query Stephan Szabo
19:11 Re: Finding column using SQL query. Michael Fuhr
19:11 Re: Last ID Problem
19:22 Re: Last ID Problem
19:38 Re: Last ID Problem
19:53 Re: Last ID Problem Michael Fuhr
19:53 Re: Last ID Problem
20:25 Returning a long string (varchar from a function) Oisin Glynn
20:38 Re: Last ID Problem Michael Fuhr
20:52 Re: Returning a long string (varchar from a function) Michael Fuhr
21:10 Re: pg_hba.cong edit Bruce Momjian
21:24 Re: pg_hba.cong edit Devrim GUNDUZ
21:43 Re: Returning a long string (varchar from a function) Oisin Glynn

10 February 2005

08:01 how to know this row has been referenced or not???? Akbar
11:50 Re: how to know this row has been referenced or not???? Michael Fuhr
15:17 Re: function returning a row Kjetil Haaland
21:53 PL/pgSQL: FOT Loops vs Cursors Van Ingen, Lane
22:50 Using PL/pgSQL to Properly Define A Trigger Van Ingen, Lane
23:22 Re: how to know this row has been referenced or not????

11 February 2005

07:32 Converting interval to numeric? Sal Dkj
07:40 Re: PL/pgSQL: FOT Loops vs Cursors Mike G.
07:46 Re: Converting interval to numeric? Bruno Wolff III
10:13 Re: function returning a row Michael Fuhr
11:51 Re: how to know this row has been referenced or not???? Akbar
13:01 Book Peter Mount
13:09 Re: function returning a row Michael Fuhr
15:57 Re: Book John DeSoi
16:21 Re: Book brew@theMode.com
22:08 Re: how to know this row has been referenced or not????

12 February 2005

11:50 plpgsql dim
12:13 Re: plpgsql Tom Lane
13:01 Re: plpgsql dim

14 February 2005

12:08 Re: function returning a row Kjetil Haaland
21:45 Re: Converting interval to numeric? Rodolfo J. Paiz
22:11 Question on PL/Perl Deepblues
22:50 Column default Keith Worthington
23:04 Re: Column default Jeff Eckermann
23:54 Re: Converting interval to numeric? Bruno Wolff III

15 February 2005

01:12 Tomas Eroles i Forner
01:38 unsubscribe Tomas Eroles i Forner
01:55 Re: Column default Keith Worthington
06:39 Re: Question on PL/Perl Mike G.
17:55 Re: Column default Jeff Eckermann
18:14 Revision Control
19:26 JBDC vs ODBC Van Ingen, Lane
20:16 column order
20:23 Re: column order Larry Rosenman

16 February 2005

03:44 Failure to Start Postmaster/postgres Daniel Blavos
05:29 Re: Failure to Start Postmaster/postgres John DeSoi
08:18 Re: Failure to Start Postmaster/postgres Tom Lane
10:07 Re: Revision Control brew@theMode.com
19:47 CASTING in JOIN or WHERE Keith Worthington
21:52 export/import from one schema to another? Les Carter
21:55 Re: Revision Control Kevin Crenshaw
21:57 Re: Converting interval to numeric? Sal Dkj
21:57 Serious connection problem apocalypznow
21:57 Re: find close (duplicate) points + create index Elinor
21:58 Re: Book Hari Bhanujan
23:21 Front End Languages for PostgreSQL Van Ingen, Lane
23:22 Re: find close (duplicate) points + create index Tom Lane

17 February 2005

02:13 Re: Front End Languages for PostgreSQL Dick Davies
02:43 Re: Serious connection problem Afton & Ray Still
03:03 Re: Front End Languages for PostgreSQL Oisin Glynn
06:21 recursive processing Keith Worthington
09:03 Re: recursive processing Doug Gorley
10:04 handling images in postgresql Ramon Orticio
10:22 Re: Front End Languages for PostgreSQL Bo Lorentsen
16:02 Re: handling images in postgresql John DeSoi
16:50 error using COPY command Jesus Lopez
17:19 Re: Front End Languages for PostgreSQL Van Ingen, Lane
17:24 Re: Front End Languages for PostgreSQL Van Ingen, Lane
17:51 Re: Front End Languages for PostgreSQL Bo Lorentsen

19 February 2005

06:28 Expensive where clause Keith Worthington
08:55 Re: Expensive where clause Stephan Szabo
09:41 Re: Expensive where clause Keith Worthington
18:12 Re: Expensive where clause Stephan Szabo

21 February 2005

04:38 Concatenate rows A Gilmore
06:35 Re: Concatenate rows Mike G.
07:25 Re: Concatenate rows Michael Fuhr
17:15 operator class for user defined type Kjetil Haaland
19:30 Re: operator class for user defined type Tom Lane
19:43 Re: operator class for user defined type Larry Rosenman
22:25 Re: Concatenate rows A Gilmore

22 February 2005

12:59 Re: Windows 8.0 Install Failure Michał Maluga
13:47 Query combination query. john-paul delaney
14:17 Re: Query combination query. Sean Davis
15:11 Re: Query combination query. john-paul delaney
15:26 Function with record type as argument Sean Davis
16:39 Perl DBI connection to Postgres SG Edwards
17:13 execute dynamic strings Stefan.Ardeleanu@siveco.ro
17:21 Re: Query combination query. (fwd) john-paul delaney
17:22 Re: Perl DBI connection to Postgres Bruno Wolff III
17:46 Re: Query combination query. (fwd) Bruno Wolff III
17:52 Re: Query combination query. (fwd) john-paul delaney
18:21 Re: Function with record type as argument Tom Lane
18:45 Re: Function with record type as argument Sean Davis
19:03 Re: Function with record type as argument Tom Lane
19:10 Re: Function with record type as argument Sean Davis
19:37 Re: recursive processing Keith Worthington
20:01 Re: recursive processing john-paul delaney
21:22 Question on TRUNCATE privleges Keith Worthington
22:01 Re: Question on TRUNCATE privleges Tom Lane
23:37 Re: [HACKERS] Question on TRUNCATE privleges Robert Treat

23 February 2005

01:00 Re: Perl DBI connection to Postgres brew@theMode.com
01:28 Re: execute dynamic strings brew@theMode.com
09:06 createlang fails David J Kirol
09:06 Re: [ADMIN] PostgreSQL Errors... Iain
09:09 Query optimization Eduardo Vázquez Rodríguez
09:09 Copy can't parse a float? Dan Quaroni
09:11 Bad Boolean external represenation *HELP*! A K
09:12 PostgreSQL Errors... Chari Clark
09:13 Re: Front End Languages for PostgreSQL Christopher Browne
09:14 Support for RETURNING xxx INTO yyy for INSERT and UPDATE? John Napiorkowski
09:18 Help in dynamic execution in plpgsql Stefan.Ardeleanu@siveco.ro
10:14 Re: Bad Boolean external represenation *HELP*! Jason Earl
11:18 Re: Copy can't parse a float? Michael Fuhr
12:00 Re: Support for RETURNING xxx INTO yyy for INSERT and UPDATE? Michael Fuhr
13:04 psql: Unicode escape sequence? john-paul delaney
13:27 Can Clipper connect Postgresql Mester József
16:00 user defined types and strings Kjetil Haaland
17:10 Re: Can Clipper connect Postgresql Frank Bax
20:23 Re: user defined types and strings Michael Fuhr
22:13 Re: user defined types and strings Kjetil Haaland

24 February 2005

00:17 shutdown postmaster question
01:31 Re: Can Clipper connect Postgresql William Yu
01:35 Re: shutdown postmaster question George Weaver
02:43 Re: user defined types and strings Tom Lane
07:54 Re: Question on TRUNCATE privleges Thomas Hallgren
08:56 Transposing a table ravi shankar
15:20 Re: Transposing a table Sean Davis
17:35 Re: Transposing a table Frank Bax
21:27 Re: shutdown postmaster question
21:35 session_user id Keith Worthington
22:44 Re: shutdown postmaster question George Weaver

25 February 2005

01:10 Re: Question on TRUNCATE privleges Bruce Momjian
01:15 Re: Question on TRUNCATE privleges Tom Lane
01:21 Re: Question on TRUNCATE privleges Bruce Momjian
01:31 Re: Question on TRUNCATE privleges Keith Worthington
01:47 Re: Question on TRUNCATE privleges Tom Lane
23:02 Boolean
23:12 Re: Boolean Tom Lane
23:24 pgadmin3 column edit question

26 February 2005

01:16 Re: pgadmin3 column edit question Oisin Glynn
01:23 php/pgsql coding question...
01:26 Re: pgadmin3 column edit question

27 February 2005

03:40 Re: Transposing a table Bruno Wolff III
19:05 PL/Pgsql or PL/Python? Wolfgang Keller

28 February 2005

00:57 Import csv file into multiple tables in Postgres Deepblues
01:57 Warning: pg_exec() query failed: ERROR: Attribute "admin" not found Mark Quinn
06:10 Re: PL/Pgsql or PL/Python? Andrew Hammond
08:00 Re: Import csv file into multiple tables in Postgres Andrew Hammond
16:08 Using upper() / decode() together Ross Gohlke
16:11 Re: pgadmin3 column edit question MaXX
20:23 Re: Using upper() / decode() together Sean Davis
20:40 Re: Import csv file into multiple tables in Postgres Sean Davis