IRC log of openacs on 2002-06-22

Timestamps are in UTC.

00:03:20 [denshi]

* denshi reads badgerblog

00:03:35 [denshi]

perhaps Hello Kitty should team up with Domo-kun

00:07:41 [markd2]

domo-kun has mouth to spare

00:12:24 [denshi]

indeed

00:49:05 [rbm]

paje: seen mbr

00:49:05 [paje]

mbr was last seen on #openacs 22 hours, 31 minutes and 7 seconds ago, saying: heads to bed [Thu Jun 20 21:17:56 2002]

00:49:11 [rbm]

paje: seen Wookiephylax

00:49:11 [paje]

Wookiephylax was last seen on #openacs 7 days, 8 hours, 48 minutes and 11 seconds ago, saying: Do they have some sort of a graphical tool for this? [Fri Jun 14 11:00:57 2002]

00:54:33 [talli]

i think BadgerTronics is in for a challenge

00:54:35 [talli]

http://sfgate.com/cgi-bin/article.cgi?f=/chronicle/a/2002/06/21/BA55331.DTL

00:54:35 [oacs-chump]

A: http://sfgate.com/cgi-bin/article.cgi?f=/chronicle/a/2002/06/21/BA55331.DTL from talli

00:54:48 [talli]

A: Voracious goats heroes in the hills

00:54:48 [oacs-chump]

added comment A1

00:54:50 [talli]

Herd clears tinder from Hetchy pipeline path

00:55:57 [denshi]

that sounds like a real challenge

00:56:03 [talli]

http://sfgate.com/cgi-bin/object.cgi?object=/chronicle/pictures/2002/06/21/ba_goats1.jpg&paper=chronicle&file=BA55331.DTL&directory=/chronicle/a/2002/06/21&type=news

00:56:03 [oacs-chump]

B: http://sfgate.com/cgi-bin/object.cgi?object=/chronicle/pictures/2002/06/21/ba_goats1.jpg&paper=chronicle&file=BA55331.DTL&directory=/chronicle/a/2002/06/21&type=news from talli

00:56:16 [talli]

B: BadgerTronic's nemesis

00:56:16 [oacs-chump]

added comment B1

00:56:17 [markd2]

http://www.evula.com/rants/misc/rico1.html

00:56:17 [oacs-chump]

C: http://www.evula.com/rants/misc/rico1.html from markd2

00:56:25 [markd2]

Talli's evil influence spreads

00:57:13 [talli]

the man speaks The Word

00:57:48 [talli]

B: notice the fellow in the upper left corner

00:57:48 [oacs-chump]

added comment B2

00:58:54 [denshi]

who is that rico character?

01:02:00 [talli]

that's a good dog-cat diary

01:02:14 [talli]

i heard another explanation for the difference between cats and dogs

01:02:33 [talli]

a dog says, "The human is feeding me. He must be God"

01:02:43 [talli]

a cat says, "The human is feeding me. I must be God."

01:02:50 [denshi]

* denshi feeds talli

01:03:05 [talli]

* talli must be God

01:07:16 [markd2]

therefore, denshi must be talli

01:07:22 [markd2]

* markd2 senses a conspiracy

01:07:45 [talli]

uhm, markd2, shouldn't you be making sure that your badgers aren't being beaten by goats?

01:07:53 [talli]

do you really have so much time to be playing on IRC?

01:08:00 [markd2]

my badgers can fend for themselves

01:08:05 [markd2]

I trust them to do What Is Righteous

01:08:07 [talli]

i mean, how will BadgerTronics shareholders respond?

01:08:13 [denshi]

nevermind my alter-ego, he doesn't understand the badger-goat relationship

01:08:19 [markd2]

with Righteous wRaTh

01:09:08 [talli]

denshi: do you think that Larry Wall is smaht?

01:09:19 [talli]

as in, wicked smaht

01:10:06 [denshi]

i dunno. I'm not from Boston

01:11:08 [talli]

seriously. is he a major intellect in the code world?

01:11:27 [talli]

i understand he's a complete freak

01:11:34 [denshi]

depends on how you define the code world

01:11:58 [talli]

and since i grew up in Los Altos, which is next to Mountain View, and I'm familiar with some of the people in his congregation, i know he's a banana

01:12:14 [denshi]

in terms of language research, no, he's not clearing any new ground

01:12:35 [denshi]

the stuff he's done has mostly been social hacks

