Re: [GENERAL] strange behavior, hoping for an explanation

Chris Travers wrote: > I have found recently that tables in certain contexts seem to have a > name pseudocolumn. I was wondering if there is any documentation as > to what this is and what it signifies. > > postgres=# CREATE table TEST2 (a text, b text); > CREATE TABLE > postgres=# INSERT INTO te

Re: [GENERAL] PQexecParams with binary resultFormat vs BINARY CURSOR

Hey Mateusz, 2011/11/11 Mateusz Łoskot > Hi, > > Considering query for binary data stored directly in tables > using libpq API, I'm trying to understand what is the difference > between specifying binary format in functions like > PQexecParams and use of BINARY CURSOR. > > For example, with quer

Re: [GENERAL] PQexecParams with binary resultFormat vs BINARY CURSOR

Hi Dmitriy, 2011/11/11 Dmitriy Igrishin : > 2011/11/11 Mateusz Łoskot >> >> Considering query for binary data stored directly in tables >> using libpq API, I'm trying to understand what is the difference >> between specifying binary format in functions like >> PQexecParams and use of BINARY CURSO

Re: [GENERAL] PQexecParams with binary resultFormat vs BINARY CURSOR

2011/11/11 Mateusz Łoskot > Hi Dmitriy, > > 2011/11/11 Dmitriy Igrishin : > > 2011/11/11 Mateusz Łoskot > >> > >> Considering query for binary data stored directly in tables > >> using libpq API, I'm trying to understand what is the difference > >> between specifying binary format in functions l

[GENERAL] weird pg_statistic problem

Hello, this morning I experienced a weird problem with our pgsql database (9.0.3): while performing a simple query, I receive the following error: Nov 11 10:24:09 postgres[23395]: [7-1] ERROR: missing chunk number 0 for toast value 550556127 in pg_toast_2619 so I tried to find which relation

[GENERAL] FK dissapearing

So I have a strange issue on one of our live systems. \d+ table shows me the FKs with cascaded deletes, but querying pg_trigger doesn't show me any specific triggers for the FK. Is that possible ? Or am I missing something here? The psql version is 8.3.7 . -- GJ -- Sent via pgsql-general ma

Re: [GENERAL] FK dissapearing

On 11 November 2011 12:25, Gregg Jaskiewicz wrote: > So I have a strange issue on one of our live systems. > > > \d+ table shows me the FKs with cascaded deletes, but querying > pg_trigger doesn't show me any specific triggers for the FK. > Is that possible ? Or am I missing something here? > > Th

Re: [GENERAL] How to inquiry a nest result?

Appreciate for your help ! -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-inquiry-a-nest-result-tp4981259p4984218.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Passing NULL to a function called with OidFunctionCall3

Hey all, I'm trying to make use of OidFunctionCall3 and am wondering how to resolve an issue. I need to be able to pass to the function called with OidFunctionCall3 a NULL and am having difficulty figuring out how. {{{ /* build fcnarg */ for (i = 0; i < set_count; i++) { if (_haspixe

[GENERAL] Hotel reservation for FOSDEM 2012 - Deadline: December 31th, 2011

Hi all, like the last years we will have a devroom at FOSDEM 2012. We also look forward to have a booth. We made a group reservation in the Agenda Louise hotel: Hotel Agenda Louise rue de Florence 6 B-1000 Brussels Tel: + 32.2.539.00.31 Fax: + 32.2.539.00.63 www.hotel-agenda.com This time,

[GENERAL] : postgres: archiver process failed on 0000000100000F72000000F0

Hello, WAL Archive process in our production is not working. [postgres@hostname]$ ps -ef | grep archive postgres 12077 16015 0 10:19 pts/400:00:00 grep archive postgres 31126 27607 0 Nov10 ?00:01:18 postgres: archiver process failed on 00010F7200F0 I see WAL files get

Re: [GENERAL] : postgres: archiver process failed on 0000000100000F72000000F0

