Undeliverable Message

To:            ISMTP@SFRA0046@Servers[<pgsql-interfaces-digest@hub.org>]
Cc:            
Subject:       pgsql-interfaces-digest V1 #356

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
thesystem administrator.  The  recipient must delete some messages before any  other messages can be delivered.   The
maximummessage limit for a user's mailbox is   10,000.  The default message limit is 1000 messages.    Administrators
canset 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
anymore incoming messages.
 

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


pgsql-interfaces-digest      Sunday, May 23 1999      Volume 01 : Number 356



Index:

Undeliverable Message
Re: [INTERFACES] What to use to get number of tuples in a query
Re: [INTERFACES] ECPG feature

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

Date: Sun, 23 May 99 5:27:05 +0100
From: <MAILER-DAEMON@mail1.sfr.fr>
Subject: Undeliverable Message

To:            ISMTP@SFRA0046@Servers[<pgsql-interfaces-digest@hub.org>]
Cc:            
Subject:       pgsql-interfaces-digest V1 #355

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
thesystem administrator.  The  recipient must delete some messages before any  other messages can be delivered.   The
maximummessage limit for a user's mailbox is   10,000.  The default message limit is 1000 messages.    Administrators
canset 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
anymore incoming messages.
 

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


pgsql-interfaces-digest     Saturday, May 22 1999     Volume 01 : Number 355



Index:

ECPG feature
jdbc - getArray
jdbc - number of updated rows
Error with JDBC
Re: [INTERFACES] ECPG feature

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

Date: Fri, 21 May 1999 21:53:08 +0200
From: "Pavel PaJaSoft Janousek" <janousek@fonet.cz>
Subject: ECPG feature
   Hi,
   ECPG is very powerfull, I have one idea..
   If I have contruction ala:
   if (cond)       exec sql ....   else       exec sql...
   Yes, this MUST be for right run as there:
   if (cond)   {       exec sql...   }   else   {       exec sql ...   }
   So, why this brackets ('{' and '}') doesn't include ECPG? It may include
this brackets before and after every 'EXEC SQL' command...
   I know, that this is some modifications in output of parser... may
anybody do this modifications?

- - -------------------------------------------------------------------------
Pavel Janousek (PaJaSoft)                         FoNet, spol. s r. o.
Vyvoj software, sprava siti, Unix, Web, Y2K     Anenska 11, 602 00  Brno
E-mail: mailto:Janousek@FoNet.Cz                Tel.: +420  5  4324 4749
SMS:    mailto:P.Janousek@SMS.Paegas.Cz         Fax.: +420  5  4324 4751
WWW:    http://WWW.FoNet.Cz/                  E-mail: mailto:Info@FoNet.Cz
- - --------------------------------------------------------------------------

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

Date: Sat, 22 May 1999 12:24:28 +0200
From: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
Subject: jdbc - getArray

Is there any working implementation of getArray? When it is
expected to be implemented in JDBC interface?


PS. I'm new this list, so if answers to my questions are in any kind
of faqs or were answered recently, please give a link to it.

PS2. I was trying to search archive-list, but it seems to be not
working...

/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/

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

Date: Sat, 22 May 1999 12:35:10 +0200
From: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
Subject: jdbc - number of updated rows

Please tell me how to get to know how many rows has method
executeUpdate affected. According to documentation
<cut>
Returns:       either the row count for INSERT, UPDATE or DELETE ...
</cut>
this method should return number of updated rows, but it always
returns 1. It's a feature(bug) of postgresql jdbc-driver?

The only solution for my problem, that I made up is:

turn off auto-commit

select count(*) from table
where tID
- - -- now i (probably)know number of updated rows

update table set ...
where tID

commit

turn on auto-commit
- - -- stupid, isn't it ...

PS. remember that I'm new here...

/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/

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

Date: Sat, 22 May 1999 04:36:47 -0700 (PDT)
From: Peter Garner <peter_garner@yahoo.com>
Subject: Error with JDBC

Hi All

I am using Postgres 6.5b and the JDBC that came with
it.   Under RH6.0 I get the following error attempting
to connect :

java.sql.SQLException: Something unusual has occured
to cause the driver to fail. Please report this
exception: java.sql.SQLException: Unknown Response
Type: Kat postgresql.Driver.connect(Driver.java:106)at
java.sql.DriverManager.getConnection(DriverManager.java:83)at
java.sql.DriverManager.getConnection(DriverManager.java:126)at
crazy.pete.jnews.nntp.NewsReader.connectDBMS(NewsReader.java:95)at NewsMain.main(NewsMain.java:64)

I suspect this is something to do with a network
service not being properly started.  (I doubt it has
anything to do with the postmaster, since I am using
the identical startup script that worked with RH5.2.)
Oh, BTW both postmaster and the JDBC CLIENT are
running
on the same machine.  What service could I have
forgotten to start that is preventing TCP sockets from
working?   Thanks!
Peace,
Peter

We are Microsoft of Borg, you will be assimilated!!!
Resistance is fut...  ***BZZZRT***  THUD!!!
[General Protection Fault in MSBorg32.DLL]
Please contact the vendor of this Borg for more information
_____________________________________________________________
Do You Yahoo!?
Free instant messaging and more at http://messenger.yahoo.com

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

Date: Sat, 22 May 1999 22:15:28 +0200
From: Michael Meskes <meskes@postgresql.org>
Subject: Re: [INTERFACES] ECPG feature

On Fri, May 21, 1999 at 09:53:08PM +0200, Pavel PaJaSoft Janousek wrote:
>     if (cond)
>         exec sql ....
>     else
>         exec sql...
> 
>     Yes, this MUST be for right run as there:
> 
>     if (cond)
>     {
>         exec sql...
>     }
>     else
>     {
>         exec sql ...
>     }

This looks like a bug. I will check it asap.

Michael
- - -- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

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

End of pgsql-interfaces-digest V1 #355
**************************************

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

Date: Sun, 23 May 1999 10:00:15 +0200
From: Michael Meskes <meskes@postgresql.org>
Subject: Re: [INTERFACES] What to use to get number of tuples in a query

On Fri, May 21, 1999 at 02:51:10PM -0700, Hitesh Patel wrote:
> What should I use to get the number of tuples returned by a PQexec()? 
> PQntuples seems to be doing the job but i'm not sure if that is the
> right thing to use.

At least that's the command I use with ecpg. :-)

However, if you're executing commands that do not return tuples you have to
use PQcmdTuples().

Michael
- -- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

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

Date: Sun, 23 May 1999 11:12:31 +0200
From: Michael Meskes <meskes@postgresql.org>
Subject: Re: [INTERFACES] ECPG feature

On Fri, May 21, 1999 at 09:53:08PM +0200, Pavel PaJaSoft Janousek wrote:
>     So, why this brackets ('{' and '}') doesn't include ECPG? It may include
> this brackets before and after every 'EXEC SQL' command...

Okay, I'm working on this. BTW Oracle's PRO*C doesn't do this. :-) 

What's the current status of the code freeze. I take it I'm not allowed to
commit this change, am I?

Michael
- -- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

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

End of pgsql-interfaces-digest V1 #356
**************************************