01:12:42 [denshi]

that's not entirely true

01:12:55 [denshi]

he does neat things in inference

01:13:49 [denshi]

but to take Perl as an example, Perl isn't amazing technologically; but rather the complete package really raised the bar in terms of production languages

01:14:05 [talli]

ah, ok

01:14:11 [talli]

so he's an outstanding engineer

01:14:40 [denshi]

the complete package being a high-quality OSS implementation, huge libraries, active community, huge docs, etc, etc, etc

01:14:58 [denshi]

what brings this up?

01:15:21 [davb]

davb (dave@alb-24-58-162-82.nycap.rr.com) has joined #openacs

01:15:40 [denshi]

paje, gnaw on davb!

01:15:40 [paje]

denshi: huh?

01:15:45 [davb]

hi denshi

01:15:47 [denshi]

knaw?

01:16:32 [talli]

hey davb

01:16:36 [talli]

denshi: just wondering

01:16:47 [davb]

hi talli

01:16:49 [talli]

i played with CPAN last night for the first time. it was very impressive

01:17:01 [denshi]

ah. wondering to do the same with APMs?

01:18:18 [davb]

hey!

01:18:27 [markd2]

markd2 has quit ("bork")

01:18:28 [davb]

arjun is working on something similar to my idae

01:18:30 [davb]

idea

01:18:37 [jim]

oh, I got something called table

01:18:58 [davb]

that is pretty cool.

01:19:04 [jim]

it's a cool little single-page thing that probably shouldn't be left on a site :)

01:19:27 [talli]

denshi: yeah, i was thinking that apm's really should have dependency checking in them

01:19:34 [jim]

by default it shows you acs_objects

01:19:44 [denshi]

talli: I thought they already did?

01:19:56 [talli]

actually, yes, they do

01:20:10 [talli]

but they should download and install those dependencies if they do not exist

01:20:34 [davb]

hey. cool forums are ported.

01:20:45 [davb]

i'll have to try it.

01:20:52 [jim]

to pg?

01:20:56 [davb]

except we will need the devel branch

01:20:59 [davb]

jim: yes

01:27:30 [davb]

there is some good info in the attachments package proposal.

01:27:55 [davb]

it is a service, a singlton that is mounted at many URLs.

01:28:08 [davb]

that is a neat concept that I never thought of.

01:36:04 [davb]

cool: there is a debian package for celestia.

01:36:22 [davb]

i am not sure its the same thing. it wants to install alot of stuf

01:40:36 [vinod]

davb: the celestia deb is the same thing

01:40:44 [davb]

cool!

01:40:51 [vinod]

i installed it from source first :-) and then saw the package

01:45:13 [davb]

hmm

01:45:19 [davb]

this is pretty cool

01:45:25 [davb]

ok back to work.

01:46:16 [vinod]

whatcha working on?

01:46:25 [davb]

hmm. mostly etp 2.0

01:46:36 [davb]

but I am thinking about a super related-items package

01:47:03 [vinod]

cool. i saw you talking about that earlier

01:47:19 [vinod]

it's still above my head. i need to read about service contracts some more

01:47:22 [davb]

right now, various packages use mapping tables to relate certain types of objects to other certain types.

01:47:44 [davb]

i have no idae how the service contract will work :) just that it will allow packages to talk to each other :)

01:48:08 [vinod]

ahhh - gotcha

01:48:18 [davb]

if anyone sees k2pts grab him. I want to ask him about the search package.

01:48:23 [davb]

:)

01:54:28 [davb]

hmmm.

02:18:38 [davb]

cool.

02:18:38 [talli]

talli has quit (Read error: 104 (Connection reset by peer))

02:19:28 [talli]

talli (~chatzilla@pool-162-83-235-174.ny5030.east.verizon.net) has joined #openacs

02:28:43 [davb]

I am curious why people who put up a web site that they did not want people to link to.

02:29:00 [davb]

that kinda defeats the whole "web" idea.

02:36:31 [talli]

talli has quit ("ChatZilla 0.8.7 [Mozilla rv:1.0.0/20020616]")

02:37:13 [talli]

talli (~chatzilla@pool-162-83-235-174.ny5030.east.verizon.net) has joined #openacs

02:37:50 [davb]

good night

02:38:25 [davb]

davb is now known as davb-sleep

02:38:28 [davb-sleep]

davb-sleep is now known as davb

