Very good book. I have the .pdf file of it from before they took it off
the site.
John Clark Naldoza y Lopez wrote:
Hello Scott,
PostgreSQL also supports regular expressions, _VERY_ useful..;-)
~* regular expression, case-insensitive..;-)
Try to get a copy of Bruce's book
Hello.
I have a question about perfomance.
I'm running PostgreSQL 7.1.2 at FreeBSD 4.3.
For the first 1-2 days of running perfomance is excellent. But
after that, speed began to decrease. And after a week of
operation, perfomance falls 8-10 times,
A question has intrigued me ever since I started to learn about Berkeley
DB (well after I had started using postgres): does PostgreSQL seperate
the data management routines such that I could use them in a way similar
to Berkeley DB? I find the concept useful for people who don't want to
start
On Tue, Aug 14, 2001 at 02:06:40PM +0600, Alexander Loginov wrote:
Hello.
I have a question about perfomance.
I'm running PostgreSQL 7.1.2 at FreeBSD 4.3.
For the first 1-2 days of running perfomance is excellent. But
after that, speed began to decrease.
Is the bug system at:
http://www.ca.postgresql.org/bugs/
actively in use? I recently reported the following bug:
http://www.ca.postgresql.org/bugs/bugs.php?4~415
and after doing so browsed through a number of earlier bugs it appears
that the vast majority are still 'unassigned' and
I am developing a db application in postgresql and
i need to write a delete trigger on one of the tables.
the environment is
table1
field1 varchar(64)
other fields.
table 2.
field1 varchar(64)
other fields
I need a delete trigger on the table 1, so that if
I delete a row from table 1
Does PostgresQL have some way to make update, insert and delete queries
not return the number of affected rows? I know that in MS SQL one would
use NOCOUNT for that.
TIA,
Jochem
---(end of broadcast)---
TIP 3: if posting/reading through
On Tue, 14 Aug 2001, Tom Lane wrote:
Lee Kindness [EMAIL PROTECTED] writes:
Is the bug system at:
http://www.ca.postgresql.org/bugs/
actively in use? I recently reported the following bug:
http://www.ca.postgresql.org/bugs/bugs.php?4~415
and after doing so browsed through a
This code looks fine to me, other than missing the actual trigger statement
is missing. Assuming table 1 is named apps:
DROP TRIGGER OnApplicationsDelete ON apps;
DROP FUNCTION ApplicationsDeleteFn();
CREATE FUNCTION ApplicationsDeleteFn()
RETURNS OPAQUE
AS '
BEGIN
delete from ports where
i have been using postgresql in preparation for supporting it with our
product. one thing that i do a lot is run scripts from the cmd-line,
and i have noticed a few things that seem to be lacking from the psql
app.
first off though, i must say how much it rocks. i absolutely hate
having to go
Hello Scott,
PostgreSQL also supports regular expressions, _VERY_ useful..;-)
~* regular expression, case-insensitive..;-)
Try to get a copy of Bruce's book
Introduction and Concepts
by Bruce Momjian
A sample from the book:
SELECT * FROM friend WHERE firstname ~* '[bc]'
read it online,
Thanks, it helps!
Tim Barnard wrote:
Another way SELECT INTO a new table, omitting the column you want to delete.
Tim
- Original Message -
From: Patrick Welche [EMAIL PROTECTED]
To: Fariba Noorbakhsh [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 13, 2001 7:36 AM
For the first 1-2 days of running perfomance is excellent. But
after that, speed began to decrease. And after a week of
operation, perfomance falls 8-10 times, than at first day of
using.
I'm doing vacuum periodically (once a hour), but perfomance
still falls down.
It
Stephan Szabo writes:
On Tue, 14 Aug 2001, Lee Kindness wrote:
Is the bug system at:
http://www.ca.postgresql.org/bugs/
actively in use?
It's mostly a front end for the pgsql-bugs mailing list. I don't
think the discussion and actions are generally copied back to the
online
Lee Kindness [EMAIL PROTECTED] writes:
Is the bug system at:
http://www.ca.postgresql.org/bugs/
actively in use? I recently reported the following bug:
http://www.ca.postgresql.org/bugs/bugs.php?4~415
and after doing so browsed through a number of earlier bugs it appears
that the
Hi
I have a very large database of seismic data. It is about 27 Gb now, and
growing at about the rate of 1 Gb every 3-4 days. I am running
postgres 7.1.2. I might possibly try to upgrade to 7.2 when it comes out,
but I don't know if it will be possible for me to do 7.3 due to
the
On Tue, 14 Aug 2001, Martin Kuria wrote:
Hi, I have a problem I am using postgresql database and I want to enforce
triggers between my related tables ( tables with relationship), one
table
has a foreign key and the other the a primary key, I would like to use
triggers to update,
Hi!
Tom == Tom Lane [EMAIL PROTECTED] writes:
Tom Justin Clift [EMAIL PROTECTED] forwards:
The problem was that when we run the benchmark with the --fast option,
which basicly does a vacuum() between after each batch of updates,
postmaster started to fill up disk with log files during one
Hello !
I've got a little problem with launching initdb on postgresql 7.1.2 under
cygwin :
when i launch it, it says :
$ initdb -d -n -D $PG_DATA
Running with debug mode on.
Running with noclean mode on. Mistakes will not be cleaned up.
Initdb variables:
PGDATA=/data/pgsql
On Tue, 14 Aug 2001, Lee Kindness wrote:
Is the bug system at:
http://www.ca.postgresql.org/bugs/
actively in use? I recently reported the following bug:
http://www.ca.postgresql.org/bugs/bugs.php?4~415
and after doing so browsed through a number of earlier bugs it appears
INSERT into env_info
(username,useremail,servicelevel,accountmanager,company) values
('$env_array{User}','$env_array{UserEmail}','$env_array{ServiceLevel}'
,'$env_array{AccountManager}','$env_array{Company}'
I sometime get a parse error near username, but for the life of me, can't
figure out
On Tue, 14 Aug 2001, Lee Kindness wrote:
Stephan Szabo writes:
On Tue, 14 Aug 2001, Lee Kindness wrote:
Is the bug system at:
http://www.ca.postgresql.org/bugs/
actively in use?
It's mostly a front end for the pgsql-bugs mailing list. I don't
think the discussion and
Hi,
I'm pretty new to PostgreSQL so please bear with me if this is a newbie
question that has been answered before on this list.
I have created several tables containing a SERIAL column-type as primary
key.
What I would like to do is get the last value of these columns after Ive
inserted a new
Tom Lane wrote:
Jochem van Dieten [EMAIL PROTECTED] writes:
Does PostgresQL have some way to make update, insert and delete queries
not return the number of affected rows? I know that in MS SQL one would
use NOCOUNT for that.
Uh ... why? Seems like a useless anti-feature. Certainly
Jochem van Dieten [EMAIL PROTECTED] writes:
Does PostgresQL have some way to make update, insert and delete queries
not return the number of affected rows? I know that in MS SQL one would
use NOCOUNT for that.
Uh ... why? Seems like a useless anti-feature. Certainly suppressing
the count
Jochem van Dieten [EMAIL PROTECTED] writes:
Uh ... why? Seems like a useless anti-feature. Certainly suppressing
the count wouldn't save a noticeable number of cycles.
I am not in it for the cycles, just for the laziness ;)
Currently working with a ColdFusion frontend through ODBC, and
yes you can. go to http://sources.redhat.com/cygwin/lists.html and
download the cygnus windows tool kit. the binary install comes with
postgres pre-built so if you don't want to build it yourself you
don't have to.
after you install cygwin you will need to read the postgres config
document found
This is my first posting to this site, but it's my
last resort. We're running 7.0.3. I have 20 servlets that makeuse of our
postgres database. All of the programs are able to perform their assigned SQL
tasks, but not on a consistent basis. Often and unpredictably, different
programs
Tom Lane wrote:
I'm doing vacuum periodically (once a hour), but perfomance
still falls down.
It sounds to me like you may be running into index growth problems.
VACUUM is presently not good about shrinking indexes.
I always enjoy Tom's comments - he is the master of understatement
Craig Longman writes:
1) stop on error
this seems to be doable through the env-var ON_ERROR_STOP, but i do wish
it was also parm i could pass on the cmd-line to psql. its just so much
easier than setting the everytime i want the stop behaviour. i guess i
could just set it and leave it.
Here is a fourth article discussing MySQL and PostgreSQL:
http://webtechniques.com/archives/2001/09/jepson/
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe
Sundararajan wrote:
I am developing a db application in postgresql and i need to write a delete
trigger on one of the tables.
the environment is
table1
field1 varchar(64)
other fields.
table 2.
field1 varchar(64)
other fields
I need a delete trigger on the table 1, so that if I
Hi,
how has the following to be read.. (ie. what is the total cost of the
query)... 4.05, 5.88 or ?
Why does the planner choose not to use numberdomain_pkey as index on
numberdomain ?
The table layout is quite bad (due to a lot of last minute-changes)
snip
# explain select c.*, (select
Philip Crotwell wrote:
Hi
I have a very large database of seismic data. It is about 27 Gb now, and
growing at about the rate of 1 Gb every 3-4 days. I am running
snip
Out of curiosity, how long does it take you to vacuum that?
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to
I am trying to upgrade from pg7.1 from 7.0 on RH7.0.
I do:
rpm -Fvh postgresql*7.1.2*rpm
but I get:
file /usr/bin/pg_id from install of postgresql-server-7.1.2-4PGDG conflicts
with file from package postgresql-7.0.2-17.
I've attached pg_id to this message.
I don't know what pg_id does
In dumping from one 7.1.2 install and trying to restore in another fresh
install:
You are now connected to database template1.
DELETE 0
psql:/local/dumpall-8-14:7: ERROR: CREATE USER: sysid 101 is already
assigned
CREATE USER
DELETE 0
You are now connected to database template1 as user
Jochem van Dieten wrote:
Dwayne Miller wrote:
SELECT nextval('mysequence') AS PKEY FROM DUAL;
...
Your inserts and updates using #queryname.pkey#
I know, but it has 2 queries again, which is exactly the reason why I
don't want it (I am actually developing this to be used by others).
Can anyone tell me how I might convert a null attribute value into a zero
attribute value such that it can be multiplied in a query.
In Oracle I could do:
sal*12*NVL(COMM, 0) AS Annual Income
where COMM is an attribute (a salesman commission, in an employes table)
which has null values. This
Me! :)
Geoffeg
This one time, at band camp, Digital Wokan wrote:
Who besides Daniel asked me for this?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Geoffrey Gallaway || I dunno, I dream in Perl sometimes.
[EMAIL
On Wed, 15 Aug 2001, Mike Withers wrote:
Can anyone tell me how I might convert a null attribute value into a zero
attribute value such that it can be multiplied in a query.
In Oracle I could do:
sal*12*NVL(COMM, 0) AS Annual Income
where COMM is an attribute (a salesman commission,
Can anyone tell me how I might convert a null attribute value into a zero
attribute value such that it can be multiplied in a query.
In Oracle I could do:
sal*12*NVL(COMM, 0) AS Annual Income
sal * 12 * CAST(COMM AS float8) AS Annual Income
Cheers
Jason
--
Indigo Industrial Controls
Hi,
My question:
is there anyway of retreiving the sequence_name corresponding to the
respective column,
knowing just the tablename and columnname?
The reason I need to do this, is because the application I write
dynamicly creates new tables, and I have no way of knowing the
Jan Wieck responded in an irritated manner thusly:
What exactly do you mean with there are no stored
procedures?
i won't pretend to know what what the original poster
had in mind when asking his question but i'm a newbie
at postgres and i have some confusion as to how a
function maps to a
At 06:30 PM 8/14/01 -0700, you wrote:
On Wed, 15 Aug 2001, Mike Withers wrote:
Can anyone tell me how I might convert a null attribute value into a zero
attribute value such that it can be multiplied in a query.
In Oracle I could do:
sal*12*NVL(COMM, 0) AS Annual Income
where COMM is
Svenne Krap [EMAIL PROTECTED] writes:
Why does the planner choose not to use numberdomain_pkey as index on
numberdomain ?
- Seq Scan on numberdomain nd (cost=0.00..1.85
rows=1 width=31)
Evidently because it thinks numberdomain only has one disk block,
and hence there's
On Wed, 15 Aug 2001, Mike Withers wrote:
At 06:30 PM 8/14/01 -0700, you wrote:
On Wed, 15 Aug 2001, Mike Withers wrote:
Can anyone tell me how I might convert a null attribute value into a zero
attribute value such that it can be multiplied in a query.
In Oracle I could do:
Ay caramba.
I'm trying to get PostreSQL 7.1.2 up and running on my i386 OpenBSD 2.9
machine. It seems like all is going well -- ./configure, gmake, gmake
install, initdb, createdb test all work fine, but then when I try to psql
test I get the following:
- - - - - - - - -
bash-2.05$
[EMAIL PROTECTED] wrote:
Hey guys,
Is there any reason why there are no stored procedures for postgresql or
does this have to do with the ability to add your own procedural
language?
What exactly do you mean with there are no stored
procedures?
I mean, we have more
Any suggestion on how to prepare for the next upgrade would be
appreciated.
I think it has to be said that if you want decent performance on excessively
large (50GB+) databases, you're going to need excessively good hardware to
operate it on. Buy a 3ware IDE RAID controller
If anyone cares I have figured out how to
do this. I use SPI_getbinval
and it works perfectly
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
50 matches
Mail list logo