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_size90 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_in uffer_filled_out uffer_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
**************************************
