Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I'm also wondering why the backend need have anything at all to do with
>> an improved function-definition mode. If you look in the archives you
>> will see speculation about inventing psql backslash commands that would
>> assist in e
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Bruce Momjian writes:
>> Is this a TODO item or something we want to address for 7.4?
> I'd like to address it for 7.4, but it looks a bit more difficult than it
> seemed at first, because session_user isn't in GUC at all, so there is no
> infrastruct
I've been looking at fixing the problem reported a few days ago whereby
a bucket split in a hash index messes up the state of concurrent scans
of the index, possibly causing some tuples to be missed by the scans.
AFAICS the only way to fix this is to prevent such a concurrent split.
Accordingly, I'
Yep, seems to be running again...
I had sevral crashes today...
On Sun, 31 Aug 2003, Marc G. Fournier wrote:
> Date: Sun, 31 Aug 2003 17:29:18 -0300 (ADT)
> From: Marc G. Fournier <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>,
> Larry Rosenman <[EMA
And I didn't grep / look far enough it actually is in that zone:
$ORIGIN fr.postgresql.org.
ftp A 194.250.190.252
ftp2A 130.79.200.5
ftp5CNAME mirrors.toulouse.inra.fr.
newsCNAME news.pyrenet.fr.
www
works here:
> nslookup ftp.fr.postgresql.org
Server: ganymede.hub.org
Address: 192.168.1.4
Non-authoritative answer:
Name:ftp.fr.postgresql.org
Address: 194.250.190.252
there was a problem earlier this morning though ... upgraded the OS on the
master DNS server and somehow /dev/null goe
Looks like Marc's script removed it
$ cd /var/adm/named/cache
$ grep ftp.fr postgresql.org
$ ls -l postgresql.org
-rw-r--r--1 root sys8517 Aug 31 14:50 postgresql.org
$ more postgresql.org
$ grep ftp.fr postgresql.org
$
$ head -20 postgresql.org
$ORIGIN .
$TTL 300; 5
Is there a problem with DNS? a few hours ago, www.fr.postgresql.org was
not defined, now that it works again, ftp.fr.postgresql.org dosn't exist
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE
Tom Lane writes:
> The JDBC guys wanted to know it. Why is not clear to me, but I figured
> it was easy enough to make them happy.
The JDBC guys didn't respond, and I don't see it used in their source
code, so I'm inclined to remove it.
--
Peter Eisentraut [EMAIL PROTECTED]
---
Tom Lane writes:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Tom Lane writes:
> >> One of the reasons for not doing conversion in binary mode is to have an
> >> escape hatch for unconvertible characters, eg for dump purposes.
>
> > That functionality is already provided by setting the clien
Carlos Guzman Alvarez writes:
> > The JDBC guys wanted to know it. Why is not clear to me, but I figured
> > it was easy enough to make them happy.
>
> I'm using it too in my .NET Data Provider for allow atomatic encoding of
> strings before send it to the server.
Why would you want to do that?
Bruce Momjian writes:
> Tom Lane wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > > Presumably, the "is_superuser" parameter was intended to make the updating
> > > of psql's prompt more accurate when SET SESSION AUTHORIZATION is used.
> > > However, if the prompt is customized to inclu
Frank Schoep writes:
> I'd be willing to write a Dutch translation for pgAdmin III,
For matters concerning pgAdmin III, please see its web site
http://www.pgadmin.org/pgadmin3/; there are separate mailing lists for it.
You're also invited to provide a translation for the core of PostgreSQL;
see
Hi Frank,
A Dutch translation of pgAdmin3 would be most welcome - thanks for
volunteering! You should find all the details of how to get started at
http://www.pgadmin.org/pgadmin3/translation.php, if not, please email
the [EMAIL PROTECTED] list (not pgsql-hackers) with any
queries. Jean-Michel Pou
On Sun, Aug 31, 2003 at 12:04:58PM +0200, Peter Eisentraut wrote:
> Lee Kindness writes:
>
> > You don't... and you simply shouldn't care. If there is a_r version
> > available then we should use it - even if the plain version is "safe".
>
> The problem with this is that the automatic determinati
Manfred Spraul wrote:
It is strange to choose 50% of RAM plus swap (what if your spam is
small). I thought it would be 100% of RAM plus the swap that exceeds RAM
size.
Linux doesn't release the swap file page when a page is read back: If
a page is only read by the user space app, then the s
Tom Lane wrote:
I'm also wondering why the backend need have anything at all to do with
an improved function-definition mode. If you look in the archives you
will see speculation about inventing psql backslash commands that would
assist in entering raw function definitions by taking something you
Hello there,
I'd be willing to write a Dutch translation for pgAdmin III, if you are
interested in it. I'll give you the language details in advance:
English-language-name: Dutch
Native-language-name: Nederlands
Please let me know if it'd be a good thing to do and I'll start on it whenever
I fi
Hi all,
This is on 7.3.4
I had altered a user like this:
alter user set search_path = shema1,public
Then I had to pgdumpall, re-initdb and restore every thing.
The alter user did'nt get through. and broke my app.
Is it a pg_dump bug? I haven't tested on 7.4b
BTW, would'nt it be more logical if
Lee Kindness writes:
> You don't... and you simply shouldn't care. If there is a_r version
> available then we should use it - even if the plain version is "safe".
The problem with this is that the automatic determination (in configure)
whether there is a xxx_r() version is, in general, fragile.
Bruce Momjian writes:
> Marc G. Fournier wrote:
> > On Sat, 30 Aug 2003, Bruce Momjian wrote:
> >
> > > Yes, and that is the complex part because _some_ non-*_r functions are
> > > thread-safe, and some are not. I have to determine if we have other
> > > such platforms before I figure out h
Stephan Szabo wrote:
I rebuild without debug, and ran just the start/insert/commit sequence
over and over and noticed that on my machine it looked to grow as above
but that if I let it go long enough it seemed to basically stop (or at
least the growth was slow enough to go without notice as compar
> It would be nice if we could configure a function to run on connection
> start. We have the ability to SET values per db or user, but not to
If my memory serves me well, Oracle has a number of system triggers. On
database startup and shutdown and perhaps also on connection start and stop.
Som
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Given that rbt is the owner of the object, I'm not sure that it is
>> sensible to interpret the above as revoking his ability to grant
>> privileges to others.
>>
>> Peter, any thoughts?
> Has this been resolved?
No. I was hoping Pet
Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM PUBLIC;
> > REVOKE
> > r=# GRANT ALL ON FUNCTION weekdate (date) TO PUBLIC;
> > GRANT
> > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM rbt;
> > ERROR: dependent privileges exist
> > HINT
Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Presumably, the "is_superuser" parameter was intended to make the updating
> > of psql's prompt more accurate when SET SESSION AUTHORIZATION is used.
> > However, if the prompt is customized to include the user name (%n), then
> > t
On Sat, 30 Aug 2003, Stephan Szabo wrote:
> On Sat, 30 Aug 2003, Tom Lane wrote:
>
> > =?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes:
> > > The interesting thing was that my postmaster needed around 4mb of RAM
> > > when I started running my test script using ...
> > > After
On Sat, 30 Aug 2003, Tom Lane wrote:
> =?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes:
> > The interesting thing was that my postmaster needed around 4mb of RAM
> > when I started running my test script using ...
> > After about 2 1/2 hours the backend process already needed 1
28 matches
Mail list logo
