Re: [HACKERS] Rules and Views

2002-07-31 Thread Tom Lane
"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes: > Since I see a huge benefit in allowing conditional rules for a view, > I think it is worth finding a solution. We do allow conditional rules for a view. You just have to write an unconditional one too (which can be merely DO INSTEAD NOTHI

Re: [HACKERS] Query parser?

2002-07-31 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: > wow=# update \d dmoz > Table "dmoz" > Column | Type | Modifiers > +-+--- > id | integer | > name | text| > path | ltree | > Indexes: dmoz_id_idx unique btree (id), > dmoz_path_idx gist

Re: [HACKERS] WAL file location

2002-07-31 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > a.The system uses no environment variables at all; some other > method is used to determine where the config file is (maybe compiled > into the code); > If I understand it, nobody is really arguing for (a). I am. I see absolutely no advantage in

Re: [HACKERS] Rules and Views

2002-07-31 Thread Zeugswetter Andreas SB SD
> > Seems more accurate, but actually you may also have two or more > > conditional rules that cover all possibilities if taken together. > > Maybe > > ERROR: Cannot insert into a view > > You need an ON INSERT DO INSTEAD rule that matches your INSERT > > Which covers both cases. > > Ac

Re: [HACKERS] WAL file location

2002-07-31 Thread Thomas Lockhart
... > Is this a fair account? Yes. You may note that we have not explored the implementation details on any of these, so the attributes of each are not cast in stone (except for the purposes of argument of course ;) - Thomas ---(end of broadcast)-

Re: [HACKERS] Open 7.3 items

2002-07-31 Thread Jean-Michel POURE
Le Mercredi 31 Juillet 2002 05:50, Bruce Momjian a écrit : > Source Code Changes What about CREATE OR REPLACE VIEW which would be great for pgAdmin2. Thanks to all of you./Jean-Michel POURE ---(end of broadcast)--- TIP 5: Have you checked our exten

[HACKERS] Query parser?

2002-07-31 Thread Teodor Sigaev
wow=# update \d dmoz Table "dmoz" Column | Type | Modifiers +-+--- id | integer | name | text| path | ltree | Indexes: dmoz_id_idx unique btree (id), dmoz_path_idx gist ("path") wow-# wow-# ; ERROR: parser: parse error at or ne

Re: [HACKERS] WAL file location

2002-07-31 Thread Andrew Sullivan
On Wed, Jul 31, 2002 at 02:00:52AM -0400, Tom Lane wrote: > let alone how to configure it so that it works reliably. I really > fail to understand why you want to drive this new feature off environment > variables. You say you've "pointed out the utility and desirability" > of doing it that way,

Re: [HACKERS] Virus Emails

2002-07-31 Thread Vince Vielhaber
On Wed, 31 Jul 2002, Christopher Kings-Lynne wrote: > I would also like to know this! They don't mention it anywhere on their > site! The FreeBSD command line version comes on the CD along with the windoze versions. > > Chris > > > -Original Message- > > From: [EMAIL PROTECTED] > > [m

Re: [HACKERS] Outer join differences

2002-07-31 Thread Mario Weilguni
> > Here are the details. > > Those probably aren't the same outer join queries. I think you're right, these aren't the same, see below: > > > When I run the query "select yt1_name, yt1_descr, yt2_name, yt2_descr > > from yuva_test1 left outer join yuva_test2 on yt1_id=yt2_id and yt2_name > > =

Re: [HACKERS] [GENERAL] Stats Collector

2002-07-31 Thread Christopher Kings-Lynne
> Bruce Momjian <[EMAIL PROTECTED]> writes: > >> It all works now and I have just submitted it to -patches as a > new contrib, > >> but it probably should make its way into the backend one day. > > > OK, the big question is how do we want to make stats reset visible to > > users? The current patc

<    1   2