create function(date,date,date,...)

Started by Radek Kanovskyover 26 years ago1 messagesgeneral

radekk@uh.cz

over 26 years ago

Hi,

i am trying to declare function that gets six date arguments
and returns some status according actual date. It looks like
this:

CREATE FUNCTION datum_ok(DATE,DATE,DATE,DATE,DATE,DATE) RETURNS TEXT AS '
DECLARE
tests ALIAS FOR $1 ;
teste ALIAS FOR $2 ;
payments ALIAS FOR $3 ;
paymente ALIAS FOR $4 ;
interrupts ALIAS FOR $5 ;
interrupte ALIAS FOR $6 ;
today DATE ;
BEGIN
today := now()::date ;
.....

It happens that when some argument is NULL, than all argument get NULL.
It works correctly only when all arguments are not NULL.

SELECT
login,
datum_ok(
test_start, test_end,
payment_start, payment_end,
interrupt_start, interrupt_end )
FROM service ;

How can I mix NULL and DATE values in arguments?

Thanks

Radek Kanovsky, rk@uh.cz

From bouncefilter Sat Sep 25 22:13:37 1999
Received: from osprey.astro.umass.edu (root@osprey.astro.umass.edu
[128.119.51.182]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA78162
for <pgsql-general@postgreSQL.org>;
Sat, 25 Sep 1999 22:13:17 -0400 (EDT)
(envelope-from weinberg@osprey.astro.umass.edu)
Received: (from weinberg@localhost)
by osprey.astro.umass.edu (8.9.3/8.9.3/Debian/GNU) id WAA18564;
Sat, 25 Sep 1999 22:13:17 -0400
Date: Sat, 25 Sep 1999 22:13:17 -0400
Message-Id: <199909260213.WAA18564@osprey.astro.umass.edu>
From: Martin Weinberg <weinberg@osprey.astro.umass.edu>
To: pgsql-general@postgreSQL.org
Subject: Memory exhausted in AllocSetAlloc()

In dumping some tables to tape, my "copy" died with the
message:

FATAL 1: Memory exhausted in AllocSetAlloc()
PQendcopy: resetting connection

This is 6.5.2 on Linux. The tables are about 15Gb.
Any of the gurus have any suggestions on what to do?
Or how to diagnose the underlying problem? I'm running
PGDEBUG=2 but there are no additional clues . . .

Thanks,

--Martin

===========================================================================

Martin Weinberg Phone: (413) 545-3821
Dept. of Physics and Astronomy FAX: (413) 545-2117/0648
530 Graduate Research Tower weinberg@astro.umass.edu
University of Massachusetts http://www.astro.umass.edu/~weinberg/
Amherst, MA 01003-4525

From bouncefilter Sat Sep 25 23:59:38 1999
Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA92077
for <pgsql-general@postgresql.org>;
Sat, 25 Sep 1999 23:59:00 -0400 (EDT) (envelope-from er@sai.msu.su)
Received: (from er@localhost) by ra.sai.msu.su (8.9.1/8.9.1) id HAA27643
for pgsql-general@postgresql.org; Sun, 26 Sep 1999 07:58:56 +0400 (MSD)
Date: Sun, 26 Sep 1999 07:58:56 +0400 (MSD)
From: "E.Rodichev" <er@sai.msu.su>
Message-Id: <199909260358.HAA27643@ra.sai.msu.su>
To: pgsql-general@postgresql.org
Subject: PL/pgSQL - args passing

Is it possible to pass the NULL value to PL/pgSQL function? More precisely,
I have a function like

CREATE FUNCTION test (text,int4) RETURNS int4 AS '
Begin
...
End;
' LANGUAGE 'plpgsql';

and typical call is

select test('Word',1);

which works fine. But sometimes I need to call this function with
arguments like

select test(NULL,1); or
select test('Word',NULL);

Now such calls lead to
ERROR: typeidTypeRelid: Invalid type - oid = 0

Any ideas?
_________________________________________________________________________
Evgeny Rodichev Sternberg Astronomical Institute
System/Net Admin Moscow State University
email: er@sai.msu.su
Phone: 007 (095) 939 2383
Fax: 007 (095) 932 8841 http://www.sai.msu.su/~er

From bouncefilter Sun Sep 26 01:55:40 1999
Received: from smtp-out.netactive.net (smtp-out.netactive.net [196.22.160.30])
by hub.org (8.9.3/8.9.3) with SMTP id BAA00287
for <pgsql-general@hub.org>; Sun, 26 Sep 1999 01:54:54 -0400 (EDT)
(envelope-from ahiggs@jpj.co.za)
Received: (qmail 29909 invoked from network); 26 Sep 1999 05:52:28 -0000
Received: from pepm31-9.netactive.co.za (HELO andy) (root@196.22.180.9)
by smtp-out.netactive.net with SMTP; 26 Sep 1999 05:52:28 -0000
Message-ID: <000901bf07e3$bc46f240$1e03a8c0@andy>
From: "Andrew Higgs" <ahiggs@jpj.co.za>
To: "pgsql-general" <pgsql-general@hub.org>
Subject: Cannot connect.
Date: Sun, 26 Sep 1999 07:55:27 +0200
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

Hi all,

I have written a program in Delphi which connects to my postgres(6.5.1) box
using ODBC. For some or other reason for the past week I have not been able
to connect. It says it cannot connect to socket. On the postgres box I have
no hassels connecting to any of my databases. It is just the remote machines
which cannot connect.

Any advice would be greatly appreciated.

Kind regards
Andrew Higgs

From bouncefilter Sun Sep 26 08:30:44 1999
Received: from olorin.minfo (root@olorin.net.bydg.pl [195.117.100.41])
by hub.org (8.9.3/8.9.3) with ESMTP id IAA18763
for <pgsql-general@postgresql.org>;
Sun, 26 Sep 1999 08:30:35 -0400 (EDT)
(envelope-from mak@minfo.com.pl)
Received: from minfo.com.pl (m00.minfo [192.168.100.100])
by olorin.minfo (8.9.3/8.9.3) with ESMTP id OAA01710
for <pgsql-general@postgresql.org>; Sun, 26 Sep 1999 14:31:33 +0200
Message-ID: <37EE1219.56830D15@minfo.com.pl>
Date: Sun, 26 Sep 1999 14:31:21 +0200
From: "Michal A. Kowalski" <mak@minfo.com.pl>
Organization: M-info, http://www.minfo.com.pl
X-Mailer: Mozilla 4.61 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Expiration date.
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

Hi,

what is the easiest way to check if record in database has expired? I have
records with field CREATED - filled with datetime('now'::abstime) function -
and with field EXPIRE - filled with number of days for which this record
remain valid. Is there any way to add days in EXPIRE to CREATED in proper way
and chceck if this particular record should be deleted using functions
embedded in PgSQL or maybe I should do this outside Pg, maybe in Perl?

MAK.
___________________________________________________________________________
-- Michal A. Kowalski -- http://www.minfo.com.pl -- mak@minfo.com.pl --

From bouncefilter Sun Sep 26 15:31:54 1999
Received: from hotmail.com (f208.law3.hotmail.com [209.185.241.208])
by hub.org (8.9.3/8.9.3) with SMTP id PAA50097
for <pgsql-general@postgreSQL.org>;
Sun, 26 Sep 1999 15:31:29 -0400 (EDT)
(envelope-from solsql@hotmail.com)
Received: (qmail 73273 invoked by uid 0); 26 Sep 1999 19:30:58 -0000
Message-ID: <19990926193058.73272.qmail@hotmail.com>
Received: from 128.163.224.179 by www.hotmail.com with HTTP;
Sun, 26 Sep 1999 12:30:57 PDT
X-Originating-IP: [128.163.224.179]
From: "Mukund Chandak" <solsql@hotmail.com>
To: pgsql-general@postgreSQL.org
Cc: mukundmc@hotmail.com
Subject: Pgsql tutorial
Date: Sun, 26 Sep 1999 15:30:57 EDT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

hi!!

I am starting a new project involving Perl/CGI and PostgreSQL.

I am new to Pgsql and would like to know if there are any good tutorials on
Pgsql and Perl.

thanks

Mukund

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Sun Sep 26 13:05:47 1999
Received: from ganesh.paneris.org (IDENT:root@paneris.org [194.128.98.74])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA43496
for <pgsql-general@postgreSQL.org>;
Sun, 26 Sep 1999 13:05:07 -0400 (EDT) (envelope-from tim@hoop.co.uk)
Received: from noonoo (flav1.dircon.co.uk [194.112.47.31])
by ganesh.paneris.org (8.8.7/8.8.7) with SMTP id SAA11824
for <pgsql-general@postgreSQL.org>; Sun, 26 Sep 1999 18:02:21 +0100
Message-ID: <005401bf0841$92130640$0501a8c0@noonoo>
From: "Tim Joyce" <tim@hoop.co.uk>
To: <pgsql-general@postgreSQL.org>
References: <199909260358.HAA27643@ra.sai.msu.su>
Subject: FATAL 1: Memory exhausted in AllocSetAlloc()
Date: Sun, 26 Sep 1999 18:06:41 +0100
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

I am getting

FATAL 1: Memory exhausted in AllocSetAlloc()

when I vacuum;

Red Hat Linux release 5.2 (Apollo) Kernel 2.0.36 on an i686
postgresql-6.5
256Mb Memory

What do I need to set to get round this? Is it simply a question of more
memory.

Cheers

Tim Joyce
Chief Enthusiast
tim@hoop.co.uk
HOOP Ltd
http://www.hoop.co.uk
01202 251 816

HOOP is proud to be a member of the Paneris community (www.paneris.co.uk)

From bouncefilter Sun Sep 26 14:01:48 1999
Received: from ganesh.paneris.org (IDENT:root@paneris.org [194.128.98.74])
by hub.org (8.9.3/8.9.3) with ESMTP id OAA45475
for <pgsql-general@postgreSQL.org>;
Sun, 26 Sep 1999 14:01:33 -0400 (EDT) (envelope-from tim@hoop.co.uk)
Received: from noonoo (flav1.dircon.co.uk [194.112.47.31])
by ganesh.paneris.org (8.8.7/8.8.7) with SMTP id SAA11861
for <pgsql-general@postgreSQL.org>; Sun, 26 Sep 1999 18:59:01 +0100
Message-ID: <008301bf0849$7d099cc0$0501a8c0@noonoo>
From: "Tim Joyce" <tim@hoop.co.uk>
To: <pgsql-general@postgreSQL.org>
References: <199909260358.HAA27643@ra.sai.msu.su>
<005401bf0841$92130640$0501a8c0@noonoo>
Subject: Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc()
Date: Sun, 26 Sep 1999 19:03:34 +0100
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

sorry, forgot to add:

I have just deleted 1,200,000 records

timj

I am getting

FATAL 1: Memory exhausted in AllocSetAlloc()

when I vacuum;

Red Hat Linux release 5.2 (Apollo) Kernel 2.0.36 on an i686
postgresql-6.5
256Mb Memory

What do I need to set to get round this? Is it simply a question of more
memory.

From bouncefilter Sun Sep 26 16:55:55 1999
Received: from osprey.astro.umass.edu (root@osprey.astro.umass.edu
[128.119.51.182]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA55492
for <pgsql-general@postgreSQL.org>;
Sun, 26 Sep 1999 16:54:57 -0400 (EDT)
(envelope-from weinberg@osprey.astro.umass.edu)
Received: from osprey.astro.umass.edu (weinberg@localhost [127.0.0.1])
by osprey.astro.umass.edu (8.9.3/8.9.3/Debian/GNU) with ESMTP id
QAA18092; Sun, 26 Sep 1999 16:54:42 -0400
Message-Id: <199909262054.QAA18092@osprey.astro.umass.edu>
To: "Tim Joyce" <tim@hoop.co.uk>
Cc: pgsql-general@postgreSQL.org, Oliver.Elphick@lfix.co.uk
Subject: Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc()
In-reply-to: Your message of "Sun, 26 Sep 1999 18:06:41 BST."
<005401bf0841$92130640$0501a8c0@noonoo>
Date: Sun, 26 Sep 1999 16:54:42 -0300
From: Martin Weinberg <weinberg@osprey.astro.umass.edu>

Tim,

I've been trying to get around the same problem for the last
week but haven't been able to trace it down. Here's what
I found so far:

1) I have had the "Memory exhausted" in both vacuum and copy.
It is not obviously reproducible; that is, if I repeat
the same command it may not fail, or fail in a different
place

2) The AllocSet...() routines are in src//backend/utils/mmgr/aset.c.
They are wrappers around malloc.

3) My machine has 256Mb and the postgres user has unlimited memory
limit. The backend does not appear to be growing at all when
the condition occurs.

4) This seems to rear it's head for large databases only. The
tables I am trying to vacuum and copy have about 50 million
records each. Small databases seem to be fine.

All of this leads me to suspect a memory bug somewhere.

I have set PGBUFFERS to 3500 to maximize use of available shmem. The
backend does not seem to grow beyond the resulting ~30Mb. I do not
know if this is related.

I am running 6.5.1 (and have tried 6.5.2) with Linux 2.2.10
under the Debian 2.1 (slink) distribution. I compiled
Oliver Elphick's 6.5.1 source package against slink which up
to floating point issues, passes the regression tests
successfully. Perhaps Oliver can tell us if this might have
introduced a problem?

Maybe a pgsql hacker/guru has a clue? I'm not sufficiently well-
versed with the guts to know what else to do.

--Martin

===========================================================================

From bouncefilter Sun Sep 26 20:22:52 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id UAA89460
for <pgsql-general@postgreSQL.org>;
Sun, 26 Sep 1999 20:22:45 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id UAA26280;
Sun, 26 Sep 1999 20:22:00 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909270022.UAA26280@candle.pha.pa.us>
Subject: Re: [GENERAL] Any books available commercially?
In-Reply-To: <199909242150.PAA20909@ez0.ezlink.com> from Richard Ryan at "Sep
24, 1999 03:50:54 pm"
To: ryanr@ezlink.com
Date: Sun, 26 Sep 1999 20:22:00 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hi,

Does anyone know of any good books on PostgreSQL that I can find
in bookstores (or order)?

We are working with some publishers on it, but have not started yet.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Sun Sep 26 20:33:57 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id UAA93894
for <pgsql-general@postgreSQL.org>;
Sun, 26 Sep 1999 20:33:56 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id UAA26937;
Sun, 26 Sep 1999 20:33:01 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909270033.UAA26937@candle.pha.pa.us>
Subject: Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc()
In-Reply-To: <008301bf0849$7d099cc0$0501a8c0@noonoo> from Tim Joyce at "Sep
26,
1999 07:03:34 pm"
To: Tim Joyce <tim@hoop.co.uk>
Date: Sun, 26 Sep 1999 20:33:01 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

[Charset iso-8859-1 unsupported, filtering to ASCII...]

sorry, forgot to add:

I have just deleted 1,200,000 records

It will be faster to dump out the table and reload.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Sun Sep 26 20:45:57 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id UAA99993
for <pgsql-hackers@postgreSQL.org>;
Sun, 26 Sep 1999 20:45:51 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id UAA27257;
Sun, 26 Sep 1999 20:44:42 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909270044.UAA27257@candle.pha.pa.us>
Subject: Re: [HACKERS] Re: [GENERAL] Update of bitmask type
In-Reply-To: <37EB88E0.24A45661@alumni.caltech.edu> from Thomas Lockhart at
"Sep 24, 1999 02:21:20 pm"
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Date: Sun, 26 Sep 1999 20:44:42 -0400 (EDT)
CC: Adriaan Joubert <a.joubert@albourne.com>, Hannu Krosing <hannu@tm.ee>,
Postgresql <pgsql-hackers@postgreSQL.org>
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

attypmod has been modified recently to contain two fields (each of 16
bits) in a backward-compatible way. It can hold the size *and*
precision of the numeric data types, and presumably should be used in
a similar manner for your bit type.

You can use a union to split atttypmod up into two 8-bit fields and on
16-bit field. Let me know if you need help.

The problem is that you need another field which contains a length in
bit units. Assuming that the second field in attypmod can't be used
for this purpose, then istm that you will want to add a field to the
data type itself. The character types have:

length - total size of data, in bytes (4 bytes)
data - body

and you might have

length - total size of data, in bytes (4 bytes)
blen - total size of data, in bits (4 bytes)
data - body

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

************

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 01:39:56 1999
Received: from cwb.pacific.net.hk (cwb.pacific.net.hk [202.14.67.92])
by hub.org (8.9.3/8.9.3) with ESMTP id BAA15343
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 01:39:02 -0400 (EDT)
(envelope-from s_kwan@HK.Super.NET)
Received: from tsingyi.pacific.net.hk (tsingyi.pacific.net.hk [202.14.67.240])
by cwb.pacific.net.hk with ESMTP
id NAA23400; Mon, 27 Sep 1999 13:38:56 +0800 (HKT)
Received: from ntser1 (ppp171.dyn9.pacific.net.hk [202.64.9.171])
by tsingyi.pacific.net.hk with SMTP
id NAA18595; Mon, 27 Sep 1999 13:38:55 +0800 (HKT)
Message-ID: <028f01bf08aa$97206b50$110540ca@hk.super.net>
From: "Simon Kwan" <s_kwan@gps.com.hk>
To: <pgsql-general@postgreSQL.org>, <mysql@lists.mysql.com>
References: <199909262054.QAA18092@osprey.astro.umass.edu>
Subject: Help: Choosing PostgreSQL vs MySQL
Date: Mon, 27 Sep 1999 13:38:54 +0800
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

Hi greeting,
I am new to Linux.
Appreciate advise and comment on choosing between PosytgreSQL vs. MySQL.
Both to be run under Linux. How does these two database compare with MS SQL
7.0?

There are two options to configure the data base,
a) The data base will have a few million rows, each row is about 100 bytes.
One of the column (field) will be a pathname (filename) to index to an
external files for storing images. Each image belongs to a particular row
and image is 3 to 20 kb (variable size jepg files).

b) same as the about, but the image will be stored as one filed in the data
base. In this case, the data base will be much larger and wonder if it is
size is okay (speed, capacity, etc...)

Many thansk in advance. Appreciate email reply also.

Simon

From bouncefilter Mon Sep 27 01:58:56 1999
Received: from cwb.pacific.net.hk (cwb.pacific.net.hk [202.14.67.92])
by hub.org (8.9.3/8.9.3) with ESMTP id BAA16056
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 01:58:12 -0400 (EDT)
(envelope-from s_kwan@HK.Super.NET)
Received: from tsingyi.pacific.net.hk (tsingyi.pacific.net.hk [202.14.67.240])
by cwb.pacific.net.hk with ESMTP
id NAA25562 for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 13:58:10 +0800 (HKT)
Received: from ntser1 (ppp171.dyn9.pacific.net.hk [202.64.9.171])
by tsingyi.pacific.net.hk with SMTP
id NAA22298 for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 13:58:09 +0800 (HKT)
Message-ID: <02ad01bf08ad$46ea0710$110540ca@hk.super.net>
From: "Simon Kwan" <s_kwan@gps.com.hk>
Cc: <pgsql-general@postgreSQL.org>
References: <199909270022.UAA26280@candle.pha.pa.us>
Subject: Help: Choose PostgreSQL vs MySQL
Date: Mon, 27 Sep 1999 13:58:09 +0800
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

Hi greeting,
I am new to Linux.
Appreciate advise and comment on choosing between PosytgreSQL vs. MySQL.
Both to be run under Linux. How does these two database compare with MS SQL
7.0?

b) same as the about, but the image will be stored as one filed in the data
base. In this case, the data base will be much larger and wonder if it is
size is okay (speed, capacity, etc...)

Many thansk in advance. Appreciate email reply also.

Simon

