Stack Overflow
Stack Overflow

Questions tagged [search-path]

118 questions
173
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
  • 22,189
  • 50
  • 171
  • 330
52
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
  • 681
  • 1
  • 5
  • 11
31
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,136
  • 2
  • 20
  • 41
16
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,602
  • 7
  • 40
  • 67
14
votes
4 answers

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

I am working on a linux server that is hosted on amazons server and I have completely setup the server and the final thing i am trying to do is host one of my old projects that I created on the server which is in Flask Framework. I am trying to run…
Omar_Jandali
  • 255
  • 2
  • 4
  • 13
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
  • 91,239
  • 30
  • 200
  • 278
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
  • 795
  • 1
  • 8
  • 10
11
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
  • 4,320
  • 5
  • 53
  • 75
10
votes
2 answers

User cannot use extension "uuid-ossp"

I am developing an application in which I decided to use UUIDs for the primary and foreign keys. For this purpose, I used the extension "uuid-ossp" which works fine in dev environment. Now, I am installing the testing environment. The database setup…
Arnaud Denoyelle
  • 25,847
  • 10
  • 73
  • 128
10
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,295
  • 2
  • 25
  • 33
10
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,102
  • 4
  • 15
  • 40
10
votes
2 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
  • 115
  • 1
  • 5
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
  • 122
  • 314
  • 481
7
votes
1 answer

Error:"Key ... is not present in table"

I have a table with a character varying(12) field in it which is its PRIMARY KEY. I ran this query SELECT * FROM bg WHERE bg_id ='470370111002' It selects a row from the table. All looks good. Then I try. INSERT INTO…
user3502355
  • 137
  • 1
  • 1
  • 10
1
2 3 4 5 6 7 8