Thread: DBI/DBD anyone?
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
==========================================================================
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
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 | -----------------------------------------------------------------------------
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