Hi Peter,
I agree 100% with you. EAV can be a good "middle of the road" appoach as
you suggest.
Peter Hunsberger wrote:
My take on this, for the research world, is to not go pure EAV, but
rather normalize by some more generic concepts within the domain. Eg.
"measurement", or "evaluation", e
On Fri, Oct 23, 2009 at 5:53 PM, Leif B. Kristensen wrote:
> I've followed this list for quite a long time, and I think that I've
> discovered a pattern that I would like to discuss.
>
> It seems like there are two camps considering EAV models. On the one
> hand, there are researchers who think th
Hello
Can the string literal syntax for the function body in a CREATE FUNCTION
statement please,
please be dropped ?
http://www.postgresql.org/docs/8.4/interactive/plpgsql-structure.html
It is so annoying and not ISO/ANSI and not compatible with other DBMSs...
I have written a mail about SQL c
is postgres a good solution for billion record data, think of 300kb data
insert into db at each minutes, I'm coding with php
what do you recommend to manage these data?
--
Shahrzad Khorrami
Hi all,
my database entered in recovery mode last week,
analyzing log file of server found this error:
cat /var/log/menssages
kernel: postmaster[1023]: segfault at fff0 rip 0060d993
rsp 7fff15f53c28 error 4
which means that?
att
Paul
__
Timothy Madden writes:
> Can the string literal syntax for the function body in a CREATE FUNCTION
> statement please,
> please be dropped ?
No. Since the function's language might be anything, there's no way to
identify the end of the function body otherwise.
regards, to
On Fri, 2009-10-23 at 23:53 +0200, Leif B. Kristensen wrote:
> I've followed this list for quite a long time, and I think that I've
> discovered a pattern that I would like to discuss.
>
> It seems like there are two camps considering EAV models. On the one
> hand, there are researchers who thin
Hi all,
my database entered in recovery mode last week,
analyzing log file of server found this error:
cat /var/log/menssages
kernel: postmaster[1023]: segfault at fff0 rip 0060d993
rsp 7fff15f53c28 error 4
which means that?
att
Paul
_
How can I list the permissions of a given user/role for a specific
relation/view/index, etc.?
Thanks!
Kynn
Le 24/10/09 06:46, Pavel Stehule a écrit :
2009/10/24 Bruno Baguette :
Hello !
I'm trying to write a little trigger function with variable arguments
quantity (at least one, but can be 2,3,4 arguments).
Theses arguments are fields name, so only varchar variable.
Since it is a dynamic query, I u
I'm trying to reconstruct create operator class statements from the
catalogs. My problem is that access method operators are related only
to their operator families.
My current assumtion is that all operators for an operator class will
have the same left and right operand types as the data type (
In addition to this what about MySQL, how much data (records) that can be
managed with it?
regards
On Sun, Oct 25, 2009 at 3:32 AM, shahrzad khorrami <
shahrzad.khorr...@gmail.com> wrote:
> is postgres a good solution for billion record data, think of 300kb data
> insert into db at each minutes,
On 24/10/2009 20:46, Tawita Tererei wrote:
> In addition to this what about MySQL, how much data (records) that can be
> managed with it?
>
> regards
>
> On Sun, Oct 25, 2009 at 3:32 AM, shahrzad khorrami <
> shahrzad.khorr...@gmail.com> wrote:
>
>> is postgres a good solution for billion record
2009/10/24 Bruno Baguette :
> Le 24/10/09 06:46, Pavel Stehule a écrit :
>>
>> 2009/10/24 Bruno Baguette :
>>>
>>> Hello !
>>>
>>> I'm trying to write a little trigger function with variable arguments
>>> quantity (at least one, but can be 2,3,4 arguments).
>>> Theses arguments are fields name, so
On Sat, Oct 24, 2009 at 1:46 PM, Tawita Tererei wrote:
> In addition to this what about MySQL, how much data (records) that can be
> managed with it?
That's a question for the mysql mailing lists / forums really. I do
know there's some artificial limit in the low billions that you have
to create
On Sat, Oct 24, 2009 at 7:32 AM, shahrzad khorrami
wrote:
> is postgres a good solution for billion record data, think of 300kb data
> insert into db at each minutes, I'm coding with php
> what do you recommend to manage these data?
You'll want a server with LOTS of hard drives spinning under it.
Le 24/10/09 22:09, Pavel Stehule a écrit :
you can use plperl or plpython for this task.
Pavel
re-Hello Pavel,
I always used plpgsql because I *thought* it was the most powerfull
procedural language for stored procedures in PostgreSQL.
The fact that PL/pgSQL is most documented than PL/Tcl
On Sat, Oct 24, 2009 at 2:43 PM, Scott Marlowe wrote:
> On Sat, Oct 24, 2009 at 7:32 AM, shahrzad khorrami
> wrote:
>> is postgres a good solution for billion record data, think of 300kb data
>> insert into db at each minutes, I'm coding with php
>> what do you recommend to manage these data?
>
>
2009/10/24 Bruno Baguette :
> Le 24/10/09 22:09, Pavel Stehule a écrit :
>>
>> you can use plperl or plpython for this task.
>>
>> Pavel
>
> re-Hello Pavel,
>
> I always used plpgsql because I *thought* it was the most powerfull
> procedural language for stored procedures in PostgreSQL.
plpgsql is
paulo matadr writes:
> analyzing log file of server found this error:
> cat /var/log/menssages
> kernel: postmaster[1023]: segfault at fff0 rip 0060d993
> rsp 7fff15f53c28 error 4
> which means that?
Well, it's a crash, but there's not nearly enough information here
Marc Munro writes:
> I'm trying to reconstruct create operator class statements from the
> catalogs. My problem is that access method operators are related only
> to their operator families.
That's because operators might not be in any class.
If you really want to find this out, look in pg_depe
Raymond O'Donnell wrote:
On 24/10/2009 20:46, Tawita Tererei wrote:
In addition to this what about MySQL, how much data (records) that can be
managed with it?
regards
On Sun, Oct 25, 2009 at 3:32 AM, shahrzad khorrami <
shahrzad.khorr...@gmail.com> wrote:
is postgres a good solution for bill
22 matches
Mail list logo