03:32:01 [talli]

talli has quit ("ChatZilla 0.8.7 [Mozilla rv:1.0.0/20020616]")

03:34:10 [talli]

talli (~chatzilla@162.83.235.174) has joined #openacs

04:03:22 [vinod_]

vinod_ (~vinod@66-108-0-75.nyc.rr.com) has joined #openacs

04:19:45 [vinod]

vinod has quit (Read error: 110 (Connection timed out))

04:36:13 [vinod_]

vinod_ has quit (Read error: 110 (Connection timed out))

07:20:57 [jim]

jim has quit (Remote closed the connection)

11:00:35 [vinod_]

vinod_ (~vinod@66-108-0-75.nyc.rr.com) has joined #openacs

11:34:20 [davb]

wow!

11:34:21 [davb]

good stuff

11:34:23 [davb]

http://www.treedragon.com/ged/map/ti/newJun02.htm#21jun02-food-chain

11:34:24 [oacs-chump]

D: http://www.treedragon.com/ged/map/ti/newJun02.htm#21jun02-food-chain from davb

11:35:04 [davb]

D:|Food Chain

11:35:04 [oacs-chump]

titled item D

11:35:21 [davb]

D: McCusker respond to Levien on software food chains

11:35:21 [oacs-chump]

added comment D1

11:36:00 [davb]

very good stuff!

11:36:11 [davb]

and long. I must return to read it

11:46:38 [davb]

D: [http://www.advogato.org/person/raph/diary.html?start=219|the original]

11:46:38 [oacs-chump]

added comment D2

11:49:39 [davb]

D: don't miss the interesting langauge stuff at the end of the second link

11:49:40 [oacs-chump]

added comment D3

12:11:30 [davb]

talli: i emailed luke about the related items stuff.

12:11:53 [davb]

i will try to write it up nicely for the bboards soon.

12:28:44 [talli]

talli has quit (Read error: 113 (No route to host))

13:11:19 [talli]

talli (~chatzilla@pool-162-83-238-204.ny5030.east.verizon.net) has joined #openacs

13:57:53 [talli]

hey guys

14:05:53 [markd2]

markd2 (~markd2@h166-102-041-011.ip.alltel.net) has joined #openacs

14:29:18 [markd2]

moo

14:29:44 [talli]

badgers moo?

14:29:53 [talli]

that can't be right

14:30:18 [markd2]

depends on the accent

14:30:40 [talli]

are you a quebecois badger?

14:30:57 [markd2]

more of the european variety

14:31:01 [talli]

those are the most sophisticated i hear

14:31:03 [markd2]

I guess I should have said "möö"

14:32:15 [markd2]

móò

14:32:19 [markd2]

mòó

14:32:45 [talli]

that's a good one

14:57:37 [lilo]

[GlobalNotice] Hi all. I have a website up at http://lilo.sargasso.net/ explaining my current situation. I'm asking for help on a personal basis to keep working as OPN head of staff and to finish setting up the nonprofit corp. Please take a look, and thanks.

14:57:39 [talli]

talli has quit (Read error: 104 (Connection reset by peer))

14:57:52 [denshi]

moo

15:10:56 [davb]

hi

15:20:02 [denshi]

moo, davb

15:20:42 [davb]

talli: this is kinda interesting, vCal related: http://www.theshiftedlibrarian.com/2002/06/21.html#a2473

15:21:31 [davb]

and this: http://dijest.com/aka/2002/06/17.html#a1402

15:21:58 [davb]

denshi: i found this interesting, at least partially langauge related

15:22:02 [davb]

D:

15:22:02 [oacs-chump]

http://www.treedragon.com/ged/map/ti/newJun02.htm#21jun02-food-chain

15:22:03 [oacs-chump]

Food Chain

15:22:04 [oacs-chump]

(1:davb) McCusker respond to Levien on software food chains

15:22:05 [oacs-chump]

(2:davb) [http://www.advogato.org/person/raph/diary.html?start=219|the original]

15:22:06 [oacs-chump]

(3:davb) don't miss the interesting langauge stuff at the end of the second link

15:26:00 [rbm]

ooom

15:28:38 [davb]

hiya rbm

15:28:52 [rbm]

wazzuuuuuup!

15:29:08 [davb]

:)

15:51:25 [davb]

* davb rewrites the triggers in search

15:54:08 [rbm]

* rbm works on the paypal service contract

15:54:17 [markd2]

* markd2 goofs off

15:56:17 [davb]

hmmm. how ot test the triggers?

15:57:41 [rbm]

do something that will fire them

15:57:46 [davb]

yeah :)

