Home > mailing lists

Mailing lists [pgsql-novice]

1 December 2005

00:00 Re: Error
00:12 Re: Error
02:30 Re: Error Charley Tiggs
02:38 Re: Combinatorial problem Marcus Engene
13:33 Re: child fk problem Oliver Elphick
14:50 Re: Error Charley Tiggs
17:04 Re: Error
17:23 Re: Error Marcus Engene
19:40 Re: PostgreSQL 8.1.0-2 WinXP Services ig@freemail.gr (ILIAS GOUDAROPOULOS)
22:53 Re: PostgreSQL 8.1.0-2 WinXP Services

2 December 2005

16:41 Re: saving a query and reults to a file. T. Lackey
23:21 PL/pgSQL Jim Beckstrom

3 December 2005

00:37 Re: saving a query and reults to a file.
02:49 Re: PL/pgSQL Michael Fuhr
18:57 Install 8.1 on Mac OS 10.4 Viva Chu
19:10 Re: Install 8.1 on Mac OS 10.4 Brendan Duddridge
19:37 Re: Install 8.1 on Mac OS 10.4 Tom Lane
21:25 What is the Best Way to Learn PL/pgSQL?
22:59 Re: What is the Best Way to Learn PL/pgSQL? Srinivas Iyyer

4 December 2005

08:20 SQL Statement Help Needed Michael Avila
10:44 Re: PostgreSQL 8.1.0-2 WinXP Services Ilias Goudaropoulos
11:44 Re: What is the Best Way to Learn PL/pgSQL? Marcus Engene
13:46 Re: SQL Statement Help Needed Frank Bax
19:24 Re: SQL Statement Help Needed brew@theMode.com
21:08 Re: SQL Statement Help Needed Michael Avila
21:47 Re: SQL Statement Help Needed Marcus Engene
21:55 fts, compond words? Marcus Engene

5 December 2005

00:49 fk problems with 0..n relations Luis Silva
03:51 Re: fk problems with 0..n relations Bruno Wolff III
04:39 Trigger question George McQuade
08:28 Need help building SQL query Robert Blixt
10:27 fk problems with 0..n relations Luis Silva
15:41 Re: Need help building SQL query Bruno Wolff III
17:39 Date Format Question Ângelo Marcos Rigo
18:11 Re: Date Format Question Frank Bax
18:42 Re: Date Format Question Tom Lane
18:57 Re: Date Format Question Frank Bax
19:34 Re: Need help building SQL query Sugrue, Sean
23:04 Re: Need help building SQL query
23:15 OT - Development question Mike Ellsworth
23:20 Re: SQL Statement Help Needed

6 December 2005

00:14 Re: fk problems with 0..n relations
00:18 Re: Need help building SQL query William Yu
03:44 Re: SQL Statement Help Needed
06:04 Re: Need help building SQL query Robert Blixt
12:59 Re: Need help building SQL query Michael Swierczek
14:50 Musings on Triggers Joshua Kramer
15:36 Re: Musings on Triggers A. Kretschmer
16:16 How to see detailed plan of a funciton Obe, Regina DND\\MIS
16:17 Re: Musings on Triggers Michael Fuhr
17:30 Re: SQL Statement Help Needed
17:55 Re: SQL Statement Help Needed Jaime Casanova
19:11 CSV file - Using COPY Command - Double-Quotes Walter
19:17 Re: CSV file - Using COPY Command - Double-Quotes Bruce Momjian
20:09 Re: CSV file - Using COPY Command - Double-Quotes Tom Lane
20:15 Re: CSV file - Using COPY Command - Double-Quotes Walter
20:17 Re: CSV file - Using COPY Command - Double-Quotes
20:24 Re: CSV file - Using COPY Command - Double-Quotes Daniel T. Staal
21:20 Re: CSV file - Using COPY Command - Double-Quotes Mike Ellsworth

7 December 2005

