omething of the sort in contrib already, I believe, though
> it's so old it still uses abstime :-(
What's wrong with abstime ?
it is valid for timestamps up to 2038-01-19 and it's on-disk size
smaller than other timestamp options
--
Hannu Krosing http://www.2ndQuadrant.com
PostgreS
On Tue, 2009-11-24 at 09:46 +, Thom Brown wrote:
> 2009/11/24 Hannu Krosing
> On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
> > Craig Ringer writes:
> > > I do think this comes up often enough that a built-in
> trigger "upda
) AND f.group_id = $2
to gather all friend info in parallel
--
----------
Hannu Krosing http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability
Services, Consulting and Training
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
# select ARRAY(select usename from pg_user);
?column?
---
{postgres,hannu,m1,skyncuser}
(1 row)
--
--
Hannu Krosing http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability
Services, Consultin
On Thu, 2009-01-22 at 16:13 +0200, Hannu Krosing wrote:
> On Thu, 2009-01-22 at 15:10 +0300, Igor Katson wrote:
>
> > Ok, thank you, guys. What is the best way to make an array out of a
> > column? I didn't make up anything better then writing a function:
> >
&
considered in the design. But it is easy to do on most cases and doable
in 100% of cases.
Typical pgQ delay can be below one second, even a few tenths of second
is doable.
--
--
Hannu Krosing http://www.2ndQuadrant.com
PostgreSQL Scalability and Availabili
Ühel kenal päeval, N, 2006-04-13 kell 10:06, kirjutas John
Sidney-Woollett:
> I just added a new table to a slony relication set. The new table seems
> to have a really high tab_reloid value of 94,198,669
...
> Is this something I should be worried about? Can I find out where all
> the intermedia
On P, 2004-10-03 at 20:24, Scott Marlowe wrote:
> On Sun, 2004-10-03 at 06:33, stig erikson wrote:
> > Is there a tool, some add-in to apache perhaps that can run ASP code on
> > linux/unix, this would help to have the system running while we recode
> > the application.
>
> There are a few tools
elein kirjutas T, 24.06.2003 kell 00:42:
There is a realtively clean hack one can use to convert plpython
functions to plpythonu manually - just rename the language for the time
of loading functions - do as superuser
update pg_language set lanname = 'plpython' where lanname = 'plpythonu';
LOAD Y
Yonatan Goraly kirjutas P, 26.10.2003 kell 00:25:
> I am in the process of adding PostgreSQL support for an application,
> in addition to Oracle and MS SQL.
> I am using PostgreSQL version 7.3.2, Red Hat 9.0 on Intel Pentium III
> board.
>
> I have a query that generally looks like this:
>
> SEL
Tom Lane wrote:
>
Thanks for doing it ;)
I have some comments too ...
> One of the
> longest-running parts of the discussion had to do with giving good error
> messages and how it is hard to get friendly messages when you rely on the
> database to do error checking. I thought this pointed up t
Franck Martin wrote:
>
> It seems that your code is exactly what I want.
>
> I have already created geographical objects which contains MBR(Minimum
> Bounding Rectangle) in their structure, so it is a question of rewriting
> your code to change the access to the cube structure to the MBR structu
Tom Lane wrote:
>
> Chris Bitmead <[EMAIL PROTECTED]> writes:
> > To me this is a much better idea. In any proper OO application you would
> > be using the "*" in postgres 99% of the time - that being the whole
> > point of OO.
And considering that the Informix OO is probably really
Illustra/Pos
Kevin Lo wrote:
>
> Hi,
>
> Some people asked me to build PostgreSQL binaries for Windows NT.
> The binaries(PostgreSQL-6.5.3) are now available at:
>
> ftp://203.79.167.135/pub/postgres-nt-binaries.tar.gz
Great !
> Please go to my page if you want to build it yourself :)
>
> http://www.free
Bruce Momjian wrote:
>
>
> Yikes. Strange. Can we just return nulls for the empty fields?
I think more natural way would be to define a new type (NAF - NotAFiled),
like we have NAN for floats (do we ?, at least IEEE has)
-
Hannu
Bruce Momjian wrote:
>
> > Bruce Momjian wrote:
> >
> > > So the field is created on the fly to show what table it came from.
> > > Seems like a good idea, though implementing another usually-invisible
> > > column will be tough.
> >
> > What problems do you forsee?
>
> Well, it is usually prett
Stephan Richter wrote:
>
> Hello everyone,
>
> This is a help message to every mailing list, I think this issue could be
> related to. We are in production and 5000 flyers (45000 follow) were sent
> out and the site keeps giving problems.
>
> I use:
> Zope 2.1.4, PyGres 2.x, Apache, and PostGre
Stephan Richter wrote:
>
> At 07:08 PM 5/7/00 -0400, Robert B. Easter wrote:
> >My understanding is that what you get from crypt(pw, salt) =
> >
> > $1$$
That's for DES crypt (and without the $$)
-
Hannu
Chris Bitmead wrote:
>
> > In this
> > case, it would only look down into the tree to 3 levels below supertable and
> > you'd never get row-types that are down lower than level 3. Anyhow, I still
> > don't think returning multple row-types is going to happen,
OTOH, I'm pretty sure that original
19 matches
Mail list logo
