Re: [GENERAL] Roadmap for Postgres on AIX

2013-03-19 Thread Wasim Arif
Thanks for the detailed and quick response guys. -Wasim. On Mon, Mar 18, 2013 at 6:00 PM, Tom Lane wrote: > Wasim Arif writes: > > What is the road map for Postgres on the AIX platform? I understand that > > the pg build farm contains an AIX 5.3 server; are there any plans to > > upgrade to 6.

Re: [GENERAL] Analyzing the types of prepared statements

2013-03-19 Thread Jason Dusek
2013/3/19 John DeSoi : > On Mar 16, 2013, at 8:30 AM, Jason Dusek wrote: >> However, it is not clear to me at this juncture how to get the >> return type for a statement, given its text. Preparing and >> looking it up in pg_prepared_statements will retrieve the >> argument types but not the return

Re: [GENERAL] Dump table from schema and function from another one

2013-03-19 Thread Adrian Klaver
On 03/19/2013 01:02 PM, Luke Luke wrote: Hi guys, Is it possible to do a postgre dump where I will dump from database complete schema[A] (table+data,procedures) and from another schema[B] only stored procedures by one dump commnad? AFAIK there is no way to dump just stored procedures(functions)

[GENERAL] Dump table from schema and function from another one

2013-03-19 Thread Luke Luke
Hi guys, Is it possible to do a postgre dump where I will dump from database complete schema[A] (table+data,procedures) and from another schema[B] only stored procedures by one dump commnad? Thanks

Re: [GENERAL] Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13

2013-03-19 Thread Tom Lane
Alexander Farber writes: > I'm trying at the psql prompt of an UTF8 database in 8.4.13: > # select 'АБВГД' ~ '^[\u0410-\u042F]{2,}$'; > WARNING: nonstandard use of escape in a string literal I think Unicode escapes were introduced in 9.0. In 8.4 you'd probably have to write out the UTF8 eq

[GENERAL] Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13

2013-03-19 Thread Alexander Farber
I'm trying at the psql prompt of an UTF8 database in 8.4.13: # select 'АБВГД' ~ '^[\u0410-\u042F]{2,}$'; WARNING: nonstandard use of escape in a string literal LINE 1: select 'АБВГД' ~ '^[\u0410-\u042F]{2,}$'; ^ HINT: Use the escape string syntax for escapes, e.g., E'\r\

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

2013-03-19 Thread Stephen Frost
* Craig Ringer (cr...@2ndquadrant.com) wrote: > As far as I'm concerned that's the immediate problem fixed. It may be > worth adding a warning on startup if we find non-self-signed certs in > root.crt too, something like 'WARNING: Intermediate certificate found in > root.crt. This does not do what

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

2013-03-19 Thread Craig Ringer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/19/2013 08:39 PM, Stephen Frost wrote: > Craig, > > * Craig Ringer (cr...@2ndquadrant.com) wrote: >> Yep, in most applications I've seen you usually store a list of >> authorized SubjectDNs or you just use your own self-signed root and >> issue

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

2013-03-19 Thread Stephen Frost
Craig, * Craig Ringer (cr...@2ndquadrant.com) wrote: > Yep, in most applications I've seen you usually store a list of > authorized SubjectDNs or you just use your own self-signed root and > issue certs from it. Even with a self-signed root issuing certs, you need to map the individual cert to a

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

2013-03-19 Thread Bruce Momjian
On Tue, Mar 19, 2013 at 01:46:32AM -0400, Stephen Frost wrote: > > I guess that suggests we should be calling this something like > > 'ssl_authorized_client_roots'. > > I'm no longer convinced that this really makes sense and I'm a bit > worried about the simple authentication issue which I though

Re: [GENERAL] Concurrent updates

2013-03-19 Thread Albe Laurenz
Steve Erickson wrote: > I have a table that I want to use as a queue with all functionality (Insert, > update, delete) embodied > in a stored procedure. Inserts and deletes are no problem. An external > program would call the stored > procedure to get one or more emails to work on, selecting on