Home > mailing lists

Mailing lists [pgsql-novice]

1 January 2006

14:01 backup by schema Frank Bax
14:12 Re: backup by schema A. Kretschmer
21:17 array size problem Luis Silva
23:56 Re: array size problem John DeSoi

2 January 2006

08:07 Sequential Scans On Complex Query With UNION - see why this fails Steve Tucknott
08:36 can't log on to phppgadmin First Last
13:49 Re: backup by schema Frank Bax
14:19 function problem Luis Silva
14:23 Re: function problem Luis Silva

3 January 2006

01:46 dropping an unused sequence?
02:00 Re: dropping an unused sequence? Tom Lane
02:14 Re: dropping an unused sequence?
13:46 Replacing Tables Greg Lindstrom
14:14 Re: Replacing Tables Sean Davis
16:33 Re: dropping an unused sequence? Jaime Casanova
19:01 which database to login to to create global users? pres
19:10 Re: which database to login to to create global users? Jaime Casanova
19:14 Re: which database to login to to create global users? pres
19:57 Re: which database to login to to create global users? Tom Lane
20:06 Re: which database to login to to create global users? pres
20:14 Re: which database to login to to create global users? pres

4 January 2006

11:59 Best way to manage users Kevin Crenshaw
12:08 Re: Best way to manage users Daniel Staal
12:19 Re: Best way to manage users Sean Davis
13:51 Re: Best way to manage users Kevin Crenshaw
13:59 Re: Best way to manage users Sean Davis
14:27 Re: Best way to manage users brew@theMode.com
16:20 Re: Best way to manage users Kevin Crenshaw
16:37 Re: Best way to manage users Sean Davis
16:43 Re: Best way to manage users Roland Giesler
16:50 Re: Best way to manage users Adam Witney
17:56 Re: Best way to manage users Kevin Crenshaw
18:02 Re: Best way to manage users Sean Davis
18:05 Re: Best way to manage users
18:26 Re: Best way to manage users Kevin Crenshaw
18:40 Re: Best way to manage users Kevin Crenshaw
18:53 Re: Best way to manage users Sean Davis
21:14 Re: Best way to manage users Frank Bax
21:27 Re: Best way to manage users Sean Davis
21:29 Problem UPDATE Statement
21:32 Re: Best way to manage users
21:35 Re: Problem UPDATE Statement Tom Lane
21:57 GRANT access rights on rows Jaromír Kamler
21:58 foreign key's in system tables Tjibbe Rijpma
22:15 Re: GRANT access rights on rows Sean Davis
22:23 Re: Problem UPDATE Statement
23:32 Re: foreign key's in system tables Michael Fuhr
23:52 pg_xlog directory Justin W. Reagor

5 January 2006

00:00 Re: pg_xlog directory Tom Lane
00:07 Re: Best way to manage users Frank Bax
03:00 Re: We want to monitor total size of database Yumiko Izumi
05:17 Re: We want to monitor total size of database Jaime Casanova
05:52 Re: We want to monitor total size of database Yumiko Izumi
07:29 Re: GRANT access rights on rows Andrew Chambers
07:36 Re: GRANT access rights on rows Bruno Wolff III
07:37 can't connect to postgresql via phppgadmin and pgaccess First Last
07:48 Re: can't connect to postgresql via phppgadmin and pgaccess A. Kretschmer
07:53 Re: GRANT access rights on rows A. Kretschmer
07:57 Re: GRANT access rights on rows Bruno Wolff III
09:50 Re: Best way to manage users Roland Giesler
11:14 Re: can't connect to postgresql via phppgadmin and pgaccess First Last
11:24 Re: can't connect to postgresql via phppgadmin and pgaccess A. Kretschmer
12:32 Re: Best way to manage users Kevin Crenshaw
12:50 Re: Best way to manage users Charley Tiggs
13:02 Re: Best way to manage users Kevin Crenshaw
13:29 Re: Best way to manage users Roland Giesler
15:36 sending N selects with begin and commit and get the result Luis Silva
18:19 Best Type to use Ketema Harris
19:10 Re: Best Type to use Kevin Crenshaw
19:18 index over boolean fields?
19:23 Re: index over boolean fields? Jaime Casanova
19:27 Re: Best Type to use Ketema Harris
19:49 Re: sending N selects with begin and commit and get the result Andrew Chambers

