Home > mailing lists

Mailing lists [pgsql-novice]

1 February 2006

05:35 Re: How to GRANT SELECT on all tables? Christoph Della Valle
05:41 Re: copy Christoph Della Valle
15:01 How To Return a Row or Result Set Ketema Harris
15:26 How To Return a Row or Result Set Ketema Harris
22:39 Reverting from subtables to no subtables. Gan Uesli Starling
23:38 Re:

2 February 2006

00:13 Re: Swappng Filds
01:06 Re: Reverting from subtables to no subtables. Tom Lane
06:07 Stress Testing Pradeep Parmar
11:40 prob in accessing psql at all Morganne witheredrose
11:43 Re: prob in accessing psql at all Sean Davis
11:45 Re: prob in accessing psql at all Christoph Frick
11:51 Re: prob in accessing psql at all Adam Witney
12:21 prob in accessing psql at all George Tichogiorgos
13:49 Can one turn off constraints/indices temporarily?
13:57 Re: Can one turn off constraints/indices temporarily? Tom Lane
14:19 pg_dump - sort data? Michael Swierczek
17:38 Generalization Hierarchies & Table Inheritance Richard Broersma Jr
17:59 Re: pg_dump - sort data? Darren R
21:45 function privileges Murat Tasan

3 February 2006

03:49 Re: function privileges Michael Fuhr
03:57 Re: function privileges Tom Lane
08:48 schemas in functions Arnaud Lesauvage
09:03 Re: schemas in functions A. Kretschmer
10:58 Create table and update it within one function ? Arnaud Lesauvage
11:04 How do I interpret the data returned from a DeadLock-Exception?(Java) Øyvind Møller Asbjørnsen
11:24 Re: Create table and update it within one function ? A. Kretschmer
13:20 Re: Create table and update it within one function ? Arnaud Lesauvage
14:21 Re: How do I interpret the data returned from a DeadLock-Exception?(Java) Tom Lane
15:27 Re: function privileges Murat Tasan
15:34 Re: function privileges Tom Lane
23:01 maximum for database users? Tjibbe Rijpma

4 February 2006

16:34 createdb: could not connect to database Paul Smith
16:51 Re: createdb: could not connect to database Devrim GUNDUZ
16:56 Re: createdb: could not connect to database Paul Smith
17:38 Re: createdb: could not connect to database Devrim GUNDUZ
17:45 Re: createdb: could not connect to database Andreas Kretschmer
18:35 Re: createdb: could not connect to database Paul Smith
19:51 function return type is a setof some column type Murat Tasan
19:51 Re: put text list into table form Web2cad
19:51 Re: Insert Text Charley Tiggs
19:51 variables outside of functions Ketema J. Harris
19:51 Postgres Installation problem. Dyanesh NagarajaRao
19:51 Dropping sub-tables Gan Uesli Starling
19:51 Re: maximum for database users? Chris Browne
19:51 Backing Up James Dey
19:51 Select date & time Jan Danielsson
20:09 Re: variables outside of functions Andreas Kretschmer
20:13 Re: Select date & time Andreas Kretschmer
20:20 Re: Backing Up Andreas Kretschmer
20:51 Re: put text list into table form Bruno Wolff III
21:03 Re: maximum for database users? Bruno Wolff III
21:20 Re: function return type is a setof some column type Murat Tasan
21:33 Re: function return type is a setof some column type Stephan Szabo
23:12 phpPgAdmin login problem Paul Smith
23:18 Re: phpPgAdmin login problem Devrim GUNDUZ
23:28 Re: phpPgAdmin login problem Paul Smith
23:58 Re: phpPgAdmin login problem Devrim GUNDUZ

5 February 2006

00:08 Re: phpPgAdmin login problem Tom Lane
00:29 Re: phpPgAdmin login problem Paul Smith
00:41 Re: phpPgAdmin login problem Devrim GUNDUZ
01:15 Re: phpPgAdmin login problem Paul Smith

6 February 2006

08:43 Re: Dropping sub-tables Oliver Elphick
16:51 Re: maximum for database users?
19:34 Foreign Keys With Arrays Ketema Harris

7 February 2006

