That worked. Thank you.
Don
On 06/24/2011 09:43 AM, JP wrote:
Hi there Donald,
Yes i think that might be an error in the Wiki, as pointed out in some
other post to the mailing list
Have you tried :
select count(*) from fps where
morganbv%morganbv_fp('Cc1ccc2nc(-c3ccc(NC([C@H]4N(C(c5cccs5)=O)CCC4)=O)cc3)sc2c1',2);
What happens? (should work)
Cheers
Jean-Paul Ebejer
Early Stage Researcher
InhibOx Ltd
Pembroke House
36-37 Pembroke Street
Oxford
OX1 1BP
UK
(+44 / 0) 1865 262 034
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. Any unauthorised dissemination or copying of this email
or its attachments, and any use or disclosure of any information
contained in them, is strictly prohibited and may be illegal. If you
have received this email in error please notify the sender and delete
all copies from your system.
We and our group companies accept no liability or responsibility for
personal emails or emails unconnected with our business.
Internet communications including emails and access and use of web
sites cannot be guaranteed to be secure or error free as information
can be intercepted, corrupted, lost or arrive late. Furthermore, while
we have taken steps to control the spread of viruses on our systems,
we cannot guarantee that this email and any files transmitted with it
are virus free. No liability is accepted for any errors, omissions,
interceptions, corrupted mail, lost communications or late delivery
arising as a result of receiving this message via the Internet or for
any virus that may be contained in it.
On 24 June 2011 17:39, Donald Keidel <[email protected]
<mailto:[email protected]>> wrote:
Hi,
I have successfully built the cartridge, loaded the emolecules
database,
and can perform substructure and exact searches. I am however
having a
hard time performing similarity searches. I am following the tutorial
at: http://code.google.com/p/rdkit/wiki/DatabaseCreation2
The command I am having problems with is the following from the
tutorial
(all others have worked fine):
DB=# select count(*) from fps where
mfp2%morganbv_fp('Cc1ccc2nc(-c3ccc(NC([C@H]4N(C(c5cccs5)=O)CCC4)=O)cc3)sc2c1',2);
ERROR: column "mfp2" does not exist
LINE 1: select count(*) from fps where
mfp2%morganbv_fp('Cc1ccc2nc(-...
As you can see I get an error that tells me that column mfp2 does
not exist.
When I check this in postgres I see the following for my DB:
DB=# \d fps
Table "public.fps"
Column | Type | Modifiers
-----------+---------+-----------
id | integer |
pairbv | bfp |
torsionbv | bfp |
morganbv | bfp |
Indexes:
"apbvidx" gist (pairbv)
"mfp2idx" gist (morganbv)
"torsionbvidx" gist (torsionbv)
Foreign-key constraints:
"fps_id_fkey" FOREIGN KEY (id) REFERENCES mols(id)
As you can see the Column does not exist. Is the command incorrect in
the tutorial?
Thank you in advance for any help.
Don
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and
makes
sense of it. Business sense. IT sense. Common sense..
http://p.sf.net/sfu/splunk-d2d-c1
_______________________________________________
Rdkit-discuss mailing list
[email protected]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense..
http://p.sf.net/sfu/splunk-d2d-c1
_______________________________________________
Rdkit-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