6 January 2006

01:12 PostgreSQL 8.1 Omar Zevallos
02:52 Re: PostgreSQL 8.1 Michael Fuhr
03:06 Re: PostgreSQL 8.1 Omar Zevallos
04:18 Re: PostgreSQL 8.1 Michael Fuhr
10:12 Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!! Info
15:23 Problem when trying to compile and link program on Windows to libpq Michael Atkisson
17:11 Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!! Jaime Casanova
18:13 Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!!
19:04 Re: Problem when trying to compile and link program on Windows to libpq Andrew Chambers
23:02 SQL Question
23:28 primary key on lower(varchar)

7 January 2006

01:26 Re: SQL Question Michael Fuhr
03:35 Re: primary key on lower(varchar) Tom Lane
04:29 Re: primary key on lower(varchar)

8 January 2006

06:11 Re: primary key on lower(varchar)
12:18 Re: primary key on lower(varchar) Charley Tiggs

9 January 2006

11:42 how to list all tables in a database Joao Miguel Ferreira
11:47 Re: how to list all tables in a database Sean Davis
11:48 Re: how to list all tables in a database Adam Witney
11:48 Re: how to list all tables in a database A. Kretschmer
12:08 Triggers and speed - 7.4.5 / 8.0.3 Steve Tucknott
12:13 Re: Triggers and speed - 7.4.5 / 8.0.3 Sean Davis
12:57 how to recall the initial definition (CREATE TABLE) of a table ? Joao Miguel Ferreira
13:08 Re: how to recall the initial definition (CREATE TABLE) of a table ? A. Kretschmer
13:08 Re: how to recall the initial definition (CREATE TABLE) Sean Davis
13:10 Re: how to recall the initial definition (CREATE TABLE) of a table ?
14:35 Re: how to list all tables in a database Brad Nicholson
14:38 Re: how to recall the initial definition (CREATE TABLE) Jaime Casanova
14:43 What does 'schema' mean ? Joao Miguel Ferreira
14:52 Re: What does 'schema' mean ? Neil Saunders
14:56 Re: how to recall the initial definition (CREATE TABLE) A. Kretschmer
14:59 Re: What does 'schema' mean ? A. Kretschmer
15:14 Re: What does 'schema' mean ? Tom Lane
15:15 Re: how to recall the initial definition (CREATE TABLE) Jaime Casanova
15:27 Re: What does 'schema' mean ? Frank Bax
15:35 Re: Triggers and speed - 7.4.5 / 8.0.3 Steve Tucknott
16:41 Re: how to recall the initial definition (CREATE TABLE) of a table ?
16:47 Re: What does 'schema' mean ?
16:48 Re: how to recall the initial definition (CREATE TABLE) of a table ? Guido Barosio
17:28 Re: how to recall the initial definition (CREATE TABLE) of a table ? Andrew Chambers
17:34 database ->xml Luis Silva
18:06 Re: how to recall the initial definition (CREATE TABLE) of a table ? A. Kretschmer
19:18 Re: how to recall the initial definition (CREATE TABLE) of a table ?
22:28 Re: SQL Question
22:42 Re: SQL Question Stephen Clouse
22:59 Re: database ->xml Bruce Momjian

10 January 2006

