But watch out! This is mentioned in the docs but it bit me when I used
timestamp with time zone so:
timestamp with time zone does not record the timezone you inserted it
with- it simply stores the GMT version and converts to whatever
timezone you like on demand. If the timezone is important da
Are you certain that it is the trigger that is crashing the process? If
that is true, then there may be a bug in plperl.
To debug, you could use gdb, but try this first:
Use the strict pragma. To do this in plperl (instead of plperlu), use:
BEGIN { strict->import(); }
or set strict mod
I am not to sure of the relevance, but I periodically worked as a
sub-contractor for an
Oil-producing Company in California. They were carrying 35 years of
data on an Alpha Server
running Ca-Ingres. The really bad part is that hundreds and hundreds
of reporting tables were
created on top of th
Will postgresql be a viable database in 20 years? Will SQL be used
anywhere in 20 years? Are you sure 20 years is your ideal backup
duration?
Very few media even last 5 years. The good thing about open source and
open standards is that regardless of the answers to those questions,
there is no
The shell is probably /bin/false right? That indicates that the
postgres user won't log in to an active session. If that's an issue,
then you should change that to whatever you like (probably
/usr/local/pgsql/).
On Jul 2, 2006, at 12:29 PM, Victor Escobar wrote:
What should the default direct
On Jul 2, 2006, at 6:13 AM, Martijn van Oosterhout wrote:
But I don't think anyone is actually considering importing ICU into the
postgres source tree, are they?
Why not?
Size - I'm not sure this is relevent since I don't think we want to
incorporate it into postgres itself, just let people us
On Jun 8, 2006, at 9:32 PM, David Fetter wrote:
On Thu, Jun 08, 2006 at 06:09:21PM -0700, Trent Shipley wrote:
On Thursday 2006-06-08 15:14, David Fetter wrote:
On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote:
on bag theory[1] and 3-value logic[2]. Until they come up wit
Well, the Date argument against NULLs (and he never endorsed them, or
so he claims) is that they are not data- they represent the absence of
data- so why put non-data in a _data_base.
If you are asking yourself the question how you can have support
multiple meanings in a column, normalize. The
To balance the discussion, I would like to say that I thoroughly
enjoyed Date's latest "Database In Depth". It gave me a strong
foundation in relational theory and I can say that I think more about
my schema designs thanks to the advice in the text. Just because SQL
may allow something, doesn't
I think the implementation of postgresql installable packages (and
package-space) should precede this idea. Then, any package management
system can install the packages.
On May 20, 2006, at 2:12 PM, Dawid Kuroczko wrote:
Comrehensive PostgreSQL Archive Network, or CPgAN
¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬
I came across a guy that wanted to get rows from a table by specifying
the table name and column ordinal number and nothing more. [Yes, this
is useless and violates relational model and SQL priniciples.]
My initial thoughts centered on using an array to snag each row and
pull out the column nu
On Apr 22, 2006, at 1:13 PM, Florian G. Pflug wrote:
Why don't you just use "SET SESSION AUTHORIZATION somerole", and then
scan
the to-be-executel sql scripts for any occurence of "reset session
authorization",
and ignore the script it matches.
Of course you'd need to be a bit carefull to c
7;; --fails
RESET SESSION AUTHORIZATION WITH PASSWORD 'abc'; --succeeds- we are
done with this role
The password ensures that the session authorization initiator is the
only one that can terminate it as well.
-M
On Apr 20, 2006, at 10:44 PM, Tom Lane wrote:
Agent M <[EMAIL PROTECTE
I really haven't provided enough details- my fault. What I want to
accomplish is a general-purpose timer facility for postgresql. Ideally,
arbitrary roles provide statements to run at certain intervals. The
benefit here is that the user connections can go away and only a single
timer connection
14 matches
Mail list logo
