2(table1_id, newdata3);
IF table2_id > 0 THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
'
LANGUAGE plpgsql SECURITY DEFINER;
END===
Also, in my original schema I'm getting an increment of 2 every time I
run nextval. I can't dup
fail if the trigger fails? To me that defeats the
purpose of having a trigger after insert.
Thanks for any help
--
-
Stephen Howie
begin:vcard
fn:Stephen Howie
n:Howie;Stephen
email;internet:[EMAIL PROTECTED]
tel;work:260-760-5910
tel;fax:260-436-9472
tel;cell:260-704-6262
lly ) and should speed it up a
bit.
id also suggest grabbing more ram while its (relatively) inexpensive.
> [SNIP]
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"You do not have the right to free health care. That would be nice, but
from the looks of public housing, we're just not interested in health care."
RC_ROOT/contrib/lo/ that handles
automagic deletes of LO's if the corresponding oid is removed. the
release in 6.5.2 had a bug where it didnt check for NULL oids, though. i
havent taken the time to patch it and mail it back to the dev team.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"You do not have the right to free health care. That would be nice, but
from the looks of public housing, we're just not interested in health care."
bocat.de ) has a working EOAdaptor for MacOS X
Server, OPENSTEP/Mach, and OPENSTEP/NT. ive been using it for quite a few
internal projects under MacOS X Server. works great.
> [SNIP]
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"I've learned that you can
On Sun, 26 Dec 1999, Mike Mascari wrote:
> Howie wrote:
>
> > will this function/index problem be fixed in 7.x ?
> >
> > ircbot=> explain select * from logins where dttime = NOW();
> [SNIP]
> emptoris=> explain select * from sales where saledate = &#
LAN:
Index Scan using logins_dttime_idx on logins (cost=2.54 rows=11 width=52)
EXPLAIN
( logins actually has 755,728 rows right now )
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"I've learned that you cannot make someone love you.
All you can do is stalk them and hope they panic and give in."
that
Oracle does ), some additional grants ( 'grant connect to' ), 'alter table
add constraint '...
tablespace support would put pgsql s far ahead of most other rdbmses.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"I've learned tha
nd Subject: in a
table ( for queries ).
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"Tell a man that there are 400 billion stars and he'll believe you.
Tell him a bench has wet paint and he has to touch it."
r more moderately and
> accurately data mart) support also -- the point: the priority?
so either (A) work on implementing tablespaces or (B) donate some money to
postgresql, inc.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"Just think how much deeper the ocean would be if sponges didn't live there."
On Wed, 6 Oct 1999, Herouth Maoz wrote:
> At 01:10 +0200 on 06/10/1999, Howie wrote:
>
>
> > for now, refint ( $PGSQL_SRC_ROOT/contrib/spi/ ) is what one should be
> > using for foreign keys. requires two triggers, one on the parent and one
> > on the child. works
requires two triggers, one on the parent and one
on the child. works nicely.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"Just think how much deeper the ocean would be if sponges didn't live there."
ta in a
separate tablespace. might be something to look into once postgres
supports tablespaces. else your db dir/partition fills up _very_ quickly.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
ou could use GNUstep's ( http://www.gnustep.org ) database library (
aka Enterprise Objects Framework 1.x ), which provides an OO
wrapper for database independent stuff. you dont have to deal with SQL;
you deal with the objects.
quite nice. NeXT ( now Apple ) has been doing that for quite some
row was removed.
the one thing i miss is the ability to determine a lo's size (
hinthintnudgenudgewinkwink ).
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
u can use refint ( $PGSQL_SRC_ROOT/contrib/spi/refint.* ), which
handles referential integrity. check_primary_key() and
check_foreign_key() are the two functions involved. youd also need two
triggers, one per table.
i could've sworn this got added to the FAQ...
---
Howie <[EMAIL PROTEC
x27;s directory ( xinv* ). they're also still in the pg_type table.
shouldnt the oid's ( and their corresponding xinv* files ) have been
removed when i deleted the rows from the table? how does one remove these
large objects from both the pg_type table and the disk ( removing the
x
ys. two functions
are involved, check_foreign_key() and check_primary_key().
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
? With Oracle?
try it and find out :) id like to know, but dont have any MS-Windows
machines here.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
re that im using 6.5's initdb.
yes, ive made sure that initdb is looking in the 6.5 dir for its template.
yes, its writing to a 6.5 dir.
so, errr, what gives?
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
think.
> Should work fine when 6.5 is released.
i had figured the client was caching OIDs. _really_ looking forward to
6.5, keep up the great work!
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"Do a little dance, make a little code, compile tonight... compile tonight."
ppen again ?
thanks in advance.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"Do a little dance, make a little code, compile tonight... compile tonight."
atabases ( terabytes )
oracle has some nice tools available, as does postgres. the difference is
that postgres' tools are normally opensource/free whereas you pay,
sometimes pay big bucks, for oracle's.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
"Oh my god, they killed init! YOU BASTARDS!"
ioned before ), my
queries were sped up by roughly 10 seconds... odd odd odd.
---
Howie <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org
[[NSNotificationCenter defaultCenter] addObserver:systemAdministrator
selector:@selector(disableUserAccount:) name:@"UserIsWhining" object:aLuser];
24 matches
Mail list logo