00:08 Re: SQL Question
06:00 With auto vacuum, is analyze still necessary? Brendan Duddridge
11:24 Preventing access of user1 to user2's database Joao Miguel Ferreira
13:29 translating this SQL query from a different dialect Vanja
14:30 Re: Preventing access of user1 to user2's database Danjel Jungersen
14:31 Re: translating this SQL query from a different dialect Jaime Casanova
14:32 Re: translating this SQL query from a different dialect A. Kretschmer
14:33 Re: With auto vacuum, is analyze still necessary? Tom Lane
14:42 Error Returned by A Function Lane Van Ingen
14:57 Re: Preventing access of user1 to user2's database Tom Lane
15:16 Re: Error Returned by A Function Lane Van Ingen
15:33 Re: Error Returned by A Function Tom Lane
15:40 Re: Error Returned by A Function Michael Fuhr
16:39 Re: translating this SQL query from a different dialect Michael Fuhr
17:28 Re: translating this SQL query from a different dialect A. Kretschmer
18:06 Re: translating this SQL query from a different dialect A. Kretschmer
19:01 Re: translating this SQL query from a different dialect A. Kretschmer
19:04 Re: translating this SQL query from a different dialect Jaime Casanova
19:11 Re: translating this SQL query from a different dialect A. Kretschmer
20:04 Re: translating this SQL query from a different dialect Vanja
21:18 A question about pages tmorelli@tmorelli.com.br
21:32 Re: A question about pages Tom Lane

11 January 2006

05:19 Intel Macs and PostgreSQL Brendan Duddridge
06:13 Re: Intel Macs and PostgreSQL Tom Lane
07:06 Re: Intel Macs and PostgreSQL Brendan Duddridge
10:25 Re: Intel Macs and PostgreSQL Sean Davis
17:41 convert bool result query Luis Silva
17:58 Re: convert bool result query Michael Fuhr
18:00 Re: convert bool result query Luis Silva
18:07 Removing duplicate entries Scott Ford
19:05 Re: Removing duplicate entries Jaime Casanova
19:18 Re: Removing duplicate entries Michael Fuhr
19:30 Comparing databases Sugrue, Sean
19:34 Re: Comparing databases Tom Lane
19:52 Open Office2 Steve Tucknott
20:01 Re: Sequential Scans On Complex Query With UNION - see Steve Tucknott
20:22 Re: Removing duplicate entries Scott Ford
22:37 Re: Sequential Scans On Complex Query With UNION - see why this fails Michael Glaesemann
22:39 Re: Intel Macs and PostgreSQL Brendan Duddridge

12 January 2006

02:21 Re: Sequential Scans On Complex Query With UNION - see why this fails Tom Lane
02:48 Re: Sequential Scans On Complex Query With UNION - see why this fails Michael Glaesemann
03:43 Re: Sequential Scans On Complex Query With UNION - see why this fails Tom Lane
03:50 Re: Removing duplicate entries Michael Fuhr
03:51 Re: Comparing databases Brendan Duddridge
11:27 A question about pages. Still not clear tmorelli@tmorelli.com.br
12:37 trigger / to_char()-function / extract()-function mushroom2@uboot.com
12:46 Forums Mark Campbell
13:25 Re: Forums A. Kretschmer
14:07 Re: A question about pages. Still not clear Guido Barosio
16:01 Re: Removing duplicate entries Michael Fuhr
16:06 Re: Removing duplicate entries Scott Ford
16:09 Sort of Complex Query - Howto Eliminate Repeating Results
16:21 Re: A question about pages. Still not clear Tom Lane
16:52 Re: [despammed] CSV Import? Lucius Seneca
17:51 Re: Forums Frank Bax
18:46 Re: Sort of Complex Query - Howto Eliminate Repeating Results Michael Fuhr
18:59 Re: Sort of Complex Query - Howto Eliminate Repeating Results
19:07 Re: Sort of Complex Query - Howto Eliminate Repeating Results
19:19 Re: A question about pages. Now is VERY clear! tmorelli@tmorelli.com.br
19:35 Re: Sort of Complex Query - Howto Eliminate Repeating Results Michael Fuhr
19:57 Re: Sort of Complex Query - Howto Eliminate Repeating Results
22:11 storing record-array in varchar?
23:59 Re: storing record-array in varchar? Michael Fuhr

13 January 2006

