Re: [GENERAL] Re: duplicate key value violates unique constraint "pg_class_relname_nsp_index"

2015-05-27 Thread Pete Hollobon
On 27 May 2015 at 09:57, Albe Laurenz wrote: > > Mitu Verma wrote: > > Following error is continuously seen with the postgreSQL database which we are using at customer site. > > > > Current Errors observed: ./fm_db_VoiceReprocessing1/data/pg_log/postgresql-04.log:2015-04-04 01:00:16 > > CESTERROR:

Re: [GENERAL] Restarting DB after moving to another drive

2015-05-13 Thread Pete Hollobon
On 11 May 2015 at 19:01, Daniel Begin wrote: > Interesting, > > The symbolic links on the old drive -still used by the DB- look like > windows' shortcuts to parent folder, while they are empty folders in the > copy of the database I have on the new drive... > > When I do a plane copy of those link

Re: [GENERAL] How to clear buffer

2015-05-13 Thread Pete Hollobon
I wrote a few notes on doing this here: http://hollobon.com/_pgblog/clear_shared_buffers.html Thanks, Pete. On 13 May 2015 at 09:13, Ravi Krishna wrote: > I am writing bench mark scripts and as part of it would like to clear the > cache > programmatically. This is to ensure that when we run sel

Re: [GENERAL] Feature request: temporary schemas

2014-09-22 Thread Pete Hollobon
On 14 September 2014 22:01, cowwoc wrote: > Hi, > > I'd like to propose the ability to create temporary schemas. > > Unlike temporary tables, this feature would enable developers to create a > temporary schema once and execute CREATE TABLE statements without the > TEMPORARY parameter. > I think

Re: [GENERAL] Feature request: temporary schemas

2014-09-16 Thread Pete Hollobon
On 14 September 2014 22:01, cowwoc wrote: > Hi, > > I'd like to propose the ability to create temporary schemas. > > Unlike temporary tables, this feature would enable developers to create a > temporary schema once and execute CREATE TABLE statements without the > TEMPORARY parameter. > > > I thi