Title: notifications:Urgent help needed!!
Hi All,
Im new to Postgresql and using version 7.2.4.
I want to get notification from backend when a specific error message (like low space) comes to the front end.
How should I specify Notify and Listen condition?
Thx. In advance.
Anagha
Title: Create Rule/trigger
Hi All,
Can we create trigger/rule that specifies
Do action Y
when
inserts/updates to any table in the database X occurs?
Thx. In advance.
Anagha
John McGloughlin writes:
config.log (sorry for the BIG file ... wasn't sure if you wanted the
whole thing or not
Looks like you need to install (or make available) the termcap library.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of
Anagha Joshi writes:
Can we create trigger/rule that specifies
Do action 'Y'
when
inserts/updates to any table in the
database 'X' occurs?
No, you need to create a trigger/rule for each table.
If you just want to audit things, maybe you could
It sounds like you may have uncontrolled index growth. This happens when
you update indexes by adding information to one end, and removing it from
the other. The index becomes lop sided (they're btrees) and begins to
grow.
you can either reindex the indexes, drop and recreate them, or wait
Title:
I cannot view the currval because it is not set in the session yet. Is there
a way to set it without having to increment the value?
Thanks
Jodi
--
___
Jodi L Kanter
BioInformatics Database Administrator
University
select last_value from your_sequence;
Jodi Kanter wrote:
I cannot view the currval because it is not set in the session yet. Is
there a way to set it without having to increment the value?
Thanks
Jodi
---(end of broadcast)---
TIP 7: don't
Title:
I tried that and it did not work. It won't be a problem in the code since
it appears that we are always doing a nextval prior to currval, but I was
just wondering about how to do it while in a psql session.
Weiping He wrote:
select
last_value from
On Wed, Jun 18, 2003 at 09:49:58 -0400,
Jodi Kanter [EMAIL PROTECTED] wrote:
so it sounds like I just need to tell my programmer friend to change his
use of last value to currval instead?
This is most likely what you want to do.
---(end of
On Wed, Jun 18, 2003 at 09:55:51 -0400,
Jodi Kanter [EMAIL PROTECTED] wrote:
I cannot view the currval because it is not set in the session yet. Is
there a way to set it without having to increment the value?
What value do you expect to see and why do you want to see it?
What flavor Postgresql are you running? That works on both my 7.2.x boxes
and my 7.3 boxes. If you're running anything older than 7.2.x, you might
wanna upgrade before asking for help, since folks tend to assume you're
running at least 7.2 around here.
Note that this IS NOT TRANSACTION safe.
What's your thought on creating some type of calibration applet that will
divine proper settings for the PostgreSQL performance related variables by
taking into consideration the speed of the machine, amount of RAM, access time
of the filesystem, and the speed of various queries on a standardized
Sure, it would be great if we could do it.
---
Chris Gamache wrote:
What's your thought on creating some type of calibration applet that will
divine proper settings for the PostgreSQL performance related variables by
Bruce Momjian [EMAIL PROTECTED] writes:
Sure, it would be great if we could do it.
If the program actually derives reliable numbers, it would be great.
It could easily do more harm than good if it gives bogus results.
I think it will be very hard to get reliable rather than bogus results
:-( ...
I'm interested in using a passwords table with my Access front end, but
need to encrypt the passwords over the network. Can anyone help me get
started on this kind of project?
---(end of broadcast)---
TIP 7: don't forget to increase your free
Hi All ,
H/W Configuration - Dell 7150 Quad Itanium 1 ( 733 MHz) with 4G RAM
OS- Red Hat 7.2
- Postgresql ver 7.3.3 compiled from raw hide red hat rpms.
Problem : We were able to install postgreSQL 7.3.3 successfully on this enviornment ,
but server
Hi,
I'm trying to setup some scripts that will allow me to use Perl DBI to
INSERT into my table. However, I have not had any success at all. I'm
using perl CGI as well so I've granted ALL permissions on my table to
the apache user and I still can't INSERT. I can, however, UPDATE and
SELECT on
Hi,
the function bellow is created successfully, but executing it forces the
following error message:
WARNING: Error occurred while executing PL/pgSQL function
drop_table_if_exists
WARNING: line 5 at select into variables
ERROR: parser: parse error at or near $1 at character 34
CREATE OR
On Wed, 18 Jun 2003, Erwin Ambrosch wrote:
Hi,
the function bellow is created successfully, but executing it forces the
following error message:
WARNING: Error occurred while executing PL/pgSQL function
drop_table_if_exists
WARNING: line 5 at select into variables
ERROR: parser: parse
Always check for bad memory when you see sig 11 first.
There are bugs that can throw a sig11, but if you see them at random
places, with random queries, it's usually bad memory.
On Tue, 17 Jun 2003, Taranjit Singh Lamba wrote:
Hi All ,
H/W Configuration - Dell 7150 Quad Itanium 1 ( 733
My guess is that we don't have spinlock code for the CPU yet. I think
it may be in 7.4.
---
Taranjit Singh Lamba wrote:
Hi All ,
H/W Configuration - Dell 7150 Quad Itanium 1 ( 733 MHz) with 4G RAM
OS
Are there really any performance settings of much interest beyond the
shared and non-shared memory settings? Beyond those the interactions
get so complex that automation is probably impossible anyway, and
certain options like fsync = false should never be 'recommended'.
On the other hand, a way
On Tue, Jun 17, 2003 at 16:51:33 -0500,
Kovalcik, Mike A [ITS] [EMAIL PROTECTED] wrote:
$sth = $dbh-do(INSERT INTO transactions
(date,description,amount,confirmation,nameid,typeid) VALUES
('$datePaid','$description','$amount','$confirmation',$nameid,$typeid))
;
Most likely you want single
I'm trying to setup some scripts that will allow me to use Perl DBI to
INSERT into my table. However, I have not had any success at all. I'm
using perl CGI as well so I've granted ALL permissions on my table to
the apache user and I still can't INSERT. I can, however, UPDATE and
SELECT on the
It would be nice to have something that could suggest settings for the
different *cost* options.
On 18 Jun 2003, matt wrote:
Are there really any performance settings of much interest beyond the
shared and non-shared memory settings? Beyond those the interactions
get so complex that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You should not be using the do method, but the prepare/execute model
instead. Using placeholders can not only be more efficient but allows
quoting to happen properly. Here is a rewrite:
#--Establish the DB connection
#--Assign the DB name
my
That was it. ncurses-devel, termcap-devel, readline-devel fixed the problem.
Thanx a bunch for all those that helped.
johnmac
Kuhn, Dylan K (4520500D) wrote:
John,
The trick on my RedHat 7.3 system was to install the termcap-devel, readline-devel, and zlib-devel RPMs from the installation
Precisely. Any hints from the real gurus out there as to how that might
be accomplished (or alternatively, reasons why it's hopeless)?
On Wed, 2003-06-18 at 18:42, scott.marlowe wrote:
It would be nice to have something that could suggest settings for the
different *cost* options.
On 18
setting RaiseError to true is the way to go in DBI.
it catches most of the error and prints in apache error log.
if RaiseError = 1 one does not have to do the explicit
die after the connect even i think
regds
mallah,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You should not be
Taranjit Singh Lamba [EMAIL PROTECTED] writes:
H/W Configuration - Dell 7150 Quad Itanium 1 ( 733 MHz) with 4G RAM
OS - Red Hat 7.2
- Postgresql ver 7.3.3 compiled from raw hide red hat rpms.
[raises eyebrow] Does RHL 7.2 claim to support Itanium?
Bruce Momjian [EMAIL PROTECTED] writes:
My guess is that we don't have spinlock code for the CPU yet.
Out-of-the-box it would probably build with SysV semas instead of
spinlocks, but that's not going to cause crashes, only less-than-stellar
performance.
regards, tom lane
From: Joerg Budischewski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi,
I'd like to announce the availability of a native postgresql driver
version 0.5.0 for OpenOffice.org database API.
The driver's homepage can be found here:
http://dba.openoffice.org/drivers/postgresql/index.html
The
Just before I received this mail, I got spam from something 'Anagha
Joshi', I think all PostgreSQL ADMIN users got this mail, so probably
have you... please look into it (forgot to check all e-mail headers, to
look for forged from-fields and such, alergic as I am to something that
looks spammy :P
Hello All
is in postgres any possibility to create bitmap index ? I have big
(~12 000 000 records) table where one field have limited count of
values. Many queries use this field in where section. I thing that
bitmap index will by better than BTree.
How i can optimize select on
On June 18, 2003 12:54 pm, Chris Gamache wrote:
What's your thought on creating some type of calibration applet that
will divine proper settings for the PostgreSQL performance related
Have you seen pg_autotune? It's aging... but might be something to play
with.
Title: Latest transcation
Hi All,
Is there any way to know programatically which is the latest insert/update occured to a particular table?
What are the values which are inserted/updated to that table?
Help appreciated.
Thx.,
Anagha
36 matches
Mail list logo
