Re: [GENERAL] RE: Convert Filemaker Pro db to Postgresql db

2001-04-09 Thread Michelle Murrain
On Monday 09 April 2001 10:49 am, Scott Gritton wrote: > Hi Joel, > I'm not a FM user so I actually don't know about its capabilities. > I've been given the assignment to convert our FM bug database over to > Postgresql and was hoping that there was a tool out 'there' that could > accomplish this

[GENERAL] Re: speed on Postgresql compared to Mysql

2001-04-09 Thread Joel Burton
On Mon, 9 Apr 2001, Lincoln Yeoh wrote: > At 05:30 AM 08-04-2001 -0400, Joel Burton wrote: > >On Tue, 3 Apr 2001, Livio Righetti wrote: > >> Also we used Postgresql for Radius (authentication) et we have to make 3 > >> vacuum per day otherwise the first server is overload and the user go to > the

[GENERAL] store procedure

2001-04-09 Thread Juan
hello list, i´m new in stores procedure and i want to do one writed in pl/pqsl, that it returns a table. i´m accesing from odbc. how the store procedure returns the table to process it in the programming languaje(vb)? what type it returns? can you send me an example. thanks Juan ---

Re: [GENERAL] linux/bsd

2001-04-09 Thread Chris Jones
On Mon, Apr 09, 2001 at 11:00:04AM +1200, Richard Boyes wrote: > My question is to what operating system would be a better > one to use for postgres. ie linux/bsd. As far as PG is concerned, it doesn't really matter; PG will run very nicely on any unix. In my experience, Sun's machines have bet

[GENERAL] Deadlock detected

2001-04-09 Thread Brian J. France
Hello, I am getting a few of these errors in my web logs and didn't know what I could do to stop it. NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause. Error in query "UPDATE SET = WHERE = " : ERROR: WaitOnLock: error on wakeup - Aborting this transaction

Re: [GENERAL] Remove data types?

