because R gives access to system commands and the
file system. No way around it at the moment, nor in the foreseeable future.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, 24x7 Support
--
Sent via pgsql
and willingness to help has been awesome.
Sounds good -- let us know if the problem resurfaces.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin
postgres 26631 17001 0 10:22 ?00:00:00 postgres: postgres
contrib_regression [local] idle
#gdb /usr/local/pgsql-head/bin/postgres 26631
(gdb) continue
Continuing.
Session #1: (run crashing function)
-
run your PL/R function that causes the crash
--
Joe Conway
credativ
)?
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
://www.postgresql.org/docs/8.3/interactive/kernel-resources.html#AEN22246
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
of PL/R or is it sometimes happening
independently?
If you believe it is PL/R specific, please give us R version and PL/R
version. Also, any chance we can get a debugger on a core file? Can you
reproduce this on a development machine?
Thanks,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
the
array element is NULL
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
different meanings.
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
dblink_disconnect('conn_test');
else
PERFORM dblink_connect('conn_test', 'dbname=database_test');
How can write my new function?
See dblink_get_connections():
http://www.postgresql.org/docs/9.0/interactive/contrib-dblink-get-connections.html
HTH,
Joe
--
Joe Conway
credativ LLC: http
with Net::FTP?
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, 24x7 Support
signature.asc
Description: OpenPGP digital signature
On 04/05/2010 01:46 PM, Kevin Grittner wrote:
Scott Marlowe scott.marl...@gmail.com wrote:
Timothy Madden terminato...@gmail.com wrote:
My scenario is how to protect the database if the machine is
stolen (it is a mini-laptop), and I would like to encrypt the
entire database, that is all
On 04/03/2010 06:35 AM, Timothy Madden wrote:
I can only see how PostgreSQL encrypts the password or the connection
in the documentation, and for the database I can see application-level
encryption with pgcrypto (and filesystem level encryption), How could
I get database level encryption in
lcar...@ucsd.edu wrote:
Does anyone have experience using the feature in PG 8.4 (maybe earlier
versions too??) to store specific columns in an encrypted format? We are
gathering sensitive data for medical studies and want to use Postgresql,
however, we need to insure that the data is secure
Jessica Richard wrote:
I need to joint select from table A in the current database A and dblink
to table B in database B, the result coming from tableB in db B is very
slow because I have to select all the rows from tableB from dblink then
do where with table A in the current dbdoing
Jessica Richard wrote:
I installed the dblink module, run dblink.sql to my current database to
use the dblink function, but I have not been successful to select a
table from a remote database (cross reference).
Whoever knows how to use dblink, please show me the syntax to select
another
Joshua Marsh wrote:
Does/Can the index track each element in the array, or does it track
only the array as a whole?
Built in index support works on the array as a whole, not the individual
elements.
How can I increase the speed of a query like: SELECT * FROM table WHERE
123 =
Matthew D. Fuller wrote:
On Wed, Nov 16, 2005 at 10:29:09AM -0500 I heard the voice of
Tom Lane, and lo! it spake thus:
The existence of this algorithm is disturbing, since it implies that
MD5 is weaker than people thought,
It occurs to me that, controlling everything that would be poking
Chris Hoover wrote:
Has anyone had problems with memory exhaustion and dblink? We were
trying to use dblink to convert our databases to our new layout, and had
our test server lock up several times when trying to copy a table that
was significantly larger than our memory and swap.
Basically
Marek Lewczuk wrote:
I've made some tests with plperl and I see that when plperl function is
executed for the first time, then it takes much more time. I know that
this is a shared library problem - is there a way to preload plperl
every connection or maybe I can build plperl into postgresql
Mª José Sempere wrote:
We are interested in installing the pgcrypto module of PostgreSQL for
Windows, In order to use the function digest() for creating index on
bytea type fields:
create unique index my_index on my_table (digest(my_bytea_field,
'md5'));
Um, why would you want to use digest()
Devrim GUNDUZ wrote:
I think we can release beta4 rpms this weekend or so. I'll also try to
build rpms for RCs.
I haven't found the time to update it since beta2, but you might want to
start with this:
http://www.joeconway.com/postgresql-8.0.0beta/SRPM/postgresql-8.0.0beta2-1PGDG.src.rpm
HTH,
Tom Lane wrote:
Joe Conway [EMAIL PROTECTED] writes:
On that, note that I specifically removed jdbc and tcl options from the
spec file because the 8.0.0 release notes said they were removed from
the distribution. I suppose at lease jdbc should be put back? It didn't
seem right to include
Tom Lane wrote:
Well, *Marc* is working on including less stuff; the rest of us don't
necessarily agree. In particular I've got to re-incorporate any major
pieces that get removed from the core distribution, since people expect
to find those in the RPM set. (In principle I suppose they could be
Joe Conway wrote:
Version 2 of the source rpm is now available here:
http://www.joeconway.com/postgresql-8.0.0beta1/SRPM/postgresql-8.0.0beta1-2PGDG.src.rpm
I've also put up i386 binary rpms for fc1 and fc2, and x86_64 binary
rpms for fc2.
Hopefully the third try is a charm ;-)
Version 3 is now
Tom Lane wrote:
Joe Conway [EMAIL PROTECTED] writes:
Hopefully the third try is a charm ;-)
Version 3 is now available: fixes the init script. Previously
/etc/init.d/postgresql worked the first time used (i.e. would initdb and
start postgres) but not the second and subsequent times.
[ blink
Joe Conway wrote:
Steve Bergman wrote:
Anyone have an SRPM of spec file for the beta?
I just created and posted a source RPM for 8.0.0beta1. As I'm not the
usual packager, and a pure hack when it comes to building my own RPMs,
it would be a Good Thing(tm) if someone else could vet this package
Steve Bergman wrote:
Anyone have an SRPM of spec file for the beta?
I just made one; see:
http://www.joeconway.com/postgresql-8.0.0beta1/
There are also Fedora Core 2 binaries there.
One caveat -- I am not the normal package maintainer, so no guarantees ;-).
HTH,
Joe
Lee Wu wrote:
I have some C functions (was compiled against 7.3.2, I think)
Do I need to re-compile C functions against 7.4.3 or something else I
missed?
Yes, you need to recompile against 7.4.3
HTH,
Joe
---(end of broadcast)---
TIP 5: Have you
Tom Lane wrote:
Also, casting the function's OID to regprocedure may be useful.
Random example:
regression=# select 1142::regprocedure;
regprocedure
date_mii(date,integer)
(1 row)
That's even better -- I tried regproc, but forgot about regprocedure. I
think the
Tom Lane wrote:
Um. Sooner or later we ought to do something about the whole
automatic-casting-to-and-from-text issue. Datatypes shouldn't have to
supply both I/O procedures and text cast procedures.
I thought automatic (i.e. implicit) casting-to-and-from-text was a no-no
because it could cause
Tom Lane wrote:
Joe Conway [EMAIL PROTECTED] writes:
select 'GRANT EXECUTE ON ' || 1142::regprocedure;
ERROR: array value must start with { or dimension information
BTW, it seems like there's something pretty broken here. How did
arrays get into it? A quick probe suggests
Tom Lane wrote:
I'm fairly sure that Oracle's pricing scales with the iron you plan to
use: the more or faster CPUs you want to run it on, the more you pay.
A large shop can easily get into the $100K license range, but Oracle
figures that they will have spent way more than that on their hardware.
Silvana Di Martino wrote:
4) What could actually solve our problem is something like the following
scenario. Imagine that postmaster (or pg_ctrl) could accept a new CL
parameter called pw. This parameter would contain a sequence of
comma-separated databasename/encryption-password pairs. I mean,
Remi wrote:
I've installed redhat enterprise 3 on a system to use as a db server.
Manually I can install and run postgresql 7.3 (the one on the extras
CD). The problem is when you try to add postgres as a service, it
might add it, but it will not start it. To do this, we got a
postgresql script,
JinNet Picker wrote:
What i need is, when ever a NEW record is inserted in
'MyDb1' , i want fire a Trigger or Rule to insert the
Same Record to MyDb2 database.
Anybody Got Idea how to do this?
See the dblink documentation for dblink_exec(), and see the Postgres
documentation for how to create
David F. Skoll wrote:
For PG 7.4, does the index grow without the free space being
reclaimed?
I believe so.
Would this affect performance substantially?
Yes, it could.
I have had reports from customers who said our applications speed
improved tremendously after a database
Erwin Brandstetter wrote:
Still the solution looks ugly and will perform likewise. PostgreSQL
urgently needs improvment on array handling. Hopefully new versions take
care of that (haven't tested 7.3+).
7.4 array functionality is significantly improved. Still room for more
improvements, but
Stephan Szabo wrote:
On Wed, 20 Aug 2003, Brian McCane wrote:
4) Can I disable the compression to improve storage speed
if the compression algorithm is not as good as deflate
See ALTER TABLE ALTER COLUMN SET STORAGE (I would guess you would want
external, but I'm not 100% sure,
Marco Kaerger wrote:
hi there,
i have got a problem concerning arrays in postgres
i created a function in which i want to know if the index 8 of var_array
ist not NULL:
IF var_array[8] IS NOT NULL
THEN
(query)
Tom Lane wrote:
I think you'd need to generate a separate function definition for
each number of arguments you wanted to deal with, which is a bit
of a pain in the neck, but it still beats writing an extension
function in C ...
I thought I'd whack out this example similar to the GREATEST/LEAST
Tom Lane wrote:
It seems to be running out of memory. I'm not sure what's eating so
much RAM --- the expression isn't that complex. Also it seems that
elog.c's ability to handle a shortage of memory has regressed ...
'ERROR: ERRORDATA_STACK_SIZE exceeded' is better than a core dump,
I suppose,
Tom Lane wrote:
Yeah. The problem is that the SQL function inliner generates an
enormous expression tree from this function definition. 7.3 had no
inliner so no problem.
But I wonder why it isn't at all a problem when the function is also
defined STRICT?
I also looked back at the greatest()
Donald Fraser wrote:
Could someone be please inform me what the correct syntax for accessing arrays
is or tell me if its not possible with pl/pgSQL functions.
It won't work in 7.3.x or before, as you've noted. In 7.4 this will work:
CREATE OR REPLACE FUNCTION test_arrays() RETURNS int4[] AS '
Naomi Walker wrote:
I need to grant access to all tables for all users on a particular
database. I've tried:
GRANT ALL ON databasename to public;
But it complained the databasebase (relation) does not exist. Do I have to
grant on each table in a separate statement? I'm guessing not.
The
Kris Kiger wrote:
Here's my problem. I have user X calling a database function. The
function inserts data into table Y. User X only has select access to
this table. Is there some way to allow user X to call a function that
does an insert for him/her without user X having to have write
Jodi Kanter wrote:
We have a set of records in a table that needs to be ranked. We thought
of adding a ranking field, but the problem is that the ranking could
change often and there could be additions and deletions from the list.
Updating this ranking field is quickly going to get messy.
Is
Sidar Lopez Cruz wrote:
how can i link 2 servers and share db info between both
the servers are on separated machines...
See contrib/dblink
Joe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Jodi Kanter wrote:
Can someone tell me how to create a query that will list values in a
field across columns instead of listing them in row form. Can this be
done in one sql query? Thanks Jodi
Are you referring to a crosstab, i.e.:
select * from cth;
id | rowid |rowdt|
Rob Abernethy IV wrote:
Does anyone have a good recipe for a view that will display users/gruops in a
way that can be used with Tomcat's JDBCRelam configuration? In other words,
instead of seeing a *list* of users in a group (grolist), I'd like to see a
separate row for every group/user
Oliver Elphick wrote:
WHERE grosysid = rec.grosysid;
Thanks, nice catch!
You exposed my lack of adequate testing. I guess I should have added a
disclaimer ;-)
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
Jie Liang wrote:
I expect to see something like:
List of relations
Schema | Name | Type | Owner
+--+---+---
public | foo | table | robot
t | foo | table | robot
That's because schema t is not in your search path. By default,
search path is:
David F. Skoll wrote:
No, I'm sure a btree will work. However, won't the index be
inefficient (i.e., very flat) if there are many entries with the same
value? Or is this not a problem?
If you're concerned, why not try a partial index?
Joe
---(end of
Jodi Kanter wrote:
We are currently using the pg_passwd utility to encrypt passwords.
Someone here told me that I can now encrypt passwords within postgresql
so that they are not stored in plain text in the pg_shadow file.
Is this true? I cannot seem to find any mention of it in my
Nathan Mueller wrote:
Can anyone make suggestions on backup systems? I was thinking that
some sort of DVD writing system would be good for accessing one or two
files in the backup quickly. It would probably also complete backups
faster. However, I think DVD's only hold a few Gigs on them. Are
Geoff wrote:
I don't think either COPY or PG_DUMP will help in this case...
I have a users table in database ADMIN with a primary key user_id. I have a
users_access table in database LIVE which I was hoping to have a foreign key
user_id reference the user_id column in the ADMIN database, so
Nick Fankhauser wrote:
Hi-
We need to increase the length of a varchar field, and couldn't find
a way to do it using alter table. Since the alternative is copying
re-creating a very large table, we starting poking around under
the hood found that pg_attribute.atttypmod seems to be
Jodi Kanter wrote:
We are currently trying to determine if their is a performance
difference with postgres in using an IN statement in the where clause
vs. using a join between tables.
Is there any published documentation or someone with personal experience
that can answer this
Jie Liang wrote:
In postgresql.conf:
# Syslog
# requires ENABLE_SYSLOG
How to do it?
My OS is FreeBSD4.5
I installed Postgres-7.2
Urgent!
I think you need to make sure that PostgreSQL was built with
--enable-syslog during configure.
Joe
---(end
Jie Liang wrote:
I did, it didn't work.
Jie Liang
Works for me. Did you change postgresql.conf? Here's what mine looks like.
#
# Syslog
#
# requires ENABLE_SYSLOG
syslog = 1 # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
From the online docs:
Felipe Nascimento wrote:
Is there a max length (number of characters) to column names??
I received the following:
identifier petb_convidado_partida_participante will be truncated to
petb_convidado_partida_particip
Tks
Felipe
Yes -- it is 31 characters max by default. You can change
Raymond Chui wrote:
Previous DBA create a lot of triggers and functions without
documentation like:
CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name
FOR EACH ROW EXECUTE PROCEDURE function_name();
Now he is gone. I couldn't find his PL/PGSQL source codes!
I can do
Jodi Kanter wrote:
Can anyone tell me the sql that is being sent to the database when
typeing this command? I am working on writing some code that will show a
list of columns in a table. Is there a describe statement?
Thanks
Jodi Kanter
Start up psql with the -E switch. It will then
Hello,
I am getting the following error when trying to use pg_dump:
***
pg_dump cymi cymi.2000_04_16.dmp
FATAL 1: Memory exhausted in AllocSetAlloc()
PQendcopy: resetting connection
SQL query to dump the contents of Table
the collected data). Is there anything I can do to
cache some or all of this table in memory in order to speed queries against it? The
physical file is about 130 MB. The server is a dual Pentium Pro 200 with 512 MB of RAM.
Any suggestions would be appreciated.
Joe Conway
p.s. I tried to search
64 matches
Mail list logo