>>> On Tue, Jan 15, 2008 at 3:33 AM, in message <[EMAIL PROTECTED]>,
Thomas Markus <[EMAIL PROTECTED]> wrote:
> update tablename set datecol=null
> ~ 2.3 mio rows
>
> After 6 hours, this was still not finished. selects and inserts are ok.
> System is a dual xeon, 8gb ram, debian 64bit, pg 8.
I'm in an academic environment. One of the problems that I often
have, is that students will put upper case letters in table names.
If this is done, and the student doesn't quote the table or column
name this error is the result. Is this possibly happening?
Carol
On Jan 18, 2008, at 11:4
Hi,
I had installed postgresql-8.1.9, But when I tried to run any sql statement
like the following:
(1)select * from ;
or
(2)select * from public.;
on the query tool to access any table inside the public schema I got the
following error:
ERROR: relation "" does not exist
Kevin Kempter <[EMAIL PROTECTED]> writes:
> Suppose I have a table with say an integer key, a char column and a large
> object column.
> can I simply delete a row from the table (delete from bigtable where...),
> then
> run a vacuum (or vacuum full) ? If so, in this scenario will postgres relea
"Suresh Gupta VG" <[EMAIL PROTECTED]> writes:
> server starting
> bash-2.05$ LOG: could not bind socket for statistics collector: Cannot
> assign requested address
> LOG: trying another address for the statistics collector
> LOG: database system was shut down at 2008-01-18 16:06:04 AST
AFAICT y
Jessica Richard написа:
Thanks!!!
"ALTER USER username SET default_transaction_read_only to true" worked.
One more question:
where do I see the current setting of "default_transacton_read_only (true for
false) for each user on the system? Is there a table that keeps this kind of info
for al
Thanks!!!
"ALTER USER username SET default_transaction_read_only to true" worked.
One more question:
where do I see the current setting of "default_transacton_read_only (true for
false) for each user on the system? Is there a table that keeps this kind of
info for all users?
Thanks again,
Jes
Hi team,
I am using pgsql 8.2.5 on Solaris 9 sparc machine. I had a separate
server which contains my application running. I need to connect the
database from the application server same configuration Solaris 9. I am
trying to add the IP address and net mask number in the "pg_hba.conf" of
postg