06:58 Re: Foreign Keys With Arrays Andreas Seltenreich
07:09 Re: Foreign Keys With Arrays Andreas Seltenreich
17:03 Please comment on pgsql speed at handling 550,000 records Srinivas Iyyer
17:14 Re: Please comment on pgsql speed at handling 550,000 records Michael Swierczek
17:33 Re: Please comment on pgsql speed at handling 550,000 records Tom Lane
17:33 Re: Please comment on pgsql speed at handling 550,000 records Srinivas Iyyer
17:36 Re: Please comment on pgsql speed at handling 550,000 records Srinivas Iyyer
17:46 Re: Please comment on pgsql speed at handling 550,000 records Tom Lane
18:11 Re: Please comment on pgsql speed at handling 550,000 Sean Davis

8 February 2006

04:33 data corruption how zero bad page blocks etc Noel Faux
18:43 SQL Question Ketema Harris
19:29 How to control memory usage of postgresql André de Camargo Fernandes
19:56 Re: SQL Question Jeffrey Melloy

9 February 2006

16:08 SQL Query gone wrong.. please help Srinivas Iyyer
16:24 Re: SQL Query gone wrong.. please help Murat Tasan
16:37 How to Include Contributed Modules in Automated Install Lane Van Ingen
16:50 Re: SQL Query gone wrong.. please help Srinivas Iyyer
18:00 Re: SQL Query gone wrong.. please help Murat Tasan
19:26 Autovacuum log messages Luiz K. Matsumura

10 February 2006

01:11 Re: SQL Question Ketema Harris
04:49 Re: SQL Question Todd Lewis
12:18 Creating Text Files from Tables Warren Murray
13:17 Re: Creating Text Files from Tables A. Kretschmer
14:07 Re: Creating Text Files from Tables John DeSoi

11 February 2006

05:58 Re: Creating Text Files from Tables Michael Fuhr

12 February 2006

08:09 Return column value from previous and next row in a recordset Matt Arnilo S. Baluyos (Mailing Lists)

13 February 2006

09:53 substring result Luis Silva
11:06 Re: substring result A. Kretschmer
11:55 Reusing columns in SELECT list Andre Majorel
13:29 Re: Reusing columns in SELECT list Tom Lane
14:36 Re: substring result Luis Silva
14:39 Re: substring result Luis Silva

15 February 2006

04:55 one table from the db on a separate drive Pradeep Parmar
05:13 Re: one table from the db on a separate drive A. Kretschmer
05:14 Re: one table from the db on a separate drive Michael Fuhr
05:17 Re: one table from the db on a separate drive Olivier Thauvin
05:38 Re: one table from the db on a separate drive Pradeep Parmar
05:48 Re: one table from the db on a separate drive Olivier Thauvin
06:06 Re: one table from the db on a separate drive Pradeep Parmar
06:29 could not send data to client: Broken pipe Pradeep Parmar
09:23 Re: quering NULL values Luis Silva
11:03 returning Record type problem Luis Silva
11:18 Re: returning Record type problem A. Kretschmer
11:50 Re: returning Record type problem Luis Silva
14:12 Query does not return rows unless a LIMIT statement is used. Richard Kut
14:35 Indexed Views Ketema Harris
14:48 Re: Indexed Views Sean Davis
14:52 Re: Query does not return rows unless a LIMIT statement Sean Davis
14:53 Re: Query does not return rows unless a LIMIT statement is used. Tom Lane
15:11 Re: Query does not return rows unless a LIMIT statement is used. Richard Kut
15:22 Re: Query does not return rows unless a LIMIT statement is used. Tom Lane
15:35 Re: Query does not return rows unless a LIMIT statement is used. Richard Kut
16:01 Re: Query does not return rows unless a LIMIT statement is used. Tom Lane
16:41 A function to count number of terms - something wrong please help Srinivas Iyyer
16:47 Re: A function to count number of terms - something Sean Davis
17:15 Re: A function to count number of terms - something wrong please help Srinivas Iyyer
17:17 Re: Query does not return rows unless a LIMIT statement is used. Richard Kut
21:01 newst packages for ubuntu Nils Zierath

16 February 2006

00:09 performance Tom Allison
12:48 Re: one table from the db on a separate drive Frank Bax
13:50 pgsql-novice-request@postgresql.org Nils Zierath
14:09 Re: pgsql-novice-request@postgresql.org Seneca Cunningham
18:16 Re: pgsql-novice-request@postgresql.org Nils Zierath
18:25 Re: pgsql-novice-request@postgresql.org Seneca Cunningham
18:51 Re: pgsql-novice-request@postgresql.org A. Kretschmer
19:03 Version 8.1 Saloom, Joe \(Space Technology\)
21:43 Queries to Export Warren Murray
21:53 Re: Queries to Export Chandra Sekhar Surapaneni

