Trato de borrar el usuario postgres y me dice que no existe , luego
vuelvo a consultar la tabla pg_shadow y sale esto
1: usename = "postgres" typeid = 19, len = 64, typmod = -1, byval = f)
2: usesysid = "1" (typeid = 23, len = 4, typmod = -1, byval = t)
3: usecreatedb = "t" (typeid = 16, le
esto tratando de hacer los que dices abajo
borrar el usuario , los cree pero nuevamente me crea dos registros
select * from pg_user;
1: usename (typeid = 19, len = 64, typmod = -1, byval = f)
2: usesysid(typeid = 23, len = 4, typmod = -1, byval = t)
3: usecr
Peter Eisentraut wrote:
Andy Shellam (Mailing Lists) wrote:
Not particularly!! Don't know what it is but it doesn't _appear_ to
be GNU. According to "man make" it is a "FreeBSD General Command." I
can tell you that "./configure && make && make install" works and
builds a working Postgres ser
Andy Shellam (Mailing Lists) wrote:
> Not particularly!! Don't know what it is but it doesn't _appear_ to
> be GNU. According to "man make" it is a "FreeBSD General Command." I
> can tell you that "./configure && make && make install" works and
> builds a working Postgres server just fine, it's ju
On 2/18/07, pedro noticioso <[EMAIL PROTECTED]> wrote:
-rw--- 1 postgres staff 234 2007-02-16 10:12
00010003
-rw--- 1 postgres staff 234 2007-02-16 10:12
00010004
-rw--- 1 postgres staff 234 2007-02-16 10:12
00010005.0024FD70.back
Thanks to all who have repplied so far
Ok so I go back and retry the complete procedure to
try to pin point what might be the problem.
1)
POSTGRES NEW INSTALL
2)
CREATE TESTING DATABASE
# createdb Test
3)
INSERT A LOT OF DATA INTO 'Test'
# insert into users values (1 ,'name','800122','2
some
Karthikeyan Sundaram wrote on 18.02.2007 09:15:
Hi,
I am new to postgres. I need some kind of template script or advise
on how to analyse the indexes. In our database, we do delete, insert,
update tons of rows.
http://www.postgresql.org/docs/8.2/interactive/routine-reindex.html
Hi,
I am new to postgres. I need some kind of template script or advise on
how to analyse the indexes. In our database, we do delete, insert, update
tons of rows.
Regards
skarthi
_
Refi Now: Rates near 39yr lows! $430,000
