On Fri, 9 Apr 2004, Christopher Browne wrote:
>
> ...Tom ... commented that all of the core developers make extensive use
> of the notion of having _many_ backends around, and therefore ...
>
> Core folk aren't likely to write up patches designed to shoot
> themselves in the foot this way ...
I's
Michael,
> > is it possible to use an index on the expression '(table_1.field &
> > table_2.field)::int > 0' ?
Not practically, no.
If it's important to you for comparisons to be indexed, then stop doing
bitwise stuff and normalize your tables. Bitwise fields are what is known
as "non-atom
> Robert Treat <[EMAIL PROTECTED]> writes:
>> On Thu, 2004-04-08 at 09:49, [EMAIL PROTECTED] wrote:
>>> (2) I would bet that *most* deployments of PostgreSQL only use one
database environment per server, so I'm not even sure that it would be
an
>>> issue for the majority of current or prospective u
Bruce Momjian wrote:
>
> Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
> there two of them there now?
There are indeed two - mine and the other one:
http://gborg.postgresql.org/project/pgtclng/
Version 1.5.0 released 2004-02-29 (source, manual, and Windows binary
[EMAIL PROTECTED] (Tom Lane) wrote:
> The cure is to cast the literal to some specific type when you
> do the CREATE.
I figured that was the case, and pointed that cure back to the
developer.
What I was hoping to hear was some way of coercing the data into a
more usable type after the fact. The
In the last exciting episode, [EMAIL PROTECTED] (Kevin Brown) wrote:
> If we want to be a bit paranoid (justifiable if you've got really
> important data on the line), we could also require that a version
> string exist in the config file. If the version string doesn't match
> the version of the p
Kevin Brown wrote:
If we're truly concerned about the possibility of multiple installations
attempting to use the same config, then the answer is simple: require
that the location of the config file be specified on the command line
and don't compile a default location into the binary. Similarly
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> What is "command output" and how does that differ from stdout?
>
> > In this case, stdout is going to psql's stdout, not to the command
> > stdout.
>
> Hm, I didn't realize it worked like that. So "command outpu
Tom Lane wrote:
> Honza Pazdziora <[EMAIL PROTECTED]> writes:
> > On Thu, Apr 08, 2004 at 10:31:44AM -0400, Tom Lane wrote:
> >> It seems that MySQL *will* read /etc/my.cnf if it
> >> exists, whether it's appropriate or not, and so it's impossible to have
> >> a truly independent test installation,
I'll be attending the MIT Sloan Innovation Lab Meeting at MIT on April
15 and 16. The topic of the meeting is "Exploring the Inner Workings of
User Innovation Communities". Some other folks from the open-source
community will be there, including individuals from Apache, Red Hat, and
Ximian.
If any
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> What is "command output" and how does that differ from stdout?
> In this case, stdout is going to psql's stdout, not to the command
> stdout.
Hm, I didn't realize it worked like that. So "command output" means
"where SELECT output wo
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I think the biggest problem is that stdin/stdout in COPY is different
> > from \copy. I propose we make stdin/stdout consistent for COPY and
> > \copy, where stdin always reads from command input, and stdout always
> > writes to comma
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I think the biggest problem is that stdin/stdout in COPY is different
> from \copy. I propose we make stdin/stdout consistent for COPY and
> \copy, where stdin always reads from command input, and stdout always
> writes to command output. This does brea
Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
there two of them there now?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be
Josh Berkus wrote:
> Folks,
>
> O'Reilly is talking about hosting "Code Sprints" for any projects that want
> them after OSCON this summer. For those unfamiliar with the term, the idea
> of a code sprint is to get together a bunch of hackers on some project (for
> example, perl or postgresql)
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> No it doesn't. EOF will do fine. The source program doesn't
> >> necessarily have to know anything about COPY, as long as its output is
> >> in a format COPY can cope with (eg, tab-delimited).
>
> > The current
Folks,
O'Reilly is talking about hosting "Code Sprints" for any projects that want
them after OSCON this summer. For those unfamiliar with the term, the idea
of a code sprint is to get together a bunch of hackers on some project (for
example, perl or postgresql) and over a day do an intensive
Here is a good article about the new features in the C99 standard:
http://www-106.ibm.com/developerworks/linux/library/l-c99.html?ca=dgr-lnxw03UsingC99
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your l
[EMAIL PROTECTED] writes:
> [ there isn't any locking associated with namespaces ]
Nor any other kind of object except tables...
There have been some discussions about fixing this, but the idea has
bogged down in concerns about performance and possible deadlocks.
To be completely correct, a quer
> Robert Treat <[EMAIL PROTECTED]> writes:
>> On Thu, 2004-04-08 at 09:49, [EMAIL PROTECTED] wrote:
>>> (2) I would bet that *most* deployments of PostgreSQL only use one
>>> database environment per server, so I'm not even sure that it would be
>>> an
>>> issue for the majority of current or prosp
Tom Lane said:
> "Dann Corbit" <[EMAIL PROTECTED]> writes:
>> The response from the Mingw team:
>
>>> Symbolic links to files and directories do not work on Win32
>>> in general. Support for symlink operation is limited to the source
>>> directory or file existing and being able to copy the source
On Thu, Apr 08, 2004 at 11:32:19AM -0400, Tom Lane wrote:
>
> > A counterexample of Apache shows that you can easily use -f or another
> > command line option to point the server to alternate master config
> > file (which I believe is the same with MySQL).
>
> According to
> http://www.mysql.com/
22 matches
Mail list logo
