SEO

#1 (**permalink**) 04-18-2008, 08:47 AM

Hi,
I just built b4 (fine!), but looking at the program itself, I don't
see rules anywhere else than in the preferences. In b3 I think I
could create new rules, but in b4 I am missing them. Is it just me?

!
! Jyrki Wahlstedt
! http://www.wahlstedt.fi/jyrki/
!
! Our life is no dream; but it ought to become one and perhaps will.
! PGP key ID: 0x139CC386 fingerprint: F355 B46F 026C B8C1 89C0 A780
6366 EFD9 139C C386

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#2 (**permalink**) 04-18-2008, 08:47 AM

Jyrki Wahlstedt wrote:
> Hi,
> I just built b4 (fine!), but looking at the program itself, I don't see
> rules anywhere else than in the preferences. In b3 I think I could
> create new rules, but in b4 I am missing them. Is it just me?

I assume you have them turned on in Preferences? And you do recall that
they appear under Tables not Schemas?

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#3 (**permalink**) 04-18-2008, 08:47 AM

On 5.9.2007, at 14.46, Dave Page wrote:

> Jyrki Wahlstedt wrote:
>> Hi,
>> I just built b4 (fine!), but looking at the program itself, I
>> don't see
>> rules anywhere else than in the preferences. In b3 I think I could
>> create new rules, but in b4 I am missing them. Is it just me?
>
> I assume you have them turned on in Preferences? And you do recall
> that
> they appear under Tables not Schemas?
>
> Regards, Dave
>
>
Oh, yes,
I did not dig deep enough, they are shown for individual tables under
the table (the hierarchy is quite deep)! Sorry for the trouble. I
could quote a character in one of my favourite movies: "Patience is a
virtue, I wish I had more of it…"

!
! Jyrki Wahlstedt
! http://www.wahlstedt.fi/jyrki/
!
! Our life is no dream; but it ought to become one and perhaps will.
! PGP key ID: 0x139CC386 fingerprint: F355 B46F 026C B8C1 89C0 A780
6366 EFD9 139C C386

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

I am missing rules