Undeliverable Message - Mailing list pgsql-interfaces

From
Subject Undeliverable Message
Date
Msg-id vines.n4,8+6yYGrA@SFRA0046.
Whole thread Raw
List pgsql-interfaces
To:            ISMTP@SFRA0046@Servers[<pgsql-interfaces-digest@hub.org>]
Cc:            
Subject:       pgsql-interfaces-digest V1 #357

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      Monday, May 24 1999      Volume 01 : Number 357



Index:

Undeliverable Message
Undeliverable Message
[none]
Re: [GENERAL] Problems with INSERT INTO?
Re: [INTERFACES] ECPG feature
JDBC getQuote Call
ODBC with VISUAL BASIC applications to access POSTGRESQL db on LINUX??
JDBC to remote site
dynamic IPs
ODBC to access POSTGRESQL on LINUX - take 2
dynamic IPs
[INTERFACES] MSAccess problem deleting rows
Re: [INTERFACES] dynamic IPs 

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

Date: Mon, 24 May 99 5:28:54 +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 #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
**************************************

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

Date: Mon, 24 May 99 5:28:59 +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 #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
**************************************

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

Date: Sun, 23 May 1999 23:30:16 -0500 (CDT)
From: mike longtine <longtine@uswest.net>
Subject: [none]

subscribe

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

Date: Mon, 24 May 1999 12:46:18 +0300
From: Herouth Maoz <herouth@oumail.openu.ac.il>
Subject: Re: [GENERAL] Problems with INSERT INTO?

At 12:22 +0300 on 24/05/1999, Anna Langer wrote:


> We are not really sure if this question is right for this mailinglist.
> We have some problem with INSERT INTO and we dont know how to solve it.We
> are writing it in a C-program. We are trying to get an integer from a file
> and put it into a database. And we are sure that we get a interger into our
> program.

The proper mailing list is the "interfaces" list, where I am redirecting
this post now.

> int aP0;
>
> PQexec(conn, "INSERT INTO octets VALUES(a)");
>
>
> But the program works when we do like this:
>
> PQexec(conn, "INSERT INTO octets VALUES(500)");
>
>
> It feels like we need to convert int a in some way, byt we dont know how. We
> are beginners with Postgresql.

This is less on the PostgreSQL side, and more on the C side. Just putting
"a" in a string doesn't tell C to pass the variable a. It just passes the
character "a", right?

What you have to do is pass the value of a as part of the command string.
So you have to make a string out of a. This is usually done with sprintf,
like this:

char command[1000];
int aP0;

sprintf( command, "INSERT INTO octets VALUES(%d)", a );

PQexec( conn, command );

Herouth

- --
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

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

Date: Mon, 24 May 1999 14:16:28 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
Subject: Re: [INTERFACES] ECPG feature

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

Sure, bug fixes are accepted at (almost) any time. Not sure what the
status of other stuff is, but I'm going to need some MVCC writeups for
the docs, and will need time to integrate them. There are a few other
bugs being chased, so I'm guessing that June 1 may slip a bit.
                     - Thomas

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

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

Date: Mon, 24 May 1999 10:18:24 -0400
From: Edwin Ramirez <ramirez@doc.mssm.edu>
Subject: JDBC getQuote Call

Hello,

I am using the postgresql JDBC driver with a reporting application,
which calls getQuote.  It seems that getQuote is not defined in the JDBC
driver.  

Does anybody know what this is supposed to do? 

- -Edwin S. Ramirez-

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

Date: Mon, 24 May 1999 11:56:05 -0400
From: "Justin Long" <justinlong@mail.strategicnetwork.org>
Subject: ODBC with VISUAL BASIC applications to access POSTGRESQL db on LINUX??

Ok, I'm confused... I've read most of the messages in my archives that deal
with PGSQL, ODBC... I would like to develop some applications using VB6 to
access PGSQL databases on Linux remotely over the Internet. Can someone
point me to an ODBC driver that would enable this? Should I use P. Harvey's
driver, or something else... what is postODBC? iODBC? I don't find any
references on the PGSQL web site and can't find other web sites that would
have these. Suggestions welcome!

Thanks,
Justin Long


Never retreat. Never surrender. Never cut a deal with a dragon.
_______________________________________________________________
Justin Long                   CIO / Site Editor
616 Station Square Ct         Network for Strategic Missions
Chesapeake, VA 23320          977 Centerville Trnpk CSB 317
JustinLong@xc.org             Va Beach, VA 23463
Check out our site at:        http://www.strategicnetwork.org

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

Date: Mon, 24 May 1999 11:54:22 -0400
From: Alex Turner <aturner@maaco.com>
Subject: JDBC to remote site

Help!

I have tried and tried, but I can't seem to connect to postgres through
JDBC from a remote site.

Could someone please send me a working pg_hba.conf file and a working
piece of JDBC?

TIA

Alex T

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

