Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> Hi,
>
> Does anyone have any packages for 7.3.4 for debian woody?
I'd like that too--Oliver Elphick has 7.3.2 but it doesn't look like
he's had time to build 7.3.4. I may try to build it myself but
probably won't get to it until later this we
I'm sorry, found my mistake, the way I'm calling the function is wrong
it should be "audit_log" ('xtable','internal'), it works.
Thanks
Josué Maldonado wrote:
Hello list,
I have a tcl trigger function called audit_log(varchar, bpchar), if I
write a trigger in a table
CREATE TRIGGER tg_test
Hi list,
That's the question, anyone knows a way to do that?
Thanks in advance,
Josue Maldonado.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hello list,
I have a tcl trigger function called audit_log(varchar, bpchar), if I
write a trigger in a table
CREATE TRIGGER tg_test
AFTER INSERT OR UPDATE OR DELETE
ON xtable
FOR EACH ROW
EXECUTE PROCEDURE audit_log('xtable','internal');
it gives this error:
ERROR: CreateTrigger: funct
Hello list,
First of all, excuse me if this is not the right site to ask my question.
Is there a way in postgresql to loop to all the fields of a given table
and compare the OLD and NEW value for each field. I need to make an
audit table that must contain only the fields changed after and
ins
> I understand that ObjID of LOCKtag recognizes each individual row
locked by
> a row level lock. BUt i have noticed that if i lock 2 different rows of
the
> same table they have the same blkno. is this deduction ok?
If they happen to be stored in the same block, they'd have the same blkno
On Tue, 2003-09-02 at 20:40, Adam Kavan wrote:
> And there is the problem, all of the counts stay at 0 no matter what I do.
OK, so why is this happening... a bug in the stats system? Ignoring
pg_autovaccu, what numbers do you get from the stats system when you do
a:
SELECT relname,n_tup_ins,n_tu
Hi,
Does anyone have any packages for 7.3.4 for debian woody?
Thanks in advance,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people
First, I meant to ask for debug level 3, (-d3, not -d2) sorry Also,
are you sure that pg_autovacuum is connecting to the same database
cluster as your insert delete script?
I have attached a new log with a debug level of 3. And I am sure they are
connecting to the same cluster, I only have
On Tue, 2003-09-02 at 18:30, Adam Kavan wrote:
> Ok I ran pg_autovacuum using the supplied command line and have attached
> the resulting log. My script is just INSERT INTO "PointUsage"
> VALUES(DEFAULT,32,now(),1024); repeated several thousand times. I ran
> autovac, then my script, then veri
Replying to myself...
On Wed, 3 Sep 2003, Nigel J. Andrews wrote:
>
> The subject says it really. Is there a way to query the value of $libdir, and I
> don't mean the dynamic_library_path GUC?
>
> I ask because, I have scripts to create databases and I've come to make
> adjustments to load tsea
The subject says it really. Is there a way to query the value of $libdir, and I
don't mean the dynamic_library_path GUC?
I ask because, I have scripts to create databases and I've come to make
adjustments to load tsearch2. Now contrib/tsearch2 installs itself into $libdir
with tsearch2.sql insta
HI,
how much storage space etc.
Thanks
Aaron
On Wed, 2003-09-03 at 02:44, Richard Welty wrote:
> On 03 Sep 2003 00:26:04 +0300 Aaron <[EMAIL PROTECTED]> wrote:
> > Can anyone out there point me to an inexpensive web hosting solution
> > that offers postgres database support???
>
> i have a linux
So you probabaly want to do somethign like this:
pg_autovacuum -d2 -s1 -S0 -v10 -V0 -a10 -A0 -L pg_autovacuum.out
this will set debug=2, sleep only 1 sec after each look, and perform
vacuums and analyzes after only 10 insert/update/delets and log it all to
pg_autovacuum.out
Run your update scrip
I am running a connection pool for the PostgreSQL and I was wondering which values you would reccommend for the connection pool?
maxWait
5000
maxActive
>
> What do you mean which options am I setting? I am using
>
> ./pg_autovacuum -U akavan -s30 -d3
Yeah, this is what I was looking for.
> I am using redhat 9 with gcc 3.2.2. And I will paste some output from
> debug level 2 at the end of this post. During the run I inserted 10523
> lines int
On Tue, 2 Sep 2003, Bo Lorentsen wrote:
> On Tue, 2003-09-02 at 22:21, Bruno Wolff III wrote:
>
> > This will be a little easier than checking out a copy from CVS. However,
> > I think the HISTORY file has more detail in it.
> I think you are right, maybe a cvsview utility would help, regarding
>
On Tue, 2003-09-02 at 23:32, Tom Lane wrote:
> I don't believe Bruce has yet made any effort to update the SGML
> release-notes file for 7.4. Instead look at the CVS-tip HISTORY file:
> http://developer.postgresql.org/cvsweb.cgi/pgsql-server/HISTORY
Ok thanks, this is very usefull !
/BL
-
On Tue, 2003-09-02 at 22:21, Bruno Wolff III wrote:
> This will be a little easier than checking out a copy from CVS. However,
> I think the HISTORY file has more detail in it.
I think you are right, maybe a cvsview utility would help, regarding
this problem ? But a bugzilla tool, may also be nice
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Bo Lorentsen <[EMAIL PROTECTED]> wrote:
>> Are there a list of things that will be done in 7.4, or better a
>> development roadmap like the one the Mozilla folks are using ?
> For a quick look see the current version of the release notes on the web a
On Tue, 2 Sep 2003, Richard Huxton wrote:
> On Tuesday 02 September 2003 21:51, Aurangzeb M. Agha wrote:
> > I run my Postgres DB on a virtual linux server where I don't have root.
> > I'm 'admin', by default, and have created a 'postgres' user to own the DB
> > dir.
> >
> > My problem is that on
Hi,
Can anyone out there point me to an inexpensive web hosting solution
that offers postgres database support???
Thanks
Aaron
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Tuesday 02 September 2003 21:51, Aurangzeb M. Agha wrote:
> I run my Postgres DB on a virtual linux server where I don't have root.
> I'm 'admin', by default, and have created a 'postgres' user to own the DB
> dir.
>
> My problem is that on occassion, my ISP restarts my server, stranding all
> m
> I understand that ObjID of LOCKtag recognizes each individual row locked
by
> a row level lock. BUt i have noticed that if i lock 2 different rows of
the
> same table they have the same blkno. is this deduction ok?
If they happen to be stored in the same block, they'd have the same blkno
..
"Jenny -" <[EMAIL PROTECTED]> writes:
> I understand that ObjID of LOCKtag recognizes each individual row locked by
> a row level lock. BUt i have noticed that if i lock 2 different rows of the
> same table they have the same blkno. is this deduction ok?
If they happen to be stored in the same b
I understand that ObjID of LOCKtag recognizes each individual row locked by
a row level lock. BUt i have noticed that if i lock 2 different rows of the
same table they have the same blkno. is this deduction ok?
thanks
jenny
_
Get MS
On Mon, 2003-09-01 at 21:46, Matthew T. O'Connor wrote:
> Just thought everyone might be interested to know that the
> distributed.net project now uses postgresql for its stats tracking
> system. They just migrated from Sysbase which they had been using for
> several years. Check out:
> http://n0
On 2 Sep 2003 at 9:36, Vivek Khera wrote:
> > "BL" == Bo Lorentsen <[EMAIL PROTECTED]> writes:
>
> BL> On Tue, 2003-09-02 at 04:08, Vivek Khera wrote:
> >> 3) Index bloat is apparently a bigger problem than I thought.
> BL> This does not sound too nice !
>
> No, like I said, I shaved 900Mb o
> "BL" == Bo Lorentsen <[EMAIL PROTECTED]> writes:
BL> On Tue, 2003-09-02 at 04:08, Vivek Khera wrote:
>> I use it in 24/7/365 system which is heavily written to and read
>> from. The drawbacks I have are:
BL> How depressing, may I ask that PG version you are using ?
Currently 7.2 in product
On Tue, 2 Sep 2003, Shridhar Daithankar wrote:
> On 2 Sep 2003 at 15:08, Amin Schoeib wrote:
> > I would like to know if there is a Function in Postgres
> > Like the LAST_DAY Function in Oracle??
> > In Oracle you can use the function the get the last day of a month.
>
> While this is not a dir
Hi,
if didn't find this function on
http://www.postgresql.org/docs/7.3/interactive/functions-datetime.html,
You have to write own function
testdb=> create or replace function last_day(date) returns date as 'select
cast(date_trunc(''month'', $1) + ''1 month''::interval as date) - 1'
language s
On 2 Sep 2003 at 15:08, Amin Schoeib wrote:
> I would like to know if there is a Function in Postgres
> Like the LAST_DAY Function in Oracle??
> In Oracle you can use the function the get the last day of a month.
While this is not a direct answer to question..
It made me think. I am sure lot of
Title: LAST_DAY Function in Postgres
Hi,
I would like to know if there is a Function in Postgres
Like the LAST_DAY Function in Oracle??
In Oracle you can use the function the get the last day of a month.
Thanxx
Schoeib
4Tek Gesellschaft für angewandte Informationstechnologien mbH
S
Title: Problems with GRANTING SELECT to a table
Hi,
I have a problem with permissions for SELECT.
Here is what I did:
test=> GRANT SELECT ON "poi"."fondsstamm" TO "flex";
GRANT
test=> \dp fondsstamm;
Access privileges for database "test"
Schema | Table | Access
On 2 Sep 2003 at 12:25, Bo Lorentsen wrote:
> On Tue, 2003-09-02 at 11:55, Shridhar Daithankar wrote:
>
> > That's fixed in 7.4. Vacuum in 7.4 prevents index bloat as well. Couple with
> > autovacuum daemon or scheduled vacuums, things (hopefully) will be lot better
> > than earlier days..
> Ar
Doug Quale wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
>
>>You can bet that RMS, control freak that he is, wouldn't have put that
>>disclaimer in there if he felt he had much chance of making the GPL
>>dynamic linking restriction enforceable.
>
> Name calling ("control freak") is childish.
Hello
You can try
select current_date + interval '1 month';
regards
Pavel Stehule
On Tue, 2 Sep 2003, Amin Schoeib wrote:
> Hi,
> I would like to know if there is a Function in Postgres
> Like the add_months Function in Oracle??
>
> Thanxx
>
> Schoeib
>
> 4Tek Gesellschaft für angewandte I
> These things are quite important when you have to convince your boss :-)
Convincing boss just say: "Caugh board or use postgresql".
Meaning of this is that you can't compare comercical or free ware.
Probably you want to use postgre because of its free, if this isn't case
why you won use oracle
On Sat, Aug 30, 2003 at 01:59:20PM +0200, Bo Lorentsen wrote:
> He likes to know about others using Postgres and simple replication (we
> need it in at 24/7 system), to know how postgres performs, and how
> stable it is regarding its data and the backup feature etc.
The replication system release
Title: ADD_Months Function in Postgres
Hi,
I would like to know if there is a Function in Postgres
Like the add_months Function in Oracle??
Thanxx
Schoeib
4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel. +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-
Bruce Momjian <[EMAIL PROTECTED]> writes:
> The FSF would _like_ dynamic linking to pass the GPL to the
> closed-source binary, but that doesn't make it so --- I would like a lot
> of things but wanting it to happen isn't enough.
>
> Their FAQ says (http://www.gnu.org/licenses/gpl-faq.html):
>
>
Lamar Owen wrote:
> Nitpik: that should be 24/7/52, since there aren't 365 weeks in a year.
Oh, great. It's just that 7*52 = 364. That leaves us with a full day to idle
and still honor the SLA, right?
Sorry, couldn't resist :)
cl.
---(end of broadcast)-
On Fri, 2003-08-29 at 17:21, Adam Kavan wrote:
> I decided to try pg_autovacuum and am having a problem.
FYI, I just downloaded beta2 and compiled it on RH9 and pg_autovacuum
works fine.
---(end of broadcast)---
TIP 3: if posting/reading through
On Tue, 2003-09-02 at 11:55, Shridhar Daithankar wrote:
> That's fixed in 7.4. Vacuum in 7.4 prevents index bloat as well. Couple with
> autovacuum daemon or scheduled vacuums, things (hopefully) will be lot better
> than earlier days..
Are there a list of things that will be done in 7.4, or bet
On 2 Sep 2003 at 14:08, [EMAIL PROTECTED] wrote:
> Hi, where can be fount Win32 versions of Postgress?
http://techdocs.postgresql.org/guides/Windows
See, if that helps you..
Bye
Shridhar
--
No problem is insoluble.-- Dr. Janet Wallace, "The Deadly Years",
stardate 3479.4
-
On 01/09/2003 20:10 Carmen Gloria Sepulveda Dedes wrote:
> > I'm working with ECPG.
> > Somebody know how can I establish multiple connections to the
database??
> > (I have used ENABLE THREADS and CONTEXT ALLOCATE in
> > oracle ... I'm looking for something similar to this ... if exists)
>
> H
Hi, where can be fount Win32 versions of Postgress?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Fri, 2003-08-29 at 17:21, Adam Kavan wrote:
> I decided to try pg_autovacuum and am having a problem. It never analyzes
> or vacuums. I looked at the code and had it display
>
> printf("%s,%s,%s\n",PQgetvalue(res, j, PQfnumber(res,
> "n_tup_ins")),PQgetvalue(res, j, PQfnumber(res,
> "n_tup
On 2 Sep 2003 at 11:49, Bo Lorentsen wrote:
> > 3) Index bloat is apparently a bigger problem than I thought.
> This does not sound too nice !
That's fixed in 7.4. Vacuum in 7.4 prevents index bloat as well. Couple with
autovacuum daemon or scheduled vacuums, things (hopefully) will be lot better
On Tue, 2003-09-02 at 04:08, Vivek Khera wrote:
> I use it in 24/7/365 system which is heavily written to and read
> from. The drawbacks I have are:
How depressing, may I ask that PG version you are using ?
> 1) upgrade to major versions require dump/restore which is a
>significant amount of
Just thought everyone might be interested to know that the
distributed.net project now uses postgresql for its stats tracking
system. They just migrated from Sysbase which they had been using for
several years. Check out:
http://n0cgi.distributed.net/cgi/dnet-finger.cgi?user=decibel
Matthew
--
"Claudio Lapidus" <[EMAIL PROTECTED]> writes:
> So? Is there a way to add the sequence to an existing table?
Sure. You have to break the SERIAL down to its component parts though.
Something like
CREATE SEQUENCE seq;
ALTER TABLE tab ADD COLUMN ser INTEGER;
UPDATE tab SET s
A trigger is the right way. Rules rewrite a statement whereas triggers are at
row level.
so in plpgsql:
create or replace function trig_param_ins_upd() returns trigger as '
begin
new.ts = current_timestamp;
return new;
end;' language 'plpgsql';
create trigger trig_param_ins_upd
On Monday 01 September 2003 22:08, Vivek Khera wrote:
> I use it in 24/7/365 system which is heavily written to and read
> from. The drawbacks I have are:
Nitpik: that should be 24/7/52, since there aren't 365 weeks in a year.
> 1) upgrade to major versions require dump/restore which is a
>s
> "BL" == Bo Lorentsen <[EMAIL PROTECTED]> writes:
BL> Hi ..
BL> He likes to know about others using Postgres and simple replication (we
BL> need it in at 24/7 system), to know how postgres performs, and how
BL> stable it is regarding its data and the backup feature etc.
I use it in 24/7/365
Hello
Now perhaps this is a bit dumb,
but...
I just populated a new table via \copy.
After that, I realize that perhaps is a good thing to have a row identifier in
it, so I try
clapidus=> alter table tickets add
column rid serial;NOTICE: ALTER TABLE will create implicit sequence
"tic
Hi to all ...
I'm looking to a way to auto update some fields of a row when other
fileds are updated.
the table structure are simple,
CREATE TABLE param (
id int4 PRIMARY KEY,
val int4,
ts timestam(3) DEFAULT CURRENT_TIMESTAMP
);
so when a new entry are insert ts areautomatically update,
but
On Tue, 02 Sep 2003 08:42:32 +0200
Christian Traber <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm really happy to see that pgadmin3 will run on Linux!
>
> I tried to build it on Gentoo but got errors.
> Was anybody of you able to build it for Gentoo or will there be an
> emerge file?
Can't help wi
58 matches
Mail list logo
