leo xu wrote:
> i read documents,i find it that concurrent index create don't lock
write.but
> need scan table twice.it explain is following as:
>It scans the table once to initially build the index, then makes a
second
> pass to look for things added after the first pass.
>
> please explain 1
Tom Harkaway wrote:
> The command I am using is:
>
> createlang -U postgres plperl hf-hvpa
>
> The message I get back is:
>
> createlang: language installation failed: ERROR: could not load
library
> "/opt/postgres/lib/postgresql/plperl.so": libperl.so: cannot open
shared object file: N
On Tue, Apr 3, 2012 at 8:58 PM, Scott Marlowe wrote:
> On Tue, Apr 3, 2012 at 7:21 PM, Jon Nelson wrote:
>> On Tue, Apr 3, 2012 at 2:45 PM, Thomas Kellerer wrote:
>>> Jon Nelson wrote on 03.04.2012 20:41:
>>>
Close, but not quite. It's not rotation but every N minutes a
newly-built tab
On Wed, Apr 4, 2012 at 8:50 AM, Jon Nelson wrote:
>
> I need to have something table-like from the client's perspective for
> a bunch of reasons.
> For now, assume that I want to keep using the view and that I'd like
> to find better ways to address my concerns.
hence my question upthread: "how s
Jon Nelson writes:
> I need to have something table-like from the client's perspective for
> a bunch of reasons.
> For now, assume that I want to keep using the view and that I'd like
> to find better ways to address my concerns.
Why aren't you using a standard partitioned table, cf
http://www.po
Hello,
I am experimenting with user defined functions in C, though I have
problem with stability.
It always crash on palloc() call, SPI_tuptable->tupdesc dereference
but not on SPI_* calls.
Here is one modified example from documentation:
PGDLLIMPORT Datum test(PG_FUNCTION_ARGS)
{
char *
On Wed, Apr 4, 2012 at 9:01 AM, Tom Lane wrote:
>
> Why aren't you using a standard partitioned table, cf
> http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
Because I'm adding "scalar" (constant-value) columns to the view like this:
SELECT * from tableA, DATE 'date string here' as
Vincas Dargis writes:
> I am experimenting with user defined functions in C, though I have
> problem with stability.
The only obvious problem in what you posted is
>command = "SELECT 1";
> ...
>pfree(command);
pfree'ing a constant is pretty much guaranteed to crash.
I am guessin
Hi Guys. I got one problem. I need to give some of the non-super users( kind
of dba) to get the privileges
to can cancel other users's query, DML. After I granted the execute on
pg_cancel_backend and pg_terminate_backend function to them, they still get
the error message as follows when they call
Jon Nelson writes:
> On Wed, Apr 4, 2012 at 9:01 AM, Tom Lane wrote:
>> Why aren't you using a standard partitioned table, cf
>> http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
> Because I'm adding "scalar" (constant-value) columns to the view like this:
> SELECT * from tableA, D
SORRY FOR DUPLICATE EMAIL, I guess I'm really in pretty bad shape...
Hello,
I am experimenting with user defined functions in C, though I have
problem with stability.
It always crash on palloc() call, SPI_tuptable->tupdesc dereference
but not on SPI_* calls, for example.
Here is one modified ex
On Wed, Apr 4, 2012 at 10:43 AM, Tom Lane wrote:
> Jon Nelson writes:
>> On Wed, Apr 4, 2012 at 9:01 AM, Tom Lane wrote:
>>> Why aren't you using a standard partitioned table, cf
>>> http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
>
>> Because I'm adding "scalar" (constant-value)
When I need to give other users access to a function that someone must
be superuser to execute I write a security definer function.
See: http://www.postgresql.org/docs/9.1/static/sql-createfunction.html
Also:
http://www.ibm.com/developerworks/opensource/library/os-postgresecurity/index.html
Usin
Jon Nelson wrote on 04.04.2012 15:50:
I need to have something table-like from the client's perspective for
a bunch of reasons.
For now, assume that I want to keep using the view and that I'd like
to find better ways to address my concerns.
What about a set-returning function that builds the qu
Hi Aaron: thanks. I tried the security definer. it works well as follows :
CREATE FUNCTION kill_process(integer) RETURNS boolean AS 'select
pg_cancel_backend($1);' LANGUAGE SQL SECURITY DEFINER;
One more question about this function : if non-super user get the
execute this function, he/her w
On Wed, Apr 4, 2012 at 10:46 AM, Vincas Dargis wrote:
> SORRY FOR DUPLICATE EMAIL, I guess I'm really in pretty bad shape...
>
> Hello,
>
> I am experimenting with user defined functions in C, though I have
> problem with stability.
>
> It always crash on palloc() call, SPI_tuptable->tupdesc deref
On Wed, Apr 4, 2012 at 11:22 AM, Thomas Kellerer wrote:
> Jon Nelson wrote on 04.04.2012 15:50:
>
>> I need to have something table-like from the client's perspective for
>> a bunch of reasons.
>> For now, assume that I want to keep using the view and that I'd like
>> to find better ways to addres
On Wed, Apr 4, 2012 at 12:47 PM, Jon Nelson wrote:
> On Wed, Apr 4, 2012 at 11:22 AM, Thomas Kellerer wrote:
>> Jon Nelson wrote on 04.04.2012 15:50:
>>
>>> I need to have something table-like from the client's perspective for
>>> a bunch of reasons.
>>> For now, assume that I want to keep using
Jon Nelson wrote on 04.04.2012 19:47:
What about a set-returning function that builds the query dynamically and
wrapping that into a view?
That way the view would never change and client would still have the
perspective of a view/table
Your function could pick up the changes automatically e.g.
On Wed, Apr 4, 2012 at 12:24 PM, leaf_yxj wrote:
> Hi Aaron: thanks. I tried the security definer. it works well as follows :
>
> CREATE FUNCTION kill_process(integer) RETURNS boolean AS 'select
> pg_cancel_backend($1);' LANGUAGE SQL SECURITY DEFINER;
>
> One more question about this function
I have a Perl daemon handling some events on a system which inserts or
updates rows in Postgres, and something is causing memory usage to grow. I
see the RSS memory size allocated to the Postgres connection continual
going up (slowly) and the RSS size allocated to the Perl daemon also
continually g
Can postgres be configure for GSS/Kerberos authentication without a keyfile?
I have Kerberos working
I compiled postgres with -with-gssapi
I've setup the pg_hba.conf with gss and my IP address
I'm not sure what to put in the postgres.conf
I can do a kinit
buckwheat.johnson@SOME_EXAMPLE.COM
Hi,
On 04/04/12 19:21, Eliot Gable wrote:
I have a Perl daemon handling some events on a system which inserts or
updates rows in Postgres, and something is causing memory usage to
grow. I see the RSS memory size allocated to the Postgres connection
continual going up (slowly) and the RSS size
On Wed, Apr 4, 2012 at 2:29 PM, Tom Molesworth wrote:
>
> I believe DBIx is more of a namespace than a specific module - do you mean
> DBIx::Class or DBI perhaps? If the former, the IRC channel #dbix-class on
> irc.perl.org tends to be very helpful in tracing problems like this,
> particularly if
2012.04.04 20:37, Merlin Moncure rašė:
did you remember to set up the V1 calling convention macro?
merlin
Yes, I did remember. This kind of inconsistency bugs me, why SPI_*
works, pmalloc not?
Vincas.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Eric,
* Eric.Kamradt (eric.kamr...@accessdevelopment.com) wrote:
> Can postgres be configure for GSS/Kerberos authentication without a keyfile?
I'd say 'probably not'.
You have to have a princ for postgres and that princ needs to exist in a
keytab file on the PostgreSQL server. By default, the
dcm_eob=> copy ar_data from '/tmp/ar-data.csv' with header true;
ERROR: syntax error at or near "true"
LINE 1: copy ar_data from '/tmp/ar-data.csv' with header true;
I can't figure out what's wrong with the syntax above. Is something missing?
--
Andy Chambers
Software Engineer
(e) achamb...@mc
On Wed, 2012-04-04 at 16:01 -0400, Andy Chambers wrote:
> dcm_eob=> copy ar_data from '/tmp/ar-data.csv' with header true;
> ERROR: syntax error at or near "true"
> LINE 1: copy ar_data from '/tmp/ar-data.csv' with header true;
>
> I can't figure out what's wrong with the syntax above. Is someth
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I have a Perl daemon handling some events on a system
> which inserts or updates rows in Postgres, and something
> is causing memory usage to grow.
The most likely culprit is the part of the chain you did not
list in the subject, DBD::Pg.
On Wed, Apr 4, 2012 at 12:51 PM, Thomas Kellerer wrote:
> Jon Nelson wrote on 04.04.2012 19:47:
>
>>> What about a set-returning function that builds the query dynamically and
>>> wrapping that into a view?
>>>
>>> That way the view would never change and client would still have the
>>> perspectiv
Am 04.04.2012 22:01, schrieb Andy Chambers:
dcm_eob=> copy ar_data from '/tmp/ar-data.csv' with header true;
ERROR: syntax error at or near "true"
LINE 1: copy ar_data from '/tmp/ar-data.csv' with header true;
I can't figure out what's wrong with the syntax above. Is something missing?
cop
I'm trying to set up a replication server that shall handle synchronized
commits. I stopped my master database, copied all the files to the slave, added
a recovery.conf, started the master with synchronized_commit = on and then
started the slave.
I would prusume because the slave is nearly up t
I am using DreamCoder as my front end to my PostgreSQL database. It has an
import feature into the database that is very helpful. I have created a
function that is called inside the after_import function.
The function needs to call distinct names in the name table and loop through
them. When th
Can postgres be configure for GSS/Kerberos authentication without a keyfile?
I have Kerberos working
I compiled postgres with -with-gssapi
I've setup the pg_hba.conf with gss and my IP address
I'm not sure what to put in the postgres.conf
I can do a kinit
buckwheat.johnson@SOME_EXAMPLE.COM
Downloaded http://get.enterprisedb.com/postgresql/postgresql-9.1.3-1-linux.run
Ran it. Install went fine.
StackBuilder install of PostGIS 1.5 failed. No error given. I can't
find it in the logs. So I ran /tmp/edb_postgis_1_5_pg91.bin by hand.
Everything went fine there.
Then I wanted to install
Hi,
In your code, only the last line "pfree(command);" is wrong. No need to put
it there. Since you use the constant string for the variable command.
In my test,
here is the result:
iihero=# select test();
INFO: 1
INFO: 2
INFO: 3
INFO: 4
INFO: 5
INFO: 6
INFO: 7
INFO: EXECQ: 1
test
How about ... "' || table_name || '" ...?
--
~
iihero
http://www.sql9.comhttp://www.sql6.com
~
-- Original --
From: "PM Support";
Date: Thu, Apr 5, 2012 03:10 AM
To: "pgsql-general@postgresql
On 04/04/2012 12:10 PM, PM Support wrote:
I am using DreamCoder as my front end to my PostgreSQL database. It has an
import feature into the database that is very helpful. I have created a
function that is called inside the after_import function.
The function needs to call distinct names in th
v8.3.4 on linux
Here's the problem...
I have to make some metadata changes, add columns to a table, add constraints,
drop a view, recreate it. I used to be able to do this by booting users off,
and then quickly make the changes before they get back in. They now have
software that seems to con
On 04/04/2012 09:26 PM, Gauthier, Dave wrote:
v8.3.4 on linux
Here's the problem...
I need toboot them off and prevent them from getting back in so that I
can make the changes, then re-enable them. There are 2 users, lets call
them "selectuser" and "moduser" who have "select" and
"select,insert
H... I don't have root access :-(
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gabriel Ramirez
Sent: Wednesday, April 04, 2012 11:00 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] v8.3.4 metadata chang
On 04/04/12 7:26 PM, Gauthier, Dave wrote:
v8.3.4 on linux
8.3 is currently at 8.3.18, there's been a LOT of fixes.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
Try to reject the connections by using pg_hba.conf, only accepting
connections of localhost or your IP.
El 04/04/2012 22:18, "Gauthier, Dave" escribió:
> H... I don't have root access :-(
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@
Yeah, original example took command from arguments, I simply forgot to
revert changes to original.
Though it's not the problem, it is something with calling other
functions under some kind environment I got. Your test was successful
for "obviously it should work" reason, but it's something wro
On Thu, Apr 5, 2012 at 4:11 AM, Scott Chapman wrote:
> Downloaded
> http://get.enterprisedb.com/postgresql/postgresql-9.1.3-1-linux.run
> Ran it. Install went fine.
> StackBuilder install of PostGIS 1.5 failed. No error given. I can't
> find it in the logs. So I ran /tmp/edb_postgis_1_5_pg91.b
45 matches
Mail list logo