On Thu, Jun 19, 2008 at 8:17 AM, Bill Moran
[EMAIL PROTECTED] wrote:
In response to [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hello,
i have the problem that postgres ist starting and stopping several (up
to 4) processes per minute, so that the error log in windows is
running full, with more
On Mon, May 12, 2008 at 4:53 PM, D Galen [EMAIL PROTECTED] wrote:
If this isn't the right place to post this, please advise.
I've spent a week trying to get PostgreSQL 8.3 to install correctly on
WIN2K. Server will load I see the server processes loaded but none of
them have any open
While developing PL/LOLCODE, I've found something wrong with returning
strings from LOLCODE functions using 8.3.0 or greater. Using 8.4beta
from a few days ago, for instance, a function that should return test
string returns
\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F in
pgsql
On Mon, Mar 17, 2008 at 2:27 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi Sam,
Thankyou for the suggestions. They make perfect sense to me. I
appreciate your time and input. The lack of optimiser usage was
something that I had not considered, and I thank you for making me
aware of
People tend to like the idea of PL/R, because R draws some awfully
nice (and frequently useful) eye candy, and it sounds cool to be able
to make such things from inside PostgreSQL. In my (probably very
limted) experience those people often find that it's harder than it
looks to make these plots
On 11/4/07, Reg Me Please [EMAIL PROTECTED] wrote:
Hi all.
I'd like to know whether the indexes on a table are updated or not during
a COPY ... FROM request.
That is, should I drop all indexes during a COPY ... FROM in order to gain
the maximum speed to load data?
Thanks.
Although
On 10/24/07, Bob Pawley [EMAIL PROTECTED] wrote:
Is there any way of converting text from an AutoCad (.dwg ot .dxf) file into
a PostgreSQL Database??
Bob Pawley
I know nothing of AutoCad, but your message has been sitting for a
while without response, so I'll throw out the suggestion that
On 10/6/07, Goboxe [EMAIL PROTECTED] wrote:
Josh,
Thanks for sharing a very good info on partitioning.
Don't thank me -- this comes from Robert Treat. I'm just the messenger :)
-Josh/eggyknap
---(end of broadcast)---
TIP 2: Don't 'kill -9' the
On 10/3/07, Goboxe [EMAIL PROTECTED] wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdf
- Josh/eggyknap
On 10/4/07, Ted Byers [EMAIL PROTECTED] wrote:
--- Michael Glaesemann [EMAIL PROTECTED] wrote:
On Oct 4, 2007, at 9:30 , Ted Byers wrote:
I do not know if PostgreSQL, or any other RDBMS,
includes the ability to call on software such as
R
See PL/R:
On 10/1/07, S Sharma [EMAIL PROTECTED] wrote:
Hi All,
The default table space defined in db conf file is used for all database
tables as well as indexes. So putting the indexes on another table space
requires manually dropping and re-creating indexes.
It would be nice to have a feature to
On 9/1/07, john_sm [EMAIL PROTECTED] wrote:
Hey Guys, can you suggest any Open Source Application Server for SOA
deployments. Also, wondering, if our needs are somewhat lightweight, is
there some lightweight open source Application Server you could Suggest.
What language are your
On 8/31/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote:
Phoenix Kiula írta:
I am getting this message when I start the DB:
psql: FATAL: could not access status of transaction 0
DETAIL: Could not write to file pg_subtrans/01F8 at offset 221184:
No space left on device.
What is
On 8/31/07, Alban Hertroys [EMAIL PROTECTED] wrote:
Hello,
I've recently been busy improving a query that yields a fixed number of
random records matching certain conditions. I have tried all the usual
approaches, and although they do work, they're all limited in some way
and don't translate
On 8/27/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello,
I have a question about whether I can safely declare a function IMMUTABLE.
Citing the documentation under Function Volatility Categories in the
section on Extending SQL:
It is generally
On 8/18/07, Julio Cesar Sánchez González
[EMAIL PROTECTED] wrote:
Hi guys,
It's natural what master table in the partitioning table contain data
(http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html) ?
or to be empty.
I'm no partitioning expert, but I would say most of the
On 8/18/07, Ron Johnson [EMAIL PROTECTED] wrote:
Interesting. Does PG have to initiate the Perl interpreter every
time you call a Perl-written SP?
IIRC PostgreSQL should only load the perl interpreter once per session.
- Josh
---(end of
On 8/15/07, Magnus Hagander [EMAIL PROTECTED] wrote:
Trevor Talbot wrote:
On 8/14/07, Jasbinder Singh Bali [EMAIL PROTECTED] wrote:
Let me fine tune my question here. What I mean to say is the way we can
write stored procedures in C, perl etc in Postgres specifying the language
On 8/15/07, Rohit [EMAIL PROTECTED] wrote:
I have few queries regarding the use of Stored Procedures, Functions
and Triggers in an RDBMS.
(1) When to use Stored Procedure? Writing an INSERT query in a Stored
Procedure is better or firing it from the application level?
(2) Can a Trigger call
On 8/14/07, Kirk Wythers [EMAIL PROTECTED] wrote:
I need some help with rewriting a query. I have a fairly complicated query
(for me anyway) that dumps daily climate data, filling in missing data with
monthly averages (one line per day).
I want to output monthly averages (one line per
On 8/6/07, Rodrigo Faccioli [EMAIL PROTECTED] wrote:
Hi,
I'm a new user's postgreSQL and I have a question: Is possible add function
of intelligent System like Neural Networks or Fuzzy Logic within postgre
SGDB?
For example: I have a database and I want to execute a select instruction.
On 8/3/07, Ow Mun Heng [EMAIL PROTECTED] wrote:
Can anyone shed some light on this. I just would like to know if queries
for raw data (not aggregregates) is expected to take a long time.
Running times between 30 - 2 hours for large dataset pulls.
Involves lots of joins on very large tables
On 8/2/07, Gavin M. Roy [EMAIL PROTECTED] wrote:
Are you contemplating providing access to data that's currently not stored
in the pg_ catalog tables? I currently monitor the statio data,
transactions per second, and active/idle backends. Things that I think
would be useful would be average
have committed in
posting to two lists simultaneously.
- Josh Tolley
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
On 7/20/07, Michael Glaesemann [EMAIL PROTECTED] wrote:
On Jul 20, 2007, at 17:54 , Vincenzo Romano wrote:
In an inner join involving a 16M+ rows table and a 100+ rows table
performances got drastically improved by 100+ times by replacing a
UNIQUE-NOT NULL index with a PRIMARY KEY on the
On 7/8/07, Crystal [EMAIL PROTECTED] wrote:
Hi All,
Our company need to save contact details into the PostgreSQL database. I
just begin to learn it, so I got many questions. I am not sure which
data type I should choose for website address, varchar or char. The
website address may be very long,
On 6/21/07, danmcb [EMAIL PROTECTED] wrote:
Hi
I have two tables, say A and B, that have a many-to-many
relationship, implemented in the usual way with a join table A_B.
How can I economically find all the rows in table A whose id's are not
in A_B at all (i.e. they have zero instances of B
On 6/21/07, brian [EMAIL PROTECTED] wrote:
I have a lookup table with a bunch of disciplines:
# SELECT id, name FROM discipline;
id |name
+-
1 | writing
2 | visual arts
3 | music
4 | dance
5 | film and television
6 | theatre
7 | media arts
28 matches
Mail list logo