Re: [GENERAL] New wrapper library: QUINCE

On 20/08/2014 3:51 AM, John R Pierce wrote: really well designed method of generating really awful nested queries?whatever. Sure, if that's what you're into. As the doco says: How far you go in the direction of monster queries is up to you, the application designer. Quince has no

Re: [GENERAL] Mimicking Oracle SYSDATE

Hello Tom, >Do you really need to be bug-compatible with Oracle's SYSDATE at that >level of detail? We did a Oracle to PostgreSQL migration recently, and migrating sysdate was an issue. Figuring out whether to use clock_timestamp, timestamp(0), and cases in which both options are incorrect, took ti

Re: [GENERAL] pgbadger download

On 08/19/2014 05:13 AM, Ramesh T wrote: can any one send me link pgbadger 6 for me .. Google pgbadger 6 --> http://sourceforge.net/projects/pgbadger/ advance thanks, -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To mak

Re: [GENERAL] adding a nullable column of type domain w/ check constraint runs checks?

On Tue, Aug 19, 2014 at 3:16 PM, Joe Van Dyk wrote: > On Tue, Aug 19, 2014 at 3:10 PM, Joe Van Dyk wrote: > >> I have a large table that I don't want to lock for more than couple >> seconds. I want to add a nullable column to the table, the type of the >> column is a domain with a check constrai

Re: [GENERAL] adding a nullable column of type domain w/ check constraint runs checks?

On Tue, Aug 19, 2014 at 3:10 PM, Joe Van Dyk wrote: > I have a large table that I don't want to lock for more than couple > seconds. I want to add a nullable column to the table, the type of the > column is a domain with a check constraint. > > It appears that the check constraint is being checke

[GENERAL] pgbadger download

can any one send me link pgbadger 6 for me .. advance thanks,

Re: [GENERAL] Best practices for cloning DB servers

Thanks for the responses. Bill - We currently use wal-e to upload our WAL logs to S3. We actually don't keep our logs around for that long, so we don't have a problem with the size of our logs or snapshots. I think we're going to go with our current solution, but during our process of cloning, poi

[GENERAL] adding a nullable column of type domain w/ check constraint runs checks?

I have a large table that I don't want to lock for more than couple seconds. I want to add a nullable column to the table, the type of the column is a domain with a check constraint. It appears that the check constraint is being checked for each row, even though the column can be nullable? Is ther

Re: [GENERAL] ERROR: Problem running post install step

On 08/19/2014 11:03 AM, Brodie S wrote: I am trying to install PostgreSQL on my OS X Mavericks Server. Installing with what? I am installing the Data directory on a NAS server. However, I'm having an issue. Here is the section of the log file that displays the error: fixing permissions

[GENERAL] Anyone using Apache Helix to manage a PostgreSQL cluster?

Very interested in hearing of successful or unsuccessful attempts, issues, etc. Thanks very much. larry

[GENERAL] ERROR: Problem running post install step

I am trying to install PostgreSQL on my OS X Mavericks Server. I am installing the Data directory on a NAS server. However, I'm having an issue. Here is the section of the log file that displays the error: fixing permissions on existing directory /Volumes/Poker/Databases ... ok creating subdirect

Re: [GENERAL] New wrapper library: QUINCE

On 8/19/2014 5:31 AM, Larry White wrote: I'm not a C++ developer, but this looks like a really well-designed API. Nice work. really well designed method of generating really awful nested queries?whatever. -- john r pierce 37N 122W somewhere on the

Re: [GENERAL] Mimicking Oracle SYSDATE

Sameer Thakur writes: > We are thinking of building our own version of Oracle's sysdate, in > the form of PostgreSQL extension. > Consider the behavior of sysdate for multiple inserts inside a function > CREATE OR REPLACE FUNCTION fun2 >RETURN number >IS var1 number(10); var2 number (2);

Re: [GENERAL] Mimicking Oracle SYSDATE

On 08/19/2014 07:11 AM, Sameer Thakur wrote: Hello, We are thinking of building our own version of Oracle's sysdate, in the form of PostgreSQL extension. Consider the behavior of sysdate for multiple inserts inside a function CREATE OR REPLACE FUNCTION fun2 RETURN number IS var1 number(1

Re: [GENERAL] Mimicking Oracle SYSDATE

On Tue, Aug 19, 2014 at 07:41:00PM +0530, Sameer Thakur wrote: > We are thinking of building our own version of Oracle's sysdate, in > the form of PostgreSQL extension. I thought that was the point of the statement_timestamp() function? A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via p

[GENERAL] Mimicking Oracle SYSDATE

Hello, We are thinking of building our own version of Oracle's sysdate, in the form of PostgreSQL extension. Consider the behavior of sysdate for multiple inserts inside a function CREATE OR REPLACE FUNCTION fun2 RETURN number IS var1 number(10); var2 number (2); BEGIN insert into t1 select

Re: [GENERAL] New wrapper library: QUINCE

I'm not a C++ developer, but this looks like a really well-designed API. Nice work. On Mon, Aug 18, 2014 at 9:21 PM, Jov wrote: > A cool project! > > Jov > blog: http:amutu.com/blog > > > 2014-08-19 6:43 GMT+08:00 Michael Shepanski : > > Hi PostgreSQLers, >> >> I've rele

[GENERAL] pgbouncer setup in the architecture

Hi, I'd like to use pgbouncer as connection pooler in our productive environment, which consists of six master db server plus 6 slaves and many webserver and services. For example, I'd like to use it as a central point from where I can redirect client connections easily without changing the code o