Yes, I read the doc...
And I have now created this function, which seems to be ok but when I try to
select
from it, I get an error telling me that "subquery must return only one column".
But
my subquery does return only one column...?
My function looks like this?
CREATE OR REPLACE FUNCTION try
Hi all,
I am running a data import in a Postgres 8.0.1 data base. The target
table is one with ~ 100 million rows. The imported data is around 40
million rows. The import is inserting 1 rows per transaction. The
table has a few indexes on it, a few foreign constraints, and one insert
trigger w
On 9/19/05 12:02 AM, "suresh ramasamy" <[EMAIL PROTECTED]> wrote:
> thanks for the info Devrim,
>
> by the way i'm newbie, i have followed the steps in the documentation for
> compiling and installation. I'm using FC4. ./cofigure completes immediately
> but the gmake running for nearly the whol
I can't find a reference in the docs for this...
I have a plperl function returning an int. The int is returned as the
result of a system call.
It is set to return a null if one of the inputs is null, but I can't see
how to return a null if the result is indeterminate. The function
currently re
On Mon, Sep 19, 2005 at 08:01:55AM +0200, Mario Weilguni wrote:
> I checked the documentation, and still do not get it. I can use SPI_copytuple
> to return a modified version of a tuple, but how do I modify a structure of
> type HeapTuple.
Does SPI_modifytuple() not do what you want?
--
Michae
Hello,
for sure, I'm just did not find this function. Thanks alot.
Best regards,
Mario
Am Montag, 19. September 2005 15:20 schrieb Michael Fuhr:
> On Mon, Sep 19, 2005 at 08:01:55AM +0200, Mario Weilguni wrote:
> > I checked the documentation, and still do not get it. I can use
> > SPI_
On Mon, Sep 19, 2005 at 10:52:23AM +1200, Brent Wood wrote:
> I have a plperl function returning an int. The int is returned as the
> result of a system call.
>
> It is set to return a null if one of the inputs is null, but I can't see
> how to return a null if the result is indeterminate. The fun
Hi,
I just hit twice the delete button on a function I spent two days writing
(without backing it up. I know... I know...). Is there a way to recover it?
A simple garbage would do the job. I don't know many software now that do
not implement a sort of simple mecanism to recover what we threw
Shiver me timbers, whats up with to_char()?!
Avast! Is there no way to get a month without it being padded to
nine characters? It makes using a database to actualy format a
date for output kinda impossible?
I'll have to walk the plank if I can't get an answer, the crew will
mutiny and leave me
Dear All
I am
PostgreSQL beginner. I am trying to write some values from external
source
table “Table1” (using PostGIS plugin) to 2 destination PostgreSQL
tables
“Table2” and “Table3” that describes relations of data:
Table1:
| A | B |
-
| 1 | 1 |
| 2 | 3 |
| 3 | 1 |
Table2
| C |
Hi.
We
are using PostgreSQL as the RDBMS for our product, and are very happy with it.
Recently, we have encountered a need to store a lot of binary files, mainly
images (up to ~100,000 files, with sizes varying from 300K-2MB).
The
question is, how well PostgreSQL performs with the b
Title: Message
provide an example of what you're trying to
do.
test=> select
date_part('month',current_date); date_part
--- 9(1
row)
test=> select
length(date_part('month',current_date)); length
1(1 row)
reid
-Original Message-Fr
May be you want the FM prefix, i.e. to_char(current_timestamp,
'FMMonth'). See the docs for more info:
http://www.postgresql.org/docs/8.0/interactive/functions-
formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE
On Sep 19, 2005, at 8:20 AM, Alex Turner wrote:
Shiver me timbers, whats up w
Tom,
Thanks for this. I am going to push for reproducing the problem in a
test environment. If I have any success, I will follow up with results
and more details.
__
Marc
On Sat, 2005-09-17 at 01:23 -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > On Fri, Sep 16, 2005 at 04
I am getting the initdb error when I do the
initdb for RHEL ES-4.Plesae advice me to fix this problem.
-bash-3.00$ /usr/bin/initdb -D /var/pgsql/dataThe files
belonging to this database system will be owned by user "postgres".This user
must also own the server process.
The database clust
Alex Turner wrote:
Shiver me timbers, whats up with to_char()?!
Avast! Is there no way to get a month without it being padded to nine
characters? It makes using a database to actualy format a date for
output kinda impossible?
I'll have to walk the plank if I can't get an answer, the crew w
50 pieces of eight to that man there!!
You are exactly right, the FM prefix is exactly what I'm seeking!
I missed that table right below the main formaing table that describes
the prefixes.
May you find much buried treasure,
Alex Turner
NetEconomistOn 9/19/05, Dianne Yumul <[EMAIL PROTECTED]> w
OK, I've investigated further a bit, and made some charts out of the
insert speed.
It looks like it is fluctuating in a very wide range even when it works
fast in average, and there's no "progressive" slow-down visible, it's
more like a sudden drop in average speed at one point. Note that even
af
Simultaneous VACUUMs in tables in different schemas appear to interact.
Observed in v7.4.5 & 7.4.8 on Fedora Core 1.
Details:
I have a database consisting of several schemas. Two of these schemas
are contain eight tables each (about 700K rows each), which are
populated and updated daily via
On 9/19/05, Bjørn T Johansen <[EMAIL PROTECTED]> wrote:
CREATE OR REPLACE FUNCTION trykkStatus (pressID INTEGER)RETURNS SetOf trykkstatus_type AS 'DECLAREorderID ordrenew.id%TYPE;tmprec trykkstatus_type%ROWTYPE;BEGINselect id into orderID from ordrenew where now() between trykkstart and pro
I thought a char field was supposed to return a padded string, and varchar was supposed to return a non-padded string?
I just checked though:
create table test (
stuff char(10)
);
insert into test values ('foo');
select stuff || 'lemon' from test;
This returns 'foolemon', not 'foo lemon
Add to that they just re-released Sid Meier's Pirates, and I'm a hopeless case mateys.
AlexOn 9/19/05, IanL PostgreSQL Lists <[EMAIL PROTECTED]> wrote:
Alex Turner wrote:> May you find much buried treasure,Somebody PLEASE burn his Privates of the Caribbean DVD!
Hi all.
I am receiving the following message when I do the vacuumdb process on
a production database:
INFO: vacuuming
"pg_catalog.pg_largeobject"
INFO: index
"pg_largeobject_loid_pn_index" now contains 4828104 row versions in
37078 pages
DETAIL: 278 index row versions were
removed.
On Mon, 2005-09-19 at 12:54, Alex Turner wrote:
> I thought a char field was supposed to return a padded string, and
> varchar was supposed to return a non-padded string?
>
> I just checked though:
>
> create table test (
> stuff char(10)
> );
>
> insert into test values ('foo');
>
> select stu
"Prasad Duggineni" <[EMAIL PROTECTED]> writes:
> I am getting the initdb error when I do the initdb for RHEL ES-4.Plesae =
> advice me to fix this problem.
I'm betting the reason you don't see any useful error message is that
it's being suppressed by SELinux. Try turning enforcement mode off
to
Scott Marlowe wrote:
> On Mon, 2005-09-19 at 12:54, Alex Turner wrote:
>> I thought a char field was supposed to return a padded string, and
>> varchar was supposed to return a non-padded string?
>>
>> I just checked though:
>>
>> create table test (
>> stuff char(10)
>> );
>>
>> insert into tes
"Ignacio Colmenero" <[EMAIL PROTECTED]> writes:
> I am receiving the following message when I do the vacuumdb process on a
> production database:
> vacuumdb: vacuuming of database "log" failed: ERROR: canceling query due to
> user request
Do you have a statement_timeout limit set?
"Reid Thompson" <[EMAIL PROTECTED]> writes:
> is this the expected result? i.e. in the past was the result incorrect?
> or is there a configuration param that controls this?
Yes, yes, and no. You could change the pg_cast entry for char-to-text
if you wanted, but then you would run into the other
On Mon, 2005-09-19 at 15:38, Tom Lane wrote:
> "Reid Thompson" <[EMAIL PROTECTED]> writes:
> > is this the expected result? i.e. in the past was the result incorrect?
> > or is there a configuration param that controls this?
>
> Yes, yes, and no. You could change the pg_cast entry for char-to-tex
No. The statement_timeout parameter is set to 0.
Thanks.
---
Ignacio Colmenero
Software Development
Micotan Software Company Ltd.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: September 19, 2005
No. The statement_timeout parameter is set to 0.
Thanks.
---
Ignacio Colmenero
Software Development
Micotan Software Company Ltd.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: September 19, 200
Brew,
Yep we tried that. It did nothing. The same pg_hba.conf change worked
when we later tried it with the client disconnected.
__
Marc
> Date: Fri, 16 Sep 2005 21:36:01 -0400 (EDT)
> From: [EMAIL PROTECTED]
> To: pgsql-general@postgresql.org
> Subject: Re: pg_ctl reload breaks our client
> Me
Added to TODO:
* Allow WAL traffic to be steamed to another server for stand-by
replication
---
Csaba Nagy wrote:
> Well, AFAICT this kind of replication in postgres is not be named "out
> of the box". Set
This change relates only to SPI, meaning plpsql. It does not help libpq.
---
Ilja Golshtein wrote:
> Hello!
>
> According to Tom's message
> http://archives.postgresql.org/pgsql-general/2005-06/msg00476.php
> we have the s
I am having with this simple trigger i wrote, worked when i created it
but now i get this error "Stack depth Limit Exceeded"
If someone could tell me what i am doing wrong i would be greatfull
Trigger
CREATE TRIGGER "updateKeys" AFTER UPDATE
ON "projects"."resource" FOR EACH ROW
EXECUTE PROC
On Monday 19 September 2005 07:08 am, Sean Davis wrote:
> On 9/19/05 12:02 AM, "suresh ramasamy" <[EMAIL PROTECTED]> wrote:
> > thanks for the info Devrim,
> >
> > by the way i'm newbie, i have followed the steps in the documentation for
> > compiling and installation. I'm using FC4. ./cofigure c
8.1 will have a define called MAKE_EXPIRED_TUPLES_VISIBLE so you can
recompile and see deleted rows. However, it isn't in 8.0 so you would
have to download a current snapshot, find that define, add it to your
release, compile, and use it.
-
On Sep 19, 2005, at 7:10 PM, Bruce Momjian wrote:
Added to TODO:
* Allow WAL traffic to be steamed to another server for stand-by
replication
"steamed" or "streamed"?
:)
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
ht
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> My original intention was to keep two sets of tables. The first
> containing only the working set of current records. The second
> containing all prior versions. I haven't experimented with such a setup
> yet and I'm wondering if it is even neces
Jamie Deppeler <[EMAIL PROTECTED]> writes:
> I am having with this simple trigger i wrote, worked when i created it
> but now i get this error "Stack depth Limit Exceeded"
You've written an infinite recursion: the trigger does another UPDATE on
the same table that it is an UPDATE trigger for. T
Hi!
>This change relates only to SPI, meaning plpsql. It does not help libpq.
Thanks for response.
I see.
Any hope it would be possible
to calculate number of rows inserted
in newly created table via
CREATE .. AS SELECT?
--
Best regards
Ilja Golshtein
---(end of broa
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My original intention was to keep two sets of tables. The first
containing only the working set of current records. The second
containing all prior versions. I haven't experimented with such a setup
yet and I'm wonde
42 matches
Mail list logo
