Hello
I know so I need to use column definition list when I have SRF
function without def of own type. But I don't understand why. In my SRF
function I specify all informations about columns?
TupleDescInitEntry (tupdesc, 1, idn, INT4OID, -1, 0, false);
TupleDescInitEntry (tupdesc,
Hi,
on Solaris 9 with PostgreSQL 7.4:
when you
- 'initdb' a fresh database,
- _don't_ set a password for user 'postgres',
- convert the 'trust' lines in data/pg_hba.conf to 'md5' or 'password'
and then try to connect as user 'postgres', the backend crashes in
backend/libpq/hba.c:372:
Michael Wildpaner [EMAIL PROTECTED] writes:
+ /* fail if there is nothing to search in */
+ if ((user_sorted == NULL) || (user_length == 0))
+ return NULL;
Hm, Solaris' bsearch() fails on empty input? How bizarre.
Easily worked around though --- thanks for the report!
I
Hm, Solaris' bsearch() fails on empty input? How bizarre.
I was skeptical but apparently this is a known bug ...
googling turned up a couple of references, eg
http://www.opencm.org/pipermail/opencm-dev/2002-July/001077.html
regards, tom lane
As Tom mentioned previous, we are aiming for 7.4.1 on Wednesday of next
week ... is anyone sitting on anything that they feel *just has to* be in
it?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first ... we know of nothing outstanding
right now ...
This means it will be tag'd/bundled on Sunday ...
Marc G.
--On Friday, December 05, 2003 12:47:40 -0400 Marc G. Fournier
[EMAIL PROTECTED] wrote:
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first ... we know of nothing
Bruce, Marc, Joe:
max_function_args - int
Shows the maximum number of function arguments
max_index_keys - int
Shows the maximum number of index keys
Have we decoupled these two variables? Last I checked, their values still
had to be identical. If they have not been
On Fri, 5 Dec 2003, Peter Eisentraut wrote:
Marc G. Fournier writes:
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first ... we know of nothing outstanding
right
Marc G. Fournier writes:
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first ... we know of nothing outstanding
right now ...
A bug in the information schema concerning
Marc G. Fournier wrote:
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first ... we know of nothing outstanding
right now ...
This means it will be tag'd/bundled on Sunday ...
Josh Berkus wrote:
max_function_args - int
Shows the maximum number of function arguments
max_index_keys - int
Shows the maximum number of index keys
Have we decoupled these two variables? Last I checked, their values still
had to be identical. If they have not been decoupled and won't
PG Folks,
What follows are a couple of proposed TODO items to make up for some of the
places our planner is weak compared to other leading databases.
Particularly, I'm personally concerned that as of 7.4.0 we would fail the
TPC benchmark even if someone sponsored us for it (see Issue #2
Hello,
It appears that the count('x') will no longer work without a type
cast. Is this on purpose? I've already modified my code to use
count(*) instead, but I decided to mention it anyway.
warehouse=# select count('x') ;
ERROR: cannot accept a value of type any
warehouse=# select
[Up front: yes, I'm following up to a post that's nearly three months
old. I can't find any more recent discussion of this issue.]
[EMAIL PROTECTED] (Tom Lane) writes:
(Of course, if you can show that there's a significant penalty in
backend launch time from having useless shlibs linked in,
The count(*) information can be revisioned too, am I wrong ? I'm able
to create a trigger that store the count(*) information in a special
table, why not implement the same in a way builded in ?
Then every insert or delete would have to lock that count. Nobody else
would be able to insert
http://archives.postgresql.org/pgsql-hackers/2000-07/msg00483.php
I'm having this same problem with postgresql 7.3.4. Easy to reproduce by
running an 'INSERT' query. Here is some of the debugging info if I break
near the beginning of the pglz_decompress function:
(gdb) p dend
$1 = (unsigned
im not sure if this is the correct mailing list, please correct me if it is not.
my gcc is version 3.2, configure runs fine i deativated readline-support...but this
error occours:
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../../src/include
I did not get any response to this question on
general so I am forwarding it to hackers.
Thanks,
elein
- Forwarded message from elein [EMAIL PROTECTED] -
Date: Sat, 29 Nov 2003 14:11:20 -0800
From: elein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: elein [EMAIL PROTECTED]
Subject:
John,
SELECT t1.a, t2.b
FROM t1, t2
WHERE t1.a = t2.a
AND t1.c = x
AND t1.f IN (m, n, o)
AND t2.d = v
AND t2.e BETWEEN j AND k
UNION ALL
Shouldn't that be UNION instead of UNION ALL? You don't want
duplicate rows, if i'm not mistaken.
Yes, you're correct;
I know Oracle is capable of producing the UNION plan. but I don't know if
that's the only option. I'm curious what indexes the rewritten union-based
query used.
Josh Berkus [EMAIL PROTECTED] writes:
SELECT t1.a, t2.b
FROM t1, t2
WHERE t1.a = t2.a
AND (
( t1.c = x
AND t1.f IN
Hi,
On Fri, 5 Dec 2003, Tom Lane wrote:
Hm, Solaris' bsearch() fails on empty input? How bizarre.
I was skeptical but apparently this is a known bug ...
googling turned up a couple of references, eg
http://www.opencm.org/pipermail/opencm-dev/2002-July/001077.html
in defense of Solaris'
Alvar Freude wrote:
while changing a column from base255 encoded text (all except null byte) to
bytea, I found the following bug in Postgresql's LIKE operator with indexes
(it follows a more detailed description then my old mails in -bugs and
- -general, including the proof of the bug):
Please try
On Fri, 2 Jan 2004, julius wrote:
im not sure if this is the correct mailing list, please correct me if it is not.
my gcc is version 3.2, configure runs fine i deativated readline-support...but this
error occours:
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Joe,
- -- Joe Conway [EMAIL PROTECTED] wrote:
Please try the attached patch and let me know how it works for you. It is
against cvs HEAD, but should apply OK to 7.4.
has this about one week time? I travel on monday to Geneva (World Summit on
Marc G. Fournier wrote:
A bug in the information schema concerning the bit types must be
fixed.
Does anyone have a patch for this?
I suppose not, but it's being worked on.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Alvar Freude wrote:
has this about one week time? I travel on monday to Geneva (World Summit on
the Information Society) and have a lot to prepare ... :-(
I'll make a report when I have some minutes (or hours ;) ) ...
Well, 7.4.1 will be bundled up for release on Sunday, so it would be
ideal to
On Sat, 6 Dec 2003, Peter Eisentraut wrote:
Marc G. Fournier wrote:
A bug in the information schema concerning the bit types must be
fixed.
Does anyone have a patch for this?
I suppose not, but it's being worked on.
Is that the one that Joe just mentioned workign on? about BYTEA?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- -- Joe Conway [EMAIL PROTECTED] wrote:
Well, 7.4.1 will be bundled up for release on Sunday, so it would be
ideal to get some feedback sooner if possible.
this is a good argument ... ;)
I'll try to check it ...
Ciao
Alvar
- --
** Alvar
Marc G. Fournier wrote:
On Sat, 6 Dec 2003, Peter Eisentraut wrote:
I suppose not, but it's being worked on.
Is that the one that Joe just mentioned workign on? about BYTEA?
I don't think so.
Joe
---(end of broadcast)---
TIP 1: subscribe and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
- -- Joe Conway [EMAIL PROTECTED] wrote:
Please try the attached patch and let me know how it works for you. It is
against cvs HEAD, but should apply OK to 7.4.
so, I checked it with my database.
It looks good, all checks I made are OK.
I
Peter Eisentraut [EMAIL PROTECTED] writes:
A bug in the information schema concerning the bit types must be
fixed.
Does anyone have a patch for this?
I suppose not, but it's being worked on.
What's the bug exactly? Is it worth delaying the release for? Given
that Bruce is out of town now
Joe Conway [EMAIL PROTECTED] writes:
Josh Berkus wrote:
Have we decoupled these two variables?
Their values are still the same, but Tom suggested we not couple them
inextricably by giving users access to them as one variable.
The only reason they are the same is that pg_proc.proargtypes and
[EMAIL PROTECTED] (Edwin S. Ramirez) writes:
It appears that the count('x') will no longer work without a type
cast. Is this on purpose?
warehouse=# select count('x') ;
ERROR: cannot accept a value of type any
Hm, that query seems like it should be legal. (You get the same
from select
Roderick A. Anderson [EMAIL PROTECTED] writes:
tuptoaster.c: In function `toast_delete_datum':
tuptoaster.c:973: `F_OIDEQ' undeclared (first use in this function)
I ran into the same thing when working with RPMs and the tarball(s).
This suggests that the shell script
I have committed some fairly wide-ranging revisions to pg_dump to make
it dump database objects in a safe order according to the dependency
information available from pg_depend. While I know that I have fixed
a lot of previously-broken cases, it's hardly unlikely that I've broken
some things too.
OpenFTS development team is proud to announce release
of OpenFTS 0.35 perl version - open-source full text search engine
for PostgreSQL.
Download from http://sourceforge.net/project/showfiles.php?group_id=30968
Major changes:
* use contrib/tsearch2
* ispell dictionary supports compound words
37 matches
Mail list logo