On Wednesday 14 September 2005 08:23, Scott Marlowe wrote:
> OK. But how many are you updating between regular vacuums? That's the
> real issue. If your regular vacuums aren't often enough, postgresql
> starts lengthening the tables instead of reusing the space in them that
> was freed by the l
robably because the bit after the SET is a "column-name" not a
> reference to a column. There's no point qualifying it in any way since
> the tablename is given as part of the UPDATE statement.
>
> On Tue, Nov 09, 2004 at 06:33:55PM -0800, John Fabiani wrote:
> > From t
From the 7.4 docs:
A column can be referenced in the form
correlation.columnname
correlation is the name of a table (possibly qualified with a schema name), or
an alias for a table defined by means of a FROM clause, or one of the key
words NEW or OLD. (NEW and OLD can only appear in rewrite ru
On Monday 01 November 2004 16:13, Ian Barwick wrote:
> On Mon, 1 Nov 2004 09:59:44 -0800, John Fabiani <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > First I'm trying to move a MySQL database to Postgres. I have to emulate
> > a MySQL sql statement - '&#
Hi,
First I'm trying to move a MySQL database to Postgres. I have to emulate a
MySQL sql statement - ''Describe tablename' which in general is '\d
tablename' from psql. If I use '-E' my 7.3.x provides three sql statements
and by 7.4.x produces four statements. But what I want is a single SQ
Hi all,
I'm looking for a way to get DBF tables into Postgres. I have been attempting
to compile pg2xbase without success. Does anyone feel kind enough to provide
the utility already compiled. I'm using SUSE 9.0. Again I'm not asking for
help in compiling but an RPM or something that already
I'm a newbie too. In my case I had to create the directories prior to
initdb. Also I had to create the linux user "postrgres".
John
"James Szabadics" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> I recently decided I would install Postgres 7.1.3 server on a Linux
> Redhat 7.1
I'm not sure what version of postgres you are using but if you are use 7.1.?
you edit the postgresql.conf file. The file is in the same location as the
data. Just uncomment the "tcpip_socket=false" and change the "false" to
"true". I'm giving fair warning "I'm a newbie". But this is how I fixe