02:50 Hide PL/pgsql Function Logic Suisen Kicosuanto
02:51 ODBC driver is broken P G
02:51 PostgreSQL questions Gregory Hight
02:51 PgSQL Initial Questions (before starting project) Paulo Jorge Matos
02:51 \list Jos
02:51 Pl/pgsql import Jim Beckstrom
02:51 Re: SQL Statement Help Needed Charley Tiggs
02:59 Re: \list Tom Lane
03:01 Re: \list Michael Fuhr
07:44 connect to another db Robert Wimmer
07:51 Re: connect to another db A. Kretschmer
08:06 Re: PgSQL Initial Questions (before starting project)
08:10 Re: ODBC driver is broken
08:19 Re: connect to another db Robert Wimmer
08:31 Coordinates question Aarni Ruuhimäki
09:48 Re: Coordinates question Neil Saunders
12:37 Re: Pl/pgsql import John DeSoi
12:53 Re: How to see detailed plan of a funciton Andreas Seltenreich
14:12 trigger function with arguments from a sql command Luis Silva
14:21 Re: trigger function with arguments from a sql command A. Kretschmer
14:43 Re: trigger function with arguments from a sql command Luis Silva
15:36 relations in PostgreSQL 8.1 Omar Zevallos
15:43 Re: connect to another db Andreas Kretschmer
16:35 Re: relations in PostgreSQL 8.1
16:46 Re: connect to another db
22:25 Location of index information Jim Beckstrom
22:32 Re: Location of index information Tom Lane
22:34 Re: Location of index information Michael Glaesemann
22:38 Re: Location of index information Michael Fuhr

8 December 2005

02:54 Re: Location of index information Jim Beckstrom
03:41 Re: Location of index information Tom Lane
15:44 Re: Location of index information Jaime Casanova
17:00 Compile/Link Error for Postgres 8.1.0 on Solaris 8 Bhide, Rajan
17:23 Re: Compile/Link Error for Postgres 8.1.0 on Solaris 8 Alan Stange
18:30 Re: Compile/Link Error for Postgres 8.1.0 on Solaris 8 Tom Lane
18:35 Re: Compile/Link Error for Postgres 8.1.0 on Solaris 8 Alan Stange
18:43 Re: Compile/Link Error for Postgres 8.1.0 on Solaris 8 Bruce Momjian

9 December 2005

07:18 Re: Compile/Link Error for Postgres 8.1.0 on Solaris 8 Bhide, Rajan
10:20 PostGreSQL 8.1.0 : out of memory during vacuum full analyze DANTE ALEXANDRA
11:11 PostGreSql+Conectiva 10+initdb - Installation problems Jeanne Louize Emygdio
13:16 remove me please Pet Campbell
13:26 Re: PostGreSql+Conectiva 10+initdb - Installation problems Tom Lane
13:58 Re: PostGreSql+Conectiva 10+initdb - Installation problems Jeanne Louize Emygdio
14:16 Re: Compile/Link Error for Postgres 8.1.0 on Solaris 8 Aly S.P Dharshi
18:56 Return void error in PG 8.1.0 Walker, Jed S
19:21 Re: Return void error in PG 8.1.0 Tom Lane
19:28 Re: Return void error in PG 8.1.0 Walker, Jed S
20:54 Bind Variables and Quoting / Dequoting Input

10 December 2005

00:22 Re: Bind Variables and Quoting / Dequoting Input Michael Fuhr
00:58 Re: Bind Variables and Quoting / Dequoting Input Michael Fuhr
01:10 Sorting empty rows at the bottom of a recordset Matt Arnilo S. Baluyos (Mailing Lists)
02:12 Re: Sorting empty rows at the bottom of a recordset Michael Fuhr
17:04 Views an non-present column Fabien SK
17:48 Re: Views an non-present column Bruno Wolff III
18:02 Re: Views an non-present column Fabien SK
22:30 Book Application Mag Gam

11 December 2005

01:38 Re: formating a select from a timestamp column Keith Worthington

12 December 2005

01:51 Hi, connecting PostgreSQL 8.1 to GeoServer1.3 Omar Zevallos
03:36 phpPgAdmin on Debian Sarge john hedge
08:17 Disk access with fsync on. Bhide, Rajan
10:00 transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile Agnes Bocchino
12:51 Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile Charley Tiggs
14:13 Re: Disk access with fsync on. Tom Lane
14:21 Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile Tom Lane
15:30 How to delete the oldest X number of rows? John Roberts
15:42 Re: How to delete the oldest X number of rows? Mathieu Arnold
15:47 Re: How to delete the oldest X number of rows? A. Kretschmer
16:05 Re: Bind Variables and Quoting / Dequoting Input
16:08 Re: Bind Variables and Quoting / Dequoting Input
16:55 Re: Bind Variables and Quoting / Dequoting Input Michael Fuhr

