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
>
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 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.
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
# [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.
>
>
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
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
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 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
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
hai is microsoft a marketing company OR software company ?
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
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
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
> 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
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
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
# [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
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
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
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
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
(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
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
Details:
Postgres version 8.1
Table structure:
media=# \d fast_links
Table "public.fast_links"
Column |Type | Modifiers
+-+--
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
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
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
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
-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
[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.
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
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
"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.
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
> 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
--
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
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 .
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
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
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" (
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
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
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
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
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
--
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
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
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
> 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
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/
--
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
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
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
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 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
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
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 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
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 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
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 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:
> >
> >
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
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
-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
-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
67 matches
Mail list logo