Date: Mon, 24 May 1999 13:31:33 -0400
From: "Michael R. Anderson" <andersmr@oscar.wvsc.edu>
Subject: dynamic IPs

May 24, 1999

I'd like to connect to a database from a machine that gets a new IP number every time it connects to the ISP.  How do I
setup the pg_hba.conf file to allow this? 
 

Regards,

Mike Anderson

- --------------------------------------------------------------------------------------------------
Dr. Michael R. Anderson
Math Dept.
West Virginia State College
Institute, WV 25112

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

Date: Mon, 24 May 1999 15:19:26 -0400
From: "Justin Long" <justinlong@mail.strategicnetwork.org>
Subject: ODBC to access POSTGRESQL on LINUX - take 2

I was directed to the psqlODBC driver and have downloaded that and installed
it. Now I am attempting to access my Postgresql database on Linux using the
latest version (6.5) of PGSQL.

Here's the error log:

conn0083196, SQLDriverConnect( in)fDriverCompletion
Global Options: Versionunknown_sizes
x_varchar_size%4, max_longvarchar_size90               disable_optimizer, unique_index
use_declarefetch               text_as_longvarchars_longvarchar
bools_as_char               extra_systable_prefixesCONN ERROR: funcerrmsg
------------------------------------------------------------          henv1129732, conn0083196, status6
sock1129748,stmts1129788, lobj_type            ---------------- Socket Info -------------------------------
sockettoremote socket.'           buffer_in0089524, buffer_out0093624
buffer_filled_inuffer_filled_outuffer_read_in

I am using Visual Interdev 6 at the moment to attain a connection. Any
suggestions from the peanut gallery as to why it can't connect? (There isn't
a driver on the Linux side that one has to install, is there?)

Any suggestions, rotten fruit, eggs, whatever, welcome...

Justin Long


Never retreat. Never surrender. Never cut a deal with a dragon.
_______________________________________________________________
Justin Long                   CIO / Site Editor
616 Station Square Ct         Network for Strategic Missions
Chesapeake, VA 23320          977 Centerville Trnpk CSB 317
JustinLong@xc.org             Va Beach, VA 23463
Check out our site at:        http://www.strategicnetwork.org

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

Date: Mon, 24 May 1999 16:11:44 -0400
From: "Michael R. Anderson" <mike@ferrar.wvsc.edu>
Subject: dynamic IPs

May 24, 1999

I'd like to connect to a database from a machine that gets a new IP number every time it connects to the ISP.  How do I
setup the pg_hba.conf file to allow this? 
 

Regards,

Mike Anderson

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

Date: Tue, 25 May 1999 00:55:22 +0200
From: leif@danmos.dk
Subject: [INTERFACES] MSAccess problem deleting rows
  Hello,
   I have a problem running M$Access on a PostgreSQL database,
deleting rows from 'raw' Access, i.e. doing an open on a table
selecting a hole row and then deleting this row. The problem
arises when the table includes a float:

create table effektivitet (   id serial ,   value float,   primary key (id)  );
create unique index ix_effekt_uniq on effektivitet (id);
   Consider a row with the following values:
id  |  value
5   |  1.1666666666666666666....

Depending on how wide my float column is displayed, M$Access will
do something like: 'DELETE FROM effektivitet WHERE id value displays some (stupid) message like "Others have been
changing...."
 
and aborts the operation. This also goes for an update on such a
table. I can of course manually delete the row by doing a
'delete from effektivitet where id within Access or directly on the Linux box.
  This also happens with following piece of VB code:

Set rstEffective With rstEffective   .Edit   !Value     .Update
End With

  How can I make M$Acess use the unique index column for pointing
out this specific row in stead of generating a where clause containing
all fields in the table?

I am running PostgreSQL 6.4.2 on RedHat 5.0 and kernel 2.0.32. (I
downloaded and installed it just a few weeks ago. This goes for
psqlODBC as well).

   Greetings,
 Leif (leif@danmos.dk)

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

Date: Mon, 24 May 1999 20:11:49 -0400
From: Tom Lane <tgl@sss.pgh.pa.us> 
Subject: Re: [INTERFACES] dynamic IPs 

"Michael R. Anderson" <mike@ferrar.wvsc.edu> writes:
> I'd like to connect to a database from a machine that gets a new IP
> number every time it connects to the ISP.  How do I set up the
> pg_hba.conf file to allow this?

I think your only alternative is to find out the range of IP numbers
your ISP might assign (it's probably not large, one C block at most)
and then configure pg_hba.conf to allow access from any address in
that range.  For example, if the ISP says 12.34.56.0 - 12.34.56.255,
then you'd put something like

host         all        12.34.56.0  255.255.255.0      password

I'd recommend using an authentication method other than "trust" ;-)
        regards, tom lane

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

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




pgsql-interfaces by date:

Previous
From: Alf Lewerken
Date:
Subject: Error Compiling unixODBC
Next
From: "Anna Langer"
Date:
Subject: Questions about INSERT INTO!