From bouncefilter Mon Sep 27 02:47:57 1999
Received: from rabies.toodarkpark.org (caffeine@rabies.toodarkpark.org
[207.176.94.148]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA17851
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 02:47:12 -0400 (EDT)
(envelope-from caffeine@toodarkpark.org)
Received: from localhost (caffeine@localhost)
by rabies.toodarkpark.org (8.8.8/8.8.8/Debian/GNU) with SMTP id
CAA22070; Mon, 27 Sep 1999 02:42:00 -0400
Date: Mon, 27 Sep 1999 06:42:00 +0000 (GMT)
From: Howie <caffeine@toodarkpark.org>
To: "Michal A. Kowalski" <mak@minfo.com.pl>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Expiration date.
In-Reply-To: <37EE1219.56830D15@minfo.com.pl>
Message-ID: <Pine.LNX.3.96.990927062538.29855N-100000@rabies.toodarkpark.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Sun, 26 Sep 1999, Michal A. Kowalski wrote:

Hi,

what is the easiest way to check if record in database has expired? I have
records with field CREATED - filled with datetime('now'::abstime) function -
and with field EXPIRE - filled with number of days for which this record
remain valid. Is there any way to add days in EXPIRE to CREATED in proper way
and chceck if this particular record should be deleted using functions
embedded in PgSQL or maybe I should do this outside Pg, maybe in Perl?

caffeine=> create table tmp ( expdays int4 not null, createdate datetime
not null);
...
caffeine=> select * from tmp;

caffeine=> select createdate,expdays, (createdate + (expdays ||
'days')::timespan)::datetime as expire from tmp;

caffeine=> select * from tmp where (createdate + (expdays || 'days')::timespan)::datetime < NOW ();

expdays|createdate
-------+----------------------------
30|Sat Aug 28 02:34:49 1999 EST
30|Thu Jul 29 02:34:52 1999 EST
(2 rows)

like that ?

---
Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
"Just think how much deeper the ocean would be if sponges didn't live there."

From bouncefilter Mon Sep 27 12:27:04 1999
Received: from hotmail.com (law-f142.hotmail.com [209.185.131.205])
by hub.org (8.9.3/8.9.3) with SMTP id MAA82460
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:26:49 -0400 (EDT)
(envelope-from amycq@hotmail.com)
Received: (qmail 62238 invoked by uid 0); 27 Sep 1999 16:26:17 -0000
Message-ID: <19990927162617.62237.qmail@hotmail.com>
Received: from 216.61.142.192 by www.hotmail.com with HTTP;
Mon, 27 Sep 1999 09:26:17 PDT
X-Originating-IP: [216.61.142.192]
From: "amy cheng" <amycq@hotmail.com>
To: pgsql-general@postgreSQL.org
Subject: ERROR: nodeRead: Bad type 0
Date: Mon, 27 Sep 1999 09:26:17 PDT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

hello, everybody,

I got an emergency: I can not use \d any more, also, I can not
use pg_dump, vacuum. Error messages are similar:

demo=> \d
ERROR: nodeRead: Bad type 0

what is this? the db is still working.

thanks in advance !!!!!!

amy

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Mon Sep 27 13:10:04 1999
Received: from hotmail.com (law-f227.hotmail.com [209.185.130.165])
by hub.org (8.9.3/8.9.3) with SMTP id NAA92301
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 13:09:27 -0400 (EDT)
(envelope-from amycq@hotmail.com)
Received: (qmail 22643 invoked by uid 0); 27 Sep 1999 17:08:56 -0000
Message-ID: <19990927170856.22642.qmail@hotmail.com>
Received: from 216.61.142.192 by www.hotmail.com with HTTP;
Mon, 27 Sep 1999 10:08:56 PDT
X-Originating-IP: [216.61.142.192]
From: "amy cheng" <amycq@hotmail.com>
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0
Date: Mon, 27 Sep 1999 10:08:56 PDT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

the problem is that I can not even dump!
also, our system admin just upgrade the OS (linux5.x -> 6.x).

thanks

amy

From: Aaron Holtz <aholtz@bright.net>
To: amy cheng <amycq@hotmail.com>
Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0
Date: Mon, 27 Sep 1999 12:55:00 -0400 (EDT)

Been there - sadly nothing I ever did got it fixed. I ended up dumping
the db and reloading it fresh. You might try deleting and rebuilding any
indexes that you have as that might be where the problem is at. This
occurred to me when I tried to upgrade from one version to another (just a
minor revision upgrade to boot....)

--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email: aholtz@bright.net
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------

On Sep 27, amy cheng molded the electrons to say....

hello, everybody,

I got an emergency: I can not use \d any more, also, I can not
use pg_dump, vacuum. Error messages are similar:

demo=> \d
ERROR: nodeRead: Bad type 0

what is this? the db is still working.

thanks in advance !!!!!!

amy

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

************

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Tue Sep 28 07:06:28 1999
Received: from vpcit.ru (qmailr@dialup.vpcit.ru [195.38.52.246])
by hub.org (8.9.3/8.9.3) with SMTP id HAA84634
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 07:06:10 -0400 (EDT) (envelope-from yura@vpcit.ru)
Received: (qmail 3409 invoked from network); 28 Sep 1999 11:05:50 -0000
Received: from gercon.vpcit.ru (HELO vpcit.ru) (195.38.52.226)
by dialup.vpcit.ru with SMTP; 28 Sep 1999 11:05:50 -0000
Message-ID: <37EF4774.753680F6@vpcit.ru>
Date: Mon, 27 Sep 1999 16:31:16 +0600
From: Yury Don <yura@vpcit.ru>
X-Mailer: Mozilla 4.61 [en] (Win98; I)
X-Accept-Language: ru,en
MIME-Version: 1.0
To: pgsql-general@postgreSQL.org
Subject: More than one transaction at the same time
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit

Hi All!

Can I start 2 or more transactions simultaneously?
Task is in the following: I am startig transaction with the "begin",
then declare a cursor. Then I need to start another transaction in order
to do some things, but I don't want to close first transaction because
later I need to fetch frome created cursor.
Or I understand something wrongly?

Sincerely yours, Yury.
don.web-page.net, ICQ 11831432

From bouncefilter Wed Sep 29 05:21:28 1999
Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id FAA31210
for pgsql-general@postgresql.org; Wed, 29 Sep 1999 05:20:53 -0400 (EDT)
(envelope-from news)
X-Authentication-Warning: hub.org: news set sender to <news> using -f
From: Olivier PRENANT <ohp@pyrenet.fr>
X-Newsgroups: comp.databases.postgresql.general
Subject: Crypt a column
Date: Mon, 27 Sep 1999 13:16:54 +0200
Organization: PYRENET
Lines: 19
Message-ID: <37EF5226.9FC5454D@pyrenet.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: floppy.pyrenet.fr 938431015 4456 194.250.190.1 (27 Sep 1999 11:16:55
GMT)
X-Complaints-To: newsmaster@pyrenet.fr
X-Mailer: Mozilla 4.08 [fr] (X11; I; UnixWare 5 i386)
To: pgsql-general@postgreSQL.org

Hi,

Hope it's the right group to post to.

I'd like to be able to have a crypt function in postgresql to be able to
write such statement:

insert into ... value ('userid',crypt('password');

Has anyone witten such function, is it possible ?

TIA,
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

From bouncefilter Mon Sep 27 08:39:10 1999
Received: from queluz.economatica.com.br (mail@queluz.economatica.com.br
[200.231.195.36]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA48899
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 08:38:31 -0400 (EDT)
(envelope-from oexel@economatica.com.br)
Received: from oexel by queluz.economatica.com.br with local (Exim 2.05 #1
(Debian)) id 11Va3U-0003Ow-00; Mon, 27 Sep 1999 09:38:56 -0300
Date: Mon, 27 Sep 1999 09:38:56 -0300
From: Otavio Exel <oexel@economatica.com.br>
To: pgsql-general@postgresql.org
Subject: libpq on win32 & postgresql on linux
Message-ID: <19990927093856.A10665@economatica.com.br>
Reply-To: oexel@economatica.com.br
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.95.3i
Organization: Economatica Ltda

hello list,

note: postgres-newbie here!

I have:
- a linux box with postgresql 6.3.2 installed;
- a win95 box with postgresql-win32-client-6.4.2 (from
ftp://ftp.postgresql.org) installed;

the win32 client can't connect due to a backward-incompatible change in
the protocol; AFAIK I have 3 choices:

1. upgrade the postgresql on the linux box;
2. downgrade the win32 client on the win32 box;
3. use odbc;

but I'm facing the following problems when choosing among the 3 above
mentioned options:

1. the stable release of debian comes with 6.3.2 and I don't feel
confortable enough to compile my own installation; I tried to install
the package for the unstable version but it is not compatible;

2. the only port of win32-client available from ftp.postgresql.org is
6.4.2; is there a postgresql-win32-client based of 6.3.2 somewhere?

3. I've never used odbc and I think of it as an unnecessary layer of
complexity for my needs; am I wrong?

would someone please comment on my comments?

TIA for any help!

--
Otavio Exel /<\oo/>\ oexel@economatica.com.br

From bouncefilter Mon Sep 27 09:17:01 1999
Received: from office.knowledge.com (office.knowledge.com [195.40.167.196])
by hub.org (8.9.3/8.9.3) with ESMTP id JAA52538
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 09:16:15 -0400 (EDT)
(envelope-from Mark.Jewiss@knowledge.com)
Received: from mark (helo=localhost)
by office.knowledge.com with local-esmtp (Exim 2.10 #1)
id 11Vad5-0005GB-00
for pgsql-general@postgresql.org; Mon, 27 Sep 1999 14:15:43 +0100
Date: Mon, 27 Sep 1999 14:15:43 +0100 (BST)
From: Mark Jewiss <Mark.Jewiss@knowledge.com>
To: pgsql-general@postgresql.org
Subject: \d <table> command
Message-ID: <Pine.BSO.4.10.9909271412510.4204-100000@office.knowledge.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello,

I want to be able to build up information about the different tables held
in a database for a small diagnostic tool that I'm writing.

I need to see the name of each column in the table, the column data type
and size, and if nulls are allowed - essentially what is produced by the
'\d <tablename>' command.

Does anyone know the SQL query to use on the system tables to produce that
result? I've started to go through them now, and was expecting to find
something along the lines of 'pg_columns', but no such luck. :(

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com

From bouncefilter Mon Sep 27 10:20:02 1999
Received: from titanium.noida.hclt.com (IDENT:root@[204.160.248.252])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA63210
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 10:19:36 -0400 (EDT)
(envelope-from imreet@titanium.noida.hclt.com)
Received: from japtest (Free [204.160.252.66] (may be forged))
by titanium.noida.hclt.com (8.8.7/8.8.7) with SMTP id SAA16606
for <pgsql-general@postgresql.org.>; Mon, 27 Sep 1999 18:35:08 +0530
Message-ID: <02cf01bf08eb$7165d8a0$42fca0cc@japtest.noida.hclt.com>
From: "Imreet Singh" <imreet@titanium.noida.hclt.com>
To: "Post Gre" <pgsql-general@postgresql.org>
Subject: Trouble with Innstalling PostGreSQL 6.5.2 on Win NT
Date: Mon, 27 Sep 1999 18:53:09 +0530
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Hi All,
I have problem in installing Post Gre SQL 6.5.2 on Windows NT. As a
prerequiste (as mentioned in readme.nt in doc directory) I tried to install
Cygwin32 package first but could not do it because it contains lot of unix
system commands
Can anybody please help me with this?

Regards,
Imreet

From bouncefilter Mon Sep 27 09:42:02 1999
Received: from mail.eskimo.com (root@mail.eskimo.com [204.122.16.4])
by hub.org (8.9.3/8.9.3) with ESMTP id JAA55132
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 09:41:13 -0400 (EDT)
(envelope-from simon@eskimo.com)
Received: from dragon (5086000101.011.popsite.net [192.216.201.229])
by mail.eskimo.com (8.9.1a/8.8.8) with SMTP id GAA08714;
Mon, 27 Sep 1999 06:40:25 -0700 (PDT)
Date: Mon, 27 Sep 1999 09:41:19 -0400 (EDT)
From: Simon Drabble <simon@eskimo.com>
X-Sender: simon@dragon
To: Mark Jewiss <Mark.Jewiss@knowledge.com>
cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] \d <table> command
In-Reply-To: <Pine.BSO.4.10.9909271412510.4204-100000@office.knowledge.com>
Message-ID: <Pine.LNX.3.96.990927093752.9587B-100000@dragon>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Mon, 27 Sep 1999, Mark Jewiss wrote:

Hello,

I want to be able to build up information about the different tables held
in a database for a small diagnostic tool that I'm writing.

I need to see the name of each column in the table, the column data type
and size, and if nulls are allowed - essentially what is produced by the
'\d <tablename>' command.

Does anyone know the SQL query to use on the system tables to produce that
result? I've started to go through them now, and was expecting to find
something along the lines of 'pg_columns', but no such luck. :(

Regards,

Mark.
--
Mark Jewiss

Dunno the specific selects to get what you want, but you can investigate the
standard postgres views:

select * from pg_views where viewname like 'pg_%';

Might get you what you're after.

I was doing something similar (creating my own list of tables/ columns)
recently - the various selects are in the source, and quite well documented.

Simon.

--
"Aah - a voice of clue in a wilderness of luse."

Simon Drabble It's like karma for your brain.
simon@eskimo.com

From bouncefilter Mon Sep 27 01:50:57 1999
Received: from cwb.pacific.net.hk (cwb.pacific.net.hk [202.14.67.92])
by hub.org (8.9.3/8.9.3) with ESMTP id BAA15827
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 01:50:19 -0400 (EDT)
(envelope-from s_kwan@HK.Super.NET)
Received: from tsingyi.pacific.net.hk (tsingyi.pacific.net.hk [202.14.67.240])
by cwb.pacific.net.hk with ESMTP
id NAA24664 for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 13:50:18 +0800 (HKT)
Received: from ppp171.dyn9.pacific.net.hk (ppp171.dyn9.pacific.net.hk
[202.64.9.171]) by tsingyi.pacific.net.hk with SMTP
id NAA20846 for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 13:50:17 +0800 (HKT)
Received: by ppp171.dyn9.pacific.net.hk with Microsoft Mail
id <01BF08EF.3AD2E950@ppp171.dyn9.pacific.net.hk>;
Mon, 27 Sep 1999 13:50:16 -0000
Message-ID: <01BF08EF.3AD2E950@ppp171.dyn9.pacific.net.hk>
From: Simon Kwan <s_kwan@gps.com.hk>
To: "'pgsql-general@postgresql.org'" <pgsql-general@postgresql.org>
Subject: Help: Choose between PostgreSQL vs MySQL
Date: Mon, 27 Sep 1999 13:50:13 -0000
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi greeting,
I am new to Linux.
Appreciate advise and comment on choosing between PosytgreSQL vs. MySQL.
Both to be run under Linux. How does these two database compare with MS SQL
7.0?

b) same as the about, but the image will be stored as one filed in the data
base. In this case, the data base will be much larger and wonder if it is
size is okay (speed, capacity, etc...)

Many thansk in advance. Appreciate email reply also.

Simon

From bouncefilter Mon Sep 27 11:16:03 1999
Received: from nefertiti.pasteur.fr (nefertiti.pasteur.fr [157.99.64.20])
by hub.org (8.9.3/8.9.3) with ESMTP id LAA72240
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 11:15:53 -0400 (EDT)
(envelope-from bortz@pasteur.fr)
Received: from ezili.sis.pasteur.fr (root@ezili.sis.pasteur.fr [157.99.60.56])
by nefertiti.pasteur.fr (8.9.3/8.9.3) with ESMTP id RAA31692;
Mon, 27 Sep 1999 17:15:52 +0200 (CEST)
Received: from ezili.sis.pasteur.fr (bortz@localhost [127.0.0.1])
by ezili.sis.pasteur.fr (8.9.3/8.9.3/Debian/GNU) with ESMTP id RAA13605;
Mon, 27 Sep 1999 17:15:52 +0200
Message-Id: <199909271515.RAA13605@ezili.sis.pasteur.fr>
X-Mailer: exmh version 2.0.2 2/24/98 (debian)
From: Stephane Bortzmeyer <bortzmeyer@pasteur.fr>
To: Marc Blanc <interlud@wanadoo.fr>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] source code sgml
In-reply-to: <199909241031.MAA01171@mbv.interlud.com>
(Marc Blanc <interlud@wanadoo.fr>'s message of
Fri, 24 Sep 1999 12:31:27 +0200)
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Mon, 27 Sep 1999 17:15:51 +0200
Sender: bortz@pasteur.fr

On Friday 24 September 1999, at 12 h 31, the keyboard of Marc Blanc
<interlud@wanadoo.fr> wrote:

is it possible to find the source code .sgml of the Tutorial and
User's guides PostgreSQL ?

It is at least reachable by anonymous CVS in the doc/src/sgml directory.

http://www.postgresql.org/docs/programmer/cvs8167.htm

From bouncefilter Mon Sep 27 11:26:03 1999
Received: from ms11.hinet.net (root@ms11.hinet.net [168.95.4.11])
by hub.org (8.9.3/8.9.3) with ESMTP id LAA73446
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 11:25:41 -0400 (EDT)
(envelope-from kevlo@hello.com.tw)
Received: from hello.com.tw (h15.s19.ts30.hinet.net [163.30.19.15])
by ms11.hinet.net (8.8.8/8.8.8) with ESMTP id XAA07897;
Mon, 27 Sep 1999 23:23:45 +0800 (CST)
Sender: kevin@ms11.hinet.net
Message-ID: <37EF8D2B.DA991489@hello.com.tw>
Date: Mon, 27 Sep 1999 23:28:43 +0800
From: Kevin Lo <kevlo@hello.com.tw>
X-Mailer: Mozilla 4.61 [en] (X11; I; FreeBSD 3.2-RELEASE i386)
X-Accept-Language: en
MIME-Version: 1.0
To: Imreet Singh <imreet@titanium.noida.hclt.com>
CC: Post Gre <pgsql-general@postgreSQL.org>
Subject: Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT
References: <02cf01bf08eb$7165d8a0$42fca0cc@japtest.noida.hclt.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Imreet Singh wrote:

Hi All,

Hi, Imreet,

I have problem in installing Post Gre SQL 6.5.2 on Windows NT. As a
prerequiste (as mentioned in readme.nt in doc directory) I tried to install
Cygwin32 package first but could not do it because it contains lot of unix
system commands
Can anybody please help me with this?

I have a web page about installing on WinNT, see:

http://members.tripod.com/~kevlo/postgres/portNT.html

Regards,
Imreet

************

Hope this helps,

--
Kevin Lo Wahoo International Enterprise Co.,Ltd.
kevlo@wahoo.com.tw http://www.wahoo.com.tw

From bouncefilter Mon Sep 27 12:06:14 1999
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA78722
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:05:51 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id LAA16573;
Mon, 27 Sep 1999 11:45:07 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271545.LAA16573@candle.pha.pa.us>
Subject: Re: [GENERAL] \d <table> command
In-Reply-To: <Pine.BSO.4.10.9909271412510.4204-100000@office.knowledge.com>
from Mark Jewiss at "Sep 27, 1999 02:15:43 pm"
To: Mark Jewiss <Mark.Jewiss@knowledge.com>
Date: Mon, 27 Sep 1999 11:45:07 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

See FAQ. It is in psql.c.

Hello,

I want to be able to build up information about the different tables held
in a database for a small diagnostic tool that I'm writing.

I need to see the name of each column in the table, the column data type
and size, and if nulls are allowed - essentially what is produced by the
'\d <tablename>' command.

Does anyone know the SQL query to use on the system tables to produce that
result? I've started to go through them now, and was expecting to find
something along the lines of 'pg_columns', but no such luck. :(

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com

************

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 12:08:03 1999
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA78936
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:07:28 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id LAA16633;
Mon, 27 Sep 1999 11:45:51 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271545.LAA16633@candle.pha.pa.us>
Subject: Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT
In-Reply-To: <02cf01bf08eb$7165d8a0$42fca0cc@japtest.noida.hclt.com> from
Imreet Singh at "Sep 27, 1999 06:53:09 pm"
To: Imreet Singh <imreet@titanium.noida.hclt.com>
Date: Mon, 27 Sep 1999 11:45:51 -0400 (EDT)
CC: Post Gre <pgsql-general@postgreSQL.org>
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Please see NT Readme on www.postgresql.org web site.

[Charset iso-2022-jp unsupported, skipping...]

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 11:58:03 1999
Received: from propertykey.com (IDENT:root@propertykey.com [206.196.37.193])
by hub.org (8.9.3/8.9.3) with ESMTP id LAA77852
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 11:57:37 -0400 (EDT)
(envelope-from jeff@remapcorp.com)
Received: from remapcorp.com (gotojail.propertykey.com [206.196.37.197])
by propertykey.com (8.9.3/8.9.3) with ESMTP id KAA30448;
Mon, 27 Sep 1999 10:57:20 -0500
Message-ID: <37EF93E0.D82352E0@remapcorp.com>
Date: Mon, 27 Sep 1999 10:57:20 -0500
From: Jeff Hoffmann <jeff@remapcorp.com>
Organization: PropertyKey.com
X-Mailer: Mozilla 4.61 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Kevin Lo <kevlo@hello.com.tw>
CC: Post Gre <pgsql-general@postgreSQL.org>
Subject: Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT
References: <02cf01bf08eb$7165d8a0$42fca0cc@japtest.noida.hclt.com>
<37EF8D2B.DA991489@hello.com.tw>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

on a related note, i've been thinking about trying out postgres on NT,
but i've been hesitant to do so because it seems to be a "just because i
can" port -- maybe not as stable or fast as on a unix system, but neat
to have. are people actually using it for serious (ie, it needs to be
reliable but not necessarily mission critical) work?

jeff

From bouncefilter Mon Sep 27 12:09:03 1999
Received: from innocence.interface-business.de
(innocence.interface-business.de [193.101.57.202])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA79031
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:08:11 -0400 (EDT)
(envelope-from gerald@mauz.interface-business.de)
Received: from mauz.interface-business.de (mauz.interface-business.de
[193.101.57.233])
by innocence.interface-business.de with ESMTP id SAA18184
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 18:08:09 +0200 (CEST)
Received: (from gerald@localhost)
by mauz.interface-business.de (8.8.8/8.8.8) id SAA03206
for pgsql-general@postgreSQL.org; Mon, 27 Sep 1999 18:08:09 +0200 (CEST)
(envelope-from gerald)
Message-ID: <XFMail.990927180809.postgres@taifun.interface-business.de>
X-Mailer: XFMail 1.3 [p0] on FreeBSD
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
Date: Mon, 27 Sep 1999 18:08:09 +0200 (CEST)
Reply-To: gerald@interface-business.de
Organization: Interface Business
Sender: gerald@mauz.interface-business.de
From: postgres@taifun.interface-business.de
To: pgsql-general@postgreSQL.org
Subject: Postgres Access Control Tool

Hallo all,

there are many threads with access control problems in here:

[INTERFACES] Changing User Passwords
[ADMIN] Controlling create table rights
[ADMIN] Restricting access on tables
[ADMIN] Restricting Access to Databases

and pg_group related questions too.

"PACO" is a GUI tool which solves such problems and more.
PACO can be found here: ftp://ftp.sftech.de/pub/paco

This is not a link to an existing tool, but it is an announcement
for discussion about a _new_ tool written by my own. PACO is free,
open source, portable and IMHO usefull for Postgres DB administrators.

After I've ansered some questions about pg_group table syntax in this
mailing list with a reference to PACO I become aware of many downloads
but got no response yet. Is this a god or a bad sign?

Gerald.

From bouncefilter Mon Sep 27 12:12:04 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA79549
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:11:11 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id MAA01434;
Mon, 27 Sep 1999 12:09:45 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271609.MAA01434@candle.pha.pa.us>
Subject: Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT
In-Reply-To: <37EF8D2B.DA991489@hello.com.tw> from Kevin Lo at "Sep 27, 1999
11:28:43 pm"
To: Kevin Lo <kevlo@hello.com.tw>
Date: Mon, 27 Sep 1999 12:09:45 -0400 (EDT)
CC: Imreet Singh <imreet@titanium.noida.hclt.com>,
Post Gre <pgsql-general@postgreSQL.org>
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Imreet Singh wrote:

Hi All,

Hi, Imreet,

I have problem in installing Post Gre SQL 6.5.2 on Windows NT. As a
prerequiste (as mentioned in readme.nt in doc directory) I tried to install
Cygwin32 package first but could not do it because it contains lot of unix
system commands
Can anybody please help me with this?

I have a web page about installing on WinNT, see:

http://members.tripod.com/~kevlo/postgres/portNT.html

Added to FAQ.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 12:17:04 1999
Received: from wall-hq.rockville.axent.com (axent.com [38.178.34.254])
by hub.org (8.9.3/8.9.3) with SMTP id MAA80474
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:16:28 -0400 (EDT)
(envelope-from dheinecke@axent.com)
Received: from raven.axent.com by wall-hq.rockville.axent.com
via smtpd (for postgresql.org [209.167.229.14]) with SMTP;
28 Sep 1999 16:17:32 UT
Received: by raven.rockville.axent.com with Internet Mail Service (5.0.1460.8)
id <TBLSMLQD>; Mon, 27 Sep 1999 12:16:37 -0400
Message-ID: <8A34CE6287D8D211AB0600A0C9D182235D2AB2@raven.rockville.axent.com>
From: David Heinecke <dheinecke@axent.com>
To: pgsql-general@postgreSQL.org
Subject: Anyone doing a native NT port?
Date: Mon, 27 Sep 1999 12:16:36 -0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.0.1460.8)
Content-Type: text/plain

Hello,

My company is pretty impressed with postgre on unix, but we also need a
native port for nt (it is not an option to have our customers install cygwin
on their production systems.) Ideally we would like to see the backend
running as a native service under nt. We have the resources to do the port
ourselves (I will probably end up doing the work myself), but I was
wondering if there was already an effort underway to develop something like
this.

Dave Heinecke
Senior Software Engineer
Axent Technologies

From bouncefilter Mon Sep 27 12:33:04 1999
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA83691
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:32:37 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id MAA01702;
Mon, 27 Sep 1999 12:18:26 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271618.MAA01702@candle.pha.pa.us>
Subject: Re: [GENERAL] netmask
In-Reply-To: <Pine.BSF.4.10.9907301015240.14588-200000@fido.rnd.runnet.ru>
from
Oleg Sharoiko at "Jul 30, 1999 10:32:10 am"
To: Oleg Sharoiko <os@rsu.ru>
Date: Mon, 27 Sep 1999 12:18:26 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

As I mentioned I already applied it.

Hello!

I think this is a bug. But it's said not to report any bugs unless you're
sure that it's a bug, so I'm asking heer is this a bug?

template1=> select netmask('10.0.0.1/0');
netmask
---------------
255.255.255.255
(1 row)

This happens because
word << shift
uses only 5 low bits of shift (this is described in docs on Intel processor).
Running
word << 32
on sparc also gives unchanegd word

I've included a patch for 6.5.
I think it will work with 6.5.1

--
Oleg.

Content-Description:

[Attachment, skipping...]

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 12:49:04 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA87764
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:48:17 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id MAA02416;
Mon, 27 Sep 1999 12:47:25 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271647.MAA02416@candle.pha.pa.us>
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To:
<8A34CE6287D8D211AB0600A0C9D182235D2AB2@raven.rockville.axent.com>
from David Heinecke at "Sep 27, 1999 12:16:36 pm"
To: David Heinecke <dheinecke@axent.com>
Date: Mon, 27 Sep 1999 12:47:25 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hello,

My company is pretty impressed with postgre on unix, but we also need a
native port for nt (it is not an option to have our customers install cygwin
on their production systems.) Ideally we would like to see the backend
running as a native service under nt. We have the resources to do the port
ourselves (I will probably end up doing the work myself), but I was
wondering if there was already an effort underway to develop something like
this.

Yikes, you want to run the PostgreSQL backend without Unix simulator
support! Wow, that sounds like a big job.

I know of no one who has done this. You can see from the FAQ item that
people have running under U/Win too, but I that is a Unix emulator too.

Seems like you would basically be writing another emulator for NT to do
the things we do under Unix, no?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 12:52:04 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA88946
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:51:50 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id MAA02445;
Mon, 27 Sep 1999 12:50:54 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271650.MAA02445@candle.pha.pa.us>
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To: <37EFA1A7.F577188A@sundayta.co.uk> from David Warnock at "Sep 27,
1999 05:56:07 pm"
To: David Warnock <david@sundayta.co.uk>
Date: Mon, 27 Sep 1999 12:50:54 -0400 (EDT)
CC: David Heinecke <dheinecke@axent.com>, pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

David,

We could definately use this as we have very similar problems. We would
love to be able to support Win 9x as well.

If you decide to do this then I will provide from our company least some
time by one or two people to test and help in non coding ways (we have
no c skills).

Let me just through up a red flag on this. PostgreSQL uses more Unix
services that most software, and is almost the size/complexity of many
Unix kernels.

This is not going to be easy to do. CygWin works because it is
emulating the Unix things we need on NT. To do a native port, you would
have to translate all our unix service calls to NT-style library calls.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 12:40:14 1999
Received: from genesis.sundayta.co.uk (mail.sundayta.co.uk [212.24.70.227])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA85308
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 12:39:26 -0400 (EDT)
(envelope-from david@sundayta.co.uk)
Received: from romans.sundayta.co.uk
([192.168.100.28] helo=sundayta.co.uk ident=david)
by genesis.sundayta.co.uk with esmtp (Exim 3.03 #1 (Debian))
id 11VeST-0002ah-00; Mon, 27 Sep 1999 18:21:01 +0100
Sender: david
Message-ID: <37EFA1A7.F577188A@sundayta.co.uk>
Date: Mon, 27 Sep 1999 17:56:07 +0100
From: David Warnock <david@sundayta.co.uk>
Organization: Sundayta Ltd
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.9 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: David Heinecke <dheinecke@axent.com>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
References: <8A34CE6287D8D211AB0600A0C9D182235D2AB2@raven.rockville.axent.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

David,

We could definately use this as we have very similar problems. We would
love to be able to support Win 9x as well.

If you decide to do this then I will provide from our company least some
time by one or two people to test and help in non coding ways (we have
no c skills).

Regards

Dave

David Heinecke wrote:

Hello,

My company is pretty impressed with postgre on unix, but we also need a
native port for nt (it is not an option to have our customers install cygwin
on their production systems.) Ideally we would like to see the backend
running as a native service under nt. We have the resources to do the port
ourselves (I will probably end up doing the work myself), but I was
wondering if there was already an effort underway to develop something like
this.

--
David Warnock
Sundayta Ltd

From bouncefilter Mon Sep 27 12:58:09 1999
Received: from wall-hq.rockville.axent.com (axent.com [38.178.34.254])
by hub.org (8.9.3/8.9.3) with SMTP id MAA90306
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 12:58:02 -0400 (EDT)
(envelope-from dheinecke@axent.com)
Received: from raven.axent.com by wall-hq.rockville.axent.com
via smtpd (for postgresql.org [209.167.229.14]) with SMTP;
28 Sep 1999 16:59:07 UT
Received: by raven.rockville.axent.com with Internet Mail Service (5.0.1460.8)
id <TBLSMLR3>; Mon, 27 Sep 1999 12:58:27 -0400
Message-ID: <8A34CE6287D8D211AB0600A0C9D182235D2AD3@raven.rockville.axent.com>
From: David Heinecke <dheinecke@axent.com>
To: Bruce Momjian <maillist@candle.pha.pa.us>, David Heinecke
<dheinecke@axent.com>
Cc: pgsql-general@postgreSQL.org
Subject: RE: [GENERAL] Anyone doing a native NT port?
Date: Mon, 27 Sep 1999 12:58:25 -0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.0.1460.8)
Content-Type: text/plain

Yeah,

That is pretty much the short of it. My greatest concern undertaking an
effort like this is the resultant #ifdef/#else/#endif mess that I will need
to make of the code. We do a lot of cross-platform development here and
ultimately the code begins to look very ugly to anything except a
preprocessor. The alternative is to put most of the nt-specific code in
separate files, but then we would have to merge over the newer code from the
CVS repository. It is not a job that I look forward to, but our unix
customers are clamoring for PostGRE on the backend and our non-unix
customers are not going to be satisfied with MySQL. Sucks to be me, I
guess.

Dave Heinecke
Senior Software Engineer
Axent Technologies

-----Original Message-----
From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
Sent: Monday, September 27, 1999 10:47 AM
To: David Heinecke
Cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Anyone doing a native NT port?

Hello,

My company is pretty impressed with postgre on unix, but we also need a
native port for nt (it is not an option to have our customers install

cygwin

on their production systems.) Ideally we would like to see the backend
running as a native service under nt. We have the resources to do the

port

ourselves (I will probably end up doing the work myself), but I was
wondering if there was already an effort underway to develop something

this.

Yikes, you want to run the PostgreSQL backend without Unix simulator
support! Wow, that sounds like a big job.

I know of no one who has done this. You can see from the FAQ item that
people have running under U/Win too, but I that is a Unix emulator too.

Seems like you would basically be writing another emulator for NT to do
the things we do under Unix, no?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 13:23:09 1999
Received: from ags.ga.erg.sri.com (solabel8.ga.erg.sri.com [192.26.244.44])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA94603
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 13:22:15 -0400 (EDT)
(envelope-from ted@ags.ga.erg.sri.com)
Received: from solabel1.ga.erg.sri.com (solabel1.ga.erg.sri.com
[192.26.244.10])
by ags.ga.erg.sri.com (8.9.1a/8.9.1) with ESMTP id NAA07890;
Mon, 27 Sep 1999 13:15:58 -0400 (EDT)
Message-Id: <199909271715.NAA07890@ags.ga.erg.sri.com>
To: David Heinecke <dheinecke@axent.com>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To: Message from David Heinecke <dheinecke@axent.com> of "Mon,
27 Sep 1999 12:16:36 EDT."
<8A34CE6287D8D211AB0600A0C9D182235D2AB2@raven.rockville.axent.com>
Date: Mon, 27 Sep 1999 13:21:31 -0400
From: Ted Nolan SRI Augusta GA <ted@ags.ga.erg.sri.com>

In message <8A34CE6287D8D211AB0600A0C9D182235D2AB2@raven.rockville.axent.com>yo
u write:

Hello,

My company is pretty impressed with postgre on unix, but we also need a
native port for nt (it is not an option to have our customers install cygwin
on their production systems.) Ideally we would like to see the backend
running as a native service under nt. We have the resources to do the port
ourselves (I will probably end up doing the work myself), but I was
wondering if there was already an effort underway to develop something like
this.

Dave Heinecke
Senior Software Engineer
Axent Technologies

************

Don't know if this helps, but I pretty well have an install procedure
that installs a Postgres 6.5.1 binary tree with enough of cygwin to
make it work, so the user never has to go get cygwin or compile
Postgres. It's very basic, no spiffy GUI, it just asks several
questions and goes to work...

I have also been able to install it as a service, though I have not integrated
that part with my install.

Ted Nolan

From bouncefilter Mon Sep 27 13:27:14 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA95237
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 13:26:49 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id NAA03991;
Mon, 27 Sep 1999 13:25:32 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271725.NAA03991@candle.pha.pa.us>
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To:
<8A34CE6287D8D211AB0600A0C9D182235D2AD3@raven.rockville.axent.com>
from David Heinecke at "Sep 27, 1999 12:58:25 pm"
To: David Heinecke <dheinecke@axent.com>
Date: Mon, 27 Sep 1999 13:25:32 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Yeah,

That is pretty much the short of it. My greatest concern undertaking an
effort like this is the resultant #ifdef/#else/#endif mess that I will need
to make of the code. We do a lot of cross-platform development here and
ultimately the code begins to look very ugly to anything except a
preprocessor. The alternative is to put most of the nt-specific code in
separate files, but then we would have to merge over the newer code from the
CVS repository. It is not a job that I look forward to, but our unix
customers are clamoring for PostGRE on the backend and our non-unix
customers are not going to be satisfied with MySQL. Sucks to be me, I
guess.

But why re-invent all the work CygWin does? Why not use something that
is modular, tested, and free?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 13:32:05 1999
Received: from ags.ga.erg.sri.com (solabel8.ga.erg.sri.com [192.26.244.44])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA95885
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 13:31:08 -0400 (EDT)
(envelope-from ted@ags.ga.erg.sri.com)
Received: from solabel1.ga.erg.sri.com (solabel1.ga.erg.sri.com
[192.26.244.10])
by ags.ga.erg.sri.com (8.9.1a/8.9.1) with ESMTP id NAA07911;
Mon, 27 Sep 1999 13:24:35 -0400 (EDT)
Message-Id: <199909271724.NAA07911@ags.ga.erg.sri.com>
To: pgsql-ports@hub.org
cc: pgsql-general@postgreSQL.org
Subject: Re: [PORTS] ipc-daemon runs wild on NT?
In-Reply-To: Message from Ted Nolan SRI Augusta GA <ted@ags.ga.erg.sri.com>
of "Fri,
24 Sep 1999 11:22:35 EDT." <199909241517.LAA19260@ags.ga.erg.sri.com>
Date: Mon, 27 Sep 1999 13:30:08 -0400
From: Ted Nolan SRI Augusta GA <ted@ags.ga.erg.sri.com>

In message <199909241517.LAA19260@ags.ga.erg.sri.com>you write:

Hello folks,

I'm running 6.5.1 on NT. I think I've applied all the patches to the
ipc-daaemon, but after a while it starts hogging the CPU, even when no
queries of any sort are being made (although there is a postmaster present).
Reducing the priority helps a bit, but it's not a solution.

Has anyone seen this? If so did you find a fix?

Thanks,

Ted Nolan

************

I've done a little more looking (very little..) and see that the
ipc-daemon has a loop in ipc-daemon.c that looks like

while(1)
{
usleep(300000) ;
....
....

I still don't know exactly what the ipc-daemon _does_, but I'm wondering if
cygwin usleep() somehow granularizes to 0 in some cases..

Does anyone has any feeling what the consequences would be in changing that
usleep to a "sleep(1)"

Ted Nolan

From bouncefilter Mon Sep 27 13:31:09 1999
Received: from genesis.sundayta.co.uk (mail.sundayta.co.uk [212.24.70.227])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA95854
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 13:30:50 -0400 (EDT)
(envelope-from david@sundayta.co.uk)
Received: from romans.sundayta.co.uk
([192.168.100.28] helo=sundayta.co.uk ident=david)
by genesis.sundayta.co.uk with esmtp (Exim 3.03 #1 (Debian))
id 11VfF0-0002dz-00; Mon, 27 Sep 1999 19:11:10 +0100
Sender: david
Message-ID: <37EFAD68.85A178ED@sundayta.co.uk>
Date: Mon, 27 Sep 1999 18:46:16 +0100
From: David Warnock <david@sundayta.co.uk>
Organization: Sundayta Ltd
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.9 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: Bruce Momjian <maillist@candle.pha.pa.us>
CC: David Heinecke <dheinecke@axent.com>, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
References: <199909271650.MAA02445@candle.pha.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Bruce,

As I am not going to be able to help on the coding I won't try to
comment on it's dificulty.

But I will ask what realistic expectations are for the current NT port
using cgywin. My current concern is that the installation is very
complex and the useability is poor due to the need to enter a cgywin
shell to access any of the postgresql features.

a) Is it going to be possible using cgywin to build binaries
(postmaster, createdb, psql etc) that can be run from a standard windows
NT command prompt? Or will a cgywin shell always be needed? If this can
be done then so that we can provide an installation of binaries with no
unix shell visible then we can probably get this accepted by our users.

b) Is it possible to add support for Windows 9x? If so it anyone working
on this? (NB I am not considering this as a server platform but for a
single user system to avoid us supporting multiple dbms) [anyway I don't
know of an alternative to Postgresql that has the same feature set - I
need most postgresql features {license and technical}].

Let me just through up a red flag on this. PostgreSQL uses more Unix
services that most software, and is almost the size/complexity of many
Unix kernels.

This is not going to be easy to do. CygWin works because it is
emulating the Unix things we need on NT. To do a native port, you would
have to translate all our unix service calls to NT-style library calls.

Dave

--
David Warnock
Sundayta Ltd

From bouncefilter Mon Sep 27 14:06:05 1999
Received: from nereus.informatik.uni-bonn.de (nereus.informatik.uni-bonn.de
[131.220.5.20]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA04588
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 14:04:57 -0400 (EDT) (envelope-from elmar@haneke.de)
Received: from localhost (jod.informatik.uni-bonn.de [131.220.9.99])
by nereus.informatik.uni-bonn.de (8.8.8/8.8.8) with ESMTP id TAA12195;
Mon, 27 Sep 1999 19:58:32 +0200 (MET DST)
Received: from Spooler by localhost (Mercury/32 v2.16);
27 Sep 99 20:03:39 +0200
Received: from spooler by haneke.de (Mercury/32 v2.16);
27 Sep 99 19:56:55 +0200
Received: from haneke.de (127.0.0.1) by Haneke Elektronik (Mercury/32 v2.16)
with ESMTP; 27 Sep 99 19:56:49 +0200
Message-ID: <37EFAFE1.982F4370@haneke.de>
Date: Mon, 27 Sep 1999 19:56:49 +0200
From: Elmar Haneke <elmar@haneke.de>
Organization: Haneke
X-Mailer: Mozilla 4.05 [de] (WinNT; I)
MIME-Version: 1.0
To: David Heinecke <dheinecke@axent.com>, pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
References: <8A34CE6287D8D211AB0600A0C9D182235D2AB2@raven.rockville.axent.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

David Heinecke schrieb:

Hello,

My company is pretty impressed with postgre on unix, but we also need a
native port for nt (it is not an option to have our customers install cygwin
on their production systems.) Ideally we would like to see the backend
running as a native service under nt. We have the resources to do the port
ourselves (I will probably end up doing the work myself), but I was
wondering if there was already an effort underway to develop something like
this.

Is it really a problem to install the required cygwin components?
Certainly not the complete cygwin package is required to run the
PorsgreSQL deamon. I think the cygwinxxx.DLL is the myjor part of the
files required. You should try to install it withoud the complete
cygwin package.

Elmar

From bouncefilter Mon Sep 27 14:08:05 1999
Received: from pop.uniserve.com (pop.uniserve.com [204.244.156.3])
by hub.org (8.9.3/8.9.3) with SMTP id OAA04826
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 14:07:35 -0400 (EDT) (envelope-from alan@ufies.org)
Received: from dev.netmaster.ca (ufies.org) [204.244.242.235]
by pop.uniserve.com with esmtp (Exim 1.82 #4)
id 11VfBV-0001Np-00; Mon, 27 Sep 1999 11:07:33 -0700
Sender: alan
Message-ID: <37EFB1F1.FC840F77@ufies.org>
Date: Mon, 27 Sep 1999 11:05:37 -0700
From: Arcterex <alan@ufies.org>
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.0.36 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: upgrade questions
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Howdy everyone.

I'm in the process of moving a postgres database from one box to another
and have a couple of questions on the best way to do things.

I'm moving from a RH 6 box using postgres 6.4 to a debian 2.1 box with
postgres 6.3. It's not backwards compatible, so I can't access the
database at all, except for when I do a "\c <database>" it tells me it's
the wrong version number.

Now the latest debian has the 6.5 version of postgres, but I can't
upgrade to that package becuase the dependancies would break
*everything*. I could download/compile the postgres sources and build
things here, trying to keep the old directories and directory structure,
and *hope* that that works...

Does anyone know of a good way to move the data across? Or maybe a way
to convert from 6.4 to 6.3 somehow?

Thanks a lot..

alan

From bouncefilter Mon Sep 27 14:21:05 1999
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id OAA06499
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 14:20:48 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id OAA10269;
Mon, 27 Sep 1999 14:17:11 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271817.OAA10269@candle.pha.pa.us>
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To: <37EFAD68.85A178ED@sundayta.co.uk> from David Warnock at "Sep 27,
1999 06:46:16 pm"
To: David Warnock <david@sundayta.co.uk>
Date: Mon, 27 Sep 1999 14:17:11 -0400 (EDT)
CC: David Heinecke <dheinecke@axent.com>, pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Bruce,

As I am not going to be able to help on the coding I won't try to
comment on it's dificulty.

But I will ask what realistic expectations are for the current NT port
using cgywin. My current concern is that the installation is very
complex and the useability is poor due to the need to enter a cgywin
shell to access any of the postgresql features.

So

a) Is it going to be possible using cgywin to build binaries
(postmaster, createdb, psql etc) that can be run from a standard windows
NT command prompt? Or will a cgywin shell always be needed? If this can
be done then so that we can provide an installation of binaries with no
unix shell visible then we can probably get this accepted by our users.

b) Is it possible to add support for Windows 9x? If so it anyone working
on this? (NB I am not considering this as a server platform but for a
single user system to avoid us supporting multiple dbms) [anyway I don't
know of an alternative to Postgresql that has the same feature set - I
need most postgresql features {license and technical}].

Sorry, I don't know the answers to these questions because I don't use
NT, but I will say this. Fixing the above problems is going to be 99
times easier than porting PostgreSQL to native NT without cygwin.
Basically, you will have to write cygwin, and that is no trivial task.

The above items can probably be done using tcl/tk for a user interface,
and having the cygwin shell do the actual execution. Again, 99 times
easier to do than the port to native NT.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 15:02:06 1999
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id PAA12712
for <pgsql-general@hub.org>; Mon, 27 Sep 1999 15:01:34 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id OAA11558;
Mon, 27 Sep 1999 14:50:54 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271850.OAA11558@candle.pha.pa.us>
Subject: Re: [GENERAL] backend crashing with INTERSECT / ORDER BY
In-Reply-To: <14269.22288.701528.749251@blanc.aeccom.com> from Dirk Lutzebaeck
at "Aug 20, 1999 03:24:32 pm"
To: Dirk Lutzebaeck <lutzeb@aeccom.com>
Date: Mon, 27 Sep 1999 14:50:53 -0400 (EDT)
CC: pgsql-general@hub.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1:

[csmaster@kamet release0]$ psql cs1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: cs1

cs1=> SELECT envelope FROM docobj
cs1-> WHERE attrid=5
cs1-> INTERSECT
cs1-> SELECT envelope FROM docobj
cs1-> WHERE attrid=6
cs1-> ORDER BY attrid DESC
cs1-> ;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.

Not sure. I just tried this:

test=> select relname from pg_class intersect select relname from
pg_class order by relname;
ERROR: get_sortgroupclause_expr: ORDER/GROUP BY expression not found in
targetlist

Not sure what this means either.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 15:03:10 1999
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id PAA12843
for <pgsql-hackers@postgreSQL.org>;
Mon, 27 Sep 1999 15:02:26 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id OAA11599;
Mon, 27 Sep 1999 14:52:06 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909271852.OAA11599@candle.pha.pa.us>
Subject: Re: [GENERAL] Error during 'vacuum analyze'
In-Reply-To: <37BD8A26.BED83813@nsi.edu> from "G. Anthony Reina" at "Aug 20,
1999 10:02:30 am"
To: "G. Anthony Reina" <reina@nsi.edu>
Date: Mon, 27 Sep 1999 14:52:06 -0400 (EDT)
CC: Mark Dalphin <mdalphin@amgen.com>,
PostgreSQL-development <pgsql-hackers@postgreSQL.org>
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

I assume we addressed this in our current tree, right?

Mark,

The error you are experiencing was discussed on the hacker's list
last week. Oliver Elphick and Tom Good worked out a patch for SQL to
solve the problem. You're right that the pg_vlock is getting created and
then getting deleted during the vacuuming of the last table. This ends
up boinking the vacuum. I've attached the patch that Oliver sent to me.
The patch won't go through all of the way so you'll have to go through
file by file and just make the changes yourself (just deleting a few
lines or adding a few, nothing big). That has solved the problem on my
machine.

-Tony

Index: include/access/nbtree.h
===================================================================
RCS file: /usr/local/cvsroot/pgsql/src/include/access/nbtree.h,v
retrieving revision 1.27
retrieving revision 1.27.2.1
diff -c -r1.27 -r1.27.2.1
*** include/access/nbtree.h     1999/05/25 22:04:55     1.27
--- include/access/nbtree.h     1999/08/08 20:24:09     1.27.2.1
***************
*** 255,260 ****
--- 255,261 ----
extern void _bt_regscan(IndexScanDesc scan);
extern void _bt_dropscan(IndexScanDesc scan);
extern void _bt_adjscans(Relation rel, ItemPointer tid);
+ extern void AtEOXact_nbtree(void);

/*
* prototypes for functions in nbtsearch.c
Index: backend/access/nbtree/nbtscan.c
===================================================================
RCS file: /usr/local/cvsroot/pgsql/src/backend/access/nbtree/nbtscan.c,v
retrieving revision 1.23.2.1
retrieving revision 1.23.2.2
diff -c -r1.23.2.1 -r1.23.2.2
*** backend/access/nbtree/nbtscan.c     1999/08/02 05:24:41     1.23.2.1
--- backend/access/nbtree/nbtscan.c     1999/08/08 20:24:10     1.23.2.2
***************
*** 42,47 ****
--- 42,69 ----
static BTScanList BTScans = (BTScanList) NULL;

static void _bt_scandel(IndexScanDesc scan, BlockNumber blkno, OffsetNumber offno);
+ 
+ /*
+  * AtEOXact_nbtree() --- clean up nbtree subsystem at xact abort or commit.
+  *
+  * This is here because it needs to touch this module's static var BTScans.
+  */
+ void
+ AtEOXact_nbtree(void)
+ {
+       /* Note: these actions should only be necessary during xact abort;
+        * but they can't hurt during a commit.
+        */
+ 
+       /* Reset the active-scans list to empty.
+        * We do not need to free the list elements, because they're all
+        * palloc()'d, so they'll go away at end of transaction anyway.
+        */
+       BTScans = NULL;
+ 
+       /* If we were building a btree, we ain't anymore. */
+       BuildingBtree = false;
+ }

/*
*    _bt_regscan() -- register a new scan.
Index: backend/access/transam/transam.c
===================================================================
RCS file: /usr/local/cvsroot/pgsql/src/backend/access/transam/transam.c,v
retrieving revision 1.27.2.1
retrieving revision 1.27.2.2
diff -c -r1.27.2.1 -r1.27.2.2
*** backend/access/transam/transam.c    1999/08/02 05:56:46     1.27.2.1
--- backend/access/transam/transam.c    1999/08/08 20:24:12     1.27.2.2
***************
*** 20,26 ****

#include "access/heapam.h"
#include "catalog/catname.h"
- #include "commands/vacuum.h"

static int    RecoveryCheckingEnabled(void);
static void TransRecover(Relation logRelation);
--- 20,25 ----
***************
*** 83,95 ****
*/
extern int    OidGenLockId;

- /* ----------------
- * globals that must be reset at abort
- * ----------------
- */
- extern bool BuildingBtree;

- 
/* ----------------
*            recovery checking accessors
* ----------------
--- 82,88 ----
***************
*** 568,578 ****
void
TransactionIdAbort(TransactionId transactionId)
{
-       BuildingBtree = false;
- 
-       if (VacuumRunning)
-               vc_abort();
- 
if (AMI_OVERRIDE)
return;

--- 561,566 ----
Index: backend/access/transam/xact.c
===================================================================
RCS file: /usr/local/cvsroot/pgsql/src/backend/access/transam/xact.c,v
retrieving revision 1.42.2.1
retrieving revision 1.42.2.2
diff -c -r1.42.2.1 -r1.42.2.2
*** backend/access/transam/xact.c       1999/08/02 05:56:48     1.42.2.1
--- backend/access/transam/xact.c       1999/08/08 20:24:12     1.42.2.2
***************
*** 144,152 ****
--- 144,154 ----
*/
#include "postgres.h"

+ #include "access/nbtree.h"
#include "catalog/heap.h"
#include "commands/async.h"
#include "commands/sequence.h"
+ #include "commands/vacuum.h"
#include "libpq/be-fsstubs.h"
#include "storage/proc.h"
#include "utils/inval.h"
***************
*** 952,957 ****
--- 954,960 ----
}

RelationPurgeLocalRelation(true);
+       AtEOXact_nbtree();
AtCommit_Cache();
AtCommit_Locks();
AtCommit_Memory();
***************
*** 1013,1021 ****
--- 1016,1027 ----
AtAbort_Notify();
CloseSequences();
AtEOXact_portals();
+       if (VacuumRunning)
+               vc_abort();
RecordTransactionAbort();
RelationPurgeLocalRelation(false);
DestroyNoNameRels();
+       AtEOXact_nbtree();
AtAbort_Cache();
AtAbort_Locks();
AtAbort_Memory();

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 14:59:10 1999
Received: from finch-post-10.mail.demon.net (finch-post-10.mail.demon.net
[194.217.242.38]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA12249
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 14:58:18 -0400 (EDT)
(envelope-from peter@retep.org.uk)
Received: from maidast.demon.co.uk ([158.152.22.37] helo=maidast.retep.org.uk)
by finch-post-10.mail.demon.net with esmtp (Exim 2.12 #1)
id 11VfyW-000Djb-0A; Mon, 27 Sep 1999 18:58:13 +0000
Received: from localhost (peter@localhost [127.0.0.1])
by maidast.retep.org.uk (8.9.3/8.9.3) with ESMTP id TAA12458;
Mon, 27 Sep 1999 19:57:13 +0100
Date: Mon, 27 Sep 1999 19:57:13 +0100 (GMT)
From: Peter Mount <peter@retep.org.uk>
To: David Warnock <david@sundayta.co.uk>
cc: Bruce Momjian <maillist@candle.pha.pa.us>,
David Heinecke <dheinecke@axent.com>, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To: <37EFAD68.85A178ED@sundayta.co.uk>
Message-ID: <Pine.LNX.4.10.9909271950380.12379-100000@maidast.retep.org.uk>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Mon, 27 Sep 1999, David Warnock wrote:

Bruce,

As I am not going to be able to help on the coding I won't try to
comment on it's dificulty.

But I will ask what realistic expectations are for the current NT port
using cgywin. My current concern is that the installation is very
complex and the useability is poor due to the need to enter a cgywin
shell to access any of the postgresql features.

You don't necessarily need to use the cygwin shell. At work, I have a pair
of utilities that are run by every user as they log on. All these tools
need is one of the dlls (in my case cygwin1.dll) in the same directory as
the tool and it works fine.

PS: There has been in the last few days on the cygwin list some discussion
about the copying of just the dll's with an application. It might be worth
you check their archives.

a) Is it going to be possible using cgywin to build binaries
(postmaster, createdb, psql etc) that can be run from a standard windows
NT command prompt? Or will a cgywin shell always be needed? If this can
be done then so that we can provide an installation of binaries with no
unix shell visible then we can probably get this accepted by our users.

See above. Yes, as I've done it.

PS: About 6 months ago (may be longer, I can't remember) for the TASS
project I compiled a standalone psql.exe (aka a Win32 version of the psql
client). Several people found it useful, and they only needed the exe and
the dll.

b) Is it possible to add support for Windows 9x? If so it anyone working
on this? (NB I am not considering this as a server platform but for a
single user system to avoid us supporting multiple dbms) [anyway I don't
know of an alternative to Postgresql that has the same feature set - I
need most postgresql features {license and technical}].

I'm not sure why the NT version is only NT specific, as Cygwin runs on
Win95 and 98. Does our NT port use any NT services?

Peter

--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf

From bouncefilter Mon Sep 27 15:02:13 1999
Received: from ags.ga.erg.sri.com (solabel8.ga.erg.sri.com [192.26.244.44])
by hub.org (8.9.3/8.9.3) with ESMTP id PAA12734
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 15:01:47 -0400 (EDT)
(envelope-from ted@ags.ga.erg.sri.com)
Received: from solabel1.ga.erg.sri.com (solabel1.ga.erg.sri.com
[192.26.244.10])
by ags.ga.erg.sri.com (8.9.1a/8.9.1) with ESMTP id OAA08445;
Mon, 27 Sep 1999 14:54:51 -0400 (EDT)
Message-Id: <199909271854.OAA08445@ags.ga.erg.sri.com>
To: Bruce Momjian <maillist@candle.pha.pa.us>
cc: David Warnock <david@sundayta.co.uk>,
David Heinecke <dheinecke@axent.com>,
pgsql-general@postgreSQL.org, ted@ags.ga.erg.sri.com
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To: Message from Bruce Momjian <maillist@candle.pha.pa.us> of "Mon,
27 Sep 1999 14:17:11 EDT." <199909271817.OAA10269@candle.pha.pa.us>
Date: Mon, 27 Sep 1999 15:00:23 -0400
From: Ted Nolan SRI Augusta GA <ted@ags.ga.erg.sri.com>

In message <199909271817.OAA10269@candle.pha.pa.us>you write:

Bruce,

As I am not going to be able to help on the coding I won't try to
comment on it's dificulty.

But I will ask what realistic expectations are for the current NT port
using cgywin. My current concern is that the installation is very
complex and the useability is poor due to the need to enter a cgywin
shell to access any of the postgresql features.

So

a) Is it going to be possible using cgywin to build binaries
(postmaster, createdb, psql etc) that can be run from a standard windows
NT command prompt? Or will a cgywin shell always be needed? If this can
be done then so that we can provide an installation of binaries with no
unix shell visible then we can probably get this accepted by our users.

b) Is it possible to add support for Windows 9x? If so it anyone working
on this? (NB I am not considering this as a server platform but for a
single user system to avoid us supporting multiple dbms) [anyway I don't
know of an alternative to Postgresql that has the same feature set - I
need most postgresql features {license and technical}].

Sorry, I don't know the answers to these questions because I don't use
NT, but I will say this. Fixing the above problems is going to be 99
times easier than porting PostgreSQL to native NT without cygwin.
Basically, you will have to write cygwin, and that is no trivial task.

The above items can probably be done using tcl/tk for a user interface,
and having the cygwin shell do the actual execution. Again, 99 times
easier to do than the port to native NT.

--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000

OK, I've just put the 6.5.1 install for NT that I mentioned a few
messages ago up for FTP at ftp.erg.sri.com in
/pub/people/ted/pg_inst.zip. This is part of a larger project I'm
working on and I have absolutely no time to support or debug it. (And
have never done it from a ZIP before, but that should be OK..) If it
works for you -- great! If not, I'd like to hear what went wrong, but
I probably won't be able to help you much. The key thing, per this
discussion, is that the user doesn't need to get or interact directly
with cygwin.

Unzip it and double click on "inst_pg.bat". Hopefully this will start an
install process. After this finishes, double click on "startdb.bat"
in the directory where you told it to install, minimize that, then double
click on "nw_psql.bat" (You could wrap other PGSQL commands as bat files
also).

When done, double click on "stopdb.bat" to kill the postmaster & ipc-daemon.

This install does not install PG as a service. I've done that with seeming
success, but it didn't make it into the install...

Also, as you've seen, I still have some concerns about the ipc-daemon
gradually becomming a CPU hog..

Ted Nolan

From bouncefilter Mon Sep 27 15:27:06 1999
Received: from queluz.economatica.com.br (mail@queluz.economatica.com.br
[200.231.195.36]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA16781
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 15:26:36 -0400 (EDT)
(envelope-from oexel@economatica.com.br)
Received: from oexel by queluz.economatica.com.br with local (Exim 2.05 #1
(Debian)) id 11VgQL-0004Bm-00; Mon, 27 Sep 1999 16:26:57 -0300
Date: Mon, 27 Sep 1999 16:26:57 -0300
From: Otavio Exel <oexel@economatica.com.br>
To: PostgreSQL mailing list <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] psql 6.3.2 for win32
Message-ID: <19990927162657.A16040@economatica.com.br>
Reply-To: oexel@economatica.com.br
References: <37EFAD68.85A178ED@sundayta.co.uk>
<Pine.LNX.4.10.9909271950380.12379-100000@maidast.retep.org.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.95.3i
In-Reply-To: <Pine.LNX.4.10.9909271950380.12379-100000@maidast.retep.org.uk>;
from Peter Mount on Mon, Sep 27, 1999 at 07:57:13PM +0100
Organization: Economatica Ltda

Peter Mount wrote:

PS: About 6 months ago (may be longer, I can't remember) for the TASS
project I compiled a standalone psql.exe (aka a Win32 version of the
psql client). Several people found it useful, and they only needed the
exe and the dll.

sorry for branching the thread but I'm after a Win32 port of psql.exe
and libpq.dll based on the 6.3.2 version of postgresql; can someone
please point me to it?

btw: the one available from ftp.postgresql.org/pub/non-unix is based on
postgresql 6.4.2;

TIA!

--
Otavio Exel /<\oo/>\ oexel@economatica.com.br

From bouncefilter Mon Sep 27 15:42:06 1999
Received: from smtp5.mindspring.com (smtp5.mindspring.com [207.69.200.82])
by hub.org (8.9.3/8.9.3) with ESMTP id PAA19127
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 15:41:55 -0400 (EDT)
(envelope-from keithmur@mindspring.com)
Received: from mindspring.com (pool-207-205-130-43.atln.grid.net
[207.205.130.43])
by smtp5.mindspring.com (8.8.5/8.8.5) with ESMTP id PAA15833
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 15:41:53 -0400 (EDT)
Message-ID: <37EFC91B.7A26809D@mindspring.com>
Date: Mon, 27 Sep 1999 14:44:27 -0500
From: "Keith G. Murphy" <keithmur@mindspring.com>
Reply-To: keithmur@mindspring.com
Organization: A small shoebox in the middle of the road
X-Mailer: Mozilla 4.6 [en] (Win95; U)
X-Accept-Language: en,en-US,en-GB
MIME-Version: 1.0
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] libpq on win32 & postgresql on linux
References: <19990927093856.A10665@economatica.com.br>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Otavio Exel wrote:

hello list,

note: postgres-newbie here!

Me, too, pretty much.

I have:
- a linux box with postgresql 6.3.2 installed;
- a win95 box with postgresql-win32-client-6.4.2 (from
ftp://ftp.postgresql.org) installed;

the win32 client can't connect due to a backward-incompatible change in
the protocol; AFAIK I have 3 choices:

1. upgrade the postgresql on the linux box;
2. downgrade the win32 client on the win32 box;
3. use odbc;

but I'm facing the following problems when choosing among the 3 above
mentioned options:

1. the stable release of debian comes with 6.3.2 and I don't feel
confortable enough to compile my own installation; I tried to install
the package for the unstable version but it is not compatible;

Why not compatible? I'm running Slink, and just upgraded apache,
postgresql, and perl from Potato. The main thing, besides libraries
specific to those products, was glibc going from 2.0 to 2.1. Everything
is still working so far. I don't run much else on my system. The
postgresql upgrade went without a hitch; postgresql-dump easily
reimported my old data into the new format. There was very little data,
however, all of it non-critical, since I am just in the initial stages
of prototyping at this point.

One reason I did it is that I wanted to try pgaccess from Win32, and the
libraries for use with it have moved beyond 6.3.2. I wanted to stay a
little further ahead with apache and Perl, too, than Slink has afforded
me. Debian's getting a little behind with this stuff, but I can see why
they don't want to hurt Slink sites that are running fine, by forcing
them to upgrade glibc.

Why not join me on the cutting edge? :-) Unless it's a production
machine. =:-0

2. the only port of win32-client available from ftp.postgresql.org is
6.4.2; is there a postgresql-win32-client based of 6.3.2 somewhere?

3. I've never used odbc and I think of it as an unnecessary layer of
complexity for my needs; am I wrong?

It will make it easier if you ever start using a different database;
almost all of them have ODBC drivers. You could use tools like Access
and Visual Basic, presumably.

would someone please comment on my comments?

Happy to see someone else trying to run this stuff on Debian. Are you
doing any web stuff?

From bouncefilter Mon Sep 27 16:47:11 1999
Received: from oceanic.wsisiz.edu.pl (root@oceanic.wsisiz.edu.pl
[195.205.208.33]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA28474
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 16:46:39 -0400 (EDT)
(envelope-from marn@oceanic.wsisiz.edu.pl)
Received: (from marn@localhost)
by oceanic.wsisiz.edu.pl (8.9.3/8.9.3 LT) id WAA26301
for pgsql-general@postgreSQL.org; Mon, 27 Sep 1999 22:46:27 +0200
Date: Mon, 27 Sep 1999 22:46:27 +0200
From: Marcin Inkielman <marn@oceanic.wsisiz.edu.pl>
Message-Id: <199909272046.WAA26301@oceanic.wsisiz.edu.pl>
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0

I have a similar problem, i think it worked with previous postrgesql versions (6.4.x)
when i typed:

------------------------

[marn@mi marn]$ createdb pr
[marn@mi marn]$ psql pr
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: pr
pr=> create table "J��zyk obcy"(a text);
CREATE
pr=> select * from "J��zyk obcy";
a
-
(0 rows)

pr=> create view "J��zyk obcy1" as select * from "J��zyk obcy";
CREATE
pr=> select * from "J��zyk obcy1";
ERROR: nodeRead: Bad type 0
pr=> vacuum;
ERROR: nodeRead: Bad type 0
pr=> drop view "J��zyk obcy1";
ERROR: nodeRead: Bad type 0

-------------------------------

note that the name of the view contains a space and a national character

there is no problem with:

-------------------------------
[marn@mi marn]$ destroydb pr;
[marn@mi marn]$ createdb pr
[marn@mi marn]$ psql pr
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: pr

pr=> create table "J��zyk_obcy"(a text);
CREATE
pr=> select * from "J��zyk_obcy";
a
-
(0 rows)

pr=> create view "J��zyk_obcy1" as select * from "J��zyk_obcy";
CREATE
pr=> select * from "J��zyk_obcy1";
a
-
(0 rows)

just a killing space??????????????
--

Marcin Inkielman

************************************
sibi omino similis?
************************************

From bouncefilter Mon Sep 27 16:53:11 1999
Received: from orion.nsdigital.com (orion.nsdigital.com [209.221.176.42] (may
be forged)) by hub.org (8.9.3/8.9.3) with SMTP id QAA29277
for <pgsql-general@hub.org>; Mon, 27 Sep 1999 16:52:49 -0400 (EDT)
(envelope-from jason@nsdigital.com)
Received: (qmail 8130 invoked from network); 27 Sep 1999 20:48:30 -0000
Received: from sense-tac-pm2-30.oz.net (HELO nsdigital.com) (216.39.138.62)
by mail.nsdigital.com with SMTP; 27 Sep 1999 20:48:30 -0000
Sender: jason
Message-ID: <37EFD980.11E8C6C0@nsdigital.com>
Date: Mon, 27 Sep 1999 13:54:24 -0700
From: Jason Farnsworth <jason@nsdigital.com>
Organization: Northstar Digital Media
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-22smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@hub.org
Subject: Finding info on database users
References: <199909271902.PAA12804@hub.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello.. I'm fairly new to Postgres but have it mostly figured out. I'm
just having a hard time finding any documentation that covers how to
manage database users and set their permissions? ANybody have a URL or
anything to point me to? Thanks..

Jason Farnsworth
Northstar Digital

From bouncefilter Mon Sep 27 17:10:17 1999
Received: from oceanic.wsisiz.edu.pl (root@oceanic.wsisiz.edu.pl
[195.205.208.33]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA31656
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 17:10:07 -0400 (EDT)
(envelope-from marn@oceanic.wsisiz.edu.pl)
Received: (from marn@localhost)
by oceanic.wsisiz.edu.pl (8.9.3/8.9.3 LT) id XAA27077
for pgsql-general@postgreSQL.org; Mon, 27 Sep 1999 23:10:03 +0200
Date: Mon, 27 Sep 1999 23:10:03 +0200
From: Marcin Inkielman <marn@oceanic.wsisiz.edu.pl>
Message-Id: <199909272110.XAA27077@oceanic.wsisiz.edu.pl>
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0

I have a similar problem, i think it worked with previous postrgesql versions (6.4.x)
when i typed:

------------------------

-------------------------------

note that the name of the view contains a space and a national character

there is no problem with:

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: pr

pr=> create table "J��zyk_obcy"(a text);
CREATE
pr=> select * from "J��zyk_obcy";
a
-
(0 rows)

pr=> create view "J��zyk_obcy1" as select * from "J��zyk_obcy";
CREATE
pr=> select * from "J��zyk_obcy1";
a
-
(0 rows)

just a killing space??????????????
--

Marcin Inkielman

************************************
sibi omino similis?
************************************

From bouncefilter Mon Sep 27 19:29:20 1999
Received: from its.uq.edu.au (root@brolga.cc.uq.edu.au [130.102.128.5])
by hub.org (8.9.3/8.9.3) with ESMTP id TAA46620
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 19:28:20 -0400 (EDT)
(envelope-from ccmcduff@its.uq.edu.au)
Received: from bunyip.cc.uq.edu.au (ccmcduff@bunyip.cc.uq.edu.au
[130.102.2.1])
by its.uq.edu.au (8.8.6/8.8.8) with ESMTP id JAA02346;
Tue, 28 Sep 1999 09:27:45 +1000 (EST)
Message-Id: <199909272327.JAA02346@its.uq.edu.au>
X-Mailer: exmh version 2.0.2 2/24/98
To: Mark Jewiss <Mark.Jewiss@knowledge.com>
Cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] \d <table> command
In-Reply-To: Your message of "Mon, 27 Sep 1999 14:15:43 +0100."
<Pine.BSO.4.10.9909271412510.4204-100000@office.knowledge.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Tue, 28 Sep 1999 09:27:45 +1000
From: Rodney McDuff <ccmcduff@its.uq.edu.au>

HI Mark

I want to be able to build up information about the different tables held
in a database for a small diagnostic tool that I'm writing.

I need to see the name of each column in the table, the column data type
and size, and if nulls are allowed - essentially what is produced by the
'\d <tablename>' command.

Does anyone know the SQL query to use on the system tables to produce that
result? I've started to go through them now, and was expecting to find
something along the lines of 'pg_columns', but no such luck. :(

From man psql:

-E Echo the actual query generated by \d and other backslash commands

  +-----------------+------------------------------------------+
  |    _   ^   _    | Dr. Rodney McDuff                        |
  |   |\  /|\  /|   | Network Development, ITS                 |
  |     \  |  /     | The University of Queensland             |
  |      \ | /      | St. Lucia, Brisbane                      |
  |       \|/       | Queensland, Australia. 4072.             |
  |<-------+------->| TELEPHONE: +61 7 3365 8220               |
  |       /|\       | FACSIMILE: +61 7 3365 4477               |
  |      / | \      | EMAIL: mcduff@its.uq.edu.au              |
  |     /  |  \     |                                          |
  |   |/  \|/  \|   |        Ex ignorantia ad sapientiam       |
  |    -   v   -    |            Ex luce ad tenebras           |
  +-----------------+------------------------------------------+

From bouncefilter Mon Sep 27 21:33:10 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id VAA61788
for <pgsql-general@postgreSQL.org>;
Mon, 27 Sep 1999 21:33:04 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id VAA20754;
Mon, 27 Sep 1999 21:32:14 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909280132.VAA20754@candle.pha.pa.us>
Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0
In-Reply-To: <199909272110.XAA27077@oceanic.wsisiz.edu.pl> from Marcin
Inkielman at "Sep 27, 1999 11:10:03 pm"
To: Marcin Inkielman <marn@oceanic.wsisiz.edu.pl>
Date: Mon, 27 Sep 1999 21:32:14 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=UNKNOWN-8BIT
Content-Transfer-Encoding: 8bit

There is a TODO item:

* Views with spaces in view name fail when referenced

I have a similar problem, i think it worked with previous postrgesql versions (6.4.x)
when i typed:

------------------------

[marn@mi marn]$ createdb pr
[marn@mi marn]$ psql pr
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: pr
pr=> create table "J��zyk obcy"(a text);
CREATE
pr=> select * from "J��zyk obcy";
a
-
(0 rows)

pr=> create view "J��zyk obcy1" as select * from "J��zyk obcy";
CREATE
pr=> select * from "J��zyk obcy1";
ERROR: nodeRead: Bad type 0
pr=> vacuum;
ERROR: nodeRead: Bad type 0
pr=> drop view "J��zyk obcy1";
ERROR: nodeRead: Bad type 0

-------------------------------

note that the name of the view contains a space and a national character

there is no problem with:

-------------------------------
[marn@mi marn]$ destroydb pr;
[marn@mi marn]$ createdb pr
[marn@mi marn]$ psql pr
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: pr

pr=> create table "J��zyk_obcy"(a text);
CREATE
pr=> select * from "J��zyk_obcy";
a
-
(0 rows)

pr=> create view "J��zyk_obcy1" as select * from "J��zyk_obcy";
CREATE
pr=> select * from "J��zyk_obcy1";
a
-
(0 rows)

just a killing space??????????????
--

Marcin Inkielman

************************************
sibi omino similis?
************************************

************

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Sep 27 23:48:11 1999
Received: from mta4.snfc21.pbi.net (mta4.snfc21.pbi.net [206.13.28.142])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA11246
for <pgsql-general@postgresql.org>;
Mon, 27 Sep 1999 23:47:18 -0400 (EDT) (envelope-from myers@iname.com)
Received: from veetwin ([209.233.30.172])
by mta4.snfc21.pbi.net (Sun Internet Mail Server
sims.3.5.1999.05.24.18.28.p7)
with ESMTP id <0FIR00BIV3URIC@mta4.snfc21.pbi.net> for
pgsql-general@postgresql.org; Mon, 27 Sep 1999 20:47:15 -0700 (PDT)
Date: Mon, 27 Sep 1999 20:49:06 -0700 (PDT)
From: myers <myers@iname.com>
Subject: Solaris 7 x86 error
X-Sender: myers@veetwin.myers.lan
To: pgsql-general@postgresql.org
Message-id: <Pine.GSO.4.10.9909272038110.1098-100000@veetwin.myers.lan>
MIME-version: 1.0
Content-type: TEXT/PLAIN; charset=US-ASCII

Folks:

I get the following errors when trying to start up Postgres ('postmaster
-S') on a Solaris 7 x86 machine:

IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
permission=700
IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
size=120, permission=0
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment

The shared memory settings in /etc/system are:

set shmsys:shminfo_shmmax=50331648
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100

Compiler was gcc 2.95.1.

A truss of the postmaster process shows the following:

shmget(5432010, 120, 0700|IPC_CREAT) Err#22 EINVAL
IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
permis\
sion=700write(2, " I p c M e m o r y C r e".., 87) = 87

write(2, "\n", 1) = 1
shmget(5432010, 120, 0) Err#2 ENOENT
IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
size=120\
, permission=0write(2, " I p c M e m o r y I d G".., 93) = 93

write(2, "\n", 1) = 1
shmat(-2, 0, 0) Err#22 EINVAL

Am I doing something obviously wrong? Many thanks for advice.

(BTW, does the search function in the mailing list message archive work?
Trying simple, obvious search values like 'solaris' or 'linux' produces no
hits.)

-David.

From bouncefilter Tue Sep 28 00:09:13 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id AAA15301
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 00:05:23 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id AAA29671;
Tue, 28 Sep 1999 00:04:04 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909280404.AAA29671@candle.pha.pa.us>
Subject: Re: [GENERAL] Solaris 7 x86 error
In-Reply-To: <Pine.GSO.4.10.9909272038110.1098-100000@veetwin.myers.lan> from
myers at "Sep 27, 1999 08:49:06 pm"
To: myers <myers@iname.com>
Date: Tue, 28 Sep 1999 00:04:04 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

See Solaris FAQ on web site. That is newer.

Folks:

I get the following errors when trying to start up Postgres ('postmaster
-S') on a Solaris 7 x86 machine:

IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
permission=700
IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
size=120, permission=0
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment

The shared memory settings in /etc/system are:

set shmsys:shminfo_shmmax=50331648
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100

Compiler was gcc 2.95.1.

A truss of the postmaster process shows the following:

shmget(5432010, 120, 0700|IPC_CREAT) Err#22 EINVAL
IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
permis\
sion=700write(2, " I p c M e m o r y C r e".., 87) = 87

write(2, "\n", 1) = 1
shmget(5432010, 120, 0) Err#2 ENOENT
IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
size=120\
, permission=0write(2, " I p c M e m o r y I d G".., 93) = 93

write(2, "\n", 1) = 1
shmat(-2, 0, 0) Err#22 EINVAL

Am I doing something obviously wrong? Many thanks for advice.

(BTW, does the search function in the mailing list message archive work?
Trying simple, obvious search values like 'solaris' or 'linux' produces no
hits.)

-David.

************

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Wed Sep 29 00:09:27 1999
Received: from vpcit.ru (qmailr@dialup.vpcit.ru [195.38.52.246])
by hub.org (8.9.3/8.9.3) with SMTP id AAA83369
for <pgsql-general@postgreSQL.org>;
Wed, 29 Sep 1999 00:08:26 -0400 (EDT) (envelope-from yura@vpcit.ru)
Received: (qmail 11791 invoked from network); 29 Sep 1999 04:08:14 -0000
Received: from gercon.vpcit.ru (HELO vpcit.ru) (195.38.52.226)
by dialup.vpcit.ru with SMTP; 29 Sep 1999 04:08:14 -0000
Message-ID: <37F03F43.5E47A1E1@vpcit.ru>
Date: Tue, 28 Sep 1999 10:08:35 +0600
From: Yury Don <yura@vpcit.ru>
X-Mailer: Mozilla 4.61 [en] (Win98; I)
X-Accept-Language: ru,en
MIME-Version: 1.0
To: pgsql-general@postgreSQL.org
Subject: Buffer Leak
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit

Hi All!

I am doing the following:
begin;
declare c1 cursor for select * from pg_class;
fetch 1 in c1;
declare c2 cursor for select * from pg_tables;
fetch 1 in c2;
close c1;
close c2;
end;
and getting:
NOTICE: Buffer Leak: [034] (freeNext=-3, freePrev=-3, relname=pg_class,
blockNum=0, flags=0x4, refcount=1 2)
What does it mean?

Sincerely yours, Yury.
don.web-page.net, ICQ 11831432

From bouncefilter Tue Sep 28 00:19:11 1999
Received: from mta4.snfc21.pbi.net (mta4.snfc21.pbi.net [206.13.28.142])
by hub.org (8.9.3/8.9.3) with ESMTP id AAA18331
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 00:18:45 -0400 (EDT) (envelope-from myers@iname.com)
Received: from veetwin ([209.233.30.172])
by mta4.snfc21.pbi.net (Sun Internet Mail Server
sims.3.5.1999.05.24.18.28.p7)
with ESMTP id <0FIR00DZJ5B39K@mta4.snfc21.pbi.net> for
pgsql-general@postgreSQL.org; Mon, 27 Sep 1999 21:18:40 -0700 (PDT)
Date: Mon, 27 Sep 1999 21:20:31 -0700 (PDT)
From: myers <myers@iname.com>
Subject: Re: [GENERAL] Solaris 7 x86 error
In-reply-to: <199909280404.AAA29671@candle.pha.pa.us>
X-Sender: myers@veetwin.myers.lan
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: pgsql-general@postgreSQL.org
Message-id: <Pine.GSO.4.10.9909272117200.300-100000@veetwin.myers.lan>
MIME-version: 1.0
Content-type: TEXT/PLAIN; charset=US-ASCII

On Tue, 28 Sep 1999, Bruce Momjian wrote:

See Solaris FAQ on web site. That is newer.

Doesn't help -- at least, assuming you meant item 1.3 in that FAQ. I've
varied the shared memory settings from four megabytes to over 200. I
still get the same error.

I wonder if something changed for 2.7. It seems to me I've gotten this
working on 2.6 and under (albeit on Sparc CPUs).

-David.

From bouncefilter Tue Sep 28 00:46:13 1999
Received: from mulga.cs.mu.OZ.AU (mulga.cs.mu.OZ.AU [128.250.1.22])
by hub.org (8.9.3/8.9.3) with ESMTP id AAA25057
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 00:45:58 -0400 (EDT)
(envelope-from gob@cat.cs.mu.OZ.AU)
Received: from cat.cs.mu.OZ.AU (cat.cs.mu.OZ.AU [128.250.27.66]) by
mulga.cs.mu.OZ.AU with ESMTP
id OAA21000 for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 14:45:49 +1000 (EST)
Received: from toaster.cs.mu.OZ.AU (toaster.cs.mu.OZ.AU [128.250.26.2])
by cat.cs.mu.OZ.AU (8.9.3+Sun/8.9.1) with ESMTP id OAA17295
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 14:45:48 +1000 (EST)
Received: from localhost (gob@localhost)
by toaster.cs.mu.OZ.AU (8.9.3+Sun/8.9.1) with ESMTP id OAA28054
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 14:45:47 +1000 (EST)
X-Authentication-Warning: toaster.cs.mu.OZ.AU: gob owned process doing -bs
Date: Tue, 28 Sep 1999 14:45:46 +1000 (EST)
From: Greg Beams <gob@cat.cs.mu.OZ.AU>
X-Sender: gob@toaster.cs.mu.OZ.AU
To: pgsql-general@postgresql.org
Subject: [GENERAL] serial type
Message-ID: <Pine.GSO.4.05.9909281439001.27261-100000@toaster.cs.mu.OZ.AU>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

I'm trying to create a table as such:

create table comment
(rec_id serial,
locale varchar(50),
...)

It creates correctly, telling me that it will create an implicit sequence
for the serial column, and an implicit index for the table. But, when I
try to insert a record into the database (without specifying the value for
the rec_id column) I get the following error:

ERROR: serial.nextval: sequence does not exist

Does anyone have any ideas (I'm not sure whether this belongs on this
list, or the pgsql-sql list)?

Thanks, Greg.

Greg Beams - gob@students.cs.mu.oz.au

I'M NOT OKAY, YOU'RE NOT OKAY--BUT, HEY, THAT'S OKAY.

From bouncefilter Tue Sep 28 01:21:12 1999
Received: from proterians.net (IDENT:greg@chaos.proterians.net.pl
[195.117.150.130]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA31725
for <pgsql-general@hub.org>; Tue, 28 Sep 1999 01:20:40 -0400 (EDT)
(envelope-from greg@proterians.net)
From: greg@proterians.net
Received: from localhost (greg@localhost)
by proterians.net (8.9.2/8.9.1) with ESMTP id HAA13273;
Tue, 28 Sep 1999 07:23:19 +0200 (EEST)
Date: Tue, 28 Sep 1999 07:23:19 +0200 (EEST)
To: Bruce Momjian <maillist@candle.pha.pa.us>
cc: Dirk Lutzebaeck <lutzeb@aeccom.com>, pgsql-general@hub.org
Subject: Re: [GENERAL] backend crashing with INTERSECT / ORDER BY
In-Reply-To: <199909271850.OAA11558@candle.pha.pa.us>
Message-ID: <Pine.LNX.4.05.9909280721490.12179-100000@proterians.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1:

[csmaster@kamet release0]$ psql cs1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: cs1

cs1=> SELECT envelope FROM docobj
cs1-> WHERE attrid=5
cs1-> INTERSECT
cs1-> SELECT envelope FROM docobj
cs1-> WHERE attrid=6
cs1-> ORDER BY attrid DESC
cs1-> ;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.

Not sure. I just tried this:

test=> select relname from pg_class intersect select relname from
pg_class order by relname;
ERROR: get_sortgroupclause_expr: ORDER/GROUP BY expression not found in
targetlist

Not sure what this means either.

On 6.5.2 ....

test=> select relname from pg_class intersect select relname from
pg_class order by relname;

works fine...

--Greg--

From bouncefilter Tue Sep 28 02:11:13 1999
Received: from kiln.isn.net (root@kiln.isn.net [198.167.161.1])
by hub.org (8.9.3/8.9.3) with ESMTP id CAA37979
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 02:10:53 -0400 (EDT)
(envelope-from ctassell@isn.net)
Received: from niki (julia06.isn.net [198.167.161.174])
by kiln.isn.net (8.9.3/8.9.3) with SMTP id DAA13609
for <pgsql-general@postgreSQL.org>; Tue, 28 Sep 1999 03:14:25 -0300
Message-Id: <4.1.19990928031028.00942ba0@mailer.isn.net>
X-Sender: ctassell@mailer.isn.net
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1
Date: Tue, 28 Sep 1999 03:15:32 -0300
To: pgsql-general@postgreSQL.org
From: Charles Tassell <ctassell@isn.net>
Subject: Re: [GENERAL] serial type
In-Reply-To: <Pine.GSO.4.05.9909281439001.27261-100000@toaster.cs.mu.OZ.
AU>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

What is the syntax you are using for the insert?

This:

INSERT INTO comment VALUES (, 'Example');

or this

INSERT INTO comment (rec_id, locale) VALUES (, 'Example');

won't work. You have to *specifically* leave out the sequence field in
your field list, like this:

INSERT INTO comment (locale) VALUES ('Example');

It works the same for any default value, which is basically what a sequence
is (type sequence = int default nextval('sequence') )

At 01:45 AM 9/28/99, Greg Beams wrote:

I'm trying to create a table as such:

create table comment
(rec_id serial,
locale varchar(50),
...)

It creates correctly, telling me that it will create an implicit sequence
for the serial column, and an implicit index for the table. But, when I
try to insert a record into the database (without specifying the value for
the rec_id column) I get the following error:

ERROR: serial.nextval: sequence does not exist

Does anyone have any ideas (I'm not sure whether this belongs on this
list, or the pgsql-sql list)?

Thanks, Greg.

Greg Beams - gob@students.cs.mu.oz.au

I'M NOT OKAY, YOU'RE NOT OKAY--BUT, HEY, THAT'S OKAY.

************

From bouncefilter Tue Sep 28 04:30:13 1999
Received: from bbaer.muenster.de (root@bbaer.muenster.de [195.202.32.20])
by hub.org (8.9.3/8.9.3) with ESMTP id EAA58816
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 04:29:14 -0400 (EDT)
(envelope-from holger@klawitter.de)
Received: from klawitter.de (holger@mueamb-wan081.citykom.de [195.202.35.81])
by bbaer.muenster.de (8.8.8/8.8.8) with ESMTP id KAA21948
for <pgsql-general@postgreSQL.org>; Tue, 28 Sep 1999 10:09:16 +0200
Sender: holger@muenster.de
Message-ID: <37F077A7.A2F71446@klawitter.de>
Date: Tue, 28 Sep 1999 10:09:11 +0200
From: Holger Klawitter <holger@klawitter.de>
X-Mailer: Mozilla 4.51 [en] (X11; U; Linux 2.2.11 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgreSQL.org
Subject: 6.5.2 unter Solaris 2.6 feedback
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi there,

I compiled 6.5.2 on
Sun Ultra 2 UPA/SBus (UltraSPARC 200MHz); Single CPU with SunOS 5.6
using gcc. Deside moving the base dir to a local user dir I changed
nothing about the configuration options.

Starting "postmaster" I got the following error:

IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1073152,
permission=600
FATAL 1: ShmemCreate: cannot create region

Solaris 2.6 is not positively verified for Postgres 6.5.2. Does
that mean, that it cannot work, or is there a magic option?

Thanks in advance,
Holger Klawitter
--
Holger Klawitter +49 (0)251 484 0637
holger@klawitter.de http://www.klawitter.de/

From bouncefilter Tue Sep 28 05:30:33 1999
Received: from mailgw1.netvision.net.il (mailgw1.netvision.net.il
[194.90.1.14]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA70219
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 05:30:20 -0400 (EDT)
(envelope-from ethanc@congruency.com)
Received: from ethan (Kengeru-fr3.ser.netvision.net.il [199.203.174.97])
by mailgw1.netvision.net.il (8.9.3/8.9.3) with SMTP id LAA07834
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 11:30:10 +0200 (IST)
Message-ID: <006501bf0993$e53e6fa0$c91614c0@ethan>
From: "ciprut ethan" <ethanc@congruency.com>
To: <pgsql-general@postgresql.org>
Subject:
Date: Tue, 28 Sep 1999 11:28:58 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0062_01BF09A4.A7CE1290"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

This is a multi-part message in MIME format.

------=_NextPart_000_0062_01BF09A4.A7CE1290
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Regards,
ciprut ethan

------=_NextPart_000_0062_01BF09A4.A7CE1290
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV> </DIV>
<DIV><FONT size=3D2>Regards,<BR>ciprut ethan</FONT></DIV></BODY></HTML>

------=_NextPart_000_0062_01BF09A4.A7CE1290--

From bouncefilter Tue Sep 28 06:52:21 1999
Received: from genesis.sundayta.co.uk (mail.sundayta.co.uk [212.24.70.227])
by hub.org (8.9.3/8.9.3) with ESMTP id GAA81901
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 06:51:41 -0400 (EDT)
(envelope-from david@sundayta.co.uk)
Received: from romans.sundayta.co.uk
([192.168.100.28] helo=sundayta.co.uk ident=david)
by genesis.sundayta.co.uk with esmtp (Exim 3.03 #1 (Debian))
id 11VvVZ-0000GH-00; Tue, 28 Sep 1999 12:33:21 +0100
Sender: david
Message-ID: <37F0A1AD.29927E31@sundayta.co.uk>
Date: Tue, 28 Sep 1999 12:08:29 +0100
From: David Warnock <david@sundayta.co.uk>
Organization: Sundayta Ltd
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.9 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: Ted Nolan SRI Augusta GA <ted@ags.ga.erg.sri.com>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
References: <199909271854.OAA08445@ags.ga.erg.sri.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Ted,

Many thanks with this. I am about to travel quite a bit, I will try this
when I get back.

Dave

--
David Warnock
Sundayta Ltd

From bouncefilter Tue Sep 28 07:56:25 1999
Received: from cwb.pacific.net.hk (cwb.pacific.net.hk [202.14.67.92])
by hub.org (8.9.3/8.9.3) with ESMTP id HAA93339
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 07:55:39 -0400 (EDT)
(envelope-from s_kwan@gps.com.hk)
Received: from tsingyi.pacific.net.hk (tsingyi.pacific.net.hk [202.14.67.240])
by cwb.pacific.net.hk with ESMTP
id TAA05708 for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 19:55:37 +0800 (HKT)
Received: from NTSER4 (ppp114.dyn5.pacific.net.hk [202.64.5.114])
by tsingyi.pacific.net.hk with SMTP
id TAA01437 for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 19:55:36 +0800 (HKT)
Received: by NTSER4 with Microsoft Mail
id <01BF09EB.6E0E2AD0@NTSER4>; Tue, 28 Sep 1999 19:55:35 +0800
Message-ID: <01BF09EB.6E0E2AD0@NTSER4>
From: Simon Kwan <s_kwan@gps.com.hk>
To: "'pgsql-general@postgresql.org'" <pgsql-general@postgresql.org>
Subject: HELP: choosing between PostgreSQL vs MySQL
Date: Tue, 28 Sep 1999 19:49:43 +0800
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi greeting,
I am new to Linux.
Appreciate advise and comment on choosing between PosytgreSQL vs. MySQL.
Both to be run under Linux. How does these two database compare with MS SQL
7.0?

b) same as the about, but the image will be stored as one filed in the data
base. In this case, the data base will be much larger and wonder if it is
size is okay (speed, capacity, etc...)

TIA

Simon

From bouncefilter Tue Sep 28 09:02:40 1999
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id JAA03968
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 09:02:10 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id IAA14438;
Tue, 28 Sep 1999 08:44:16 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909281244.IAA14438@candle.pha.pa.us>
Subject: Re: [GENERAL] More than one transaction at the same time
In-Reply-To: <37EF4774.753680F6@vpcit.ru> from Yury Don at "Sep 27,
1999 04:31:16 pm"
To: Yury Don <yura@vpcit.ru>
Date: Tue, 28 Sep 1999 08:44:16 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

[Charset koi8-r unsupported, filtering to ASCII...]

Hi All!

Can I start 2 or more transactions simultaneously?
Task is in the following: I am startig transaction with the "begin",
then declare a cursor. Then I need to start another transaction in order
to do some things, but I don't want to close first transaction because
later I need to fetch frome created cursor.
Or I understand something wrongly?

We don't support nested transactions yet.
-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Tue Sep 28 10:14:41 1999
Received: from office.knowledge.com (office.knowledge.com [195.40.167.196])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA20590
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 10:13:41 -0400 (EDT)
(envelope-from Mark.Jewiss@knowledge.com)
Received: from mark (helo=localhost)
by office.knowledge.com with local-esmtp (Exim 2.10 #1)
id 11Vy0E-0001g5-00
for pgsql-general@postgresql.org; Tue, 28 Sep 1999 15:13:10 +0100
Date: Tue, 28 Sep 1999 15:13:10 +0100 (BST)
From: Mark Jewiss <Mark.Jewiss@knowledge.com>
To: pgsql-general@postgresql.org
Subject: Cusors in Perl DBI
Message-ID: <Pine.BSO.4.10.9909281512090.27171-100000@office.knowledge.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello,

I'm now in the middle of trying to write a small cgi to fetch data from a
table using cursors.

Does anyone have an example of how to do this?

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com

From bouncefilter Tue Sep 28 10:46:42 1999
Received: from armadint.teleord.co.uk (armadint.teleord.co.uk
[193.132.206.41])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA28311
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 10:46:27 -0400 (EDT)
(envelope-from davida@teleord.co.uk)
Received: from wombat.teleordering.co.uk (wombat.teleordering.co.uk
[172.17.4.7])
by armadint.teleord.co.uk (8.9.1a/8.9.1/DJH/TeleordA 3.0) with ESMTP id
OAA20291; Tue, 28 Sep 1999 14:38:12 GMT
Received: from davef (davef.teleordering.co.uk [172.17.4.88])
by wombat.teleordering.co.uk (8.8.6/8.8.6/DJH/TeleordW 2.2) with SMTP
id OAA28853; Tue, 28 Sep 1999 14:43:08 GMT
Message-Id: <199909281443.OAA28853@wombat.teleordering.co.uk>
From: "David Fury" <davida@teleord.co.uk>
To: pgsql-general@postgreSQL.org, Mark Jewiss <Mark.Jewiss@knowledge.com>
Date: Tue, 28 Sep 1999 15:51:53 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: [GENERAL] Cusors in Perl DBI
Reply-to: d.fury@teleord.co.uk
Priority: normal
In-reply-to: <Pine.BSO.4.10.9909281512090.27171-100000@office.knowledge.com>
X-mailer: Pegasus Mail for Win32 (v3.01d)

I'm now in the middle of trying to write a small cgi to fetch data from a
table using cursors.

Does anyone have an example of how to do this?

The info that you need is in a variety of places. Try

perldoc DBI

at the UNIX command line to get general DBI doc , or run pod2html
on the DBI source to get html versions of this. There is also a DBI
FAQ installed as part of the distrinbution.

perldoc DBD::Pg

will get you speciific Postgres DBD (driver) info.

Secondly, check out the DBI pages at

http://www.symbolstone.org/technology/perl/DBI/index.html

which will point you to various DBI-related resources (including
examples with cursors)

Hope this helps,

David

David Fury
Software Developer

Whitaker BookTrack

d.fury@teleord.co.uk Tel: 01252 742578

From bouncefilter Tue Sep 28 13:33:49 1999
Received: from mta2.snfc21.pbi.net (mta2.snfc21.pbi.net [206.13.28.123])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA61713
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 13:32:54 -0400 (EDT) (envelope-from myers@iname.com)
Received: from veetwin (adsl-209-233-30-172.dsl.snfc21.pacbell.net
[209.233.30.172])
by mta2.snfc21.pbi.net (8.9.3/8.9.3) with ESMTP id KAA18770;
Tue, 28 Sep 1999 10:32:44 -0700 (PDT)
Date: Tue, 28 Sep 1999 10:34:34 -0700 (PDT)
From: myers <myers@iname.com>
X-Sender: myers@veetwin.myers.lan
To: Bruce Momjian <maillist@candle.pha.pa.us>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Solaris 7 x86 error
In-Reply-To: <199909280404.AAA29671@candle.pha.pa.us>
Message-ID: <Pine.GSO.4.10.9909281029060.490-100000@veetwin.myers.lan>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

See Solaris FAQ on web site. That is newer.

Oops. Okay. Here's a lesson in getting too fancy. With the following
settings in /etc/system, Postgres does not work:

set shmsys:shminfo_shmmax=50000000
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100

Pare this down to the minimum, and Postgres *does* work:

set shmsys:shminfo_shmmax=50000000

Why, I don't know, especially since those extra shared memory directives
appear to exceed Postgres' requirements. But for the record, keep
/etc/system simple.

Thanks to Bruce for pointing me in the right direction.

-David.

From bouncefilter Tue Sep 28 14:33:49 1999
Received: from mbg.vsnl.net.in (mbg.vsnl.net.in [202.54.12.3])
by hub.org (8.9.3/8.9.3) with ESMTP id OAA74232
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 14:32:59 -0400 (EDT)
(envelope-from srishti@giasbg01.vsnl.net.in)
Received: from giasbg01.vsnl.net.in (PPP-191-20.bng.vsnl.net.in
[203.197.191.20])
by mbg.vsnl.net.in (8.9.1a/8.9.1) with ESMTP id AAA28815
for <pgsql-general@postgresql.org>;
Wed, 29 Sep 1999 00:10:43 +0500 (GMT+0500)
Message-ID: <37F10980.2D125881@giasbg01.vsnl.net.in>
Date: Wed, 29 Sep 1999 00:01:28 +0530
From: "Srishti Software Pvt. Ltd." <srishti@giasbg01.vsnl.net.in>
X-Mailer: Mozilla 4.05 [en] (WinNT; I)
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: clarifications needed on postgres/perl
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Hi!,
we are using postgresql(6.3.2-10) on red-hat linux 5.2.
we use perl-5 to access postgres.
the problem we have is :
we have a table having 13 fields, now when updating one of the fields
from the perl program, for more than 800 records, the following error
is
reported :
"FATAL 1: palloc failed: memory exhausted."
how ever when doing the same directly in psql monitor, there is no
error. also when the number of records to be updated are below 800
there
is no error.

We also changed the buffer size to 256, still we get an error like:

IpcMemoryCreate: memKey=155356396 , size=760632 ,
permission=384IpcMemoryCreate: shmget(..., create, ...)
failed: Invalid argument

i know I have to build IPC support into the Linux kernel. i
will have to rebuild the kernel and switch on this option.

can u please tell me how to do it.?

kindly suggest some remidies,
we will be very thankful.

looking forward to ur valuable suggestions very soon,
with best regards,
Team srishti.

From bouncefilter Tue Sep 28 14:36:53 1999
Received: from mbg.vsnl.net.in (mbg.vsnl.net.in [202.54.12.3])
by hub.org (8.9.3/8.9.3) with ESMTP id OAA74939
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 14:36:33 -0400 (EDT)
(envelope-from srishti@giasbg01.vsnl.net.in)
Received: from giasbg01.vsnl.net.in (PPP-191-20.bng.vsnl.net.in
[203.197.191.20])
by mbg.vsnl.net.in (8.9.1a/8.9.1) with ESMTP id AAA25479
for <pgsql-general@postgresql.org>;
Wed, 29 Sep 1999 00:14:20 +0500 (GMT+0500)
Message-ID: <37F10A59.1365D43F@giasbg01.vsnl.net.in>
Date: Wed, 29 Sep 1999 00:05:05 +0530
From: "Srishti Software Pvt. Ltd." <srishti@giasbg01.vsnl.net.in>
X-Mailer: Mozilla 4.05 [en] (WinNT; I)
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: clarifications needed on postgres/perl
X-Priority: 1 (Highest)
References: <37F10980.2D125881@giasbg01.vsnl.net.in>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Srishti Software Pvt. Ltd. wrote:

Hi!,
we are using postgresql(6.3.2-10) on red-hat linux 5.2.
we use perl-5 to access postgres.
the problem we have is :
we have a table having 13 fields, now when updating one of the fields
from the perl program, for more than 800 records, the following error
is
reported :
"FATAL 1: palloc failed: memory exhausted."
how ever when doing the same directly in psql monitor, there is no
error. also when the number of records to be updated are below 800
there
is no error.

We also changed the buffer size to 256, still we get an error like:

IpcMemoryCreate: memKey=155356396 , size=760632 ,
permission=384IpcMemoryCreate: shmget(..., create, ...)
failed: Invalid argument

i know I have to build IPC support into the Linux kernel. i
will have to rebuild the kernel and switch on this option.

can u please tell me how to do it.?

kindly suggest some remidies,
we will be very thankful.

looking forward to ur valuable suggestions very soon,
with best regards,
Team srishti.

From bouncefilter Tue Sep 28 16:47:54 1999
Received: from yima.gb.marcomm.com (yima.gb.marcomm.com [207.67.69.5])
by hub.org (8.9.3/8.9.3) with ESMTP id QAA96125
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 16:47:39 -0400 (EDT)
(envelope-from ivan@gb.marcomm.com)
Received: from mac-ivan.gb.marcomm.com (mac-ivan.gb.marcomm.com
[207.67.69.17])
by yima.gb.marcomm.com (8.8.8/8.8.8) with ESMTP id PAA27208;
Tue, 28 Sep 1999 15:45:32 -0500 (CDT)
Date: Tue, 28 Sep 1999 15:44:55 -0500 (CDT)
From: Ivan Richwalski <ivan@gb.marcomm.com>
To: myers <myers@iname.com>
cc: Bruce Momjian <maillist@candle.pha.pa.us>, pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Solaris 7 x86 error
In-Reply-To: <Pine.GSO.4.10.9909281029060.490-100000@veetwin.myers.lan>
Message-ID: <Pine.BOS.4.10.9909281507550.65376-100000@mac-ivan.gb.marcomm.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Tue, 28 Sep 1999, myers wrote:

Oops. Okay. Here's a lesson in getting too fancy. With the following
settings in /etc/system, Postgres does not work:

set shmsys:shminfo_shmmax=50000000
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100

Pare this down to the minimum, and Postgres *does* work:

set shmsys:shminfo_shmmax=50000000

Why, I don't know, especially since those extra shared memory directives
appear to exceed Postgres' requirements. But for the record, keep
/etc/system simple.

I think the problem is that you set shminfo_shmmin ( The
minimum size for a shared segment ) to 200 bytes. But in the truss
that you posted earlier, postmaster is trying to create a memory
segment that is too small:

shmget(5432010, 120, 0700|IPC_CREAT) Err#22 EINVAL

The man page for shmget has this in the ERRORS section:

EINVAL size is less than the system-imposed minimum
or greater than the system-imposed maximum.

EINVAL A shared memory identifier exists for key but
the size of the segment associated with it is
less than size and size is not equal to 0.

I've had some pretty good results with shminfo_shmmax=16777216
( Maximum size of any one shared memory segment is 16Meg ). This is
on an Ultra 1 with 256Meg of RAM running Solaris 2.6. Just make sure
to increase the number of buffers when you start the postmaster to
match the maximum size of your shared memory segments.

Ivan Richwalski.

From bouncefilter Tue Sep 28 17:05:51 1999
Received: from rns.roundnoon.com (alewis@unused147.ntaccess.com
[204.0.130.147] (may be forged))
by hub.org (8.9.3/8.9.3) with ESMTP id RAA99734
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 17:04:56 -0400 (EDT)
(envelope-from alewis@roundnoon.com)
Received: from localhost (alewis@localhost)
by rns.roundnoon.com (8.9.1/8.9.3) with ESMTP id QAA11954;
Tue, 28 Sep 1999 16:04:03 -0500
Date: Tue, 28 Sep 1999 16:04:03 -0500 (CDT)
From: Andy Lewis <alewis@roundnoon.com>
To: myers <myers@iname.com>
cc: Bruce Momjian <maillist@candle.pha.pa.us>, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Solaris 7 x86 error
In-Reply-To: <Pine.GSO.4.10.9909272117200.300-100000@veetwin.myers.lan>
Message-ID: <Pine.LNX.4.05.9909281602480.11920-100000@rns.roundnoon.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

I'm having the exact same problems on an Ultra 5 and Solaris 7.

What gives?

Thanks

Andy

On Mon, 27 Sep 1999, myers wrote:

On Tue, 28 Sep 1999, Bruce Momjian wrote:

See Solaris FAQ on web site. That is newer.

Doesn't help -- at least, assuming you meant item 1.3 in that FAQ. I've
varied the shared memory settings from four megabytes to over 200. I
still get the same error.

I wonder if something changed for 2.7. It seems to me I've gotten this
working on 2.6 and under (albeit on Sparc CPUs).

-David.

************

From bouncefilter Tue Sep 28 17:13:59 1999
Received: from bwn.net (mail.bwn.net [216.146.128.3])
by hub.org (8.9.3/8.9.3) with ESMTP id RAA01435
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 17:10:58 -0400 (EDT) (envelope-from jimcr@bwn.net)
Received: from bwn.net (IDENT:jimc@pkr22.bewell.net [216.146.152.22])
by bwn.net (8.9.3/8.9.3) with ESMTP id PAA01846;
Tue, 28 Sep 1999 15:10:54 -0600
Sender: jimc@bwn.net
Message-ID: <37F12EE9.E3E51252@bwn.net>
Date: Tue, 28 Sep 1999 15:11:05 -0600
From: Jim Cromie <jimcr@bwn.net>
X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.5-22 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
CC: jimcr@bwn.net
Subject: Referential Integrity functions for 2 different users
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Q: why do 2 different users have 2 different versions of
referential-integrity checks ?

Background: Ive done several different builds of 6.5.1 and 6.5.2
(from tar) on
linux (RH6.0), and ran refint.sql, and had some trouble with
regression tests.
Due to these probs (which showed as trigger-function errs), I
tried to
implement the Foreign Key checks as rules.

Bad idea perhaps, but my install didnt know about
check_primary_key(),
which is apparently needed to pass the regression tests.

FWIW, perhaps contrib should be under src (ie src/contrib) then
the
src/Makefile could automatically build it.

Anyway, the function-definitions stored w/in postgres for the 2
users
differ. For the bad one 'jimc', refint.example causes immediate

disconnection from the backend, its a broken configuration.

check_foreign_key| 500| 14|f |t
|f | 1|f | 16| 23 0 0 0 0 0 0
0| 100| 0| 0|
100|select true |-
check_primary_key| 500| 14|f |t
|f | 3|f | 16|23 23 23 0 0 0 0
0| 100| 0| 0|
100|select true as result|-
(2 rows)

-----------------+--------+-------+--------+------------+-------------+--------+---------+----------+---------------+-----------+--------------+--------------+--------------+------+-----------------------------------------------------

check_foreign_key| 501| 13|f |t
|t | 0|f | 0|0 0 0 0 0 0 0
0| 100| 0| 0| 100|-
|/home/postgres/postgresql-6.5.1/contrib/spi/refint.so
check_primary_key| 501| 13|f |t
|t | 0|f | 0|0 0 0 0 0 0 0
0| 100| 0| 0| 100|-
|/home/postgres/postgresql-6.5.1/contrib/spi/refint.so
(2 rows)

Note the lack of a .so for jimc,

I tried to drop function, which reported 'does not exist' for
both
functions, and and drop rule, which reported 'Rule or view $X
not
found'

Q2: So how do I delete these erroneous entries ? Theyre
apparently
associated with user 'jimc', possibly the database instance
itself.
Is it necessary to drop the jimc database ?

Q3: (rephrasing Q1) given that these functions are 6.5.1
specific (at
least in terms of where they reside in a standard build),
shouldnt
they be system-wide functions (and not over-ridden by
user-specific
settings ?

Q4: It seems that the pg_* tables are database specific, and not

site-wide. However, it doesnt jive with 'jimc's inability to do

'\i $HOME/v651/contrib/spi/refint.sql', which results in a lack
of
permission. If theyre database-specific (ie \connect jimc) why
cant I
delete them.

From bouncefilter Tue Sep 28 17:16:51 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id RAA02334
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 17:15:57 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id RAA04812
for pgsql-general@postgreSQL.org; Tue, 28 Sep 1999 17:15:07 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909282115.RAA04812@candle.pha.pa.us>
Subject: New FAQ items
To: PostgreSQL-general <pgsql-general@postgreSQL.org>
Date: Tue, 28 Sep 1999 17:15:07 -0400 (EDT)
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Here are two new FAQ items. They are on the web site, along with an
expanded TODO list.

---------------------------------------------------------------------------

4.22) How do I create a column that will default to the current time?

The tempation is to do:

create table test (x int, modtime timestamp default 'now');

but this makes the column default to the time of table creation, not the
time of row insertion.
Instead do:

CREATE TABLE test (x int, modtime timestamp default now() );

The calling of the function now() prevents the default value from being
computed at table creation time, and delays it until insertion time. We
believe this will not be a problem in post-6.5.* releases.

4.23) Why are my subqueries using IN so slow?

Currently, we join subqueries to outer queries by sequential scanning
the result of the subquery for each row of the outer query. A workaround
is to replace IN with EXISTS. For example, change:

SELECT *
FROM tab
WHERE col1 IN (SELECT col2 FROM TAB2)

to:

SELECT *
FROM tab
WHERE EXISTS (SELECT col2 FROM TAB2 WHERE col1 = col2)

We hope to fix this limitation in a future release.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Tue Sep 28 17:25:51 1999
Received: from yima.gb.marcomm.com (yima.gb.marcomm.com [207.67.69.5])
by hub.org (8.9.3/8.9.3) with ESMTP id RAA04382
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 17:25:47 -0400 (EDT)
(envelope-from ivan@seppuku.net)
From: ivan@seppuku.net
Received: from mac-ivan.gb.marcomm.com (mac-ivan.gb.marcomm.com
[207.67.69.17])
by yima.gb.marcomm.com (8.8.8/8.8.8) with ESMTP id QAA02126
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 16:25:46 -0500 (CDT)
Date: Tue, 28 Sep 1999 16:25:08 -0500 (CDT)
X-Sender: ivan@mac-ivan.gb.marcomm.com
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Solaris 7 x86 error
Message-ID: <Pine.BOS.4.10.9909281623050.73779-100000@mac-ivan.gb.marcomm.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Tue, 28 Sep 1999, myers wrote:

Oops. Okay. Here's a lesson in getting too fancy. With the following
settings in /etc/system, Postgres does not work:

set shmsys:shminfo_shmmax=50000000
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100

Pare this down to the minimum, and Postgres *does* work:

set shmsys:shminfo_shmmax=50000000

Why, I don't know, especially since those extra shared memory directives
appear to exceed Postgres' requirements. But for the record, keep
/etc/system simple.

shmget(5432010, 120, 0700|IPC_CREAT) Err#22 EINVAL

The man page for shmget has this in the ERRORS section:

EINVAL size is less than the system-imposed minimum
or greater than the system-imposed maximum.

EINVAL A shared memory identifier exists for key but
the size of the segment associated with it is
less than size and size is not equal to 0.

Ivan Richwalski.

From bouncefilter Tue Sep 28 17:45:51 1999
Received: from smtp2.usit.net (SMTP2.USIT.NET [199.1.48.42])
by hub.org (8.9.3/8.9.3) with ESMTP id RAA08819
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 17:45:35 -0400 (EDT)
(envelope-from shawn.pursley@acorncomputers.com)
Received: from shawn (DIALUP193.TNCOO.USIT.NET [216.80.176.67])
by smtp2.usit.net (8.9.2/8.9.2) with SMTP id RAA24414
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 17:44:07 -0400 (EDT)
Message-ID: <00e901bf09fa$ca229040$9f5305c7@go.servicetransport.com>
From: "Shawn Pursley" <shawn.pursley@acorncomputers.com>
To: <pgsql-general@postgreSQL.org>
References: <199909271618.MAA01702@candle.pha.pa.us>
Subject: Is there some type of Daemon that can look at pgsql?
Date: Tue, 28 Sep 1999 16:45:31 -0500
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

I'm trying to create a program that would look, at a specified interval of
every 15 seconds, at a database; if there is a new entry(which would be
specified as a field called IMSTAT), it would need to start a process of
copying a .tif file from a local drive and then create a dynamic HTML page
from this .tif. My end users would be passed an URL of this newly created
page.

After completing the dynamic page, then I would modify the db records to a
completed status and then the system would again check to see if any new
entries existed.

Is pgsql the way that you folks would do this or is there a better way/some
existing daemon that can monitor pgsql?

We currently run Apache 1.3.6
Postgres 6.4.2 (I know this needs to be upgraded)
on a Mandrake 5.2 box (essentially RH 6.0)

Thanks for any and all help,
Shawn

From bouncefilter Tue Sep 28 20:19:53 1999
Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id UAA30917
for pgsql-general@postgresql.org; Tue, 28 Sep 1999 20:19:07 -0400 (EDT)
(envelope-from news)
X-Authentication-Warning: hub.org: news set sender to <news> using -f
From: Stephane Alnet <stephane@u-picardie.fr>
X-Newsgroups: comp.databases.postgresql.general
Subject: Re: [GENERAL] encrypted field
Date: Tue, 28 Sep 1999 20:14:32 -0400
Organization: Boston University
Lines: 22
Message-ID: <37F159E8.632A04AA@u-picardie.fr>
References: <19990917131234.A3394@wallace.ece.rice.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12 i686)
X-Accept-Language: en, French, fr
To: pgsql-general@postgresql.org

PS: Note that all crypted passwords are created with salt "HP" (my name
initials..) You can change that, or if you know C, you can do in a way that it
will pick two random characters (the way it should really be).

One quick remark: if you are serious about using hash (not encryption, strictly
speaking) as a protection: having a *random* salt is an important part of using
crypt(). "Static salt" (sounds weird, huh) reduces the strength of the algorithm
a lot.

I also ran into a 'gotcha': crypt expects zero terminated
strings, pg text type is a counted string.
[...] anyone have any improvements, let me know

To avoid this "gotcha" and at the same time provide quality "hash", you may want
to look into functions like MD5 or SHA-1 which will accept anything as input (a
bit stream!) and generate a fixed-length, ASCII-text result.

St��phane

PS: I have a working implementation of SHA-1 in C, if someone has the time /
experience / need to write a wrapper for pgsql... ;)

From bouncefilter Tue Sep 28 20:21:01 1999
Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id UAA31257
for pgsql-general@postgresql.org; Tue, 28 Sep 1999 20:20:11 -0400 (EDT)
(envelope-from news)
X-Authentication-Warning: hub.org: news set sender to <news> using -f
From: Stephane Alnet <stephane@u-picardie.fr>
X-Newsgroups: comp.databases.postgresql.general
Subject: Re: [GENERAL] encrypted field
Date: Tue, 28 Sep 1999 20:15:38 -0400
Organization: Boston University
Lines: 22
Message-ID: <37F15A2A.82C50D3B@u-picardie.fr>
References: <19990917131234.A3394@wallace.ece.rice.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12 i686)
X-Accept-Language: en, French, fr
To: pgsql-general@postgreSQL.org

PS: Note that all crypted passwords are created with salt "HP" (my name
initials..) You can change that, or if you know C, you can do in a way that it
will pick two random characters (the way it should really be).

I also ran into a 'gotcha': crypt expects zero terminated
strings, pg text type is a counted string.
[...] anyone have any improvements, let me know

St��phane

PS: I have a working implementation of SHA-1 in C, if someone has the time /
experience / need to write a wrapper for pgsql... ;)

From bouncefilter Tue Sep 28 21:08:55 1999
Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id VAA40184
for pgsql-general@postgresql.org; Tue, 28 Sep 1999 21:08:23 -0400 (EDT)
(envelope-from news)
X-Authentication-Warning: hub.org: news set sender to <news> using -f
From: Stephane Alnet <stephane@u-picardie.fr>
X-Newsgroups: comp.databases.postgresql.general
Subject: Re: [GENERAL] encrypted field
Date: Tue, 28 Sep 1999 20:16:16 -0400
Organization: Boston University
Lines: 23
Message-ID: <37F15A50.AE38F348@u-picardie.fr>
References: <19990917131234.A3394@wallace.ece.rice.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12 i686)
X-Accept-Language: en, French, fr
To: pgsql-general@postgresql.org

PS: Note that all crypted passwords are created with salt "HP" (my name
initials..) You can change that, or if you know C, you can do in a way that it
will pick two random characters (the way it should really be).

I also ran into a 'gotcha': crypt expects zero terminated
strings, pg text type is a counted string.
[...] anyone have any improvements, let me know

St��phane

PS: I have a working implementation of SHA-1 in C, if someone has the time /
experience / need to write a wrapper for pgsql... ;)

From bouncefilter Tue Sep 28 20:22:53 1999
Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id UAA31452
for pgsql-general@postgresql.org; Tue, 28 Sep 1999 20:22:13 -0400 (EDT)
(envelope-from news)
X-Authentication-Warning: hub.org: news set sender to <news> using -f
From: Stephane Alnet <stephane@u-picardie.fr>
X-Newsgroups: comp.databases.postgresql.general
Subject: cancel <37F15A2A.82C50D3B@u-picardie.fr>
Control: cancel <37F15A2A.82C50D3B@u-picardie.fr>
Date: Tue, 28 Sep 1999 20:17:38 -0400
Organization: Boston University
Lines: 1
Message-ID: <7srm3d$6ea$1@news1.bu.edu>
References: <37F15A2A.82C50D3B@u-picardie.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12 i686)
X-Accept-Language: en, French, fr
To: pgsql-general@postgreSQL.org

This message was cancelled from within Mozilla.

From bouncefilter Tue Sep 28 23:14:55 1999
Received: from thelab.hub.org (nat194.229.mpoweredpc.net [142.177.194.229])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA70698
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 23:14:37 -0400 (EDT) (envelope-from scrappy@hub.org)
Received: from localhost (scrappy@localhost)
by thelab.hub.org (8.9.3/8.9.1) with ESMTP id AAA57804;
Wed, 29 Sep 1999 00:14:24 -0300 (ADT) (envelope-from scrappy@hub.org)
X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs
Date: Wed, 29 Sep 1999 00:14:23 -0300 (ADT)
From: The Hermit Hacker <scrappy@hub.org>
To: David Heinecke <dheinecke@axent.com>
cc: Bruce Momjian <maillist@candle.pha.pa.us>, pgsql-general@postgreSQL.org
Subject: RE: [GENERAL] Anyone doing a native NT port?
In-Reply-To:
<8A34CE6287D8D211AB0600A0C9D182235D2AD3@raven.rockville.axent.com>
Message-ID: <Pine.BSF.4.10.9909290014040.33998-100000@thelab.hub.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Just curious, but why is using the CyWin stuff not an option? *raised
eyebrow*

On Mon, 27 Sep 1999, David Heinecke wrote:

Yeah,

That is pretty much the short of it. My greatest concern undertaking an
effort like this is the resultant #ifdef/#else/#endif mess that I will need
to make of the code. We do a lot of cross-platform development here and
ultimately the code begins to look very ugly to anything except a
preprocessor. The alternative is to put most of the nt-specific code in
separate files, but then we would have to merge over the newer code from the
CVS repository. It is not a job that I look forward to, but our unix
customers are clamoring for PostGRE on the backend and our non-unix
customers are not going to be satisfied with MySQL. Sucks to be me, I
guess.

Dave Heinecke
Senior Software Engineer
Axent Technologies

-----Original Message-----
From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
Sent: Monday, September 27, 1999 10:47 AM
To: David Heinecke
Cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Anyone doing a native NT port?

Hello,

My company is pretty impressed with postgre on unix, but we also need a
native port for nt (it is not an option to have our customers install

cygwin

on their production systems.) Ideally we would like to see the backend
running as a native service under nt. We have the resources to do the

port

ourselves (I will probably end up doing the work myself), but I was
wondering if there was already an effort underway to develop something

like

this.

Yikes, you want to run the PostgreSQL backend without Unix simulator
support! Wow, that sounds like a big job.

I know of no one who has done this. You can see from the FAQ item that
people have running under U/Win too, but I that is a Unix emulator too.

Seems like you would basically be writing another emulator for NT to do
the things we do under Unix, no?
-- 
Bruce Momjian                        |  http://www.op.net/~candle
maillist@candle.pha.pa.us            |  (610) 853-3000
+  If your life is a hard drive,     |  830 Blythe Avenue
+  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
************

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

From bouncefilter Tue Sep 28 23:16:56 1999
Received: from thelab.hub.org (nat194.229.mpoweredpc.net [142.177.194.229])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA71179
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 23:16:32 -0400 (EDT) (envelope-from scrappy@hub.org)
Received: from localhost (scrappy@localhost)
by thelab.hub.org (8.9.3/8.9.1) with ESMTP id AAA57818;
Wed, 29 Sep 1999 00:15:57 -0300 (ADT) (envelope-from scrappy@hub.org)
X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs
Date: Wed, 29 Sep 1999 00:15:57 -0300 (ADT)
From: The Hermit Hacker <scrappy@hub.org>
To: David Warnock <david@sundayta.co.uk>
cc: Bruce Momjian <maillist@candle.pha.pa.us>,
David Heinecke <dheinecke@axent.com>, pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To: <37EFAD68.85A178ED@sundayta.co.uk>
Message-ID: <Pine.BSF.4.10.9909290015230.33998-100000@thelab.hub.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Mon, 27 Sep 1999, David Warnock wrote:

Bruce,

As I am not going to be able to help on the coding I won't try to
comment on it's dificulty.

But I will ask what realistic expectations are for the current NT port
using cgywin. My current concern is that the installation is very
complex and the useability is poor due to the need to enter a cgywin
shell to access any of the postgresql features.

So

a) Is it going to be possible using cgywin to build binaries
(postmaster, createdb, psql etc) that can be run from a standard windows
NT command prompt? Or will a cgywin shell always be needed? If this can
be done then so that we can provide an installation of binaries with no
unix shell visible then we can probably get this accepted by our users.

pgAdmin should provide you with this, no?

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

From bouncefilter Tue Sep 28 23:30:24 1999
Received: from dfw-ix10.ix.netcom.com (dfw-ix10.ix.netcom.com [206.214.98.10])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA74301
for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 23:29:46 -0400 (EDT)
(envelope-from drfrog@smartt.com)
Received: (from smap@localhost) by dfw-ix10.ix.netcom.com (8.8.4/8.8.4)
id WAA20213 for <pgsql-general@postgresql.org>;
Tue, 28 Sep 1999 22:29:12 -0500 (CDT)
Received: from 00-10-4b-66-ed-f1.bconnected.net(209.53.22.49) by
dfw-ix10.ix.netcom.com via smap (V1.3)
id rma019652; Tue Sep 28 22:26:39 1999
Sender: DrFrog@ix.netcom.com
Message-ID: <37F1897F.77356006@smartt.com>
Date: Wed, 29 Sep 1999 03:37:35 +0000
From: Clayton Cottingham <drfrog@smartt.com>
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.3.2 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: new irc channel
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

hiya

ive set up a new irc chat {with some help of course!} for database users

on irc.stampede.org
called #dbms

please come on in and join the discussions!

From bouncefilter Tue Sep 28 23:49:35 1999
Received: from mustang.sdc.com.au (mustang.sdc.com.au [203.2.199.1])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA79169
for <pgsql-general@postgreSQL.org>;
Tue, 28 Sep 1999 23:49:22 -0400 (EDT)
(envelope-from scldad@mustang.sdc.com.au)
Received: from mustang.sdc.com.au (localhost [127.0.0.1])
by mustang.sdc.com.au (8.9.1a/8.9.1) with ESMTP id NAA04822;
Wed, 29 Sep 1999 13:15:29 +0930
Message-Id: <199909290345.NAA04822@mustang.sdc.com.au>
X-Mailer: exmh version 2.0.3 3/23/99
To: The Hermit Hacker <scrappy@hub.org>
cc: Bruce Momjian <maillist@candle.pha.pa.us>,
David Heinecke <dheinecke@axent.com>, pgsql-general@postgreSQL.org,
David Warnock <david@sundayta.co.uk>
Subject: Re: [GENERAL] Anyone doing a native NT port?
In-Reply-To: Message from The Hermit Hacker <scrappy@hub.org> of "Wed,
29 Sep 1999 00:15:57 -0300."
<Pine.BSF.4.10.9909290015230.33998-100000@thelab.hub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Wed, 29 Sep 1999 13:15:29 +0930
From: Stephen Davies <scldad@sdc.com.au>

You do NOT have to run a cygwin shell to run binaries built under cygwin.

I use cygwin to build .exe and .dll files that run from an NT/DOS prompt and
from PERL scripts running as CGI.

The only requirement is that the primary cygwin.dll be in the NT path
somewhere.

I even run vi under NT;-))

