Re: [GENERAL] Possible bug (or I don't understand how foreign keys should work with partitions)

2007-06-30 Thread Masaru Sugawara
would work in this case and ran into this. > > > > Is this really a bug? If not, what am I doing wrong please? > > > > Best regards, > > Daniel Hello, I could make child tables inherit an external reference by the following queries. Actually, There appears to be re

Re: [GENERAL] Possible bug (or I don't understand how foreign keys should work with partitions)

2007-06-28 Thread Masaru Sugawara
FOREIGN KEY(rID) REFERENCES regs_00(rID) ON DELETE CASCADE) INHERITS(regsemail); By the way, why will you have such a huge number of e-mail addresses ? -- Masaru Sugawara > People, > > either I don't understand how p > People, > > either I don

Re: [GENERAL] Function Help

2001-09-28 Thread Masaru Sugawara
month ' LANGUAGE 'sql' ; ex. # select first_saturday('2001/9/28'::date); first_saturday 2001-09-01 # select first_saturday('2001/10/28'::date); first_saturday 2001-10-06 # select first_saturday('1999/9/28'::date); first_saturday 1999-09-04 # select first_saturday('2010/9/28'::date); first_saturday 2010-09-04 Regards. -- Masaru Sugawara [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org