- postmodern-devel - mailman3.common-lisp.net

Re: [postmodern-devel] [Sbcl-devel] Possible bug in REFILL-INPUT-BUFFER
by Attila Lendvai 06 Oct '09

06 Oct '09

> 3: (SB-UNIX::NOTE-DANGEROUS-SELECT) > 4: (SB-IMPL::SUB-SUB-SERVE-EVENT NIL NIL) > 5: (SB-IMPL::SUB-SERVE-EVENT NIL NIL NIL) > 6: (SB-SYS:WAIT-UNTIL-FD-USABLE 13 :INPUT NIL) > 7: (SB-IMPL::REFILL-INPUT-BUFFER #<SB-SYS:FD-STREAM for "a socket" {100338FE81}>) > 8: (SB-IMPL::INPUT-UNSIGNED-8BIT-BYTE #<SB-SYS:FD-STREAM for "a socket" {100338FE81}> T NIL) > 9: (CL-POSTGRES::READ-UINT1 #<unavailable argument>) fyi, we have a postmodern branch which has a patch to make it use iolib as the socket backend. we also had some issues with sb-bsd-sockets before... i CC the postmodern list to give another data point why it's a good idea to have iolib as the socket backend. http://dwim.hu/darcsweb/darcsweb.cgi?r=HEAD%20postmodern;a=summary or darcs pull http://dwim.hu/darcs/postmodern/ hth, -- attila

3 8

[postmodern-devel] Anyone tried to use the new recursive with in Postgresql 8.4 with S-SQL?
by Sabra Crolleton 05 Oct '09

05 Oct '09

I can't seem to get the syntax right using s-sql. I can write a straight sql statement, but it looks ugly in the middle of a lisp program. Sample sql statement from the postgresql docs is: WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS ( SELECT g.id, g.link, g.data, 1, ARRAY[g.id], false FROM graph g UNION ALL SELECT g.id, g.link, g.data, sg.depth + 1, path || g.id, g.id = ANY(path) FROM graph g, search_graph sg WHERE g.id = sg.link AND NOT cycle ) SELECT * FROM search_graph; http://www.postgresql.org/docs/8.4/static/queries-with.html Sabra

2 1

[postmodern-devel] Using simple-date date class as :col-type
by Mitch Berkson 25 Sep '09

25 Sep '09

I have not been successful using the date class as a :col-type in a DAO. Here is what I have tried: (defclass cpa-address () ((id :col-type integer :accessor address-id) (start_date :col-type date :accessor address-start-date) (version :col-type integer)) (:metaclass postmodern:dao-class) (:keys id) (:table-name gt_address)) In the Postgres database, the field type of start_date is date. When I select a cpa-address DAO, I expect to see a symbol of type simple-date in the start_date slot, but what I get is a CL universal time. Should I be trying something else to take advantage of simple-date? Thanks for any help. Mitch

2 2

[postmodern-devel] "defined more than once in table.lisp" warnings
by Mitch Berkson 24 Sep '09

24 Sep '09

When I run a select-dao, the REPL prints a bunch of warnings like: Warning: (METHOD UPDATE-DAO (CPA-SERIES)) defined more than once in d:\lisp\postmodern\postmodern\table.lisp. Is this something I can fix? Thanks for any help. Mitch

2 5

[postmodern-devel] Error if SSL and no client cert and key files specified
by Mitch Berkson 05 Sep '09

05 Sep '09

If I call make-ssl-stream with *ssl-key-file* and *ssl-certificate-file* both nil, I get the following error: Error: A failure in the SSL library occurred on handle #<Pointer to type :VOID = #x02600208>. (Return code: 1)SSL error queue: error:140C5042:SSL routines:SSL_UNDEFINED_FUNCTION:called a function you should not call Does this mean that it's not possible to make a unilateral SSL connection? Should there be a more user-friendly error message? Thanks for any help. Mitch

2 3

[postmodern-devel] darcs patch: add support for the currval() and lastval() functions
by khaelin＠gmail.com 31 Aug '09

31 Aug '09

Sun Aug 30 19:25:12 CEST 2009 khaelin(a)gmail.com * add support for the currval() and lastval() functions

3 5

[postmodern-devel] Large objects support
by Nicolas Martyanoff 30 Aug '09

30 Aug '09

Hi, Is there a large object¹ support in development, or do you intend to add one in the future? 1. http://www.postgresql.org/docs/8.4/static/largeobjects.html Regards, -- Nicolas Martyanoff http://codemore.org khaelin(a)gmail.com

2 2

[postmodern-devel] Wildacrds in string patterns
by Sebastian Tennant 29 Aug '09

29 Aug '09

Hi all, What's the trick for using wildcards such as '%' in string patterns in queries? I can't find anything on it in the S-SQL reference and I've tried several different things - I either get a database error or the Emacs debugger kicks in complaining about an end of file, or some such problem. Regards, Sebastian -- Emacs' AlsaPlayer - Music Without Jolts Lightweight, full-featured and mindful of your idyllic happiness. http://home.gna.org/eap

2 2

[postmodern-devel] Using get-dao to somehow pull in foreign key linked fields?
by Sabra Crolleton 28 Aug '09

28 Aug '09

I was just going to display the fields in a record and my first thought was to use the relevant class and then just call get-dao and iterate over the slots, something like: (item (postmodern:get-dao 'countrynotes (parse-integer id)))) However, looking at the countrynotes definition, you quickly notice that it has a foreign key: ; shortened version of the countrynotes class (defclass countrynotes () ( (id :accessor id :col-type int4 :initarg :id ) (country-id :accessor country-id :col-type int4 :initarg :country-id :foreign-key (countries id)) (name :accessor name :col-type varchar :initarg :name ) (updated-at :accessor updated-at :col-type timestamp :initarg :updated-at )) (:metaclass postmodern:dao-class) (:table-name countrynotes)(:keys id)) In displaying the countrynote, I don't really want to show the country-id, I really want to display the name of the country instead, which is another table: (defclass countries () ( (id :accessor id :col-type int4 :initarg :id ) (name :accessor name :col-type varchar :initarg :name ) (updated-at :accessor updated-at :col-type timestamp :initarg :updated-at )) (:metaclass postmodern:dao-class) (:table-name countries)(:keys id)) I can easily write out the full required sql statement, but is there a simple way of just using the dao? Sabra

2 1

[postmodern-devel] Authentication
by Sebastian Tennant 27 Aug '09

27 Aug '09

Hi all, It seems it is not possible to connect to a local postgres server using the 'ident sameuser' authentication method - the two functions 'connect' and 'connect-toplevel' both require user and password arguments. I thought perhaps passing empty strings as user and password arguments might be the way to say "use the ident sameuser method" but alas, it raises the error: "Database error 28000: no PostgreSQL user name specified in startup packet" Perhaps this is a feature that is lacking, or am I missing something? Regards, Sebastian P.S. Apologies if this is a FAQ. A Gmane search of this list for 'ident sameuser' returned no results. -- Emacs' AlsaPlayer - Music Without Jolts Lightweight, full-featured and mindful of your idyllic happiness. http://home.gna.org/eap

3 2