[GENERAL] PG8 final when

2004-12-19 Thread Együd Csaba
Dear Developers, when do you plan to announce the final version of 8.0.0? As far as I can remember it was promised by 15. dec. No hurrying, just would like to know. I should install it on the site and thougt I wait for the final version. many thaks, -- Csaba --- Outgoing mail is certified Virus

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ciprian Popovici
On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Fri, Dec 17, 2004 at 11:10:12 -, > Filip Wuytack <[EMAIL PROTECTED]> wrote: > > Is it possible to have a sequence (as a multirow prim key), where > > sequence (id) only increase per group of data (grp). > > Wh

[GENERAL] A "cascade on delete" constraints deletes AFTER the source is gone??

2004-12-19 Thread Vitaly Belman
I noticed that when you do a constraint and tell it "cascade on delete", it will do so only AFTER that the source is deleted. Can I tell it somehow to cascade BEFORE the source is gone? -- ICQ: 1912453 AIM: VitalyB1984 MSN: [EMAIL PROTECTED] Yahoo!: VitalyBe ---(end

Re: [GENERAL] PG8 final when

2004-12-19 Thread Bruce Momjian
Együd Csaba wrote: > Dear Developers, > when do you plan to announce the final version of 8.0.0? As far as I can > remember it was promised by 15. dec. > No hurrying, just would like to know. I should install it on the site and > thougt I wait for the final version. My guess is 2-3 weeks from now

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ragnar Hafstað
On Sun, 2004-12-19 at 15:02 +0200, Ciprian Popovici wrote: > On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > On Fri, Dec 17, 2004 at 11:10:12 -, > > Filip Wuytack <[EMAIL PROTECTED]> wrote: > > > Is it possible to have a sequence (as a multirow prim key), whe

Re: [GENERAL] PG8 final when

2004-12-19 Thread Clodoaldo Pinto
--- Együd Csaba <[EMAIL PROTECTED]> escreveu: > Dear Developers, > when do you plan to announce the final version of 8.0.0? As far as I can > remember it was promised by 15. dec. Could you please point to where was it promised? Regards, Clodoaldo Pinto

Re: [GENERAL] Scheduler in Postgres

2004-12-19 Thread Bruno Wolff III
On Sat, Dec 18, 2004 at 15:00:17 -0600, "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > > In oracle, jobs are fired off by the database engine. If the database is > up and job support is enabled, your jobs will run. Without some kind of > support for the database to fire up connections and execute s

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Bruno Wolff III
On Sun, Dec 19, 2004 at 15:02:27 +0200, Ciprian Popovici <[EMAIL PROTECTED]> wrote: > On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > On Fri, Dec 17, 2004 at 11:10:12 -, > > Filip Wuytack <[EMAIL PROTECTED]> wrote: > > > Is it possible to have a sequence (a

Re: [GENERAL] A "cascade on delete" constraints deletes AFTER the source is gone??

2004-12-19 Thread Michael Fuhr
On Sun, Dec 19, 2004 at 03:20:19PM +0200, Vitaly Belman wrote: > I noticed that when you do a constraint and tell it "cascade on > delete", it will do so only AFTER that the source is deleted. Can I > tell it somehow to cascade BEFORE the source is gone? What problem are you trying to solve? --

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ciprian Popovici
On Sun, 19 Dec 2004 13:51:39 + Ragnar Hafstaà <[EMAIL PROTECTED]> wrote: > On Sun, 2004-12-19 at 15:02 +0200, Ciprian Popovici wrote: > > On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > > On Fri, Dec 17, 2004 at 11:10:12 -, > > > Filip Wuytack <[EMAIL PRO

Re: [GENERAL] Multi row sequence?

2004-12-19 Thread Ragnar Hafstað
On Sun, 2004-12-19 at 22:43 +0200, Ciprian Popovici wrote: > On Sun, 19 Dec 2004 13:51:39 + Ragnar Hafstað <[EMAIL PROTECTED]> wrote: > > On Sun, 2004-12-19 at 15:02 +0200, Ciprian Popovici wrote: > > > On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]> > wrote: > > > > On F

Re: [GENERAL] UNION with more restrictive DISTINCT

2004-12-19 Thread Vincent Hikida
Oops. That statement will "prefer" the t1.name instead of t2.name. It should be COALESCE(t2.name,t1.name) Another option is: SELECT t2.id , t2.name FROM t2 UNION SELECT t1.id , t1.name FROM t2 WHERE NOT EXISTS (SELECT NULL FROM t

Re: [GENERAL] Scheduler in Postgres

2004-12-19 Thread Jim C. Nasby
On Sat, Dec 18, 2004 at 10:22:44PM -0500, Tom Lane wrote: > Christopher Browne <[EMAIL PROTECTED]> writes: > > Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Jim C. Nasby") > > would write: > >> In PostgreSQL, there's currently no way to assume the identity of > >> another user. > >

[GENERAL] pgjob registered on pgFoundary

2004-12-19 Thread Jim C. Nasby
I've registered pgjob on pgFoundary. The idea for this is to periodically run SQL inside the database without the need for external utilities. Initially we'll probably have to settle for using some kind of external program to run this stuff, but eventually I'd like to see enough support in the back

Re: [GENERAL] A "cascade on delete" constraints deletes AFTER the source is gone??

2004-12-19 Thread Vitaly Belman
It's a bit complex. I have two tables. "Books" and "Book_Authors" (which links between book_id and author_id). Book_authors has a foreign key on book_id to the Books table. On key violation it is set to delete the rows (if a book is deleted, it should't be linked to any authors). In Book_Authors