Undeliverable Message - Mailing list pgsql-sql

To:            ISMTP@SFRA0046@Servers[<pgsql-sql-digest@hub.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@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@awod.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@netcom.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@home.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@digiro.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@idc.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 ü). To enable the user to search the
> ü 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@idc.nl

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

Date: Tue, 2 Mar 1999 06:51:12 -0500 (GMT+5)
From: Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.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@tekila.intermidia.icmc.sc.usp.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@icmc.sc.usp.br
http://www.intermidia.icmc.sc.usp.br/~dfpires

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

Date: Tue, 2 Mar 1999 17:06:30 -0300 (EST)
From: Daniel Facciolo Pires <dfpires@tekila.intermidia.icmc.sc.usp.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@icmc.sc.usp.br
http://www.intermidia.icmc.sc.usp.br/~dfpires

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

Date: Tue, 2 Mar 1999 17:18:16 -0300 (EST)
From: Daniel Facciolo Pires <dfpires@tekila.intermidia.icmc.sc.usp.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@icmc.sc.usp.br
http://www.intermidia.icmc.sc.usp.br/~dfpires

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

Date: Tue, 2 Mar 1999 21:53:44 +0100 (MET)
From: jwieck@debis.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@pmsun20.dial.eunet.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@draaw.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@draaw.net                              http://www.draaw.net/

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

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