At 13:06 29/11/00 -0500, Robert B. Easter wrote:
>When you compiled PostgreSQL, you have to give ./configure --with-perl so it
>will make the .so file its looking for. See ./configure --help next time.
>
We installed from RPM not source. Do we have to do a re-install from source
to get this wor
I would like to create a pgplsql function that return a record set. After I
spent a couple hours learning how to write plsql functions, but now I'm
stuck again. I know how to create the plsql function, but how do I call
plsql functions? Any ideas?
wooi.
"Alex Bolenok" <[EMAIL PROTECTED]> writes:
> peroon=# INSERT INTO t_foo (foo_value) VALUES (2000);
> NOTICE: fn_foo_ains: Start
> NOTICE: fn_foo_ains: End
> NOTICE: fn_bar_ains: Start
> NOTICE: fn_bar_ains: End
Looking at the code, it seems that all AFTER triggers are implicitly
handled as DE
* Tom Lane <[EMAIL PROTECTED]> [001129 20:22]:
> > I'd lean towards a pg_ping (Peter E., any comment here?)
>
> > Really we'd need to change the postmaster too, because what we need to
> > do is send a query "are you ready to accept connections?" that the
> > postmaster will answer without an aut
> I'd lean towards a pg_ping (Peter E., any comment here?)
> Really we'd need to change the postmaster too, because what we need to
> do is send a query "are you ready to accept connections?" that the
> postmaster will answer without an authentication exchange. AFAIR this
> is *not* immediately
>> How _much_ longer? (Sorry if it's a FAQ, in that case, I'd appreciate
>> a pointer/URL).
> Dunno, but I've been using 7.1devel for ~2 months, and so far,
> longer rows seem to work fine.
> More information on the TOAST project is at
> http://www.postgresql.org/projects/devel-toast.html
I t
On 30 Nov 2000, at 1:24, Igor V. Rafienko wrote:
> on Nov 29, 2000, 19:17, Joel Burton std::cout'ed:
>
> [snip]
>
> | > 5) BLOB Support.
> |
> | Keep in mind the pgsql 7.1 (about to go beta tomorrow, if I heard |
> right) will support much longer row sizes than 8k. Doesn't remove |
> the nee
Hi,
I had learned in theory that Hash indices are used for "=" and
B-tree for "<" ,">".
explain command doesn't tell us which index it is using. Hash or
Btree?
Also,
should a following query
"id < 1243" invoke a index ? (assuming there is an index on id).
I have seen Postgres
on Nov 29, 2000, 19:17, Joel Burton std::cout'ed:
[snip]
| > 5) BLOB Support.
|
| Keep in mind the pgsql 7.1 (about to go beta tomorrow, if I heard
| right) will support much longer row sizes than 8k. Doesn't remove
| the needs for blobs for many of us, but fixed my problems.
How _much_ lon
[re: question #4, speed/vacuuming]
> Do
> people need to vaccume their databases hourly? Can you vaccume while
> a database is in use? Any discussion on this curious phenomenon would
> be appreciated. It still boggles me.
I vacuum twice a day, once in the dead of night, once around
lunch.
GH <[EMAIL PROTECTED]> writes:
> running this script with "start" causes the postgres server to start,
> run out of files, and then shutdown. Postgres is useable until it runs
> out of files and shuts down.
Continuing on that line of thought --- it seems like this must be an
indication of a file
Alex Howansky <[EMAIL PROTECTED]> writes:
> Is there any way to determine exactly what a postgres process is
> doing at any time? The output from the ps command only shows "INSERT" or
> "SELECT", and not the full query string.
There isn't any really nice solution at the moment, but you could run
"kurt miller" <[EMAIL PROTECTED]> writes:
> I'm getting these log entries:
> ExecRestrPos: node type 18 not supported
> ExecMarkPos: node type 18 not supported
You're hitting the nested-mergejoin bug that was discovered awhile ago.
Aside from the log messages, you are probably getting wrong answe
I've looked in the docs, Bruce's book, and the list archives, but I've been
unable to find an answer to this. Any help would be greatly appreciated.
I have a database front-ended by a web site. All queries (apart from a few cron
jobs and developer's manual tests) come from the web site through P
I'm getting these log entries:
ExecRestrPos: node type 18 not supported
ExecMarkPos: node type 18 not supported
Any idea what they mean?
TIA,
-km
_
Get more from the Web. FREE MSN Explorer download : http://exp
Peter Eisentraut <[EMAIL PROTECTED]> writes:
>> Really we'd need to change the postmaster too, because what we need to
>> do is send a query "are you ready to accept connections?" that the
>> postmaster will answer without an authentication exchange.
> ISTM that the rejection of a client with aut
> > I am considering splitting the database into tables residing on separate
> > machines, and connect them on one master node.
> >
> > The question I have is:
> >
> > 1) How can I do this using PostgreSQL?
>
> You can't.
I'll jump in with a bit more info. Splitting tables across multiple
mac
17 matches
Mail list logo
