
I'm sending this one to both hackers and interfaces (not sure which one
it really pertains to) but I have the reply-to set to interfaces.

Anyway...

I'm trying to set up dbd/dbi and all went well until I got to test DBD.
The README says it's for 6.2+, but fails when trying to create a table
like so:

CREATE TABLE builtin (
 bool    bool,
 char    char,
 char16  char16,
 text    text,
 date    date,
 int4    int4,
 int4_   int4[],
 float8  float8,
 point   point,
 lseg    lseg,
 box     box
)

I get the error:  ERROR:  parser: parse error at or near "char"

Same thing when I try to create it from psql.  Since I know I can
create tables all day long with the user I am at the time I have to
think there's something changed in PostgreSQL, although I didn't 
find anything that would point to the problem in any of the docs.
That's why I'm sending this to both lists.  Was there a change in 
datatypes or is there something wrong with the perl script that does
the test; I'm rather perl un-savvy!  I'm running 6.3 and perl 5.00404
on FreeBSD 2.2.6.

Anyone have any suggestions?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null
       # include <std/disclaimers.h>                   TEAM-OS2 
   Online Searchable Campground Listings    http://www.camping-usa.com
       "There is no outfit less entitled to lecture me about bloat
               than the federal government"  -- Tony Snow
==========================================================================



Tue, 23 Jun 1998 15:16:54 -0400 (edt)
Vince Vielhaber <vev@michvhf.com>
DBI/DBD anyone?
Vince Vielhaber wrote:
> 
> I'm sending this one to both hackers and interfaces (not sure which one
> it really pertains to) but I have the reply-to set to interfaces.
> 
> Anyway...
> 
> I'm trying to set up dbd/dbi and all went well until I got to test DBD.
> The README says it's for 6.2+, but fails when trying to create a table
> like so:
> 
> CREATE TABLE builtin (
>  bool    bool,
>  char    char,
>  char16  char16,
>  text    text,
>  date    date,
>  int4    int4,
>  int4_   int4[],
>  float8  float8,
>  point   point,
>  lseg    lseg,
>  box     box
> )
> 
> I get the error:  ERROR:  parser: parse error at or near "char"
> 
> Same thing when I try to create it from psql.  Since I know I can
> create tables all day long with the user I am at the time I have to
> think there's something changed in PostgreSQL, although I didn't
> find anything that would point to the problem in any of the docs.
> That's why I'm sending this to both lists.  Was there a change in
> datatypes or is there something wrong with the perl script that does
> the test; I'm rather perl un-savvy!  I'm running 6.3 and perl 5.00404
> on FreeBSD 2.2.6.
> 
> Anyone have any suggestions?
> 
> Vince.
> --
> ==========================================================================
> Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null
>        # include <std/disclaimers.h>                   TEAM-OS2
>    Online Searchable Campground Listings    http://www.camping-usa.com
>        "There is no outfit less entitled to lecture me about bloat
>                than the federal government"  -- Tony Snow
> ==========================================================================


use DBD-Pg-0.73.tar.gz and please report the version of DBD-Pg if you
have problems with this module.


Edmund
-- 
Edmund Mergl          mailto:E.Mergl@bawue.de
Im Haldenhau 9        http://www.bawue.de/~mergl
70565 Stuttgart       fon: +49 711 747503
Germany

Tue, 23 Jun 1998 21:49:36 +0200
Edmund Mergl <E.Mergl@bawue.de>
Re: [HACKERS] DBI/DBD anyone?
On Tue, 23 Jun 1998, Edmund Mergl wrote:

> use DBD-Pg-0.73.tar.gz and please report the version of DBD-Pg if you
> have problems with this module.

Looks like I found a site with an old version.  It's 0.63 and I just
ftp'd it yesterday!  Where do I find 0.73?  I don't see any reference
in the README.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null
       # include <std/disclaimers.h>                   TEAM-OS2 
   Online Searchable Campground Listings    http://www.camping-usa.com
       "There is no outfit less entitled to lecture me about bloat
               than the federal government"  -- Tony Snow
==========================================================================



Tue, 23 Jun 1998 15:58:12 -0400 (edt)
Vince Vielhaber <vev@michvhf.com>
Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
On Tue, 23 Jun 1998, Vince Vielhaber wrote:

> On Tue, 23 Jun 1998, Edmund Mergl wrote:
> 
> > use DBD-Pg-0.73.tar.gz and please report the version of DBD-Pg if you
> > have problems with this module.
> 
> Looks like I found a site with an old version.  It's 0.63 and I just
> ftp'd it yesterday!  Where do I find 0.73?  I don't see any reference
> in the README.

