[GENERAL] will this bug be fixed in 7.5

Hi, We just experienced this bug: http://tinyurl.com/28gkh on 7.4.1 (freebsd and os x). Is there any chance this is on the list for 7.5? culley ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] Training and certification

I think the first step is a book called "The Official PostgreSQL Certification Study Guide - Everything You Need to Know to Pass the PostgreSQL Adminsitrator Certification Test (PG-081)" which would be based on the "Official PostgreSQL Certification Syllabus." All the M$ certifications I have

[GENERAL] order of statements in create function

Hi, why does everyone write CREATE FUNCTION foo() RETURNS INTEGER AS ' blah blah ' LANGUAGE 'plpgsql'; I've never seen for example: CREATE FUNCTION foo() RETURNS INTEGER LANGUAGE 'plpgsql' AS ' blah blah '; Is there a special reason to this? I have a hard time believing

Re: [GENERAL] adding a db-specific user

On Fri, Jul 09, 2004 at 17:06:20 +, Sally Sally <[EMAIL PROTECTED]> wrote: > I was wandering how I can add a user to a specific db. There are several > databases but I want to add the user to only one of them. It seems when I > add a new user, it is entered in the pg_user table and I can lo

[GENERAL] adding a db-specific user

I was wandering how I can add a user to a specific db. There are several databases but I want to add the user to only one of them. It seems when I add a new user, it is entered in the pg_user table and I can log in to any one of the other dbs (ofcourse I won't be able to do anything until I gran

Re: [GENERAL] Training and certification

Am Freitag, 9. Juli 2004 08:30 schrieb Bret Busby: > Thus, recognised, international, industry certification of > open source application systems development, either involving PostgreSQL > as a database backend by itself, or, involving PostgreSQL as a factor > could be useful, apart from having the

Re: [GENERAL] PG vs MySQL

Is this a TODO here, perhaps dumping authentication from tables? --- Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > since the purpose of the pg_hba.conf file is to ensure that you never > > manage to lock

Re: [GENERAL] max_fsm_pages

> "TL" == Tom Lane <[EMAIL PROTECTED]> writes: TL> VACUUM will fill whatever FSM space is available. You do have to TL> restart the postmaster to get the increased FSM size to be allocated, TL> but you don't have to do any magic pushups beyond that. Do you need a full restart or will a simpl

Re: [GENERAL] Training and certification

I recall an extended discussion of certifications and training some time back. You may recall it, too. The outcome (if it may be so called) was the view that, given the nature of the PostgreSQL project, there exists no entity that can bless a certification and thereby make it "official", any more

Re: [GENERAL] Enough RAM for entire Database.. cost aside, is this

In article <[EMAIL PROTECTED]>, Edmund Dengler <[EMAIL PROTECTED]> writes: > But on the other hand, general algorithms which are designed to work under > a wide variety of circumstances may fail in specific cases. I am thinking > of VACUUM which would kill most caching algorithms simply because we

Re: [GENERAL] Column name 'user' not allowed?

> I tried to install phpopenchat but I can't create this table: > > poc=> CREATE TABLE poc_user_account ( > poc(> USER varchar(255) NOT NULL, Thanks everyone! Creating the database with quoted USER column worked fine, now I have to resolve the other problems. I'd like to see one application de

Re: [GENERAL] HELP

Marek Nowiński wrote: I accidentaly deleted over 1.000.000 records from one table in my database. Is there any way to recover them? Please help me as soon as possible... After the records were deleted, no other operation was made on the database. In fact, all the postgres services were shut down. I