13 December 2005

01:28 Re: How to delete the oldest X number of rows? John Roberts
08:35 Re: transaction ID wrap limit is 2147484146 Start Postgresql Agnes Bocchino
16:30 Update Query Problem
16:37 Re: Update Query Problem Charley Tiggs
16:37 How to recover space from a failed cluster s anwar
16:39 Re: Update Query Problem Andreas Kretschmer
16:43 Re: Update Query Problem Jaime Casanova
16:49 Re: Update Query Problem Michael Fuhr
16:52 Re: Update Query Problem Charley Tiggs
17:02 Re: Update Query Problem
17:06 Re: Update Query Problem Andreas Kretschmer
17:06 Re: How to recover space from a failed cluster Tom Lane
17:09 Re: Update Query Problem
19:42 Re: Bind Variables and Quoting / Dequoting Input
20:39 Re: What is the Best Way to Learn PL/pgSQL? manjusri schuit
22:03 Multi-row update w. plpgsql Daniel Hertz
22:10 Table Structure Advice
22:21 Re: Table Structure Advice

14 December 2005

02:46 create table with table constraints Jim Beckstrom
05:33 Re: create table with table constraints Michael Fuhr
06:12 Offline database usage Roland Giesler
10:36 Re: Multi-row update w. plpgsql Oliver Elphick
10:37 VB.Net with PostgreSQL Vishal Kashyap
11:27 Re: VB.Net with PostgreSQL Jaime Casanova
12:30 Re: VB.Net with PostgreSQL Charles Bai
13:23 Sequence on a char(6) column Roland Giesler
13:26 Re: Sequence on a char(6) column Jaime Casanova
18:05 Help please Charlie Bright
18:08 Re: TEMPORARY TABLE in a PL/pgSQL function Luiz K. Matsumura
18:18 Re: TEMPORARY TABLE in a PL/pgSQL function Oliver Elphick
18:27 Repercussions of killing a vacuum s anwar
18:41 Re: Help please Roland Giesler
18:57 Re: Help please Daniel T. Staal
19:28 Re: Repercussions of killing a vacuum Brad Nicholson
21:17 Re: Sequence on a char(6) column Bruno Wolff III
23:26 RoR Tutorial

15 December 2005

00:00 Inheritance : terminology.... Norberto Meijome
00:47 Re: RoR Tutorial Roland Giesler
02:05 Re: Sequence on a char(6) column Bruno Wolff III
03:05 Re: Sequence on a char(6) column Roland Giesler
03:32 Re: Sequence on a char(6) column Bruno Wolff III
03:59 GUID function in pgsql?
05:05 Re: GUID function in pgsql? Bruno Wolff III
07:34 client-server connection Ramon Orticio
07:51 Re: client-server connection A. Kretschmer
10:02 Re: TEMPORARY TABLE in a PL/pgSQL function Luiz K. Matsumura
10:11 Re: GUID function in pgsql?
10:51 Re: GUID function in pgsql? Norberto Meijome
10:52 Re: client-server connection Oliver Elphick
11:05 Re: GUID function in pgsql?
13:12 Command line psql and other ODBC access. T. Lackey
13:32 Re: Command line psql and other ODBC access. Sean Davis
15:34 Re: RoR Tutorial - OFF TOPIC
16:48 Re: GUID function in pgsql? Bruno Wolff III
21:21 Re: create table with table constraints Jim Beckstrom
21:36 Re: create table with table constraints Tom Lane
21:49 Re: create table with table constraints Michael Fuhr
22:02 how do I import pqsl 7.1 database into 8.0 Mike Shen
23:08 Re: how do I import pqsl 7.1 database into 8.0 Tom Lane

16 December 2005

01:10 Regarding retrieving a bytea datatype using embedded SQL Raghunandan Bapuram
03:44 How populate : variables dynamically? Doug
06:21 sockets and refused connections Dirk Dil
06:29 Re: sockets and refused connections Tom Lane
16:47 Proper Use of Triggers (and Perhaps Locks) Lane Van Ingen

17 December 2005

15:10 Login problem Danjel Jungersen

18 December 2005

02:51 Re: Login problem John DeSoi
09:43 Re: Login problem Danjel Jungersen
13:00 Re: Login problem John DeSoi
13:00 COPY command, linking foreign keys Srinivas Iyyer

19 December 2005

