Re: [GENERAL] what happens when concurrent index create

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

Re: [GENERAL] Unable to createlang

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

Re: [GENERAL] views, queries, and locks

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

Re: [GENERAL] views, queries, and locks

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

Re: [GENERAL] views, queries, and locks

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

[GENERAL]

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 *

Re: [GENERAL] views, queries, and locks

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

Re: [GENERAL]

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

[GENERAL] Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

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

Re: [GENERAL] views, queries, and locks

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

[GENERAL] PostgreSQL 8.4 crash on user defined C language function

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

Re: [GENERAL] views, queries, and locks

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)

Re: [GENERAL] Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

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

Re: [GENERAL] views, queries, and locks

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

[GENERAL] Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

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

Re: [GENERAL] PostgreSQL 8.4 crash on user defined C language function

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

Re: [GENERAL] views, queries, and locks

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

Re: [GENERAL] views, queries, and locks

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

Re: [GENERAL] views, queries, and locks

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.

Re: [GENERAL] Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

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

[GENERAL] Leaky Perl / DBIx / Postgres 9.0.1 Trio

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

[GENERAL] Can postgres be configure for GSS/Kerberos authentication without a keyfile?

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

Re: [GENERAL] Leaky Perl / DBIx / Postgres 9.0.1 Trio

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

Re: [GENERAL] Leaky Perl / DBIx / Postgres 9.0.1 Trio

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

Re: [GENERAL] PostgreSQL 8.4 crash on user defined C language function

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

Re: [GENERAL] Can postgres be configure for GSS/Kerberos authentication without a keyfile?

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

[GENERAL] copy syntax

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

Re: [GENERAL] copy syntax

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

Re: [GENERAL] Leaky Perl / DBIx / Postgres 9.0.1 Trio

-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.

Re: [GENERAL] views, queries, and locks

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

Re: [GENERAL] copy syntax

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

[GENERAL] Hot synchron backup doesn't start

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

[GENERAL] Function with variables/insert/for loop problems

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

[GENERAL] Can postgres be configure for GSS/Kerberos authentication without a keyfile?

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

[GENERAL] EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)

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

Re: [GENERAL] PostgreSQL 8.4 crash on user defined C language function

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

Re: [GENERAL] Function with variables/insert/for loop problems

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

Re: [GENERAL] Function with variables/insert/for loop problems

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

[GENERAL] v8.3.4 metadata changes while users active

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

Re: [GENERAL] v8.3.4 metadata changes while users active

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

Re: [GENERAL] v8.3.4 metadata changes while users active

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

Re: [GENERAL] v8.3.4 metadata changes while users active

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.

Re: [GENERAL] v8.3.4 metadata changes while users active

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...@

Re: [GENERAL] PostgreSQL 8.4 crash on user defined C language function

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

Re: [GENERAL] EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)

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