reset password
Author Message
sikandarahmad
Posts: 19
Posted 16:27 Jan 28, 2015 |

I am setting CSNS2 project on my local, while running the Database create scripts got the following error.

any idea?

create function resources_ts_trigger_function() returns trigger as $$

declare
    l_filename  varchar

ERROR: unterminated dollar-quoted string at or near "$$
declare
    l_filename  varchar"
  Position: 68

cysun
Posts: 2935
Posted 16:43 Jan 28, 2015 |

Are you using Eclipse's DB Explorer plugin to run the script? DB Explorer does not recognize anything other than basic SQL syntax. To run the script you can use the command line client psql or the GUI client pgadmin.

lishenyu
Posts: 103
Posted 18:50 Feb 02, 2015 |

professor , do we need to create two databases , one for csns_create.sql   one for csns_drop.sql ? and what's the owner of this database ?

cysun
Posts: 2935
Posted 20:50 Feb 02, 2015 |
lishenyu wrote:

professor , do we need to create two databases , one for csns_create.sql   one for csns_drop.sql ? and what's the owner of this database ?

Just one database. The owner can be anyone - just remember to change db.username and db.password in build.properties accordingly.