Hi,
I'm trying to generate graphics dynamically from a plperl function, like this:
CREATE OR REPLACE FUNCTION test_gd
(
IN aint4,
IN bint4,
OUT val int4,
OUT image
On Mon, Jul 24, 2006 at 11:43:39AM +0200, Philippe Lang wrote:
> The problem seems to come from the return_next, in conjunction with binary
> data:
>
>
> return_next
> (
> {
> val => $_[0] * $_[1],
> image => $im->gif(
Hello everybody,
I must replace an old server by a new one, and I decide to upgrade
postgresql 7.1.3 to 8.1.4.
But a lot of web script use a program name pgtclsh. I try to find somes
informations about it on the web, but all the information that I find
was for the older version thant 8.
Someone h
I just installed Postgres for Mac.
Also, where is a nice browser/editor for postgres? Something like the
OpenBase manager, but for Postgres. Something friendly and neat and
simple. I'm sick of all these stupid syntax errors making me spend
half a day doing something I could do in 1 minute.
On Jul 24, 2006, at 11:21 AM, Theodore H. Smith wrote:
I just installed Postgres for Mac.
Also, where is a nice browser/editor for postgres? Something like
the OpenBase manager, but for Postgres. Something friendly and neat
and simple. I'm sick of all these stupid syntax errors making me
Hi,
I'm getting the following error from my python script, which tries to
insert lots of data in one transaction:
libpq.OperationalError: ERROR: failed to fetch new tuple for AFTER trigger
I have several AFTER triggers in place, which one raises this error? I'm
sure I only INSERT data, no U
Well I tried NaviCat and some others, they seem to work. Perhaps the
problem was with REALbasic.
I can connect via perl, also, which is good.
What's a good way to store the database logic?
Say for example, I want to do something to the database, can I just
say something like DataBasePleas
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> I'm getting the following error from my python script, which tries to
> insert lots of data in one transaction:
> libpq.OperationalError: ERROR: failed to fetch new tuple for AFTER trigger
That's not supposed to happen. Can you provide a test ca
On 24 Jul 2006 at 17:57, Theodore H. Smith wrote:
> Say for example, I want to do something to the database, can I just
> say something like DataBasePleaseTryRegisterUser( "name", "details",
> "serial", "etc" ); where DataBasePleaseTryRegisterUser would be some
> kind of function stored in t
On Jul 24, 2006, at 12:57 PM, Theodore H. Smith wrote:
Well I tried NaviCat and some others, they seem to work. Perhaps
the problem was with REALbasic.
I don't know the details of REALBasic, but perhaps it uses ODBC or
some other "generic" connection method. In this case, you probably
ha
Hello Tom,
in the mean time I've traced the problem down to a 'CONSTRAINT' declared
as 'DEFERRABLE INITIALLY DEFERED'. As soon as I remove that constraint
the transaction commits nicely. BTW: I'm running in ISOLATION LEVEL
SERIALIZABLE, if that matters.
Has something changed so that it's wor
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> in the mean time I've traced the problem down to a 'CONSTRAINT' declared
> as 'DEFERRABLE INITIALLY DEFERED'. As soon as I remove that constraint
> the transaction commits nicely. BTW: I'm running in ISOLATION LEVEL
> SERIALIZABLE, if that matter
Hello,
When I tried to install postgresql 8.1.4, I got the following errors.
Could someone tell me what are missing or wrong please?
==
./configure --prefix='/home/postgresql/' --without-docdir --without-readline
. gmake
pg_backup_archiver.o(.text+0x
Hello,
When I tried to install postgresql 8.1.4, I got the following errors.
Could someone tell me what are missing or wrong please?
==
./configure --prefix='/home/postgresql/' --without-docdir
--without-readline
. gmake
pg_backup_archiver.o(.text+
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> Sorry, I was unclear: luckily the error is easily reproducible. The
> problem is just to cut unnecessary parts and to come up with a small
> test case. I'll give it a try tomorrow.
> As far as VACUUM is concerned: I run this data-loading script jus
On Mon, 2006-07-24 at 14:54 -0400, Tom Lane wrote:
> Right offhand the only way that I could see for the tuple to disappear
> before the trigger fires is if a concurrent VACUUM removed it, which
> should not happen for a tuple inserted by a still-active transaction.
> If you've got autovacuum runni
Emi Lu <[EMAIL PROTECTED]> writes:
> When I tried to install postgresql 8.1.4, I got the following errors.
> pg_backup_archiver.o(.text+0x10f4): In function `StartRestoreBlob':
> pg_backup_archiver.c: undefined reference to `lo_create'
> collect2: ld returned 1 exit status
It looks to me like ld
I've got a few questions about creating custom data types for PostgreSQL.
I'm not sure how to phrase the questions without an example, so here goes:
I'd like to create a custom data type representing a Medieval Knight.
(This isn't what I really want to do, it's just an example.)
One of the "pro
Emi Lu <[EMAIL PROTECTED]> writes:
> The full results for configuration and gmake are saved in the attached
> two files.
That's hardly full results from gmake --- it looks like it re-used a
whole pile of pre-existing .o files. Perhaps what you need is a "make
distclean" and start again.
Hi,
My wishlist for pg_{dump,restore} have only 1 item:
1) Thats "pg_restore -t file.bkp" returns not only the table,
but the related PK and indexes, like "pg_dump -t
makes with a operational database.
If you drop a table from a database, this drops whole table and,
obviously, your indexes. If
I'm working on an application ( using Catalyst ) and realized I was
using a user with too many privileges to access the database.
I've add a new user and as I go though granting various accesses to the
different tables I realized many of those tables have primary keys that
are generated by a s
HI!
Consider the following server side function:
CREATE FUNCTION my_function(int4) RETURNS SETOF int8 AS
$BODY$
SELECT
CASE WHEN (some_condition)
THEN (
SELECT ... -- arbitrary select (returning row(s) of int8 values)
)
ELSE (
SELECT ... -- arbitrary select (retur
On Mon, 24 Jul 2006, Christian Schoenebeck wrote:
> Consider the following server side function:
>
> CREATE FUNCTION my_function(int4) RETURNS SETOF int8 AS
> $BODY$
> SELECT
> CASE WHEN (some_condition)
> THEN (
> SELECT ... -- arbitrary select (returning row(s) of int8 values)
>
On 7/24/06, Redefined Horizons <[EMAIL PROTECTED]> wrote:
I've got a few questions about creating custom data types for PostgreSQL.
ok, i have a weakness for medieval stuff, so:
I'm not sure how to phrase the questions without an example, so here goes:
I'd like to create a custom data type r
i had some questions/thoughts on using sequences vs oids as pks... it's a
common requirement to obtain the last value of a sequence after an insert. most
other databases support such a feature, but since oid's are deprecated, and
only oid's are returned, this isn't supported by postgres (and perfor
Merlin,
Thank you very much for taking the time to write that detailed
response to my question. I appreciate it very much.
You have helped me understand my design issue better, but I have
another question if you have the patience to answer! :]
I am actually working on a spatial extension for Po
"Roderick A. Anderson" <[EMAIL PROTECTED]> writes:
> I've add a new user and as I go though granting various accesses to the
> different tables I realized many of those tables have primary keys that
> are generated by a sequence.
> Do I need to grant access on the sequences and what type of acce
Martijn van Oosterhout wrote:
> On Mon, Jul 24, 2006 at 11:43:39AM +0200, Philippe Lang wrote:
>> The problem seems to come from the return_next, in conjunction with
>> binary data:
>>
>>
>> return_next
>> (
>> {
>> val => $_[0] *
28 matches
Mail list logo
