Undeliverable Message

To: ISMTP(at)SFRA0046@Servers[<pgsql-sql-digest(at)hub(dot)org>]
Cc:
Subject: pgsql-sql-digest V1 #157

Message not delivered to recipients below. Press F1 for help with VNM
error codes.

VNM3043: DE_VOLDER Fabrice(at)ATR_EXPL_LYON1@SFR_DO_CNTR_EST

VNM3043 -- MAILBOX IS FULL

The message cannot be delivered because the
recipient's mailbox contains the maximum number of
messages, as set by the system administrator. The
recipient must delete some messages before any
other messages can be delivered.
The maximum message limit for a user's mailbox is
10,000. The default message limit is 1000 messages.
Administrators can set message limits using the
Mailbox Settings function available in the
Manage User menu (MUSER).

When a user's mailbox reaches the limit, the
user must delete some of the messages before
the mailbox can accept any more incoming messages.

---------------------- Original Message Follows ----------------------

pgsql-sql-digest Tuesday, March 2 1999 Volume 01 : Number 157

Index:

Staus of Primary/Foreign key?
Semantics of LIKE
Persistent connection in PostGresSQL
FW: indexing functions
CREATE TABLE - DEFAULT
Commit
Commit
COMMIT
Re: [SQL] Staus of Primary/Foreign key?
RULE problem
question about pg_dump

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

Date: Mon, 1 Mar 1999 23:35:57 -0500 (EST)
From: "Stan Brown" <stanb(at)awod(dot)com>
Subject: Staus of Primary/Foreign key?

I have implemented referential integrity in older Postgres projects
using functions. I am preparing to do a new project, aand was wondering
what the status of Primary/Foreign key implementation was?

I am starting with 6.4.2,

Thanks.

- --
Stan Brown stanb(at)netcom(dot)com 843-745-3154
Westvaco
Charleston SC.
- --
Windows 98: n.
useless extension to a minor patch release for 32-bit extensions and
a graphical shell for a 16-bit patch to an 8-bit operating system
originally coded for a 4-bit microprocessor, written by a 2-bit
company that can't stand for 1 bit of competition.
- -
(c) 1999 Stan Brown. Redistribution via the Microsoft Network is prohibited.

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

Date: Mon, 01 Mar 1999 22:02:43 -0800
From: Craig Johannsen <cjohan(at)home(dot)com>
Subject: Semantics of LIKE

How does the LIKE predicate operator treat trailing spaces
in a CHAR column. For example,
create table test(c1 char(5));
insert into test('abc');
select c1 from test where c1 like 'abc%';
should retrieve one row.
select c1 from test where c1 like 'abc';
should retrieve zero rows.
select c1 from test where c1 like 'abc ';
should retrieve one row.

Correct? Does this conform exactly to the SQL 92 spec?

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

Date: Tue, 02 Mar 1999 12:11:10 +0200
From: CIMPOESU Teodor <teo(at)digiro(dot)net>
Subject: Persistent connection in PostGresSQL

I have some questions for you all,
What is the difference between a persistent connection and a regular one
in postgres?
If I read /server-status after some queries with pg_pconnect() I see a
lot of active sessions there.
In which cases it is reasonable to use a persistent conection and in
which is not?
10x.

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

Date: Tue, 2 Mar 1999 12:36:07 +0100
From: Bas Peters <bpeters(at)idc(dot)nl>
Subject: FW: indexing functions

I posted this message a while ago, but did not receive any response, so
I give it another try. Any pointer would help.

> Is it possible to manipulate the way an index is created by using
> functions? I would like to store SGML data in text fields that include
> a lot of entities (like &uuml;). To enable the user to search the
> &uuml; character as u I would like to index those entities as the
> character without the diacritical marks. Is this possible?
>
> Thanks in advance,
>
> Bas Peters
> bpeters(at)idc(dot)nl

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

Date: Tue, 2 Mar 1999 06:51:12 -0500 (GMT+5)
From: Ingrith Andrea Correa Vargas <i-correa(at)uniandes(dot)edu(dot)co>
Subject: CREATE TABLE - DEFAULT

I'll try sending my question again.
Can you help me?!

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

Hello again!

I have been receiving some mails asking my question about creating a table
with a default value as a user defined function, but I have a problem yet.

I hope somebody knows to solve my problem...
Thank you in advance! :)

//Ingrith

- ---||---

Te complete problem is:

- ---------------------------------------------------------
CREATE TABLE emp (code INT4
, name VARCHAR(20)
, salary INT4
, 2salary INT4 default double_salary(emp)
);

CREATE FUNCTION double_salary(emp) RETURNS INT4
AS 'SELECT $1.salay * 2 AS result' LANGUAGE 'sql'
;

ERROR: parser: syntax error at or near ")"
- ---------------------------------------------------------

Function double_salary receives an 'emp' , as you see, and there is the
error, because if I change parameter 'emp' by a number, the error doesn't
appear.

How can I do?!

The origin of this question is that I want to know if a subclass inherits
all atributtes from the parent, included functions like double_salary in
my example.

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

Date: Tue, 2 Mar 1999 16:55:39 -0300 (EST)
From: Daniel Facciolo Pires <dfpires(at)tekila(dot)intermidia(dot)icmc(dot)sc(dot)usp(dot)br>
Subject: Commit

Hello,

I'm using Postgresql with Servlets. Servlets don't accept finalize a
section more than two times. I have to update a value (sequence) to take
the new value. So, i would like to know if have a way to invoke a command
like commit ... by programm and how can i do this.

Thanks a lot

- -----------------------------------------
Daniel Facciolo Pires
Mestrando em Ciencias da Computacao
ICMC-USP-Sao Carlos
Grupo: Hipermidia
dfpires(at)icmc(dot)sc(dot)usp(dot)br
http://www.intermidia.icmc.sc.usp.br/~dfpires

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

