[HACKERS] Approved

2003-06-06 Thread tih
Please see the attached file. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-06 Thread Bruce Momjian
scott.marlowe wrote: > On Fri, 6 Jun 2003, Peter Eisentraut wrote: > > > scott.marlowe writes: > > > > > If indexes on text worked right in other locales it would be no big deal. > > > > They will in version 7.4, so all these concerns about trading off locale > > use vs. performance will become

Re: [HACKERS] Wrong version of jdbc in 7.3.3 rpms

2003-06-06 Thread Barry Lind
Lamar, I can understand you not wanting to install the components necessary to build the various jdbc versions. So I would just request that you pull the latest prebuilt version from jdbc.postgresql.org when doing a new RPM. I will try to answer some of your other questions below. Lamar Owen wro

Re: [HACKERS] SAP and MySQL ...

2003-06-06 Thread Hans-Jürgen Schönig
Hardly. SAP failed on the attempt to open source ADABAS even more miserably than Borland with Interbase. Now it looks like they found someone who said "we know open source, we can do that, oh pick me, me, me, pick mee!" that's what i think as well. by the way: did you see that MySQL AB has g

[HACKERS] [Fwd: Re: Problem trying to implement version 3.0 of the PostgreSQLprotocol in C#]

2003-06-06 Thread Carlos Guzman Alvarez
Hello: > Sounds like you are sending junk following the Parse message. You are right thanks very much, but now i have another problem, i don't get response from the postgresql server, hummm this is what i'm sending for test: Byte1 ('P') Int32 (40) String ('') String ('SELECT

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-06 Thread scott.marlowe
On Fri, 6 Jun 2003, Peter Eisentraut wrote: > scott.marlowe writes: > > > If indexes on text worked right in other locales it would be no big deal. > > They will in version 7.4, so all these concerns about trading off locale > use vs. performance will become obsolete. Oh! I thought there were

Re: [HACKERS] Removing a user's password

2003-06-06 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Well, they are not actually removing it, just setting it to NULL, as > > though a password was never assigned. We have a way for users to set > > it, but no way for them to remove it. > > If they had a way to remove it, then they'd n

Re: [HACKERS] Wrong version of jdbc in 7.3.3 rpms

2003-06-06 Thread Justin Clift
Barry Lind wrote: Does anyone know why apparently the 7.3beta1 version of the jdbc drivers are what is included in the 7.3.3 rpms? No idea. Just updated the "PostgreSQL Release Process" document though in case anyone (Marc) ever decides they're going to use it: http://advocacy.postgresql.org/doc

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-06 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > 1) Are any additional changes expected for GUC.c before feature-freeze? I'm still thinking of adding an am_superuser variable so that psql can rely on the new ParameterStatus mechanism instead of explicit queries to find out if you're superuser. But this

Re: [HACKERS] Wrong version of jdbc in 7.3.3 rpms

2003-06-06 Thread Lamar Owen
On Thursday 05 June 2003 11:39, Barry Lind wrote: > Does anyone know why apparently the 7.3beta1 version of the jdbc drivers > are what is included in the 7.3.3 rpms? > > The pg73b1jdbc3.jar file is very old (it is the 7.3 beta 1 version). > > What RPMs are you using? You should contact whoever p

[HACKERS] large objects

2003-06-06 Thread Nigel J. Andrews
I realise large objects are liked anymore and that the wire protocol is changing in 7.4 but I've just posted this message into the PHP documentation: -- begin Using php 4.3.0 and PostgreSQL 7.3.1 I can write a simple script in which pg_lo_write seems to always return 1 and not the number of by

Re: [HACKERS] Aggregates containing outer references don't work per

2003-06-06 Thread Bruce Momjian
I think the issue is this part: > What we now realize is that the spec says SUM(outervar) ought to be > considered an aggregate evaluated at the outervar's query level, and > then imported *as a whole* as an effective constant for the subquery. > > I claim that there should be nothing wrong with

[HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-06 Thread Josh Berkus
Folks, Last we talked (before the mail server went down) Tom had agreed in principle to a re-ordering of postgresql.conf.sample and the "Run-Time Configuration" docs page based on the attached ordering file. I would like to make this happen before feature-freeze on June 15. To do that, I nee

Re: [HACKERS] Linux startup script

2003-06-06 Thread Andrew Overholt
Darko Prenosil once said: > I have noticed that after "/etc/init.d/postgresql restart", postmaster is no > longer writes to "serverlog". (RedHat 9). > Here is fixed "restart" section. > > restart) > echo -n "Restarting PostgreSQL: " > su - $PGUSER -c "$DAEMON restart -D '$PGDATA' -s -

Re: [HACKERS] Broken RR?

2003-06-06 Thread Rasmus Resen Amossen
I can't reproduce the above. Are you sure T2 isn't committing? Arch, damn, yes, bugger... If it were, since the default isolation level is read committed, Ok, that explains it. But my second question is still unanswered: Is the key value locking, that is implemented in postgres, ARIES/KVL?

[HACKERS] UPDATE ... SET = DEFAULT

2003-06-06 Thread Rod Taylor
Is there an easy way of doing this? Insert was simple as all that needed to be done was to throw away the reference to the column. It would seem a new primnode (change InsertDef into SetDefault or similar) will be required with some executor logic. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: htt

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-06 Thread scott.marlowe
On Thu, 5 Jun 2003, Nigel J. Andrews wrote: > On Wed, 4 Jun 2003, Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > That is one thing I liked about the initdb mention --- it clearly told > > > them to watch out for something they might not have been looking for. > > > > Only

Re: [HACKERS] Aggregates containing outer references don't work per spec

2003-06-06 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > When we considered outervar1 as a constant, we could do the aggregate in > the subquery using computations, but when SUM(outervar1) is computed in > an above query, combining that with anything that is part of different > query level makes no sense to me

Re: [HACKERS] Broken RR?

2003-06-06 Thread Mike Mascari
Rasmus Resen Amossen wrote: > Does Postgres garantee repeatable-read (RR) during transactions? And > does it implement ARIES/KVL? > > If so, why is the following possible? > > T1: begin; > T1: select * from table; > (notice the row with id = X) > T2: begin; > T2: delete from table where id = X

Re: [HACKERS] Broken RR?

2003-06-06 Thread Mike Mascari
I wrote: > Rasmus Resen Amossen wrote: > > >>Does Postgres garantee repeatable-read (RR) during transactions? And >>does it implement ARIES/KVL? >> >>If so, why is the following possible? >> >>T1: begin; >>T1: select * from table; >> (notice the row with id = X) >>T2: begin; >>T2: delete from t

Re: [HACKERS] Problems with renaming a column

2003-06-06 Thread Rod Taylor
On Wed, 2003-06-04 at 22:28, Christopher Kings-Lynne wrote: > > Which ones are missing, and should we really be looking at creating a > > pg_definition_schema instead? > > Missing: > > Database, schema, table, domain, cast, conversion, function... > > Maybe a definition schema might be better...

[HACKERS] Wrong version of jdbc in 7.3.3 rpms

2003-06-06 Thread Barry Lind
Does anyone know why apparently the 7.3beta1 version of the jdbc drivers are what is included in the 7.3.3 rpms? --Barry Original Message Subject: Re: [JDBC] Official JDBC driver release ? Date: Thu, 05 Jun 2003 08:14:40 +0200 From: Thomas Kellerer <[EMAIL PROTECTED]> To: [EMAI