> Patch applied. Thanks.
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> >
> > > Patch removed at the request of the author. Author will resubmit.
> >
> > I've attached the fixed version of the patch below. After the
> > discussion on pgsql-hackers (especially the frightening memory dump in
>
> I think that we have concluded that a bigger executable with the
> unicode conversion functionality does not have any performance
> penalty. So I would like to remove --enable-unicode-conversion option
> so that it is always enabled if --enable-multibye is specified.
> Any objection?
Makes sens
Hello,
Following is an proposed fix to jdbc.sgml(line numbers are
for 7.1.3 doc). Comments?
[using an undefined method of ResultSet]
lines 564
x InputStream is = rs.getBinaryInputStream(1);
o InputStream is = rs.getBinaryStream(1);
Thanks.
Hiroyuki Yatabe([EMAIL PROTECTED])
Software
> There was a discussion about --enable-syslog by default. What was the
> consensus? I think this is a good one.
Yes, I thought we decided it should be the default too.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+
I think that we have concluded that a bigger executable with the
unicode conversion functionality does not have any performance
penalty. So I would like to remove --enable-unicode-conversion option
so that it is always enabled if --enable-multibye is specified.
Any objection?
--
Tatsuo Ishii
There was a discussion about --enable-syslog by default. What was the
consensus? I think this is a good one.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
> I have heard from Tom Lane that he will be out of town until Wednesday.
> As with any volunteer project, we can't hold people to dates and
> schedules. I know he is not done with everything he wants to do before
> beta, so we have to decide whether we should push ahead with beta now or
> wait
Hello,
Followings are proposed fixes to jdbc.sgml(line numbers are for 7.1.3
doc). Comments?
jdbc.sgml
[invalid column's name in a SELECT statement]
lines 579
x PreparedStatement ps = con.prepareStatement("SELECT oid FROM images WHERE name=?");
o PreparedStatement ps = con.prepareStatement
I have done ALTER TABLE / ADD PRIMARY KEY at home now, and is currently
being testing in the 10 mins a day I have free to code on Postgres. It
should only need another bit of testing before it's beta-worthy.
Given that adding primary keys is something that cannot be done at all with
postgres at
Hi Bruce,
I reckon we should wait until he returns. This way people testing the
beta's get to try the new features Tom will add when he gets back, and
don't have to wait for the next version of the Beta.
i.e. better testing.
Regards and best wishes,
Justin Clift
Bruce Momjian wrote:
>
> I
I have heard from Tom Lane that he will be out of town until Wednesday.
As with any volunteer project, we can't hold people to dates and
schedules. I know he is not done with everything he wants to do before
beta, so we have to decide whether we should push ahead with beta now or
wait for him to
John Summerfield writes:
> I'd point out this from the INSTALL document:
> --prefix=PREFIX
>
> Install all files under the directory PREFIX instead of
> /usr/local/pgsql. The actual files will be installed into various
> subdirectories; no files will ever be ins
will do.
> Jim Buttafuoco writes:
>
> > I am working a some patches to the code and I noticed that "pg_dump
-C
> > database" doesn't provide the database location information in the
dump
> > file. Is this correct?
>
> Your observation is correct, but the behaviour is not. Feel free to
> se
Jim Buttafuoco writes:
> I am working a some patches to the code and I noticed that "pg_dump -C
> database" doesn't provide the database location information in the dump
> file. Is this correct?
Your observation is correct, but the behaviour is not. Feel free to
send a patch.
--
Peter Eisent
Hi,
I am currently building a small web based app, with postgres as back end. I
found that in ecpg you can declare and use cursor without declaring a
transaction. In several places I have used cursors for selects only. That's
the only way I found to make ecpg fetch multiple rows.
And in ecpg
> The x = NULL hack keeps biting people. Innocent people should not be
> exposed to incorrect behaviour because of (supposed) MS Access breakage.
> I strongly urge that we do one of the following:
>
> 1) Provide a tunable knob to turn this on (cf. KSQO)
>
> 2) Confine this to the ODBC driver some
On Thursday 06 September 2001 07:46 pm, John Summerfield wrote:
> I'd point out this from the INSTALL document:
> --prefix=PREFIX
[snip]
> Installing everything under --prefix (as the document says) would also
> help package builders; the current rpm looks pretty horrible (and
> that's why I
> [EMAIL PROTECTED] ("Joe Conway") wrote in message
>news:<02a101c12c0e$37856d60$48d210ac@jecw2k1>...
> ... snip
> > BYTEA is very similar to TEXT, except that it is intended for binary data. I
> > recently posted a PHP function which escapes binary in order to allow
> > inserting it into a bytea
> [EMAIL PROTECTED] ("Joe Conway") wrote in message
news:<02a101c12c0e$37856d60$48d210ac@jecw2k1>...
> ... snip
> > BYTEA is very similar to TEXT, except that it is intended for binary
data. I
> > recently posted a PHP function which escapes binary in order to allow
> > inserting it into a bytea c
I have checked this in CVS and it is working fine. Karel, have you
fixed this? I can't find a place where I have applied a fix for this.
> Good day,
>
> Sorry to post to this list about a patch, but I seem to be having some
> difficult getting on the pgsql-patches list; keep getting an "ille
Hi,
I have a serious problem with hanging backends.
This is wat I get from ps ->
postgres 23507 22794 0 13:33 ?00:00:09
/usr/local/pgsql/bin/postgres 1.1.3.123 postgres bts01 SELECT waiting
This blocks all the other clients. (ODBC call failed)
The situation
- PostgreSQL 6.4.2 on i
[EMAIL PROTECTED] ("Joe Conway") wrote in message
news:<02a101c12c0e$37856d60$48d210ac@jecw2k1>...
... snip
> BYTEA is very similar to TEXT, except that it is intended for binary data. I
> recently posted a PHP function which escapes binary in order to allow
> inserting it into a bytea column (on
On Thu, Sep 06, 2001 at 03:16:26PM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > versuch=# CREATE RULE ru_u_chkntfy AS ON UPDATE TO chkntfy DO NOTIFY CHKNTFY;
> > CREATE
> > versuch=# update chkntfy set nummer=10 where nummer = 1;
> > ERROR: Conditional NOTIFY is not implemented
>
>
> Tom Lane writes:
>
> > > What we probably want is some configure switch that switches between the
> > > current behaviour and the behaviour you want.
> >
> > I'd suggest --prefix-like options to determine installation locations
> > for the perl and python modules,
>
> Basically, I was envision
The x = NULL hack keeps biting people. Innocent people should not be
exposed to incorrect behaviour because of (supposed) MS Access breakage.
I strongly urge that we do one of the following:
1) Provide a tunable knob to turn this on (cf. KSQO)
2) Confine this to the ODBC driver somehow (which c
Hello,
Reading the TO DO list, I found the following item:
"Allow cursors to be DECLAREd/OPENed/CLOSEed outside transactions"
I badly need this functionnality to interface postgres in my company
database abstraction layer. Do you have any idea of when it should be
available?
If you think it can
Hi,
I want to extend the catalog, i think the key is
pg_attribute.h, pg_class.h, pg_type.h
is it enough:
1. add pg_xxx.h
2.modify pg_attribute.h, pg_class.h, pg_type.h, catname.h,
indexing.h, indexing.c, Makefile
i tried once, it was ok when target to template. but like a mess
when target
All,
I am working a some patches to the code and I noticed that "pg_dump -C
database" doesn't provide the database location information in the dump
file. Is this correct?
Thanks
Jim
Example:
datname | datdba | encoding | datistemplate | datallowconn |
datlastsysoid | datpath | idxpath
--
All,
I am working a some patches to the code and I noticed that "pg_dump -C
database" doesn't provide the database location information in the dump
file. Is this correct?
Thanks
Jim
Example:
datname | datdba | encoding | datistemplate | datallowconn |
datlastsysoid | datpath | idxpath
-
Thanks. You saved me work by pointing me to the FOR UPDATE detail, and
the aggregate non-locking restriction. Can anyone comment on why this is
so? Reposting in HACKERS was a good idea :)
Side note: GeneXus (http://www.genexus.com) support, will be formally
announced in 10 days in an important in
I believe LOCK TABLE IN EXCLUSIVE MODE should block everything but
selects, but it locks for the entire transaction I think. Maybe in tcl you
could create your own locking using global variables. If the spin lock code
is available to user functions you might be able to use that.
Alternativley, in
> > Don't worry about that. Before anything user could do, postgres's
> > start up procedure sets the appropreate encoding to ClientEncoding
> > variable.
>
> Larry's backend knows method how call conversion routines, without
> set ClientEncoding:-) IMHO with my patch is always sure that backend
I found a non-existent option "-list" described in the doc of
libpgtcl's pg_result procedure. Shall we remove it from the docs?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-loun
On Mon, Sep 10, 2001 at 12:14:44AM -0400, Bruce Momjian wrote:
> > There are many places in our docs where INV_ARCHIVE is mentioned. In
> > my understanding, INV_ARCHIVE has never been supported since
> > PostgreSQL 6.0 was born. Shall we remove it from the docs?
>
> It is for large object/invert
On Mon, Sep 10, 2001 at 01:46:28PM +0900, Tatsuo Ishii wrote:
> Hi,
>
> I'm going to add a new function "pg_client_encoding" returning the
> current client side encoding name. I know there is a similar
> functionality already there in PostgreSQL (show client_encoding) but
> it's pain to handle no
On Mon, Sep 10, 2001 at 03:50:46PM +0900, Tatsuo Ishii wrote:
> Don't worry about that. Before anything user could do, postgres's
> start up procedure sets the appropreate encoding to ClientEncoding
> variable.
Larry's backend knows method how call conversion routines, without
set ClientEncodin
36 matches
Mail list logo
