[GENERAL] Why is this function wrong

2005-10-24 Thread Johan Wehtje
after AS. Can somebody point what is probably obvious. Cheers Johan Wehtje ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Why is this function wrong

2005-10-24 Thread Johan Wehtje
Thanks for your help, I adjusted the function after a better reading of the pl/Sql chapter - and feel I posted in haste. Hopefully though it may prove useful to someone else. Cheers Johan Wehtje Thomas F. O'Connell wrote: On Oct 24, 2005, at 11:27 AM, Johan Wehtje wrote: This is probably

Re: [GENERAL] PgInstallerfor 8.1 beta 3 missing Postgis?

2005-10-22 Thread Johan Wehtje
between 8.0 and 8.1 in Postgres it is probably worthwhile having a README that opens as soon as the installer is done with information on upgrading from previous installations as well as pointers to the change log. Cheers Johan Wehtje Magnus Hagander wrote: Magnus, I have replied to general

[GENERAL] PgInstallerfor 8.1 beta 3 missing Postgis?

2005-10-21 Thread Johan Wehtje
, but it only contains some perl scripts, the postgis.sql file is nowhere to be found. Is there an updated version of the installer with the missing bits of postgis? Cheers Johan Wehtje ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [GENERAL] PgInstallerfor 8.1 beta 3 missing Postgis?

2005-10-21 Thread Johan Wehtje
am having. Any suggestions you have would be appreciated Tack på förhand Johan Wehtje Magnus Hagander wrote: I don't know whether I should be posting to Hacker Win 32 or General, but I wanted to ask if anyone else has experienced troubles restoring a DB on windows to 8.1 from 8.0.x when

Re: [GENERAL] A good client

2005-10-19 Thread Johan Wehtje
a difference. Cheers Johan Wehtje Tony Caduto wrote: With some add on tools Delphi comes close, but it is still nowhere near as quick as Access to build a bunch of forms , pump data into spreadsheets, charts, word processing applications. It is often little things that make the difference

Re: [GENERAL] A good client

2005-10-18 Thread Johan Wehtje
In terms of really good GUI clients we are now at a stage where we are spoilt for choice. There is PgAdmin, both III and the new Beta are excellent. Aquafold Data Studio is also nice. I use SQLManager Postgresql Manager from sqlmanager.net all the time. PGLightning is also very good. I actually

Re: [GENERAL] ANN: Rekall V2.4.0

2005-10-18 Thread Johan Wehtje
think we already have a number of really excellent GUI DB managers, and to me Rekall looks more like a Db Manager than Rich Client cum RAD tool for Db centric applications. Cheers Johan Wehtje John Dean wrote: Hi Tom At 03:32 18/10/2005, Tom Lane wrote: Johan Wehtje [EMAIL PROTECTED] writes

Re: [GENERAL] ANN: Rekall V2.4.0

2005-10-17 Thread Johan Wehtje
have support for transactions and Stored Procedures. Given that from the 7 series onwards the relative speeds of MySql and Postgresql is not something that has a clear and definitive answer, I would suggest that the Connection Wizard text is misleading at best. Johan Wehtje John Dean wrote: We

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

2005-10-15 Thread Johan Wehtje
are) or for projects that become quite risky for developer and client alike. Johan Wehtje Alex Turner wrote: Actualy to me, it seems like postgres is a perfect partner for MS Access. Throw out Jet, and use Pgsql. It's infinately better than Jet, so operating in a Win98 environment seems

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

2005-10-15 Thread Johan Wehtje
. Cheers Johan Wehtje Matthew Peter wrote: Someone trying to stick microsoft yet another place they don't belong. --- Johan Wehtje [EMAIL PROTECTED] wrote: Very much a description of the Business I am in. For all the criticism leveled at it, I still think that as a rich Database Client

[GENERAL] copy command feature requests

2005-08-26 Thread Johan Wehtje
. Johan Wehtje ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] convert mdb files to pg?

2005-01-27 Thread Johan Wehtje
of data sets (usually particular tables). I have used it with Postgres 8.0 b2, b5, rc1 and final as well as worth 7.4.2. You can also use it across a network (Import Access DB on Winbox1 to PG DB on Linbox 2) Cheers Johan Wehtje David Fetter wrote: On Thu, Jan 27, 2005 at 02:50:11PM -0500

Re: [GENERAL] postgresql and javascript

2004-12-10 Thread Johan Wehtje
is very active at the moment. Cheers Johan Wehtje Geoffrey wrote: Chris Smith wrote: [EMAIL PROTECTED] wrote: Does anyone know how to connect javascript to a postgresql database You can't connect javascript to any sort of database. Actually you can, with server side javascript, although I

Re: [GENERAL] PoastgreSQL/SQLite Anywhere?

2004-12-01 Thread Johan Wehtje
licenses are similar , so from that point of view the combination is a no-brainer. Johan Wehtje Wolfgang Keller wrote: Hello, for applications which require offline data collection/processing with PDAs and synchronisation/replication with a centralised server database (running on PostgreSQL), I

Re: [GENERAL] tool for postgresql

2004-11-29 Thread Johan Wehtje
a (somewhat pricey) solution. Cheers Johan Wehtje Gevik Babakhani wrote: Checkout http://www.pgadmin.org *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Nageshwar Rao *Sent:* Monday, November 29, 2004 10:20

[GENERAL] Column n.nsptablespace does not exist error

2004-11-29 Thread Johan Wehtje
I am getting the error Column n.nsptablespace does not exist in my application when I connect using my Administrative tool. This only happens with Version 8, but it does crash my application, does anyone have any ideas ? Cheers Johan Wehtje ---(end of broadcast

Re: [GENERAL] Column n.nsptablespace does not exist error

2004-11-29 Thread Johan Wehtje
Thanks Neil, I will just have to hassle EMS to upgrade :) Cheers Johan Wehtje Neil Conway wrote: On Tue, 2004-11-30 at 17:54 +1100, Johan Wehtje wrote: I am getting the error Column n.nsptablespace does not exist in my application when I connect using my Administrative tool. This only happens

Re: [GENERAL] XUL and mozilla/firefox SQL extension

2004-11-28 Thread Johan Wehtje
project. Johan Wehtje Joshua D. Drake wrote: [EMAIL PROTECTED] wrote: Considering using the firefox SQL extension combined with XUL to create a web application to access a database in PostGreSQL, wondering if anyone has attempted this, and how it turned out? Hello, I have played

Re: [GENERAL] Query on exception handling in PL/pgSQL

2004-11-27 Thread Johan Wehtje
and there was one error in line 45,000 the server would write a file with the same name as the input file + an extension like err, with just that row omitted . Also it would load 100 rows at a time - perform any logging. Johan Wehtje Victor Ciurus wrote: And how does exactly PG8.0 help us

Re: [GENERAL] Can COPY skip a header line?

2004-11-20 Thread Johan Wehtje
MS SQL Server has a BULK INSERT command that can take a parameter Start Row so that you can skip as many Rows as you want. this is also available using the command line bcp utility. This would be a nice feature for Postgresql to have , and I can't see it on any of the to do lists, unless it is

Re: [GENERAL] Visual DATA MODEL Designer in linux?

2004-11-08 Thread Johan Wehtje
relatively new product called Data Architect, that appeared promising. http://www.thekompany.com/home/ Cheers Johan Wehtje Eric wrote: Heu... I search for a graphical DATA MODEL designer in linux to developp my database project (to draw) it on screen instead of paper and pencil... Thanks for answers about