Thanks Harald, i'm running PostgreSQL 7.1.3.
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
ruben <[EMAIL PROTECTED]> writes:
Today, one of the processes running daily took 4 hours when it takes
about 5 minutes. After a VACCUM ANALYZE of the affected tables it took
the same to finish, then I
On Fri, 6 Aug 2004, Stephan Szabo wrote:
> On Fri, 6 Aug 2004, Tom Lane wrote:
>
> > Stephan Szabo <[EMAIL PROTECTED]> writes:
> > > It also looks like before triggers returning NULL can break them.
> >
> > Or a BEFORE trigger that overrides the attempted field update.
> >
> > > I think we'd been
Hello everyone.
Are there any recommended ways for doing postgresql replication?
Si Chen
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Fri, 6 Aug 2004, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > It also looks like before triggers returning NULL can break them.
>
> Or a BEFORE trigger that overrides the attempted field update.
>
> > I think we'd been worried about the added cost of doing the check when
> >
Stephan Szabo <[EMAIL PROTECTED]> writes:
> It also looks like before triggers returning NULL can break them.
Or a BEFORE trigger that overrides the attempted field update.
> I think we'd been worried about the added cost of doing the check when
> the average case doesn't have this problem but we
Cott Lang wrote:
The higher-ups are attempting to force me to run Postgres over NFS at
least temporarily.
Despite giving me a queasy feeling and reading quite a bit of messages
advising against it, running Oracle over NFS with a NAS filer doesn't
seem to be unusual. Is there a reason PG would be
Darkcamel wrote:
Hello all,
I am new to postgres and don't really understand how the database is
set-up. I am very fluent with mysql and sql2000, but postgres is new to
me. If anyone can point me to some good links I would appreciate it very
much.
Thanks,
Darkcamel
Duane,
El 05/08/2004 5:29 PM, Duane Lee - EGOVX en su mensaje escribio:
What table is lnpedpk in - ped_cam? What table is ped_pk in - ped_pro and
ped_cam?
lnPedPk is parameter pased to the function and it could be a fixed value
on the sql console too, ped_pk is common in both tables, I changed th
Markus Bertheau <[EMAIL PROTECTED]> writes:
> I create the situation as follows:
> CREATE TABLE a (name TEXT PRIMARY KEY);
> INSERT INTO a VALUES ('xxx');
> CREATE TABLE b (name TEXT PRIMARY KEY REFERENCES a(name) ON UPDATE CASCADE);
> INSERT INTO b VALUES ('xxx');
> CREATE RULE b_rename AS ON UPD
On Fri, 6 Aug 2004, Markus Bertheau wrote:
> Up to here I thought that the following was going on: The UPDATE b
> statement was rewritten into a UPDATE a statement by the rule system.
> The update on a triggers the foreign key update on b. This UPDATE gets
> rewritten again by the rule system to
In article <[EMAIL PROTECTED]>,
ruben <[EMAIL PROTECTED]> writes:
> Today, one of the processes running daily took 4 hours when it takes
> about 5 minutes. After a VACCUM ANALYZE of the affected tables it took
> the same to finish, then I recreated (drop and create) the index of
> the affected tab
--- Darkcamel <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I am new to postgres and don't really understand
> how the database is
> set-up. I am very fluent with mysql and sql2000,
> but postgres is new to
> me. If anyone can point me to some good links I
> would appreciate it
Hi,
On PostgreSQL 7.4.2 I can create a situation in which a foreign key is
violated:
bug=# SELECT b.name, exists(SELECT 1 FROM a WHERE a.name = b.name) FROM b;
name | ?column?
--+--
xxx | f
(1 ÑÑ)
bug=# \d+ b
ÐÑÐ "public.b"
ÐÐÐ | ÐÐÐ | ÑÐÐÐ
Michael Glaesemann wrote:
Thanks for the links! I remember coming across a TimeCenter paper. The
TimeCenter reference page is quite extensive and I look forward to
reading more of the work Darwen and Date critiqued.
Sorry for the redundant Darwen critique link.
On Aug 6, 2004, at 6:37 PM, Mike Ma
On Mon, 2004-08-02 at 16:09 -0700, webb wrote:
> What I am curious about is versioning the data that goes into this
> database using something that I want to call a "checkpoint".
:-)
How about using CHECKPOINT or SAVEPOINT in postgresql 8.0? (in beta now)
http://developer.postgresql.org/docs/postg
I'm a student currently working on a postgresql
based project.
I want to know whether olap technologies are
compatible with postgresql and would like some links
to sites that could give me more info on this subject.
What is the latest on olap in postgresql
_
Kay-Uwe Genz <[EMAIL PROTECTED]> wrote:
>
> Hi @ all,
>
> I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of
> my DB. But I saw that pg_user is a view. Where are the information I
> need?
Maybe you could \d the view and find out? *But* you have to have
the proper permissi
David Garamond wrote:
2a. individual string values will be tagged with charset+encoding. this
incurs an overhead of 1-2 bytes per value.
forgot to add: this overhead is just for "in-memory" or temporary value
(e.g. when being passed as arguments). in the storage itself, this is
not needed becaus
Stephan Szabo wrote:
Could you point me where in the archives can I read more? I'm having a
bit of trouble finding discussion on this. Thanks.
I didn't spend too much time looking, but there are a few that look like
they'll touch upon related issues:
http://archives.postgresql.org/pgsql-hackers/200
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Amir Zicherman wrote:
| i am running multiple threads that are calling this function at the
| same time. i want to be able to do that and have the locking in
| postgresql take care of locking the selected rows of each thread. why
| is the function not
Mike
Thanks for the links! I remember coming across a TimeCenter paper. The
TimeCenter reference page is quite extensive and I look forward to
reading more of the work Darwen and Date critiqued.
On Aug 6, 2004, at 6:37 PM, Mike Mascari wrote:
Partial indexes get me close to where I want with tem
Michael Glaesemann wrote:
From what I gather, the SQL TSQL2 discussions ended without any
conclusion as to extending SQL in this direction.
Darwen's critique of TSQL2 is here:
http://www.hughdarwen.freeola.com/TheThirdManifesto.web/OnTSQL2.pdf
I'm not sure if Snodgrass ever replied to it.
The wo
22 matches
Mail list logo