00:39 moving db off a rooted server fearff@yahoo.com
04:54 Re: trigger / to_char()-function / extract()-function Michael Fuhr
11:39 Re: storing record-array in varchar?
12:16 How to set a Default Value Ângelo Marcos Rigo
12:28 Re: How to set a Default Value Michael Glaesemann
12:29 Re: How to set a Default Value Sean Davis
14:39 Setting a variable for current session (set, define or something) for auditing Christian Hofmann
15:39 User variables like: SET @a='test'; Christian Hofmann
16:40 Re: How to set a Default Value Ângelo Marcos Rigo
17:30 Re: How to set a Default Value Michael Fuhr

14 January 2006

15:47 help with query: advanced ORDER BY...
16:18 Re: help with query: advanced ORDER BY... Michael Fuhr
19:32 Re: help with query: advanced ORDER BY...

15 January 2006

00:38 Re: help with query: advanced ORDER BY... Michael Fuhr
01:15 Re: help with query: advanced ORDER BY...
02:36 Re: help with query: advanced ORDER BY... Michael Glaesemann
09:53 Re: help with query: advanced ORDER BY...
09:59 Re: help with query: advanced ORDER BY... Michael Glaesemann
17:19 Help with query Christian Hofmann
17:33 Re: help with query: advanced ORDER BY... Stephan Szabo
17:49 Re: Help with query Andreas Kretschmer
18:26 Re: Help with query Christian Hofmann

16 January 2006

05:09 Re: Help with query A. Kretschmer
11:56 Re: Help with query Christian Hofmann
12:11 block transactions in stored procedures Ghiz x
15:46 Re: Help with query Andreas Kretschmer
18:26 Query problem
18:46 Re: Query problem - Possible solution

17 January 2006

07:43 Fw: Help needed Minal A. Aryamane
08:05 First post - first question Cédric Buschini
08:43 Re: First post - first question Michael Glaesemann
10:23 Re: First post - first question Guido Barosio
21:10 Finding and replacing text within records Lynna Landstreet
21:38 alter table set tablespace over nfs getting stuck s anwar
21:53 Re: alter table set tablespace over nfs getting stuck Tom Lane
23:48 Re: Finding and replacing text within records Andrew Chambers

18 January 2006

00:23 Re: alter table set tablespace over nfs getting stuck s anwar
19:35 Huge size of Data directory Anthony Presley
19:52 Swappng Filds Greg Lindstrom
19:54 Re: Huge size of Data directory Tom Lane
20:10 Re: Huge size of Data directory Michael Fuhr
20:12 Moving existing tables into an inheritence hierarchy s anwar
20:28 Re: Swappng Filds Tom Lane
20:39 Re: Swappng Filds Michael Fuhr
20:41 Re: Huge size of Data directory Anthony Presley
20:57 Re: Huge size of Data directory Michael Fuhr

19 January 2006

10:13 Problems with select statement Lynna Landstreet
13:55 Re: Problems with select statement Stephan Szabo
18:49 Re: Problems with select statement Lynna Landstreet
19:47 Re: Problems with select statement Stephan Szabo
19:55 Re: Problems with select statement Frank Bax
22:11 Re: Problems with select statement George Weaver

20 January 2006

04:21 Curious date problem Tim Daly
05:07 save to another database First Last
05:20 Re: save to another database A. Kretschmer
06:08 Initdb panic: invalid record offset at 0/0 creating template1 Agnes Bocchino
06:38 Re: Problems with select statement Lynna Landstreet
07:24 column number instead of column name First Last

21 January 2006

04:23 Re: column number instead of column name Michael Fuhr

22 January 2006

01:39 msysconf error David Chapman

23 January 2006

05:13 Re: Forums Bruno Wolff III
12:56 default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP f g
13:31 Re: default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP A. Kretschmer
16:24 Re: default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP f g
22:03 Maximum useful number of partitions in a table s anwar

24 January 2006

16:51 pl/pgsql switch Luis Silva
19:51 Re: pl/pgsql switch Michael Fuhr
20:50 Re: default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP Michael Fuhr

25 January 2006

21:02 Re: block transactions in stored procedures Jaime Casanova

26 January 2006

21:22 Update & Lack of Error Message
21:53 Re: Update & Lack of Error Message Michael Fuhr
23:13 Re: Update & Lack of Error Message

27 January 2006

