r3wp [groups: 83 posts: 189283]
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r3wp

[PgSQL] PostgreSQL and REBOL

MikeL
28-Mar-2011
[79]
Doc,   PgSQL does not have same 'send-sql' and /flat options.   Is 
there a reason they can not parallel the mySQL use?
Dockimbel
28-Mar-2011
[80]
No particular reason, this driver wasn't much used by me or others, 
so I haven't work on it  as much as on the MySQL one. For SEND-SQL 
support with options, it should be quite easy to add IIRC (just a 
matter of copy/pasting some code from MySQL driver).
MikeL
28-Mar-2011
[81]
It looks like copy and paste but it had a warning on it   --- ;--- 
Internals (do not touch!)---   ..... which I took as "[this means 
you!]" .... I will give it a try in later today
Dockimbel
28-Mar-2011
[82]
Yes, there's a few  insertions to do on lower-level parts. I'll take 
a few minutes to do it after lunch. Btw, I don't have any pgsql server 
available, nor have time to setup one, so I'll let you test and eventually 
debug the new version. ;-)
MikeL
28-Mar-2011
[83]
Yes ... much better idea ...  I will do that testing while you polish 
off Red!
Dockimbel
28-Mar-2011
[84]
This is the new version to try: http://softinnov.org/tmp/pgsql-protocol-091.r
MikeL
28-Mar-2011
[85x5]
I am trying some of the code from mySQL and get a PgSQL error "** 
Script Error: Invalid argument: TABLE
** Where: forever
** Near: to integer! trim pos"
I hit this on an earlier install before today's fix ... I had atributed 
it to a problem with PgSQL version 8.4 install.
It comes on CREATE Table as well as SQL without table references 
in it ... e.g. simple SELECT
The error message seems to be the problem ... the table is CREATEd 
and is usable from new rebol sessions which load the protocol fresh.
Thanks Doc.  I can work around that TABLE message using the pgAdmin. 
 The Send-SQL and /FLAT protocol updates work exactly the same as 
on MySQL for me.
Dockimbel
29-Mar-2011
[90x2:last]
Glad to hear that.
The cause of the error above is a communication protocol change, 
the driver was made for 7.x. It would need a good upgrade.