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
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 you
"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 triggers
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
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
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.2content-type=text/x-cvsweb-
markup
you can
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
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
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..
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 message I
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
"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 step
Is anybody familiar with this?
http://news.excite.com:80/news/bw/001107/pa-sanchez
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 command,isn't
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
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
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 - Toledo
25 matches
Mail list logo