15:57:59 [davb]

i did, and I got an error, so I know the trigger is firing :)

15:58:12 [rbm]

* rbm needs some music, but since his computer is now is his bedroom and his wife is asleep, he can't listen to any :(

15:58:17 [rbm]

and I was feeling like some Mozart

15:58:24 [rbm]

s/was/am/

15:58:25 [davb]

am i allowed to do this?

15:58:30 [davb]

declare v_live_revisioncr_items.live_revision%TYPE;

15:58:42 [rbm]

on your trigger?

15:58:49 [davb]

well in a pl/pgsql function.

15:58:52 [rbm]

yeah

15:59:00 [davb]

ok...

15:59:30 [rbm]

PG 7.2 lets you do that in the function header too.

15:59:42 [davb]

that is cool.

15:59:49 [davb]

i knew somewhere i was not allowed.

16:00:04 [davb]

do i need an AS?

16:00:25 [davb]

no i don't...

16:00:25 [rbm]

Where?

16:01:42 [davb]

in the declare statement.

16:01:50 [rbm]

I got spam from romania from someone looking for a job

16:02:05 [davb]

wow, mine are usually all from the US.

16:02:34 [davb]

my code looks like this:

16:02:35 [davb]

declare v_live_revisioncr_items.live_revision%TYPE;

16:02:43 [davb]

and the error message like this:

16:02:54 [davb]

NOTICE: plpgsql: ERROR during compile of content_search__utrg near line 1

16:02:54 [oacs-chump]

Label NOTICE not found.

16:02:54 [davb]

ERROR: parse error at or near "v_live_revisioncr_items.live_revision%TYPE"

16:02:55 [oacs-chump]

Label ERROR not found.

16:04:19 [rbm]

hmmm

16:04:21 [rbm]

hang on

16:05:19 [denshi]

Romania: we a happy country. We got the bomb, muthaf&*$#! We put the 'mania' back in 'Romania'

16:07:22 [rbm]

davb: maybe you need a new line after declare?

16:07:26 [denshi]

rbm: did you spam look like any of the above?

16:07:31 [davb]

ah

16:07:50 [rbm]

davb: I've used the "foo table.column%TYPE;" construct many times. It's used in the acs-kernel a lot

16:07:55 [davb]

right.

16:08:17 [rbm]

denshi: no. It's saying that he's a display engineer with lots of experience looking for a job

16:08:32 [denshi]

see if he can put the 'mania' back in anything

16:10:22 [davb]

there is a shortage of mania in austin?

16:10:32 [denshi]

yes

16:13:19 [denshi]

jobs, too

16:13:54 [rbm]

jobs too?

16:14:04 [denshi]

jobs == mania

16:14:15 [denshi]

thus there is a job shortage

16:14:20 [rbm]

texas slang?

16:15:00 [denshi]

I don't believe so

16:15:45 [rbm]

FYI, bug-tracker is nice.

16:18:59 [davb]

yes. it is very cool.

16:20:01 [davb]

heh, now the error is on line 2 instead of line one.

16:23:16 [rbm]

Holy crap... Turkey is in the semifinals and will face Brazil, again

16:23:35 [rbm]

And Korea defeated Spain. WOW!

16:23:58 [rbm]

I watched about 20 mins of the Korea vs Spain game last night. Korea deserved to win IMHO

16:25:05 [rbm]

So on the semifinals we'll have Brazil vs Turkey and Germany vs Korea. 1 nation from the Americas, 2 from Europe and 1 from Asia.

16:34:36 [davb]

can i do foo := SELECT bar from blargh in pl/pgsql?

16:36:15 [davb]

ah.

16:36:17 [davb]

no errors.

16:36:27 [rbm]

davb: AFAIK no you can't.

16:36:47 [rbm]

You'd have to do SELECT INTO foo bar FROM blargh;

16:39:25 [davb]

ok.

16:42:11 [markd2]

markd2 has quit ("Bork")

16:48:03 [talli]

talli (~chatzilla@pool-162-83-238-204.ny5030.east.verizon.net) has joined #openacs

16:55:37 [vinod_]

vinod_ has quit ("changing universes")

16:59:25 [lilo]

