Windows7 and user-defined procedure
От | el dorado |
---|---|
Тема | Windows7 and user-defined procedure |
Дата | |
Msg-id | E1OS8B6-0005zq-00.do_ra_do-mail-ru@f272.mail.ru обсуждение исходный текст |
Список | pgsql-general |
Hello! I have user-defined procedure (C procedure) realised in dll ('c_some_text_dll'). It is called in the following way: 1. CREATE OR REPLACE FUNCTION "app_text" () RETURNS text AS '$libdir/c_some_text_dll', 'getTextValueFromApplication' LANGUAGE 'c' VOLATILE RETURNS NULL ON NULL INPUT SECURITY INVOKER; 2. CREATE TABLE "log" ( "id" SERIAL, "value" TEXT DEFAULT app_text() NOT NULL ) So when called from my application some stored procedure containing 'INSERT INTO log...' there was the result of 'app_text()'in the field 'value'. It works in XP and Win2000. I'm trying to test in Windows 7 now and get an error when inserting data in table 'log': "Couldnot open relation base\16123\16222: No such file or directory". The file '16222' exists and represents the table 'log' itself. All the imaginable rights for files and directories are set- as it seems to me. One more detail - if I call this procedure from some other client application, f.e., psql (SELECT * FROM app_text()), beforethis INSERT - it begins to work in my application too. Are there any ideas? I'll appreciate any help. Thanks, Marina.
В списке pgsql-general по дате отправления: