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?
If not, what is the alternate way to do this?
Thx. In advance.
Anagha
Info contains the details like time of insertion of a row and data in
that row.
I think this sufficely explains what I want.
-Anagha
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:00 PM
To: Anagha Joshi
Cc: [EMAIL PROTECTED]
Subject:
CTED]
Sent: Thursday, June 19, 2003 7:26 PM
To: Anagha Joshi; [EMAIL PROTECTED]
Subject: Re: [ADMIN] Latest transcation
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 18 June 2003 22:16, Anagha Joshi wrote:
> Is there any way to know programatically which is the latest
> insert/
Title: Urgent Help : Use of return from function/procedure.
Hi,
I'm new to postgres and using version 7.2.4
I've created a trigger and function which does the following:
trigger 'T' fires after insert on a spcific table takes place and it executes function 'F'
Function 'F' retur
Title: database & table size
Hello ,
Here is something I’ve found related to database & table size
My databse name is ’test’ and table name is ‘cdrrec’.
1. Following will give oids & database
test=# select datname, oid from pg_database;
datname | oid
-+-
Title: Object based Query Requirement.
Hi,
I use Postgres-7.2.4. and my client is in C++
I need to know the following:
As I user libpq++ library, I have to pass the query in the string format only. i.e.’const char *’
Does Postgres support object based query? i.e. User should make the obj
Title: Seqno. is not btree?
Hi,
I use Postgresql-7.2.4
I’ve created following table:
create table vchar (
seqno SERIAL,
col_var character varying (8192)
);
After as many as 2412081 records are inserted, I shutdown my server. My every record was inserted programatically by
Hi All,
Im using PG-7.2.4 on Solaries.
When I do:
template1=# select time(6576);
ERROR: TIME(6576) precision must be between 0 and 13
Where am I wrong?
Pls. help
Thanks,
Anagha
Hi,
Ive observed this:
Here is output from PostgreSQL 7.1.2:
trapdb=# select cast(datetime(1057637700) as timestamp);
?column?
---
2003-07-08 09:45:00+05:30
(1 row)
Here is output from PostgreSQL 7.2.4:
trapdb=# select cast(datetime
Hi all,
I’m using PG – 7.2.4 on Solaries.
I’m using “libpq++”
library as client implementation is coded in “C++”.
I’m doing the following :
Making
the connection to database by creating new object of “PgDatabase”
i.e.
data = new PgDatabase( “ CONNECTION INFO “);
T
10 matches
Mail list logo