I just looked back to where I'd been and I see that Hermetica had the
reference to 0.73 so I just grabbed it.  Now I'm not sure where I found
0.63.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null
       # include <std/disclaimers.h>                   TEAM-OS2 
   Online Searchable Campground Listings    http://www.camping-usa.com
       "There is no outfit less entitled to lecture me about bloat
               than the federal government"  -- Tony Snow
==========================================================================



Tue, 23 Jun 1998 16:03:37 -0400 (edt)
Vince Vielhaber <vev@michvhf.com>
Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
Vince Vielhaber wrote:
> 
> On Tue, 23 Jun 1998, Edmund Mergl wrote:
> 
> > use DBD-Pg-0.73.tar.gz and please report the version of DBD-Pg if you
> > have problems with this module.
> 
> Looks like I found a site with an old version.  It's 0.63 and I just
> ftp'd it yesterday!  Where do I find 0.73?  I don't see any reference
> in the README.


As any other perl module from CPAN. Try 

        http://www.perl.com/CPAN/modules/by-module/DBD/

The multiplex dispatcher will automatically route your
request to the nearest CPAN site.

Edmund
-- 
Edmund Mergl          mailto:E.Mergl@bawue.de
Im Haldenhau 9        http://www.bawue.de/~mergl
70565 Stuttgart       fon: +49 711 747503
Germany

Tue, 23 Jun 1998 22:11:21 +0200
Edmund Mergl <E.Mergl@bawue.de>
Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
On Tue, 23 Jun 1998, Vince Vielhaber wrote:

> 
> I'm sending this one to both hackers and interfaces (not sure which one
> it really pertains to) but I have the reply-to set to interfaces.
> 
> Anyway...
> 
> I'm trying to set up dbd/dbi and all went well until I got to test DBD.
> The README says it's for 6.2+, but fails when trying to create a table
> like so:
> 
> CREATE TABLE builtin (
>  bool    bool,
>  char    char,
>  char16  char16,
>  text    text,
>  date    date,
>  int4    int4,
>  int4_   int4[],
>  float8  float8,
>  point   point,
>  lseg    lseg,
>  box     box
> )
> 
> I get the error:  ERROR:  parser: parse error at or near "char"
> 
> Same thing when I try to create it from psql.  Since I know I can

Hmmmm, isn't 'char' a reserved word? try to create this table with 
different column names....

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
|                   Department of Electrical Engineering                    |
|           Computer Architecture and Digital Technique section             |
|                          M.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------


Wed, 24 Jun 1998 10:19:03 +0200 (MET DST)
Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>
Re: [HACKERS] DBI/DBD anyone?
Hi,

after installing Jun 20 snapshot I 'm unable to compile DBD-Pg v 0.73
It seems that there were many changes in libpq. 
Edmund, did you try latest snapshots ?

	Regards,

		Oleg

cc -c -I/usr/local/pgsql/include -I/usr/local/include/pgsql -I/usr/include/pgsql -I/usr/lib/perl5/i686-linux/5.00404/DBI -I/usr/lib/perl5/site_perl/i686-linux/auto/DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2    -DVERSION=\"0.73\" -DXS_VERSION=\"0.
73\" -fpic -I/usr/lib/perl5/i686-linux/5.00404/CORE  dbdimp.c
In file included from /usr/local/pgsql/include/libpq/pqcomm.h:22,
                 from /usr/local/pgsql/include/libpq-fe.h:28,
                 from Pg.h:12,
                 from dbdimp.c:12:
/usr/local/pgsql/include/c.h:66: warning: useless keyword or type name in empty declaration
/usr/local/pgsql/include/c.h:66: warning: empty declaration
dbdimp.c: In function bd_db_ping':
dbdimp.c:140: structure has no member named fout'
dbdimp.c:140: too many arguments to function qPuts'
dbdimp.c:146: structure has no member named fin'
dbdimp.c:146: warning: passing arg 2 of qGetc' from incompatible pointer type
dbdimp.c:146: structure has no member named fin'
dbdimp.c:146: warning: passing arg 2 of qGetc' from incompatible pointer type
make: *** [dbdimp.o] Error 1

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Wed, 1 Jul 1998 17:52:24 +0400 (MSK DST)
Oleg Bartunov <oleg@sai.msu.su>
DBD-Pg is broken  from  Jun 20 snapshot ?