Stephan,
Thanks for the initial help. I followed your instructions, but now I'm
getting an error: "ERROR: RelationBuildTriggers: 2 record(s) not found for
rel nametable". Where else would these triggers be referenced.
-
Nathan Barnett
-Original
When are the 7.0.3 RPM's expected to be released? Most of my production
servers use the RPM install and I would like to keep it that way, however I
would also like to move up to 7.0.3 some time soon.
Just wondering...
Matthew wrote:
>
> When are the 7.0.3 RPM's expected to be released? Most of my production
> servers use the RPM install and I would like to keep it that way, however I
> would also like to move up to 7.0.3 some time soon.
>
> Just wondering...
Today. Working on it now. What distribution are
"Nathan Barnett" <[EMAIL PROTECTED]> writes:
> Thanks for the initial help. I followed your instructions, but now I'm
> getting an error: "ERROR: RelationBuildTriggers: 2 record(s) not found for
> rel nametable". Where else would these triggers be referenced.
If you manually add/delete trigger
Will there be an RPM for Alpha?
-Original Message-
From: Lamar Owen [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 6:57 PM
To: Matthew
Cc: pgsql-general
Subject: Re: [GENERAL] 7.0.3 RPMs?
Matthew wrote:
>
> When are the 7.0.3 RPM's expected to be released? Most of my produ
Roger Wernersson wrote:
>
> Will there be an RPM for Alpha?
What distribution? I haven't yet rebuilt the RPMset on an Alpha for
7.0.3 -- if you want to take a shot at it, you can try. It will be
interesting to see if the 7.0.2 alpha patches apply smoothly and work
correctly for 7.0.3, as Ryan h
Hi!
I'm concidering Postgres instead of for example Oracle or DB2. Can anyone
tell me what platforms Postgres runs on?
* Alpha (True64)
* Sparc (Solaris)
* PowerPc (AIX)
* IA-64 (HP-UX)
What kind of performance can one expect from Postgres? Can I upload the
database into memory and run without
when i did what's described below, i had no problems at all with
PL/Perl (and, in fact, am using it for a couple of triggers that
are lightly used in a production environment)
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/pl/plperl/README?rev=1.2&content-type=text/x-cvsweb-
markup
you can
n.b. to clarify, i got PL/Perl working on RH Linux 6.2
am in the process of attempting to get it working on NT.
==BEGIN FORWARDED MESSAGE==
when i did what's described below, i had no problems at all with
PL/Perl (and, in fact, am using it for a couple of trig
I've upgraded to 7.0.3 and am logging. I'll let you know if I see it
again.
btw - do I need to send any signal to postmaster to let it know I've
rotated the log file?
btw2 - as far as upgrading goes, that was probably the quickest/easiest
I've every done. wahoo!
On Sat, 11 Nov 2000, Tom Lane
Philip Hallstrom <[EMAIL PROTECTED]> writes:
> btw - do I need to send any signal to postmaster to let it know I've
> rotated the log file?
AFAIK we don't really support log rotation currently --- you have to
stop/restart the postmaster and direct its stdout/stderr into a new
file :-(. There is
We run RH6.2 for production, but I have a few RH7.0 boxes that I would like
to upgrade soon also
> -Original Message-
> From: Lamar Owen [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 11:57 AM
> To: Matthew
> Cc: pgsql-general
> Subject: Re: [GENERAL] 7.0.3 RPMs?
Hi,
Thanks for that. My problem now is it would be nice to have a way to get this
in one SQL query. I can't find a way to split up the pg_trigger.tgargs column
up into components. The data I need is separated by "\000", but the column type
is bytea. How do I split it up? I've tried using instr an
Unfortunately I don't think there's a good way to do it in SQL itself.
You might be able to do something in one of the procedural
languages. When i did the support for the older pg_dump (which may
look nothing like the current one), all I did was enhance the code that
was already there to handl
I just checked the FTP site, and found the 7.0.3 RPMS. thanks much... I
will try them out tonight.
> -Original Message-
> From: Matthew [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 1:08 PM
> To: 'Lamar Owen'
> Cc: pgsql-general
> Subject: RE: [GENERAL] 7.0.3 RPMs?
Matthew wrote:
>
> I just checked the FTP site, and found the 7.0.3 RPMS. thanks much... I
> will try them out tonight.
Wait until I announce their availability -- a minor dependency problem
was just found that I need to fix before anyone uses those RPM's that
have been uploaded. Silly little
How would you do the simple task of returning multiple rows of multiple
columns in a function?
ie:
create function test()
return int, int
as
'select col1, col2 from a'
language 'sql';
assuming col1 and col2 are integers.. I would like to port my db app from
MS SQL to postgres and would really
Can you create a temporary table within a function?
In my functions I need to calculate some stuff.. Do some
manipulations.. Then return some values.. For this, in MS SQL, I currently
use temporary tables in my stored procs.. Can you do this in postgres? I
can't seem to get it to work..
Thanks
According to my copy of SQL For Smarties by Joe Celko (2nd ed, p. 411):
> The UNION removes all duplicate rows from the results and does
> not care from which table the duplicate rows came. We could
> use this feature to write a query to remove duplicates from a
> table:
>(TABLE tableA)
>
Denis Perchine wrote:
>
> Hello,
>
> I have very interesting problem. I have quite highly loaded database.
> Once a day I create new indices, and after that drop old ones. Ido this one
> by one.
>
Your "reindex" is different from REINDEX command,isn't it ?
> All is fine except this error messa
According to my copy of SQL For Smarties by Joe Celko (2nd ed, p. 411):
> The UNION removes all duplicate rows from the results and does
> not care from which table the duplicate rows came. We could
> use this feature to write a query to remove duplicates from a
> table:
>(TABLE tableA)
>
Hi,
I'm new on this list, so if the questions are better on some other
lists, please let me know!
Are there somewhere detailed informations about arrays?
Has Postgres some special array functions like push, shift, unshift ...
in Perl?
How it is possible to use arrays in subselects? I tested
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Denis Perchine wrote:
>> ERROR: Index 2050642 does not exist
>>
>> Looks like index oid was already resolved, but index was not locked yet...
>> And it was dropped just under the feet...
> Parser-rewriter-planner acquires a short term lock.
> This may
"Edward Q. Bridges" <[EMAIL PROTECTED]> writes:
> ebridges=> (select * from has_some_dupes)
> ebridges-> UNION
> ebridges-> (select * from has_some_dupes);
[ produces the same result as "select * from has_some_dupes" ]
Yup, that's a bug in 7.0.* (and a version or two before). There's
a planning
Is anybody familiar with this?
http://news.excite.com:80/news/bw/001107/pa-sanchez
Ned Lilly <[EMAIL PROTECTED]> writes:
> Is anybody familiar with this?
> http://news.excite.com:80/news/bw/001107/pa-sanchez
This strikes me as some people who hope to freeload off open-source
efforts, without having actually learned anything about how the
community works. Did you catch this:
:
On 14 November 2000 07:33, Hiroshi Inoue wrote:
> Denis Perchine wrote:
> > Hello,
> >
> > I have very interesting problem. I have quite highly loaded database.
> > Once a day I create new indices, and after that drop old ones. Ido this
> > one by one.
>
> Your "reindex" is different from REINDEX c
Quickie questions:
When VACUUM VERBOSE says a table has x pages, what is the size of
the indicated page?
I'm trying to correlate table size with the output of an EXPLAIN
of the SELECT INTO which created it.
I've got 33150 rows which the EXPLAIN said at top level would be
80-byte rows. VACUUM i
On Mon, Nov 13, 2000 at 11:42:51AM -0600, Matthew wrote:
> When are the 7.0.3 RPM's expected to be released? Most of my production
> servers use the RPM install and I would like to keep it that way, however I
> would also like to move up to 7.0.3 some time soon.
there is polish(ed) linux distrib
And now it's on www.slashdot.org ...
http://slashdot.org/articles/00/11/13/1342208.shtml
Poul L. Christiansen
Michael Fork wrote:
>
> Thought this may be of interest to some...
>
> http://www.phpbuilder.com/columns/tim20001112.php3
>
> Michael Fork - CCNA - MCP - A+
> Network Support - Toled
30 matches
Mail list logo
