[GENERAL] Compile docs on ArchLinux

Hi all, Under Arch, I am not able to compile Postgres docs. By having a look at config.log, it cannot find the docbook folder: configure:29356: checking for DocBook V4.2 onsgmls:/etc/xml/catalog:2:78:E: name expected onsgmls:/etc/xml/catalog:2:18:E: cannot find "PUBLIC"; tried "/etc/xml/PUBLIC",

Re: [GENERAL] LOCK TABLE is not allowed in a non-volatile function

Eliot Gable writes: > When the trigger fires, I get this in my postgres.log file: > 2012-04-17 16:57:15 EDT|test_db|169.254.5.138(56783)||[unknown]|30474 > WARNING: Failed to materialize the live_user_activity table; code 0A000: > LOCK TABLE is not allowed in a non-volatile function > I can

Re: [GENERAL] Feature Proposal: Constant Values in Columns or Foreign Keys

=?UTF-8?Q?Nils_G=C3=B6sche?= writes: > Bartosz Dmytrak wrote: >> how about inheritance in postgres? > I know about Postgres' inheritance feature, but would prefer a more standard > relational solution. [ blink... ] That seems like a pretty silly argument for proposing something that is *more* n

Re: [GENERAL] Feature Proposal: Constant Values in Columns or Foreign Keys

Bartosz Dmytrak wrote: > how about inheritance in postgres? I know about Postgres' inheritance feature, but would prefer a more standard relational solution. > With this approach all IDs will use the same sequence so there will not be > duplicated PKs in inherited tables. In my case, the prim

Re: [GENERAL] LOCK TABLE is not allowed in a non-volatile function

On Tue, Apr 17, 2012 at 5:20 PM, Eliot Gable wrote: > > > > I cannot find a single non-volatile function in the call path; so I am > baffled on where this error message is coming from. I would be thankful for > any ideas anyone might have on where this error message might be coming > from or how

[GENERAL] LOCK TABLE is not allowed in a non-volatile function

I have a table which has a trigger on it. It is basically a log of user activity. The trigger is created like this: CREATE TRIGGER user_log_user_activity_call_in_trig AFTER INSERT ON bbx_cdr.user_log FOR EACH ROW WHEN ( NEW.user_log_action = 'ringing' ) EXECUTE PROCEDURE user_log_user_activity_cal

[GENERAL] LOCK TABLE is not allowed in a non-volatile function

I have a table which has a trigger on it. It is basically a log of user activity. The trigger is created like this: CREATE TRIGGER user_log_user_activity_call_in_trig AFTER INSERT ON bbx_cdr.user_log FOR EACH ROW WHEN ( NEW.user_log_action = 'ringing' ) EXECUTE PROCEDURE user_log_user_activity_cal

Re: [GENERAL] Feature Proposal: Constant Values in Columns or Foreign Keys

Hi, how about inheritance in postgres? CREATE TABLE "tblBase" ( id serial NOT NULL, -- serial type is my assumption. "SomeData" integer, CONSTRAINT "tblBase_pkey" PRIMARY KEY (id ) ) WITH ( OIDS=FALSE ); CREATE TABLE "tblDerived1" ( -- Inherited from table "tblBase": id integer NOT NUL

[GENERAL] Feature Proposal: Constant Values in Columns or Foreign Keys

Hi! I have a little feature proposal. Let me try to explain the motivation behind it. Suppose our application has two types of objects, looking somewhat like this: abstract class Base { public int Id; public int SomeData; } class Derived1 : Base { public int Data1; } class Derived2

Re: [GENERAL] recommended schema diff tools?

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > can anyone recommend an open source tool for diffing schemas? You might want to check out the "same_schema" action of check_postgres.pl: http://bucardo.org/check_postgres/check_postgres.pl.html#same_schema http://bucardo.org/wiki/Check_postg

[GENERAL] pgpool2 master fail problem

Hi all, i try to build a postgresql cluster using postgresql 9.1.3 and pgpool2 3.1.2. I want to setup this cluster as a master/slave with streaming copy. Everything is ok execept the case when the masters fails, and i try to recover it, because the old master recovers as master instead of slave.

Re: [GENERAL] Result sets from functions

On 2012-04-16, Liam Caffrey wrote: > > Hi, > > There is a feature that I have used in SQL Server which I find really > useful for debugging (without using a debugger!!). > It is this I can write multiple "select * from some_table" statements > throughout my stored procedure (here read "pgsql

Re: [GENERAL] The scope of extensions

On Mon, Apr 16, 2012 at 09:20:14PM +0200, Guillaume Lelarge wrote: > On Mon, 2012-04-16 at 21:16 +0200, Guillaume Lelarge wrote: > > On Mon, 2012-04-16 at 16:46 +0100, Roger Leigh wrote: > > > On Mon, Apr 16, 2012 at 10:22:19AM -0500, Merlin Moncure wrote: > > > > On Mon, Apr 16, 2012 at 10:05 AM,

Re: [GENERAL] How to install pgfincore with PG 9.1

> > >> buggy Makefile. Thanks for the report. >> I'll fix that soon and keep you informed. >> -- >> > -- > Cédric Villemain +33 (0)6 20 30 22 52 > http://2ndQuadrant.fr/ > PostgreSQL: Support 24x7 - Développement, Expertise et Formation > Seems it got fixed in new version.