clkao / plv8js-migrated

Automatically exported from code.google.com/p/plv8js
Other
0 stars 0 forks source link

replacing the plv8.start_proc function fails, depending on the length of the definiton #76

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
  Run the attached .sql file on a new database, e.g.,
  createdb test
  psql test -f test.sql

What is the expected output? What do you see instead?
  Expected:
    CREATE EXTENSION
    SET
    psql:test.sql:44: NOTICE:  init completed.
    CREATE FUNCTION
    ALTER FUNCTION
  Got:
    CREATE EXTENSION
    SET
    psql:test.sql:44: NOTICE:  init completed.
    psql:test.sql:44: ERROR:  SyntaxError: Unexpected token ILLEGAL
    DETAIL:  initv8() LINE 1: ��
    psql:test.sql:45: ERROR:  function initv8() does not exist

What version of the product are you using? On what operating system?
  plv8 1.5.0-dev1
  postgresql 9.2.4
  postgresql-libs 9.2.4
  v8 3.19.0
  Arch linux 3.9.6-1 x86_64

Please provide any additional information below.
  This problem seems to depend on the length of the function definition;
  therefore the comments in test.sql. With 2 more paragraphs, it goes away, too.
  In our use case (updating db from generated sql file), js functions  generated
  in init proc were not accessible, however, in this minimal example, they are…

  A workaround is to execute another plv8 command before, or set the
  plv8.start_proc to something else.

Original issue reported on code.google.com by chpas...@gmail.com on 19 Jun 2013 at 10:01

Attachments:

GoogleCodeExporter commented 9 years ago
4e1c881

Thanks for the report!

Original comment by umi.tan...@gmail.com on 22 Jun 2013 at 10:34