Craig Ringer writes:
> sam rab wrote:
>> I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
>> [and got]
>> /usr/bin/ld:exports.list:1: parse error in VERSION script
> Your toolchain is just TOO OLD.
Yes. You could probably work around this particular issue by removing
the lin
sam rab wrote:
> Great day to you!
> I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
Maybe this is a stupid question, but ... why?
Red Hat 7.2 is *ANCIENT*. There haven't been security updates since
nigh-unto-forever. It's using C libraries with a completely different
threa
Great day to you!
I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
Process of "configure" ends normally,
process of "gmake" ends with this output of errors:
{
gmake[3]: Entering directory
`/usr/home/install/postgresql-8.3.7/src/interfaces/
libpq'
gcc -O2 -Wall -Wmis
Hello, help me please,
I don't know how, but i got 2 postgres users.
How can I delete the first one
thx alot for your answers.
///
select passwd,ctid,xmi
[EMAIL PROTECTED] wrote:
Hello?
help me plz? i don't khow what to do...
How can I delete first postgres user.
template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax
from pg_shadow where usesysid=1;
usename | passwd| valuntil | ctid |
xmin | xmax
[EMAIL PROTECTED] wrote:
How can I delete first postgres user.
Ugh. How did you duplicate if there is an unique index in rolname ?
pg_shadow is a view; you want to take a look at the real relation
pg_authid.
delete from pg_authid where ctid = '(0,1)'
--
Euler Taveira de Oliveira
http
Hello?
help me plz? i don't khow what to do...
How can I delete first postgres user.
template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax from
pg_shadow where usesysid=1;
usename | passwd| valuntil | ctid | xmin
| xmax | cmin | cmax
--
"Josh Tolley" <[EMAIL PROTECTED]> writes:
> pg_shadow is a view based on pg_authid.
Not in 7.4 it wasn't ...
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> I have two "postgres" user. How to delete the first one ???
Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
two rows?
regards, tom lane
---(end of broadcast)---
On Dec 28, 2007 7:01 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> hello
>
> Help me please...
> I have two "postgres" user. How to delete the first one ???
>
> ***
> # select * from pg_shadow where usesysid=1;
> usename | usesysid | usecreatedb | usesuper | usecatupd
> |
hello
Help me please...
I have two "postgres" user. How to delete the first one ???
***
# select * from pg_shadow where usesysid=1;
usename | usesysid | usecreatedb | usesuper | usecatupd
| passwd| valuntil | useconfig
--+--+--
On 26 Sep 2006 07:21:53 -0700, Mussum <[EMAIL PROTECTED]> wrote:
I am developing an application and I am not obtaining to leave this
error:
org.postgresql.util.PSQLException: Não está inserindo um registro.
org.postgresql.jdbc2.AbstractJdbc2ResultSet.insertRow(AbstractJdbc2ResultSet.java
I am developing an application and I am not obtaining to leave this
error:
org.postgresql.util.PSQLException: Não está inserindo um registro.
org.postgresql.jdbc2.AbstractJdbc2ResultSet.insertRow(AbstractJdbc2ResultSet.java:618)
com.sun.rowset.JdbcRowSetImpl.insertRow(JdbcRowSetImp
bash$ /usr/local/pgsql/bin/pg_dumpall > db.out
ERROR: MemoryContextAlloc:
invalid request size 4294967293
PQendcopy: resetting connection
SQL query to dump the contents of Table 't_oommain' did not execute
correctly. After we read all the
table contents from the backend, PQendcopy() failed
Vinicio Llumiquinga <[EMAIL PROTECTED]> writes:
> fmgr_info: function 18816: cache lookup failed
> This happend when I write any function.
I suspect you dropped the plpgsql call handler function.
If so, the only convenient recovery method AFAIK is to drop the
plpgsql language entry and all your
I have a problem
I have a function in plpgsql:
create function add_one (integer) returns integer as '
begin
return $1+1;
end;
' language 'plpgsql';
When I create in psql monitor this function the message is CREATED
Then I write:
select add_one(1);
and always say:
fmgr_info: function 18816:
i have a problems for deploying database POSTGRESQL ON MY OS linux
first point is :
i want to put the data of database in another location, what can i do at
installation and after installation
second point is:
when the location is full what can i do for extend the database in the nex
location
17 matches
Mail list logo