02:41 procedures for adding data Mogin Mohandas
02:56 Re: procedures for adding data Michael Glaesemann
11:03 Re: COPY command, linking foreign keys Sean Davis
13:27 Re: COPY command, linking foreign keys Srinivas Iyyer
14:46 pg_config not found Luis Silva
15:21 Re: Repercussions of killing a vacuum s anwar
15:41 Re: COPY command, linking foreign keys Sean Davis
21:26 Install Error Kent Morrison
22:08 Re: procedures for adding data Mogin Mohandas
22:35 Re: procedures for adding data Michael Glaesemann

20 December 2005

06:34 Re: Login problem Danjel Jungersen
11:57 problems restoring database from plain text backup Oleg
12:37 Re: Login problem John DeSoi
13:26 problems restoring database from plain text backup from psql Oleg
13:38 Re: problems restoring database from plain text backup from psql Tom Lane
14:58 transfer database from Linux to Windows Oleg
15:20 Re: transfer database from Linux to Windows Jaime Casanova
15:55 Re: Login problem Danjel Jungersen
15:56 Re: transfer database from Linux to Windows Oleg
16:05 Re: Login problem Tom Lane
16:17 Re: transfer database from Linux to Windows Jaime Casanova
16:19 Re: transfer database from Linux to Windows Jaime Casanova
16:22 Re: Login problem Danjel Jungersen
17:27 Re: Login problem Frank Bax
18:46 Re: Install Error

21 December 2005

04:00 Using bytea Raghunandan Bapuram
04:00 Static Variables in PL/PGSQL Michael Dengler
04:00 how to pass the password value in single statement. mallikarjun.revgond
04:00 can not create trigger with parameter Rahul Patil
04:00 Postgresql v 8.0.1-3 problems Miguel
04:00 Re: GUID function in pgsql? Chris Browne
04:00 Small function in PLPGSQL Tirant Lo Blanc
04:00 Error connecting to database Stephen Simpson
04:00 how do i add a number of days to now()? stig erikson
04:02 Questions about server. max chin
04:02 Find list of table names for particular DB webbj2@Scranton.edu
04:32 Re: how do i add a number of days to now()? Michael Glaesemann
05:03 Re: Static Variables in PL/PGSQL A. Kretschmer
05:22 Re: Postgresql v 8.0.1-3 problems Devrim GUNDUZ
13:46 Re: Small function in PLPGSQL Tjibbe Rijpma
14:11 Re: transfer database from Linux to Windows Oleg
14:18 Re: transfer database from Linux to Windows Jaime Casanova
14:53 Re: transfer database from Linux to Windows Oleg
15:02 Re: can not create trigger with parameter Chandra Sekhar Surapaneni
15:29 GIS and postgresql Randy Long
15:34 plpgsql function returning SETOF Johannes Brügmann
15:39 Re: GIS and postgresql Tom Lane
15:41 Re: GIS and postgresql Michael Fuhr
15:43 Re: GIS and postgresql Oleg
16:13 Re: Questions about server. Daniel T. Staal
16:14 Re: plpgsql function returning SETOF A. Kretschmer
16:19 Re: transfer database from Linux to Windows Jaime Casanova
16:40 Re: Postgresql v 8.0.1-3 problems
17:19 Re: plpgsql function returning SETOF Johannes Brügmann
17:31 Re: plpgsql function returning SETOF Johannes Brügmann
17:39 Re: plpgsql function returning SETOF Andreas Kretschmer
17:50 Re: plpgsql function returning SETOF Tom Lane
18:08 Re: plpgsql function returning SETOF Johannes Brügmann
18:10 Re: plpgsql function returning SETOF Johannes Brügmann
19:34 Re: Questions about server. Brad Nicholson
22:40 Re: [HACKERS] problem with nasty latin2 sorting Tom Lane

22 December 2005

11:10 Re: transfer database from Linux to Windows Oleg
13:58 Re: problem with nasty latin2 sorting Volkan YAZICI
14:28 Tsearch 2, index in different table? Mag Gam
14:50 long transaction with concurrent SELECT statements Tim Baumgartner
15:49 Re: Tsearch 2, index in different table? Mag Gam
16:26 Re: long transaction with concurrent SELECT statements Tom Lane
17:59 Re: Tsearch 2, index in different table?

23 December 2005

