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 pro
.
In every case I always get the syntax error directly 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
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 as
mp restore woes such as I 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 windo
gis folder, 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 belo
oes make a difference.
Cheers
Johan Wehtje
Tony Caduto wrote:
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 - the speed with which drop down lists
can be created is a huge boon to
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 PROTEC
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 p
does
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
its no-one.
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
pplications in this market 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 ope
he DB.
Johan Wehtje
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
pment 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,
both 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 PostgreSQ
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.
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
has 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
thesis 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 with
a bulk copy 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 he
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
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
22 matches
Mail list logo
