Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Bruce Momjian wrote:
Also, Andrew, on your other patch for log_session_info line, Magnus had
the idea of giving each session an id based on the first transaction of
the session.
I did think about using a cluster-wide se
Slavisa Garic <[EMAIL PROTECTED]> writes:
> ... I get the following error on Linux
> machine even if permissions on the data file are 777:
> _pg.error: ERROR: COPY command, running in backend with effective uid
> 26, could not open file '/home/slavisa/.nimrod/experiments/demo/ejdata'
> for
On Tue, 3 Feb 2004, Slavisa Garic wrote:
> My understanding is that COPY workes FROM 'filename' or STDIN where the
> last characters are '.\\n'. I tried using the copy from 'filename' and as
> I said NetBSD is not complaining where I get the following error on Linux
> machine even if permissions
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> Could you help me by suggesting where/how to update it (would it be in
> the CVS, or do you want me to just e-mail you/somebody the file?) and
> what format would work best (text, HTML, docbook).
Seems like the way to work this is to keep it on a webpage
Hi,
I have a question about the COPY statement. I am using PGSQL(7.3.4) with
python-2.3 on RedHat v8 machine. The problem I have is the following.
Using pg module in python I am trying to run the COPY command to populate
the large table. I am using this to replace the INSERT which takes about
fe
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Bruce Momjian wrote:
>> Also, Andrew, on your other patch for log_session_info line, Magnus had
>> the idea of giving each session an id based on the first transaction of
>> the session.
> I did think about using a cluster-wide sequence, if we can make
Steve,
the point is that PostgreSQL is no GNU product, never has been and if
someone intends to he shall do so after yanking out the contributions I
made.
Jan
Steve Tibbett wrote:
The suggested location is %ProgramFiles%\CompanyName\ProductName but GNU products often don't have a "company", so
On Mon, 2 Feb 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > any chance of having some kind of max_total_sort_mem setting to keep
> > machines out of swap storms, or would that be a nightmare to implement?
>
> I don't see any reasonable way to do that.
I didn't think th
> Shutdown of an idle postmaster used to take about two or three seconds
> (mostly due to the sync/sleep(2)/sync in md_sync). For the last couple
> of days it's taking more like a dozen seconds. I presume somebody broke
> something, but I'm unsure whether to pin the blame on bgwriter or
> Wind
On Mon, 2 Feb 2004, Augusto Cesar Castoldi wrote:
> How can I configure postgreSQL to search without acents?
>
> Is PostgreSQL have this support?
>
> I configured my locale to pt_BR, that support acents, create table with
> enconding "latin1", but nothing works. I know that I can use function
>
Yes,
I tried to initdb isso locale too.
Didnt worked, now my linux is configured with pt_BR, than in initdb
appers there, "using locale pt_BR"
Why it doesn't work? Did you tried it?
Is there something related with "Indexes" ? Do I need to create one? If
I create an Index, it will save the row
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> any chance of having some kind of max_total_sort_mem setting to keep
> machines out of swap storms, or would that be a nightmare to implement?
I don't see any reasonable way to do that.
regards, tom lane
-
On Mon, 2 Feb 2004, Tom Lane wrote:
> Jeff <[EMAIL PROTECTED]> writes:
> >> On Sat, 31 Jan 2004, Tom Lane wrote:
> > Well, maybe. What's in the back of my mind is that we may come
> > across other cases besides CREATE INDEX and VACUUM that should use a
> > "one-off" setting. I think it'd make mo
>Bruce Momjian
> Richard Huxton wrote:
> > On Wednesday 28 January 2004 00:38, Simon Riggs wrote:
> > > POSTGRESQL: Summary of Changes since last release (7.4.1)
> >
> > > All corrections and changes welcome...if this is well received,
then I
> > > will monitor pgsql-commiters to keep track of thin
Bruce Momjian wrote:
Also, Andrew, on your other patch for log_session_info line, Magnus had
the idea of giving each session an id based on the first transaction of
the session. That seems like a useful addition to that variable, though
I am not sure what value to give a session before it execu
Shutdown of an idle postmaster used to take about two or three seconds
(mostly due to the sync/sleep(2)/sync in md_sync). For the last couple
of days it's taking more like a dozen seconds. I presume somebody broke
something, but I'm unsure whether to pin the blame on bgwriter or
Windows changes.
Jeff <[EMAIL PROTECTED]> writes:
>> On Sat, 31 Jan 2004, Tom Lane wrote:
> Well, maybe. What's in the back of my mind is that we may come
> across other cases besides CREATE INDEX and VACUUM that should use a
> "one-off" setting. I think it'd make more sense to have one
> parameter than keep on i
Also, Andrew, on your other patch for log_session_info line, Magnus had
the idea of giving each session an id based on the first transaction of
the session. That seems like a useful addition to that variable, though
I am not sure what value to give a session before it executes its first
query.
-
How can I configure postgreSQL to search without acents?
Is PostgreSQL have this support?
I configured my locale to pt_BR, that support acents, create table with
enconding "latin1", but nothing works. I know that I can use function
"TO_ASCII", and "select like "t_s%".
Like:
Table test
Clumns:
Bruce Momjian wrote:
Andrew Dunstan wrote:
[redirecting to hackers]
If you like. I originally just made it happen if log_connections was
set, but Neil wanted a separate setting for it. What is the consensus
about a name?
log_disconnect?
Not bad. Maybe for symmetry "log_disconnectio
As you can see, I am trying to apply patches while I am on the road so I
am not able to put them in the queue and do the normal patch application
delays.
My goal is to apply when I know I am around to fix things in case they
break, and it seems to be working. When I return I will go back to my
no
Bruce Momjian <[EMAIL PROTECTED]> writes:
> As some know, win32 doesn't have sync, and some are concerned that sync
> isn't reliable enough during checkpoint anyway.
>
> The trick is to somehow record all files modified since the last
> checkpoint, and open/fsync/close each one.
Note that some p
Andrew Dunstan wrote:
> [redirecting to hackers]
>
> If you like. I originally just made it happen if log_connections was
> set, but Neil wanted a separate setting for it. What is the consensus
> about a name?
log_disconnect?
--
Bruce Momjian| http://candle.pha.pa.u
On Mon, Feb 02, 2004 at 11:45:10AM -0500, Steve Tibbett wrote:
> The suggested location is %ProgramFiles%\CompanyName\ProductName but
> GNU products often don't have a "company", so some projects use GNU as
> the company name.
FWIW, this is not a GNU project ...
--
Alvaro Herrera ()
Jajaja! Solo
Okay, I figured out what was the problem.
glibc's LC_COLLATE file under /usr/lib/locale/tr_TR
is wrong! And it has been wrong for many years now. And
nobody noticed it. PostgreSQL is innocent here.
I checked it many times over and over again with
test programs and different environment settings a
Okay, I figured out what was the problem.
glibc's LC_COLLATE file under /usr/lib/locale/tr_TR
is wrong! And it has been wrong for many years now. And
nobody noticed it. PostgreSQL is innocent here.
I checked it many times over and over again with
test programs and different environment settings a
The suggested location is %ProgramFiles%\CompanyName\ProductName but GNU products
(Boften don't have a "company", so some projects use GNU as the company name.
(B
(BI'd rather it was simply %ProgramFiles%\PostgreSQL myself.
(B
(B - Steve
(B
(B-Original Message-
(BFrom: Jan Wieck [m
Christopher Kings-Lynne wrote:
Hi guys,
In what version of Postgres did the pg_stat_activity view appear?
Must have been 7.2 as the tags in postmaster/pgstat.c only go back to
REL7_2_BETA1.
Jan
--
#==#
# It's easier to get forg
[redirecting to hackers]
If you like. I originally just made it happen if log_connections was
set, but Neil wanted a separate setting for it. What is the consensus
about a name?
cheers
andrew
Peter Eisentraut wrote:
Andrew Dunstan wrote:
This patch brings up to date what I did last year (
On Fri, Jan 30, 2004 at 07:41:18 -0800,
"Edwin S. Ramirez" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I need Postgres support for the following update syntax :
>
> update table1 set (col1, col2, col3) = (select f1, f2, f3 from table2
> where id=5) where rownum=3;
>
> update table1 set (col1, col2
Fabien COELHO <[EMAIL PROTECTED]> writes:
> It would make sense to ignore some alter/drop errors in pg_restore.
For the most part I think pg_restore should ignore *all* SQL errors and
try to keep plugging. This would more nearly emulate the behavior of
pg_dump SQL scripts, which is the older and
Steve Tibbett wrote:
I think users would prefer %ProgramFiles%\PostgreSQL - that's what Mozilla
and some other projects do, although still other projects do
%ProgramFiles%\GNU\PostgreSQL.
What would be the reason to put PostgreSQL into %ProgramFiles%\GNU ?
Jan
I'd vote for %ProgramFiles%\Postg
Tom Lane wrote:
> After looking at the code a bit, I think the simplest solution is for
> find_option to look in a separate mapping table (mapping from old to new
> option name) if it doesn't find the given name in the main table. This
> would make lookup of "old" names a shade slower than "prefer
Hello,
I think I have found a feature of pg_restore that may be a bug.
If the --clean option AND --dbname=database option are used with an
initially empty database, the restoration fails, although the very same
options with a "| psql database" works fine.
The internal psql with --dbname option
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> In what version of Postgres did the pg_stat_activity view appear?
7.2
-Neil
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> On Sat, 31 Jan 2004, Tom Lane wrote:
>
> > "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > > On Sat, 31 Jan 2004, Tom Lane wrote:
> > >> So, what I'd like to do is make btree index creation pay
> > >attention to> vacuum_mem instead of sort_mem, and rename the
> > >vacuum_mem parameter to> so
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
>
>
> Text sorting depends on strcoll() and nothing but. See varstr_cmp().
I see, apparently sort done for "ORDER BY" clause is case-sensitive.
But problem is still there. It is about "I"-with-dot and "I"-without-dot
in Turk
On Sat, 31 Jan 2004, Tom Lane wrote:
> Now, what should we call it instead? I haven't come up with any
> compelling thoughts --- the best I can do is "big_sort_mem" or
> "single_sort_mem". Surely someone out there has a better idea.
vacuuming and indexing are not too frequent database administ
Kurt Roeckx <[EMAIL PROTECTED]> writes:
> I had a discussion about time_t some weeks ago. There is nothing
> in the standard that says time_t must be a signed, all it says is
> that (time_t)(-1) represents an invalid value.
Don't get me started :-(
No sane person (certainly no one born before 19
On Fri, Jan 30, 2004 at 06:33:09PM +0100, BARTKO, Zoltan wrote:
> Having googled around I found this about Docbook to PDF conversion:
>
> http://www.linuxfocus.org/English/May2000/article152.shtml
>
> no sign of fop.
>
> I hope it helps and that I am not mistaken when I claim the format is
> doc
Hi guys,
In what version of Postgres did the pg_stat_activity view appear?
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Mon, Feb 02, 2004 at 01:57:15AM -0500, Tom Lane wrote:
> Claudio Natoli <[EMAIL PROTECTED]> writes:
> > Under Win32, localtime returns NULL for dates pre 1970.
>
> Count on Microsloth to get it wrong :-(
I had a discussion about time_t some weeks ago. There is nothing
in the standard that say
> I'd not recommend spending a lot of time on patching the existing code.
> Erroring out rather than crashing is probably sufficient.
Agreed.
This fixes the ones bugging me now. I'll provide others as I trip over them.
[Note: this'll mean some changes to the tests for Win32]
Cheers,
Claudio
Claudio Natoli <[EMAIL PROTECTED]> writes:
> Under Win32, localtime returns NULL for dates pre 1970.
Count on Microsloth to get it wrong :-(
> If we want to support pre-1970 dates, which I imagine we do, then this
> function requires some serious rework under Win32.
I think the long-term trend h
44 matches
Mail list logo