Cheers,
Stephen.

The Hermit Hacker <scrappy@hub.org> wrote:

On Mon, 27 Sep 1999, David Warnock wrote:

Bruce,

As I am not going to be able to help on the coding I won't try to
comment on it's dificulty.

But I will ask what realistic expectations are for the current NT port
using cgywin. My current concern is that the installation is very
complex and the useability is poor due to the need to enter a cgywin
shell to access any of the postgresql features.

So

a) Is it going to be possible using cgywin to build binaries
(postmaster, createdb, psql etc) that can be run from a standard windows
NT command prompt? Or will a cgywin shell always be needed? If this can
be done then so that we can provide an installation of binaries with no
unix shell visible then we can probably get this accepted by our users.

pgAdmin should provide you with this, no?

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

************

--
========================================================================
Stephen Davies Consulting scldad@sdc.com.au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133

From bouncefilter Wed Sep 29 01:21:27 1999
Received: from sapphire.albourne.com (root@sapphire.albourne.com
[195.212.241.227]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA94210
for <pgsql-general@postgreSQL.org>;
Wed, 29 Sep 1999 01:21:04 -0400 (EDT)
(envelope-from a.joubert@albourne.com)
Received: from isadora.cy.albourne.com (akamas.albourne.com [195.212.241.254])
by sapphire.albourne.com (8.9.3/8.9.3/Albourne/CYS/1.6X) with ESMTP
id IAA00926; Wed, 29 Sep 1999 08:23:40 +0300 (EET DST)
Received: from albourne.com (localhost [127.0.0.1])
by isadora.cy.albourne.com (8.9.3/8.9.3/Albourne/CYC/1.4) with ESMTP id
IAA04031; Wed, 29 Sep 1999 08:20:58 +0300 (EET DST)
Sender: a.joubert@albourne.com
Message-ID: <37F1A1BA.30CE727D@albourne.com>
Date: Wed, 29 Sep 1999 08:20:58 +0300
From: Adriaan Joubert <a.joubert@albourne.com>
Organization: APL Financial Services (Overseas) Ltd
X-Mailer: Mozilla 4.61 [en] (X11; U; OSF1 V4.0 alpha)
X-Accept-Language: en
MIME-Version: 1.0
To: Shawn Pursley <shawn.pursley@acorncomputers.com>
CC: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Is there some type of Daemon that can look at pgsql?
References: <199909271618.MAA01702@candle.pha.pa.us>
<00e901bf09fa$ca229040$9f5305c7@go.servicetransport.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Shawn Pursley wrote:

I'm trying to create a program that would look, at a specified interval of
every 15 seconds, at a database; if there is a new entry(which would be
specified as a field called IMSTAT), it would need to start a process of
copying a .tif file from a local drive and then create a dynamic HTML page
from this .tif. My end users would be passed an URL of this newly created
page.

After completing the dynamic page, then I would modify the db records to a
completed status and then the system would again check to see if any new
entries existed.

Is pgsql the way that you folks would do this or is there a better way/some
existing daemon that can monitor pgsql?

Do it with perl and use DBI/DBD-Pg or the perl interface that comes with
postgres to talk to the database. That is almost certainly the easiest
way, and you can either launch it from cron (perhaps not the right thing
for something that has got to run every 15 seconds), or turn it into a
daemon with some of the modules in CPAN. If I remember correctly the
Perl cookbook shows how to do most of the bits and pieces you'll need.

Adriaan

From bouncefilter Wed Sep 29 09:01:30 1999
Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id JAA63836
for <pgsql-general@postgreSQL.org>;
Wed, 29 Sep 1999 09:01:04 -0400 (EDT)
(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
by candle.pha.pa.us (8.9.0/8.9.0) id IAA24975;
Wed, 29 Sep 1999 08:59:52 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909291259.IAA24975@candle.pha.pa.us>
Subject: Re: [GENERAL] Buffer Leak
In-Reply-To: <37F03F43.5E47A1E1@vpcit.ru> from Yury Don at "Sep 28,
1999 10:08:35 am"
To: Yury Don <yura@vpcit.ru>
Date: Wed, 29 Sep 1999 08:59:52 -0400 (EDT)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL56 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

[Charset koi8-r unsupported, filtering to ASCII...]

Hi All!

I am doing the following:
begin;
declare c1 cursor for select * from pg_class;
fetch 1 in c1;
declare c2 cursor for select * from pg_tables;
fetch 1 in c2;
close c1;
close c2;
end;
and getting:
NOTICE: Buffer Leak: [034] (freeNext=-3, freePrev=-3, relname=pg_class,
blockNum=0, flags=0x4, refcount=1 2)
What does it mean?

I don't see that in the current source tree.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Wed Sep 29 16:20:47 1999
Received: from hotmail.com (law-f282.hotmail.com [209.185.130.221])
by hub.org (8.9.3/8.9.3) with SMTP id QAA51406
for <pgsql-general@postgreSQL.org>;
Wed, 29 Sep 1999 16:20:28 -0400 (EDT)
(envelope-from amycq@hotmail.com)
Received: (qmail 44315 invoked by uid 0); 29 Sep 1999 20:13:27 -0000
Message-ID: <19990929201327.44314.qmail@hotmail.com>
Received: from 216.61.142.192 by www.hotmail.com with HTTP;
Wed, 29 Sep 1999 13:13:27 PDT
X-Originating-IP: [216.61.142.192]
From: "amy cheng" <amycq@hotmail.com>
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Anyone doing a native NT port?
Date: Wed, 29 Sep 1999 13:13:27 PDT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

I even run vi under NT;-))