[GlobalNotice] Hi everybody. I've started sending two messages a day for fund raising, asking people to help so I can keep at this. I'm skipping the second message today and replacing it with something that I hope will be helpful.

17:00:07 [lilo]

[GlobalNotice] If you have an opinion on the network, and my role in it, now is definitely the time to participate.

17:00:58 [lilo]

[GlobalNotice] If you want the opportunity to tell me directly what you think about me, please come to #question. I can't listen to everybody on channel or on message, but I definitely need to hear from you.

17:01:19 [lilo]

[GlobalNotice] So I'll tell you how you can talk to me about it, and I hope it won't be too hard or take too much time.

17:01:51 [lilo]

[GlobalNotice] If you use the network, this is *definitely* a time to make your presence known. It will mean a lot. Please come to #question. Thanks.

17:02:34 [davb]

hmmm.

17:03:31 [lilo]

[GlobalNotice] Again, I hate to stress this, but I am *really* going to need your opinion, good, bad or indifferent. Please come to #question. Thanks.

17:04:45 [talli]

hey davb

17:06:14 [davb]

hi talli

17:09:23 [lilo]

[GlobalNotice] Okay, one last time, and then I'll get started. When people express the opinion that "everybody says that x", the only way I will know if it's true is if *you* are part of the everybody who makes your voice heard. Please come to #question. Thanks.

17:13:06 [rbm]

talli: bug-tracker is really nice

17:17:47 [davb]

cool. my trigger does NOT insert revisions if they are not live.

17:17:58 [davb]

now to see if it does insert them when they are :)

17:25:18 [davb]

do i use if new.live_revision IS NOT NULL to check the not nulless?

17:28:50 [davb]

yeah.

17:28:59 [rbm]

yeah

17:31:55 [davb]

cool thanks

17:38:19 [rbm]

* rbm sends $10 to lilo

17:40:52 [talli]

rbm: thanks

17:41:12 [talli]

of you have any bugs or suggestions, there's a bugtracker for bugtracker at clients.museatech.net

17:41:28 [talli]

it should move to the oacs site ASAP, though, but that can't be for a while, i guess

17:41:55 [talli]

what's the IP for the new openacs instance you set up on openacs.org?

17:42:03 [rbm]

paje: openacs.org-dev?

17:42:03 [paje]

i heard openacs.org-dev was 208.184.248.90

17:42:06 [talli]

* talli remembers to announce linuxworld

17:42:11 [talli]

thanks

17:42:19 [rbm]

talli: Reserve a seat for me at that booth!

17:42:30 [talli]

good

17:42:37 [talli]

you'll have to help staff it :)

17:42:54 [rbm]

* rbm goes to eat lunch

17:43:14 [denshi]

when is linuxworld?

17:43:26 [talli]

rbm: before you go...

17:43:31 [talli]

can i get admin privs on the new site?

17:43:46 [talli]

denshi: linuxworld is Aug 13-15 in SF

17:43:51 [davb]

talli: i can

17:43:57 [davb]

do it

17:43:57 [talli]

davb: thanks

17:44:48 [rbm]

talli: sure, let me do that

17:45:36 [davb]

too late :)

17:45:41 [davb]

i added don also.

17:46:06 [rbm]

talli: looks like you... yeah, what davb said :)

17:46:15 [davb]

ok, i am almost done editing the search so that i will only grab live revisions. I wish I could remember what neophtytos said about that...

17:46:34 [talli]

are we goign to use the new forums in the dev brancj?

17:46:36 [talli]

branch

17:46:57 [davb]

btw, bugtracker works great on the stable code.

17:47:08 [rbm]

talli: Ben said they're working on the PG port

17:47:16 [rbm]

I haven't checked if it's usable on PG yes

17:47:24 [rbm]

s/yes/yet/

17:59:19 [talli]

i thought that Yon posted that forums have been ported and are in CVS?

17:59:30 [talli]

lars does great work

18:00:59 [davb]

Luke says my related item idea is already implemented as part of the CR.

18:01:02 [talli]

i'm looking forward to Linux World

18:01:07 [talli]

davb: very cool!

18:01:16 [talli]

so it just needs a UI?

18:01:20 [davb]

yes.

18:01:24 [davb]

the cr has all kinds of neat stuff.

18:01:34 [davb]

but really crappy docs. it never says how to _use_ it.

18:01:41 [talli]

yeah

18:01:51 [talli]

