That is helpful but these functions to do help me detect errors in
queries such as "(moose & frog" where the left parentheses is
missing. I may just have to write a lexical analyzer.
Benjamin
On Sep 8, 2007, at 10:45 PM, Oleg Bartunov wrote:
There are two useful functions - numnode() and
There are two useful functions - numnode() and querytree()
More details in http://www.sai.msu.su/~megera/postgres/fts/doc/fts-query.html
Oleg
On Sat, 8 Sep 2007, Benjamin Arai wrote:
Is there a way to pass a query to PostgreSQL to check if the TSeasrch2 search
text is valid? For example,
SEL
Is there a way to pass a query to PostgreSQL to check if the
TSeasrch2 search text is valid? For example,
SELECT to_tsquery('default', '!');
returns an error. I want to know if there is a way get true/false
for the '!' portion of the query?
Benjamin
---(end of b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/08/07 19:58, novnov wrote:
> You're right, that's not how I understood your partitioning question. I'd not
> be eager to implement that kind of split in the db, though I can see that
> it's an example of how to spread the load around.
>
> But ba
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
> But basically, it seems that the answer to one of my questions is that there
> is currently no way with postgres to spread a single database over multiple
> servers, ala a loadbalanced apache cluster, where requests are forwarded to
> different boxes.
On 07/09/2007, Filip Rembiałkowski <[EMAIL PROTECTED]> wrote:
> 2007/9/5, Raj A <[EMAIL PROTECTED]>:
> > correction:
> >
> > > The result I'm expecting for the above to be
> > >
> > >notification_time| finished_time | actual
> > > +--
You're right, that's not how I understood your partitioning question. I'd not
be eager to implement that kind of split in the db, though I can see that
it's an example of how to spread the load around.
But basically, it seems that the answer to one of my questions is that there
is currently no wa
I have a trigger function that I want to apply to several tables, hence
my use of TG_RELNAME. I just want the record to get inserted if an
UPDATE comes from my view rule if the record for the client doesn't
already exist. This is what I have, but I'm finding the FOUND is not
returned for EXECUTE. H
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
>
> Yes the trx would be akin to banking operations.
>
> This is good: "Can you partition your data to multiple servers?" That's kind
> of my question! I've not dealt with RAC, data partitioning, any of those
> topics; just haven't had exposure. But sin
Yes the trx would be akin to banking operations.
This is good: "Can you partition your data to multiple servers?" That's kind
of my question! I've not dealt with RAC, data partitioning, any of those
topics; just haven't had exposure. But since you're asking me if the data
can be partitioned to d
On 9/8/07, Greg Sabino Mullane <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
> > Given past history of this project and its relation to
> > Stonebraker, I was tempted earlier today to suggest that
> > the Postgres vs. PostgreSQL renaming argument be dropped
On 9/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
> > On 9/8/07, Zenaan Harkness <[EMAIL PROTECTED]> wrote:
> >> In the meantimem, is there any option to allow pg to run in a privileged
> >> account on windows?
>
> > Your friend has the following choices i
On 9/7/07, Greg Smith <[EMAIL PROTECTED]> wrote:
> ... renaming the database "Horizontica".
Following the naming convention, wouldn't it be "Horizonta"?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On 9/8/07, Zenaan Harkness <[EMAIL PROTECTED]> wrote:
>> In the meantimem, is there any option to allow pg to run in a privileged
>> account on windows?
> Your friend has the following choices in the matter. He can stop
> running as an administrator a
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Given past history of this project and its relation to
> Stonebraker, I was tempted earlier today to suggest that
> the Postgres vs. PostgreSQL renaming argument be dropped
> in favor of renaming the database "Horizontica".
That name could
On 9/8/07, Zenaan Harkness <[EMAIL PROTECTED]> wrote:
> On Sat, Sep 08, 2007 at 09:45:21AM -0500, Scott Marlowe wrote:
> > On 9/8/07, Zenaan Harkness <[EMAIL PROTECTED]> wrote:
> > > A lack of a sense of control is simply one more barrier to potential
> > > switchers. Make sense?
> >
> > But by sta
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
>
> Yes, I realize that scaling must be a large and complicated topic. And that
> PostgresSQL is not as scaleable as Oracle etc.
Depends on how we're defining scalability. :)
I didn't explicitly say that RAC will outscale postgresql. It's just
one ap
I suppose you could set up a batch file to start Postgresql, create a short-cut
to pg_ctl and then modify the properties of the shortcut to run as under
different credentials (or use runas with a batch file). That'll require that
your friend enter the password for that account every time he sta
Yes, I realize that scaling must be a large and complicated topic. And that
PostgresSQL is not as scaleable as Oracle etc.
I know after reading your post that Postgres cannot match RAC. I'm still not
sure if Postgres can operate a database from more than one box, at all. If
it can, how? I mean is
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
>
> What happens when a database needs to scale beyond a single server? Is this
> something PostgreSQL can do?
>
> Further, does a database need to be designed differently if it's going to be
> used on more than one server? I know there are many issues t
What happens when a database needs to scale beyond a single server? Is this
something PostgreSQL can do?
Further, does a database need to be designed differently if it's going to be
used on more than one server? I know there are many issues that might effect
a database's ability to scale; but sp
On 9/7/07, Max Zorloff <[EMAIL PROTECTED]> wrote:
> On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen <[EMAIL PROTECTED]> wrote:
>
> >> The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has the
> >> following problem - after some time it
> >> just "hangs", and if I try to connect to it w
On Sat, Sep 08, 2007 at 09:45:21AM -0500, Scott Marlowe wrote:
> On 9/8/07, Zenaan Harkness <[EMAIL PROTECTED]> wrote:
> > A lack of a sense of control is simply one more barrier to potential
> > switchers. Make sense?
>
> But by starting postgresql under an administrative account, the user
> woul
On 9/8/07, Zenaan Harkness <[EMAIL PROTECTED]> wrote:
> A lack of a sense of control is simply one more barrier to potential
> switchers. Make sense?
But by starting postgresql under an administrative account, the user
would, in effect, be giving up that control to PostgreSQL to simply do
as it pl
On 9/8/07, Thorsten Kraus <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am looking for a tool which is able to generate a database diagramm
> including the relationships from an existing database schema. The only
> tool I know for this purpose is the Clay database plugin for eclipse.
> Are there any ot
2007/9/8, Denis Gasparin <[EMAIL PROTECTED]>:
>
> > This has certainly been discussed before.
> >
> > IIRC the real argument against that was, that fork() isn't the most
> > expensive thing to do anymore. And Postgres does lots of other stuff
> > after accept(), namely connecting to a certain datab
am Sat, dem 08.09.2007, um 11:44:17 +0200 mailte Thorsten Kraus folgendes:
> Hello,
>
> I am looking for a tool which is able to generate a database diagramm
> including the relationships from an existing database schema. The only
> tool I know for this purpose is the Clay database plugin for e
Hello,
I am looking for a tool which is able to generate a database diagramm
including the relationships from an existing database schema. The only
tool I know for this purpose is the Clay database plugin for eclipse.
Are there any other tools which can help me?
Best regards,
Thorsten
-
On Sat, Sep 08, 2007 at 09:52:04AM +0200, Thomas Kellerer wrote:
> Zenaan Harkness wrote on 08.09.2007 07:03:
> >Hi, a friend of mine on Windows, is attempting to convert to using
> >PostgreSQL (and of course, I'm helping him).
> >
> >The installation gave an option to run as an application, rather
On Sat, Sep 08, 2007 at 08:49:28AM +0100, Dave Page wrote:
> > From: Zenaan Harkness <[EMAIL PROTECTED]>
> > > >
> > > >
> > Is there a way to achieve this, on windows?
On Sat, Sep 08, 2007 at 08:26:04AM +0100, Richard Huxton wrote:
> Zenaan Harkness wrote:
> >Hi, a friend of mine on Windows, is attempting to convert to using
> >PostgreSQL (and of course, I'm helping him).
> >
> >The installation gave an option to run as an application, rather than as
> >a service
Zenaan Harkness wrote on 08.09.2007 07:03:
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
a service.
Turns out, my friends login account has Admin privs, and
> --- Original Message ---
> From: Zenaan Harkness <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: 08/09/07, 06:03:54
> Subject: [GENERAL] replacing Access/ Approach etc
>
> Is there a way to achieve this, on windows?
Yes, 8.2 will start under a admin
account just fine.
Paul Mendoza wrote:
Here is a problem I'm having with a function I've created. It should be
returning a varchar value no matter what the input is but I'm getting a null
value back. Then it says in the error that I'm using "nonstandard use of
escape in a string literal at character 9". What do you
Zenaan Harkness wrote:
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
a service.
Turns out, my friends login account has Admin privs, and postgres.exe
will n
> This has certainly been discussed before.
>
> IIRC the real argument against that was, that fork() isn't the most
> expensive thing to do anymore. And Postgres does lots of other stuff
> after accept(), namely connecting to a certain database,
> authenticating the user, etc..
Ok. I knew that. I
36 matches
Mail list logo
