I recently came across this question: "What is the purpose of PostGIS on
PostgreSQL?"<http://gis.stackexchange.com/q/223487/35779> and wanted to know
what this mailing list had to respond with.
?Thanks,
9.2.3, Was running overnight for 17 hours. Cancelled install. May investigate
further. Installing to Windows.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-long-to-wait-on-9-2-bitrock-installer-tp5723762p5746908.html
Sent from the PostgreSQL - general mailing list
Hi all,
I would like to know how to load a user defined function from a file
written in pl/pgsql.
I have read it on logging
psql -h host database < create_some_func.sql
but then i am forced to redo the login.Is there another way to do it?
--
Sent via pgsql-general mailing list (pgsql-general@po
rser is getting confused between a FOR IN SELECT loop and
a FOR integer loop.
If its not top secret we would like to see the code
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: [EMAIL PROTECTED]
ICQ :
Dear Mage ,
I'm wondering why pgsql doesn't support boolean typecasts like select
true::int;
Many client applications including php assign 1 to true and 0 to false
This was a issue PHP < 4.2 + < PostgreSQL 7.3.x and supports it till
now for backward compatibility
--
Best
for any kinda answers.
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: [EMAIL PROTECTED]
ICQ : 264360076
---
You yourself, as much as anybody in the entire
Dear twosk
I heard from somone that i could use PostgreSQL, but I cannot find any information
that confirms or denies it.
AFAIK There was a discussion on the same topic in Dec2003 please search
the list and you will geta solution
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai
process
This can work provided the database are on same system and have have
same schema not tried though.
2) I read that when dumping and restoring data the insert option is
safer but slower than copy? Does anyone know from experience how much
slower (especially for a database containing millions
Dear Anton Nikiforov,
The problem:
From the very beginning everything was fine and all records that i
was getting from routers were calculated just right. I spent a weeks
monitoring and testing my software.
Now i have 10.000.000 records in raw table and when i'm inserting data
alot of record
Hi Amir Khawaja ,
I have a rather trivial (I hope) question about OID types and
PostgreSQL. Since PostgreSQL creates tables "WITH OIDS" by default,
I'm wondering if it is bad practice to allow the default behaviour.
For example, if I have a database with 60+ tables (all tables
Dear ezra epstein ;
Using Postgres 7.4,
the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "%" at character 135
the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "ROWTYPE" at character 141
Very odd. The first doesn't even like t
Dear all,
Before reading all this let me assure you nothing is out of control just
DONT PANIC
I was just going through the pages of http://www.2038.org
and was concerned by the fact my computer using Linux will rollover to
Fri Dec 13 20:45:52 1901
after
Tue Jan 19 03:14:07 2038
Now
Hello javier garcia,
Hello Bob;
Some time ago I were using Postrges along with Excel via Microsoft Query and
ODBC. I just remember that there was a problem when trying to see views but
it worked with single tables. Perhaps you can experiment with that.
This problem can be over come by
Dear Markus Rebbert ,
what happens with sequences if i dump a database and i want to reload
it?
The pg_dump command also dumps the index value of sequences and you do
not have to do any thing
Just make sure your pg_restore and pg_dump with option --disable-tiggers
Regards,
Vishal kashyap
Dear Philippe Lang,
For e-mail from PgSQL function you need is
http://pgmail.sourceforge.net/
Tell me if it help's n one of my project its a great help
Regards,
V Kashyap
---(end of broadcast)---
TIP 8: explain analyze is your friend
Just a quick query,
Does the RPM for 7.1 do a pg_dump/restore as part of rpm -Uvh or do I
need to do this myself ?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020
Hello All-- Maybe someone here can benefit from what I noticed-- and/or
answer my new problem I have run into.
Thanks,
Sam
-Original Message-
From: Sam and Lisa Snow [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 14, 2001 2:20 PM
To: '[EMAIL PROTECTED]'
Subject: Porting Pos
is an existing unix/postgres user and changed the password for
that entry. This isn't what I wanted to happen. After some experimentation
I found that I could add a user xxx to the file with pg_passwd and then edit
the file and change the xxx to the correct 14 character name.
Is there a de
have
never seen a postgresQL news group on Usenet. It's really a hassle
to move all messages in pgsql-general to a separate folder or to
cut and paste when replying to a message within a digest. What do
you think?
Peter
--
--
I have been trying to get a colleague to update a database on my server
using a form I sent him for MS Access. The form was developed using
Access'97 and seems to work just fine on my PC. I just emailed the .mdb
file.
Everything worked well for the first couple of iterations of the fo
20 matches
Mail list logo