17 February 2006

00:04 Re: Version 8.1
00:47 Re: Queries to Export Sean Davis
08:45 Index usage btree+gist ? Arnaud Lesauvage
12:26 Re: Version 8.1 John DeSoi
12:50 PostGIS Geometry column in pg8.1.3 Oleg
13:53 Writing Python triggers and the TD dictionary value Curt Schwaderer
13:58 Re: Index usage btree+gist ? Tom Lane
14:06 Re: Index usage btree+gist ? Arnaud Lesauvage
14:21 Re: Index usage btree+gist ? Tom Lane
14:24 Re: Index usage btree+gist ? Arnaud Lesauvage
15:16 reinstallation of Posstgresql 8.0 program Shaler
15:40 Re: Queries to Export
15:59 Re: PostGIS Geometry column in pg8.1.3 Michael Fuhr
16:10 Re: Writing Python triggers and the TD dictionary value Michael Fuhr
18:41 Cloning databases using rsync David Gaudine
19:15 Re: Cloning databases using rsync Tom Lane
20:42 Re: Cloning databases using rsync David Gaudine

18 February 2006

03:13 Can't Find Any Tables with DatabaseMetaData.getTables() ccrupper
03:13 Re: Return column value from previous and next row in a recordset Ken Hagans
03:14 BLOB type storing... once again? GIGI
03:14 Re: [PERFORM] could not send data to client: Broken pipe Richard Huxton
03:14 Ident authentication failed without su to user James A. Bowery
03:14 Query question, subselects and referencing out? Jan Danielsson
03:14 Re: Version 8.1 Christopher Browne
03:14 Index usage btree+gist ? Arnaud Lesauvage
03:14 readline library not found Finger Infratherapie
03:14 php cant see new table!! Sears, Jeremy
03:39 Re: php cant see new table!! Michael Fuhr
10:01 Re: Ident authentication failed without su to user Andreas Seltenreich
10:04 Re: Query question, subselects and referencing out? Andreas Seltenreich
10:05 Re: readline library not found Andreas Seltenreich

20 February 2006

08:42 get the inserted row id Zouari Fourat
08:55 Re: get the inserted row id Michael Glaesemann
09:02 Re: get the inserted row id A. Kretschmer
09:27 Re: [postgis-users] PostGIS Geometry column Oleg
09:31 inserting a value as null Zouari Fourat
09:56 Re: inserting a value as null Oliver Elphick
13:02 Re: Restoring SQL Databse for use in PostgreSQL. Bruno Wolff III
13:14 Function testing if a string is a number ? Arnaud Lesauvage
14:09 Re: Function testing if a string is a number ? Tom Lane
14:14 Re: Function testing if a string is a number ? Arnaud Lesauvage

21 February 2006

08:41 problems to install PostgreSQL Paolo De Simone
11:20 Re: newst packages for ubuntu Devrim GUNDUZ
13:52 Re: problems to install PostgreSQL Seneca Cunningham
14:05 Re: problems to install PostgreSQL Tom Lane
17:41 plpgsql-function with timestamp Christian Stalp
22:05 find a record in range of a number larry postgres
22:34 Re: find a record in range of a number Michael Fuhr

22 February 2006

04:39 table inheritance Shuying Wang
04:57 Re: table inheritance Michael Fuhr
05:20 Re: table inheritance Shuying Wang
13:43 SQL Question Kevin Crenshaw
13:54 drop index Jaromír Kamler
13:56 Re: drop index Charley Tiggs
14:00 Re: drop index Christoph Frick
14:03 Re: SQL Question Sean Davis
14:05 Re: drop index A. Kretschmer
16:09 Re: plpgsql-function with timestamp Andreas Kretschmer
17:22 Re: plpgsql-function with timestamp Christian Stalp
17:32 id from a field Luis Silva
17:43 Re: id from a field A. Kretschmer
17:46 Re: plpgsql-function with timestamp Richard Kut
18:15 Re: plpgsql-function with timestamp Christian Stalp

23 February 2006

