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
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, 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 ==========================================================================
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 ==========================================================================
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
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 | -----------------------------------------------------------------------------
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 | -----------------------------------------------------------------------------