it helps to have someone like Luke who knows what's in there

18:02:13 [davb]

well yeah, but its trapped in his brain.

18:02:17 [davb]

:)

18:02:34 [talli]

that's true

18:02:47 [talli]

did he say how hard it would be to implement the UI or the functioanlity?

18:03:03 [davb]

no, just it shouldn't be too hard.

18:03:18 [davb]

s/just/but

18:03:34 [talli]

did you guys mount a bugtracker on openacs.org-dev yet?

18:04:13 [davb]

yes

18:04:39 [davb]

http://208.184.248.90/bugtracker/openacs.org/

18:04:39 [oacs-chump]

E: http://208.184.248.90/bugtracker/openacs.org/ from davb

18:06:01 [talli]

ah, ok

18:06:09 [talli]

it doesn't show up on the home page

18:06:18 [davb]

i know, its in a folder.

18:06:54 [talli]

you should give it a name

18:07:21 [davb]

right, i'll have to rename the package instance

18:09:53 [davb]

darn, i can't run psql on the server.

18:10:06 [davb]

someone wrote an interface for that.

18:16:34 [davb]

ok i patched and I will commit the changes

18:20:33 [davb]

weird.

18:20:39 [davb]

this patch is to CMS

18:20:43 [davb]

who uses that?

18:20:57 [davb]

actually the patch is going to the wrong place.

18:21:28 [davb]

nm i am dumb

18:26:04 [davb]

uhoh

18:26:06 [davb]

cvs server: failed to create lock directory for `/cvsroot/openacs-4-5.org/packages/bug-tracker' (/cvsroot/openacs-4-5.org/packages/bug-tracker/#cvs.lock): Permission denied

18:26:06 [davb]

cvs server: failed to obtain dir lock in repository `/cvsroot/openacs-4-5.org/packages/bug-tracker'

18:26:06 [davb]

cvs [server aborted]: read lock failed - giving up

18:27:05 [davb]

yep.

18:41:39 [denshi]

denshi has quit (Remote closed the connection)

18:44:20 [davb]

talli: i will fix the bugtracker name later.

18:45:27 [davb]

ah, never mind.

18:45:42 [davb]

i _can_ rename it from the bugtracker interface. duh

18:49:08 [markd2]

markd2 (~markd2@h166-102-041-051.ip.alltel.net) has joined #openacs

18:50:18 [davb]

hmmm, can i have a nested if in pl/pgsql?

18:51:37 [markd2]

an if inside of another if?

18:51:52 [markd2]

(well, if inside of the block controlled by an if)

18:52:05 [davb]

yes.

18:52:28 [davb]

like this:

18:52:30 [davb]

if old.live_revision <> new.live_revision then

18:52:30 [davb]

if new.live_revision is Not Null then

18:53:14 [markd2]

yeah, I'd imagine that would work

18:53:30 [markd2]

the elses might be ambiguous if the blocks don't have begin/end around

18:56:20 [talli]

davb: my issue is that the application isn't named on the site map

18:56:40 [talli]

is that why it's not available on the home page?

18:59:02 [davb]

is it on the site map :)

18:59:16 [davb]

click the little plus next to the bugtracker

19:01:49 [denshi]

denshi (~chatzilla@cs6625161-163.austin.rr.com) has joined #openacs

19:02:09 [markd2]

bork!

19:02:22 [denshi]

mmmmmbork!

19:02:54 [davb]

the code that grabs the installed packages for the default home page must not look in the folders.

19:23:28 [rbm]

davb: oops

19:27:51 [rbm]

davb: try now

19:27:54 [rbm]

paje: seen davb

19:27:54 [paje]

davb was last seen on #openacs 25 minutes and 0 seconds ago, saying: the code that grabs the installed packages for the default home page must not look in the folders. [Sat Jun 22 14:02:49 2002]

19:31:05 [denshi]

paje: seen the light?

19:31:05 [paje]

I haven't seen 'the', denshi

19:34:00 [davb]

ok

19:34:58 [davb]

hhm, still have read lock problem for bugtracker.

19:36:03 [rbm]

you do? for cvs?

19:36:07 [davb]

yes.

19:36:10 [davb]

maybe its me :)

19:36:21 [davb]

