Re: [GENERAL] Reg: PL/pgSQL commit and rollback

2015-03-18 Thread Glyn Astill
> From: Medhavi Mahansaria >To: Adrian Klaver >Cc: "pgsql-general@postgresql.org" >Sent: Tuesday, 17 March 2015, 14:30 >Subject: Re: [GENERAL] Reg: PL/pgSQL commit and rollback > > > >Yes. I have read this document. > >But my issue is that even when it throws and exception I need to rollbac

[GENERAL] Windows installer

2015-03-18 Thread Tim Rowe
Is the Windows graphical installer still available? The "download" link from http://www.postgresql.org/download/windows/ gives a "Page not found" error. -- Tim Rowe

Re: [GENERAL] Windows installer

2015-03-18 Thread John McKown
Interesting. I can bring that page up on my work system. I clicked on it from your email address just now. My work PC is running Windows 7. My email reader is the web based reader at mail.google.com. I'm using Google Chrome browser. On Wed, Mar 18, 2015 at 6:05 AM, Tim Rowe wrote: > Is the Window

Re: [GENERAL] Windows installer

2015-03-18 Thread Tim Rowe
It now comes up with a maintenance page for me (with installation links), so that's ok, something is happening. It looks as if I just chose a bad time to install Postgres. Thanks :) On 18 March 2015 at 11:46, John McKown wrote: > Interesting. I can bring that page up on my work system. I clicked

Re: [GENERAL] Windows installer

2015-03-18 Thread John McKown
OOPS, I clicked on the download link on that page to go to: http://www.enterprisedb.com/products-services-training/pgdownload#windows and _it_ said "Down for Maintenance" But had a link to: http://get.enterprisedb.com/postgresql/postgresql-9.3.4-3-windows.exe http://get.enterprisedb.com/postgresql/

[GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread Tim Uckun
What do you guys do to namespace your functions so that they are not jumbled in with the system functions and also somewhat hierarchically organized. Obviously it's possible to create schemas for different namespaces but that can lead to a lot of schemas which hold no data. The other way is to s

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread WadeDare4703
I don't understand. What is wrong with having a schema which holds no data? Schemas are cheap. - Original Message - From: "Tim Uckun" To: "pgsql-general" Sent: Wednesday, March 18, 2015 6:56:55 PM Subject: [GENERAL] Name spacing functions and stored procedures What do you guys do

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread David G. Johnston
On Wednesday, March 18, 2015, WadeDare4703 wrote: > I don't understand. What is wrong with having a schema which holds no > data? Schemas are cheap. > > -- > *From: *"Tim Uckun" > > *To: *"pgsql-general" > > *Sent: *Wednesday, March 18, 2015 6:56:55 PM > *Subject:

[GENERAL] Archeiving and Purging

2015-03-18 Thread adityagis
Dear Users, I have lots of data in my DB. I need to do archeiving and purging of my data. Can anyone please help me with step by step riles? Thanks in Advance. Aditya Kumar -- View this message in context: http://postgresql.nabble.com/Archeiving-and-Purging-tp5842393.html Sent from the Post

Re: [GENERAL] Archeiving and Purging

2015-03-18 Thread John R Pierce
On 3/18/2015 7:20 AM, adityagis wrote: I have lots of data in my DB. I need to do archeiving and purging of my data. Can anyone please help me with step by step riles? like this? select * from table where datefield < current_date-interval '6 months'; delete from table where datefield < curre

Re: [GENERAL] Archeiving and Purging

2015-03-18 Thread David G. Johnston
On Wednesday, March 18, 2015, John R Pierce wrote: > On 3/18/2015 7:20 AM, adityagis wrote: > >> I have lots of data in my DB. I need to do archeiving and purging of my >> data. >> Can anyone please help me with step by step riles? >> > > like this? > > select * from table where datefield < cur

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread Pavel Stehule
Hi 2015-03-19 2:56 GMT+01:00 Tim Uckun : > What do you guys do to namespace your functions so that they are not > jumbled in with the system functions and also somewhat hierarchically > organized. > > Obviously it's possible to create schemas for different namespaces but > that can lead to a lot

[GENERAL] Unicode license compatibility with PostgreSQL license

2015-03-18 Thread Haribabu Kommi
Hi All, For our next set of development activities in PostgreSQL, we want to use the Unicode organization code with PostgreSQL to open source that feature. Is the Unicode license is compatible with PostgreSQL. The following is the header that is present in one of the Unicode files. /* * Copyrig

[GENERAL] Installation Size showing huge size in postgres installed on windows os

2015-03-18 Thread Rajagopal NS
I have installed Postgres 9.0 in my machine. When I look at Programs and Features under Control Panel, I see the Size for Postgres 9.0 is shown as 121GB. I feel neither the installation or the small postgres databases I would have created use 121GB. Any reason why it shows 121GB Regards NS