Bruce Momjian <[EMAIL PROTECTED]> writes:
>> I know I might have had a different opinion on this before but I'm
>> beginning to think that the path to any auxiliary programs needs to be
> I understand your concern. My question is how does someone access
> initdb without getting binaries of the s
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > while (HeapTupleIsValid(lTuple = heap_getnext(sRel, 0)))
> > + {
> > heap_delete(lRel, &lTuple->t_self, NULL);
> > + if (RelationGetForm(lRel)->relhasindex)
> > + {
> > + Relationidescs[Num_pg_liste
Bruce Momjian <[EMAIL PROTECTED]> writes:
> while (HeapTupleIsValid(lTuple = heap_getnext(sRel, 0)))
> + {
> heap_delete(lRel, &lTuple->t_self, NULL);
> + if (RelationGetForm(lRel)->relhasindex)
> + {
> + Relationidescs[Num_pg_listener_indices];
OK, I have fixed the mistake I made that Tom pointed out. The fix will
be in 7.0.1. Tomorrow's snapshot will have it too.
Patch attached.
Thanks Tom.
> Jeff Davis <[EMAIL PROTECTED]> writes:
> > Regarding UNLISTEN: 'UNLISTEN ' does not remove
> > LISTEN entries for '' in 'pg_listener' class,
> [Charset ISO-8859-1 unsupported, filtering to ASCII...]
> > Tom Lane writes:
> >
> > > Or possibly he's invoking the right initdb, but it's finding the wrong
> > > postgres binary.
> >
> > Or the wrong template files? Run initdb --show to see.
> >
> > > I wonder if we can get initdb to check
> Raul Chirea <[EMAIL PROTECTED]> writes:
> > So, it seems to be a parser difficulty (bug) to correctly determine
> > the type of a numeric constant with decimals (like 99.9).
>
> Yes. You can find more about this in the pgsql-hackers archives.
> We've been aware of the problem for a while but a
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> Tom Lane writes:
>
> > Or possibly he's invoking the right initdb, but it's finding the wrong
> > postgres binary.
>
> Or the wrong template files? Run initdb --show to see.
>
> > I wonder if we can get initdb to check that it's
> > invo
Applied. Pgaccess author will apply it there.
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> [syntax change WITH PASSWORD "foo" -> WITH PASSWORD 'foo']
>
> Here's a patch. (I think. I'm a bloody Tcl amateur.) What do we do with
> it?
>
>
> *** pgsql-cvs/src/bin/pgaccess/lib/users.t
Jeff Davis <[EMAIL PROTECTED]> writes:
> Regarding UNLISTEN: 'UNLISTEN ' does not remove
> LISTEN entries for '' in 'pg_listener' class,
> nor does it prevent NOTIFYication.
It appears that this breakage is due to failure to maintain the index
on pg_listener that was added in 7.0. UNLISTEN is t
I looked at the TODO before sending this, and found
nothing regarding listen/unlisten.
I was unable to find the bug report sumission page at
www.postgresql.org, even though it was mentioned in
this template.
Your name : Jeff Davis
Your email address : [EMAIL PROTEC
Raul Chirea <[EMAIL PROTECTED]> writes:
> So, it seems to be a parser difficulty (bug) to correctly determine
> the type of a numeric constant with decimals (like 99.9).
Yes. You can find more about this in the pgsql-hackers archives.
We've been aware of the problem for a while but are unsure as
Hi there,
It happened to me, too !
Denis Sbragion wrote:
> pgsql=# UPDATE aocc SET controvalore_ord = 320.5 WHERE controvalore_ord = 320.5
> 00 AND oid = 21624;
> ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
> You will have to retype this query using an e
Tom Lane writes:
> Or possibly he's invoking the right initdb, but it's finding the wrong
> postgres binary.
Or the wrong template files? Run initdb --show to see.
> I wonder if we can get initdb to check that it's
> invoking the right version of 'postgres'? A display of the version
> number w
Rainer Tammer writes:
> The regression test fails on a couple of topics.
> -> HINT --enable-locale !!
You need to unset all your locale settings before running the
tests. (any or all of LC_*, LOCALE, LANG, LANGUAGES, etc.)
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL P
14 matches
Mail list logo
