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'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
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
"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
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
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
[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.
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
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 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
>> 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
> 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
* 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
"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
> > 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
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.
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
17 matches
Mail list logo
