On Fri, Dec 26, 2003 at 04:07:50PM -0800, David Fetter wrote:
> \dfT integer
>
> might bring back all the functions that operate on (or return)
> integers.
I like this the best so far. My only concern is that there is a
whole lot of output generated by this (see thread parent).
> > > Duplicatio
A E wrote:
I am attempting to use Setof Record dynamically. I am developing an
application where I will not know what the end-user is trying to work
with from a web front end. Thus I will not know before hand the
structure of the table I am trying to pull the record from.
[code]
I know that I woul
On Fri, Dec 26, 2003 at 06:34:47PM -0500, Alex J. Avriette wrote:
> On Fri, Dec 26, 2003 at 11:49:20AM -0600, David Fetter wrote:
> > > The latter is harder to answer than the former. For the former,
> > > I propose a macro in psql, "\qf" (query function). Obviously,
> > > the name implies a broad
On Fri, Dec 26, 2003 at 11:49:20AM -0600, David Fetter wrote:
> > The latter is harder to answer than the former. For the former, I
> > propose a macro in psql, "\qf" (query function). Obviously, the name
> > implies a broader scope than simply querying the datatypes
> > permissable.
> * Part of
Hi,
I am attempting to use Setof Record dynamically. I am developing an application where I will not know what the end-user is trying to work with from a web front end. Thus I will not know before hand the structure of the table I am trying to pull the record from.
My Code:
CREATE FUNCTION
Eric Ridge <[EMAIL PROTECTED]> writes:
> I assume the doc chapter on Page Files and the various storage-related
> README files are good places for more information. Any other tips or
> pointers?
Not right offhand, but feel free to ask questions when you get stuck.
Also don't forget that there's
from log :
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork checkpoint process: Resource temporarily unavailable
ulimit -a :
core file size(blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (block
On Dec 26, 2003, at 4:04 PM, Tom Lane wrote:
Eric Ridge <[EMAIL PROTECTED]> writes:
Xapian has it's own storage subsystem, and that's what I'm using to
store the index... not using anything internal to postgres (although
this could change).
I would say you have absolutely zero chance of making it
PostgreSQL runs beautifully together with JBoss (or any other J2EE platform)
using its current JDBC driver so the idea of a co-bundle is not far fetched
at all.
I'm not an advocate for a backend rewrite to Java. I'm however a firm
believer that Java and the J2EE platform will become (if it isn't a
Eric Ridge <[EMAIL PROTECTED]> writes:
> Xapian has it's own storage subsystem, and that's what I'm using to
> store the index... not using anything internal to postgres (although
> this could change).
I would say you have absolutely zero chance of making it work that way.
You will not be able t
On Dec 26, 2003, at 3:22 PM, Tom Lane wrote:
3) How does one get the $PGDATA directory?
DataDir. Why should you care? An index AM that wants to know this is
probably broken IMHO; it's certainly trying to do something that's
outside the charter of index AMs, and is likely to cause lots of
headache
ivan <[EMAIL PROTECTED]> writes:
> the error is : could not fork new process for connection: Resource
> temporarily unavailable
We could have saved some time if you'd spelled out the full error
message to begin with.
This is undoubtedly a kernel-imposed restriction you are running into.
I'm not s
> ivan <[EMAIL PROTECTED]> writes:
>>> i need to connect to by my database more then 100 connections,
>>> but after ~20-30 conn, postmaster says me "Resource temporarily
>>> unavailable", what are this resource ?
> ulimit -u = 256 ,
> it's ok, ?
Mph. Well, that doesn't seem to be the problem, u
Eric Ridge <[EMAIL PROTECTED]> writes:
> 1) Is it possible for an access method to receive some kind of "DROP
> INDEX" notification?
No.
> select * from test where stuff => 'stuff' AND NOT more_stuff =>
> '"drink beer"';
> has this plan:
To do better here, you'd need to invent a "not-=>'
ulimit -u = 256 ,
it's ok, ?
On Fri, 26 Dec 2003, Tom Lane wrote:
> ivan <[EMAIL PROTECTED]> writes:
> > i need to connect to by my database more then 100 connections,
> > but after ~20-30 conn, postmaster says me "Resource temporarily
> > unavailable", what are this resource ?
>
> First bet is
.. many others stuf ...
the error is : could not fork new process for connection: Resource
temporarily unavailable
On Fri, 26 Dec 2003, Joshua D. Drake wrote:
> Hello,
>
> Perhaps you have too many open files? What else is running on this
> machine?
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
In manage-ag.sgml our docs says:
[...]
risk. To allow it, you must compile PostgreSQL with
the C preprocessor macro ALLOW_ABSOLUTE_DBPATHS
defined. One way to do this is to run the compilation step like
this:
gmake CPPFLAGS=-DALLOW_ABSOLUTE_DBPATHS all
[...]
I wonder if there's
(I started with this addressed to the -general list, but it just
doesn't seem like a general usage topic. If -hackers is the wrong
place, please point me in the right direction).
I've been working on a custom index type (access method) that allows
postgres to do fulltext searching (including p
DBT-2 and PostgreSQL 7.4 is finally working with LVM2 at 100 and 200
warehouse scale factors on 8-processor system in STP with 40 drives (38
managed under LVM), but not without a few catches. I have written up
some brief instructions on how to execute the test successfully with the
Linux-2.6.0 stab
Hello,
Perhaps you have too many open files? What else is running on this
machine?
Sincerely,
Joshua D. Drake
ivan wrote:
max_connections=200
shared_buffers=2000
ram = 500M + 300M swap
hdd = infinite
On Fri, 26 Dec 2003, Joshua D. Drake wrote:
hi
i need to connect to by my database more
ivan <[EMAIL PROTECTED]> writes:
> i need to connect to by my database more then 100 connections,
> but after ~20-30 conn, postmaster says me "Resource temporarily
> unavailable", what are this resource ?
First bet is that you are running into a maximum-number-of-processes-
per-user limit imposed
max_connections=200
shared_buffers=2000
ram = 500M + 300M swap
hdd = infinite
On Fri, 26 Dec 2003, Joshua D. Drake wrote:
>
> >hi
> >
> >i need to connect to by my database more then 100 connections,
> >but after ~20-30 conn, postmaster says me "Resource temporarily
> >
> >
> >unavailable", wh
hi
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me "Resource temporarily
unavailable", what are this resource ?
We need more info. What does your postgresql.conf say about
max_connections? How much ram do you have? How much
shared mem
"Alex J. Avriette" <[EMAIL PROTECTED]> wrote:
> I'd like to request the following feature:
>
> Frequently when answering questions on IRC for people, questions
> fall into one of two categories, "what function can I use to
> manipulate datatype xyz," and "what datatype can i use for xyz."
>
> The
hi
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me "Resource temporarily
unavailable", what are this resource ?
im using debain with kernel 2.4.23-pre7, on P4 , (postgres 7.4.1)
what can be wrong ?
---(end of bro
On Fri, Dec 26, 2003 at 10:48:20AM -, Dave Page wrote:
> It's rumoured that David Fetter once said:
> >
> > I guess that's OK, but it shows up like a beacon to all kinds of
> > hostile gear. Passive systems are usually a better bet.
>
> Are there many hostile forces in your hallway?
Most day
It's rumoured that David Fetter once said:
>
> I guess that's OK, but it shows up like a beacon to all kinds of
> hostile gear. Passive systems are usually a better bet.
Are there many hostile forces in your hallway?
:-)
/D
---(end of broadcast)---
27 matches
Mail list logo
