Josh Berkus wrote:
Tom, Justin,
Um, not documenting it is probably not a good move for us, however putting
it at the end in a section marked Developer Focused or something similar
would probably have the right mix of messages. i.e. hands off + not a
performance tweak, etc.
So,
Josh Berkus wrote:
Tom,
Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the
option that's supposed to let you turn off Inserting missing FROM clause for
table ...
I thought that patch was accepted 3 weeks ago? Is this just missing from
postgresql.conf.sample?
scott.marlowe wrote:
On Fri, 6 Jun 2003, Bruce Momjian wrote:
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
I just want to drop a note to say I'm back on the list. I'm sorry to
have been away for so long, but I had some personal issues that kept me
from the list.
I also lost all my data, so it would be great if someone could send me
the latest version of the PITR patch.
Thanks.
--
John Nield
[EMAIL
--On Monday, June 09, 2003 23:12:27 -0400 Tom Lane [EMAIL PROTECTED]
wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
cc -O -g -I../../../src/interfaces/libpq -I../../../src/include
-I/usr/local/include -DBINDIR=\/usr/local/pgsql/bin\ -c -o pg_dump.o
pg_dump.c UX:cc: WARNING: debugging and
On Mon, 9 Jun 2003, Tom Lane wrote:
Josh Berkus [EMAIL PROTECTED] writes:
Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the
option that's supposed to let you turn off Inserting missing FROM clause for
table ...
Bruce hasn't applied that patch yet. I believe
Hi all.
I am newer to postgresql develop, so my qestion maybe too simple.
I have noticed that we have discussed the incremental backup and PITR before.
Frankly, I am still interested in incremental backup. I am not sure
whether we can implement such function based on XLog
Since there exists
Hi!
For some reason I wish to write C-function for SQL which returns set of
composite type, but this type is defined function itself and composite type can
be changed from call to call. So I can't define create type by 'CREATE TYPE'
command.
It's documented (34.7.8. Returning Rows (Composite
Larry Rosenman [EMAIL PROTECTED] writes:
for the record, this is a change from 7.3.2 to 7.3.3 that broke here.
[ scratches head... ] I don't see anything in the CVS logs that could
account for that.
regards, tom lane
---(end of
Teodor Sigaev [EMAIL PROTECTED] writes:
For some reason I wish to write C-function for SQL which returns set of
composite type, but this type is defined function itself and composite type can
be changed from call to call. So I can't define create type by 'CREATE TYPE'
command.
Perhaps the
On Tue, 10 Jun 2003, Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
for the record, this is a change from 7.3.2 to 7.3.3 that broke here.
[ scratches head... ] I don't see anything in the CVS logs that could
account for that.
It might be maintenenace related (7.1.3 UP 1 of
On Tue, 10 Jun 2003, Nigel J. Andrews wrote:
How do people feel about changing matching for host and hostssl to be such that
a plain host line in pg_hba.conf does not allow a SSL connection but requires
the hostssl specifier?
Nigel,
We had discussed overhauling the connection settings on
Excellent news. I picked up your patch but have not be able to devote
a large amount of time to it. I'll send you a patch based on the cvs
tip as well as some pointers to proposed changes. I'll contact you
offlist about various workload proposals.
Cheers,
Patrick
J.R. Nield wrote:
I just want
On Tue, 10 Jun 2003, Tom Lane wrote:
Nigel J. Andrews [EMAIL PROTECTED] writes:
How do people feel about changing matching for host and hostssl to be such that
a plain host line in pg_hba.conf does not allow a SSL connection but requires
the hostssl specifier?
Then there would be no way
Nigel J. Andrews [EMAIL PROTECTED] writes:
On Tue, 10 Jun 2003, Tom Lane wrote:
If your real gripe is that libpq insists on trying SSL connections
first, the server is the wrong end to be patching that problem at.
There should be a way to control libpq's allow_ssl_try state variable
from the
On Sat, 7 Jun 2003 [EMAIL PROTECTED] wrote:
Hi all,
I wonder if it's a security problem: One of my customer noticed that he
could see all databases on the system with phppgadmin. not only he sees
databases but tables, views, fonctions... Fortunatly he can't see any row.
This customer has
Perhaps the RECORD stuff would help you? It's poorly documented, but
you could look at the code for SRFs to see how to use it.
regards, tom lane
Ok, RECORD was a keyword, thank you. But I have questions:
1 What do you mean SRF? Set Return Function?
2 Some example I found in contrib/tablefunc,
Nigel J. Andrews wrote:
On Mon, 9 Jun 2003, Tom Lane wrote:
Josh Berkus [EMAIL PROTECTED] writes:
Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the
option that's supposed to let you turn off Inserting missing FROM clause for
table ...
Bruce hasn't
Nigel J. Andrews wrote:
How do people feel about changing matching for host and hostssl to be such that
a plain host line in pg_hba.conf does not allow a SSL connection but requires
the hostssl specifier?
I had been going to submit a very small patch to do this but then it occurred
to me
Justin Clift wrote:
Tom Lane wrote:
Josh Berkus [EMAIL PROTECTED] writes:
wal_debug is seldom used outside of Postgresql source development or unusual
system failures, and should therefore go last.
BTW, it occurs to me that wal_debug is one of the hacker-only variables
that probably ought not be
Jan,
No, not documenting it IS a good move.
I couldn't disagree more. Undocumented options? Who are we, Microsoft?
If there's a button people will
press it, if there's a switch people will turn it on and if there's a
slot people will stick in whatever they have ... believe it or
Hi folks,
We recently built a dual K8D-based Opteron box running Linux in 64-bit
mode (Debian 'testing' distribution with newly compiled binutils, gcc,
and various support libraries for amd64 architecture).
The Postgres 7.3.3 port was simply a matter of setting the appropriate
flags to take of
Teodor Sigaev wrote:
Ok, RECORD was a keyword, thank you. But I have questions:
1 What do you mean SRF? Set Return Function?
It refers to functions returning one or more tuples. From a practical
standpoint, it is a function that is (and must be) used in the FROM
clause like a table (hence also
Tom Lane writes:
1. Do we want to someday allow groups to have groups as members? (Seems
reasonable to me.)
I agree.
2. Are there any other differences between groups and roles? (I'm not
sure about this one.)
One other difference I found is that roles can be enabled or disabled (as
Hans-Jürgen Schönig writes:
Imagine having groups having rights on dozens of tables. If these groups
were assigned to a role it would be an easy task to block numerous
groups from executing SQL at once. Currently a user has all rights of
all groups he belongs to so it is damn hard to say that
Dennis Björklund writes:
When you run psql with a different language then english the strings are
usually in a character set that is not pure ascii. For example to
represent swedish you need either latin1 or unicode. Therefor the po file
for swedish is in latin1.
Yes, you need to set your
Okay, separate documentation might work ;-)
Jan
Josh Berkus wrote:
Jan,
No, not documenting it IS a good move.
I couldn't disagree more. Undocumented options? Who are we, Microsoft?
If there's a button people will
press it, if there's a switch people will turn it on and if there's a
Can you send us a patch?
---
Martin D. Weinberg wrote:
Hi folks,
We recently built a dual K8D-based Opteron box running Linux in 64-bit
mode (Debian 'testing' distribution with newly compiled binutils, gcc,
and
Can you send in a report for the supported platforms list?
http://developer.postgresql.org/docs/postgres/supported-platforms.html
Robert Treat
On Tue, 2003-06-10 at 13:16, Martin D. Weinberg wrote:
Hi folks,
We recently built a dual K8D-based Opteron box running Linux in 64-bit
mode (Debian
Peter Eisentraut [EMAIL PROTECTED] writes:
Another issue is that users and roles share a namespace. We might have to
deal with that sometime, but it's not a problem as far as the information
schema is concerned.
I've been thinking for awhile that the ACL code would be simplified if
userids
It would be nice to merge them, but with Unix having separate
namespaces, I am not sure it is a good idea to diverge from that.
---
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Another issue is that users
Bruce,
I didn't change the source tree at all. I used:
env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX
--without-zlib
with the experimental gcc and bintils from www.x86-64.org. I needed
--without-zlib because I don't have a 64 bit compile yet for zlib.
make
make
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We are 5 days away from the feature freeze date, but with the almost
week of downtime we have had, I don't think we can stick to that date.
Do we choose July 1 as feature freeze and July 15 as beta, or push beta
start to Auguest 1?
Well it
[EMAIL PROTECTED] wrote:
[ There is text before PGP section. ]
[ PGP not available, raw data follows ]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We are 5 days away from the feature freeze date, but with the almost
week of downtime we have had, I don't think we can stick to that date.
On Tue, 10 Jun 2003, Peter Eisentraut wrote:
we should try to keep the (translated) column headers within the client,
to side-step this issue. Do you want to investigate that?
That is the obvious solution, there is no real need to send the strings to
the server in the first place.
The
Tom,
I'm noticing re-namining of a lot of GUCs. As far as I can tell, the
re-naming is based on logical reasons -- for example, log_hostname is more
accurate that hostname_lookup -- but was a little surprised. We'd better
warn users who are upgrading
--
-Josh Berkus
Aglio Database
Tom,
Also, Autocommit seems to be gone from postgresql.conf.sample. Was this
intentional?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
Josh Berkus [EMAIL PROTECTED] writes:
Also, Autocommit seems to be gone from postgresql.conf.sample. Was this
intentional?
Yes. It's toast ... didn't you see that flamewar a couple months ago?
regards, tom lane
---(end of
Tom,
Yes. It's toast ... didn't you see that flamewar a couple months ago?
Nope, missed it. There's enough traffic on this list that I ignore anything
that I'm not working on.
So are we eliminating the autocommit GUC entirely, or just from
postgresql.conf?
(I never used the setting,
Martin D. Weinberg [EMAIL PROTECTED] writes:
I didn't change the source tree at all. I used:
env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX
--without-zlib
BTW, see Jeff Baker's nearby report in pgsql-general that s_lock.h needs
to be tweaked to use spinlocks on
Josh Berkus [EMAIL PROTECTED] writes:
So are we eliminating the autocommit GUC entirely, or just from
postgresql.conf?
Entirely --- putting it on the server side was a bad mistake, in
hindsight. The functionality is better provided on the client side.
(The GUC var does still physically
So are we eliminating the autocommit GUC entirely, or just from
postgresql.conf?
It's a client side feature now. Completely gone from the server.
--
Rod Taylor [EMAIL PROTECTED]
PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
Folks,
Revised ordering of options, based on information and suggestions received
here on both mailing lists.
--
-Josh Berkus
__AGLIO DATABASE SOLUTIONS___
Josh Berkus
Complete information technology [EMAIL PROTECTED]
Folks,
Is there an idiot's guide to our SGML format somewhere? I'm new to updating
the actual Postgresql docs, and new to SGML in general.
I'm trying to figure out how to add a sub-title and sub-section within a
section. Or something similar.
--
-Josh Berkus
Aglio Database Solutions
San
On Tue, 2003-06-10 at 17:52, Josh Berkus wrote:
Folks,
Is there an idiot's guide to our SGML format somewhere? I'm new to updating
the actual Postgresql docs, and new to SGML in general.
I'm trying to figure out how to add a sub-title and sub-section within a
section. Or something
Hi,
could somebody explain me please why following select
SELECT docid FROM prod.guids
GROUP BY docid HAVING( COUNT(docid) 1 )
taking 15 min on 2 Proc Box on 1M rows, where number of duplicates
around 300K,
and docid indexed and not null and char(16).
May be I am doing something wrong?
'k, someone please test ... should all be setup now and 'auto-updating'
hourly ...
On Tue, 10 Jun 2003, Bruce Momjian wrote:
[EMAIL PROTECTED] wrote:
[ There is text before PGP section. ]
[ PGP not available, raw data follows ]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We are
On Tue, 10 Jun 2003, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
We are 5 days away from the feature freeze date, but with the almost
week of downtime we have had, I don't think we can stick to that date.
Do we choose July 1 as feature freeze and July 15 as beta, or push beta
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
'k, someone please test ... should all be setup now and 'auto-updating'
hourly ...
Not quite there yet:
$cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot login
Logging in to :pserver:[EMAIL PROTECTED]:2401/projects/cvsroot
CVS password:
cvs
you have to give it a password ... any password, but a password non the
less ... someone else asked me this also, and if I enter no passwd, I can
get the same error message ...
On Wed, 11 Jun 2003 [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
'k, someone please
On Wed, 11 Jun 2003 12:10 pm, The Hermit Hacker wrote:
you have to give it a password ... any password, but a password non the
less ... someone else asked me this also, and if I enter no passwd, I can
get the same error message ...
The reason for the confusion might be because here:
Moving to -hackers.
Unfortunately, having all my users run contrib/adddepend isn't an
option for me. However, that script does contain a good deal of
information that I may be able to use for detecting old-style foreign
key constraints in my own code.
I assume you're doing the database
On Tue, Jun 10, 2003 at 10:25:05PM -0400, Rod Taylor wrote:
I see that adddepend detects old-style foreign key constraints by
looking for groups of 3 triggers having 6 or more identical function
arguments. Is that the best way to do it?
That said, I've not heard of any issues with the
OK, feature freeze July 1, beta starts July 15.
---
The Hermit Hacker wrote:
On Tue, 10 Jun 2003, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
We are 5 days away from the feature freeze date, but with the
Tom Lane wrote:
The recent change to make log_min_messages SUSET provokes the following
behavior:
$ export PGOPTIONS=-d 5
$ psql
psql: FATAL: 'log_min_messages': permission denied
$
Considering that I *am* superuser, this is quite unacceptable.
If you don't want to revert the change,
Sorry, I forgot --- this should have gone only to patches.
---
Bruce Momjian wrote:
Tom Lane wrote:
The recent change to make log_min_messages SUSET provokes the following
behavior:
$ export PGOPTIONS=-d 5
$
Hi,
I'm new in this mailing list and in the world of
PostGreSQL.
I need to create a C++ application under Windows which
will use a very huge database...
I was thinking that PostgreSQL could help me to reduce
the cost of a such software. But i would like to know
what is the status of the
57 matches
Mail list logo
