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

[postmodern-devel] cl-postgres/sbcl crashes with bogus stack frame
by david thompson 06 May '10

06 May '10

Any ideas what might trigger cl-postgres (postmodern 1.14) coming to its knees with the backtrace shown below? No error or condition description is given - sbcl (1.0.28) just retires from active duty and drops into the debugger with the ("bogus stack frame") indication. The postgresql server (8.3) log doesn't have any indication of trouble at the time cl-postgres seems to run into trouble. This seems to only happen intermittently (every few thousand queries), irreproducibly (doesn't seem to be associated with a specific query or anything along those lines), and only when the postgresql server is being utilized by several lisp instances concurrently. Thanks in advance for any input/ideas/troubleshooting suggestions... - Alan ... 32: ("bogus stack frame") 33: (SB-IMPL::SUB-SUB-SERVE-EVENT NIL NIL) 34: (SB-IMPL::SUB-SERVE-EVENT NIL NIL NIL) 35: (SB-SYS:WAIT-UNTIL-FD-USABLE 5 :INPUT NIL) 36: (SB-IMPL::REFILL-INPUT-BUFFER #<SB-SYS:FD-STREAM for "a socket" {C265BA9}>) 37: (SB-IMPL::INPUT-UNSIGNED-8BIT-BYTE #<SB-SYS:FD-STREAM for "a socket" {C265BA9}> T NIL) 38: (CL-POSTGRES::SKIP-BYTES #<unavailable argument> #<unavailable argument>) 39: (CL-POSTGRES::TRY-TO-SYNC #<SB-SYS:FD-STREAM for "a socket" {C265BA9}> T) 40: ((FLET #:CLEANUP-FUN-[FORM-FUN-[SEND-QUERY]389]390))[:CLEANUP] 41: (CL-POSTGRES::SEND-QUERY #<unavailable argument> #<unavailable argument> #<unavailable argument>) 42: ((LABELS #:G161)) 43: (SQLG::QUERY-CORE "select program from programs where programskey = '192828' ;" 20 #<unused argument>)

4 5

[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

[postmodern-devel] Add :add-column action to :alter-table
by Daniel White 25 Aug '09

25 Aug '09

Patch attached adds an :add-column action to :alter-table where the column should be the same form as a column in :create-table. For example: (:alter-table table :add-column col-name :type string :default "default")) -- Daniel White

2 1

[postmodern-devel] [S-SQL] Multiple rows in INSERT INTO clause
by Timur Sufiev 25 Aug '09

25 Aug '09

Is there some way in S-SQL to generate INSERT INTO clauses with multiple rows, e.g. "INSERT INTO \"table\" (a, b) VALUES (10, 20), (30, 40)" ? Desired sexp format is `(:insert-into table :set a (10 20) b (30 40)), transformation can work like a MAPCAR: stop processing values sequences as soon as the end of the shortest one is reached. The reason to have such a feature is a performance issue: having a sequence of rows to be inserted we want to minimize the overhead related with sending queries to db; one query inserting, say, 50 rows is certainly faster than 50 queries each inserting 1 row. I would prepare the patch myself, but the syntax of s-sql.lisp is a bit too tricky for me :(. -- Timur Sufiev -- Timur Sufiev

2 2