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 alter_
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
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.
> >
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 termin
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
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 usef
> > 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,
> (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
-
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
> > 'cons
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)
{
Assert(buf->r_l
(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 tabl
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
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
> > 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,
We can set flag in ItemData and register callback function in
buffer
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: scrappy@{freeb
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-LUBL
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
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 [, .
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 finish
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
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 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 O
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)
I’m contemplating using the DBI interface as a permanent client to postgres for a group of users, and have a few
Hi All ,
SELECT DISTINCT h_name FROM haszon;
+---+
| h_name|
+---+
| CITROEN |
| DAEWOO-FSO|
| DAEWOO-LUBLIN |
| FIAT |
| FORD |
| GAZ |
| HYUNDAI |
| KIA |
| MAZDA |
| MERCEDES BENZ |
| MITSUBISHI|
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
> 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
> Explicit cursor can be declared as:
>
> DECLARE
> ...
> curname CURSOR [(argname type [, ...])]
> IS ;
In esql you would have FOR instead of IS.
DECLARE curname CURSOR ... FOR
Thus the question, where is the syntax from
> 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, tha
> 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 ro
> 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
> dire
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 an
> 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.
W
> >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 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'
34 matches
Mail list logo
