Unable to get started. function fhir_create_resource(unknown) does not exist

[Subhrajyoti Moitra]

Hello,
I am trying to use FHIRBase as my persistence engine for a small EMR System.
I have followed the installation instructions and successfully used the fhirbase.sql file and consequent commands to install it.

But when i try commands like,

SELECT fhir.fhir_create_resource('{"resource": {"resourceType": "Patient", "name": [{"given": ["Smith"]}]}}');

I get an error that function is not found, public schema gives me the same results.
What am I doing wrong? Please help and guide.

Thanks,
Subhro.


Exact Error:

ERROR:  function fhir.fhir_create_resource(unknown) does not exist
LINE 1: SELECT fhir.fhir_create_resource('{"resource": {"resourceTyp...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

[Subhrajyoti Moitra]

Can some one please help.. ? I am not able to make this work. Please guide.

Thanks a lot in advance
Subhro.

[Danil Kutkevich]

On Monday, February 15, 2016 at 7:52:37 AM UTC+3, Subhrajyoti Moitra wrote:
> Can some one please help.. ? I am not able to make this work. Please guide.

Hi, Subhrajyoti Moitra

How do you download fhirbase.sql?

From here https://github.com/fhirbase/fhirbase-plv8

or https://github.com/fhirbase/fhirbase ?

[Николай Рыжиков]

Looks like you have installed old version. Please for dstu2 and more advanced features use fhirbase-plv8. Readme on github has instructions how to install or build it.

--
You received this message because you are subscribed to the Google Groups "FHIRbase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to fhirbase+u...@googlegroups.com.
To post to this group, send email to fhir...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/fhirbase/f20b5ea2-b984-4555-ba38-68e5bc203373%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Subhrajyoti Moitra]

Thanks a lot folks.
I was able to install and run the queries. Now to develop the app.
Thanks a lot again.
Subhro.

[Sandy]

Hi Subhro,

- I have installed postgresSQL for windows from below link:

https://www.postgresql.org/download/windows/

- I am using pgAdmin4 client to connect to the server. I have created a Test database also.

Now, How can I execute 'fhirbase.sql' [given at below link] to my Test database :

https://raw.githubusercontent.com/fhirbase/fhirbase-build/master/fhirbase.sql

I want to run the query 'SELECT fhir_create_resource('{"resource": {"resourceType": "Patient", "name": [{"given": ["Smith"]}]}}');'

using pgAdmin4, But i am getting below error:  

Can you please guide me. Thanks in advance.

ERROR:  function fhir_create_resource(unknown) does not exist

LINE 1: SELECT fhir_create_resource('{"resource": {"resourceType": "...

               ^

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

********** Error **********

ERROR: function fhir_create_resource(unknown) does not exist

SQL state: 42883

Hint: No function matches the given name and argument types. You might need to add explicit type casts.

Character: 8