> Modified Files:
...
> Some small polishing of Mark Hollomon's cleanup of DROP command: might
> as well allow DROP multiple INDEX, RULE, TYPE as well. Add missing
> CommandCounterIncrement to DROP loop, which could cause trouble otherwise
> with multiple DROP of items affecting same catalog entr
Tom Lane wrote:
> Philip Warner <[EMAIL PROTECTED]> writes:
> > At 01:01 23/10/00 -0400, Tom Lane wrote:
> >> (It's barely possible that we could get away with allowing
> >> triggers to be added or deleted mid-transaction, but that doesn't feel
> >> right to me.)
>
> > A little OT, but the above
At 01:37 23/10/00 -0400, Tom Lane wrote:
>
>What I'm proposing is that once an xact has touched a
>table, other xacts should not be able to apply schema updates to that
>table until the first xact commits.
Totally agree. You may want to go further and say that metadata changes can
not be made whi
Philip Warner <[EMAIL PROTECTED]> writes:
> At 01:01 23/10/00 -0400, Tom Lane wrote:
>> (It's barely possible that we could get away with allowing
>> triggers to be added or deleted mid-transaction, but that doesn't feel
>> right to me.)
> A little OT, but the above is a useful feature for managi
At 01:01 23/10/00 -0400, Tom Lane wrote:
>(It's barely possible that we could get away with allowing
>triggers to be added or deleted mid-transaction, but that doesn't feel
>right to me.)
>
A little OT, but the above is a useful feature for managing data; it's not
common, but the following sequen
Alex Pilosov <[EMAIL PROTECTED]> writes:
> On Mon, 23 Oct 2000, Tom Lane wrote:
>> begin;
>> select * from foo; -- gets AccessShareLock
>> LOCK TABLE foo; -- gets AccessExclusiveLock
>> ...
>> end;
>>
>> this will work currently because the SELECT releases AccessShareLock
>> when done,
On Mon, 23 Oct 2000, Tom Lane wrote:
> begin;
> select * from foo; -- gets AccessShareLock
> LOCK TABLE foo; -- gets AccessExclusiveLock
> ...
> end;
>
> this will work currently because the SELECT releases AccessShareLock
> when done, but it will deadlock if S
On Mon, 23 Oct 2000, Alex Pilosov wrote:
> On Mon, 23 Oct 2000, Tom Lane wrote:
>
> > when done, but it will deadlock if SELECT does not release that lock.
> >
> > That's annoying but I see no way around it, if we are to allow
> > concurrent transactions to do schema modifications of tables tha
Alex Pilosov <[EMAIL PROTECTED]> writes:
> I might be in above my head, but maybe this is time for yet another type
> of lock?
Wouldn't help --- it's still a deadlock.
regards, tom lane
On Mon, 23 Oct 2000, Tom Lane wrote:
> when done, but it will deadlock if SELECT does not release that lock.
>
> That's annoying but I see no way around it, if we are to allow
> concurrent transactions to do schema modifications of tables that other
> transactions are using.
I might be in above
Alex Pilosov <[EMAIL PROTECTED]> writes:
> I think this happens after I create/modify tables which reference this
> table. This is spontaneous, and doesn't _always_ happen...
Um. I was hoping it was something more easily fixable :-(. What's
causing the relcache to decide that the rel has been m
On Thu, 19 Oct 2000, Tom Lane wrote:
> Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> >> SELECT session_data, id
> >> FROM sessions
> >> WHERE id = ?
> >> FOR UPDATE
> >>
> >> I think part of my problem might be that sessions is a view
> >> and not a table,
>
> > Did you create an o
"Kevin O'Gorman" <[EMAIL PROTECTED]> writes:
> It's odd. I had already tried "8 Oct 2000 10:00:00 PDT" on one system
> (RedHat Linux 6.1), and it had worked. Today I'm building on a
> Caldera 2.3 system, and both the 00:00 and 10:00 builds fail.
Hm. Portability bug maybe? But I can't tell wit
"Kevin O'Gorman" <[EMAIL PROTECTED]> writes:
> For one thing, has anybody recently read the stuff that prints at the
> end of a 'make install'?
Yeah, it's pretty out-of-date. Someone or other had promised to update
it (Peter E. I think).
> For another the INSTALL document is a bit coy about wha
I think this happens after I create/modify tables which reference this
table. This is spontaneous, and doesn't _always_ happen...
Anything I could do next time it craps up to help track the problem down?
-alex
CREATE TABLE "customers" (
"cust_id" int4 DEFAULT nextval('customers_cus
Alex Pilosov <[EMAIL PROTECTED]> writes:
> I'm having the error 'relation modified while in use' fairly
> often. It is the same relation that's always giving a problem.
Hmm, could we see the full schema dump for that relation?
(pg_dump -s -t tablename dbname will do)
If you are not actively mod
Did you run make distclean? I've run regtests before committing changes.
Vadim
- Original Message -
From: "Patrick Welche" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 21, 2000 10:17 AM
Subject: [HACKERS] failed runcheck
> First a core dump which can be relieved
Having just installed a few times, and being new to it, I've
fallen in some holes the rest of you may not notice.
For one thing, has anybody recently read the stuff that
prints
at the end of a 'make install'? It gives three or so
pointers
to pages at postgresql.org, which pages do not exist, or
I'm having the error 'relation modified while in use' fairly
often. It is the same relation that's always giving a problem. Usually
after all currently-running backends die away with that error, error
disappears. If I shutdown, ipcclean, start up postgres, it also
disappears.
What causes this?
On Sun, 22 Oct 2000, Tom Lane wrote:
> Vince Vielhaber <[EMAIL PROTECTED]> writes:
> >> It's in the appendices of the developer's guide.
>
> > What developer's guide?
>
> http://www.postgresql.org/devel-corner/docs/postgres/
> has a developer's guide link ...
Hiding in plain sight. I must hav
Vince Vielhaber <[EMAIL PROTECTED]> writes:
>> It's in the appendices of the developer's guide.
> What developer's guide?
http://www.postgresql.org/devel-corner/docs/postgres/
has a developer's guide link ...
regards, tom lane
On Sun, 22 Oct 2000, Tom Lane wrote:
> Vince Vielhaber <[EMAIL PROTECTED]> writes:
> > Where is it in the programmer's manual?
>
> It's in the appendices of the developer's guide.
What developer's guide?
Vince.
--
==
Vi
Vince Vielhaber <[EMAIL PROTECTED]> writes:
> Where is it in the programmer's manual?
It's in the appendices of the developer's guide.
regards, tom lane
I thought it was there?
> On Sun, 22 Oct 2000, Bruce Momjian wrote:
>
> > No. I will add a mention to look on the programmer's manual for that
> > information.
>
> Where is it in the programmer's manual?
>
> Vince.
>
> >
> > > Larry Rosenman <[EMAIL PROTECTED]> writes:
> > > > How do I ch
On Sun, 22 Oct 2000, Bruce Momjian wrote:
> No. I will add a mention to look on the programmer's manual for that
> information.
Where is it in the programmer's manual?
Vince.
>
> > Larry Rosenman <[EMAIL PROTECTED]> writes:
> > > How do I check out the current tree?
> >
> > Up-to-date in
No. I will add a mention to look on the programmer's manual for that
information.
> Larry Rosenman <[EMAIL PROTECTED]> writes:
> > How do I check out the current tree?
>
> Up-to-date info is in
>
> http://www.postgresql.org/devel-corner/docs/postgres/anoncvs.htm
>
> (Hey Bruce, is this in th
I've already cc'd PeterE. I suspect we want the -lpq build to have
-lsocket (at least on THIS (unixware) platform.
Larry
* KuroiNeko <[EMAIL PROTECTED]> [001022 19:25]:
>
> Well, all in all, adding -lsocket is just enough. I was trying to compile
> /home/ed/t.c, which contains just PQconnectd
Shared libpq works for me. I bet you were getting tripped up
by some ENV vars I set globally...
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
PGP
Philip Warner <[EMAIL PROTECTED]> writes:
>> So you have to give the raw type name, no fancy fandangoes ...
> OK - I'll use typname in CREATE AGGREGATE, and see how it hangs together.
> Do you know if the type parser is invoked in function declarations? If not
> I probably just need to limit use
I couldn't find a link ANYWHERE on the site to this file. There are
hints about it's existence, but it ain't linked obviously anywhere...
Thanks!
LER
* Tom Lane <[EMAIL PROTECTED]> [001022 18:44]:
> Larry Rosenman <[EMAIL PROTECTED]> writes:
> > How do I check out the current tree?
>
> Up-to-
Larry Rosenman <[EMAIL PROTECTED]> writes:
> How do I check out the current tree?
Up-to-date info is in
http://www.postgresql.org/devel-corner/docs/postgres/anoncvs.htm
(Hey Bruce, is this in the Developer's FAQ?)
regards, tom lane
Ok, I can't find it on the web site
How do I check out the current tree?
(I want to play with Peter_E's changes...)
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Gar
Stephan Szabo wrote:
>
> On Fri, 20 Oct 2000, Hannu Krosing wrote:
>
> > I'm unable to find the complementary function to
> >
> > ALTER TABLE t ADD FOREIGN KEY(id) REFERENCES pkt(pk);
>
> Currently, ALTER TABLE ... DROP table constraint definition
> doesn't exist.
>
> > I would try DROP TRIGGE
At 18:33 21/10/00 +0700, Denis Perchine wrote:
>
>pg_dump --blob -Fc test3 -f test3.tar -v
>pg_restore test3.tar --db=test4 -v
>
Should work with current CVS sources now...
Philip Warner| __---_
Albatro
Bruce Hartzler <[EMAIL PROTECTED]> writes:
> (int2 & int4 will "fail" because of different error messages)
> (geometry "fails" because 0 != -0 for some reason)
See the documentation about platform-specific regress test comparison
files. You'll need to add entries to regress/resultmap. There may
72L;144L;216L;288L;360L;0L;Here's a patch to get postgresql up and running (I've only tested it on PB w/ dev tools but it should work on Darwin as well). It's very rough but I thought I'd put it up for those of you who are interested. If anyone has suggestions or help for some of the remaining issu
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > It seems some incompatible changes have been made between 7.0 and
> > current. In 7.0, if a parameter is NULL OR a null string (""), then
> > the value from an environment variable is applied. However in current
> > ONLY NULL is considered. Is there a
37 matches
Mail list logo