2001-04-09 Thread Peter Eisentraut
Pruner Jan writes: > Is it possible to remove data type 'name'? No. > I'm trying to move our IS from Sybase Anywhere to PostgreSQL > and I need to create table 'name'. Ain't gonna happen. ;-( -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ -

Re: [GENERAL] Support of type procedure

2001-04-09 Thread Peter Eisentraut
Mourad EL HADJ MIMOUNE writes: > I have read in some document about Postgres that this last supports > attrubutes of type procedure. > Type procedure allows values of an attribute to be represented by a > procedure. This presumably existed in or near Berkeley POSTGRES 4.2, and some support code

Re: [GENERAL] linux/bsd

2001-04-09 Thread Peter Eisentraut
Richard Boyes writes: > My question is to what operating system would be a better > one to use for postgres. ie linux/bsd. More important things to worry about are a fast disk, a modern file system, lots of memory, lots of CPU. The operating system ends up being a matter of taste mostly. -- P

[GENERAL] PostgreSQL on Windows (again)

2001-04-09 Thread Steve Jorgensen
Ok, please forgive my bone-head, not even a newby yet questions. I need to set up PostgreSQL on Windows, and create a step-by-step set up instructions for a team ov people I'm working with who will need to do the same. I tried out the Install version at http://208.160.255.143/pgsql/pgsql.exe and

Re: [GENERAL] postgres 7.0.3 on FreeBSD 3.4

2001-04-09 Thread Yann Ramin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You'll have to do a clean kernel recompile. Make sure you set 'maxusers' in your kernel config file to 128 or higher. Information on compiling your own kernel can be found in the FreeBSD Handbook. On Tuesday 03 April 2001 02:37 pm, Michal Taborsk

Re: [GENERAL] Win Nt setup help please

2001-04-09 Thread Steve Jorgensen
There is no native port of PostgreSQL. PostgreSQL uses UNIX system calls, so Cygwin is required to translate these to Windows system calls no matter what you used to compile the program with. On Tue, 20 Mar 2001 16:03:34 + (UTC), [EMAIL PROTECTED] (Matthew) wrote: >Pardon my ignorance on th

RE: [GENERAL] Re: Windows install

2001-04-09 Thread charlie derr
It seems that the cygwin stuff comes with this install (I already had cygwin configured on my machine, but this install created another one, with all the details taken care of). The install went fine. Then i entered the cygwin shell (that had been installed with postgreSQL) and did "su postgres"

Re: [GENERAL] quota's ?

2001-04-09 Thread Sander Steffann
Hi, > On Sat, Apr 07, 2001 at 01:46:48PM -0400, Doug McNaught wrote: > > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > > > > Doug McNaught writes: > > > > > > > Doing this would almost certainly result in a corrupted database once > > > > you ran up against the limit. > > > > > > I think you c

Re: [GENERAL] getting the right version of cygwin for windows2000 install

2001-04-09 Thread Steve Jorgensen
Well, I've been trying to do this myself. Go to http://sources.redhat.com/cygwin/download.html and run the setup program which will install the latest Cygwin, and even copy in a PostgreSQL 7.1 RC2 directory to go with it. I'm not able to make it work, though. First, it seems odd that they provi

Re: [GENERAL] linux/bsd

2001-04-09 Thread Justin Clift
Hi Marc, No argument there. Solaris 8 is a LOT better then previous versions in regards to driver support, but still a long way behind *BSD, linux, Windows, etc. BUT, if you've got hardware it DOES work on... it's really nice. Regards and best wishes, Justin Clift The Hermit Hacker wrote: >

[GENERAL] Re: store procedure

2001-04-09 Thread Joel Burton
On Mon, 9 Apr 2001, Juan wrote: > hello list, > i´m new in stores procedure and i want to do one writed in pl/pqsl, that it > returns a table. > i´m accesing from odbc. > > how the store procedure returns the table to process it in the programming > languaje(vb)? what type it returns? Juan --

Re: [GENERAL] ongoing holy grail thread

2001-04-09 Thread Tony Grant
On 09 Apr 2001 12:58:55 -0400, Dave Smith wrote: > Did you start the database server with the -i option? Redhat scripts started the database. From vague memory there was an -i in there. I am now using this as an excuse to move up to 7.1RC4. So startup is on the list of things to do. I'm tired,

[GENERAL] Re: PostgreSQL on Windows (again)

2001-04-09 Thread Joel Burton
On Mon, 9 Apr 2001, Steve Jorgensen wrote: Check your path to make sure that cygipc is in it. IIRC, configure is looking for libcygipc, and probably not finding it. > $ ./configure > creating cache ./config.cache > checking host system type... i686-pc-cygwin > checking which template to use... w

Re: [GENERAL] Re: information on users

2001-04-09 Thread will trillich
On Sun, Apr 08, 2001 at 05:44:28AM -0400, Joel Burton wrote: > On Tue, 3 Apr 2001, Nick T wrote: > > I see that we can add users and delete or drop users. As the database > > administrator, I'd like to be able to view all of the users and all of the > > information about them. Couldn't find out

Re: [GENERAL] Deadlock detected

2001-04-09 Thread Maurice Balick
Brian J. France wrote: > > BTW, on a different table I get this warning ever time I vacuum the database. It doesn't seem to cause a problem, but didn't know how to get rid of it. > > NOTICE: Index : NUMBER OF INDEX' TUPLES (214) IS NOT THE SAME AS HEAP' (215). > Recreate the index

Re: [GENERAL] Views and default values

2001-04-09 Thread will trillich
On Fri, Apr 06, 2001 at 01:26:39PM +0200, DaVinci wrote: > On Fri, Apr 06, 2001 at 12:24:09PM +0100, Michael Ansley wrote: > > >> Data Base: > > >> > > >> create table foo ( > > >> cod serial primary key, > > >> explication text, > > >>

Re: [GENERAL] Virtual domains ?

2001-04-09 Thread will trillich
On Tue, Apr 03, 2001 at 05:41:54PM +0300, Kris Van Hulle wrote: > On 3 Apr 2001, at 10:31, Tom Lane wrote: > > > "Kris Van Hulle" <[EMAIL PROTECTED]> writes: > > > Does PostgreSQL have support for virtual domains ? > > > > In 7.1 you can configure the postmaster to bind only to one specific IP >