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, th
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 dec
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 not
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 ta
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 Usenet,
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
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 appNam
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
On Tue, Aug 14, 2001 at 03:38:08PM +0200, Jochem van Dieten wrote:
> 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.
Just ignore the result. Postgres has to find all the row
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
>> 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 d
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
>
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
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 pg_dump/pg_rest
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 up
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
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
datadir=/usr/sha
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 a
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 di
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 r
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.
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 co
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,
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 make use 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 perform
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 understa
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 Aven
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,
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)
# explain select c.*, (select count(*) f
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
Out of curiosity, how long does it take you to vacuum that?
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to nois
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 (apa
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 postgr
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 use
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 PROTE
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 com
> 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
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 knowi
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"
>
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 the
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 c
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$ /usr/local/p
[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
> 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 (www.hypermicro.
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 PROTE
> 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 sequence
>
My guess is that you don't have the ipc-daemon running before you run
initdb.
--Barry
Steve SAUTETNER wrote:
> 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
Hi Gilles,
That's cool. Was hoping you'd figure it out!
Just updated the buggy link to point to your new HOWTO :
http://techdocs.postgresql.org/oresources.php#ldap
:-)
Regards and best wishes,
Justin Clift
Gilles DAROLD wrote:
>
> Hi all,
>
> Some of you dream of that, I just had nigthm
53 matches
Mail list logo