08:39 Regarding Postgres access through C Krishnaprasad
08:50 Re: Regarding Postgres access through C A. Kretschmer
08:55 Regarding Postgres access through C Krishnaprasad
09:14 Re: Regarding Postgres access through C A. Kretschmer
09:14 Re: Regarding Postgres access through C Naz Gassiep
15:18 Re: SQL Question Kevin Crenshaw
16:07 Schema Questions
16:11 Re: Schema Questions Sean Davis
17:54 check problem Luis Silva
18:22 Re: reinstallation of Posstgresql 8.0 program
20:45 Re: Schema Questions Guido Barosio
21:45 Re: check problem Michael Fuhr
22:52 Re: check problem Luis Silva
23:42 Re: check problem Bruno Wolff III

24 February 2006

08:32 View running Processes ? Arnaud Lesauvage
08:41 Re: View running Processes ? A. Kretschmer
09:00 Re: View running Processes ? Arnaud Lesauvage
09:05 Re: View running Processes ? A. Kretschmer
09:09 Re: check problem Luis Silva
09:24 Re: View running Processes ? Arnaud Lesauvage
09:37 Re: View running Processes ? A. Kretschmer
13:29 Re: check problem Bruno Wolff III
13:57 Transaction Questions Richard Kut
15:15 Re: Transaction Questions Tom Lane
15:47 Re: Transaction Questions Richard Kut
15:54 Re: Transaction Questions Tom Lane
16:23 Re: Transaction Questions Richard Kut
16:43 Re: Transaction Questions Tom Lane
17:42 Copy data from one table to another Keith Worthington
17:58 Re: Copy data from one table to another Sean Davis
18:20 Re: Copy data from one table to another Guido Barosio
18:47 Re: Transaction Questions Richard Kut
19:08 Re: Transaction Questions Sean Davis
19:14 Re: Transaction Questions Richard Kut
19:24 Re: Transaction Questions Sean Davis
19:38 Re: Transaction Questions Richard Kut

25 February 2006

02:31 Re: Copy data from one table to another Keith Worthington
04:17 Regarding PL/SQL with C Krishnaprasad
06:26 Re: Regarding PL/SQL with C Michael Fuhr
07:27 Regarding PL/SQL with C Krishnaprasad
12:03 UNSUSCRIBE Juan Ravera
14:18 Re: Regarding PL/SQL with C Michael Fuhr
17:26 tsearch2: rebuilding of fulltext index
17:53 Re: tsearch2: rebuilding of fulltext index Michael Fuhr
18:04 Re: tsearch2: rebuilding of fulltext index
19:05 Re: tsearch2: rebuilding of fulltext index Michael Fuhr
19:13 Re: tsearch2: rebuilding of fulltext index

26 February 2006

00:31 exporting to DTD Johnny l
17:26 references versus foreign keys Tom Allison
18:06 Re: references versus foreign keys Tom Lane

27 February 2006

03:48 Re: Regarding PL/SQL with C Krishnaprasad
04:20 Re: Regarding PL/SQL with C Michael Fuhr
07:08 Uppercase initials in Win XP mariateresa.ll@bresciaonline.it
07:14 Re: Uppercase initials in Win XP Michael Glaesemann
13:47 How do you backup functions only? Andrew Walmsley
14:22 How to enable remote anoymous logins? (+ admin books?)
14:34 Re: How to enable remote anoymous logins? (+ admin Sean Davis
14:44 Re: How do you backup functions only? Tom Lane
15:16 Failure Recovery Hal Davison
15:28 Re: Failure Recovery A. Kretschmer
15:32 Re: Failure Recovery Hal Davison
15:39 Re: Uppercase initials in Win XP
16:50 Re: How to enable remote anoymous logins? (+ admin books?) Andrej Ricnik-Bay
16:58 Re: How to enable remote anoymous logins? (+ admin
17:10 Re: How to enable remote anoymous logins? (+ admin Sean Davis
18:05 Re: How to enable remote anoymous logins? (+ admin
18:10 Re: How to enable remote anoymous logins? (+ admin books?)
20:11 unique index Gus List
20:30 Re: unique index Michael Fuhr

28 February 2006

07:40 Generic archive functions. Jesper Krogh
08:55 Finding the right logging level Arnaud Lesauvage
10:34 Re: How to enable remote anoymous logins? (+ admin Sean Davis
17:23 install crdandridge1@comcast.net
17:32 Re: install Sean Davis
17:33 Re: install Lane Van Ingen
18:13 alter table, placing the new column after the id Zouari Fourat
18:18 Re: alter table, placing the new column after the id Sean Davis
18:41 Re: install Tom Lane
21:08 createlang Utility Error Lane Van Ingen
21:35 Re: createlang Utility Error Michael Fuhr