Excellent, I got it working...Thanks ;)
Abdul-Wahid
On 5/9/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> > So how can I create a trigger to automatically update the hash fields
> > on updates and inserts?
>
> Something like the following works for me:
>
> create or replace function public.my_trig
Hi,
I have created a simple plpgsql function as follows as included below.
The function works fine but I need to have this done automatically on
updates and inserts. So I have a table
CREATE TABLE addresses (
address_id serial PRIMARY KEY,
companyvarchar(250),
fnamevarchar
Hi,
I have just upgraded my (thank God test) database server to Postgres to
8.0.1 from 7.4.7. I do a stand dump, shutdown, upgrade, restore
procedure.
On the server i have 5 databases. All of them work fine except one
where I can "select" fine but an not insert, update or delete!!!
I get errors
Hi,
I have been running a 2Gb database for about 3 months now on my AMD64
bit and have been very happy with the peformance and stability. I am
running it under Gentoo.
I don't have any particular benchmarks and only my own testing of our
company scripts. I have been very impressed with the perfor
Hi,
Is it possible, perhaps through some extension, to query two database
through one SQL select statement where the two databases have
different connections? Something similar to how you can link databases
in Oracle.
Regards,
Abdul-Wahid
---(end of broadcast)---
> You can add plpg-procedures , rules, trigger and/or views to
> hide this complicated data-model from the users.
>
>
>
>
>
> Abdul-Wahid Paterson wrote:
> Hi, I have the following table as a link table between my 'cats' table and
> my 'items&
Hi,
I have the following table as a link table between my 'cats' table and
my 'items' table. Every item must have at least one cat and exactly
one 'master' cat.
How can I create an integrity check to make sure that each item has
exactly one 'master' cat.
CREATE TABLE cats_items (
cat_id
I think the filesystem you choose depends what you are looking for.
Ext3 is by far the most tested and most stable out the file systems
available. It is basically just ext2 with journalling stuck on top
(and a few other niceities). XFS may well be faster but is perhaps not
so well tested or as stab
