On 6/15/05 11:08 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
Tom,
I've been lurking on the pgsql forum for some time, and today I read a reply
you had posted, and thought to myself, "He probably has a good idea what is
causing my problem", so here it is, if you don't mind taking alook at it...
My
David <[EMAIL PROTECTED]> writes:
> Well, you guessed correctly. It was a configuration problem. By
> inserting the line:
> unix_socket_directory = '/var/run/postgresql'
> into postgresql.conf, it works as expected.
Well, you've still got an issue here somewhere, because if your server
a
I have a client who wants to use Delphi as a front end to a Database, I
would like to use PostgreSQL over MSSQL and have been looking at the
psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm
wondering if anyone has experience with it? Any help will be appreciated.
Thanks,
J
On Tue, Jun 14, 2005 at 11:22:34PM -0400, Tom Lane wrote:
> David <[EMAIL PROTECTED]> writes:
> > I've just upgraded from 7.4.7 to 8.0.3.
>
> On what platform, and how did you build or obtain each of these PG
> versions?
Oops - thought I included that but apparently didn't..
Platform is Debian.
On Fri, Jun 10, 2005 at 12:34:15PM -0400, Tom Lane wrote:
> "Colin E. Freas" <[EMAIL PROTECTED]> writes:
> > 2005-06-07 16:02:38 EDTLOG: statement: update pg_class set
> > reltriggers=foo.c from (select relname,count(tgrelid) as c from
> > pg_class,pg_trigger where pg_class.oid=tgrelid and relna
Hi I have a number of tables. I am interested in having some
internationalization capability so that the application and it's data
can be in more than one language. i18 will take care of the interface
but not the data. To internationalize the date, I am wanting to put the
internationalized tex
The test database is on one of the fedora 3 server and postgresql 7.4.7 [rpm installed] . I back it up with the command
pg_dump -Ft - b test > test.tar
And once the process finished I transfer it to another server via nfs and
restore it with
pg_restore -d test test.tar
I use this process for m
[EMAIL PROTECTED] (Pieter-Jan Savat) writes:
> I'm facing the following problem.
>
> I have a postgres 8.0 DB with a table 'results' containing 6.000.000
> records.
> This table has 16 indexes. Each one basically created to speed up
> different queries.
>
> Because of some glitch in the system ther
Hello,
I'm facing the following problem.
I have a postgres 8.0 DB with a table 'results' containing 6.000.000
records.
This table has 16 indexes. Each one basically created to speed up
different queries.
Because of some glitch in the system there has never been a VACUUM FULL
on this table.
