On Tue, 2 Sep 2008, Pedro Stavrinides wrote:
Hi All,
This is my first post to this mailing list, so apologies if I am sending my
message to the incorrect place...
My question: I have configured a very basic text search for our application,
but got stuck at the point where I need the search vec
Hi All,
This is my first post to this mailing list, so apologies if I am sending my
message to the incorrect place...
My question: I have configured a very basic text search for our application,
but got stuck at the point where I need the search vector to filter out some
unwanted text (HTML tags
Edoardo Panfili <[EMAIL PROTECTED]> writes:
> my enumerated type is (this is a subset)
> CREATE TYPE hibridation AS ENUM('none','genus','specie');
> function declaration
> CREATE FUNCTION ename(text,boolean,text,text RETURNS text AS
> 'funzioniGDB.so' LANGUAGE C IMMUTABLE;
> index creation (the
Oracle handles connecting to multiple databases (even on multiple/remote
computers) fairly seamlessly, PG does not (yet.) Oracle's toolsets (for
things like forms and reports) are much further developed than PG's too,
though there are 3rd party tools that work with both.
Back in the old mainframe
--- On Thu, 8/28/08, Masis, Alexander (US SSA) <[EMAIL PROTECTED]> wrote:
> From: Masis, Alexander (US SSA) <[EMAIL PROTECTED]>
> Subject: [GENERAL] MySQL LAST_INSERT_ID() to Postgres
> To: pgsql-general@postgresql.org
> Date: Thursday, August 28, 2008, 4:14 PM
> I was mapping C++ application c
As part of my log configuration, I log statements that take over 3
seconds. I find this very useful for optimising tables etc. The problem
is that it produces verbatim some very large statements which can create
huge log entries, which are probably responsible themselves for slowing
the system
Hello,
I have a problem with enumerated types in functions parameters.
my enumerated type is (this is a subset)
CREATE TYPE hibridation AS ENUM('none','genus','specie');
function declaration
CREATE FUNCTION ename(text,boolean,text,text RETURNS text AS
'funzioniGDB.so' LANGUAGE C IMMUTABLE;
i
mike stanton escribió:
>
> Hello all,
> I've got a problem I can't get round. I want to declare a refcursor variable
> in a C program and call a function which returns a refcursor portal to the
> main C program.
> When I compile the C program, I get a refcursor doesn´t exist message.
> Has anyo
On Mon, Sep 01, 2008 at 04:39:09PM +0200, Thomas Kellerer wrote:
> David Fetter, 01.09.2008 16:08:
>>> because we are making extensive usage of Oracle's windowing
>>> functions
>>
>> http://umitanuki.net/pgsql/wfv04/design.html
>
> I knew there was work going on regarding this, but I didn't know ho
David Fetter, 01.09.2008 16:08:
because we are making extensive usage of Oracle's windowing
functions
http://umitanuki.net/pgsql/wfv04/design.html
I knew there was work going on regarding this, but I didn't know how definite
the decision was to integrate that into 8.4
It's too bad lead(), l
Hello all,
I've got a problem I can't get round. I want to declare a refcursor variable in
a C program and call a function which returns a refcursor portal to the main C
program.
When I compile the C program, I get a refcursor doesn´t exist message. Has
anyone got a C program which uses a ref
On Mon, Sep 01, 2008 at 10:31:25AM +0200, Thomas Kellerer wrote:
> Scott Marlowe, 31.08.2008 22:44:
>> I think some of it is inertia. We've always used Oracle, let's
>> just keep on using it. The more conservative the IT department is,
>> the less likely they are to take chances with new technolo
Albretch Mueller wrote:
PostgreSQL has 60+ types and many look like eachother. How do you propose to
differentiate?
~
Data Types are basically about value ranges (how many bits do you
need to hold the value) and formatting.
That is exactly wrong, at least in the PostgreSQL approach to the ty
Chris Sano wrote:
I'm trying to build a SQL script that will create a database if it
doesn't already exist. I've looked everywhere and haven't been able to
find anything. Am I missing something? Thanks.
SELECT * FROM pg_database will tell you what databases exist.
--
Sent via pgsql-general ma
Bill wrote:
The SQL database servers I have worked with cannot use and index for a
SELECT of the form
SELECT * FROM ATABLE
WHERE AFIELD LIKE ?
because there is no way to know the location of the wild card until the
parameter value is known. InterBase and Firebird allow
SELECT * FROM ATABLE
Matthew Dennis wrote:
Given table T(c1 int) and function F(arg int) create an index on T using
F(c1). It appears that if you execute "create or replace function F"
and provide a different implementation that the index still contains the
results from the original implementation, thus if you exe
Thank you.
I was making it way too over-complicated.
Works perfectly
On 9/1/08 3:39 AM, "hubert depesz lubaczewski" <[EMAIL PROTECTED]> wrote:
> On Sun, Aug 31, 2008 at 11:31:32PM -0400, Aaron Burnett wrote:
>> table1 has 25 columns
>> table2 is a subset of table1 (create table2 as select
>>
Henry wrote:
On Sun, August 31, 2008 10:44 pm, Scott Marlowe wrote:
The other thing that holds back PostgreSQL right now is a lack of
experienced pgsql DBAs and application developers. That will change
over time.
And built-in, simple to use, reliable, flexible and fast replication.
Many a Pg
If you are using functions take a look at plProxy. We created it after
finding out that dblink wasn't good enough for us in oltp environments.
There are also some security issues related to dblink that should be given
serious consideration.
As for replication SkyTools and Londiste are alternatives
On Fri, Aug 29, 2008 at 2:07 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> On Fri, Aug 29, 2008 at 1:40 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
>
> Oh, that's weird - that code is filtering out system objects client
> side for some reason. I'll look at that.
I've committed a change to filter out
Scott Marlowe, 31.08.2008 22:44:
I think some of it is inertia. We've always used Oracle, let's just
keep on using it. The more conservative the IT department is, the
less likely they are to take chances with new technology.
It used to be there was about an 80/20 split between what things you
On Fri, Aug 29, 2008 at 2:39 PM, J Welcomecert <[EMAIL PROTECTED]> wrote:
It looks like you haven't openssl installed on your system, or you
didn't provided the right switches for compiling it?
Regards
Marco
--
Marco Bizzarri
http://notenotturne.blogspot.com/
http://iliveinpisa.blogspot.com/
On Mon, September 1, 2008 4:09 am, Craig Ringer wrote:
> Right now, PostgreSQL has network-based master-to-slave(s) clustering
> using Slony that permits slaves to operate online read-only as reporting
> servers etc. It also covers failover with the use of an external
> heartbeat/STONITH setup. How
On Sun, August 31, 2008 10:44 pm, Scott Marlowe wrote:
> The other thing that holds back PostgreSQL right now is a lack of
> experienced pgsql DBAs and application developers. That will change
> over time.
And built-in, simple to use, reliable, flexible and fast replication.
Many a Pg admin or i
On Sun, Aug 31, 2008 at 11:31:32PM -0400, Aaron Burnett wrote:
> 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,
I agree with David's comment. The business I work for recently proposed a FOSS
based solution for a client, but were told no FOSS solutions would be
considered. We had a subcontractor offer a support contract for an application
based on the same FOSS components, but with a support contract.
Th
26 matches
Mail list logo
