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 PostGreS
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
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 t
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
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> 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 existing documentation specifies that the password for anoncvs is
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
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 u
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:
http://d
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 pl
-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:
cv
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 pus
'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
> >
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?
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
> start to Auguest 1?
I don't think a
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 s
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
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]
> 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
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 ex
"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 spinlock
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, mys
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 broadcast)-
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
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
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 probl
[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 tha
-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
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 i
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?
--
Bruce Momjian| http://candle.pha.p
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 use
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
userid
One issue is that these settings don't even exist in most builds unless
you add compiler flags.
---
Josh Berkus wrote:
> Jan,
>
> > No, not documenting it IS a good move.
>
> I couldn't disagree more. Undocumented options
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 (Deb
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 va
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
slo
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
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 t
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
se
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 kn
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
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
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
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
>
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 ..."
> >
> >
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, a
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 custom
"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
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 wou
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 to
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 b
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
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
"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 to have a host entry that allowed bot
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 broadcast)
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 T
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 the
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
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 this was a good candidate for a
--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 an
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 optimization mutually exclusive;
>> -O disabled UX:acomp: ERROR: "pg_du
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 PRO
61 matches
Mail list logo