This problem has been resolved !! Thanks VB On Fri, Nov 11, 2011 at 9:58 PM, Venkat Balaji wrote: > Hello, > > WAL Archive process in our production is not working. > > [postgres@hostname]$ ps -ef | grep archive > postgres 12077 16015 0 10:19 pts/400:00:00 grep archive > postgres 31126 2760

Re: [GENERAL] : postgres: archiver process failed on 0000000100000F72000000F0

On Fri, Nov 11, 2011 at 09:58:56PM +0530, Venkat Balaji wrote: - Hello, - - WAL Archive process in our production is not working. - - [postgres@hostname]$ ps -ef | grep archive - postgres 12077 16015 0 10:19 pts/400:00:00 grep archive - postgres 31126 27607 0 Nov10 ?00:01:18 postgre

Re: [GENERAL] weird pg_statistic problem

Enrico Sirola writes: > this morning I experienced a weird problem with our pgsql database (9.0.3): > while performing a simple query, I receive the following error: > Nov 11 10:24:09 postgres[23395]: [7-1] ERROR: missing chunk number 0 > for toast value 550556127 in pg_toast_2619 Was this a t

[GENERAL] dblink build problem…must be a lesson here...

Hi, I compiled pg 9.1.1 on my Mac OX 10.7.2 this afternoon and when I attempted to build dblink I got: eagle:dblink postgres$ export CC="gcc -arch i386" eagle:dblink postgres$ make gcc -arch i386 -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat

Re: [GENERAL] VACUUM touching file but not updating relation

Thom Brown writes: > On 11 November 2011 00:55, Tom Lane wrote: >> Thom Brown writes: >>> I just noticed that the VACUUM process touches a lot of relations >>> (affects mtime) but for one file I looked at, it didn't change. This >>> doesn't always happen, and many relations aren't touched at al

Re: [GENERAL] VACUUM touching file but not updating relation

On 11 November 2011 23:28, Tom Lane wrote: > Thom Brown writes: >> On 11 November 2011 00:55, Tom Lane wrote: >>> Thom Brown writes: I just noticed that the VACUUM process touches a lot of relations (affects mtime) but for one file I looked at, it didn't change.  This doesn't alw

Re: [GENERAL] PQexecParams with binary resultFormat vs BINARY CURSOR

2011/11/11 Dmitriy Igrishin : > 2011/11/11 Mateusz Łoskot >> >> Does it mean the protocol automagically switches between text/binary >> depending on >> format code (0|1) specified to PQexecParams and friends? > > The Bind(F) message contains array with > the parameter format codes. So, yes, all yo

[GENERAL] Determine a function's volatility in C

Hey all, I'm wondering if there is a way to determine a function's volatility in C. The function information provided through fmgr_info() doesn't provide it. Ideas? Thanks, Bborie -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu -- Sent via

Re: [GENERAL] Determine a function's volatility in C

Hello 2011/11/12 Bborie Park : > Hey all, > > I'm wondering if there is a way to determine a function's volatility > in C.  The function information provided through fmgr_info() doesn't > provide it.  Ideas? > you should to look to pg_proc table search in postgresql code tuple = Search

Re: [GENERAL] Determine a function's volatility in C

Bborie Park writes: > I'm wondering if there is a way to determine a function's volatility > in C. The function information provided through fmgr_info() doesn't > provide it. Ideas? extern char func_volatile(Oid funcid) (Most catalog-lookup convenience functions of this ilk can be found in lsy

[GENERAL] Large values for duration of COMMITs and slow queries. Due to large WAL config values?

Postgres 9.1.1, master with 2 slaves via streaming replication. I've enabled slow query logging of 150ms and am seeing a large number of slow COMMITs: 2011-11-12 06:55:02 UTC pid:30897 (28/0-0) LOG:  duration: 232.398 ms statement: COMMIT 2011-11-12 06:55:08 UTC pid:30896 (27/0-0) LOG:  duration: