clsql-postgresql store and view-database

[petter]

When using the clsql-postgresql backend I get an error when a sql
query is made since it tries to select a field called view-database:

SQL-DATABASE-DATA-ERROR: While accessing database #<POSTGRESQL-
DATABASE ..": Error #.(SB-SYS:INT-SAP #X0063D6D9) / column
blob.view_database does not exist has occurred.

It seems like it will use all the slots in the object to create the
field names, e.g.

(clsql:def-view-class blob () ((id :accessor blob-id :initarg :id)))
(describe (make-instance 'blob))
#<BLOB {1003DAFD31}>
is an instance of class #<CLSQL-SYS::STANDARD-DB-CLASS BLOB>.
The following slots have :INSTANCE allocation:
ID #<unbound slot>
VIEW-DATABASE NIL

I guess it should exclude the view-database slot in this process.

[petter]

On Nov 24, 3:42 pm, petter <petter.gus...@gmail.com> wrote:

> I guess it should exclude the view-database slot in this process.

Or simply just a note in the docs that you should always add a (view-
database :hidep t) with the clsql backend.

[Leslie P. Polzer]

Yeah, different stores need slightly different handling...