title: Error calling function postgresql .NET
body: <p>ERROR: 42883: function insertvideo(character varying, character varying, double precision, integer) does not exist</p>
  
  <p>But that Stored Procedure exist!!! Why continue this error???</p>
  
  <p>This is my connection string: </p>
  
  <pre><code> &lt;connectionStrings&gt;
          &lt;add name="myConnection" connectionString="Server=127.0.0.1; 
                     User Id=postgres; Password=myPass; Database=myDB; "/&gt;
        &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>Stored Procedure is in <code>public</code> schema and work correctly.</p>
  
  <pre><code>    using (NpgsqlConnection conn = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["AxWaveConnection"].ToString()))
      {
          try
          {
              conn.Open();
          }
          catch (Exception ex)
          {
              Console.WriteLine(ex.Message);
          }
  
          NpgsqlCommand cmd = new NpgsqlCommand("insertvideo", conn);
          cmd.CommandType = System.Data.CommandType.StoredProcedure;
  
  
          cmd.Parameters.Add(new NpgsqlParameter("out_scope_id", NpgsqlDbType.Bigint));
              cmd.Parameters["out_scope_id"].Direction = ParameterDirection.Output;
  
          cmd.Parameters.Add(new NpgsqlParameter("in_youtubeidvideo", NpgsqlDbType.Varchar, 15));
          cmd.Parameters["in_youtubeidvideo"].Value = VideoId;
  
          cmd.Parameters.Add(new NpgsqlParameter("in_title", NpgsqlDbType.Varchar, 200));
          cmd.Parameters["in_title"].Value = Title;
  
          cmd.Parameters.Add(new NpgsqlParameter("in_rating", NpgsqlDbType.Double));
          cmd.Parameters["in_rating"].Value = Rating;
  
          cmd.Parameters.Add(new NpgsqlParameter("in_viewcount", NpgsqlDbType.Integer));
          cmd.Parameters["in_viewcount"].Value = ViewCount;
  
  
          try
          {
              cmd.ExecuteNonQuery();
  
              scopeID = Convert.ToInt64(cmd.Parameters["out_scope_id"].Value);
          }
          catch (Exception e)
          {
              scopeID = -1;        //Duplicate Record
          }
  
          conn.Close();
  </code></pre>