> > It seems -S option for postmaster (detaching ttys) does not exist in
> > postgresql.conf. Is there any reason for this?
>
> It has been declared evil, because it loses the log output. Using shell
> redirection, or better yet pg_ctl is the way to go.
Really? I thought -S was evil because we h
I have a large list ot parameters and I'd like to have just one main
function for checking them all. Like so:
check_param(some_identifier_for_the_param, param_value)
...
rec RECORD;
...
select into rec check_param_function
from param_check_table
where id == identifier;
select re
I tried to find information in the lists but got no luck.
I want to make a client application that performs a query to show the
results, but the client application stays open and the database gets
updated.
I want that the updates of the database reflects on the open client
application, I think t
Well, I was interested in binary operators on integers
and as Peter suggested that I should look into it
myself, so I did it.
Choice of operators:
~ - not
& - and
# - xor - I like it :)
| - or
Things I am unsure of:
1) Precedence. I quite nonscientifically hacked in gram.y,
and could
As a question, since I don't have a source tree available here at work,
will there be an issue if an elog occurs between the various two user id
sets? Just wondering, because most of those statements are do some
SPI thing or elog.
Stephan Szabo
[EMAIL PROTECTED]
On Wed, 20 Sep 2000, Peter Eis
Tom Lane writes:
> Current ecpg sources will not build on a compiler that doesn't accept
> "long long int". They are also overly optimistic about the prospects
> of having strtoull() in libc. I think some autoconf work is needed
> here.
Will look.
--
Peter Eisentraut [EMAIL PROTECTED]
Thomas Lockhart writes:
> Peter, will you be doing more work on configuration? If so, could we
> implement --enable-australian-zones (or something similar) which sets
> the internal USE_AUSTRALIAN_RULES parameter?
Will do.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e
Tatsuo Ishii writes:
> It seems -S option for postmaster (detaching ttys) does not exist in
> postgresql.conf. Is there any reason for this?
It has been declared evil, because it loses the log output. Using shell
redirection, or better yet pg_ctl is the way to go.
--
Peter Eisentraut [EMA
Philip Warner writes:
> Doing the following:
>
> create table test (f1 int);
> create view v_test as select f1+1 as f11 from test;
> drop table test;
>
> then selecting from the view results in:
>
> ERROR: Relation 'test' does not exist
>
> which is fine.
If you peak into th
Here's what I've come up with to avoid "permission denied" errors when a
RI trigger has to lock a PK table. Whenever the SELECT FOR UPDATE is
executed I temporarily switch the current user id to the owner of the PK
table. It's not the grand unified solution via setuid functions that was
envision
I wanted to add a few features and fix a few bugs in the regression test
driver, and I ended up re-writing most of it. I'd like to offer it for
testing.
Features/fixes:
* Use one driver script for both standalone test and test against running
installation.
* Also use only one script for both
COPY tr FROM 'file' USING DELIMITERS '/';
Run-time exception error; current exception: RWBoundsErr
No handler for exception.
anyone can explain me?
Thanks.
Current ecpg sources will not build on a compiler that doesn't accept
"long long int". They are also overly optimistic about the prospects
of having strtoull() in libc. I think some autoconf work is needed
here.
regards, tom lane
(Cleaning up mail, and I don't see a reply to this...)
> Here are a few apparent discrepencies between pg7.0beta3 and the timezone
> documentation...
> 1) Unrecognized timezones claimed in the docs:
> ERROR: Bad timestamp external representation '1-1-2000 00:00:00 DST'
> ERROR: Bad timestamp e
Alfred Perlstein <[EMAIL PROTECTED]> writes:
> I posted earlier this week about a table of ours getting corrupted
> after some time. The table looks like this:
> ...
> After a while we get this crash apparently, followed by crashes of any
> backend that scans this table, not updating this specifi
* Alfred Perlstein <[EMAIL PROTECTED]> [000920 06:19] wrote:
> There's two tracebacks of crashed 7.0.2 backends at the end of this
> email.
Sorry, a couple more things I should have included:
I'm running with a ~256 shared memory segment:
DAEMON=/usr/local/pgsql/bin/postmaster
DATA=/vol/amrd0/d
This (invalid) query crashes the 7.0.2 backend:
auction=# SELECT (select max(b.lot)) as last_lot,auction_status(a.id) > 0 AS current,
a.lot, a.person_id, next_price(a.id), seller.mail AS seller_mail, buyer.mail AS
buyer_mail, seller.locale AS seller_locale, buyer.login AS buyer_login, num_bid(a
I've seen mention of this on the list, but I can't see it mentioned in TODO
from current CVS.
--- Forwarded Message
Date:Wed, 20 Sep 2000 11:17:52 +0200
From:Martijn van de Streek <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Bug#72084: Broken permissions required with fore
There's two tracebacks of crashed 7.0.2 backends at the end of this
email.
I posted earlier this week about a table of ours getting corrupted
after some time. The table looks like this:
details:
id | integer |
attr_type | varchar(32) |
attr_name | varchar(32) |
attr_vers |
19 matches
Mail list logo
