Re: [GENERAL] Equivalent function not found for ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE().

2017-03-28 Thread Adrian Klaver
On 03/28/2017 12:51 PM, Rob Sargent wrote: On 03/27/2017 04:59 AM, MAJUMDER, SAYAN wrote: Hi, I am new to postgresql and presently we are migrating from sql server to postgresql. We have certain functions in sql server such as ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE(). I am unable to fin

Re: [GENERAL] [REQUEST] Change Windows standard distribution to Visual Studio 2015 for PostgreSQL 10 and later

2017-03-28 Thread Adrian Klaver
On 03/28/2017 06:46 AM, Hans Buschmann wrote: I use Postgres on Windows 64 bit (8.1,10,WS2012R2,WS2016) for quite a while. I always install and upgrade from the ZIP binary distribution from enterpriseDB which works like a charm. In a recent fresh install I noticed that PostgreSQL 9.6.2 (older v

Re: [GENERAL] Equivalent function not found for ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE().

2017-03-28 Thread David G. Johnston
On Tue, Mar 28, 2017 at 12:51 PM, Rob Sargent wrote: > On 03/27/2017 04:59 AM, MAJUMDER, SAYAN wrote: > > Hi, > > I am new to postgresql and presently we are migrating from sql server to > postgresql. > > We have certain functions in sql server such as > ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSA

Re: [GENERAL] Equivalent function not found for ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE().

2017-03-28 Thread Rob Sargent
On 03/27/2017 04:59 AM, MAJUMDER, SAYAN wrote: Hi, I am new to postgresql and presently we are migrating from sql server to postgresql. We have certain functions in sql server such as ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE(). I am unable to find any equivalent functions in postgres

Re: [GENERAL] Equivalent function not found for ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE().

2017-03-28 Thread John R Pierce
On 3/27/2017 3:59 AM, MAJUMDER, SAYAN wrote: I am new to postgresql and presently we are migrating from sql server to postgresql. We have certain functions in sql server such as ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE(). I am unable to find any equivalent functions in postgresql. Kin

[GENERAL] Equivalent function not found for ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE().

2017-03-28 Thread MAJUMDER, SAYAN
Hi, I am new to postgresql and presently we are migrating from sql server to postgresql. We have certain functions in sql server such as ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE(). I am unable to find any equivalent functions in postgresql. Kindly help me. Thanks in advance. Its urgent. Tha

[GENERAL] [REQUEST] Change Windows standard distribution to Visual Studio 2015 for PostgreSQL 10 and later

2017-03-28 Thread Hans Buschmann
I use Postgres on Windows 64 bit (8.1,10,WS2012R2,WS2016) for quite a while. I always install and upgrade from the ZIP binary distribution from enterpriseDB which works like a charm. In a recent fresh install I noticed that PostgreSQL 9.6.2 (older versions not tested anymore) requires Visual C+

Re: [GENERAL] Issue in autovacuum

2017-03-28 Thread Tom Lane
Adrian Klaver writes: > On 03/28/2017 03:15 AM, Agarwal, Prateek wrote: >> When I upgrade my db to 9.4.6 (my application remains same and hardly >> any code change w.r.t transaction declarations), it started complaining >> about dead rows below. I am not sure if it is something to do with >> upgra

[GENERAL] Postgres Permissions Article

2017-03-28 Thread Paul Jungwirth
Hi All, I wrote a blog post about the Postgres permissions system, and I thought I'd share: http://illuminatedcomputing.com/posts/2017/03/postgres-permissions/ The main point I wanted to convey, which I somehow never grasped confidently from reading the docs or other articles, is how permiss

Re: [GENERAL] Request to add feature to the Position function

2017-03-28 Thread David G. Johnston
On Tue, Mar 28, 2017 at 7:09 AM, Adrian Klaver wrote: > On 03/28/2017 12:29 AM, Ron Ben wrote: > >> Here is a refer to the stackoverflow question: >> >> http://stackoverflow.com/questions/42974822/find-sub-string- >> position-from-the-end-of-string-in-postgresql >> >> it carry another example and

Re: [GENERAL] Request to add feature to the Position function

2017-03-28 Thread Adrian Klaver
On 03/28/2017 12:29 AM, Ron Ben wrote: Here is a refer to the stackoverflow question: http://stackoverflow.com/questions/42974822/find-sub-string-position-from-the-end-of-string-in-postgresql it carry another example and the solution however I still think that this fuctionality should be avliab

Re: [GENERAL] Issue in autovacuum

2017-03-28 Thread Adrian Klaver
On 03/28/2017 03:15 AM, Agarwal, Prateek wrote: I had 9.3.0 previously where auto vacuum was working fine where it was able to reclaim space by removing dead tuples. Version: PostgreSQL 9.4.6 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit When I upg

Re: [GENERAL] Trigger based logging alternative to table_log

2017-03-28 Thread Glyn Astill
> From: Jeff Janes > To: "pgsql-general@postgresql.org" > Sent: Monday, 27 March 2017, 18:08 > Subject: [GENERAL] Trigger based logging alternative to table_log > > I have some code which uses table_log > (http://pgfoundry.org/projects/tablelog/) to keep a log of changes to > selected tables.

[GENERAL] Issue in autovacuum

2017-03-28 Thread Agarwal, Prateek
I had 9.3.0 previously where auto vacuum was working fine where it was able to reclaim space by removing dead tuples. Version: PostgreSQL 9.4.6 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit When I upgrade my db to 9.4.6 (my application remains same a

Re: [GENERAL] Request to add feature to the Position function

2017-03-28 Thread Ron Ben