search for: search_path

Hello! I''ve submitted a patch to work around a problem when multiple schemas are included in the search_path in database.yml for PostgreSQL databases. (Long story short: the pg_dump --schema flag only accepts a single schema.) http://dev.rubyonrails.org/ticket/6665 While I''ve tested the regex pattern used to check for multiple schemas, I''m unsure of how to properly write tests to...

...e_path = shift; > local $_; > > + return $input if File::Spec->file_name_is_absolute($input) and -f $input; Do you really need to use file_name_is_absolute? -f seems to work fine also with absolute paths. In case the path is relative, -f will be fine too, as... > my @search_path = ("."); > push (@search_path, @paths) if $use_path; > foreach (@search_path) { ... the first search path is always '.'. -- Pino Toscano

Building virt-v2v out-of-tree does not work and requires several small fixes here and there. Tomáš Golembiovský (3): build: perform gnulib check from source directory build: run ocaml-link.sh from build directory docs: don't perform lookup on absolute paths cfg.mk | 1 + podwrapper.pl.in | 2 ++ v2v/Makefile.am | 16 ++++++++-------- 3 files changed, 11 insertions(+), 8

...diff --git a/podwrapper.pl.in b/podwrapper.pl.in index f12a173f..1e4aa149 100755 --- a/podwrapper.pl.in +++ b/podwrapper.pl.in @@ -689,6 +689,8 @@ sub find_file my $use_path = shift; local $_; + return $input if File::Spec->file_name_is_absolute($input) and -f $input; + my @search_path = ("."); push (@search_path, @paths) if $use_path; foreach (@search_path) { -- 2.25.0

...the lookup will fail. Instead of letting it fall through maybe something like this would be more expressive: if File::Spec->file_name_is_absolute($input) { return $input if -f $input; die "$progname: $input: cannot find input file" } > > > my @search_path = ("."); > > push (@search_path, @paths) if $use_path; > > foreach (@search_path) { > > ... the first search path is always '.'. > > -- > Pino Toscano > _______________________________________________ > Libguestfs mailing list >...

I have found that the "schema.table" syntax used in Postgresql (and Oracle) does not work directly with RODBC. This works library(RODBC) con<-odbcConnect("mydb") d<-sqlQuery(con,"select * from meso.trees") However this does not. d<-sqlFetch(con,"meso.trees") Error in odbcTableExists(channel, sqtable) : ?meso.trees?: table not found on channel

Hi everyone. I''m having a bit of a problem with an application I''m currently developing with Rails 1.2.3 and PostgreSQL, attempting to use test-first development. Here''s the scenario: * I have the usual three databases, with migrations. Testing has been working beautifully. * I need to store geographic data, so I add PostGIS to all three databases (along with

...s is for the time being the easiest way to get support guys to add nodes to classes. I have to use global parameters in my modules if I would like to declare parameters using dashboard as the ENC. So I have a module which does this: class resolver ($domain_name=$::domainname, $search_path=$::searchpath, $name_servers=$::nameservers, ){ if ($name_servers == undef) { fail(''ensure at least the namesever parameter is defined'') } ... The 3 global parameters can be passed in using dashboard ENC. I have a requirement to add a name_server p...

...9; NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index ''service_spiels_pkey'' for table ''service_spiels'' -> 0.1989s == Service_spiels: migrated (0.1991s) ========================================== rake aborted! PGError: ERROR: Option ''search_path'' is not recognized : SHOW search_path Yes it pops with this error but the table was SUCCESSFULLY created! The search_path in my database.yml is commented out. Also, I tried one of the suggestions here at the forum of hardcoding my connection in my models: class ServiceSpiels < Acti...

...dexes. Index A is created offline by RDig and queried from the web via RDig (specifically, RDig.searcher.search). Index B is managed by AAF with :remote => true. Simple enough. However, I need to query both indexes from RDig. Usually this is ok, as I modified RDig to accept an array of search_paths with an element for index A and index B. However, when Index B is updated by AAF, RDig.searcher.search will not "see" the changes to Index B until I restart Mongrel (or restart script/console). If I query Index B directly through ClassB.find_by_contents("myfield:my_value&quot...

...ort-options. my @tool_options = (); open PIPE, "$tool --long-options |" @@ -235,11 +253,27 @@ printf "$progname: $tool: checked $tool_options_checked tool options, $pod_optio exit 0; +sub find_file +{ + my $input = shift; + my $use_path = shift; + local $_; + + my @search_path = ("."); + push (@search_path, @paths) if $use_path; + foreach (@search_path) { + return "$_/$input" if -f "$_/$input"; + } + die "$progname: $input: cannot find input file on path" +} + sub read_whole_file { my $input = shift; +...

...ifferent versions of db. So I decided to make following structure that seems much prettier for me megaproject_db - public schema (db info) - test schema - development schema - production schema Does anybody tried to make the same thing that I want to do? I found in wiki that I need to add schema_search_path to db config file. So first question: why so strange name for schema property?? I have looked through code and found that this property contains a list of schema name. And table names are looking for thought all this schemas. I am wonder, is anybody need it (i mean multiply schemas)? Well, after...

...ase queries in a single request, are they guaranteed to use the same database connection handle? We have an application using postgresql where users have their own schema''s. I have before and after filters using ActiveRecord::Base.connection.execute that set the session authorization and search_path, then I do 1 or 2 queries using AR. I want to make sure that the queries using AR are using the same connection handle as the before and after filters are. I''m assuming that rails assigns one connection handle per request, but I wanted to make sure. Chris

...ike to access /home/dumbboy/files/deleteme, what is the key to be used, and how the lookup/match happens? and how the mount operations happens? Thanks a lot. I've attached my configuration files below: $ cat /etc/amd.conf ... auto_dir = /.amd_mnt ... map_type = file search_path = /etc ... [ /home ] map_name = amd.home ... $ cat /etc/amd.home /defaults type:=nfs;sublink:=${key};opts:=rw,intr,tcp,nfsvers=3,vers=3,nosuid,nodev,noresvport,rsize=16384,wsize=16384;fs:=${autodir}/${rhost}${rfs} dumbboy rhost:=home111;rfs:=/0/export/home * rhost:=home110;r...

I want to return my own error messages from an API instead of letting the client see the stack trace. I''m returning a custom structure so I guess I could just put a member in that structure for the error message, although that seems like kind of a hack. Any suggestions? Chris

v1 was here: https://www.redhat.com/archives/libguestfs/2019-November/msg00271.html In v2 I just updated the way paths are handled. Note this series requires the following patch to common which adds the common/options/key-option.pod file: https://www.redhat.com/archives/libguestfs/2019-November/msg00269.html Rich.

Hi, How should I use Activerecord to map to a database schemas with Psotgresql? Where can I find the infomation about how to use schemas in Rails? Thanks you very much Saiho __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

...g with this library; if not, write to the Free Software +# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + +package Sys::Guestfs::GuestOS; + +use strict; +use warnings; + +use Module::Pluggable::Ordered sub_name => 'modules', + search_path => 'Sys::Guestfs::GuestOS', + require => 1; + +use Carp; + +=pod + +=head1 NAME + +Sys::Guestfs::GuestOS - Guest OS specific queries and manipulation + +=head1 SYNOPSIS + + use Sys::Guestfs::GuestOS; + + $guestos = Sys::Guestfs::GuestOS->get_instance($...

...cy database on PostgreSQL. Since the old database had some really ughly and weird naming conventions (like CamelCase). To work around this I created a second schema (named rails) in the same database and gave the tables and fields some rails-friendly names. The database user that Rails uses has its search_path set to the rails schema. That way Rails won''t try to find models for the legacy tables. This worked fine so far. I even got triggers working to be able to write into the real tables. Now I installed RSpec and tried running some tests. This failed because the test database gets recreated o...

I am using asterisk 1.6.1.6 and have been setting up a system to use a Postgresql database as the realtime DB via the ODBC route. I have got extensions and voicemail working but am having trouble with SIP The problem seems to be with using a schema. If I put the table "sip" in the schema "foo" then I add this entry to extconfig.conf sippeers => odbc,psqldb,foo.sip Restart