[GENERAL] Issue installing an extension

Hi there I have installed 9.2.2 on a Debian Squeeze VM. I am trying to install a third party extension. 1) For the extension I did "make" & "make install". 2) I now see the extension files in /usr/share/postgresql/9.2/extension/... (files .sql and .control) 3) When I issue CREATE EXTENSION ...

[GENERAL] Characters

Hi there I am using PG 9.2 and 'pg_database' shows 'en_US.UTF-8'. I have a text 'Piqué' but this is shown in my application as 'Piqu?' so I was wondering where the problem is? I am using Devart's 'PostgreSQL Data Access Components' to access PG from FreePascal. In my FreePascal code I do use An

Re: [GENERAL] Characters

mheim Switzerland -- 2013/4/10 Adrian Klaver > On 04/10/2013 02:53 AM, P. Broennimann wrote: > >> Hi there >> >> I am using PG 9.2 and 'pg_database' shows 'en_US.UTF-8'. >> >> I have a text 'Piqué' but this is shown in my

[GENERAL] Document Management System (DMS)

Hi there I am looking for an open-source document management system (DMS) based on PostgreSQL. Anyone has experience with such tools? Thanks & cheers, Peter

[GENERAL] dblink / Insert several records into remote table

Hello I'd like to use dblink to insert records (several) from a local table to a remote table. Is it possible to do this in one statement? Something like: insert into select col1, col2, col3 from Can someone give me an example or tell me what commands to use? What I have so far: l_con

[GENERAL] Output of query_to_xml

Hi there In my stored function I use: select query_to_xml('select * from table12', true, true, '') into ... The result is OK but there is always an empty line: http://www.w3.org/2001/XMLSchema-instance";> *<-- Empty line here* FG8976SDFRETG NL 2011-02-28

[GENERAL] NOTIFY/LISTEN in Postgresql

Hi there 1) Can a Pg/SQL function "listen" for a notification sent from an external instance? I would like my stored function to pause/wait and continue its execution once an external event (NOTIFY event) occurs. 2) In Pg/SQL I can implement a loop (until something happens) to pause/wait. This co

Re: [GENERAL] NOTIFY/LISTEN in Postgresql

amp; cheers, Peter 2012/10/15 Craig Ringer > On 10/15/2012 08:54 PM, P. Broennimann wrote: > >> Hi there >> >> 1) Can a Pg/SQL function "listen" for a notification sent from an >> external instance? >> > > No, it's the other way around. A

[GENERAL] Purge Logs from pgagent

Hi there I am using pgagent without problems but I have a few questions: -> I see that pgagent does log its acivities in the tables "pga_joblog" and "pga_jobsteplog". My log gets quiet big. 1) Is it save to empty these tables once a while manually? 2) Is there a settings to tell pgagent to purg

[GENERAL] Pg/SQL returning composite type

Hi there I have in schema "core": CREATE OR REPLACE FUNCTION core.f_read ( ... ) RETURNS core.c_result_type AS $$ declare c_result core.c_result_type%rowtype; begin ... return c_result; end ... CREATE TYPE core.c_result_type AS ( a_value

[GENERAL] Installation Issue on Ubuntu under Xen

Hi there I have a VM running under XEN XCP. The VM is Ubuntu server 12.04.1/64 headless. The VM is completely fresh & clean and works fine. Then I install Postgresql... sudo apt-get install python-software-properties sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update s

[GENERAL] Problem with pgAgent on Ubuntu

Hi there My PostgreSQL 9.1 installed on an Ubuntu/64 10.04 machine is running fine. I installed pgAgent with "sudo apt-get install pgagent" (that is probably version 3.0.1). I executed the .sql script to create the pgagent objects in the database. sudo su postgres psql -d postgres postgres-# \d

Re: [GENERAL] Problem with pgAgent on Ubuntu

Eureka! I changed 127.0.0.1 for the PG's assiged IP address 192.168. and now it works :) Thx & cheers, P. 2012/1/16 Tom Lane > "P. Broennimann" writes: > > -> The problem I am having is that I can not start pgagent. When I try: > > > cd /usr/b

[GENERAL] Basic PostgreSQL Question

Hi there I have installed pgAgent (scheduling) in the default "postres" database on my server. I read somewhere that this is where the linux pgAgent expects to find its tables. My own application database is called "xyz" on the same server. Now I need to create pgAgent "jobs" from my "xyz" stored

[GENERAL] dblink (INSERT ..... RETURNING)

Hi there I have a remote table that I access over dblink. The table has a primary field set to "autoincrement". I need now to insert a record in that remote table and get back the new primary field (autoincrement sequence). Since "bdlink_exec" can not give back rows I tried to use "dblink", but