World: r3wp
[PgSQL] PostgreSQL and REBOL
older | first |
Maarten 4-Dec-2007 [67] | If you have Command or the SDK write a wrapper using C Callbacks (google for that + rebol) and the /Library component |
xavier 5-Dec-2007 [68] | . |
MikeL 28-Mar-2011 [69] | I am trying PGSQL with Doc's protocol and getting 'open pgsql' error "** Script Error: find expected series argument of type: series object port bitse t ** Near: fast-query: either args: find port/target" This is Postgres 9.0 recently downloaded. Anyone having success with it? |
Dockimbel 28-Mar-2011 [70] | Have you provided a database name in the connection URL? |
MikeL 28-Mar-2011 [71x4] | Thanks Kaj.... looks like the NIC MAC is the only reliable one that meets the criteria. |
ouch wrong group | |
Doc I tried db: open pgsql://postgres:[xxxxxxxx-:-127-:-0-:-0-:-1]:5432/postgres/ where postgres is listed as a db on pgAdmin III | |
Ouch it's the trailing slash | |
Dockimbel 28-Mar-2011 [75x2] | Btw, you only need to provide the port-id if it's not the default one (5432). |
Let us know if it works ok with PostgreSQL v9.0. I haven't tested it since v7.3. | |
MikeL 28-Mar-2011 [77] | Will do. Thanks for your work on this enabler ... it's a long list of your work that i leverage. [looking for the donate button ....] |
Dockimbel 28-Mar-2011 [78] | It's on the http://cheyenne-server.orgsite at the bottom ;-) |
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. | |
older | first |