Date: Tue, 2 Mar 1999 17:06:30 -0300 (EST)
From: Daniel Facciolo Pires <dfpires(at)tekila(dot)intermidia(dot)icmc(dot)sc(dot)usp(dot)br>
Subject: Commit

Hello,

I'm using Postgresql with Servlets. Servlets don't accept finalize a
section more than two times. I have to update a value (sequence) to take
the new value. So, i would like to know if have a way to invoke a command
like commit ... by programm and how can i do this.

Thanks a lot

- -----------------------------------------
Daniel Facciolo Pires
Mestrando em Ciencias da Computacao
ICMC-USP-Sao Carlos
Grupo: Hipermidia
dfpires(at)icmc(dot)sc(dot)usp(dot)br
http://www.intermidia.icmc.sc.usp.br/~dfpires

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

Date: Tue, 2 Mar 1999 17:18:16 -0300 (EST)
From: Daniel Facciolo Pires <dfpires(at)tekila(dot)intermidia(dot)icmc(dot)sc(dot)usp(dot)br>
Subject: COMMIT

Hello,

I'm using Postgresql with Servlets. Servlets don't accept finalize a
section more than two times. I have to update a value (sequence) to take
the new value. So, i would like to know if have a way to invoke a command
like commit ... by programm and how can i do this.

Thanks a lot

- -----------------------------------------
Daniel Facciolo Pires
Mestrando em Ciencias da Computacao
ICMC-USP-Sao Carlos
Grupo: Hipermidia
dfpires(at)icmc(dot)sc(dot)usp(dot)br
http://www.intermidia.icmc.sc.usp.br/~dfpires

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

Date: Tue, 2 Mar 1999 21:53:44 +0100 (MET)
From: jwieck(at)debis(dot)com (Jan Wieck)
Subject: Re: [SQL] Staus of Primary/Foreign key?

>
> I have implemented referential integrity in older Postgres projects
> using functions. I am preparing to do a new project, aand was wondering
> what the status of Primary/Foreign key implementation was?
>
> I am starting with 6.4.2,

I'm planning to implement most of the constraints currently
missing (foreign key, cascaded deletes) over rules - or at
least making the rule system capable of supporting it.

But it will not be in v6.5. The reason for that is that
constraints need a special feature, the rule system currently
cannot support. It is required that rule actions can be
deferred until transaction commit time. At that time (or
when they should get run anyway), they need very special
visibility of heap tuples on a per range table base. One and
the same table might have to be scanned with different
snapshot's in one query.

That all will take a while.

Jan

- --

## It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#
------------------------------

Date: Tue, 2 Mar 1999 23:06:55 +0100 (MET)
From: mueller(at)pmsun20(dot)dial(dot)eunet(dot)ch (Pascal Mueller)
Subject: RULE problem

Hi

I have a problem using rules and do not know if I am wrong or if there
is a bug somewhere?
I have two tables A and B. I want to restrict deleting an instance of table
A if there is a instance in B referencing A.
I tried to set up a rule for this. Here's an example:

- -- START EXAMPLE

- -- **********************************************************************
- -- * rule_test.sql *
- -- * A test case for rule usage *
- -- * *
- -- * Last modification: 03/02/1999 pm, SWS *
- -- **********************************************************************

- -- Create table
CREATE TABLE a ( a INT PRIMARY KEY );
CREATE TABLE b ( b INT PRIMARY KEY, ref INT );

- -- RULEs ----------------------------------------------------------------
- -- Rules for database integrity.

- -- Restrict REMOVE on A if there is still an entry in B referencing A
CREATE RULE demo AS ON DELETE TO a
WHERE EXISTS (
SELECT * FROM b
WHERE b.ref )
DO INSTEAD NOTHING
;

- -- FILL IN DATA ---------------------------------------------------------
INSERT INTO a VALUES ( '1' );
INSERT INTO a VALUES ( '2' );
INSERT INTO a VALUES ( '3' );
INSERT INTO b VALUES ( '1', '1' );
INSERT INTO b VALUES ( '2', '3' );
INSERT INTO b VALUES ( '3', '3' );

- -- TRY TO REMOVE --------------------------------------------------------
DELETE FROM a WHERE a DELETE FROM a WHERE a DELETE FROM a WHERE a
- -- END EXAMPLE

The DELETE commands does not work and ends up in an ERROR in all 3 cases:

DELETE FROM a WHERE a ERROR: ExecEvalExpr: unknown expression type 108
DELETE FROM a WHERE a ERROR: ExecEvalExpr: unknown expression type 108
DELETE FROM a WHERE a ERROR: ExecEvalExpr: unknown expression type 108

And trying to understand what's going on I issued en EXPLAIN command,
crashing the backend:

pascal 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.

What I'm doing wrong here? Any hint? Thanks for any help.

Pascal Mueller

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

Date: Tue, 2 Mar 1999 22:01:56 -0500
From: Bill Brandt <brandtwr-pgsql(at)draaw(dot)net>
Subject: question about pg_dump

I'm trying to upgrade from 6.3. In doing this, I performed a pg_dump of
each database (pg_dump -o where the oid's matter). I have one database
(which doesn't use oid info in the tables btw) that is around 40MB of
data. The output file that created looks fine, but when I go to load the
data, it gets a portion of the way into loading and indicates that you
cannot exceed 20000 lines of input on a copy command. Is there a way to
dump the database that it won't try more than 20000 lines at a time? I
kept the 6.3 directory so dumping again is not a big deal.

Bill

- --
Bill Brandt
brandtwr(at)draaw(dot)net http://www.draaw.net/

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

End of pgsql-sql-digest V1 #157
*******************************