Stack Overflow
Stack Overflow

Questions tagged [search-path]

124 questions
224
votes
3 answers

How to check if a table exists in a given schema

Postgres 8.4 and greater databases contain common tables in public schema and company specific tables in company schema. company schema names always start with 'company' and end with the company number. So there may be schemas…
Andrus
  • 26,339
  • 60
  • 204
  • 378
64
votes
2 answers

How does the search_path influence identifier resolution and the "current schema"

Is it possible to define in which schema new tables get created by default? (Referred by "unqualified table names".) I've seen some details about using the "search path" in Postgres, but I think it only works while retrieving data, not creating. I…
thyandrecardoso
  • 801
  • 1
  • 7
  • 12
34
votes
5 answers

No schema has been selected to create in ... error

I am working on a Linux server that is hosted on Amazon's server and I have completely set up the server. The final thing I am trying to do is host one of my old projects that I created on the server which is in the Flask framework. I am trying to…
Omar_Jandali
  • 485
  • 2
  • 7
  • 18
32
votes
7 answers

Xcode 5 Framework/Library Search Path Absolute Address

I updated my Xcode to 5.0. I added some library/framework search paths and the path it's displaying is the absolute path. For example, if my folder is in my desktop it would display…
cessmestreet
  • 2,298
  • 3
  • 22
  • 42
18
votes
5 answers

controlling which project header file Xcode will include

My Xcode project builds to variations of the same product using two targets. The difference between the two is only on which version of an included library is used. For the .c source files it's easy to assign the correct version to the correct…
Jean-Denis Muys
  • 6,772
  • 7
  • 45
  • 71
15
votes
2 answers

User cannot use extension "uuid-ossp"

EDIT : there is no need for an extension anymore. You can now generate a uuid with the function gen_random_uuid() that is available by default since PostgreSQL 14. I am developing an application in which I decided to use UUIDs for the primary and…
Arnaud Denoyelle
  • 29,980
  • 16
  • 92
  • 148
13
votes
5 answers

PostgreSQL search_path change not working as advertised

I am using PostgreSQL 9.0.3 on RedHat. The database contains two schemas, public and wh. I created a new role called django. I want this user to use the wh schema as it's default. Following the manual, I did: ALTER USER django SET SEARCH_PATH TO…
talonsensei
  • 225
  • 2
  • 3
  • 12
13
votes
1 answer

Including headers from custom framework in XCode

Am I supposed to adjust FRAMEWORK_SEARCH_PATHS or HEADER_SEARCH_PATHS when I add custom frameworks to the project? I have MainProject.xcodeproject that links SomeFramework.framework that's simply dragged from "Products" in SomeFramework.xcodeproject…
Kornel
  • 97,764
  • 37
  • 219
  • 309
13
votes
3 answers

Unable to use crosstab in Postgres

Postgres 9.2.1 on OSX 10.9.2. If I run the following crosstab example query: CREATE EXTENSION tablefunc; CREATE TABLE ct(id SERIAL, rowid TEXT, attribute TEXT, value TEXT); INSERT INTO ct(rowid, attribute, value)…
Black
  • 5,023
  • 6
  • 63
  • 92
12
votes
3 answers

How to unmask a function in R, due to name collisions on searchpath

When I loaded package debug to debug a script with zoo objects, I got trouble: function index from zoo got masked by debug package. How can I unmask index? In general, how to deal with these name colliding problems? We just do not use debug package…
ahala
  • 4,683
  • 5
  • 27
  • 36
12
votes
2 answers

makefile : How to link object files from different subdirectory and include different search paths

I want to change the location of my test code (tsnnls_test_DKU.c) and I am unable to make change in makefile to reflect this folder change properly. Some help would be appreciated. I have two questions: 1) How to link object files from different…
Garima Singh
  • 1,410
  • 5
  • 22
  • 46
11
votes
1 answer

How to set default schema in Yii2

My Yii2 is setup with PostgreSQL. Instead of using separate database per project, I like to use schema for each project. Problem with later setup is that I can't figure out how to select default schema "defaultSchema" through configuration. I am…
hserge
  • 905
  • 1
  • 9
  • 12
11
votes
3 answers

PostgreSQL \dt command does not show *ALL* tables in search_path schemas

Why in PostgreSQL, when there are tables with the same name in different schemas, does \dt only include the table in the first schema listed in the search path, as per the example below? I'm interested in: the reason why this would be desirable,…
saint_utz
  • 125
  • 1
  • 5
10
votes
2 answers

Are we able to generate a list of loaded packages in R?

Is there a function where we can generate a list of required packages in R? Something similar to "pip freeze" so we can duplicate environments quickly?
Max
  • 982
  • 10
  • 21
9
votes
2 answers

How to use the MATLAB search path

I have some questions regarding the MATLAB Search Path: The current directory is on the search path, but why is it not in the output of "path"? Where can I find the complete search path? What are all the possible ways to add search…
Tim
  • 1
  • 141
  • 372
  • 590
1
2 3
…
8 9