On Tue, 2005-12-27 at 20:58 -0800, Randal L. Schwartz wrote:
> > "Tony" == Tony Caduto <[EMAIL PROTECTED]> writes:
>
> Tony> Check out my site at http://www.amsoftwaredesign.com
>
> Tony> and click on the forums link, I have some examples on how to send a
> Tony> email from a function using p
It sounds as if reliability of the data is of some importance (usually is in
financial applications), and personally, I wouldn't trust mySQL with such data
-- the inability to have clean transactions, its willingness to insert data
that doesn't match what the original input was with throwing an
Sure so long as they decide to go with this solution. It would be greatly
appreciated. Have you looked at Ruby which is quite helpful when dealing
with PHP Perl CGI and C/C++. I haven't a lot of programming experience, my
degree is in BA Adv Mgmt and Financial Acctg and Diploma in IT. I rapidly
I would prefer using linux. I have worked in a limited capacity with both
linux and windows. The front end I was looking at Ruby/PHP.
Thanks Igor
SQ- ledger.org provided by Dann Corbit has a lot of what I would be looking
for plus more. The financials would require a budgeted amount plus requ
> "Tony" == Tony Caduto <[EMAIL PROTECTED]> writes:
Tony> Check out my site at http://www.amsoftwaredesign.com
Tony> and click on the forums link, I have some examples on how to send a
Tony> email from a function using plperl, also how to connect to a simple
Tony> socket server and send messa
Pamela wrote:
Hello:
I was wondering if anyone has setup a point-of-sale system with
postgresql. Also, I will have to create a database for a church that
requires lots of tables and subcategories. They have 4 different
locations and wish to be interconnected amongst each other,
Postg
Aftab Alam wrote:
Hi there,
How can i send mail form postgresql.
which language i can use,for that some thing i have to install for postgres.
Kindly suggest.
thanx & regards
aftab
Check out my site at http://www.amsoftwaredesign.com
and click on the forums link, I have some examples on ho
Maybe this helps:
http://www.sql-ledger.org/
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Pamela
Sent: Tuesday, December 27, 2005
4:32 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] new beginner to
postgresql. Looking at it for a church
Hel
Hi there,
How can i send mail form postgresql.
which language i can use,for that some thing i have to install for postgres.
Kindly suggest.
thanx & regards
aftab
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settin
I have installed PG on Windows XP successfully several times, but now I
have one machine on which the install
fails with an error message: "Failed to set permissions on the installed
files. Please see the logfile at ..." . The log file in question does
not look very useful. It has lines of the type
Ingo van Lil wrote:
Hi there,
is there any way to add new columns to a view without dropping and
recreating it (and thus every other view that depends on it)? A friend
of mine came up with a crude hack that involves manipulating the reltype
flag in pg_class so Postgres thinks the view is actualy
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> How would syncsync differ from sync;sync? The second
> case will wait for the first command to return, or is there a race
> condition that's reduced by typing by hand?
The actual runtime of the "sync" program is epsilon, because it doesn't
wait for all
This sounds like a dangerous line to walk, to me.
If the schemas for the two database systems are diverging, then trying
to synchronize them is sure to have problems. I do not think that there
is any miracle cure (using PostgreSQL or any other database system).
If you know of a sure subset of ta
I am debugging a plpgsql function.
I came from an MSSQL server and I am missing a few techniques here so I
apologize for using MS as my reference.
Is there a variable that stores the number of records the last statement
effected? - in MS it was @@RowCount, I could constantly check its value as I
s
Hello:
I was wondering if anyone has setup a
point-of-sale system with postgresql. Also, I will have to create a database for
a church that requires lots of tables and subcategories. They have 4 different
locations and wish to be interconnected amongst each other, yet remain distinct
OK.
I'm try to explain my problems. My customer have Postgre server with any
older version of my DB (without any new or modified views, functions etc.)
and when i create export (in pgAdmin3), then pg_dump makes a SQL script. Ok.
It's nice, but when i'm trying to run this script on customer's machi
Petr,
As long as the new server is the same operating system, and the versions of
postgres are the same, you can do a binary copy of the data directory and move
it to the new machine, point the new server's postgres to the copied and data
and start it up. Indexes, statistics, etc. all are intac
Pg_dump followed by pg_restore is the usual way:
pg_dump dumps a database as a text file or to other formats.
Usage:
pg_dump [OPTION]... [DBNAME]
General options:
-f, --file=FILENAME output file name
-F, --format=c|t|p outp
Hi.
Is any way how to detach complete database, and attach it into other Postgre
server (like MSSQL, Interbase etc. databases movability) ?
Moving database via SQL export is crazy way for me (and for my customers).
Thanks and forgive me for my poor english.
Petr
---(end
David Rysdam <[EMAIL PROTECTED]> writes:
> According to what I've been able to find:
> A = predicted time to first returned row in milliseconds
arbitrary units
> B = total cost in arbitrary units
> C = actual time to first returned row in
On Thu, Dec 22, 2005 at 11:47:13AM -0500, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > On Wed, Dec 21, 2005 at 11:30:15PM -0800, Benjamin Arai wrote:
> >> Somebody said running "sync ; sync; sync" from the console. This seems
>
> > The reason is partly historical. On some OSes running sy
There's been plenty of vacuuming and analyzing on these tables, so
outdated stats are not the answer.
No but it could be incorrect stats do to the statistics parameter not
being set high enough.
Joshua D. Drake
---(end of broadcast)---
TIP
I'm afraid I still don't understand the output of EXPLAIN ANALYZE. The
output I get is like this:
blah blah blah (cost=A..B blah blah) (actual time=C..D blah blah)
According to what I've been able to find:
A = predicted time to first returned row in milliseconds
B = total cost in arbitrary un
Hi,
On Tue, 2005-12-27 at 15:54 -0800, dfx wrote:
> How I can set case-insensitive the system, or avoid the conversion to
> lower case?
You need to double-quote the object names that you don't want to be
converted to lower case, like CREATE TABLE "DevrimGunduz".
Regards,
--
The PostgreSQL Compa
On Tue, Dec 27, 2005 at 12:41:44PM -0500, Ted Byers wrote:
> I am puzzled. Can ayone explain why I get an error from Postgres
> on this simple stored procedure?
There are several mistakes in the code you posted:
* PostgreSQL doesn't have a CREATE PROCEDURE command. Use CREATE
FUNCTION.
* You
Eugene wrote:
> hello!
> I have IP CSV, it is huge CSV with quotes
> "69110784","69111807","US","UNITED
> STATES","ILLINOIS","BLOOMINGTON","40.4758","-88.9894","61701","LEVEL 3
> COMMUNICATIONS INC","DSL-VERIZON.NET"
> "69111808","69112831","US","UNITED
> STATES","TEXAS","GRAPEVINE","32.9309"
On 12/27/05, Ted Byers <[EMAIL PROTECTED]> wrote:
> I am puzzled. Can ayone explain why I get an error from Postgres on this
> simple stored procedure?
>
> The following is from the pgAdmin III History window:
> -- Executing query:
> CREATE PROCEDURE addEntity (
one reason could be that PROCEDURE
Try
CREATE FUNCTION .
On Tuesday 27 December 2005 09:41, Ted Byers wrote:
> I am puzzled. Can ayone explain why I get an error from Postgres on this
> simple stored procedure?
>
> The following is from the pgAdmin III History window:
> -- Executing query:
> CREATE PROCEDURE addEntity (
> f
You can't, you have to double qoute everything that has upper or mixed
case. It can become a huge PITA
The easiest way to get around this is to use lower case for all your DDL
i.e. columns, tablenames etc.
There is no practical reason to use uppercase or mixed case excecpt for
purly visual
Well, the rule is very simple, either always quote your identifiers, or
never quote them. If you always quote them, then you always need to
specify them in the same case. If you never quote them, then you always
get case-insensetivity.
My memory is a little hazy, as it's been a few years, but
Dear
Sirs,
I
understood that I can create objects with Upper and Lower case but I have to
reference it with double quotes (INSERT INTO "Accoglienza" ("IdAccoglienza")
VALUES (15);" is ok)
The
new question is: can I avoid the automatic conversion to lower case in Postgres?
(it exist som
On Tue, Dec 27, 2005 at 09:14:20AM -0600, John McCawley wrote:
> Due to case weirdness in Postgres, particularly when accessing it from
> PHP, I completely abandoned mixed case table and column names. I don't
> know if things have changed in the past several years, but when I first
> made the l
Due to case weirdness in Postgres, particularly when accessing it from
PHP, I completely abandoned mixed case table and column names. I don't
know if things have changed in the past several years, but when I first
made the leap, mixed case was more trouble than it was worth.
Even after I got
On 12/27/05, dfx <[EMAIL PROTECTED]> wrote:
> Dear Sirs,
>
> I have a little problem:
>
> - Contest: Server side: Linux Fedora core 4 with PostgreSQL v. 8.0
> Client side: both Linux Fedora core 4 with pgAdmin III v.
> 1.4 and/or Windows 2000 server vith pgAdmin III v. 1.4
>
> - I M
On Tue, 27 Dec 2005, dfx wrote:
Dear Sirs,
I have a little problem:
- Contest: Server side: Linux Fedora core 4 with PostgreSQL v. 8.0
Client side: both Linux Fedora core 4 with pgAdmin III v.
1.4 and/or Windows 2000 server vith pgAdmin III v. 1.4
- I Made a table:
CREATE TABL
Dear
Sirs,
I have a little
problem:
- Contest: Server
side: Linux Fedora core 4 with PostgreSQL v. 8.0
Client side: both Linux Fedora core 4 with pgAdmin III v. 1.4 and/or Windows
2000 server vith pgAdmin III v. 1.4
- I Made a
table:
CREATE TABLE "Accoglienza"(
"IdA
Mr. Treat:
I need to support geo-spatial data (like air images) in a
database. since that kind of data has georeferenced information anexed,
I need to know if your are able to provide a database which support that
type of data.
Thanks, and Mery Xmas.
---(e
Hi there,
is there any way to add new columns to a view without dropping and
recreating it (and thus every other view that depends on it)? A friend
of mine came up with a crude hack that involves manipulating the reltype
flag in pg_class so Postgres thinks the view is actualy a table, using
'ALTER
hello!
I have IP CSV, it is huge CSV with quotes
"69110784","69111807","US","UNITED
STATES","ILLINOIS","BLOOMINGTON","40.4758","-88.9894","61701","LEVEL 3
COMMUNICATIONS INC","DSL-VERIZON.NET"
"69111808","69112831","US","UNITED
STATES","TEXAS","GRAPEVINE","32.9309","-97.0755","76051","LEVEL
Mark Constable wrote:
But obviously there is no point in the lost time for the conversion to
postgresql if ultimately postgresql has a similar limitation.
Ultimately, PostgreSQL has sooo many non-limitations with respect to
MySQL that you would never find that it was "lost time" -- I don't
Thanks guys,
Found it!
Just needed info on the pgcrypto package.
On 12/27/05, Lic. Martin Marques wrote:
> On Mon, 26 Dec 2005, Tom Lane wrote:
> >
> > This might be a good time to press your buddy to move to 8.1 ;-)
> > PG 8.1 contains logic that should positively prevent a wraparound, by
> > shutting down the server if wraparound gets too close.
>
that was m
Am 2005-12-22 10:11:48, schrieb Jim C. Nasby:
> > PostgreSQL != Access
> > PostgreSQL ~ MS SQL Server
>
> Note that many people have had good results by using Access as a
> front-end to PostgreSQL.
I have stoped using Windows with WfW 3.11 and Access 2.0
Greetings
M
On Mon, 26 Dec 2005, Tom Lane wrote:
This might be a good time to press your buddy to move to 8.1 ;-)
PG 8.1 contains logic that should positively prevent a wraparound, by
shutting down the server if wraparound gets too close.
But if VACUUM fixes the wraparound issue, shouldn't even a badly
c
44 matches
Mail list logo
