Re: [GENERAL] Function error

Thanks Charles !!! On Fri, Jan 8, 2016 at 1:15 PM, Sachin Srivastava wrote: > Thanks Pavel !!! > > On Fri, Jan 8, 2016 at 1:05 PM, Pavel Stehule > wrote: > >> Hi >> >> >> >> 2016-01-08 8:24 GMT+01:00 Sachin Srivastava : >> >>> Dear Concern, >>> >>> >>> >>> I am creating below function *“create_

Re: [GENERAL] Function error

Thanks Pavel !!! On Fri, Jan 8, 2016 at 1:05 PM, Pavel Stehule wrote: > Hi > > > > 2016-01-08 8:24 GMT+01:00 Sachin Srivastava : > >> Dear Concern, >> >> >> >> I am creating below function *“create_catexp_ss_master()” *and getting >> error as below, I have already created dependent function firs

Re: [GENERAL] Function error

Hello If I understand you correctly you have two functions create_catexp_ss_1 and create_catexp_ss_2 that you then call from create_catexp_master. If so then you probably need to change the call to them: > -- Exposure for single supplier without category filtering >

Re: [GENERAL] Function error

Hi 2016-01-08 8:24 GMT+01:00 Sachin Srivastava : > Dear Concern, > > > > I am creating below function *“create_catexp_ss_master()” *and getting > error as below, I have already created dependent function firstly > successfully *(“create_catexp_ss_1” and “create_catexp_ss_2”) *but still > gettin

[GENERAL] Function error

Dear Concern, I am creating below function *“create_catexp_ss_master()” *and getting error as below, I have already created dependent function firstly successfully *(“create_catexp_ss_1” and “create_catexp_ss_2”) *but still getting error, please suggest why? ERROR: syntax error at or near "c

Re: [GENERAL] RAM of Postgres Server

On Jan 7, 2016, at 10:32 PM, Sachin Srivastava wrote: > > > Dear John, > > We are looking at more like 500-600 connections simultaneously in 1 day and I > want to say we get 1 to 12000 connections a day per db. Unless you have 300 cores to service those 500-600 simultaneous connections,

Re: [GENERAL] RAM of Postgres Server

Dear John, We are looking at more like 500-600 connections simultaneously in 1 day and I want to say we get 1 to 12000 connections a day per db. Regards SS On Fri, Jan 8, 2016 at 10:49 AM, John R Pierce wrote: > On 1/7/2016 8:21 PM, Sachin Srivastava wrote: > > *Q. Total Connection limit f

Re: [GENERAL] RAM of Postgres Server

On Thu, Jan 7, 2016 at 9:21 PM, Sachin Srivastava wrote: > Dear David G. and Gavin, > > Please find the details as below: > > > * Q. What type of queries to be run on postgres database server? * > > All types. Databases will be general OLTP. > > *Q. Size of commonly accessed tables, indexes, ...

Re: [GENERAL] RAM of Postgres Server

On 1/7/2016 8:21 PM, Sachin Srivastava wrote: *Q. Total Connection limit from the database through users and Application on daily basis for all the database:* **Probably 4000+ I hope you mean 4000 sessions/day, and not 4000 concurrent connections. -- john r pierce, recycling bits in san

Re: [GENERAL] RAM of Postgres Server

Dear David G. and Gavin, Please find the details as below: * Q. What type of queries to be run on postgres database server? * All types. Databases will be general OLTP. *Q. Size of commonly accessed tables, indexes, ... ?* Various. Anywhere from a few MB to over 100GB. *Q. Database size fo

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

On 01/07/2016 06:30 PM, Steve Petrie, P.Eng. wrote: Thanks to forum members for the four helpful replies, to my earlier message that initiated this thread. The replies expressed concerns, with the feasibility of my proposal to use postgres tables to store short-lived context data, for dialog c

Re: [GENERAL] Trigger function interface

> On 1/6/16 7:03 PM, Tatsuo Ishii wrote: >> Is it possible to get the parse tree in a C trigger function which is >> invoked when DML (INSERT/UPDATE/DELETE against a view) is executed? > > Yes, it's in fcinfo->flinfo->fn_expr. Thanks for the info. But is this the parse tree for the top level quer

