-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
> On Fri, 2006-09-01 at 11:03, Bruno Wolff III wrote:
>> On Thu, Aug 31, 2006 at 11:41:41 -0700, Josh Berkus
>> wrote:
[snip]
> The coercion of the GPL is legalistic. If you distribute GPL
> stuff, you've got to give out the sour
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Brandon Aiken wrote:
> Oh, I'm not saying that MySQL is a full-featured database, nor saying
> that I agree with the MySQL philosophy. I don't. That's why I'm trying
> to avoid MySQL.
>
> However PostgreSQL isn't any more accurate with FLOATs than
What parameters have to be passed to configure or make to build the
import library files like libpqddll.lib on win32 using msys and mingw?
Thank in advance
--
Keith Hutchison
http://balance-infosystems.com http://realopen.org
http://www.kasamba.com/Keith-Hutchison
---(en
On Fri, 2006-09-01 at 13:33, Brandon Aiken wrote:
> Of course the year exists. The date itself is nonsensical, however.
>
> 'January 3, 648' does reference a valid day, but the date itself has no
> meaning at that time in the world, so there is very little meaning in
> using Gregorian dates excep
On Fri, Sep 01, 2006 at 09:30:57AM -0400, Merlin Moncure wrote:
> On 8/31/06, Randall Lucas <[EMAIL PROTECTED]> wrote:
> >Now that I have this query, in order to make my case, I need to "sign
> >off" on all of the individual data that went into it. I would like to
> >do something like:
> >
> >
Anastasios Hatzis wrote:
rows = plpy.execute("""SELECT "FooHolding" WHERE "CoosOfFoo_vid" =
ORIGINALVALUE;""")
for row in rows:
for col in row:
plpy.execute("""INSERT INTO "FooHolding" ("CoosOfFoo_eid",
"CoosOfFoo_vid", "FoosOfCoo_eid", "FoosOfCoo_vid") VALUES (col[0],
COPYVALUE, c
On Thu, Aug 31, 2006 at 08:17:35AM -0700, SunWuKung wrote:
> From this array how could I get back the fact that this array
> consists of a two dimensional array with X elements?
>
> Select array_dims('{{1,4,10,11},{1,5,4,5}}'::text [])
>
> I would like to get back the number 4 here?
SELECT array
On Fri, 2006-09-01 at 11:03, Bruno Wolff III wrote:
> On Thu, Aug 31, 2006 at 11:41:41 -0700,
> Josh Berkus wrote:
> >
> > In general, I think that people who harp on PostgreSQL's lack of a
> > benevolent dictator as an inhibitor to progress are people who are not
> > comfortable with democra
On Fri, 2006-09-01 at 13:33, Brandon Aiken wrote:
> -Original Message-
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 01, 2006 2:27 PM
> To: Brandon Aiken
> Cc: pgsql general
> Subject: RE: [GENERAL] Precision of data types and functions
>
> On Fri, 2006-09-01
Of course the year exists. The date itself is nonsensical, however.
'January 3, 648' does reference a valid day, but the date itself has no
meaning at that time in the world, so there is very little meaning in
using Gregorian dates except to give us a relativistic idea of when it
occurred. Never
On Fri, 2006-09-01 at 10:41, Silvela, Jaime (Exchange) wrote:
> Lately my database crashed and I’ve had some strangeness following.
>
> I found that some tables would have two distinct rows with identical
> primary key.
>
>
>
> Now, VACUUM complains thusly
>
>
>
> WARNING: index "pg_stati
On Fri, 2006-09-01 at 13:24, Brandon Aiken wrote:
> > Now, MySQL's design to 9-fill fields when you try to enter a too-large
> > number is, in fact, stupid on MySQL's part. I consider that silent
> > truncation. Heck, MySQL lets you create a date on February 31st, or
> > prior to the year 1500, b
The Gregorian calendar was established in the 1500's by Pope Gregory,
so, no, those dates did not exist.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 2:22 PM
To: Brandon Aiken
Cc: pgsql general
Su
On Fri, 2006-09-01 at 10:37, Brandon Aiken wrote:
> Oh, I'm not saying that MySQL is a full-featured database, nor saying
> that I agree with the MySQL philosophy. I don't. That's why I'm trying
> to avoid MySQL.
>
> However PostgreSQL isn't any more accurate with FLOATs than MySQL is.
> The A
Patrick TJ McPhee wrote:
% Patrick TJ McPhee wrote:
[...]
[the query is "select 1"]
% > But if I turn on duration logging, I get timings like
% > LOG: duration: 91.480 ms
The logs and data are all one file system, which seems to be on a logical
volume with a single disk sitting under it.
Flor
Training I agree with, but certifications can go either way. A good
example of where certifications are generally NOT going to work in your
favour is the fiasco that Oracle has created with their OCP
certification over the past 6 or so years. So many people were pushed
through these OCP mills
Martijn van Oosterhout wrote:
> Do we want to keep relying on the system libraries for collation, or
> do we want to use a cross-platform library like ICU or do we want to
> create our own collation library?
ICU seems fine.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
--
> There's probably not much more we can learn at this point --- given
> that the entry is old, any other evidence is probably long gone.
I'm afraid I'll never be able to get soon enough to the evidence even if
it happens again, unless I manage to reproduce it myself, which I tried
but didn't succe
Greetings List:
I just want to share with my Open Source commrads a success story. We have
been working on converting a rather large and complex Logistics application
from a Commercial database engine and 4GL supplied Progress Software Corp. We
wrote the user interface in native X-Windows using
Csaba Nagy <[EMAIL PROTECTED]> writes:
>> Is this xmin quite a bit older than what you get for a freshly-created
>> temp table?
> I would say yes, this is a test system which is highly stressed from
> time to time, but does not get continuous load.
OK, so it seems we have an old pg_type entry t
Exactly Tom,I was missing a few paranthesis like a nut.Thanks for pointing out.Thanks and regards~HarpreetOn 9/1/06, Tom Lane <
[EMAIL PROTECTED]> wrote:"Harpreet Dhaliwal" <
[EMAIL PROTECTED]> writes:> sprintf(buffer, "INSERT INTO headers (id, header_content) VALUES ( %d,> SELECT contents FROM par
Greetings folks,
I've got a function that returns and array $foo, and an array $bar.
Is there an elegant way to test if $bar is a subset of $foo? I've been
looking through the docs and haven't found anything. Am I missing
something obvious, or am I out of luck?
Cheers,
Chris
--
On Thu, Aug 31, 2006 at 11:41:41 -0700,
Josh Berkus wrote:
>
> In general, I think that people who harp on PostgreSQL's lack of a
> benevolent dictator as an inhibitor to progress are people who are not
> comfortable with democracy and are looking for excuses why company X needs
> to "take o
On Thursday 31 August 2006 14:41, Josh Berkus wrote:
> > We do have portions of a meritocracy in place but we are by no means
> > mature in that arena. Likely because of our lock problem ;)
>
> What specific issues do you see? We're pretty strongly merit-based -- the
> only reservation I see on t
Lately my database crashed and I’ve
had some strangeness following.
I found that some tables would have two
distinct rows with identical primary key.
Now, VACUUM complains thusly
WARNING: index
"pg_statistic_relid_att_index" contains 2984 row versions, but table
contains 2983 row
Oh, I'm not saying that MySQL is a full-featured database, nor saying
that I agree with the MySQL philosophy. I don't. That's why I'm trying
to avoid MySQL.
However PostgreSQL isn't any more accurate with FLOATs than MySQL is.
The ANSI SQL standard for FLOAT is for an inaccurate number. It wa
Hi folks,
I have multiple tables where some of the rows need sometimes to be
duplicated, but where the copy record has in one column a different
value. I have an idea how I could realize this via functions, but
probably you have another suggestion?
Example table:
CREATE TABLE "FooHolding" (
We have recently upgraded from PostgreSQL 7.4.5 to 8.1.4. Our DB is
about 45GB in size and has about 100 tables, lots of stored
procedures, triggers etc.
The DB lived on a SAN and is accessed via Fibre Channel cards in an
IBM BladeCenter. The system is running RedHat Linux Enterprise 3 I
Anton de Wet wrote:
One problem I see the postresql at the moment (and I'm porbably touching
a can of worms here) is the lack of some sort of certification.
One thing linux (or Red Hat) is doing well is supplying the things that
corporates are looking for. And the first thing they look for w
On Fri, Sep 01, 2006 at 04:16:31PM +0200, Stefan Kaltenbrunner wrote:
> On the ICU vs. our own library I'm not sure what would be a good thing
> to do - ICU is _LARGE_ and we already have some perfectly fine and
> proven code for things like character conversion or timezone handling in
> the core .
Curtis Scheer <[EMAIL PROTECTED]> writes:
> However, when I try to insert a record into foo with any other value besides
> 1 it actually inserts the record but doesn't return the # of rows affected.
Works for me:
regression=# create table foo (foovalue int);
CREATE TABLE
regression=# CREATE OR RE
> Is this xmin quite a bit older than what you get for a freshly-created
> temp table?
I would say yes, this is a test system which is highly stressed from
time to time, but does not get continuous load.
test03=> select oid, xmin from pg_type where typname = 'temp_report';
oid| xmin
--
Csaba Nagy <[EMAIL PROTECTED]> writes:
> I executed what you suggest below, see the results below. Short
> conclusion: the type is there in pg_type, the relation is not there in
> pg_class. Is there anything I should look for more ?
> test03=> select oid, xmin from pg_type where typname = 'temp_re
"Harpreet Dhaliwal" <[EMAIL PROTECTED]> writes:
> sprintf(buffer, "INSERT INTO headers (id, header_content) VALUES ( %d,
> SELECT contents FROM parser WHERE id = %d ), id, id);
> SPI_exec(buffer,0).
You're short some parentheses --- try executing a comparable query
manually.
Martijn van Oosterhout wrote:
> On Fri, Sep 01, 2006 at 12:40:53PM +0200, Stefan Kaltenbrunner wrote:
>> heh if this is a request for a wishlist then I would suggest that we
>> should finally tackle one of the things most databases are doing better
>> then we (including MySQL) - that is better ch
On Fri, Sep 01, 2006 at 08:22:44AM -0500, Curtis Scheer wrote:
> I'm trying to prevent any further input of a particular field value via an
> insert rule with the following rule.
> Basically the stored procedure that it calls raises an exception. The
> behavior I wanted\excepted was to call the
[EMAIL PROTECTED] wrote:
We have a number of large corporate clients here
Anton,
Others are also looking for training so I am
starting a thread on it as I feel that the Topic
should be part of Advocacy. Opinions will likely
vary about certification -- but Training? Yes,
definitely needed.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christopher Browne wrote:
> In an attempt to throw the authorities off his trail, "Toffy" <[EMAIL
> PROTECTED]> transmitted:
>> Hi,
>> as i put Postrgesql and Mysql in the same server Linux (Fedora core 5),
>> is it possible that this configuration ma
On 8/31/06, Randall Lucas <[EMAIL PROTECTED]> wrote:
Now that I have this query, in order to make my case, I need to "sign
off" on all of the individual data that went into it. I would like to
do something like:
select last_query_shown_tuples();
schema | table_name | pk_columns | pk
On Fri, 2006-09-01 at 11:25, Csaba Nagy wrote:
> I executed what you suggest below [snip]
Ok... it looks like the postgres version is not what I expected and
reported in the first mail, but:
test03=> select version();
version
I’m trying to prevent any further input of a
particular field value via an insert rule with the following rule.
CREATE OR REPLACE RULE rule_foovalue AS
ON INSERT TO foo
WHERE new.foovalue = 1 DO SELECT
fooexception.fooexception
FROM fooexception() fooexception(fooexception
In an attempt to throw the authorities off his trail, "Toffy" <[EMAIL
PROTECTED]> transmitted:
> Hi,
> as i put Postrgesql and Mysql in the same server Linux (Fedora core 5),
> is it possible that this configuration may cause a strong deceleration
> of all system performace?
If either or both are
Details:
Postgres version 8.1
Table structure:
media=# \d fast_links
Table "public.fast_links"
Column |Type | Modifiers
+-+--
On Thu, 31 Aug 2006, [EMAIL PROTECTED] wrote:
Hello -
I am attempting to find a way to make use of arrays of text, as demonstraited
by the following:
CREATE TABLE messages (
id SERIAL,
format TEXT NOT NULL,
arguments TEXT[]
);
Into that table will be values that you would associate with
(Sending to the list as I accidently only replied to Roman with my earlier
reply)
Thanks for your assistance. This was a case of user error. To me the
examples I looked at used the double quote (") but on further inspection
they do indeed use double single quotes (').
The quote_literal function w
thanks!
I actually came to a similar solution after Roman's post.
Thanks all for the replies!
> Dan <[EMAIL PROTECTED]> schrieb:
>
>> Hey,
>>
>> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
>> function. Is this possible in 8.1?
>>
>> Ive found quite a few references o
Dan <[EMAIL PROTECTED]> schrieb:
> Hey,
>
> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
> function. Is this possible in 8.1?
>
> Ive found quite a few references on google using EXECUTE, but this seems
> relevant to earlier versions, not 8.1.
>
> I have a function li
On Fri, Sep 01, 2006 at 08:13:14PM +1000, Dan wrote:
> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
> function. Is this possible in 8.1?
...
> I have a function like this:
...
> Executing this function yields:
>
> # SELECT user_create('bob',1234,'bobspassword');
> ERROR
On Fri, Sep 01, 2006 at 08:13:14PM +1000, Dan wrote:
> Hey,
>
> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
> function. Is this possible in 8.1?
>
> Ive found quite a few references on google using EXECUTE, but this seems
> relevant to earlier versions, not 8.1.
Does
# [EMAIL PROTECTED] / 2006-09-01 20:13:14 +1000:
> Hey,
>
> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
> function. Is this possible in 8.1?
>
> Ive found quite a few references on google using EXECUTE, but this seems
> relevant to earlier versions, not 8.1.
>
> I hav
Hey,
I am running PostgreSQL 8.1.4 and I want to create a user from inside a
function. Is this possible in 8.1?
Ive found quite a few references on google using EXECUTE, but this seems
relevant to earlier versions, not 8.1.
I have a function like this:
CREATE FUNCTION user_create (un varchar, u
SunWuKung wrote:
> >From this array how could I get back the fact that this array consists
> of a two dimensional array with X elements?
>
> Select array_dims('{{1,4,10,11},{1,5,4,5}}'::text [])
>
> I would like to get back the number 4 here?
>
> Thanks for the help.
> Balázs
This is what I came
> We have a number of large corporate clients here
in South Africa,
> including some of the biggest banks, of which a
few are asking for
> training at the moment. It would be really nice to
have some form
> of
> certification available that we could present that
had some
> international
> cr
I executed what you suggest below, see the results below. Short
conclusion: the type is there in pg_type, the relation is not there in
pg_class. Is there anything I should look for more ?
Cheers,
Csaba.
> BTW, when this happens, does the error persist? If it's a race
> condition you'd expect not
On Fri, Sep 01, 2006 at 12:40:53PM +0200, Stefan Kaltenbrunner wrote:
> heh if this is a request for a wishlist then I would suggest that we
> should finally tackle one of the things most databases are doing better
> then we (including MySQL) - that is better charset/locale/collate support.
> esp
Alvaro Herrera wrote:
Bruce Momjian wrote:
Tom Lane wrote:
It's pointless to suppose that individual developers would really be
answerable to any project-wide management, since that's not who they're
paid by. So I tend to think that a project roadmap would be more of an
exercise in wishful t
hai is microsoft a marketing company OR software company ?
On Fri, Sep 01, 2006 at 03:41:12AM -0400, Jasbinder Bali wrote:
> The structure SPITupleTable is defined thus:
> If the select query returns 10 rows (say),
> how to access the result of each row separately?
Read this:
> >http://www.postgresql.org/docs/8.1/interactive/spi-interface-support.ht
On Fri, Sep 01, 2006 at 03:33:55AM -0400, Harpreet Dhaliwal wrote:
> Thats OK, but my question is why did the original insert not take place.
> Syntax error was in the select query that is fired as a result of the
> trigger
The trigger is part of the transaction. If the trigger fails, so does
the
The structure SPITupleTable is definedthus:typedef struct{MemoryContext tuptabcxt;/* memory context of result table */uint32 alloced;/* number of alloced vals */
uint32 free; /* number of free vals */TupleDesc tupdesc;/* row descripto
On Fri, Sep 01, 2006 at 02:02:57PM +0700, Jeroen T. Vermeulen wrote:
> Is gborg.postgresql.org having trouble? I just got a warning from a user
> that he couldn't get to the mailing lists, and sure enough, the site seems
> to be completely down.
It's known. It's also been discussed on this list a
Thats OK, but my question is why did the original insert not take place. Syntax error was in the select query that is fired as a result of the triggerThanks,~Harpreet
On 9/1/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
# [EMAIL PROTECTED] / 2006-09-01 03:19:03 -0400:> If that is the case then why
# [EMAIL PROTECTED] / 2006-09-01 03:19:03 -0400:
> If that is the case then why does it throw error in one on the insert
> queries in the shared object written in SPI without inserting the row on the
> table on which record is inserted.
>
> Follwing query in the shared object throws an error.
>
>
If that is the case then why does it throw error in one on the insert queries in the shared object written in SPI without inserting the row on the table on which record is inserted.Follwing query in the shared object throws an error.
INSERT INTO headers (id, header_content) VALUES (1, SELECT raw_em
On Thu, 31 Aug 2006, Josh Berkus wrote:
In general, I think that people who harp on PostgreSQL's lack of a
benevolent dictator as an inhibitor to progress are people who are not
comfortable with democracy and are looking for excuses why company X needs
to "take over the project for its own good.
Is gborg.postgresql.org having trouble? I just got a warning from a user
that he couldn't get to the mailing lists, and sure enough, the site seems
to be completely down.
Jeroen
---(end of broadcast)---
TIP 5: don't forget to increase your free
On Fri, Sep 01, 2006 at 02:51:59AM -0400, Harpreet Dhaliwal wrote:
> Hi,
> I've written a trigger after insert on a table (parser) and the trigger
> calls a function that dynamically loads a shared object written in C.
>
> This shared object intends to use the newly inserted row in the table on
>
67 matches
Mail list logo