01:59 Re: Update & Lack of Error Message Michael Fuhr
08:51 Password Authentication Error s21113298@tuks.co.za
16:49 problem with returning values from pl/pgsql Luis Silva
18:31 Problema con postgresql 8.1.2 Luzmar Caicedo Useche
19:01 Re: Problema con postgresql 8.1.2 Jaime Casanova
19:07 Using drop database from psql Lan Barnes
19:13 Problem with pg_dump Luzmar Caicedo Useche
19:33 Re: Using drop database from psql Tom Lane
19:38 Re: Problem with pg_dump Tom Lane

28 January 2006

00:40 Re: Using drop database from psql Guido Barosio

30 January 2006

02:21 Re: msysconf error Rolf Østvik
02:22 Question about support for SUSE 10 Frederic_Therrien@DMR.CA
02:22 Re: column number instead of column name First Last
02:22 Using postgresql on Debian Gerard Cullen
02:22 put text list into table form Web2cad
02:22 Charting postgres schemas and table data into Kivio Rob
02:22 Restoring SQL Databse for use in PostgreSQL. Dhivya
02:22 problem with pg_dump - attrdef record(s) missing richard
02:45 Re: problem with pg_dump - attrdef record(s) missing Tom Lane
03:06 Re: Charting postgres schemas and table data into Kivio Michael Fuhr
07:22 Re: Question about support for SUSE 10 Devrim GUNDUZ
10:43 Re: put text list into table form Sean Davis
10:50 wrong objects order using pg_dump Oleg
13:15 Re: Problem with pg_dump Luzmar Caicedo Useche
13:46 Re: wrong objects order using pg_dump Jaime Casanova
14:04 Schema with Postgress 8.1 chris preston
14:16 Re: wrong objects order using pg_dump Tom Lane
14:31 Help, 400 million rows, query slow, I stopped after 5 days Christian Hofmann
14:36 Re: wrong objects order using pg_dump Oleg
14:41 quering NULL values Luis Silva
14:45 Re: Help, 400 million rows, query slow, I stopped after 5 days Tom Lane
14:47 Re: quering NULL values Charley Tiggs
14:54 Re: Help, 400 million rows, query slow, I stopped after 5 days Christian Hofmann
14:55 Re: quering NULL values Luis Silva
15:28 Re: Help, 400 million rows, query slow, I stopped after 5 days Tom Lane
16:28 Re: Restoring SQL Databse for use in PostgreSQL. Bruno Wolff III
16:45 Re: Help, 400 million rows, query slow, I stopped after 5 days Christian Hofmann
17:49 Upgrade to PG 8 before starting major development? Lan Barnes
18:55 Re: Upgrade to PG 8 before starting major development? Lan Barnes
19:26 Re: Upgrade to PG 8 before starting major development?

31 January 2006

00:04 Insert Text
00:13 Re: Insert Text Michael Glaesemann
03:01 Dynamic column names in plpgsql Derrick Betts
04:41 Re: Upgrade to PG 8 before starting major development? Bruno Wolff III
10:55 Re: put text list into table form Sean Davis
10:59 copy Clifton Zama
11:17 How to define variables in psql?
11:51 lost archives, alpha data files Tomka Gergely
12:20 Re: How to define variables in psql? A. Kretschmer
12:35 Re: How to define variables in psql?
13:30 Re: Upgrade to PG 8 before starting major development? Andreas
13:34 Re: Dynamic column names in plpgsql Tom Lane
14:00 Re: copy Tom Lane
14:04 Re: lost archives, alpha data files Tom Lane
14:07 Re: lost archives, alpha data files Tomka Gergely
14:10 ... Gan Uesli Starling
14:17 function returning a setof a column type Murat Tasan
14:48 Re: Tom Lane
17:53 Re: function returning a setof a column type Tom Lane
19:02 subscribe-digest Darren R
20:10 How to GRANT SELECT on all tables?
20:45 Re: How to GRANT SELECT on all tables? Tom Lane
21:37 Re: How to GRANT SELECT on all tables? Kevin Crenshaw