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
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
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
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
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"
>
> 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.
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
[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
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
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,
> > 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
> 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
>
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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.
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
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
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
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
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
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
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
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
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
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,
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
>
>> 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
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
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
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
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
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,
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
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
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
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
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
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
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
>
53 matches
Mail list logo
