Re: [HACKERS] CreateFunctionStmt struct

2004-12-23 Thread Alvaro Herrera
On Thu, Dec 23, 2004 at 11:57:09AM -0800, Sibtay Abbas wrote: Hi, > Can anyone tell me which field here is used to > indicated the language of the function, in which it is > written. > > like when we create a function we mention $$language > bla in the end. It's one of the options (options is a

Re: [HACKERS] Bgwriter behavior

2004-12-23 Thread Simon Riggs
On Wed, 2004-12-22 at 04:43, Tom Lane wrote: > Bruce Momjian writes: > > So what are we doing for 8.0? > > Well, it looks like RC2 has already crashed and burned --- I can't > imagine that Marc will let us release without an RC3 given what was > committed today, never mind the btree bug that Mark

[HACKERS] CreateFunctionStmt struct

2004-12-23 Thread Sibtay Abbas
hello, typedef struct CreateFunctionStmt { NodeTag type; boolreplace; List *funcname; List *parameters; TypeName *returnType; List *options; List

Re: [HACKERS] Bgwriter behavior

2004-12-23 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > I remember the other difference between 8.0 and pre-8.0. When a backend > > has to write a block in 8.0, it does a write _plus_ fsync(), while in > > pre-8.0 it did only a write. There was a proposal to pass backend write > > information to the backgro

Re: [HACKERS] Bgwriter behavior

2004-12-23 Thread Tom Lane
Bruce Momjian writes: > I remember the other difference between 8.0 and pre-8.0. When a backend > has to write a block in 8.0, it does a write _plus_ fsync(), while in > pre-8.0 it did only a write. There was a proposal to pass backend write > information to the background writer so it would kno

Re: [HACKERS] Connection without database name

2004-12-23 Thread Michael Fuhr
On Thu, Dec 23, 2004 at 10:46:26AM +0100, Michael Meskes wrote: > Very early in its existance ecpg got an oracle compat hack that enabled > it to do a connect with just the username and use the database as > specified via PGDATABASE. It appears that this feature is not really > used as it seems it

Re: [HACKERS] join selectivity

2004-12-23 Thread Tom Lane
[EMAIL PROTECTED] writes: > So it should NOT depend on full number of rows either, is this right ? No, it's supposed to return a fraction. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Connection without database name

2004-12-23 Thread Tom Lane
Michael Meskes <[EMAIL PROTECTED]> writes: > Very early in its existance ecpg got an oracle compat hack that enabled > it to do a connect with just the username and use the database as > specified via PGDATABASE. It appears that this feature is not really > used as it seems it segfault for quite so

Re: [HACKERS] join selectivity

2004-12-23 Thread Tom Lane
[EMAIL PROTECTED] writes: > On Thu, Dec 23, 2004 at 10:01:33AM -0500, Tom Lane wrote: >> Right. This amounts to assuming that the join conditions and the >> restriction conditions are independent, which of course is bogus, >> but we really don't have enough information to do better. > Doesn't JOI

Re: [HACKERS] Regression (semi)fix for netbsd-mac68k

2004-12-23 Thread Tom Lane
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > Now we just need to work out why the box is failing the oldstyle_length test > - see > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=osprey&dt=2004-12-23%2005:00:22 Either the passing of arguments or the passing of the return value isn't working t

Re: [HACKERS] join selectivity

2004-12-23 Thread Tom Lane
[EMAIL PROTECTED] writes: > Doing some tests I've found out that the returned value from the > JOINSEL is applied to REL1.rows X REL2.rows, but REL1 and REL2 > are not 'base' table, rather relations with a number of > rows once again estimated by other selectivity functions. Right. This amounts

Re: [HACKERS] Regression (semi)fix for netbsd-mac68k

2004-12-23 Thread Andrew Dunstan
Rémi Zara said: >> >>> From pgbuildfarm, it seems that openBSD sparc64 does not exhibit the >>> problem (it's not part of resultmap, and passes the float8 test). >> >> OK, never mind that then. Patch applied as-is. > > Cool, thanks ! > Now we just need to work out why the box is failing the old

[HACKERS] Connection without database name

2004-12-23 Thread Michael Meskes
Very early in its existance ecpg got an oracle compat hack that enabled it to do a connect with just the username and use the database as specified via PGDATABASE. It appears that this feature is not really used as it seems it segfault for quite some amount of releases. While trying ot fix it I f

Re: [HACKERS] join selectivity

2004-12-23 Thread strk
On Thu, Dec 16, 2004 at 03:12:21PM -0500, Greg Stark wrote: > > "Mark Cave-Ayland" <[EMAIL PROTECTED]> writes: > > > Well at the moment PostGIS has a RESTRICT function that takes an expression > > of the formwhere column is a column consisting of > > geometries and constant is a bounding box.

[HACKERS] Happy Christmas and thanks...

2004-12-23 Thread Richard Huxton
for all the hard work on 8.0, not to mention the new-look website. It's all shaping up to be a good new year. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster