As a rule of thumb, online applications that hold open
transactions during user interaction are considered to be
Broken By Design (tm). So I'd slap the programmer/design
team with - let's use the server box since it doesn't contain
anything useful.
Many
Just thought that I'd tell you.
I've been waiting (very patiently, I think) for a long time for outre joins,
views w/ joins and not the least, functions that can handle NULL's in an
orderly way.
A little anxious I started implementing these elements in my projects,
removing the workarounds
Todo:
1. Compact log files after checkpoint (save records of uncommitted
transactions and remove/archive others).
On the grounds that undo is not guaranteed anyway (concurrent heap access),
why not simply forget it, since above sounds rather expensive ?
The downside would only be, that
Why not like Interbase ?
when you define a procedure in Interbase, you have the 'suspend'
instruction,
it suspend execution of the stored procedure and returns variables, then
come back to the procedure.
select * from myfunc('ba ba');
select mycol from myfunc('dada');
escuse my poor english
Title: select for update question
Hello,
As I understand it:
Issuing a select for update within a transaction will prevent other users from modifying data. (exclusive lock)
Im contemplating using the DBI interface as a permanent client to postgres for a group of users, and have a few
Hi All again,
after I deleted the null row from carname:
SELECT DISTINCT h_name
FROM haszon
WHERE h_name NOT IN (SELECT cn_name FROM carname)
+---+
| h_name|
+---+
| DAEWOO-FSO|
| DAEWOO-LUBLIN |
| GAZ |
| TATA |
+---+
Query
Why not like Interbase ?
when you define a procedure in Interbase, you a the 'suspend' instruction,
it suspend execution of the stored procedure and returns variables, then
come back to the procedure.
select * from myfunc('ba ba');
select mycol from myfunc('dada');
escuse my poor english :)
Hi,
Tom Lane wrote:
John Reid [EMAIL PROTECTED] writes:
Ugh. Don't overload pg_class with things that are not tables. I see no
reason that either pg_class or pg_attribute should be involved in the
definition of a domain. Make new system tables if you need to, but
don't confuse the
I know this is not an on-topic post, but I wanted my message to reach the
right people.
I want to thank all of you who have worked so hard to make Postgres such an
excellent database. Since people tend to complain a lot, I thought it might
be nice to share some good news...
I have just
Definitely it's Oracle's syntax.
Zeugswetter Andreas SB [EMAIL PROTECTED] ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:[EMAIL PROTECTED].
at...
Explicit cursor can be declared as:
DECLARE
...
curname CURSOR [(argname type [, ...])]
Gabor -
Tri-valued logic strikes again. Remember, NULL represents don't know,
which means could be anything. So, when you ask the system to return
values that are guaranteed not to be in a list, and that list contains
a NULL, the system returns nothing, since the NULL _could_ be equal to
the
On Mon, 21 May 2001, Gabor Csuri wrote:
Hi All again,
after I deleted the null row from carname:
SELECT DISTINCT h_name
FROM haszon
WHERE h_name NOT IN (SELECT cn_name FROM carname)
+---+
| h_name|
+---+
| DAEWOO-FSO|
| DAEWOO-LUBLIN |
| GAZ
ftp://ftp.postgresql.org/pub/source/v7.1.2 ...
Just want a second opinion before I announce more publicly ...
Thanks ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary:
Hi you all:
I´ve got some kind of a problem in the deploy of my perl client.
My environment is the following
Ihave a Solaris 7 web server in the internet, powered by apache and outside the local
net.
From it I can access, through a hole in the firewall to my PostgreSQL 7.0.2 (yes, I´d
better
broken how? I just connected into it ...
On Tue, 22 May 2001, Karl DeBisschop wrote:
The Hermit Hacker wrote:
ftp://ftp.postgresql.org/pub/source/v7.1.2 ...
Just want a second opinion before I announce more publicly ...
I'd check. But the postgresql ftp site appears to be broken
(This machine still is having trouble with mx records :( )
On Mon, 21 May 2001, Christopher Kings-Lynne wrote:
Actually this brings up a problem I'm having with ALTER TABLE ADD
CONSTRAINT and since it mostly affects you with DROP CONSTRAINT, I'll
bring it up here. If you have a table
Folks:
As I study the source of LockBuffer in bufmgr.c I came across
the following code snippet for the case of releasing a
shared (read) lock:
if (mode == BUFFER_LOCK_UNLOCK)
{
if (*buflock BL_R_LOCK)
{
(buf-r_locks)--;
if (!buf-r_locks)
*buflock = ~BL_R_LOCK;
Or I am missing something...
buflock is per-backend flag, it's not in shmem. Backend is
allowed only single lock per buffer.
Vadim
Has this been already fixed or reported?
-
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or
On Tue, May 22, 2001 at 12:19:41AM -0400, Bruce Momjian wrote:
This in fact has happened within ECPG. But since sizeof(bool) is passed to
libecpg it was possible to figure out which 'bool' is requested.
Another issue of C++ compatibility would be cleaning up the usage of
'const'
On Tue, May 22, 2001 at 05:52:20PM -0400, Bruce Momjian wrote:
On Tue, May 22, 2001 at 12:19:41AM -0400, Bruce Momjian wrote:
This in fact has happened within ECPG. But since sizeof(bool) is
passed to libecpg it was possible to figure out which 'bool' is
requested.
Another
We have a TODO item
* Update reltuples in COPY
I was just about to go do this when I realized that it may not be such
a hot idea after all.
Imho it is not a good idea at all. The statistics are a very sensitive area,
that imho should only be calculated on request. I already don't
As a rule of thumb, online applications that hold open
transactions during user interaction are considered to be
Broken By Design (tm). So I'd slap the programmer/design
team with - let's use the server box since it doesn't contain
anything useful.
We
Correct me if I am wrong, but both cases do present a problem currently
in 7.1. The WAL log will not remove any WAL files for transactions that
are still open (even after a checkpoint occurs). Thus if you do a bulk
insert of gigabyte size you will require a gigabyte sized WAL
REDO in oracle is done by something known as a 'rollback segment'.
You are not seriously saying that you like the rollback segments in Oracle.
They only cause trouble:
1. configuration (for every different workload you need a different config)
2. snapshot too old
3. tx abort because
Explicit cursor can be declared as:
DECLARE
...
curname CURSOR [(argname type [, ...])]
IS select_stmt;
In esql you would have FOR instead of IS.
DECLARE curname CURSOR ... FOR
Thus the question, where is the syntax
However, just remember that pg_class already has a row count that we
force in there by default.
I was just suggesting we make that accurate if we can, even if we can
make it accurate only 80% of the time. Once we INSERT, it isn't
accurate anymore anyway. This is just an estimate, and in
And, I cannot say that I would implement UNDO because of
1. (cleanup) OR 2. (savepoints) OR 4. (pg_log management)
but because of ALL of 1., 2., 4.
OK, I understand your reasoning here, but I want to make a comment.
Looking at the previous features you added, like subqueries, MVCC, or
On Mon, 21 May 2001, Peter Eisentraut wrote:
Tom Lane writes:
checking for libreadline ... no
checking for libedit ... no
*
* NOTICE: I couldn't find libreadline nor libedit. You will
* not have history support in psql.
*
This may be useful as well, but
Peter Eisentraut wrote:
http://www.postgresql.org/~petere/gettext.html
This is a compilation of the BSD-licensed gettext tools from NetBSD plus
some of my own code, put into a (hopefully) portable package, intended to
be evaluated for possible use in PostgreSQL. Give it a try if you're
On Wed, 23 May 2001, Christopher Kings-Lynne wrote:
Actually, I realized that in the face of multiple inheritance, dynamically
generated constraint names still fail with our current default naming
scheme. What happens when two tables both have a $1 and then you inherit
from both of
On Tue, 22 May 2001, Christopher Kings-Lynne wrote:
Anyone looked at this yet?
Also, if someone could tell me where I should attempt to add a regression
test and what, exactly, I should be regression testing it would be
helpful...
At the risk of making it even longer, probably
32 matches
Mail list logo