01:48 Postgres 8.1 choosing the larger index for an index scan s anwar
01:53 2 Questions Ramon Orticio
03:46 Re: Postgres 8.1 choosing the larger index for an index scan Tom Lane
03:51 Re: 2 Questions Dario Brignardello
06:49 Re: 2 Questions Devrim GUNDUZ
14:15 PostgreSQL Logging Mag Gam
15:05 Lane Van Ingen
15:19 Re: Sean Davis
15:29 Re: Tom Lane
17:59 Re: 2 Questions
18:03 Re: 2 Questions
18:59 Re: Lane Van Ingen

24 December 2005

13:27 Re: PostgreSQL Logging Oliver Elphick
16:40 Re: PostgreSQL Logging Mag Gam
17:04 Logs not Rotating Mag Gam

25 December 2005

00:55 Re: Logs not Rotating Tom Lane
04:31 Re: Logs not Rotating Mag Gam

26 December 2005

14:32 Re: Logs not Rotating Tom Lane
19:12 ... Jaromír Kamler

27 December 2005

01:48 speeding up pg_dump?
03:35 Re: speeding up pg_dump? Tom Lane
04:39 Re: speeding up pg_dump?
04:56 Re: speeding up pg_dump? Tom Lane
05:10 Re: speeding up pg_dump?
07:25 Re: 2 Questions Ramon Orticio
17:29 Complex Query Help- For Me, Anyway
18:11 Re: Complex Query Help- For Me, Anyway Keith Worthington
20:46 Re: Complex Query Help- For Me, Anyway
21:18 Re: Complex Query Help- For Me, Anyway Keith Worthington
21:54 Re: Complex Query Help- For Me, Anyway

28 December 2005

00:22 Re: Complex Query Help- For Me, Anyway Keith Worthington
01:42 We want to monitor total size of database Yumiko Izumi
11:22 Re: Complex Query Help- For Me, Anyway Kevin Crenshaw
13:00 Re: We want to monitor total size of database Larry Rosenman
13:22 Re: We want to monitor total size of database Jaime Casanova
13:53 limiting number of allowed rows in a table Vanja
14:00 Re: limiting number of allowed rows in a table Sean Davis
15:35 Re: limiting number of allowed rows in a table Vanja
17:01 Re: Postgres 8.1 choosing the larger index for an index scan s anwar
23:11 ?linux distro? Randy Burkhardt
23:41 Re: ?linux distro? Richard Broersma Jr

29 December 2005

00:28 Re: ?linux distro?
00:46 Re: ?linux distro? Tom Lane
02:43 Re: ?linux distro?
16:49 Re: ?linux distro? Joshua Kramer
22:32 Simple Accumulating Number Loop? Ubence Quevedo
22:36 Re: ?linux distro? Oliver Elphick
22:44 help with date_part & day of week

30 December 2005

00:00 Re: help with date_part & day of week Bruce Momjian
00:36 Re: help with date_part & day of week
01:01 ecommerce soolution Michael Dean
01:36 Re: help with date_part & day of week Bruce Momjian
01:45 Re: ecommerce soolution John DeSoi
12:36 pg_trigger permissions Steve Tucknott
13:59 Re: pg_trigger permissions Tom Lane
14:07 Re: pg_trigger permissions Steve Tucknott
20:52 Correct way to set up Variables [Was - Simple Accumulating Number Loop?] Ubence Quevedo

31 December 2005

06:14 PG_Dump Users and Groups David Chapman
06:14 Restoring to a different tablespace Joeseph Blowseph
06:14 Postgresql 8.1 Rana Biswas
06:14 Re: speeding up pg_dump? Christopher Browne
06:14 Re: limiting number of allowed rows in a table Christopher Browne
06:15 Re: ?linux distro? Gordon Haverland
06:15 Re: [GENERAL] Simple Accumulating Number Loop? Bricklen Anderson
06:15 Re: ecommerce soolution Christopher Browne
06:15 pg:8.0 -> 8.1 - COPY and UTF-8 error on restore. yaptNO@technovellSPAM.com
07:48 Re: Postgresql 8.1 Devrim GUNDUZ
08:49 Limit to mail size? Steve Tucknott
16:18 Re: Limit to mail size? Marc G. Fournier
18:59 Re: ecommerce solution Michael Avila
19:24 Re: PG_Dump Users and Groups Tom Lane
19:29 Re: Restoring to a different tablespace Tom Lane
19:32 Re: Limit to mail size? Tom Lane