On Mon, 19 Jan 2004, Joshua D. Drake wrote:
> scott.marlowe wrote:
>
> >Is it possible to institute phrase searching with that system?
> >
> >
>
> It seems to work fine???
>
> Sincerely,
>
> Joshua D. Drake
Not really. with htdig, I can do "select distinct" on the 7.3 docs and I
get exact
On Wed, Jan 14, 2004 at 12:37:55PM -0800, Joshua D. Drake wrote:
> >I used to have that complaint until I got more aquainted with the docs.
> >When I used to use mysql I found that if I used search feature on their
> >docs
> >I could find exactly what I was looking for almost immediately. When I
On Thu, 15 Jan 2004, Julio Misael Gutierrez wrote:
> Good day,
> I´m testing PostGresql,
> I would like to Know why when I create a new table,
> postgresql create a new type with the same name of the table.
> Where I can find more information about this?.
To add to what Tom said, this allows you
On Wed, Jan 14, 2004 at 11:40:04AM -0800, Chris Ochs wrote:
> I am playing around with Erserver, but the download has to be updated from
> cvs or it won't even compile (corrupted file in the distribution). It
Fixing this has been on my TODO list for several weeks now, but it
keeps failing to mak
scott.marlowe wrote:
Is it possible to institute phrase searching with that system?
It seems to work fine???
Sincerely,
Joshua D. Drake
I.e.:
"create unique index"
"select distinct"
etc...
???
On Fri, 16 Jan 2004, Joshua D. Drake wrote:
Hello,
Took an hour today and made the 7.3.4
On Tue, 13 Jan 2004, Harry Jackson wrote:
> David Teran wrote:
> >
> > The real question was: are there open known bugs where a select
> > statement does not return a correct result, meaning a wrong number of
> > rows? Were there a lot of errors like this?
> > We are asking this because this mak
Mental <[EMAIL PROTECTED]> writes:
> We were having trouble with characters that were high ascii encoded.
You probably need to pay attention to your client_encoding setting,
and perhaps also reconsider what database encoding you are using.
If either of these is not SQL_ASCII then it had better be
Scott,
> "create unique index"
>
> "select distinct"
I believe that one does this by adding to the word root dictionary and
rebuilding the index. The problem is that then anything indexed as "select
distinct" shows up under searches for "select distinct" but not for
"distinct".
Try searchi
En un mensaje anterior, scott.marlowe escribió:
> On Sat, 17 Jan 2004, Joshua D. Drake wrote:
>
> > Hello,
> >
> > Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
> > reinitdb which means you do
>
> You may have missed where bill said he wanted to change a default limit
> f
En un mensaje anterior, scott.marlowe escribió:
> > 2) I would like to upgrade to 7.4.1 without having to re-edit any config
> > files or change any paths.
>
> Just backup the config files in $PGDATA to another directory, and toss
> them back into $PGDATA after the initdb
>
> > 3) I would like t
On Sat, 17 Jan 2004, Joshua D. Drake wrote:
> Hello,
>
> Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
> reinitdb which means you do
You may have missed where bill said he wanted to change a default limit
for plpgsql function args from 16 to something else. that will req
On Fri, 16 Jan 2004 [EMAIL PROTECTED] wrote:
>
> I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
> Did nothing special, just make && make install and all was well.
>
> I now have updated my ports collection via cvsup and see that the 7.4.1 port
> is available. So no
Is it possible to institute phrase searching with that system?
I.e.:
"create unique index"
"select distinct"
etc...
???
On Fri, 16 Jan 2004, Joshua D. Drake wrote:
> Hello,
>
> Took an hour today and made the 7.3.4, 7.4.1 and Practical PostgreSQL
> documentation
> all searchable using Open
On Sat, Jan 17, 2004 at 10:27:09PM -0500, Tom Lane wrote:
> Mental <[EMAIL PROTECTED]> writes:
> > The postgresql documentation for COPY FROM INFILE suggests that high-ascii
> > characters be encoded to a backslash followed by the octal value for the
> > character.
>
> While it's certainly possi
First I wish I knew how this was caused but here is our problem.
Sometime in the recent past we got a duplicate table. Here is the
result of a pg_dump with a pg_restore for just that table.
--
-- TOC entry 59 (OID 11462032)
-- Name: order_to_do; Type: TABLE; Schema: public; Owner: www
-- Data Pos
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 16 January 2004 21:50
> To: Martin Hampl
> Cc: [EMAIL PROTECTED]; Mark Cave-Ayland
> Subject: Re: [GENERAL] indexing with lower(...) -> queries
> are not optimised very well - Please Help
>
>
> Martin Hampl <[EMAI
Oops, meant to copy the list on this...
- Original Message -
From: "Chris Smith" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 8:01 AM
Subject: Re: [GENERAL] Very long time to commit or close connections
> > There are not that many things happenin
Erwin,
> Could this be related to a network problem ?
>
> Like RST not received by the client, making it believe the server did
> not acknowledge the connection.close(), eating up the server's resources
> ? No firewall/VPN gateways between you and your customer ?
Nice thought, but the app and dat
Hi all,
Imagine I have a PL/pgSQL function called myfunction that returns a
rowtype like this
CREATE TYPE mytype AS (a integer, b integer, c integer);
Imagine that I often need only 1 or 2 of this values, just say I need to
do query like these :
select a from myfunction()
select a,c from
Hi Claudia,
I have done a successuff schema and data migration from Oracle 8i to
PostgreSQL 7.4 by using the contrib : postgresql-7.4/contrib/Oracle/ora2pg
Regards,
Thierry
Cláudia Morgado wrote:
Hello!!
Somebody
could help me to pass the data that are of a database Oracle 8i for my
new dat
On 15. jan 2004, at 18:51, JustSomeGuy wrote:
I want to design a data base that can hold the following structure
struct {
unsigned short a;
unsigned short b;
unsigned int len;
unsigned char *data;
} myObject;
a and b describe the type of object, len is the number of bytes that
are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Chris Smith wrote:
| Hi everyone,
|
| I'm running into a rather serious problem in a production application
using
| PostgreSQL.
|
| We've got about a connection every 4 seconds being created to the
database.
| Most of the time, this causes no problems a
Title: Nachricht
Hello
Claudia
Have a
look at http://www.samse.fr/GPL/ora2pg/
Regards
Dieter
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Cláudia MorgadoSent: Monday, January 12, 2004
8:12 PMTo: [EMAIL PROTECTED]Subject:
[GE
23 matches
Mail list logo