headers
Ron Johnson | 1 Jun 2003 03:31
Picon
Gravatar

Re: Slashdot: SAP and MySQL Join Forces

On Sat, 2003-05-31 at 14:19, PeterKorman wrote:
[snip]
> My copy of PostgreSQL by Douglas & Douglas (D&D) just arrived. It eases the 
> book derth with pretty high quality content. 
> 
> http://www.samspublishing.com/catalog/product.asp?product_id={310F293A-6C05-45CB-A781-FF25FBB6914A}

Click on that link, get:

Java Exception error '80004005'

java.lang.NullPointerException

C:\INETPUB\WWWROOT\SAMSPUBLISHING\CATALOG\../includes/objects/related_authorX.asp, line 57

--

-- 
+-----------------------------------------------------------+
| Ron Johnson, Jr.     Home: ron.l.johnson <at> cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
|                                                           |
| Regarding war zones: "There's nothing sacrosanct about a  |
| hotel with a bunch of journalists in it."                 |
|     Marine Lt. Gen. Bernard E. Trainor (Retired)          |
+-----------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org
Permalink | Reply | 2 comments |
headers
Vincent Hikida | 1 Jun 2003 03:55
Favicon

Re: Slashdot: SAP and MySQL Join Forces

Look at the URL on your browser. It is probably missing the end bracket.

Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"

www.UrbanaSoft.com

----- Original Message -----
From: "Ron Johnson" <ron.l.johnson <at> cox.net>
To: <pgsql-general <at> postgresql.org>
Sent: Saturday, May 31, 2003 6:31 PM
Subject: Re: [GENERAL] Slashdot: SAP and MySQL Join Forces

> On Sat, 2003-05-31 at 14:19, PeterKorman wrote:
> [snip]
> > My copy of PostgreSQL by Douglas & Douglas (D&D) just arrived. It eases
the
> > book derth with pretty high quality content.
> >
> >
http://www.samspublishing.com/catalog/product.asp?product_id={310F293A-6C05-
45CB-A781-FF25FBB6914A}
>
> Click on that link, get:
>
> Java Exception error '80004005'
>
> java.lang.NullPointerException
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Ron Johnson | 1 Jun 2003 05:14
Picon
Gravatar

Re: Slashdot: SAP and MySQL Join Forces

On Sat, 2003-05-31 at 20:55, Vincent Hikida wrote:
> Look at the URL on your browser. It is probably missing the end bracket.

That's it.  I wonder why it didn't work...

> ----- Original Message -----
> From: "Ron Johnson" <ron.l.johnson <at> cox.net>
> To: <pgsql-general <at> postgresql.org>
> Sent: Saturday, May 31, 2003 6:31 PM
> Subject: Re: [GENERAL] Slashdot: SAP and MySQL Join Forces
> 
> 
> > On Sat, 2003-05-31 at 14:19, PeterKorman wrote:
> > [snip]
> > > My copy of PostgreSQL by Douglas & Douglas (D&D) just arrived. It eases
> the
> > > book derth with pretty high quality content.
> > >
> > >
> http://www.samspublishing.com/catalog/product.asp?product_id={310F293A-6C05-
> 45CB-A781-FF25FBB6914A}
> >
> > Click on that link, get:
> >
> > Java Exception error '80004005'
> >
> > java.lang.NullPointerException
> >
> >
> C:\INETPUB\WWWROOT\SAMSPUBLISHING\CATALOG\../includes/objects/related_author
(Continue reading)

Permalink | Reply | 0 comments |
headers
Bruce Momjian | 1 Jun 2003 06:42
Picon

Re: qsort (was Re: Solaris)


I assume we decided that BSD sort isn't fast enough to warrant replacing
the native qsort.

---------------------------------------------------------------------------

Mark Kirkwood wrote:
> Mike Castle wrote:
> 
> >First I added a counter to the compare function, and the most cases, the
> >glibc implementation was called significantly less often than the BSD
> >compare function.
> >  
> >
> Interesting - all examples I tried had glibc compare count higher, do 
> you want to post one of yours?
> 
> >In a simple test function, like comparing two ints, then yes, the BSD
> >implementation was faster.  But in a more complex function, say comparing
> >strings, often times the glibc version was faster.  Why?  Because the
> >time spent in the compare function became the overwhelming factor.
> >  
> >
> Considering strings is a good point - I went away and tried some 
> examples,  unfortunately I only managed to see BSD faster, but the 
> difference was not as large as in the integer tests.
> 
> 
> regards
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
elein | 1 Jun 2003 06:46
Favicon

Re: context in plpgsql functions


You can do this in a C function or a plpython function
by saving out the information into context in C or
into the SD[] dictionary in plpython.

This is the subject of my talk at OSCON :-)

elein

On Saturday 17 May 2003 08:50, Gianni Mariani wrote:
> Gianni Mariani wrote:
> 
> > Jeff Eckermann wrote:
> >
> >> --- Ian Barwick <barwick <at> gmx.net> wrote:
> >>  
> >>
> >>> On Friday 16 May 2003 20:46, Gianni Mariani wrote:
> >>>   
> >>>
> >>>> I've been using PostgreSQL 7.3.2.
> >>>>
> >>>> What, if any, way is there to share a context
> >>>>     
> >>>
> >>> (global rowtype variable)
> >>>   
> >>>
> >>>> between plpgsql functions ?
> >>>>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Guillaume Houssay | 1 Jun 2003 15:48
Picon

Table data type modification

Sorry for this very basic question.

After installing Postgresql 7.3.2 and migrating table description. I can not
modify the column types of some tables.

To do the modification, I tried both pgphpadmin and pgadmin with the
administrator user which comes by default after installation.

I am pretty sure this is link to the privilegies but I can not find out the
solution.

Could you please help ?

GH

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Permalink | Reply | 0 comments |
headers
bruno | 1 Jun 2003 18:57
Picon
Favicon

update database format

newbie

I don't open Postgresql 7.3.2 because
- .. an old version of database format ..-
please an help

tnk bruno

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Permalink | Reply | 0 comments |
headers
elein | 2 Jun 2003 00:55
Favicon

Re: server process segfaulting


The problem is that the information in the dictionary
element TD[] that is used to store information is
probably shared by all invocations of the function
within the transaction.

It is similar to the problem where all invokations
share a common SD[]  for a particular function 
in the scope of a connection.

That this is a bug or a feature is debateable.  
Handling the memory scope is very tricky.

This is an educated guess. I have not looked at
the plpython code itself, altough I can vouch
for the behaviour.

elein

On Wednesday 14 May 2003 19:39, Tom Lane wrote:
> James Gregory <james <at> anchor.net.au> writes:
> > On Thu, 2003-05-15 at 01:53, Tom Lane wrote:
> >> Um.  There was a report that plpython triggers get confused if you try
> >> to apply the same trigger procedure to multiple tables (it tries to use
> >> the first table's row descriptor with all the other tables, and yes that
> >> can lead to a segfault).
> 
> > Is it only plpython that has the problem?
> 
> I'm not sure.  It's only been reported against plpython, but it seems
(Continue reading)

Permalink | Reply | 0 comments |
headers
Mark Kirkwood | 2 Jun 2003 01:51
Picon
Favicon

Re: qsort (was Re: Solaris)

That is probably the most reasonable conclusion to draw from the results ;-)

cheers

Mark

Bruce Momjian wrote:

>I assume we decided that BSD sort isn't fast enough to warrant replacing
>the native qsort.
>
>---------------------------------------------------------------------------
>
>Mark Kirkwood wrote:
>  
>
>>Mike Castle wrote:
>>
>>    
>>
>>>First I added a counter to the compare function, and the most cases, the
>>>glibc implementation was called significantly less often than the BSD
>>>compare function.
>>> 
>>>
>>>      
>>>
>>Interesting - all examples I tried had glibc compare count higher, do 
>>you want to post one of yours?
>>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Mike Withers | 2 Jun 2003 03:18
Picon
Picon
Favicon

Linked Servers

Hi

I like to ask if it is possible to set up linked servers in a similar 
fashion to MS SQL or Oracle such that there is a common login/workspace and 
query structure which identifies "server-database-table" at the SQL query 
level?

I have looked at FAQ and searched manuals and archives. Any suggestions?

Mike Withers
University of Western Sydney
Australia

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo <at> postgresql.org)
Permalink | Reply | 0 comments |

Gmane