failed to create lock directory for `/cvsroot/openacs-4-5.org/packages/bug-tracker' (/cvsroot/openacs-4-5.org/packages/bug-tracker/#cvs.lock): Permission denied

19:36:25 [rbm]

are you on the cvs group?

19:36:31 [rbm]

OH! Crap, hang on.

19:37:34 [rbm]

one more try

19:37:52 [rbm]

nevermind

19:38:20 [rbm]

Now you can try.

19:38:31 [rbm]

I think I covered everything now

19:38:52 [davb]

much better.

19:39:43 [davb]

I still need more karma to commit.

19:40:40 [markd2]

davb++

19:40:41 [markd2]

davb++

19:40:42 [markd2]

davb++

19:40:43 [markd2]

karma davb?

19:40:43 [paje]

davb has karma of 4

19:40:46 [markd2]

does that help?

19:41:58 [rbm]

davb: Hmmm, I gave you full privs for that repository

19:42:38 [rbm]

davb: GO ahead. I had made a typo on the avail file

19:43:27 [rbm]

davb: sorry about this.

19:43:38 [davb]

yeah!

19:43:42 [davb]

no problem.

19:43:45 [rbm]

paje: you should take only one karma per user

19:43:45 [paje]

rbm: huh?

19:44:14 [davb]

rbm: do you know about nested ifs in pl/pgsql?

19:48:27 [rbm]

what about it

19:48:36 [rbm]

Just END IF properly

19:48:38 [davb]

should it work?

19:48:43 [rbm]

yeah, no problem

19:49:11 [davb]

i have if then if then else end if end if

19:49:36 [rbm]

just paste the block here

19:49:57 [davb]

ok.

19:50:04 [davb]

begin

19:50:04 [davb]

if old.live_revision <> new.live_revision then

19:50:04 [davb]

if new.live_revision is Not Null then

19:50:04 [davb]

insert into search_observer_queue (

19:50:04 [davb]

object_id,

19:50:05 [davb]

event

19:50:07 [davb]

) values (

19:50:09 [davb]

new.live_revision,

19:50:11 [davb]

''UPDATE''

19:50:13 [davb]

);

19:50:15 [davb]

else

19:50:19 [davb]

perform search_observer__enqueue(old.revision_id,''DELETE'');

19:50:21 [davb]

end if;

19:50:23 [davb]

end if;

19:50:25 [davb]

return new;

19:50:27 [davb]

end;' language 'plpgsql';

19:50:38 [davb]

i am getting a parse error at the second if according to the error message.

19:50:45 [davb]

second end if that is.

19:53:37 [davb]

thanks alot BTW :)

19:54:23 [rbm]

That's all of the function?

19:56:23 [rbm]

I sure hope this is indented better in your sources

19:57:36 [rbm]

davb: You could get rid of the second IF by doing:

19:57:59 [rbm]

IF old.live_revision <> new.live_revision AND new.live_revision IS NOT NULL THEN

19:58:21 [rbm]

Nested IFs should work though, but it's less efficient

20:01:34 [davb]

ok cool.

20:05:08 [davb]

yeah, it works

20:05:09 [davb]

thanks

20:05:52 [rbm]

np

20:11:04 [davb]

oops, wait, it doesn't quite work.

20:17:17 [davb]

hmm. i need to rewrite this.

20:17:47 [davb]

I need to add an item is the id is changed and it is not null and i need to delete an item if the new id is null and the old id is not null

20:20:17 [rbm]

davb: can you rephrase? I'm having trouble parsing that

20:20:36 [rbm]

oh, _if_ the id is changed

20:20:59 [davb]

yeah, i just need to think about it.

20:21:13 [davb]

also it seems the and logic is wrong the way i wrote it, it only deletes :)

20:21:55 [rbm]

davb: I think I may have missed some parenthesis there

20:22:23 [rbm]

Maybe: IF (old.live_revision <> new.live_revision) AND (new.live_revision IS NOT NULL) THEN

20:22:32 [rbm]

I can't remember if that works though.

20:24:11 [rbm]

* rbm chugs away on devfs

20:39:05 [markd2]

markd2 has quit ("Bork")

20:51:52 [davb]

thanks rbm. i'll try it.

20:52:04 [davb]

after i go to the drive-in movies (tomorrow) :)

20:55:04 [rbm]

(:

23:47:10 [denshi]

ooom

23:48:41 [talli]

talli has quit (Remote closed the connection)

23:50:21 [talli]

talli (~chatzilla@pool-162-83-238-204.ny5030.east.verizon.net) has joined #openacs