ëÏÎÄÒÁÔØÅ× ðÁ×ÅÌ áÌÅËÓÁÎÄÒÏ×ÉÞ wrote:
> I'm Sorry for my english.
>
> Why Postgresql community do not use a "patch" style updates, I think this is
> usefull.
>
> Example: postgresql-7.4.6-7.4.7.tar.bz2
That works if your changes are small, but it has problems with files
that are added via the p
Tony Caduto wrote:
> Would it not be possible to add another param to the function like I
> mentioned
> and keep everyone happy? Users coming from MS SQL server look puzzled when
> they see the huge Character Varying(n) in a admin tool.
>
> I have not programmed in C since 1993, but I know in
Joshua D. Drake wrote:
>
> >
> >Or were you trying to say "let's ship it, and I don't care if major
> >Linux distributors refuse to include it in their packaging because it's
> >too hard to build that way"?
> >
> Close but not quite :). I was saying that Linux distributors are
> going to do what t
"Steve - DND" <[EMAIL PROTECTED]> writes:
>> Probably the problem has to do with not finding the underlying
>> language's DLL (eg, python.dll).
> Do I need to install a particular version of python then? Is there any
> further documentation that can help me with this?
Darn if I know. If the inst
> >> createlang: language installation failed: ERROR: could not
> load library
> >> "C:/Program Files/PostgreSQL/8.0/lib/plpython.dll": dynamic load error
>
> > Actually I just tried createlang with all of the pls(except
> plpgsql which is
> > already installed). All of them fail with the same err
"Steve - DND" <[EMAIL PROTECTED]> writes:
>> createlang: language installation failed: ERROR: could not load library
>> "C:/Program Files/PostgreSQL/8.0/lib/plpython.dll": dynamic load error
> Actually I just tried createlang with all of the pls(except plpgsql which is
> already installed). All o
Steve - DND schrieb:
I just tried using createlang to install plpython into a database on my
Windows 8.0 installation and continue to receive the error below. The file
plpython.dll is in exactly the location specified below as well. What
exactly am I doing wrong here?
createlang -e -U postgres plpy
"Julian Scarfe" <[EMAIL PROTECTED]> writes:
> Does the planner "realise" that
> the intersection, Query 6, will still return 150 rows, or does it assume
> independence of the filters in some way and estimate
> 20,000*(150/20,000)*(396/20,000)?
It assumes independence of the conditions --- which
> I just tried using createlang to install plpython into a database on my
> Windows 8.0 installation and continue to receive the error below. The file
> plpython.dll is in exactly the location specified below as well. What
> exactly am I doing wrong here?
>
> createlang -e -U postgres plpythonu jun
From: "Tom Lane" <[EMAIL PROTECTED]>
The problem is that it's underestimating the number of rows pulled from
the n table (1 vs actual 150), which makes a simple nestloop join look
like the way to go. That error comes from the fact that we don't really
have any statistical estimation for geometric
Hello,
My objective is design and build a Data Mart what enable OLAP queries using
Open Source tools.
I will want know if the solution below is possible and correct or exist a
better solution:
1 - The data will be generate to PostgreSQL from a commercial Database by a
ETL process.
2 - The Mondr
Hi Forum,
Is there a SQL sentence that one could build in order to
pull a bytea out of a table and save it into a file? Currently I do this by
getting a record set and outputting to a stream. I am using a developer
interface which would let me send a SQL sentence easily without having to
"Julian Scarfe" <[EMAIL PROTECTED]> writes:
> 6) Now I combine the filters in 4 & 5 (as I did from 1 & 2 to get 3, which
> performed in a similar time to 1)
> explain analyze
> select n.ref, n.code, a.ident, a.name
> from n left outer join a on (a.ident = n.code)
> where bbox &&
On Thu, Apr 07, 2005 at 11:51:10 +1000,
Chris Smith <[EMAIL PROTECTED]> wrote:
>
> Is there another way to approach this?
>
> I'm trying to delete records through a webapp and if there are 500,000
> records for example, I can't really leave the page open and expect it to
> finish...
Maybe yo
# [EMAIL PROTECTED] / 2005-04-03 11:14:54 -0700:
> On Sunday 03 April 2005 07:16 am, Michelle Konzack wrote:
> > I am puzzeling around, how to query a postgresql from a BASH script.
> > Generaly it must do nothing else as
>
> I recently came across this program-ShellSQL. I haven't had time to try i
In a 7.4 database I have a table n of which the relevant columns see to be:
Table "public.n"
Column |Type | Modifiers
---+-+---
code | text| not null
ref | te
Steve - DND wrote:
try pltcl, it's supposed to be pretty good at this.
As is plperl and likely plpython, and maybe others.
Does anyone have an example of this at work? I tried a few Google searches,
but couldn't get any results showing iterating over the columns of a record.
Attached - example of
17 matches
Mail list logo
