Re: [GENERAL] Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist

2004-03-22 Thread Tom Lane
Chris Lee <[EMAIL PROTECTED]> writes: > When I try to restore dump (using 7.4.2 pg_dumpall) from 7.1.2, I got the > following error: > [1-1] ERROR: relation "pg_relcheck" does not exist > [2-1] ERROR: relation "pgadmin_checks" does not exist > [ etc ] Are you *certain* you used the 7.4 dump pro

Re: [GENERAL] Funniest way to write 'PostgreSQL'

2004-03-22 Thread Matthew D. Fuller
[ I'm a bit behind on email :] On Mon, Mar 15, 2004 at 07:41:52PM +0200 I heard the voice of Kaarel, and lo! it spake thus: > Kaarel wrote: > > >What is the funniest way you have seen 'PostgreSQL' written? > > > >Postgres and Postgre are a common way to say PostgreSQL...and they are > >not reall

[GENERAL] Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist

2004-03-22 Thread Chris Lee
Hi, When I try to restore dump (using 7.4.2 pg_dumpall) from 7.1.2, I got the following error: [1-1] ERROR: relation "pg_relcheck" does not exist [2-1] ERROR: relation "pgadmin_checks" does not exist [3-1] ERROR: relation "pgadmin_checks" does not exist [4-1] ERROR: column pg_group.oid does

Re: [GENERAL] Beginner Questions Please: Which To Go With ?

2004-03-22 Thread Frank Finner
Hi, from my point of view (and according to my experiences) I wouldn´t recommend the use of MySQL between Access and PostgreSQL. It has a somewhat similiar, although subtle different language compared to PostgreSQL, and if one uses it, he will get used to that and going on to PostgreSQL will be

Re: [GENERAL] "select for update" confusion

2004-03-22 Thread Keary Suska
on 3/21/04 5:10 PM, [EMAIL PROTECTED] purportedly said: > I'm trying to build a type of record "check out" program and I'm just > a wee bit confused. > Several users will be using the same select > statement at the same time and just want to make sure they're getting > different records. example..

Re: [GENERAL] Shared memory errors during initdb in Mac OS X

2004-03-22 Thread Jerry LeVan
The default allocation of shared memory on mac os x is a bit small from /etc/rc: sysctl -w kern.sysv.shmmax=4194304 I ran into a problem when I tried to do a make test on the distribution, there is not enought shared memory for two instances. I googled and found an ipcs package that I was able to c

Re: [GENERAL] Shared memory errors during initdb in Mac OS X

2004-03-22 Thread Tom Lane
John Siracusa <[EMAIL PROTECTED]> writes: > and then restarted. Now it works, but I'm not sure if it was the change in > settings or the restart that fixed it. Obviously I had to restart to make > the changes take effect, but my theory before I bit the bullet and restarted > was that some stale s

Re: [GENERAL] PHP or JSP? That is the question.

2004-03-22 Thread Michael Chaney
Not reading the newsgroup, I missed the original. But here's my two cents. First, do not use Microsoft products on a web server unless you want to spend all your time applying patches and cleaning up the results of your server being used as a warez site. The initial setup might be easy, but the

Re: [GENERAL] Shared memory errors during initdb in Mac OS X

2004-03-22 Thread John Siracusa
On 3/22/04 1:45 PM, John Siracusa wrote: > Of course, I'v already set all the shared memory params, and have been runing > 7.4.1 quite successfully with them. Immediately after the error above, I ran > this to check the values: > > % sysctl -a | egrep shm > kern.sysv.shmmax: 10485760 > kern.sysv.

[GENERAL] Any Information About Simulation Enviroment?

2004-03-22 Thread Reza Zakery
Hi, I'm a master of science student at Sharif university, Iran. As a part of my thesis, I'm going to write a system that is supposed to be used as a educational aid material for the Advanced Databases course. This tool will be based on PostgreSQL and must provide a simulation environment that

Re: [GENERAL] High Reliability without High Availability?

2004-03-22 Thread Randal L. Schwartz
> "Al" == Al Cohen <[EMAIL PROTECTED]> writes: Al> Is there a log file that does or could do this? Or some internal Al> system table that we could use to generate something? I may be just mis-remembering, but wasn't there an embedded-Perl solution that connected up as triggers for all your c

Re: [GENERAL] unsigned types, binary op. and cast pb

2004-03-22 Thread Stephan Szabo
On Mon, 22 Mar 2004, Pierre Didelon wrote: > > On Fri, 19 Mar 2004, Pierre Didelon wrote: > > > >> > >>Hi postgresql experts, > >> > >>I am new to the group so forgive any misunderstanding or repetition. > >> > >>I noticed a previous mail concerning unsigned types, claiming > >>several solutions,