pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedDBI/DBD anyone?
6+ messages / 3 participants
[nested] [flat]
* DBI/DBD anyone?
@ 1998-06-23 19:16 Vince Vielhaber <vev@michvhf.com>
0 siblings, 2 replies; 6+ messages in thread
From: Vince Vielhaber @ 1998-06-23 19:16 UTC (permalink / raw)
To: Hackers <hackers@postgreSQL.org>; pgsql-interfaces
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
==========================================================================
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] DBI/DBD anyone?
@ 1998-06-23 19:49 Edmund Mergl <E.Mergl@bawue.de>
parent: Vince Vielhaber <vev@michvhf.com>
1 sibling, 1 reply; 6+ messages in thread
From: Edmund Mergl @ 1998-06-23 19:49 UTC (permalink / raw)
To: Interfaces <pgsql-interfaces@hub.org>; +Cc: Hackers <hackers@postgreSQL.org>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
@ 1998-06-23 19:58 Vince Vielhaber <vev@michvhf.com>
parent: Edmund Mergl <E.Mergl@bawue.de>
0 siblings, 2 replies; 6+ messages in thread
From: Vince Vielhaber @ 1998-06-23 19:58 UTC (permalink / raw)
To: Edmund Mergl <E.Mergl@bawue.de>; +Cc: Interfaces <pgsql-interfaces@hub.org>
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
==========================================================================
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
@ 1998-06-23 20:03 Vince Vielhaber <vev@michvhf.com>
parent: Vince Vielhaber <vev@michvhf.com>
1 sibling, 0 replies; 6+ messages in thread
From: Vince Vielhaber @ 1998-06-23 20:03 UTC (permalink / raw)
To: Edmund Mergl <E.Mergl@bawue.de>; +Cc: pgsql-interfaces
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
==========================================================================
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] DBI/DBD anyone?
@ 1998-06-23 20:11 Edmund Mergl <E.Mergl@bawue.de>
parent: Vince Vielhaber <vev@michvhf.com>
1 sibling, 0 replies; 6+ messages in thread
From: Edmund Mergl @ 1998-06-23 20:11 UTC (permalink / raw)
To: Vince Vielhaber <vev@michvhf.com>; +Cc: Interfaces <pgsql-interfaces@hub.org>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] DBI/DBD anyone?
@ 1998-06-24 08:19 Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>
parent: Vince Vielhaber <vev@michvhf.com>
1 sibling, 0 replies; 6+ messages in thread
From: Maarten Boekhold @ 1998-06-24 08:19 UTC (permalink / raw)
To: Interfaces <pgsql-interfaces@hub.org>; +Cc: Hackers <hackers@postgreSQL.org>; pgsql-interfaces
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 |
-----------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~1998-06-24 08:19 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-23 19:16 DBI/DBD anyone? Vince Vielhaber <vev@michvhf.com>
1998-06-23 19:49 ` Edmund Mergl <E.Mergl@bawue.de>
1998-06-23 19:58 ` Vince Vielhaber <vev@michvhf.com>
1998-06-23 20:03 ` Vince Vielhaber <vev@michvhf.com>
1998-06-23 20:11 ` Edmund Mergl <E.Mergl@bawue.de>
1998-06-24 08:19 ` Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox