Stack Overflow
Stack Overflow

Questions tagged [search-path]

124 questions
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
  • 147
  • 1
  • 2
  • 14
6
votes
2 answers

How do I change GCC's default search directory for crti.o?

I'd like to specify GCC's search directory for the startfile and endfile: crt1.o, crti.o and crtn.o. Passing -B on the command line to the GCC driver works, but is inconvenient. How do I modify the specs file…
Shaun Jackman
  • 956
  • 10
  • 15
5
votes
1 answer

Truncate if exists in psql function and call function

I have the following code to create a function that truncates all rows from the table web_channel2 if the table is not empty: create or replace function truncate_if_exists(tablename text) returns void language plpgsql as $$ begin select from…
Zoltán Domokos
  • 57
  • 1
  • 1
  • 3
5
votes
1 answer

SQL state: 42883, No function matches the given name and argument types. But that function actually exists

I have a server with PostgreSQL 8.1.23, with a function that works perfectly when it runs with postgres user, but with another user shows the SQL STATE: SQL state: 42883 This is my function: CREATE OR REPLACE FUNCTION fun_validatepost(integer,…
mmontes
  • 53
  • 1
  • 1
  • 3
5
votes
2 answers

search_path doesn't work as expected with currentSchema in URL

I encounter difficulties when configuring a custom search path for SQL queries, specifically when trying to locate objects within the public schema. The problem arises when I specify the currentSchema parameter in the database connection URL, as it…
spoonboy
  • 2,570
  • 5
  • 32
  • 56
5
votes
2 answers

Invalid Bundle Error (Possibly CocoaPods caused error)

Here is my Podfile: # Uncomment this line to define a global platform for your project platform :ios, '9.2' # Uncomment this line if you're using Swift use_frameworks! target 'My_App_Name' do pod 'LocationKit','~>3.0' pod 'Bolts' pod…
Burak
  • 525
  • 4
  • 24
5
votes
1 answer

Why does a PostgreSQL SELECT query return different results when a schema name is specified?

I have a PostgreSQL database table with 4 columns - labeled column_a, column_b, etc. I want to query this table with a simple select query: select * from table_name; I get a handful of results looking like: column_a |…
Eric Jankowski
  • 463
  • 4
  • 9
4
votes
1 answer

Runtime linker ignores RPATH in executable on solaris

I'm trying to compile samtools on a Solaris server where I do not have root. Samtools depends on zlib. The system zlib on this machine is not compiled with large file support, so compiling samtools against this version has the expected effect:…
Ryan C. Thompson
  • 40,856
  • 28
  • 97
  • 159
4
votes
4 answers

How to make my program search specific folders for dependencies?

When my program opens, before any of my code actually runs, it will automatically attempt to load various DLLs whose functions it imports. It looks in the folder that the app is in, and then in a few specific places like \Windows and…
Mason Wheeler
  • 82,511
  • 50
  • 270
  • 477
4
votes
2 answers

nltk doesn't add $NLTK_DATA to search path?

under linux,I have set env var $NLTK_DATA('/home/user/data/nltk'),and blew test works as expected >>> from nltk.corpus import brown >>> brown.words() ['The', 'Fulton', 'County', 'Grand', 'Jury', 'said', ...] but when running another python script,I…
Alex Luya
  • 9,412
  • 15
  • 59
  • 91
4
votes
4 answers

how can a Win32 App plugin load its DLL in its own directory

My code is a plugin for a specific Application, written in C++ using Visual Studio 8. It uses two DLL from an external provider. Unfortunately, my plugin fails to start because the DLLs are not found (I put them in the same directory as the plugin…
Jean-Denis Muys
  • 6,772
  • 7
  • 45
  • 71
4
votes
1 answer

How to use % operator from the extension pg_trgm?

I have my pg_trgm module installed. pg_trgm | 1.0 | extensions | text similarity measurement and index ... The schema set is extensions. To use it I have to run something like this select: extensions.similarity('hello','hallo'); I'm trying to…
Emerson R Orci
  • 85
  • 1
  • 6
3
votes
1 answer

PostgreSQL can I inherit search_path variable from a "group role"?

I know I can define the search_path variable for a login this way: ALTER ROLE myrole SET search_path=public, foo, bar; But if I use a lot of logins I will also use groups (groups in pgadmin which are in fact roles). I would like to define the…
regilero
  • 29,806
  • 6
  • 60
  • 99
3
votes
1 answer

How Do I Use System Variables In Delphi Search Path?

In Delphi XE2 I am setting up a search path. I would like to use a system variable, that I define, to shorten the strings of the various folders used in the search path. I do it like this: Search path : x:\Delphi Library\XTools;x:\Delphi…
Jonathan Elkins
  • 455
  • 5
  • 21
3
votes
3 answers

VisualStudio unit test doesn't find my DLL with P/Invoke. How can I fix this?

I'm working on Windows 7 with Visual Studio 2008. I have a .NET assembly that makes calls into a native DLL with P/Invoke. I have set up a separate .NET unit test project in my Visual Studio solution that tests the assembly by making various calls…
Daniel Oberlin
  • 91
  • 1
  • 6
1
2
3
…
8 9