sorry if distract you. is it possble for win95? I love viANDemacs,
why not wordpad etc? because of regular expression (esp. Vim ).
so, anybody know free software editor on win95 that support regular
expression?

thanks!

amy

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Wed Sep 29 16:20:50 1999
Received: from hotmail.com (law-f42.hotmail.com [209.185.131.105])
by hub.org (8.9.3/8.9.3) with SMTP id QAA51373
for <pgsql-general@postgresql.org>;
Wed, 29 Sep 1999 16:20:17 -0400 (EDT)
(envelope-from amycq@hotmail.com)
Received: (qmail 11007 invoked by uid 0); 29 Sep 1999 20:19:45 -0000
Message-ID: <19990929201945.11006.qmail@hotmail.com>
Received: from 216.61.142.192 by www.hotmail.com with HTTP;
Wed, 29 Sep 1999 13:19:45 PDT
X-Originating-IP: [216.61.142.192]
From: "amy cheng" <amycq@hotmail.com>
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Is there some type of Daemon that can look at pgsql?
Date: Wed, 29 Sep 1999 13:19:45 PDT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

kind of weird. why polling? where comes from the picture? Seems to
me the picture-uploading process should do those. Or, -- if that
uploading process is somebody else's business, you should
get a trigger within the db: wirte it in C (with in turn, you can
use system() and call a perl program) (and then call it in PL/pgSQL). --
note that seems that PL/pgSQL can not be used to
handle OS directly.

amy

From: Adriaan Joubert <a.joubert@albourne.com>
To: Shawn Pursley <shawn.pursley@acorncomputers.com>
CC: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Is there some type of Daemon that can look at pgsql?
Date: Wed, 29 Sep 1999 08:20:58 +0300

Shawn Pursley wrote:

I'm trying to create a program that would look, at a specified interval

every 15 seconds, at a database; if there is a new entry(which would be
specified as a field called IMSTAT), it would need to start a process of
copying a .tif file from a local drive and then create a dynamic HTML

page

from this .tif. My end users would be passed an URL of this newly

created

page.

After completing the dynamic page, then I would modify the db records to

completed status and then the system would again check to see if any new
entries existed.

Is pgsql the way that you folks would do this or is there a better

way/some

existing daemon that can monitor pgsql?

Adriaan

************

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Wed Sep 29 09:35:43 1999
Received: from trends.net (clio.trends.ca [209.47.148.2])
by hub.org (8.9.3/8.9.3) with ESMTP id JAA68590
for <pgsql-general@postgresql.org>;
Wed, 29 Sep 1999 09:34:41 -0400 (EDT)
(envelope-from sean.ellis@oscenter.com)
Received: from algorithm.oscenter.com (root@algorithm.oscenter.com
[12.18.95.132]) by trends.net (8.8.8/8.8.8) with ESMTP id JAA26932
for <pgsql-general@postgresql.org>;
Wed, 29 Sep 1999 09:22:08 -0400 (EDT)
Received: from oscenter.com (bits@localhost [127.0.0.1])
by algorithm.oscenter.com (8.9.3/8.9.3) with ESMTP id IAA29953;
Wed, 29 Sep 1999 08:21:13 -0500
Sender: bits@algorithm.oscenter.com
Message-ID: <37F21249.B93836AB@oscenter.com>
Date: Wed, 29 Sep 1999 08:21:13 -0500
From: "Sean W. Ellis" <sean.ellis@oscenter.com>
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Shawn Pursley <shawn.pursley@acorncomputers.com>,
pgsql-general@postgresql.org
Subject: Re: [GENERAL] Is there some type of Daemon that can look at pgsql?
References: <199909271618.MAA01702@candle.pha.pa.us>
<00e901bf09fa$ca229040$9f5305c7@go.servicetransport.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Shawn Pursley wrote:

I'm trying to create a program that would look, at a specified interval of
every 15 seconds, at a database; if there is a new entry(which would be
specified as a field called IMSTAT), it would need to start a process of
copying a .tif file from a local drive and then create a dynamic HTML page
from this .tif. My end users would be passed an URL of this newly created
page.

After completing the dynamic page, then I would modify the db records to a
completed status and then the system would again check to see if any new
entries existed.

Is pgsql the way that you folks would do this or is there a better way/some
existing daemon that can monitor pgsql?

We currently run Apache 1.3.6
Postgres 6.4.2 (I know this needs to be upgraded)
on a Mandrake 5.2 box (essentially RH 6.0)

Thanks for any and all help,
Shawn

************

in crontab have:

*/15 * * * * /usr/local/sbin/runme 1> /dev/null 2> /dev/null

runme can just be a perl script that connects, checks a value, performs
a copy if needed. I do this all the time for automating stuff. I have
stuff that runs every minute instead of 15, but the principal is the
same. If you need the perl code as an example, please let me know.

--
Sean W. Ellis, ASE/CNE 6586538
Office Systems Center, 110 N. Main, Victoria, TX 77901
UNIX: Because reboots are for hardware upgrades...

From bouncefilter Wed Sep 29 12:28:19 1999
Received: from trends.net (clio.trends.ca [209.47.148.2])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA04222
for <pgsql-general@postgresql.org>;
Wed, 29 Sep 1999 12:28:07 -0400 (EDT)
(envelope-from Mark.Jewiss@knowledge.com)
Received: from office.knowledge.com (office.knowledge.com [195.40.167.196])
by trends.net (8.8.8/8.8.8) with ESMTP id MAA07617
for <pgsql-general@postgresql.org>;
Wed, 29 Sep 1999 12:11:42 -0400 (EDT)
Received: from mark (helo=localhost)
by office.knowledge.com with local-esmtp (Exim 2.10 #1)
id 11WMJz-0005TN-00
for pgsql-general@postgresql.org; Wed, 29 Sep 1999 17:11:11 +0100
Date: Wed, 29 Sep 1999 17:11:11 +0100 (BST)
From: Mark Jewiss <Mark.Jewiss@knowledge.com>
To: pgsql-general@postgresql.org
Subject: Request for a large data set
Message-ID: <Pine.BSO.4.10.9909291709340.5608-100000@office.knowledge.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello,

I want to do some testing on a large set of data to see how various things
I'm writing will hold up.

Does anyone have a large data set that they could make available somewhere
for me to grab via ftp? I'm after a csv file that I can read into a db
here.

Something along the lines of a million rows of data would be good - a
phone book or some such thing would be ideal.

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com

From bouncefilter Wed Sep 29 19:27:14 1999
Received: from trends.net (clio.trends.ca [209.47.148.2])
by hub.org (8.9.3/8.9.3) with ESMTP id TAA88115
for <pgsql-general@postgreSQL.org>;
Wed, 29 Sep 1999 19:26:29 -0400 (EDT)
(envelope-from darold@neptune.fr)
Received: from neptune.fr (root@titan.neptune.fr [194.2.77.2])
by trends.net (8.8.8/8.8.8) with ESMTP id TAA01090
for <pgsql-general@postgreSQL.org>;
Wed, 29 Sep 1999 19:19:04 -0400 (EDT)
Received: from neptune.fr (IDENT:develop@ppp2.neptune.fr [194.2.77.35])
by neptune.fr (8.9.3/8.9.3) with ESMTP id BAA25454
for <pgsql-general@postgreSQL.org>; Thu, 30 Sep 1999 01:18:56 +0200
Sender: develop@neptune.fr
Message-ID: <37F2A022.F7B4BFC1@neptune.fr>
Date: Wed, 29 Sep 1999 23:26:26 +0000
From: Gilles Darold <darold@neptune.fr>
Reply-To: darold@neptune.fr
X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgreSQL.org
Subject: createdb error
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi all,

I have a problem with createdd on a remote server. It runs 6.3.2.

% createdb foo
ERROR: parser: parse error at or near ""
createdb: database creation failed on foo.

Does anyone know what does it means ?

(/usr/local/pgsql/bin/postmaster -i -S -D /usr/local/pgsql/data )

Thanks.

Gilles Darold

From bouncefilter Thu Sep 30 03:25:45 1999
Received: from ns1.prima.net.id ([202.57.0.8])
by hub.org (8.9.3/8.9.3) with ESMTP id DAA79274
for <pgsql-general@postgresql.org>;
Thu, 30 Sep 1999 03:25:06 -0400 (EDT)
(envelope-from chai@prima.net.id)
Received: from prima.net.id (chai@[202.57.0.54]) by ns1.prima.net.id
(8.8.4/8.7.2) with ESMTP id HAA07961 for
<pgsql-general@postgresql.org>; Thu, 30 Sep 1999 07:29:15 +0700 (GMT)
Sender: chai@ns1.prima.net.id
Message-ID: <37F31031.5F50A983@prima.net.id>
Date: Thu, 30 Sep 1999 14:24:33 +0700
From: Chairudin Sentosa Harjo <chai@prima.net.id>
Reply-To: chai@prima.net.id
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.10 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Constraint Problem
References: <199909300433.AAA52816@hub.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Dear Friends,

I have a very wierd problem. It should be obvious, but I can't
understand why.

I am using Postgresql 6.5.2, SuSe 6.2, Pentium III, Kernel Linux 2.2.10.

Please notice the error, it keeps saying ck_ngetest_disc_pin,
ck_ngetest_disc_country
is the cause of the problem.
I have inserted the correct value, but why keep giving error???

The wierdest part is, when I insert a value to field "disc_all", the
error mentioned
"ck_ngetest_disc_pin" !!!.... If the constraint was violated, the error
message
should be "ck_ngetest_disc_all".

create table ngetest
(
custnum int8 NOT NULL,
first_name varchar(15) NOT NULL,
service_type char NOT NULL,
sex char NOT NULL,
detailed_bill char NOT NULL,
ngetest_status char NOT NULL,
disc_all char,
disc_country char,
disc_pin char,

constraint pk_ngetest PRIMARY KEY (custnum),

constraint ck_ngetest_service_type check
(service_type = 'Y' or
service_type = 'N' or
service_type = 'G' or
service_type = 'M' or
service_type = 'O' or
service_type = 'D'),

constraint ck_ngetest_status check
(ngetest_status = 'A' or
ngetest_status = 'I' or
ngetest_status = 'S' or
ngetest_status = 'T'),

constraint ck_ngetest_disc_all check
(disc_all = 'Y' or
disc_all = 'N'),
constraint ck_ngetest_disc_country check
(disc_country = 'Y' or
disc_country = 'N'),
constraint ck_ngetest_disc_pin check
(disc_pin = 'Y' or
disc_pin = 'N')
);

insert into ngetest
(custnum, first_name, service_type, sex, detailed_bill, ngetest_status,
disc_all)
values
(1,'Bob','Y','M','Y','A','Y');
ERROR: ExecAppend: rejected due to CHECK constraint ck_ngetest_disc_pin

insert into ngetest
(custnum, first_name, service_type, sex, detailed_bill, ngetest_status,
disc_country)
values
(2,'Mike','Y','M','Y','A','Y');
ERROR: ExecAppend: rejected due to CHECK constraint ck_ngetest_disc_pin

insert into ngetest
(custnum, first_name, service_type, sex, detailed_bill, ngetest_status,
disc_pin)
values
(3,'John','Y','M','Y','A','Y');
ERROR: ExecAppend: rejected due to CHECK constraint
ck_ngetest_disc_country

Regards,
Chairudin Sentosa

From bouncefilter Thu Sep 30 05:05:47 1999
Received: from oxmail.ox.ac.uk (oxmail3.ox.ac.uk [163.1.2.9])
by hub.org (8.9.3/8.9.3) with ESMTP id FAA93028
for <pgsql-general@postgresql.org>;
Thu, 30 Sep 1999 05:05:16 -0400 (EDT)
(envelope-from moray.mcconnachie@computing-services.oxford.ac.uk)
Received: from heraldgate2.oucs.ox.ac.uk
([163.1.2.50] helo=frontend2.herald.ox.ac.uk ident=exim)
by oxmail.ox.ac.uk with esmtp (Exim 2.10 #1)
id 11Wc9G-00054N-00; Thu, 30 Sep 1999 10:05:10 +0100
Received: from moraypc.oucs.ox.ac.uk ([163.1.14.118] helo=moraypc)
by frontend2.herald.ox.ac.uk with smtp (Exim 2.02 #1)
id 11Wc9G-0008Su-00; Thu, 30 Sep 1999 10:05:10 +0100
Message-ID: <004d01bf0b22$e4e63930$760e01a3@oucs.ox.ac.uk>
From: "Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk>
To: "amy cheng" <amycq@hotmail.com>, <pgsql-general@postgresql.org>
References: <19990929201327.44314.qmail@hotmail.com>
Subject: Re: [GENERAL] Anyone doing a native NT port?
Date: Thu, 30 Sep 1999 10:05:08 +0100
Organization: Oxford University
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

Simplest of internet searches e.g. at Yahoo on Emacs would give you
http://www.cs.washington.edu/homes/voelker/ntemacs.html
With full instructions about emacs for NT.
Similarly, vim - see http://www.vim.org/

Might be better if you searched the net *before* posting questions of
this type.

M.
----------------------------------------------------------------------
----------------
Moray.McConnachie@computing-services.oxford.ac.uk
----- Original Message -----
From: amy cheng <amycq@hotmail.com>
To: <pgsql-general@postgreSQL.org>
Sent: Wednesday, September 29, 1999 9:13 PM
Subject: Re: [GENERAL] Anyone doing a native NT port?

Show quoted text

I even run vi under NT;-))

sorry if distract you. is it possble for win95? I love viANDemacs,
why not wordpad etc? because of regular expression (esp. Vim ).
so, anybody know free software editor on win95 that support regular
expression?

thanks!

amy

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

************

Import Notes

Reply to msg id not found: Pine.LNX.4.10.9909101349380.520-100000@bsmlx17