[EMAIL PROTECTED] (Andrew Dunstan) writes:
> We don't have the luxury of being able just to throw out old stuff
> because we think it might be neater to do it another way. The current
> rules for HBA are order dependent. The issue raised as I understood it
> was not to invent a new scheme but to b
[EMAIL PROTECTED] (Tom Lane) writes:
> If your pg_hba.conf looks like
> hostall all 0.0.0.0/32 md5
> there's not much call to update it dynamically ...
There's one case, where .pgpass got hosed, and you didn't have a
backup of it, and need to assign new passwords...
I once
[EMAIL PROTECTED] (Dhanaraj M - Sun Microsystems) writes:
> Hi all,
>
> I have recented joined and working on postgres. I fixed a bug that I
> saw in the mailing list. I ran the regression test that is available
> in postgres. It was successful and now I need the following details..
>
> 1) Test su
[EMAIL PROTECTED] ("Markus Bertheau") writes:
> 2006/3/17, Bruce Momjian :
>> Peter Eisentraut wrote:
>> > Bruce Momjian wrote:
>> > > The psql manual pages for 8.1 now has:
>> >
>> > > \set HISTFILE ~/.psql_history- :DBNAME
>
> Any reason psql doesn't do this by default? It is clear
[EMAIL PROTECTED] (Greg Stark) writes:
> Christopher Browne <[EMAIL PROTECTED]> writes:
>
>> Letter of Invitation for Countries Whose Citizens Require a
>> Temporary Resident Visa to Enter Canada
>
> I missed that this was happening up here in Canada. How exclusive is
> the guest list for this?
oleg@sai.msu.su (Oleg Bartunov) writes:
> I'd need an invitation to get a visa. Is't possible ?
"Certainty" is difficult to promise, but there is a reasonable
population of relevant people here such that invitations can be
arranged.
In view of the fact that it can take a fair bit of time to arran
[EMAIL PROTECTED] (Robert Treat) writes:
> On Tuesday 14 February 2006 16:00, Martijn van Oosterhout wrote:
>> > I would like to suggest that we increase substantially the FAQ entries
>> > relating to patch submission. By we, I actually mean please could the
>> > committers sit down and agree some
kleptog@svana.org (Martijn van Oosterhout) writes:
> On Sat, Feb 04, 2006 at 01:54:52AM +0100, Peter Eisentraut wrote:
>> I took a first swing at this and rearranged some of these calls.
>
>> ld -- On AIX at least this seems to be some magic library but doesn't
>> have an obvious testable symbol.
[EMAIL PROTECTED] ("Mark Woodward") writes:
> The "port" aspect is troubling, it isn't really self
> documenting. The application isn't psql, the applications are custom
> code written in PHP and C/C++.
Nonsense. See /etc/services
> Using the "/etc/hosts" file or DNS to maintain host locations f
[EMAIL PROTECTED] (Tom Lane) writes:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> Hmm, yeah, sounds useful. There's one implementation issue to notice
>> however, and it's that the autovacuum process dies and restarts for each
>> iteration, so there's no way for it to remember previous state un
[EMAIL PROTECTED] (Alvaro Herrera) writes:
> Chris Browne wrote:
>
>> It strikes me as a slick idea for autovacuum to take on that
>> behaviour. If the daily backup runs for 2h, then it is quite futile
>> to bother vacuuming a table multiple times during that 2h period wh
matthew@zeut.net ("Matthew T. O'Connor") writes:
> Legit concern. However one of the things that autovacuum is supposed to
> do is not vacuum tables that don't need it. This can result in an overal
> reduction in vacuum overhead. In addition, if you see that autovacuum is
> firing off vacuum com
[EMAIL PROTECTED] writes:
> On Thu, Jan 19, 2006 at 09:37:12AM -0500, Pollard, Mike wrote:
>> Martijn van Oosterhout wrote:
>> > Please provides natural keys for any of the following:
>> > - A Person
>> > - A phone call: (from,to,date,time,duration) is not enough
>> > - A physical address
>> > - A
Lukas Smith <[EMAIL PROTECTED]> writes:
> Bruce Momjian wrote:
>
>> * Flush cached query plans when the dependent objects change,
>>when the cardinality of parameters changes dramatically, or
>>when new ANALYZE statistics are available
>
> Wouldn't it also make sense to flush a
[EMAIL PROTECTED] (Gustavo Tonini) writes:
> But, wouldn't the performance be better? And wouldn't asynchronous
> messages be better processed?
Why do you think performance would be materially affected by this?
The MAJOR performance bottleneck is normally the slow network
connection between serv
[EMAIL PROTECTED] (Gustavo Tonini) writes:
> What about replication or data distribution inside the backend. This
> is a valid issue?
I'm not sure what your question is...
--
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http://www.ntlug.org/~cbbrowne/x.html
"Love is like a snowmobi
[EMAIL PROTECTED] (Gavin Sherry) writes:
> Hi,
>
> On Tue, 14 Nov 2005 [EMAIL PROTECTED] wrote:
>
>> > Gavin Sherry:
>> > Grouping sets
>> > Recursive queries
>>
>> The recursive queries is a long-awaited feature. Does the fact that
>> the feature is listed for Gavin Sherry mean th
[EMAIL PROTECTED] (Tom Lane) writes:
> The 8.1 supported-platforms list is looking pretty good, I think -- we
> don't have updates for every single combination of OS and hardware,
> but we have updates for every OS and at least one instance of all
> supported CPU types.
Not to pester overly...
AI
[EMAIL PROTECTED] (Alvaro Herrera) writes:
> Chris Browne wrote:
>> [EMAIL PROTECTED] ("Jim C. Nasby") writes:
>>
>> > On Tue, Nov 01, 2005 at 11:23:55AM -0300, Alvaro Herrera wrote:
>> >> Tom Lane wrote:
>> >> > "Jim C. Na
[EMAIL PROTECTED] ("Jim C. Nasby") writes:
> AFAIK they're not using subtransactions at all, but I'll check.
Are they perchance using pl/PerlNG?
We discovered a problem with Slony-I's handling of subtransactions
which was exposed by pl/PerlNG, which evidently wraps its SPI calls
inside subtransac
[EMAIL PROTECTED] ("Jim C. Nasby") writes:
> On Tue, Nov 01, 2005 at 11:23:55AM -0300, Alvaro Herrera wrote:
>> Tom Lane wrote:
>> > "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
>> > > AFAIK they're not using subtransactions at all, but I'll check.
>> >
>> > Well, yeah, they are ... else you'd neve
[EMAIL PROTECTED] (Tom Lane) writes:
> Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
>> hmm well -HEAD(and 8.0.4 too!) is broken on AIX 5.3ML3:
>> http://archives.postgresql.org/pgsql-hackers/2005-10/msg01053.php
>
> [ shrug... ] The reports of this problem have not given enough
> information t
[EMAIL PROTECTED] (Andreas Pflug) writes:
> Tom Lane wrote:
>> Andreas Pflug <[EMAIL PROTECTED]> writes:
>>
>>> So postmaster doesn't clean up pg_listener,
>> It never has. If you're complaining about this patch
>> http://archives.postgresql.org/pgsql-committers/2005-10/msg00073.php
>> you ought t
[EMAIL PROTECTED] (Hannu Krosing) writes:
> It also seems that Slony can be modified to not use LISTEN/NOTIFY in
> high load situations (akin to high performance network cards, which
> switch from interrupt driven mode to polling mode if number of packets
> per second reaches certain thresolds).
Y
[EMAIL PROTECTED] ("Marc G. Fournier") writes:
> On Mon, 26 Sep 2005, Josh Berkus wrote:
>
>> Tom,
>>
>>> Or, as you say, we could take the viewpoint that there are commercial
>>> companies willing to take on the burden of supporting back releases, and
>>> the development community ought not spend
[EMAIL PROTECTED] (Steve Atkins) writes:
> We started our upgrade from 7.2 to 7.4 about 20 months ago and finished it
> about 10 months ago, skipping 7.3 entirely.
We did similar; there was only one system deployed in a timeframe
where 7.3 was relevant, and the "big systems" skipped over 7.3 much
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
> Hans-Jürgen Schönig wrote:
>> no because a new is not a heap ...
>
> Why not use a function with a temporary table?
>
> That way you can pass a table parameter that
> is the temporary table with a select statement
> that you can populate the temp tabl
[EMAIL PROTECTED] (huaxin zhang) writes:
> not sure where to put this.
>
> I run two queries:
>
> 1. select count(*) from table where indexed_column<10;
> 2. select * from table where indexed_column<10;
>
> the indexed column is not clustered at all. I saw from the trace
> that both query runs th
[EMAIL PROTECTED] (Alvaro Herrera) writes:
> On Tue, Aug 30, 2005 at 12:45:18PM -0400, Chris Browne wrote:
>> [EMAIL PROTECTED] ("David Parker") writes:
>> > The slony log trigger saves execution plans, so any given
>> > connection that has been used with a
[EMAIL PROTECTED] ("David Parker") writes:
> The slony log trigger saves execution plans, so any given connection
> that has been used with a slony schema installed will have cached OIDs
> referring to the sl_log_1 table. When you drop the schema, those OIDs
> obviously go away. When you re-create
[EMAIL PROTECTED] (Alvaro Herrera) writes:
> Or, slightly different, what are people's most wanted features?
- Vacuum Space Map - Maintain a map of recently-expired rows
This allows vacuum to target specific pages for possible free
space without requiring a sequential scan.
- Deferrable
[EMAIL PROTECTED] (Alvaro Herrera) writes:
> On Thu, Aug 25, 2005 at 02:45:02PM -0700, Joshua D. Drake wrote:
>>
>> >If y'all would like, I can eliminate the anti-virus/anti-spam checks and
>> >just let it all go through though ... *evil grin*
>>
>> Would not bother me in the least. I have prote
Just ran into a fascinating edge case. One of our folks was building
a stored function, and ran into an odd error when trying to COPY to
stdout.
Here's a characteristic example:
create or replace function build_table (integer) returns integer as '
begin
execute ''copy foo to stdout;'';
retur
Christopher Browne <[EMAIL PROTECTED]> writes:
> There are essentially four choices:
Aside:
I suppose there are as many possible choices as there are bytecode
compiled systems out there. One could consider Icon, CLISP, Python,
PHP, OCAML, CMU/CL, all of which have bytecode compilers.
But none o
[EMAIL PROTECTED] (Stephen Frost) writes:
> * Tom Lane ([EMAIL PROTECTED]) wrote:
>> I think most of the real advantages of bug trackers that have been
>> mentioned in this thread have to do with history and searchability.
>> We have the raw info for that, in the pgsql-bugs and
>> pgsql-commmitters
[EMAIL PROTECTED] (Russell Smith) writes:
> Because it's not the hub of PostgreSQL development. I think it will
> be difficult to build a culture of "This" is the place to be unless
> we actually kill gborg totally. Currently there are still projects
> there, I'm personally never sure where to lo
The Slony-I team is proud to present the 1.0.4 release of the most
advanced replication solution for the most advanced Open Source
Database in the world.
The release tarball is available for download
http://developer.postgresql.org/~wieck/slony1/download/slony1-1.0.4.tar.gz
There are a limite
[EMAIL PROTECTED] (Yann Michel) writes:
> On Fri, Oct 08, 2004 at 10:09:18AM +0100, Dave Page wrote:
>> I think what Reini was asking was why do you think you need bitmap
>> indexes as opposed to any existing type?
>
> due to I'm developing a datawarehousing application we have lots of
> fact-data
[EMAIL PROTECTED] (Josh Berkus) writes:
>> > Lots of people have talked about it but I don't know anyone coding it.
>
> I would love to have bitmap indexes in Postgres, as would a lot of other
> community members. However, they are far from trivial to code. Are you
> offering to help?
I'm cur
[EMAIL PROTECTED] (Darcy Buskermolen) writes:
> On September 30, 2004 05:55 pm, Bruce Momjian wrote:
>
> To me it looks like all you need to do is add -pthreads or maybe
> -lpthreads depending on exact system to your compile line..
-lpthreads does the trick, indeed. (-lpthread also does the job,
[EMAIL PROTECTED] (Bruce Momjian) writes:
> Have you tried using cc_r for that compile line? Does that help?
Alas, that is not an option available.
cc_r is specific to the AIX "xlc" compiler; we're using GCC, and xlc
is not available to us.
bash-2.05a$ gcc -v
Reading specs from /usr/local/lib/g
We have discovered an interesting locking scenario with Slony-I that
is pointing to a use for the ability to exclude certain schemas from
pg_dump.
The situation is that when a "full" pg_dump kicks off, a Slony-I
"create sync" event, which expects to "LOCK slony_schema.sl_event;",
is blocked from g
[EMAIL PROTECTED] (Rod Taylor) writes:
> On Sun, 2004-09-05 at 13:43, Tom Lane wrote:
>> Rod Taylor <[EMAIL PROTECTED]> writes:
>> > collect2: ld returned 254 exit status
>>
>> That's a fairly unhelpful error message, isn't it?
>>
>> I'm thinking that this may be due to having added the timezone
I have a table that has a candidate primary key (e.g. - unique, not
null) that I wish to actually assert _is_ a primary key.
Is there a way to do that without too much (mwahahhaha! fiddling with
pg_class!!!) trickery?
--
(format nil "[EMAIL PROTECTED]" "cbbrowne" "acm.org")
http://cbbrowne.com/in
[EMAIL PROTECTED] (chinni) writes:
> Postgres-R is a multi server (write anywhere) replication tool
> which is possibly important for any enterprise if they want to shift
> to postgres.
>
> Did you guys debate on merging it.
I seem to recall there being a licensing issue; Postgres-R uses the
I just had a thought; was looking at a script where I'd rather invoke
using psql than using a Perl module (since Pg/DBD that might very well
not be available on AIX, HP/UX, Solaris, or such).
What would be very nice would be for there to be a psql command option
that would accept a "DSN" as oppose
"Santo Quartarone" <[EMAIL PROTECTED]> writes:
> What's the safest email browser?
less is pretty safe, more or less ;-).
You didn't specify what sort of platform you wanted to use; the
choices vary, considerably, between platforms.
--
(format nil "[EMAIL PROTECTED]" "cbbrowne" "cbbrowne.com")
ht
I was wanting to check out what was up with timezone handling with the
latest changes that were committed, as there had been some "biting" on
AIX.
To wit, notice the default time zone on one of our AIX boxes:
bash-2.05a$ date
Tue May 18 21:47:37 GDT 2004
bash-2.05a$ echo $TZ
CUT0GDT
bash-2.05a$
[EMAIL PROTECTED] ("Jim C. Nasby") writes:
> I would still argue that if any language should be installed by
> default it should be plpgsql and not java. As I mentioned, everyone
> using a database already knows SQL; not nearly as many know java.
A vital factor is indeed that pl/pgsql does not req
[EMAIL PROTECTED] (Dave Cramer) writes:
> Pl/J is a java procedural language for postgres. We are looking for
> alpha testers to help us find bugs, and get feedback.
>
> The project can be found at
>
> http://plj.codehaus.org/
>
> Bugs can be reported at
>
> http://jira.codehaus.org/secure/BrowsePr
We have encountered a pretty oddball situation involving an "unknown" type.
mydb=# select version();
version
-
[EMAIL PROTECTED] ("Marc G. Fournier") writes:
> On Thu, 1 Apr 2004, Christopher Kings-Lynne wrote:
>> > Is your timeline based on the assumption of doing all the work
>> > yourself? If so, how about farming out some of it? I'd be
>> > willing to contribute some effort to PITR. (It's been made c
[EMAIL PROTECTED] (Andrew Dunstan) writes:
> Karel Zak wrote:
>
>> Hi,
>>
>> in TODO is item: "* Allow dump/load of CSV format". I don't think
>> it's clean idea. Why CSV and why not something other? :-)
>>
>> A why not allow to users full control of the format by they own
>> function. It means som
I recently had the 'joy' of needing to compile a copy of 7.1, to
support a fairly crusty application where we'd have to do more testing
than we can justify in order to upgrade to some (vastly) newer
generation.
Ran into a couple of things worth mentioning:
1. Had a whole lot of gory problems due
"Greg Patnude" <[EMAIL PROTECTED]> writes:
> It would be really sweet in postgreSQL if we could apply the
> equivalent of a printf(columnname) to the table definition -- MS
> Access has what they call an "input mask" and it comes in really
> handy -- however -- I havent used Access for anthing seri
201 - 255 of 255 matches
Mail list logo