To: ISMTP@SFRA0046@Servers[<pgsql-interfaces-digest@hub.org>]
Cc:
Subject: pgsql-interfaces-digest V1 #224
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-interfaces-digest Thursday, February 11 1999 Volume 01 : Number 224
Index:
[none]
Re: [INTERFACES] libpq and multi-threading on Linux?
Troubles with the ODBC driver in the postgres distribution (integrated installation)
Troubles with the ODBC driver in the postgres distribution (integrated installation)
Troubles with the ODBC driver in the postgres distribution (integrated installation)
Troubles with the ODBC driver in the postgres distribution (standalone installation)
ODBC - MSysConf
[none]
pgAdmin v6.4.2
Re: [INTERFACES] facing problem with ecpg
Re: [INTERFACES] ODBC - MSysConf
JDBC: DatabaseMetaData and getPrimaryKeys
Re: [INTERFACES] facing problem with ecpg
Re: [INTERFACES] JDBC: DatabaseMetaData and getPrimaryKeys
Help with ODBC
Help with ODBC in VB6
----------------------------------------------------------------------
Date: Thu, 11 Feb 1999 09:42:04 +0200
From: "Sergey T. Soenko" <serg@kzsm.lg.ua>
Subject: [none]
- --
< +++++mailto:serg@kzsm.lg.ua
------------------------------
Date: Thu, 11 Feb 1999 01:59:37 -0700
From: Brendan Rempel <rempelb@cybersurf.net>
Subject: Re: [INTERFACES] libpq and multi-threading on Linux?
I succeeded in doing exactly that. I simply took the C source examples on
the Postgres documentation and pasted it into the thread with no problems
at all. The only changes made to the examples were just simple ones like
return values or fprintf(stderr) stuff, but that's all. Postgres server
and libpq libraries run flawlessly in pthreads.
For me, synchronization was not required since each thread did not share
resources with other threads. Each thread personally initialized the
libpq connection, did its job and destroyed the connection, just like the
example.
Brendan
Michael Olivier wrote:
> Hi folks,
>
> I apologize in advance if I have overlooked docs, but I haven't been
> able to find a discussion of how PostGreSQL via libpq on Linux fares
> with pthreads. Can someone point me to docs if available, or otherwise
> enlighten me? How well does it work and what are the important design
> issues to consider?
>
> I'm expecting to create a pool of db connections to use within a
> long-running process, which will create a new thread for each incoming
> request from a client. I've found just a very little bit about PG
> being multi-processing, but not how it will interact with a
> multi-threaded client. I appreciate your comments.
>
> thanks,
> --Michael
>
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com
------------------------------
Date: Thu, 11 Feb 1999 10:48:26 +0100
From: Pascal DAYRE <dayre@ipgp.jussieu.fr>
Subject: Troubles with the ODBC driver in the postgres distribution (integrated installation)
(Sparc Ultra10, solaris 2.6, Postgres 6.4.2)
Hello everybody, can you help me?
I 've tried to install the ODBC driver like the description
in "PostgreSQL Programmer's Guide" guide (153-157).
I've tried the integrated installation and also the standalone
installation.
What is the compiler needed for C++? I have tried a GNU one and a
Solaris one?
What is the good version for GNU C++?
- -----------------------------------------------
My compilations for integrated installation:
1> integrated installation with a GNU c++
./configure --prefix- --with-template- --with-CXX
gmake
...
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/ecpg'
gmake -C libpq++ all
gmake[2]: Entering directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
/usr/local/geoscope/src/GNU/package/usr/local/bin/c++ -I../../backend
- -I../../include -I../../interfaces/libpq -I../../include
- -I../../backend -Xa -v -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO
- -K PIC -c pgenv.cc -o pgenv.o
c++: cannot specify -o with -c and multiple compilations
gmake[2]: *** [pgenv.o] Error 1
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces'
gmake: *** [all] Error 2
2> integrated installation with /opt/SUNWspro/bin/CC (workshop, solaris)
./configure --prefix- --with-template
gmake
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/ecpg'
gmake -C libpq++ all
gmake[2]: Entering directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
CC -I../../backend -I../../include -I../../interfaces/libpq
- -I../../include -I../../backend -Xa -v -D__sparc__ -D__sun__
- -DDISABLE_COMPLEX_MACRO -K PIC -c pgenv.cc -o pgenv.o
CC: Warning: Option -Xa passed to ld, if ld is invoked, ignored
otherwise
CC: Warning: Option -K passed to ld, if ld is invoked, ignored otherwise
### CC: Note: LM_LICENSE_FILE ### CC: Note: NLSPATH
/opt/SUNWspro/bin/../SC4.2/bin/../lib/locale/%L/LC_MESSAGES/%N.cat:/opt/SUNWspro/bin/../SC4.2/bin/../../lib/locale/%L/LC_MESSAGES/%N.cat
CC: Invalid input file name PIC, no output generated for this file.
/opt/SUNWspro/bin/../SC4.2/bin/ccfe -y-o -ypgenv.o -I../../backend
- -I../../include -I../../interfaces/libpq -I../../include -I../../backend
- -y-fbe -y/opt/SUNWspro/bin/../SC4.2/bin/fbe -ptb pgenv.o -y-xarch- -y-verbose -O0 -ptf /tmp/08458%1.%2 -ptx
/opt/SUNWspro/bin/../SC4.2/bin/CC -ptk "-I../../backend -I../../include
- -I../../interfaces/libpq -I../../include -I../../backend -Xa -v
- -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO -K -c " -D__SunOS_5_6
- -D__SUNPRO_CC20 -Dunix -Dsun -Dsparc -D__sparc -D__unix -D__sun
- -D__BUILTIN_VA_ARG_INCR -D__SVR4 -I/opt/SUNWspro/SC4.2/include/CC
- -I/opt/SUNWspro/SC4.2/include/CC/rw7 -I/opt/SUNWspro/SC4.2/include/cc
- -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO pgenv.cc -s
/tmp/ccfe.08458.0.s
"pgenv.h", line 21: Error: Could not open include file <string>.
"pgenv.h", line 25: Error: Type name expected instead of "using".
"pgenv.h", line 48: Error: Type name expected instead of "string".
"pgenv.h", line 48: Error: No storage class or type for this
declaration.
"pgenv.h", line 48: Error: "," expected instead of "pgAuth".
"pgenv.h", line 49: Error: Use ";" to terminate declarations.
"pgenv.h", line 49: Error: Type name expected instead of "string".
"pgenv.h", line 49: Error: No storage class or type for this
declaration.
"pgenv.h", line 49: Error: Multiple declaration for string.
"pgenv.h", line 49: Error: "," expected instead of "pgHost".
"pgenv.h", line 50: Error: Use ";" to terminate declarations.
"pgenv.h", line 50: Error: Type name expected instead of "string".
"pgenv.h", line 50: Error: No storage class or type for this
declaration.
"pgenv.h", line 50: Error: Multiple declaration for string.
"pgenv.h", line 50: Error: "," expected instead of "pgPort".
"pgenv.h", line 51: Error: Use ";" to terminate declarations.
"pgenv.h", line 51: Error: Type name expected instead of "string".
"pgenv.h", line 51: Error: No storage class or type for this
declaration.
"pgenv.h", line 51: Error: Multiple declaration for string.
"pgenv.h", line 51: Error: "," expected instead of "pgOption".
"pgenv.h", line 52: Error: Use ";" to terminate declarations.
"pgenv.h", line 52: Error: Type name expected instead of "string".
"pgenv.h", line 52: Error: No storage class or type for this
declaration.
"pgenv.h", line 52: Error: Multiple declaration for string.
"pgenv.h", line 52: Error: "," expected instead of "pgTty".
Compilation aborted, too many Error messages.
rm /tmp/ccfe.08458.0.s
gmake[2]:
How can I fix the problem?
What is the mistake?
thank you for answering :)
Pascal
------------------------------
Date: Thu, 11 Feb 1999 10:57:21 +0100
From: Pascal DAYRE <dayre@ipgp.jussieu.fr>
Subject: Troubles with the ODBC driver in the postgres distribution (integrated installation)
(Sparc Ultra10, solaris 2.6, Postgres 6.4.2)
Hello everybody, can you help me?
I 've tried to install the ODBC driver like the description
in "PostgreSQL Programmer's Guide" guide (153-157).
I've tried the integrated installation and also the standalone
installation.
What is the compiler needed for C++? I have tried a GNU one and a
Solaris one?
What is the good version for GNU C++?
- -----------------------------------------------
My compilations for integrated installation:
1> integrated installation with a GNU c++
./configure --prefix- --with-template- --with-CXX
gmake
...
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/ecpg'
gmake -C libpq++ all
gmake[2]: Entering directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
/usr/local/geoscope/src/GNU/package/usr/local/bin/c++ -I../../backend
- -I../../include -I../../interfaces/libpq -I../../include
- -I../../backend -Xa -v -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO
- -K PIC -c pgenv.cc -o pgenv.o
c++: cannot specify -o with -c and multiple compilations
gmake[2]: *** [pgenv.o] Error 1
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces'
gmake: *** [all] Error 2
2> integrated installation with /opt/SUNWspro/bin/CC (workshop, solaris)
./configure --prefix- --with-template
gmake
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/ecpg'
gmake -C libpq++ all
gmake[2]: Entering directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
CC -I../../backend -I../../include -I../../interfaces/libpq
- -I../../include -I../../backend -Xa -v -D__sparc__ -D__sun__
- -DDISABLE_COMPLEX_MACRO -K PIC -c pgenv.cc -o pgenv.o
CC: Warning: Option -Xa passed to ld, if ld is invoked, ignored
otherwise
CC: Warning: Option -K passed to ld, if ld is invoked, ignored otherwise
### CC: Note: LM_LICENSE_FILE ### CC: Note: NLSPATH
/opt/SUNWspro/bin/../SC4.2/bin/../lib/locale/%L/LC_MESSAGES/%N.cat:/opt/SUNWspro/bin/../SC4.2/bin/../../lib/locale/%L/LC_MESSAGES/%N.cat
CC: Invalid input file name PIC, no output generated for this file.
/opt/SUNWspro/bin/../SC4.2/bin/ccfe -y-o -ypgenv.o -I../../backend
- -I../../include -I../../interfaces/libpq -I../../include -I../../backend
- -y-fbe -y/opt/SUNWspro/bin/../SC4.2/bin/fbe -ptb pgenv.o -y-xarch- -y-verbose -O0 -ptf /tmp/08458%1.%2 -ptx
/opt/SUNWspro/bin/../SC4.2/bin/CC -ptk "-I../../backend -I../../include
- -I../../interfaces/libpq -I../../include -I../../backend -Xa -v
- -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO -K -c " -D__SunOS_5_6
- -D__SUNPRO_CC20 -Dunix -Dsun -Dsparc -D__sparc -D__unix -D__sun
- -D__BUILTIN_VA_ARG_INCR -D__SVR4 -I/opt/SUNWspro/SC4.2/include/CC
- -I/opt/SUNWspro/SC4.2/include/CC/rw7 -I/opt/SUNWspro/SC4.2/include/cc
- -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO pgenv.cc -s
/tmp/ccfe.08458.0.s
"pgenv.h", line 21: Error: Could not open include file <string>.
"pgenv.h", line 25: Error: Type name expected instead of "using".
"pgenv.h", line 48: Error: Type name expected instead of "string".
"pgenv.h", line 48: Error: No storage class or type for this
declaration.
"pgenv.h", line 48: Error: "," expected instead of "pgAuth".
"pgenv.h", line 49: Error: Use ";" to terminate declarations.
"pgenv.h", line 49: Error: Type name expected instead of "string".
"pgenv.h", line 49: Error: No storage class or type for this
declaration.
"pgenv.h", line 49: Error: Multiple declaration for string.
"pgenv.h", line 49: Error: "," expected instead of "pgHost".
"pgenv.h", line 50: Error: Use ";" to terminate declarations.
"pgenv.h", line 50: Error: Type name expected instead of "string".
"pgenv.h", line 50: Error: No storage class or type for this
declaration.
"pgenv.h", line 50: Error: Multiple declaration for string.
"pgenv.h", line 50: Error: "," expected instead of "pgPort".
"pgenv.h", line 51: Error: Use ";" to terminate declarations.
"pgenv.h", line 51: Error: Type name expected instead of "string".
"pgenv.h", line 51: Error: No storage class or type for this
declaration.
"pgenv.h", line 51: Error: Multiple declaration for string.
"pgenv.h", line 51: Error: "," expected instead of "pgOption".
"pgenv.h", line 52: Error: Use ";" to terminate declarations.
"pgenv.h", line 52: Error: Type name expected instead of "string".
"pgenv.h", line 52: Error: No storage class or type for this
declaration.
"pgenv.h", line 52: Error: Multiple declaration for string.
"pgenv.h", line 52: Error: "," expected instead of "pgTty".
Compilation aborted, too many Error messages.
rm /tmp/ccfe.08458.0.s
gmake[2]:
How can I fix the problem?
What is the mistake?
thank you for answering :)
Pascal
------------------------------
Date: Thu, 11 Feb 1999 11:15:14 +0100
From: Pascal DAYRE <dayre@ipgp.jussieu.fr>
Subject: Troubles with the ODBC driver in the postgres distribution (integrated installation)
(Sparc Ultra10, solaris 2.6, Postgres 6.4.2)
Hello everybody, can you help me?
I 've tried to install the ODBC driver like the description
in "PostgreSQL Programmer's Guide" guide (153-157).
I've tried the integrated installation and also the standalone
installation.
What is the compiler needed for C++? I have tried a GNU one and a
Solaris one?
What is the good version for GNU C++?
- -----------------------------------------------
My compilations for integrated installation:
1> integrated installation with a GNU c++
./configure --prefix- --with-template- --with-CXX
gmake
...
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/ecpg'
gmake -C libpq++ all
gmake[2]: Entering directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
/usr/local/geoscope/src/GNU/package/usr/local/bin/c++ -I../../backend
- -I../../include -I../../interfaces/libpq -I../../include
- -I../../backend -Xa -v -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO
- -K PIC -c pgenv.cc -o pgenv.o
c++: cannot specify -o with -c and multiple compilations
gmake[2]: *** [pgenv.o] Error 1
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces'
gmake: *** [all] Error 2
2> integrated installation with /opt/SUNWspro/bin/CC (workshop, solaris)
./configure --prefix- --with-template
gmake
gmake[2]: Leaving directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/ecpg'
gmake -C libpq++ all
gmake[2]: Entering directory
`/usr/localsgbd1/postgresql-6.4.2/src/interfaces/libpq++'
CC -I../../backend -I../../include -I../../interfaces/libpq
- -I../../include -I../../backend -Xa -v -D__sparc__ -D__sun__
- -DDISABLE_COMPLEX_MACRO -K PIC -c pgenv.cc -o pgenv.o
CC: Warning: Option -Xa passed to ld, if ld is invoked, ignored
otherwise
CC: Warning: Option -K passed to ld, if ld is invoked, ignored otherwise
### CC: Note: LM_LICENSE_FILE ### CC: Note: NLSPATH
/opt/SUNWspro/bin/../SC4.2/bin/../lib/locale/%L/LC_MESSAGES/%N.cat:/opt/SUNWspro/bin/../SC4.2/bin/../../lib/locale/%L/LC_MESSAGES/%N.cat
CC: Invalid input file name PIC, no output generated for this file.
/opt/SUNWspro/bin/../SC4.2/bin/ccfe -y-o -ypgenv.o -I../../backend
- -I../../include -I../../interfaces/libpq -I../../include -I../../backend
- -y-fbe -y/opt/SUNWspro/bin/../SC4.2/bin/fbe -ptb pgenv.o -y-xarch- -y-verbose -O0 -ptf /tmp/08458%1.%2 -ptx
/opt/SUNWspro/bin/../SC4.2/bin/CC -ptk "-I../../backend -I../../include
- -I../../interfaces/libpq -I../../include -I../../backend -Xa -v
- -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO -K -c " -D__SunOS_5_6
- -D__SUNPRO_CC20 -Dunix -Dsun -Dsparc -D__sparc -D__unix -D__sun
- -D__BUILTIN_VA_ARG_INCR -D__SVR4 -I/opt/SUNWspro/SC4.2/include/CC
- -I/opt/SUNWspro/SC4.2/include/CC/rw7 -I/opt/SUNWspro/SC4.2/include/cc
- -D__sparc__ -D__sun__ -DDISABLE_COMPLEX_MACRO pgenv.cc -s
/tmp/ccfe.08458.0.s
"pgenv.h", line 21: Error: Could not open include file <string>.
"pgenv.h", line 25: Error: Type name expected instead of "using".
"pgenv.h", line 48: Error: Type name expected instead of "string".
"pgenv.h", line 48: Error: No storage class or type for this
declaration.
"pgenv.h", line 48: Error: "," expected instead of "pgAuth".
"pgenv.h", line 49: Error: Use ";" to terminate declarations.
"pgenv.h", line 49: Error: Type name expected instead of "string".
"pgenv.h", line 49: Error: No storage class or type for this
declaration.
"pgenv.h", line 49: Error: Multiple declaration for string.
"pgenv.h", line 49: Error: "," expected instead of "pgHost".
"pgenv.h", line 50: Error: Use ";" to terminate declarations.
"pgenv.h", line 50: Error: Type name expected instead of "string".
"pgenv.h", line 50: Error: No storage class or type for this
declaration.
"pgenv.h", line 50: Error: Multiple declaration for string.
"pgenv.h", line 50: Error: "," expected instead of "pgPort".
"pgenv.h", line 51: Error: Use ";" to terminate declarations.
"pgenv.h", line 51: Error: Type name expected instead of "string".
"pgenv.h", line 51: Error: No storage class or type for this
declaration.
"pgenv.h", line 51: Error: Multiple declaration for string.
"pgenv.h", line 51: Error: "," expected instead of "pgOption".
"pgenv.h", line 52: Error: Use ";" to terminate declarations.
"pgenv.h", line 52: Error: Type name expected instead of "string".
"pgenv.h", line 52: Error: No storage class or type for this
declaration.
"pgenv.h", line 52: Error: Multiple declaration for string.
"pgenv.h", line 52: Error: "," expected instead of "pgTty".
Compilation aborted, too many Error messages.
rm /tmp/ccfe.08458.0.s
gmake[2]:
How can I fix the problem?
What is the mistake?
thank you for answering :)
Pascal
------------------------------
Date: Thu, 11 Feb 1999 12:06:34 +0100
From: Pascal DAYRE <dayre@ipgp.jussieu.fr>
Subject: Troubles with the ODBC driver in the postgres distribution (standalone installation)
- --------------668455E0634BA07049CA63EA
Content-Type: text/plain; charsetContent-Transfer-Encoding: 7bit
(Sparc Ultra10, solaris 2.6, Postgres 6.4.2)
Hello everybody, can you help me?
I 've tried to install the ODBC driver like the description
in "PostgreSQL Programmer's Guide" guide (153-157).
I've tried the integrated installation and also the standalone
installation.
What is the compiler needed for C++? I have tried a GNU one and a
Solaris one?
What is the good version for GNU C++?
- -----------------------------------------------
My compilations for standalone installation:
1> standalone installation with a GNU c++
cd interfaces/odbc
gmake standalone
rm -f psqlodbc-025.tar.gz
/bin/tar -chf psqlodbc-025.tar \
*.c *.h *.in Config.mk TODO.txt Version.mk config.guess config.sub
configure install-sh license.txt notice.txt odbcinst.ini psqlodbc.def
psqlodbc.rc readme.txt -C ../.. makefiles template Makefile.shlib
tar: Makefile.shlib: No such file or directory
gmake: *** [standalone] Error 1
[root@geosp15]tcsh(14)
How can I fix the problem?
What is the mistake?
thank you for answering :)
Pascal
- --
- -------------------------------------------
Pascal DAYRE
dayre@ipgp.jussieu.fr
tel: (33) 1 44 27 38 96
fax: (33) 1 44 27 38 94
- --------------------------------------------
- --------------668455E0634BA07049CA63EA
Content-Type: text/html; charsetContent-Transfer-Encoding: 7bit
<HTML>
(Sparc Ultra10, solaris 2.6, Postgres 6.4.2)
<P>Hello everybody, can you help me?
<P>I 've tried to install the ODBC driver like the description
<BR>in "PostgreSQL Programmer's Guide" guide (153-157).
<BR>I've tried the integrated installation and also the standalone
<BR>installation.
<P>What is the compiler needed for C++? I have tried a GNU one and a
<BR>Solaris one?
<BR>What is the good version for GNU C++?
<P>-----------------------------------------------
<BR>My compilations for standalone installation:
<P>1> standalone installation with a GNU c++
<BR>
<P>cd interfaces/odbc
<P>gmake standalone
<P>rm -f psqlodbc-025.tar.gz
<BR>/bin/tar -chf psqlodbc-025.tar \
<BR> *.c *.h *.in Config.mk TODO.txt Version.mk config.guess
config.sub configure install-sh license.txt notice.txt odbcinst.ini psqlodbc.def
psqlodbc.rc readme.txt -C ../.. makefiles template Makefile.shlib
<BR>tar: Makefile.shlib: No such file or directory
<BR>gmake: *** [standalone] Error 1
<BR>[root@geosp15]tcsh(14)
<BR>
<BR>
<BR>
<BR>
<P>How can I fix the problem?
<BR>What is the mistake?
<P>thank you for answering :)
<P>Pascal
<BR>
<BR>
<BR>
<PRE>--
- -------------------------------------------
Pascal DAYRE
dayre@ipgp.jussieu.fr
tel: (33) 1 44 27 38 96
fax: (33) 1 44 27 38 94
- --------------------------------------------</PRE>
</HTML>
- --------------668455E0634BA07049CA63EA--
------------------------------
Date: Thu, 11 Feb 1999 12:59:49 -0800
From: Karsten Kaus <kk@kdschmid.de>
Subject: ODBC - MSysConf
ok, in general it seems to be possible to connect Access97 ( not Access
2.0! ?right? ) to postgres.
It works on ONE of my Computers in the office (486). On that computer
I cannot start the 32Bit-ODBC in the systemconfiguration, but I can
create DSNs within Access97, and I get connected to any postgres-
database I wish (tried only 2).
On my Pentium in the office and on ALL machines at home I get the
error 4307, that there is a Table called MSysConf on my server but
it does not have the expected format.
I searched for this table using grep and pg_dumpall as well as psql \dS
and could not find anything. So I created one as described in the
MSAccess-Help, but this didn't help. Still the fomat was invalid.
I do not want to use this table anyway ( do I? ), so what to do?
Thanks for help,
Karsten Kaus
------------------------------
Date: Thu, 11 Feb 1999 14:09:24 +0100
From: Andreas Kaschke <kaschke@books.de>
Subject: [none]
subscribe
------------------------------
Date: Thu, 11 Feb 1999 16:06:55 -0000
From: Dave Page <dpage@vale-housing.co.uk>
Subject: pgAdmin v6.4.2
I've just released pgAdmin v6.4.2 which is available from:
http://www.vale-it.demon.co.uk/freeware
New features/enhancements include:
1) Improved the error logging to include details of the database connection
and some internal variables in the logfile.
2) Added a check to prevent use with earlier versions of PostgreSQL than
are compatible.
3) Added checks to warn the user if the ODBC driver settings for the
datasource could cause problems with the operation of pgAdmin.
4) Added a Database browser dialogue with Create and Drop database
facilities.
Please note that pgAdmin 6.4.x will only work correctly with PostgreSQL
6.4.x.
Regards,
Dave.
- --
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!
------------------------------
Date: Fri, 12 Feb 1999 00:42:34 +0800
From: hoelc <hoelc@pd.jaring.my>
Subject: Re: [INTERFACES] facing problem with ecpg
Hello,
I've just upgrated my PostgreSQL system to version Postgres-6.4.2
Now it has the *ecpg
But I'm facing problem in using it, when I compile the C program with
cc -o tryecpg tryecpg.c -lecpg -lpq
the compiler can't recognize the " exec sql ", and give error massage
Parse error before 'sql'
What went wrong ? Please advise.
Thanks for giving me the address for the Oracle Pre*C/C++ programmer's guide, it
is a good reference. But, it doesn't exactly reflect the ecpg, right? Is there
any reference and example program for how to use ecpg?
Thank you very much.
Regards,
LCH
Michael Meskes wrote:
> On Sat, Feb 06, 1999 at 07:16:14PM -0600, James Thompson wrote:
> > http://www.dal.ca/%7eoracle/oradoc/DOC/api/doc/PC_22/toc.htm
>
> Gotta look at this.
>
> > With it you end up with something like the following in your code
> >
> > exec sql
> > insert into customer(id,name_first,name_middle,name_last,company,
> > address1,address2,city,state,country,zip,phone_work,
> > phone_home,phone_fax,email,date_entered,billing_terms,
> > confirmation_method)
> > values (:id,:name_first, :name_middle, :name_last,
> > :company,:address1,:address2,
> > :city,:state,:country,:zip,:phone_work,
> > :phone_home,:phone_fax,:email,date('now'),
> > :billing_terms,
> > :confirmation_method);
>
> Xou can even add indicators like in
>
> ... values (:id,:name_first, :name_middle:nm_ind, :name_last, ...
>
> If nm_ind is set to -1 the name_middle entry will be set to NULL.
>
> > The author of the code is very responsive to few problem reports I have
> > sent him and has sent patches, or workarounds to me usually within 24
> > hours.
>
> Glad I can help. :-)
>
> > In the few cases you can't figure out a way to make something happen using
> > ecpg I believe you can mix the libpg and ecpg code in the same program.
> > The only place I could see a need for this is when you'd need the
> > functionality given by Pro*C's Dynamic SQL which ecpg doesn't yet support,
> > but I think its in the works.
>
> It is. In fact I already submitted a patch for the PREPARE and EXECUTE
> commands. James, if you'd like to test this I can send you the source until
> it makes its way into CVS.
>
> 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: Thu, 11 Feb 1999 09:35:12 -0500
From: David Hartwig <daveh@insightdist.com>
Subject: Re: [INTERFACES] ODBC - MSysConf
Karsten Kaus wrote:
> ok, in general it seems to be possible to connect Access97 ( not Access
> 2.0! ?right? ) to postgres.
I recall someone doing this successfully. The key here is that it needs to
be running on Win95, Win98, or NT.
>
> It works on ONE of my Computers in the office (486). On that computer
> I cannot start the 32Bit-ODBC in the systemconfiguration, but I can
> create DSNs within Access97, and I get connected to any postgres-
> database I wish (tried only 2).
> On my Pentium in the office and on ALL machines at home I get the
> error 4307, that there is a Table called MSysConf on my server but
> it does not have the expected format.
You do not need this table on the server. The driver will report it as an
error in the log file, but it should not be a problem to the application.
Activate the CommLog in the driver settings and send a copy of the errant
session. Its located in C:\psqlodbc*.log.
>
> I searched for this table using grep and pg_dumpall as well as psql \dS
> and could not find anything. So I created one as described in the
> MSAccess-Help, but this didn't help. Still the fomat was invalid.
> I do not want to use this table anyway ( do I? ), so what to do?
>
I would drop the table unless you know what you are doing with MSysConf. At
least until you get on solid footing. It's improper configuration may
cause other problems.
------------------------------
Date: Thu, 11 Feb 1999 20:36:06 +0100
From: "Alejandro Alberola Arias" <alberola@bio.es>
Subject: JDBC: DatabaseMetaData and getPrimaryKeys
Hi,
I am using PostgreSQL 6.4 on a Linux box and its JDBC driver.
The problem is that the getPrimaryKeys() method of the
DatabaseMetaData class doesn't work for me.
Any ideas ?
Thanks.
Alejandro Alberola
alberola@bio.es
------------------------------
Date: Thu, 11 Feb 1999 20:51:42 +0100
From: Michael Meskes <Michael.Meskes@gmx.net>
Subject: Re: [INTERFACES] facing problem with ecpg
On Fri, Feb 12, 1999 at 12:42:34AM +0800, hoelc wrote:
> Hello,
> I've just upgrated my PostgreSQL system to version Postgres-6.4.2
> Now it has the *ecpg
> But I'm facing problem in using it, when I compile the C program with
> cc -o tryecpg tryecpg.c -lecpg -lpq
> the compiler can't recognize the " exec sql ", and give error massage
> Parse error before 'sql'
The exec sql should be there after running ecpg. ecpg is a preprocessor. You
have to feed you're source (should be named file.pgc BTW) through ecpg
before running cc. That is:
ecpg tryecpg.pgc
cc -o tryecpg tryecpg.c -lecpg -lpq
> What went wrong ? Please advise.
If this was not the problem we need more details.
> Thanks for giving me the address for the Oracle Pre*C/C++ programmer's guide, it
> is a good reference. But, it doesn't exactly reflect the ecpg, right? Is there
> any reference and example program for how to use ecpg?
The reference is pretty outdated but the source comes with three examples.
Oracle's Pro*C manual however is a good reference for the syntac of embedded
SQL, although it does not comply with the standard on some parts.
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: Thu, 11 Feb 1999 14:31:15 -0600
From: "John Barrett" <jbarrett@onramp.net>
Subject: Re: [INTERFACES] JDBC: DatabaseMetaData and getPrimaryKeys
This is a multi-part message in MIME format.
- ------Content-Type: text/plain;
charsetContent-Transfer-Encoding: 7bit
I've attached a quick and dirty little application in Java I use to transfer
data from one server to another
It uses the getPrimaryKeys call and works nicely... please excuse the lack
of documentation/comments :)))))
Might help ya to see a working app that uses the method.....
- -----Original Message-----
From: Alejandro Alberola Arias <alberola@bio.es>
To: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Date: Thursday, February 11, 1999 1:39 PM
Subject: [INTERFACES] JDBC: DatabaseMetaData and getPrimaryKeys
>Hi,
>
>I am using PostgreSQL 6.4 on a Linux box and its JDBC driver.
>
>The problem is that the getPrimaryKeys() method of the
>DatabaseMetaData class doesn't work for me.
>
>Any ideas ?
>
>Thanks.
>
>Alejandro Alberola
>alberola@bio.es
>
>
>
>
- ------Content-Type: application/octet-stream;
nameContent-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename
import java.sql.*;
import java.util.Vector;
class DBLogin
{
public String username;
public String password;
public String connurl;
public DBLogin(String u, String p, String c)
{
username = u;
password = p;
connurl = c;
}
}
class DBField
{
public int fnum;
public int ftyp;
public int fsiz;
public int fdig;
public String fnam;
public String fdef;
public DBField(ResultSet res) throws SQLException
{
fnum = res.getInt(17);
ftyp = res.getInt(5);
fsiz = res.getInt(7);
fdig = res.getInt(9);
ftyp = res.getInt(5);
fnam = res.getString(4).toLowerCase();
fdef = res.getString(6);
if (fdef.equals("VARCHAR2")) {
fdef = "VARCHAR";
}
if (fdef.equals("DATE")) {
fdef = "DATETIME";
}
if (fdef.equals("VARCHAR")) {
fdef = fdef + "(" + fsiz + ")";
}
if (fdef.equals("NUMBER")) {
if (fdig == 0) {
// integer
fdef = "int4";
} else {
if (fdig == 2) {
fdef = "money";
} else {
fdef = "decimal(" + fsiz + "," + fdig + ")";
}
}
}
fdef = fdef.toLowerCase();
}
public String toString()
{
return fnam + " " + fdef;
}
}
class DBXfer
{
Connection srcConn;
Connection dstConn;
DBLogin srcLogin;
DBLogin dstLogin;
public static void main(String argv[])
{
try {
Class.forName ("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Class.forName ("postgresql.Driver");
DriverManager.registerDriver (new postgresql.Driver());
} catch (Exception e) {
System.out.println("Cound Not Register Drivers");
return;
}
DBLogin srcLogin = new DBLogin("user","pass","jdbc:oracle:thin:@<host>:1521:ORCL");
DBLogin dstLogin = new DBLogin("user","pass","jdbc:postgresql://<host>/<db>");
DBXfer dbx = new DBXfer(srcLogin,dstLogin);
dbx.transfer(null,"schema","table");
}
public DBXfer(DBLogin src, DBLogin dst)
{
srcLogin = src;
dstLogin = dst;
try {
srcConn = DriverManager.getConnection(src.connurl,src.username,src.password);
} catch (Exception e) {
System.out.println("Could not open source connection: " + e);
return;
}
try {
dstConn = DriverManager.getConnection(dst.connurl,dst.username,dst.password);
} catch (Exception e) {
System.out.println("Could not open destination connection: " + e);
srcConn = null;
return;
}
}
public void transfer(String catalog, String schema, String table)
{
ResultSet res;
String srcsql;
String dstsql;
String pkey[];
int pmax;
DBField fdat[];
int fmax;
int i;
String com;
srcsql = "create table " + table.toLowerCase() + " ( ";
dstsql = "insert into " + table.toLowerCase() + " ( ";
com = "";
pmax = 0;
pkey = new String[16];
fmax = 0;
fdat = new DBField[100];
try {
DatabaseMetaData dmd = srcConn.getMetaData();
res = dmd.getColumns(catalog,schema,table,"%");
while (res.next()) {
DBField tmp = new DBField(res);
fdat[tmp.fnum] = tmp;
if (tmp.fnum > fmax) {
fmax = tmp.fnum;
}
}
for (i=1;i<fmax+1;i++) {
srcsql = srcsql + com + fdat[i].toString();
dstsql = dstsql + com + fdat[i].fnam;
com = ", ";
}
res = dmd.getPrimaryKeys(catalog,schema,table);
while (res.next()) {
//System.out.println("Primary("+res.getString(5)+"): " + res.getString(4));
pkey[res.getInt(5)] = res.getString(4);
if (res.getInt(5) > pmax) {
pmax = res.getInt(5);
}
}
if (pmax > 0) { // got a primary key
srcsql = srcsql + com + "primary key ( ";
com = "";
for (i=1; i<pmax+1;i++) {
srcsql = srcsql + com + pkey[i].toLowerCase();;
com = ", ";
}
srcsql = srcsql + " )";
}
srcsql = srcsql + " )";
System.out.println(srcsql);
// finish building destination insert statement
dstsql = dstsql + " ) values ( ";
com = "";
for (i=1;i<fmax+1;i++) {
dstsql = dstsql + com + "?";
com = ", ";
}
dstsql = dstsql + " )";
System.out.println(dstsql);
// we got everything we need.... lets do something with it !!
Statement dstcmd = dstConn.createStatement();
// drop the table if it exists
try {
dstcmd.executeUpdate("drop table " + table);
} catch (Exception e) {}
// create table using the definition we just assembled
System.out.println("creating table");
System.out.flush();
dstcmd.executeUpdate(srcsql);
// we got a table.... get the data
Statement srccmd = srcConn.createStatement();
System.out.println("accessing source data");
System.out.flush();
res = srccmd.executeQuery("select * from " + table);
// setup to store data to new table
System.out.println("building insert statement");
System.out.flush();
PreparedStatement dstins = dstConn.prepareStatement(dstsql);
// move that data !!
int cnt = 0;
String fld;
while (res.next()) {
System.out.println("======== Record: " + (++cnt));
System.out.flush();
for (i=1;i<fmax+1;i++) {
fld = res.getString(i);
if (fld == null) {
System.out.println(i + "\t" + fdat[i].ftyp + "\t" + fdat[i].fdig + "\t" + null);
} else {
System.out.println(i + "\t" + fdat[i].ftyp + "\t" + fdat[i].fdig + "\t" + fld.toString());
}
System.out.flush();
if (fld == null) {
dstins.setNull(i,fdat[i].ftyp);
} else {
dstins.setString(i,fld);
}
}
dstins.executeUpdate();
}
} catch (Exception e) {
System.out.println("Exception: " + e);
}
}
}
- ------
------------------------------
Date: Thu, 11 Feb 1999 17:59:29 -0500
From: "Stephen Turner" <stephen@edtechnews.com>
Subject: Help with ODBC
This is a multi-part message in MIME format.
- ------Content-Type: text/plain;
charsetContent-Transfer-Encoding: quoted-printable
subscribe me
I have Red Hat 5.2 with PostgreSQL 6.3.2 and I want to connect through the internet with ODBC. I'm currently working on
aproject with Visual Basic where I can connect to Postgres and edit the database. I did edit the pg_hba.conf but that
didn'tseem to help. I downloaded the driver from Insight and I notice in the configuration help that it refered to
somethingelse besides the 32bit ODBC applet in the Control Panel folder. I guess what I'm asking is how do I know when
I'mconnected through ODBC because I can't tell.
Thanks in advance
Stephen Turner
stephen@edtechnews.com
- ------Content-Type: text/html;
charsetContent-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>subscribe me</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I have Red Hat 5.2 with PostgreSQL 6.3.2 and I want to connect
through the internet with ODBC. I'm currently working on a project with Visual
Basic where I can connect to Postgres and edit the database. I did edit the
pg_hba.conf but that didn't seem to help. I downloaded the driver from Insight
and I notice in the configuration help that it refered to something else besides
the 32bit ODBC applet in the Control Panel folder. I guess what I'm asking is
how do I know when I'm connected through ODBC because I can't tell.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks in advance</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Stephen Turner</FONT></DIV>
<DIV><FONT size=2><A
href="mailto:stephen@edtechnews.com">stephen@edtechnews.com</A></FONT></DIV></BODY></HTML>
- ------
------------------------------
Date: Thu, 11 Feb 1999 18:04:00 -0500
From: "Stephen Turner" <stephen@edtechnews.com>
Subject: Help with ODBC in VB6
This is a multi-part message in MIME format.
- ------Content-Type: text/plain;
charsetContent-Transfer-Encoding: quoted-printable
subscribe
I have Red Hat 5.2 with PostgreSQL 6.3.2 and I want to connect through the internet with ODBC. I'm currently working on
aproject with Visual Basic where I can connect to Postgres and edit the database. I did edit the pg_hba.conf but that
didn'tseem to help. I downloaded the driver from Insight and I notice in the configuration help that it refered to
somethingelse besides the 32bit ODBC applet in the Control Panel folder. I guess what I'm asking is how do I know when
I'mconnected through ODBC because I can't tell.
Thanks in advance
Stephen Turner
stephen@edtechnews.com
- ------Content-Type: text/html;
charsetContent-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><FONT size=2></FONT><FONT color=#000000 size=2>subscribe</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I have Red Hat 5.2 with PostgreSQL 6.3.2 and I want to connect
through the internet with ODBC. I'm currently working on a project with Visual
Basic where I can connect to Postgres and edit the database. I did edit the
pg_hba.conf but that didn't seem to help. I downloaded the driver from Insight
and I notice in the configuration help that it refered to something else besides
the 32bit ODBC applet in the Control Panel folder. I guess what I'm asking is
how do I know when I'm connected through ODBC because I can't tell.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks in advance</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Stephen Turner</FONT></DIV>
<DIV><FONT size=2><A
href="mailto:stephen@edtechnews.com">stephen@edtechnews.com</A></FONT></DIV></DIV></BODY></HTML>
- ------
------------------------------
End of pgsql-interfaces-digest V1 #224
**************************************
