Questions tagged [search-path]

124 questions
3
votes
1 answer

Force PostgreSQL to use different schema in functions

I wanted to make an update function for a schema in PG SQL database. A test function is below. It doesn't work because it should never raise a notice, but will do that when running test_schema_update('second'). CREATE OR REPLACE FUNCTION…
Nux
  • 9,276
  • 5
  • 59
  • 72
3
votes
1 answer

Attaching a temporary namespace to the search path

This question is sort of a follow up to this post as I'm still not fully convinced that, with respect to code robustness, it wouldn't be far better to make typing namespace::foo() habit instead of just typing foo() and praying you get the desired…
Rappster
  • 12,762
  • 7
  • 71
  • 120
3
votes
2 answers

What do double quotes signify in Xcode's search paths?

Tonight we had an annoying issue that only presented itself in Xcode's command line builds, not from Xcode's GUI. When building from a machine with Xcode's GUI with a recursive User Header Search path of $PROJROOT, without double quotes, we…
Matt Foley
  • 921
  • 1
  • 8
  • 24
2
votes
1 answer

How to set search path of a process created from CreateProcess

I am using CreateProcess to invoke cl to compile and link another C++ program (TestProg.cxx) into a DLL. I invoke cl.exe with the following compilation options: compilation options: /Od /nologo /Fo /RTC /w /Zc TestProg.cxx /DLL the call: if (…
2
votes
1 answer

Matlab addpath() does not stick on the path when current directory is changed?

I have matlab_xunit, which is a folder with a bunch of functions used for writing unit tests. It's stored in ../external/matlab_xunit. I want to call runtests which is part of this package. Here is the sample…
cinny
  • 2,292
  • 3
  • 18
  • 23
2
votes
1 answer

Postgresql search_path issue

Based on past experience and documentation related to search_path: "The first matching table in the search path is taken to be the one wanted. If there is no match in the search path, an error is reported, even if matching table names exist in other…
Mike Laz
  • 21
  • 1
2
votes
1 answer

Are RLS policy definitions affected at runtime by the search_path?

While answering this question, I gave some (unfounded) advice on create policy test_policy on policy for all to public using ( user_id = session_user_id()); Btw, you should schema-qualify the session_user_id() call to make your policy…
Bergi
  • 630,263
  • 148
  • 957
  • 1,375
2
votes
1 answer

How does R find S3 methods? Why can't R find my S3 `+` method?

I would like to create and attach an environment containing S3 methods and have R find them in the search path, by using the method name (i.e., I should be able to get infix-style a + b to work and not have to write prefix-style "+.Foo"(a, b)). What…
Ana Nimbus
  • 635
  • 3
  • 16
2
votes
1 answer

Setting search_path in sql dump

In a psql dump from a database using pg_dump version 11.4, the search_path is set as follows: SELECT pg_catalog.set_config('search_path', '', false); I am attempting to another schema (i.e. not public), and make this new schema the default one for…
Daniel Soutar
  • 827
  • 1
  • 10
  • 24
2
votes
1 answer

Algorithm A-star with rotation

I have a question. If it is possible to add rotation to my algorithm. I mean, for example if I want to go from (0,0) to (0,1) first of all i need to rotate and then go to that field. I don't have any ideas how to do that. My implementation of…
Michał Kruk
  • 155
  • 1
  • 10
2
votes
0 answers

.Rprofile's search path is not the same as the default one

Consider the two lines below: Sys.setenv(R_IMPORT_PATH = "/path/to/my/r_import") foo <- modules::import("foo") If I execute this code from within an already-established interactive R session, it works fine. But if I put the same two lines in my…
kjo
  • 33,683
  • 52
  • 148
  • 265
2
votes
2 answers

PostgreSQL search_path issue using pg_dump created plain .sql file

Created a Postgres plain text SQL file using pg_dump. When importing the text SQL file using the psql -f everything seems to be running fine. But the newly imported databases is missing the search_path. The source database has the search_path, I…
varun7447
  • 574
  • 1
  • 6
  • 27
2
votes
2 answers

Find a directory in shared library search path

I want dlopen() every shared library in a specific directory. In order to do that, what is the cleanest way to retrieve linux's library search path. Or Is there a quicker way of find a specific directory in that path ? posix would be better.
David Larochette
  • 1,200
  • 10
  • 18
2
votes
1 answer

Additional module citext is installed, but type "citext" not found?

I'm trying to run an inline query on my database - which has the citext extension installed (using CREATE EXTENSION) - and yet the executed query keeps throwing this error when calling a function: type "citext" does not exist DO LANGUAGE…
2
votes
1 answer

Matlab: search path locked for editing?

I have written some database management software in Matlab. Occasionally data is labeled incorrectly and must be moved manually using windows explorer. All of the folders of the database are in the matlab search path via addpath(DataBaseRootDir). …
Brandon Dube
  • 428
  • 1
  • 10
  • 26
1 2
3
8 9