similar to: Rails and PostgreSQL bytea

Hi! I want to escape binary data correctly either manually or using some pre-defined function that does this for me! I have found on the web: PGconn.escape_bytea but I only get "undefined method". Any ideas, what is the correct way of doing this my self? I''m using Rails (WEBrick) under Windows XP with postgre-pr 0.4.0 I have tried: s_buffer = s_buffer.gsub(/['']/,

Is there a built-in function that handles the problem of bitstreams in postgresql? The problem occurs when the stream contains for example the " character. Postgres will think that the string has ended with that character. Is there a function that changes all such characters into "\[ASCII-number]"? And the other way around when getting the stream back from the database? References:

Hello, So I''ve realized one of the columns in a table has to be binary instead of text. However, a straightforward change_column :my_table, :my_column, :binary fails under PostgreSQL (9.x series) The error message being: PGError: ERROR: column "my_column" cannot be cast to type bytea : ALTER TABLE "my_table" ALTER COLUMN "my_column" TYPE bytea Now

Hello! I have a problem that is quite anoying! In side my Controller it is no problem to use the link_to_remote/remote_function function to produce html stuff to include in my .rhtml file. BUT if I want to do this in another object, for eample if I inside my controller (init_test) want to do like this: my_dropdown->get_html in which I want to perform the link_to_remote/remote_function

Is there an easy (and secure) way to search your database when you don''t know the number of parameters ahead of time? I can see doing it by concatenating together an sql query, but hopefully rails provides a more elegant way to do this with ActiveRecord without making a ginormous switch statement? For example, lets say my search form has 4 different input boxes. I only want the query

Hello all, Some time before Christmas, a project was started. The task was to enhance an existing LiveCD solution with User-mode Linux. A number of requirements was stated, where the greatest challenge was to fit 10 virtual routers within an old no-name PC with only 256MB Ram. And the solution must still be run from a LiveCD. Thanks to Xen, the task was possible to complete. -But, what does it

Hi We have an mailserver running RedHat Linux 9.0 with UW-IMAP (imap-2001a- 18.progeny.1.src.rpm), we have user mailboxes in /var/spool/mail/username using the default mbox storage method. Some users have home directories and some dont. They only connect through the POP3 server, not IMAP. We are now migrating both hardware and software to an new server running RHEL 4, i have copied all

Hi, I''m working on a web app that allows users to submit links to external sites. I''m curious if there are any special security considerations I should take aside from escaping the user input with h( )? Is it safe to directly link_to h(user_inputted_url), h(user_inputted_url) or could that be exploited in a way that I''m not thinking of. Thanks. -------------- next

Hello, i got 2 subnets and i want to be able to browse both network from one. I have tried to config samba as i think it shall be but it only works on one side. Anyone know how i shall config samba for this? /Rickard

Hello, Is there some things removed from the kernel.org kernels before the get into xen-unstable? I was just about to compile a new dom0 kernel, and couldn''t find the option for Buslogic SCSI driver i xen-unstable kernel synced earlier this morning. I find this a bit strange, as I know the option is there in kernel.org''s 2.6.16-rc2. The config option was somehow lost in 2.6.15

I''m currently using ruby-postgres (the compiled interface to PostgreSQL), and I''m seeing a huge performance hit with larger :binary fields in ActiveRecord subclasses owing, it appears, to the use of the bytea field type and the fact that using that datatype necessitates an in-memory "unescape" conversion. The best I can tell from looking at the Postgres Active

I'm trying to efficiently allow conversion of R objects to PostgreSQL bytea (raw binary) datatype within PL/R for persistent storage in Postgres tables. I have found R_serialize() which looks like what I need, -- e.g. R_serialize(object, NULL, FALSE, NULL) -- except that it is marked attribute_hidden. Is there some other externally available interface that I can use? Thanks, Joe

Hi, All I have an encountered an issue where the args field is not saved correctly to the database. I encounter an error like this: ActiveRecord::StatementInvalid (RuntimeError: ERROR C22021 M invalid byte sequence for encoding "UTF8": 0xcb3a H This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by

Hello! I have some questions about Wine and how/if it can be used with industrial communication like OPC (MicroSoft Com/DCom objects, DDE and more) My short question is: Can I use Wine to make OPC communication work with a Linux system. OPC "OLE for Process Control" A "general" standard for communication in industrial systems, that unfortunately is totally depending on

Hello I am developing X application nowI have one question about xorg-xf86-input-keyboard license I checked following file https://github.com/freedesktop/xorg-xf86-input-keyboard/blob/master/COPYING  This file show MIT licene And I found following file  https://github.com/freedesktop/xorg-xf86-input-keyboard/blob/master/src/lnx_kbd.c   * Portions based on kbdrate.c from util-linux 2.9t, which

Hi! I am running dovecot 2.1.16 on NixOS (http://nixos.org), and I have been fighting the dynamically loaded dovecot modules/plugins a bit. The problem is that in Nix/NixOS all packages are completely isolated from each other (each package has a separate /lib, /libexec, /bin etc, with only its own files in it). So dovecot has all its modules under

Hello all, Well, my local mirror now has CentOS 5.6! Yay! But, I cannot get it to install. A "yum update" and a "yum --skip-broken" yields me this: --> Processing Conflict: firefox conflicts xulrunner >= 1.9.2.14 --> Finished Dependency Resolution firefox-3.6.13-2.el5.centos.i386 from installed has depsolving problems --> firefox conflicts with xulrunner

Hi! I just ?cant get FCPPO (FirstClassPersonalPostOffice) installed. The FC client (8.005US.exe), installs ok. When installing fcpers80231.exe, I get info that "This version of windows is not supported.", right after I accept the license agreement. I have to kill wineserver to be able to continue work. The console window has following info:

I'm testing a TDM400P with FXO module to receive incoming calls from an analogue line and send it to a SIP device. To recieve callerid, I need to use cidsignalling=dtmf and cidstart=polarity. The problem is that when a call is finished, the TDM400P seems to require about 20 seconds to prepare for the next incoming call. If a new call comes in within 20 seconds after the previous call was

Dear R Users,I have a data set with several variables. One of these variables is the number of farms per county and I'd like to split this variable into two domains: (a) counties with fewer than 600 farms and (b) counties with 600 or more farms I've tried solving this problem for hours, but I'm new at R so I'm not getting there. if (x < 600) y <- x else z <- x didn't