Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> Tom also mentioned that it might be possible for the server to support
>> setting the character set for a database even when multibyte wasn't
>> enabled. That would then allow clients like jdbc to get a value from
>> non-multibyte enabled servers tha
> > Still I don't see what you are wanting in the JDBC driver if
> > PostgreSQL would return "UNKNOWN" indicating that the backend is not
> > compiled with MULTIBYTE. Do you want exact the same behavior as prior
> > 7.1 driver? i.e. reading data from the PostgreSQL backend, assume its
> > encoding
Richard Poole <[EMAIL PROTECTED]> writes:
> How about a feature in psql which would read something like '%type' and
> convert it to the appropriate thing before it passed it to the backend?
That's just about what Ian's patch does, only it does it during backend
parsing instead of in the client.
On Tue, May 08, 2001 at 05:49:16PM -0400, Tom Lane wrote:
> I presume that Ian is not thinking about such a scenario, but only about
> using %type in a schema file that he will reload into a freshly created
> database each time he edits it. That avoids the issue of whether %type
> declarations ca
Bruce Momjian <[EMAIL PROTECTED]> writes:
> But don't we already have problems with changing functions that use
> tables or does this open a new type of problem?
But this feature isn't about functions that use tables internally;
it's about tying the fundamental signature of the function to a tabl
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> We need to discuss whether we like the %TYPE feature proposed by Ian
>> Taylor. It seems awfully nonstandard to me, and I'm not sure that the
>> value is great enough to be worth inventing a nonstandard feature.
>> ISTM that people don't normally tie f
Bruce Momjian <[EMAIL PROTECTED]> writes:
> OK, now that we have started 7.2 development, I am going to go through
> the outstanding patches and start to apply them or reject them. They
> are at:
> http://candle.pha.pa.us/cgi-bin/pgpatches
> I could use help in identifying which patches are
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The query that showed the bug would serve just fine.
Most of the bug reports we get are far too bulky to be appropriate to
add to the regress tests as-is. IMHO anyway.
We do need more extensive regress tests, but I don't think that slapping
bug-rep
Kovacs Zoltan <[EMAIL PROTECTED]> writes:
> Thanks in advance. Zoltan
You're welcome ;-)
regards, tom lane
*** src/backend/executor/nodeAppend.c.orig Thu Mar 22 01:16:12 2001
--- src/backend/executor/nodeAppend.c Tue May 8 15:48:02 2001
***
*** 8,14
On Tue, 8 May 2001, Tom Lane wrote:
> Kovacs Zoltan <[EMAIL PROTECTED]> writes:
> > I cannot decide if this is a serious bug or not --- some queries from
> > complex views may give strange results. The next few days I will try to
> > find the point where the problem is but now I can only include
"Rod Taylor" <[EMAIL PROTECTED]> writes:
> Fiddling with userlock stuff for the purposes of setting up an action
> queue. Having the lock in the where clause causes the lock code to
> actually lock 2 rows, not just the one that is being returned.
A WHERE clause should *never* contain function ca
As a general rule I don't. But I'm having a hard time trying to find
out if there is a lock on a given item without attempting to lock it.
Seems to work that way with all locks but most delay until it can
obtain it. Userlocks don't wait.
--
Rod Taylor
BarChord Entertainment Inc.
- Origi
> HOWEVER, I _do_ have 7.1.1 RPMs built (minus some minor modifications) for
> RedHat 7.1. Thomas, would you mind e-mailing me any changes you made to
> anything (other than the version diff)? I have another patch from Trond to
> apply to the initscript, and more testing would be nice.
No chang
Hi.
On some systems /bin/sh is not Burne Shell, e.g. /bin/sh is tcsh, but
there is /bin/sh5. It is looks like there is already knowledge about it in
the system: Makefile.ultrix4 has `SHELL=/bin/sh5' in it, but configure
thinks something else: config.status has `s%@SHELL@%/bin/sh%g'. (This is
real
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
> A fellow NetBSD developer has sent me some changes needed to build 7.1
> cleanly on NetBSD through its package system. I am asking him a few
> questions about it but I thought I would just commit them then if no one
> has a problem. They are mostly
Kovacs Zoltan <[EMAIL PROTECTED]> writes:
> I cannot decide if this is a serious bug or not --- some queries from
> complex views may give strange results. The next few days I will try to
> find the point where the problem is but now I can only include the data
> structure and the SELECT statement
Fiddling with userlock stuff for the purposes of setting up an action
queue. Having the lock in the where clause causes the lock code to
actually lock 2 rows, not just the one that is being returned. 0's in
the last section means it could not be locked. This is with 7.1.1.
The function itself i
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> How about letting them see all statistics where they have select permission
> on the base table (if that is possible with the new permission table) ?
Yeah, I was thinking the same thing. If we restrict the view on the
basis of current_user b
Thomas Lockhart <[EMAIL PROTECTED]> writes:
> I've built RPMs for 7.1.1, but perhaps we should wait until 7.1.2 to
> post them given the pgtcl problem? Lamar, what are you planning for
> 7.1.1?
Given my plpgsql screwup, and the dump-7.0-views thing that Philip wants
to fix in pg_dump, I'd say the
Hi.
After `configure --enable-depend' I try `make' and got
gmake[3]: Entering directory
`/tmp_mnt/hosts/wisdom/NewSoftware/Ask/build/pgsql/src/backend/port'
gcc -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o ../../utils/strdup.o ../../utils/strdup.c
-MMD
cp: ../
A fellow NetBSD developer has sent me some changes needed to build 7.1
cleanly on NetBSD through its package system. I am asking him a few
questions about it but I thought I would just commit them then if no one
has a problem. They are mostly related to building cleanly on NetBSD.
Perhaps someon
First pleasu use a subject line, since I almost discarded this
message.
Second please send your questions to an appropriate list like
pgsql-general.
See if adding the next row is fast again.
If it is not, I do not have a clue.
Andreas
-Ursprüngliche Nachricht-Von: Saju
[mailt
> > >From a portability standpoint, I think if we go anywhere, it would be to
> > write directly into device files representing sections of a disk.
>
> That makes sense to me. On "traditional" Unices, we could use the raw
> character device for a partition (eg /dev/rdsk/* on Solaris),
On Sola
> > Right now anyone can look in pg_statistic and discover the min/max/most
> > common values of other people's tables. That's not a lot of info, but
> > it might still be more than you want them to find out. And the
> > statistical changes that I'm about to commit will allow a couple dozen
> >
> > 2. The allocation time for raw devices is by far better (near
> > instantaneous) than creating preallocated files in a
> > fs. Providing 1 Tb of raw devices is a task of minutes,
> > creating 1 Tb filsystems with preallocated 2 Gb files is a
> > task of hours at best.
>
> Fil
I've posted RPMs for Mandrake, but could not put them in the obvious
place on the FTP site because the permissions do not allow group write
access. Lamar, could you open up that part of the tree to allow group
write permissions? In the meantime, I've placed the files in
/pub/binary/v7.1-Mandrake/.
26 matches
Mail list logo
