--On Thursday, November 18, 2004 3:15 PM +0900 Michael Glaesemann
<[EMAIL PROTECTED]> wrote:
Would it work to drop and readd the trigger within a transaction? Would
that make it multi-user safe? I can't think of another way to bypass an
update trigger.
I had that idea too, and I have no idea. :-(
On Nov 18, 2004, at 2:53 PM, Jim Archer wrote:
This is a multi-user environment, so I can't really drop the trigger
and readd it.
Would it work to drop and readd the trigger within a transaction? Would
that make it multi-user safe? I can't think of another way to bypass an
update trigger.
Mich
Hi All...
I'm been fighting this problem for a few days now, and it seems like it
should be simple. But the solution has eluded me so far...
I need to flag a record when it is updated or when it is a new insert.
Then I SELECT for the changed records and do something not related to
Postgres. E
This was posted in news.groups, but it was not posted to the list.
REQUEST FOR DISCUSSION (RFD)
unmoderated group comp.databases.postgresql.admin
unmoderated group comp.databases.postgresql.general
unmoderated group comp.databases.postgresql.hackers
# > "Whenever a user-defined base data type is created, PostgreSQL
# > automatically creates an associated array type, whose name consists
# > of the base type's name prepended with an underscore.
#
# The key word in that sentence is "base" data type --- ie, not
# composite.
Ah, I see -- it wa
Jonathan Daugherty <[EMAIL PROTECTED]> writes:
> I'm trying to write a PL/PgSQL function whose sole parameter is an
> array whose element type is a type that I've created. For example:
> According to the 7.4 docs,
> "Whenever a user-defined base data type is created, PostgreSQL
> automatically
Hello,
I'm trying to write a PL/PgSQL function whose sole parameter is an
array whose element type is a type that I've created. For example:
CREATE TYPE test_type AS (x bigint, y bigint);
CREATE OR REPLACE FUNCTION array_test (test_type[]) ...
According to the 7.4 docs,
"Whenever a user-
On Wed, 2004-11-17 at 12:49, Robert Fitzpatrick wrote:
> On Wed, 2004-11-17 at 11:49, Michael Fuhr wrote:
> > On Wed, Nov 17, 2004 at 11:20:41AM -0500, Robert Fitzpatrick wrote:
> >
> > > I have a view that used union all to merge three tables together. I was
> > > hoping to create a rule, one for
On Wed, 2004-11-17 at 11:49, Michael Fuhr wrote:
> On Wed, Nov 17, 2004 at 11:20:41AM -0500, Robert Fitzpatrick wrote:
>
> > I have a view that used union all to merge three tables together. I was
> > hoping to create a rule, one for each table using the WHERE condition of
> > the rule to determin
On Wed, Nov 17, 2004 at 11:20:41AM -0500, Robert Fitzpatrick wrote:
> I have a view that used union all to merge three tables together. I was
> hoping to create a rule, one for each table using the WHERE condition of
> the rule to determine which table gets updated. Is this possible?
See the CREA
Dawid,
unfortunately, tsearch2 doesn't support unicode yet.
If you keep tsvector separately from data than you'll need one more join.
Oleg
On Wed, 17 Nov 2004, Dawid Kuroczko wrote:
I'm trying to use tsearch2 with database which is in 'UNICODE' encoding.
It works fine for English text, but
Timo,
take a look into .aff file and search 'compoundwords'.
german ispell file I got from http://j3e.de/ispell/igerman98/ has no
support for compound words: 'compoundwords off'
Norwegian, for example, has:
compoundwords controlled z
compoundmin 4
Oleg
On Wed, 17 Nov 2004, Oleg Bartunov wrote
I have a view that used union all to merge three tables together. I was
hoping to create a rule, one for each table using the WHERE condition of
the rule to determine which table gets updated. Is this possible?
This is what I have, assume the view here is a merge of three tables
using union all:
I'm trying to use tsearch2 with database which is in 'UNICODE' encoding.
It works fine for English text, but as I intend to search Polish texts I did:
insert into pg_ts_cfg('default_polish', 'default', 'pl_PL.UTF-8');
(and I updated other pg_ts_* tables as written in manual).
However, Polish-spec
--- Konstantin Danilov <[EMAIL PROTECTED]> wrote:
> Hello everyone!
> I have a question.. Does PostgreSQL have official
> certification? If yes, where can I find
> certification courses to get a certificate?
There are no official certifications. Anyone who
wants to can offer their own certificat
--- Marco Bizzarri <[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I would like to know if postgresql has any
> certification for the
> military environment.
There are no official certifications, nor are there
likely to be. But certifications may be offered by
individual companies, like Red Had does
On Wed, 17 Nov 2004, Timo Haberkern wrote:
sorry for the late answer, i was on holyday,
see my remarks below
Oleg Bartunov wrote:
On Fri, 5 Nov 2004, Timo Haberkern wrote:
Oleg,
i use TSearch2 with PostgreSQL 7.4.6 and i applied the compoundword patch
yesterday. The configuration changed a little
On Wed, Nov 17, 2004 at 07:43:31PM +0530, Antony Paul wrote:
> Is it possible to know when a row was last updated. Using 7.3.3.
Add a TIMESTAMP or TIMESTAMP WITH TIME ZONE column to the table and
use a trigger to update it.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Hi all,
Is it possible to know when a row was last updated. Using 7.3.3.
rgds
Antony Paul
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that you
sorry for the late answer, i was on holyday,
see my remarks below
Oleg Bartunov wrote:
On Fri, 5 Nov 2004, Timo Haberkern wrote:
Oleg,
i use TSearch2 with PostgreSQL 7.4.6 and i applied the compoundword
patch yesterday. The configuration changed a little bit but the
result is the same. I get no c
Timothy Perrigo wrote:
(PostgreSQL 8.0 beta 4 on Mac OS X 10.3.6)
I'm working on a function which creates and populates a temporary table,
then returns the number of records it has inserted. I'm getting an
error, though, after successive invocations of the function (I can call
it once successfu
(PostgreSQL 8.0 beta 4 on Mac OS X 10.3.6)
I'm working on a function which creates and populates a temporary
table, then returns the number of records it has inserted. I'm getting
an error, though, after successive invocations of the function (I can
call it once successfully, but on the next ca
Hi,
Am Dienstag, den 16.11.2004, 11:22 +0100 schrieb Stefano Farina:
> Hi all
> I have to develop an embedded database using memory FLASH and memory
> RAM
> Some tables must be saved in RAM and some tables in FLASH ( RAM and
> FLASH are two different mounted directories in the file system).
> I sa
Thanks Ben, libncures5 was installed but libncurses5-devel don't.
Problem solved! I must find zlib deps now ;+)
On Wed, 17 Nov 2004 09:20:00 +, Ben Trewern <[EMAIL PROTECTED]> wrote:
> I think you have to install ncurses. On Mdk 10 its libncurses5-devel I
> think.
>
> Try that and see what
Helps me. Thanks for the clairification.
On Wednesday 17 November 2004 06:49 am, Martijn van Oosterhout saith:
> Just to clarify, there is a difference between OIDs and XIDs. Object
> IDs (OID) are a system assigned field to every row that eventually
> wraps around. If you don't use them in your a
Just to clarify, there is a difference between OIDs and XIDs. Object
IDs (OID) are a system assigned field to every row that eventually
wraps around. If you don't use them in your application you'll hever
really have a problem. The only exception is that statements that
modify structures in the dat
> Well, they were generated by MySQL and I can open them with
> e.g. the Windows Editor Notepad. But I don't know if they are
> actually encoded in UNICODE.
> Since I can open the file with Notepad and read the
> statements, I assume, it is not UNICODE. They look just like
> in the email below.
What you're looking for sounds like and extended (destructive) version
of what autovacuum does.
So you might try to look at the statistics tables like autovacuum does.
I don't know how it does that, but it seems that that way you'd be able
to incrementally have approximate information about wha
Look at the documentation here:
http://www.postgresql.org/docs/7.4/interactive/maintenance.html
The upshot is that you should vacuum every table in the database at
least once every billion transaction. It doesn't have to be a VACUUM
FULL, just run VACUUM without specifying a table.
There's some
Hello everyone!
I have a question.. Does PostgreSQL have official certification? If yes, where
can I find certification courses to get a certificate?
Konstantin
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi,
I have the same problem and I solved it. This question then was asked
and I answer it. Try looking at the google and you will find it.
In general - Open the package manager and searche for keyword "redline".
The neccessary library will apper and you just will have to install it.
Regards,
K
On Tue, 16 Nov 2004 11:22:27 +0100, Stefano Farina
<[EMAIL PROTECTED]> wrote:
>
> Hi all
> I have to develop an embedded database using memory FLASH and memory RAM
> Some tables must be saved in RAM and some tables in FLASH ( RAM and FLASH
> are two different mounted directories in the file sys
I think you have to install ncurses. On Mdk 10 its libncurses5-devel I
think.
Try that and see what happens.
Regards,
Ben
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.htm
[EMAIL PROTECTED] wrote:
Well, they were generated by MySQL and I can open them with e.g. the
Windows Editor Notepad. But I don't know if they are actually encoded in
UNICODE.
Since I can open the file with Notepad and read the statements, I assume,
it is not UNICODE. They look just like in the ema
Long and rambling question, here -- we have a customer with a database
that is outgrowing their original storage, and they want to upgrade
storage as cheaply and smoothly as possible.
Presently, they have one 120G or so RAID 5 unit, and the entire system
and data are stored on that
35 matches
Mail list logo