Re: [GENERAL] Any way to selectively color query output in psql?

On Thu, Jan 7, 2016 at 2:32 PM, Gavin Flower wrote: > On 08/01/16 10:25, David G. Johnston wrote: > >> Basically I want to write this: >> >> psql -c "SELECT E'\e[1;33m Some Text Here \e[0m';" >> >> And have just the text "Some Text Here" colored while everything else is >> default white. >> >> Th

Re: [GENERAL] Any way to selectively color query output in psql?

On 08/01/16 10:25, David G. Johnston wrote: Basically I want to write this: psql -c "SELECT E'\e[1;33m Some Text Here \e[0m';" And have just the text "Some Text Here" colored while everything else is default white. The \e constructs are the ANSI color escapes which work when using echo -e I

[GENERAL] Any way to selectively color query output in psql?

Basically I want to write this: psql -c "SELECT E'\e[1;33m Some Text Here \e[0m';" And have just the text "Some Text Here" colored while everything else is default white. The \e constructs are the ANSI color escapes which work when using echo -e I am using bash 4.2.25(1) on Ubuntu 14.04 Is thi

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On 1/7/2016 12:41 PM, balajishanmu...@live.in wrote: For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I am yet to get the log. I will post the Postgres log once I have it. is this an enterprise grade SSD with supercap backup? or is it a consumer desktop/notebook class

Re: [GENERAL] pg_upgrade on Windows

On 1/7/2016 12:32 PM, Igal @ Lucee.org wrote: I'm trying to run pg_upgrade on Windows, but I'm getting the error: cannot write to log file pg_upgrade_internal.log Failure, exiting I saw a similar question for Linux at23216734

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On Thu, Jan 7, 2016 at 1:41 PM, balajishanmu...@live.in wrote: > Hi, > > For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I > am yet to get the log. I will post the Postgres log once I have it. > > Thanks! Yeah a lot of cheaper consumer grade SSDs don't fsync safely. Ther

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

Hi, For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I am yet to get the log. I will post the Postgres log once I have it. Thanks! -- View this message in context: http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435p5880957.htm

[GENERAL] pg_upgrade on Windows

hi guys, I am having issues with pg_upgrade on Windows. I have posted a question on StackOverflow -- at http://stackoverflow.com/questions/34664236/pg-upgrade-on-windows-cannot-write-to-log-file-pg-upgrade-internal-log -- copied below for convenience: I'm trying to run pg_upgrade on Windows

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On Wed, Jan 6, 2016 at 2:08 PM, balajishanmu...@live.in wrote: > Most of the time I will be restarting centOS by issuing reboot command. Which > will do the orderly shutdown of all the service and sometimes just pull the > plug. > > But the issue appears to be random. Is there a way that before Po

Re: [GENERAL] RAM of Postgres Server

On Thu, Jan 7, 2016 at 12:32 AM, Sachin Srivastava wrote: > Dear David, > > > > > > Q: RAM holds data that is recently accessed - how much of that will you > have? > > > > Ans: Kindly confirm, as per your question “RAM holds data that is recently > accessed” : How we figured out that how much da

Re: [GENERAL] 9.5rc1 RLS select policy on insert?

Ted, Please don't top-post on these lists. > On Wed, Jan 6, 2016 at 9:40 PM, Stephen Frost wrote: > > * Ted Toth (txt...@gmail.com) wrote: > >> I see the insert policy check running but also the select policy using > >> on insert. I don't understand why the select policy is being run. > >> Could

Re: [GENERAL] 9.5rc1 RLS select policy on insert?

Ted Toth writes: > This happens on simple INSERTs no RETURNING. You're going to need to show a concrete example. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail

Re: [GENERAL] Definitive answer: can functions use indexes?

> On 07 Jan 2016, at 5:19, Jim Nasby wrote: > > On 1/6/16 5:41 PM, Tom Lane wrote: >> Since the question makes little sense as stated, I'm going to assume >> you mean "can a query like SELECT ... WHERE left(foo, 3) = 'bar' >> use an index on column foo?" >> >> The answer to that is no, there is