Thread
-
DBI/DBD anyone?
Vince Vielhaber <vev@michvhf.com> — 1998-06-23T19:16:54Z
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 ========================================================================== -
Re: [HACKERS] DBI/DBD anyone?
Edmund Mergl <e.mergl@bawue.de> — 1998-06-23T19:49:36Z
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
-
Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
Vince Vielhaber <vev@michvhf.com> — 1998-06-23T19:58:12Z
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 ========================================================================== -
Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
Vince Vielhaber <vev@michvhf.com> — 1998-06-23T20:03:37Z
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 ========================================================================== -
Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
Edmund Mergl <e.mergl@bawue.de> — 1998-06-23T20:11:21Z
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 -
Re: [HACKERS] DBI/DBD anyone?
Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl> — 1998-06-24T08:19:03Z
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 | -----------------------------------------------------------------------------
-
DBD-Pg is broken from Jun 20 snapshot ?
Oleg Bartunov <oleg@sai.msu.su> — 1998-07-01T13:52:24Z
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