Re: [ADMIN] how do i query the type of an object?

2010-08-12 Thread Yeb Havinga
Tom Lane wrote: Mark Rostron writes: Is there some way to query the data-type of ''? There's a SQL-standard construct called IS OF, and a function called pg_typeof, but it's not real clear whether either of those would help you. I failed finding IS OF in the pg documentation, howev

[ADMIN] High-water Mark for number of sessions/connections reached in Postgres

2010-08-12 Thread Tomeh, Husam
I was wondering if we can query/obtain the high-water mark of number of sessions or connections reached in a Postgres database. Is there a view or command that can provide this information. The pg_stat_database shows the current number of connections, but not the high-water mark a database had

[ADMIN] trigger AFTER INSERT

2010-08-12 Thread Josi Perez (3T Systems)
Hi, I think that I have a conceptual problem and I hope anyone could help me. If I write a trigger AFTER INSERT and I have one error in this trigger, the record (that I think was already inserted) is not inserted. Example: INSERT INTO tableX trigger sumRecords AFTER INSERT under tableX to accum

Re: [ADMIN] trigger AFTER INSERT

2010-08-12 Thread Tom Lane
"Josi Perez (3T Systems)" writes: > If I write a trigger AFTER INSERT and I have one error in this trigger, the > record (that I think was already inserted) is not inserted. Sure, because the whole transaction is rolled back on error. regards, tom lane -- Sent via pgsql

Re: [ADMIN] Autovacuum daemon internal handling

2010-08-12 Thread Alvaro Herrera
Excerpts from Gnanakumar's message of jue ago 12 00:56:34 -0400 2010: > > in 8.2 "naptime" means "time to sleep after we finish a job". So even > > if the previous task takes an hour, it will still sleep a minute before > > doing another round. (Note that this setting has a different meaning in >

[ADMIN] CRYPT / DECRYPT in bytea field

2010-08-12 Thread Victor Hugo
Gentlemen, I need a help .. I have a table X in a bytea field and this field stores images, I need to save that image and cryptogram qnd I am displaying the information I need to decrypt this file, could someone help?? -- []´s Victor Hugo -- Sent via pgsql-admin mailing list (pgsql-admin@postg

Re: [ADMIN] CRYPT / DECRYPT in bytea field

2010-08-12 Thread Kevin Grittner
Victor Hugo wrote: > I have a table X in a bytea field and this field stores images, I need > to save that image and cryptogram qnd I am displaying the information > I need to decrypt this file, could someone help?? http://www.postgresql.org/docs/8.4/interactive/encryption-options.html http:

Re: [HACKERS] [ADMIN] postgres 9.0 crash when bringing up hot standby

2010-08-12 Thread Robert Haas
On Wed, Aug 11, 2010 at 10:25 AM, Robert Haas wrote: > [request form more information] Per off-list discussion with Alanoly, we've determined the following: dblink was compiled with the same flags as libpqwalreciever dblink works libpqwalreceiver crashes -- Robert Haas EnterpriseDB: http://www

Re: [HACKERS] [ADMIN] postgres 9.0 crash when bringing up hot standby

2010-08-12 Thread Tom Lane
Robert Haas writes: > Per off-list discussion with Alanoly, we've determined the following: > dblink was compiled with the same flags as libpqwalreciever > dblink works > libpqwalreceiver crashes I wonder if the problem is not so much libpqwalreceiver as the walreceiver process. Maybe an ordina

Re: [HACKERS] [ADMIN] postgres 9.0 crash when bringing up hot standby

2010-08-12 Thread Tom Lane
I wrote: > I wonder if the problem is not so much libpqwalreceiver as the > walreceiver process. Maybe an ordinary backend process does some > prerequisite initialization that walreceiver is missing. Hard to > guess what, though ... I can't think of anything dlopen() depends on > that should be u