On Sunday 31 August 2008, Christophe wrote:
> On Aug 31, 2008, at 7:44 PM, Guy Rouillier wrote:
> > CTOs/CIOs like to sleep at night.
>
> If you buy Oracle, and there's a problem, the conversation with the
> CEO is that "Oracle broke." With PG, even if you have exactly the
> same level of support
hi, all:
I use a plproxy to execute sql like below:
CREATE OR REPLACE FUNCTION public.dmlexec(query text,op text) RETURNS
setof integer AS $$
CLUSTER 'testcluster';
RUN ON all;
$$ LANGUAGE plproxy;
create or replace function public.dmlExec(query text, op text) returns
integer as $
Hi,
I¹m hoping someone can help me out on this one.
Two tables
table1 has 25 columns
table2 is a subset of table1 (create table2 as select
id,field1,field2,field3,field4,field5,field6 from table1) with just 7
columns
There is a primary key on ID
table2 was exported to a CSV, truncated, then th
On Sun, Aug 31, 2008 at 10:44:38PM -0400, Guy Rouillier wrote:
> M2Y wrote:
>>
>> Why most enterprises prefer Oracle than Postgres even though it is
>> free and has a decent enough user community.
>
> Databases are a critical part of many companies' business. I work
> for telecom company, and if
On Aug 31, 2008, at 7:44 PM, Guy Rouillier wrote:
CTOs/CIOs like to sleep at night.
If you buy Oracle, and there's a problem, the conversation with the
CEO is that "Oracle broke." With PG, even if you have exactly the
same level of support, "that database you selected broke."
The sad rea
M2Y wrote:
Why most enterprises prefer Oracle than Postgres even though it is
free and has a decent enough user community.
Databases are a critical part of many companies' business. I work for
telecom company, and if we were to lose our databases, we'd be out of
business, period. So, "fre
M2Y wrote:
> Hello,
>
> I am a CS graduate and I have a brief idea of Postgres and Oracle.
> But, I dont have an in-depth knowledge in any of them. I have a couple
> of questions and
>
> I want to compare both of them in terms of functionality, performance,
> advantages and disadvantages.
>
> Wh
Another thing that has only been mentioned obliquely is support. When an
organization selects an enterprise wide mission critical database system
they get a lot of perceived security from purchasing a world-wide 24x7
support contract from a company with the resources that Oracle can
provide. Ye
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> 7. Though I don't personally buy it, I have heard others complain
>> loudly that there is no print-version of Postgres documentation.
> This one should be taken off the list. The postgresql online
> reference manual is in print( volumes 1
On Sun, Aug 31, 2008 at 1:50 PM, Kevin Hunter <[EMAIL PROTECTED]> wrote:
> 7. Though I don't personally buy it, I have heard others complain
> loudly that there is no print-version of Postgres documentation.
This one should be taken off the list. The postgresql online
reference manual is in p
At 2:29pm -0400 on Sun, 31 Aug 2008, Srinivas wrote:
> I want to compare both of them in terms of functionality, performance,
> advantages and disadvantages.
If you publish anything, watch out for the Oracle licensing no-nos.
Specifically, I believe they disallow certain comparisons. I believe
pe
On Sun, Aug 31, 2008 at 12:29 PM, M2Y <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am a CS graduate and I have a brief idea of Postgres and Oracle.
> But, I dont have an in-depth knowledge in any of them. I have a couple
> of questions and
>
> I want to compare both of them in terms of functionality,
On Sun, Aug 31, 2008 at 11:29:32AM -0700, M2Y wrote:
> Hello,
>
> I am a CS graduate and I have a brief idea of Postgres and Oracle.
> But, I dont have an in-depth knowledge in any of them. I have a
> couple of questions and
>
> I want to compare both of them in terms of functionality,
> performa
Building my application and got the following error.
/usr/bin/ld: warning: libssl.so.4, needed by
../../../external/postgres/lib/libpq.so, not found (try using -rpath or -r
path-link)
/usr/bin/ld: warning: libcrypto.so.4, needed by
../../../external/postgres/lib/libpq.so, not found (try using -
Dear Madam or Sir!
I am just studying PostgreSQL 8.3.1 from a mag CD unfortunately under
MS-Windows.
Aye, it is under the BSD licence which allows for re-proprietarisation of
the code.
I lean more to the GPL, the GPL v3.x being a bit too strict in the case of
my GNU Business Model.
This provide
Hello,
I've got a large multi-process/multi-threaded VOIP application, that uses
UDP ports all over the place (internal communication, SIP ports, RTP ports,
etc).
Because of the opportunity for port duplication, we decided to have the
ports allocated from a table/stored procedure from our
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
>> Thus, when piping the output (from legacy host 192.168.2.2) to
>> populate the newly initialized cluster, by way of running (on the new
>> host 192.168.2.3)
>> pg_dumpall -h 192.168.2.2|psql
>> an error occurs in that first section when the s
Albretch Mueller wrote:
Also I know there is a DISTINCT keyword, but I also need to know how
many times the particular data in the column is repeated if it is,
that is why I need to go:
~
SELECT md5, COUNT(md5) AS md5cnt
FROM jdk1_6_0_07_txtfls_md5
WHERE (md5cnt > 1)
GROUP BY md5
ORDER BY m
Albretch Mueller wrote:
Varchar or text?
~
Is the length of the data read in always less than 255 bytes ( or
characters?)? ...
It may be more limited than that by application-domain-specific constraints -
e.g., a license plate might be statutorily limited to eight characters.
It might be
Hello,
I am a CS graduate and I have a brief idea of Postgres and Oracle.
But, I dont have an in-depth knowledge in any of them. I have a couple
of questions and
I want to compare both of them in terms of functionality, performance,
advantages and disadvantages.
Why most enterprises prefer Oracl
Thomas Finneid wrote:
Hi
A quick question, In the doc on the net for miscellaneous config
options, e.g. maintenance_work_mem, the doc states the argument is an
integer, but it does not state whether the number should be in Bytes,
KB, MB. From examples I have seen, I conclude its in KB, but is
Stanislav Raskin wrote:
> Now, if I increase OFFSET slowly, it works all the same way, until OFFSET
> reaches the value of 750. Then, the planner refuses to use an index scan and
> does a plain seq scan+sort, which makes the query about 10-20 times slower:
You may want to try setting enable_seqsc
Thomas Finneid <[EMAIL PROTECTED]> writes:
> A quick question, In the doc on the net for miscellaneous config
> options, e.g. maintenance_work_mem, the doc states the argument is an
> integer, but it does not state whether the number should be in Bytes,
> KB, MB. From examples I have seen, I con
> If there's a chance to upgrade to 8.3 please do so.
I am aware of the benefits with 8.3, but such an upgrade would require quite
some changes in our application, including introduction of explicit casting
mechanisms. We are going to do so sooner or later, but right now we need to
focus on othe
On Sun, Aug 31, 2008 at 7:14 AM, Stanislav Raskin <[EMAIL PROTECTED]> wrote:
> Hello everybody,
>
> Now, if I increase OFFSET slowly, it works all the same way, until OFFSET
> reaches the value of 750. Then, the planner refuses to use an index scan and
> does a plain seq scan+sort, which makes the
Hello everybody,
I have some weird behaviour with a pretty simple query, which I use in a web
front end to browse through pages of data.
SELECT
foo.id, get_processing_status(foo.id) AS status, foo.name,
foo.valid_until
FROM
foo
WHERE foo.active AND foo.valid_un
On Thu, Aug 28, 2008 at 1:42 AM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> Hi all!
>
Any clues about this?
Thanks in advance.
> I'm playing with client thread abort issues in Npgsql. And with a test
> sample one of our users provided us we are seeing that even after the
> client fin
Hi
A quick question, In the doc on the net for miscellaneous config
options, e.g. maintenance_work_mem, the doc states the argument is an
integer, but it does not state whether the number should be in Bytes,
KB, MB. From examples I have seen, I conclude its in KB, but is that
correct?
regar
28 matches
Mail list logo
