Getting Error Executing Queries

29 views

Skip to first unread message

unread,

Jan 18, 2017, 9:53:17 AM1/18/17

to FHIRbase

Hi,

- I have installed postgresSQL for windows from below link:

- 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 :

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 someone 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.