Undeliverable Message - Mailing list pgsql-interfaces

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

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   Friday, February 12 1999   Volume 01 : Number 226



Index:

Re: [INTERFACES] facing problem with ecpg
Re: [INTERFACES] facing problem with ecpg
Undeliverable Message

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

Date: Fri, 12 Feb 1999 07:06:52 +0100
From: Michael Meskes <Michael_Meskes@topmail.de>
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: Fri, 12 Feb 1999 06:36:26 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Subject: Re: [INTERFACES] facing problem with ecpg

> 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

Michael, could you add a short section with this info to your ecpg sgml
documentation? Also, perhaps you would want to include an example on how
to set up a makefile with a general production rule.

                      - Tom

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

Date: Fri, 12 Feb 99 9:08:25 +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 #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         password         connurl     }
}

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         ftyp         fsiz         fdig         ftyp         fnam         fdef
        if (fdef.equals("VARCHAR2")) {
            fdef         }

        if (fdef.equals("DATE")) {
            fdef         }

        if (fdef.equals("VARCHAR")) {
            fdef         }
        if (fdef.equals("NUMBER")) {
            if (fdig                 // integer
                fdef             } else {
                if (fdig                     fdef                 } else {
                    fdef                 }
            }
        }
        fdef     }

    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         DBLogin    dstLogin         DBXfer dbx
        dbx.transfer(null,"schema","table");
    }

    public DBXfer(DBLogin src, DBLogin dst)
    {
        srcLogin         dstLogin
        try {
            srcConn         } catch (Exception e) {
            System.out.println("Could not open source connection: " + e);
            return;
        }
        try {
            dstConn         } catch (Exception e) {
            System.out.println("Could not open destination connection: " + e);
            srcConn             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         dstsql         com         pmax         pkey         fmax         fdat
        try {
            DatabaseMetaData dmd
            res             while (res.next()) {
                DBField    tmp                 fdat[tmp.fnum]                 if (tmp.fnum > fmax) {
                    fmax                 }
            }

            for (imax+1;i++) {
                srcsql                 dstsql                 com             }

            res             while (res.next()) {
                //System.out.println("Primary("+res.getString(5)+"): " + res.getString(4));
                pkey[res.getInt(5)]                 if (res.getInt(5) > pmax) {
                    pmax                 }
            }
            if (pmax > 0) { // got a primary key
                srcsql                 com                 for (ix+1;i++) {
                    srcsql                     com                 }
                srcsql             }

            srcsql             System.out.println(srcsql);

            // finish building destination insert statement
            dstsql             com             for (imax+1;i++) {
                dstsql                 com             }
            dstsql             System.out.println(dstsql);

            // we got everything we need.... lets do something with it !!
            Statement dstcmd
            // 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             System.out.println("accessing source data");
            System.out.flush();
            res
            // setup to store data to new table
            System.out.println("building insert statement");
            System.out.flush();
            PreparedStatement dstins
            // move that data !!
            int cnt             String fld;
            while (res.next()) {
                System.out.println("                System.out.flush();
                for (imax+1;i++) {
                    fld                     if (fld                         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                         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<META content</HEAD>
<BODY bgColor<DIV><FONT size+scribe me</FONT></DIV>
<DIV><FONT size/ONT> </DIV>
<DIV><FONT size/ONT> </DIV>
<DIV><FONT size*ve 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/ONT> </DIV>
<DIV><FONT size*nks in advance</FONT></DIV>
<DIV><FONT size/ONT> </DIV>
<DIV><FONT size.phen Turner</FONT></DIV>
<DIV><FONT size*
href
- - ------
- ------------------------------

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<META content</HEAD>
<BODY bgColor<DIV>
<DIV><FONT size/ONT><FONT color<DIV><FONT size/ONT> </DIV>
<DIV><FONT size*ve 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/ONT> </DIV>
<DIV><FONT size*nks in advance</FONT></DIV>
<DIV><FONT size/ONT> </DIV>
<DIV><FONT size.phen Turner</FONT></DIV>
<DIV><FONT size*
href
- - ------
- ------------------------------

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

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

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



pgsql-interfaces by date:

Previous
From: Dave Page
Date:
Subject: RE: [INTERFACES] pgAdmin v6.4.2
Next
From: Karsten Kaus
Date:
Subject: Re: [INTERFACES] ODBC - MSysConf