Greetings!
I have found references on the Internet to a connection string designer for
npgsql, but I haven't found where to get it. I don't seem to have it with my
download of npgsq. Or am I just looking in the wrong place?
For example, http://npgsql.projects.postgresql.org/exampleprograms.htm
Greetings!
We just upgraded a customer's PostgreSQL installation from 8.3 to 8.4.1. I
wanted to make a small change to the database. I wanted to take a backup
before I did it, just in case. When I run pgAdmin from the PostgreSQL/8.4/bin
folder and try to take a backup, the backup fails. The
Greetings!
I am using PostgreSQL 8.3, as are most of our customers. But we still have at
least one who is using PostgreSQL 8.1. The log files from that customer are
showing repeated syntax errors, but they are not giving me any information
about where the errors are coming from. Here's a sam
Greetings!
PostgreSQL just crashed on a client's machine. There are several strange
things in the log file for today. Among the strangest is the following:
2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error at or
near "qecr" at character 2
2009-10-21 12:28:01 EDT anneal 94
Greetings!
At the current moment, our customer's computer has 22 instances of postgres.exe
running. When a colleague checked a few minutes ago, there were 29. Our
contract specifies that we cannot consume more than 40% of the computer's
memory, and we're over that level. When does an instanc
I like to use RAISE NOTICE statements to make sure my functions are working
correctly. I just wrote a trigger function that has the following code:
-- We have a new tender. Find out who it is.
select into userRecord * from users where users_key = new.tender_key;
if not found then
r
By George, I think you've got it!
(Imagine a hokey imitation British accent.)
I only had to make one small change. It complained it didn't know about a
column named "charge". When I changed it to:
select charge, (cn).* from (select charge, chargeneeds(charge) as cn from
charge) q;
it worke
Greetings!
Having received the answer I needed to my question about using functions with
OUT parameters from this list (thanks very much!), I find myself confused about
how to use the function in a view. The function chargeneeds takes one input
parameter, a charge number, and has 3 output para
I have been beating my head against the documentation on plpgsql functions with
output parameters for the last three hours, but I haven't been able to get them
to work yet.
I am playing with the sum_n_product function, taken from the doucmentation:
-- Function: sum_n_product(integer, integer)
Greetings!
I just ran across one of the strangest pieces I have ever seen in a piece of
software.
I was connected remotely to a test machine set up at a customer's site. The
machine is running Windows XP and PostgreSQL 8.1. PGAdmin has a connection to
the customer's production database, whic
From: Steve Crawford
To: Radcon Entec
Cc: "pgsql-general@postgresql.org"
Sent: Wednesday, April 8, 2009 1:15:55 PM
Subject: Re: [GENERAL] Table has 22 million records, but backup doesn't see them
Radcon Entec wrote:
>
> Here is the t
By the way, a full backup and restore using PGAdmin and accepting all default
setings worked successfully, including all 22 million feedback records.
I still would like to understand why the feedback table cannot be backed up by
itself. The technique of backing up and restoring only selected ta
From: Steve Crawford scrawf...@pinpointresearch.com
And what was the result? Zero-size file? If not, what was in the file?
Here is the text that results from dumping my 22-million-row feedback table:
--
-- PostgreSQL database dump
--
-- Started on 2009-04-08 10:10:49 Eastern Daylight Time
SET
Greetings!
I'm running PostgreSQL 8.1 under Windows XP, looking at a database hosted on a
machine running PostgreSQL under Windows Server 2003.
The database has a table with three simple columns and 22 million rows. I am
trying to back up that table by itself. However, pg_dump finishes almost
Greetings!
On my computer, I have a copy of a customer's database for which a full backup
file would be about 300 megabytes long. There are several history tables that
are not needed for day-to-day operation of our system. I came up with a DOS
batch file that consists of a sequence of pg_dump
15 matches
Mail list logo
