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
"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 src/backend/uti
[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
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.proargtyp
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
-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.
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 unsubs
-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
- --
** Alv
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? ab
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 ge
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 archi
-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 o
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 -Wmissing-declar
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
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 Solari
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
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.
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:
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 -D_GNU_SOUR
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 cha
[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 t
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 count('x'::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 bel
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 b
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 ...
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 concerni
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
> >
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
--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 outst
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. Fournie
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 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
---
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!
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:
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,
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
