to another person, use
> it for any purpose or store or copy the information in any medium.
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/F
#x27; strict volatile the
function will compile and execute. However if I do not explicitly declare any
variables as my / local / global it still executes which under the strict rule
should not.
Mike
---(end of broadcast)---
TIP 5: Have you checked
Isn't the syntax CREATE OR REPLACE FUNCTION chargeratetest() RETURNS "trigger"
AS'
?
On Wed, Jan 19, 2005 at 03:45:53PM +1100, Jamie Deppeler wrote:
> Hi,
>
> Think im doing something wrong here, cant seem to resolve the problem i
> have a trigger which is calling a update function and when
arison functions, create a new
operator class, and assign them names like "~>" and "~<". See the
documentation here:
http://www.postgresql.org/docs/8.0/interactive/xoper.html .
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Opps... resending to list as well. Perhaps someone can add more insight below.
And check the documentation at
http://borg.postgresql.org/docs/8.0/interactive/extend.html .
-- Forwarded message --
From: Mike Rylander <[EMAIL PROTECTED]>
Date: Thu, 20 Jan 2005 00:05:40
Title: Message
Hi,
I need to calculate
a moving average and I would like to do it with SQL, or a Pg function built for
this purpose. I'm on Pg 7.4. Is this possible in Pg without a bunch of self
joins, or is there a funtion available?
Thanks,
Mike
st)---
> TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
--
Mike Benoit <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
Is this on fedora or redhat linux? If so a separate rpm must be installed for
plpython to function.
If you built from source the config script must also include building python.
On Fri, Jan 21, 2005 at 10:34:51PM -0700, Michael Fuhr wrote:
> On Fri, Jan 21, 2005 at 09:16:27PM -0800, elein wr
a PEAR implementation in PHP.
--
Mike Nolan
---(end of broadcast)---
TIP 8: explain analyze is your friend
uch less. I can
attest to the fact that 4 x Opterons work VERY nicely. ;)
>
> Max
>
> ---(end of broadcast)---
> TIP 8: explain analyze is your friend
>
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database De
?
Thanks.
--
Mike Benoit <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
On Sat, 29 Jan 2005 09:55:15 -0800, Max <[EMAIL PROTECTED]> wrote:
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Mike Rylander
> > Sent: Friday, January 28, 2005 4:02 AM
> > To: Max; PgSql Ge
t:
postgresql-8.0.0beta4 $ time make -j 5
... lots of output ...
real0m41.274s
user1m36.315s
sys 0m15.451s
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TI
ssue of case-sensitivity either at the syntax level or the data
level seems to be one that brings out nearly religous ferver when 'discussed'.
--
Mike Nolan
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an a
ll OK. If you
want to test safely you could do a full load of 'pg_dump -s' (again,
just the schema) into a temp database and test the script there.
> I could use any help that you can give me.
> Thanks
> Sim
Hope that counts as help!
--
Mike Rylander
[EMAIL PROTECTED]
GPLS --
ecent data connections between the two offices starting
next week, but I was wonding if there is a good peer-to-peer option for
PostgreSQL at this time.
As I understand Slony, it is master-slave only.
--
Mike Nolan
---(end of broadcast)---
TIP 1: subs
al
transfer plan unfolds.
Master/Slave is probably an acceptable solution, I was just wondering if
there was a multi-master one available yet.
--
Mike Nolan
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriat
th to support it plus the traffic from the remote office plus
exixting outside traffic from our public website.
That's one of those things you just don't know will work until you
have it built, so I'm looking for other options now while I have time
to consider them. Once I get on
umber of entrys in the table
> "related_ingredients".
Can you send the table structure and the query that does this? It may
just be a matter of adding a subselect with a HAVING clause, but we
won't know until we have more information.
--
Mike Rylander
[EMAIL PROTECTE
ks a lot!
How about a Perl script that uses DBI with autocommit turned on and
loops over the file using (something like) 'while (my @line =
split(',',scalar(<>)) {}'?
Perl tracks the line number of the current input file (including
STDIN) in $. (dollar-period). If you
On Fri, 4 Feb 2005 13:56:23 +0100 (CET), Joolz
<[EMAIL PROTECTED]> wrote:
> If is has to be perl, so be it, although I'm not a big fan. Do you
> think this is possible in python?
>
Sure. I just suggested Perl since that's my QnD tool of choice.
--
Mike Rylander
[EMAIL
On Fri, 4 Feb 2005 17:52:45 +0100, Victor SpÃng Arthursson
<[EMAIL PROTECTED]> wrote:
>
> 2005-02-04 kl. 13.00 skrev Mike Rylander:
>
> > Can you send the table structure and the query that does this? It may
> > just be a matter of adding a subselect with a HAVING cl
On Mon, 7 Feb 2005 12:34:39 +0100, Victor SpÃng Arthursson
<[EMAIL PROTECTED]> wrote:
>
> 2005-02-04 kl. 20.36 skrev Mike Rylander:
>
> > How about:
> >
> > SELECT r.* FROM opskrifter r JOIN opskrifter_content c ON (r.nummer =
> > c.opskrift) JOIN ops
h big big big data
Check!
> View/Functions
> Indexing
> Building a datawarehouse
Check!
BTW, thanks in advance!
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast
> I need to check whether a SQL subexpression (to be used in WHERE
> clause), e.g.:
I've never tested it from Perl, but could you use 'explain select'
to see if it parses? It won't actually execute it if it does.
--
Mike Nolan
--
Hi to whoever is getting these. I sent this out the other day to the admin,
general, and novice group since I wasn't getting any response and was just
curious if anyone in postgresql.org had read it. I'm not sure which group to
send it to cause it's such and odd problem. Also did several google
l
> works at all on 64bit arches?
>
It's been working fine for me on Gentoo Linux / AMD64.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
)
timestamp::DATE in ((select date from table where...))
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
nv
DO INSTEAD
INSERT INTO inv(breeder_id,breed_id,count)
SELECT h.breeder_id, d.breed_id, NEW.count
WHERE h.name = NEW.breeder
AND d.name = NEW.breed;
update/delete???
Thanks,
Mike H.
---(end of broadcast)---
TIP 8: exp
ere must be a occurence of 'new' before
> 'york'" (stemmed not really exact phrase)?
>
What you'll want to do is check the original text for the exact phrase
after the tsearch2 index has given you some targets.
Given table foo:
CREATE TABLE foo (
id
nt '&' op, as in '&[dist<=1]' meaning "next
token follows with a max distance of 1". I imagine that it would
only be useful on unstripped tsvectors, but if the lexem position is
already stored ...
--
Mike Rylander
[EMAIL PROTECTED]
GPLS --
I think that's a case of how the
compiled expression is built from user input. Unless I'm mistaken
a + ( foo1 | foo2 )
is exactly equal to
(a + foo1) | (a + foo2)
Ahhh... but then there is the more complex example of
a + foonish + bar
becoming
a + (foo1 | foo2) + bar
...
source as free, because:
# dstat -m 1
--memory-usage-
_used _buff _cach _free
13G 322M 8095M 9.8G
Now, I'm not blaming Pg for the apparent discrepancy in calculated vs.
reported-by-free memory usage, but I only noticed this after upgrading
to 8.1. I'll collect any more
On 12/8/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Mike Rylander <[EMAIL PROTECTED]> writes:
> > To cut to the chase, here are
> > some numbers for everyone to digest:
> >total gnu ps resident size
> > # ps ax -o rss|perl -e '
(foo1 + forbruk + vare + merke + lov) | (foo2 + forbruk +
vare + merke + lov) ) & ! bar # explode the compound words to their
"decomposed" form, because that's what ought to be in the indexed data
That meets the same criteria as the simpler example above, and I've
not sa
and chicago, or new followed by york at
a distance of 1."
where the modifier to the '+' operator could be specified by the user
initially if desired.
While I understand and agree that "phrase searching" would be the most
common use for proximity+direction operator modifie
On 12/12/05, Will Glynn <[EMAIL PROTECTED]> wrote:
> Mike Rylander wrote:
>
> >Right, I can definitely see that happening. Some backends are upwards
> >of 200M, some are just a few since they haven't been touched yet.
> >
> >
> >>Now, multiply
esn't cover UPDATEs of course, but that should be easy enough
to do. It does, however, give you a simple "type" lookup table if you
happen to have a pid in hand and want to know what it is.
Thoughts?
>
> Karsten
> --
> GPG key ID E4071346 @ wwwkeys.pgp.net
> E167 67FD A291 2BEA 7
e availability of
> POSTGRESQL for Windows/Linux and other platforms is the main reason we are
> planning to choose POSTGRESQL
>
> - Rajendra Talekar
> Chief Developer and Managing Director
> Codexpert Systems
--
Mike Rylander
[EMAIL PROTECTED]
GPLS
g@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
rkaround I will rename one of the tables temporarily. If someone has
been able to get this to work I would appreciate any tips to reference for next
time.
Mike
---(end of broadcast)---
TIP 6: explain analyze is your friend
ed to remember to go in and change
> the function.
>
> Running Postgresql 8.1
>
> Thanks for any advice/help!
>
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Mike Rylander
[EMAIL
backtest where field ~ E'\\134';
select * from backtest where field ~ E'\\134';
field
--
ABC\DEFG
(1 row)
So far the only way I have found to change data with backslashes in it
is something like the following:
update backtest
set field = replace(field,'\
select * from backtest where field ~ '';
field
---
(0 rows)
select * from backtest where field like '%%';
field
---
(0 rows)
Could this be a locale issue? The one where it does not work uses the C
locale, the others use the default locale, en_US.UTF-8.
-
control in my PHP app, whatever
changed is apparently affecting both Postgres and PHP.
Any ideas? Some kind of library issue maybe, such as readline?
--
Mike Nolan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, ple
If someone can make a ppm I would appreciate it. I have VS 2005 not 2003.
Mike
On Thu, Feb 23, 2006 at 02:11:55AM -, Greg Sabino Mullane wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> I am pleased to announce that version 1.44 of DBD::Pg has
> b
r 355" depending upon which
database it is checking.
Maybe it can be "fixed" in 8.2 if it hasn't been addressed already.
Mike
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
I've been lurking on the pgsql-* lists for about a month now and have
decided to quit being a "wall flower".
Looking through the achives, I've noticed a fair number of threads about
Oracle compatibility functions: predominantly for decode(). I've even
seen and (quickly) looked at one implemen
Ack! Should at least pull the current version from the database:
This version also correctly checks the "default" return value for a
possible return of a wanted NULL value. (The part just ahead of "return
$final_else;".
/***/
C
relation "bb" does not exist.
postgres 8.1.2
Maybe in a future version the alias can be allowed? Perhaps someone wanted to
avoid updating the wrong column on accident and put this in as a safety net?
Mike
---(end of broadcast)---
T
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 03 April 2006 01:21
...snip
2) pgAdmin uses a separate connection for query tool windows. Because
temp tables exist only for the life of the session, if
s/\p{Mn}+//ogsm;
return NFC($string);
$func$ LANGUAGE 'plperl' STRICT;
It's untested and won't be as fast as ICU, but it should get the job
done. Hope it helps!
>
> Thanks
> Balázs
>
> ---(end of broadcast)---
> TIP 6:
Hello,
I was wondering if anybody know a tool or postgres
command which would allow me to see how much data is
written to hardrive and read from hardrive by Postgres
in given time period. (let's say last 24h)
Thank you,
__
Do You Yahoo!?
Tired of
wo years of data also
has a much larger number of columns, all with indexes since they are all
potentially used for querying subsets from the tables. Is there
something particularly wrong that I might doing (or something that I'm
not doing) to prevent
than querying the table itself. Is this possible, or reasonable
to do?
Thanks again for your help,
Mike
(P.S. - Sorry if you get this twice Tom)
===
dbname=# set session enable_seqscan to on;
SET
dbname=# explain analyze selec
his...can anybody suggest some alternative
methods for summarizing the possible values from an indexed column that
has a small number of unique values?
Thanks in advance,
Mike
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
o add a routine
in my php scripts that does essentially the same thing.
I really appreciate your help,
Mike
Martijn van Oosterhout wrote:
On Fri, Apr 28, 2006 at 08:35:08AM -0400, Mike Leahy wrote:
Hello list,
Following from a question I had yesterday, I'm wondering if there is
s
Hello,
Will there need to be a new version of DBD::Pg released for 8.1.4?
Mike
--
Open WebMail Project (http://openwebmail.org)
---(end of broadcast)---
TIP 6: explain analyze is your friend
ot;Name", "qryYield"."Yield",
"qryPrintCopyComments"."PrintCopyComments"
ORDER BY "qryPQSetPages"."MachineID", "qryPQSetPages"."PrintCopyID",
"tblColors"."Color";
=
For the sake of brevity, I'll only list one of the other views to give
you a rough idea of what they look like. Most of the other views look
similar to the one in the first left join, qryCRMS
=
SELECT "PrintSamples"."MachineID", "PrintSamples"."PrintCopyID",
"tblColors"."ColorID", "ParameterValues"."ParameterValue" AS
"CRMS_Value"
FROM "AnalysisModules"
JOIN ("tblColors"
JOIN ("tblTPNamesAndColors"
JOIN "PrintSamples" ON "tblTPNamesAndColors"."TestPatternName"::text
= "PrintSamples"."TestPatternName"::text) ON "tblColors"."ColorID" =
"tblTPNamesAndColors"."ColorID"
JOIN ("DigitalImages"
JOIN "PrintSampleAnalyses" ON "DigitalImages"."ImageID" =
"PrintSampleAnalyses"."ImageID"
JOIN ("ParameterNames"
JOIN ("Measurements"
JOIN "ParameterValues" ON "Measurements"."MeasurementID" =
"ParameterValues"."MeasurementID") ON "ParameterNames"."ParameterID" =
"ParameterValues"."ParameterID") ON "PrintSampleAnalyses"."psaID" =
"Measurements"."psaID") ON "PrintSamples"."PrintSampleID" =
"DigitalImages"."PrintSampleID") ON "AnalysisModules"."MetricID" =
"Measurements"."MetricID"
WHERE "tblTPNamesAndColors"."ColorID" = 3 AND
"tblTPNamesAndColors"."TestPatternName"::text ~~ '%TP8%'::text AND
("Measurements"."msmTag"::text = 'DAC'::text OR
"Measurements"."msmTag"::text = ''::text) AND
"AnalysisModules"."AnalysisModuleName"::text = 'MacroUniformity'::text
AND "ParameterNames"."ParameterName"::text = 'CRMS'::text;
=
I'm running this on XP Pro with a P4 3.2ghz, 1.5G memory and a single
SATA Raptor.
My conf settings are:
shared_buffers = 12288
work_mem = 262144
maintenance_work_mem = 131072
effective_cache_size = 1
random_page_cost = 2.0
Postgres isn't the only app running on this computer that requires
significant resources. I've got another proprietary app on there that
is very CPU and memory intensive. This other app should be allocated
resources before postgres.
Autovacuum is running with the default settings, and I also do a vacuum
full analyze nightly (probably overkill for me, but the server doesn't
see any other activity at night anyway)
How should I resolve this problem? Rewrite qrySummary to be more
efficient (not a job I look forward to)? Get a better server/upgrade
the memory in the one I have? Adjust some settings in my conf file?
Some other solution I haven't thought of? I'm looking for a point in
the right direction.
Mike
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
work_mem = 262144
I'm still trying to figure out how to track the memory usage in
ExecutorState
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Sunday, June 18, 2006 11:13 PM
To: Qingqing Zhou
Cc: pgsql-general@postgresql.org
Subject: Re:
So what's my next step? How do I track down what is causing this
problem?
-Original Message-
From: Qingqing Zhou [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 11:01 PM
To: Relyea, Mike
Cc: pgsql-general@postgresql.org; Tom Lane
Subject: RE: [GENERAL] Out of memory err
I've zipped the results of EXPLAIN INSERT INTO "tblSummary" SELECT *
FROM "qrySummary"; for my case. It's a zip file that I've renamed to
.txt in order to get around the attachment being blocked by certain mail
servers.
PK yÖ4¨yï ý explain.txtí]]oÇÕ¾/[EMAIL
PROTECTED]( É`ç{ÖH
Thanks Jim and Tom. At least now I've got a direction to head in. I
think for now I'll probably reduce work_mem as a stop-gap measure to get
the query running again. This will buy me some time to redesign it.
I'll probably separate out each sub query and store the results in a
table (would a tem
under PostgreSQL? I found one web store package in the pgsql
project archives, but it looks like it may need a lot of tinkering to get
it working.
--
Mike Nolan
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
t the latter word might be
proprietary to Oracle. I've lost touch with the rest of the members in
that group, though, since the computer I was using for PG development
purposes got zapped by lightning in August.
--
Mike Nolan
---(end of broadcast)--
> I also have 7.4 running on 10.3 and didn't have any trouble installing it.
Same here. I built and installed REL7_4_STABLE from CVS without any problem
on 10.3. Maybe the problem starts with a later release?
-mc
--
Mike Coleman <[EMAIL PROTECTED]>
Five Bats Incorporated, P
_
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=dept/features&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca
---(end
;High Memory Support' setting to get it to
use the full 1GB.
That was under RH 8, though.
-
Mike Nolan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
dual circumstances (including budget).
Were you told why that was the wrong choice?
--
Mike Nolan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
age Reference Manual, but
I cheated by looking it up in the index. There are index entries for
'BETWEEN' in "Practical PosgreSQL" and "Managing & Using MySQL", too.
Sometimes books are still better than online docs. :-)
--
Mike Nolan
---(end
ust need
> someone willing to go through the files and add suitable entries ...
I may look into it after the first of the year, though I'm likely to
propose something more sweeping than that.
--
Mike Nolan
---(end of broadcast)---
TIP
> Mike Nolan <[EMAIL PROTECTED]> writes:
> > However, I think RH always sets the LANG environmental variable, so
> > that's going to be picked up by initdb, which means that the C locale
> > will NOT be used unless specifically asked for. Other OS packages ma
I stand corrected. I was doing some testing of a PHP module that is
called from a web form a while back and got inconsistent results with
currval, I probably had a script error of some kind.
--
Mike Nolan
---(end of broadcast)---
TIP 9: the plan
ny possibility that he's got an open transacation sitting out
there for days holding a lock on that table?
Mike Mascari
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
of the SQL standard?
On a mostly unrelated topic, does the SQL standard indicate whether NULL
should sort to the front or the back? Is there a way to force it to
one or the other independent of whether the order by clause uses ascending or
descending order?
--
Mike Nolan
-
the front end uses as a default column
heading with what the back end uses as a default column name. '?column?'
would probably not meet SQL standards.
--
Mike Nolan
---(end of broadcast)---
TIP 2: you can get off all lists at once with th
or can I just use pg_dump and pg_dumpall
from it? (I get the same 'undefined symbol: get_progname' message when
I try that.)
--
Mike Nolan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
e a
killer...
How about a TIP:
"For large number of joins, test whether the GEQO settings are right for
you"
Mike Mascari
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Tom Lane wrote:
Mike Mascari <[EMAIL PROTECTED]> writes:
But just as a quick notice to those upgrading from 7.3 to 7.4 with fully
normalized databases requiring > 11 joins, the GEQO setting can be a
killer...
Uh ... dare I ask whether you think it's too high? Or too low?
Tom Lane wrote:
Mike Mascari <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Uh ... dare I ask whether you think it's too high? Or too low?
Too low. In fact, after testing some of my queries which are a bit large
(# of tables) in size, I usually just wind up tur
n the same
cluster, it executes fine???
I'll try and dump the entire database and restore it on a third machine
and see if the query crashes that backend as well. But it will take a
bit of time. If it does crash what does that mean? If not, what does
that mean?
Mike Mascari
---(end of broadcast)---
TIP 8: explain analyze is your friend
n aggregate function
--
Mike Nolan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
x, count(*) from memmast
group by newx
FAIL: select substr(memid,1,1) as memtp, substr(memid,2,4) as newx,
count(*) from memmast group by memtp, newx
--
Mike Nolan
---(end of broadcast)---
TIP 5: Have you checked our extensive F
> Works for me in every branch back to 7.1 ... what version are you using?
7.4.1, but I figured out what I did wrong. The alias for the first
column turns out to be the same as the name of another column in the table.
--
Mike Nolan
---(end of broadc
begin
NEW.mod_date = LOCALTIMESTAMP;
return NEW;
end;
' language 'plpgsql';
CREATE TRIGGER t_foo
BEFORE INSERT OR UPDATE ON foo
FOR EACH ROW
EXECUTE PROCEDURE touch();
If you want timezone information, use TIMESTAMP WITH TIME ZONE and
CURRENTTIMESTAMP. These are transaction start times.
Mike Mascari wrote:
CREATE FUNCTION touch() RETURNS trigger AS '
begin
NEW.mod_date = LOCALTIMESTAMP;
return NEW;
end;
' language 'plpgsql';
CREATE TRIGGER t_foo
BEFORE INSERT OR UPDATE ON foo
FOR EACH ROW
EXECUTE PROCEDURE touch();
If you want timezone information, use TIME
Marc A. Leith wrote:
Quoting Mike Mascari <[EMAIL PROTECTED]>:
Would Joe Conway's PL/R procedural language be any help here? I'd guess
there's an R package to fit the bill, but then again I'm only on page 30
of Modern Applied Statistics in S-Plus. ;-)
For a turn
this is the way to support large files). It
is my understanding that ext3 supports file sizes up to 1T. The restore worked
fine when the database was smaller. Any ideas?
Thanks,
Mike Charnoky
---(end of broadcast)---
TIP 6: Have you searched
ataPos
2: tctx->dataPos = 1785996817
BTW, the file size is: 2361910772 bytes
Mike Charnoky
Tom Lane wrote:
Mike Charnoky <[EMAIL PROTECTED]> writes:
I am currently using PostgreSQL v7.3.4 on a RedHat 8.0 system (2.4.23 kernel)
using the ext3 filesystem. I am experiencing problems when p
hat dataPos is
being treated as an integer somewhere.
Mike Charnoky
Tom Lane wrote:
Mike Charnoky <[EMAIL PROTECTED]> writes:
I am currently using PostgreSQL v7.3.4 on a RedHat 8.0 system (2.4.23 kernel)
using the ext3 filesystem. I am experiencing problems when performing a
pg_restore using
27;'text''])
plpy.execute(plan,[''blah''])
return ''MODIFY''
'LANGUAGE plpythonu;
Do you have a trigger on 't1' which invokes testing()?
Mike Mascari
---(end of broadcast)---
T
27;'text''])
plpy.execute(plan,[''blah''])
return ''MODIFY''
'LANGUAGE plpythonu;
Do you have a trigger on 't1' which invokes testing()?
Mike Mascari
I do have a trigger on t1. The function loads into the database OK, but
when
k end for those who
need or want that information.
I would only display the host information if psql was called with -h.
--
Mike Nolan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I received the following note on another database-oriented list.
This may be something that pg users could help in, though I'll also
pass on the caveat that the other list had, that I have no direct knowledge
about the institution or the researchers.
--
Mike
ta better than pg.)
MySQL's poor implementation of the 'alter table' process.
--
Mike Nolan
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
t always does
the edit to a temporary file so it goes away immediately upon exit and
some of the ways \o works, I'm used to using both features in Oracle
to provide a historical trail of my work), mysql can't even repeat a
command (\g) without first re-editing it.
--
Mike Nola
Mike Mascari wrote:
Stephan Szabo wrote:
On Thu, 26 Feb 2004 [EMAIL PROTECTED] wrote:
I'm using postgresl 7.3.2 and have a query that executes very slowly.
There are 2 tables: Item and LogEvent. ItemID (an int4) is the
primary key
of Item, and is also a field in LogEvent. Some ItemI
key
-
1
3
(2 rows)
[EMAIL PROTECTED] select * from bar;
key | value
-+---
1 | Mike
2 | Joe
(2 rows)
[EMAIL PROTECTED] select f.key from foo f left outer join bar b on f.key
= b.key and b.key is null;
key
-
1
3
(2 rows)
To do what I think you believe to be happen
Stephan Szabo wrote:
On Fri, 27 Feb 2004, Mike Mascari wrote:
To do what I think you believe to be happening w.r.t. outer joins,
you'd have to have a subquery like:
[EMAIL PROTECTED] select a.fookey
test-# FROM
test-# (SELECT foo.key AS fookey, bar.key as barkey FROM foo LEFT
OUTER JOIN b
| Annual Audit
This isn't my query, I'm translating a system prototyped in MSSQL to
Postgres. This query _does_ work in MSSQL. Does that constitute a
bug in MSSQL, or a shortcomming of Postgres, or just a difference of
interpretation?
If MSSQL picks an arbitrary valu
801 - 900 of 1197 matches
Mail list logo
