On Wed, Jun 23, 2004 at 02:43:06PM +0900, Joel Matthew wrote:
> > We used to have some attempts at optimizing on the assumption that
> > char(n) fields were physically fixed-width, but we gave it up as a
> > bad job several major releases back ... it was never more than a
> > very marginal optimiza
hey thanks! can't believe it was as simple as 0 -> NULL. doh. count() works as expected now.
On Jun 20, 2004, at 11:17 AM, Markus Bertheau wrote:
Ð ÐÑÐ, 20.06.2004, Ð 17:44, kumar mcmillan ÐÐÑÐÑ:
hi.
I am using a pseudo "pivot table" SQL query to generate a report butI
am totally stumped on wh
Dear list,
I've got an application using PostgreSQL which is due to be moved servers.
I've been able to backup on the old and restore on the new server but only
once and as the current application is regularly being updated I'd like to
be able to do this repeatedly using the "clean" option. I t
On Sat, Jun 26, 2004 at 12:16:17PM +0200, Együd Csaba wrote:
> I've a problem with the perfprmance of the production environment.
> I've two db servers. One on my laptop computer (2Ghz, 1GB, WinXP, Cygwin,
> Postgres 7.3.4) and one on a production server (2GHz, 1GB, Ultra SCSI,
> RH7.1, Postgres 7
On 6/26/04 3:01 PM, "Keary Suska" <[EMAIL PROTECTED]> wrote:
>> I attempted to compile 7.4.3 with enable-thread-safety but it fails and
>> says it's not supported. My configure command was:
>>
>> ./configure --enable-thread-safety
>
> This is what I did for 10.3.4/7.4.2:
>
> 1. Enabled thread s
On Sat, 2004-06-26 at 04:16, EgyÃd Csaba wrote:
> Hi All,
> I've a problem with the perfprmance of the production environment.
> I've two db servers. One on my laptop computer (2Ghz, 1GB, WinXP, Cygwin,
> Postgres 7.3.4) and one on a production server (2GHz, 1GB, Ultra SCSI,
> RH7.1, Postgres 7.3.2
On Sat, 26 Jun 2004, elein wrote:
> Can someone explain the reasoning behind not allowing
> a user table to contain a foreign key of a system table?
>
> For example:
>
> create table myusers (
> login textreferences pg_catalog.pg_shadow(usename),
> ...
> );
>
> Fails with a messa
Can someone explain the reasoning behind not allowing
a user table to contain a foreign key of a system table?
For example:
create table myusers (
login textreferences pg_catalog.pg_shadow(usename),
...
);
Fails with a message about using system catalogs.
Using pg_user fail
hi people
i am having trouble getting postgresql qork on my debian system. i used
su postgres -c createdb jaydb
to create a database.after the execution of command i got
CREATE DATABASE
COMMENT
but when i try to acces the database i cannot access it .
please help
jay
---(e
Hi group,
I am trying to get pgsql working on my debian system. I installed pgsql
using apt-get. but then i cant connect to it . i am using the following
command
psql -U jay -d jaydb
earlier i used create su postgres 'createdb root' jaydb.
but now i cannot access the db.
i get the follwing msgs
Thanks, that worked!
Aaron Burghardt
[EMAIL PROTECTED]
On Jun 26, 2004, at 4:01 PM, Keary Suska wrote:
on 6/26/04 11:21 AM, [EMAIL PROTECTED] purportedly said:
I attempted to compile 7.4.3 with enable-thread-safety but it fails
and
says it's not supported. My configure command was:
./configu
11 matches
Mail list logo
