This is only a soft answer. A real answer would probably involve
mucking with the system tables, so maybe a question about the
application logic can prevent you from resorting to that.
Through what process does a file get orphaned?
Is it possible that you could just cascade deletes on the
Hello,
Just installed pg 8.0.1-r3 and now phppgadmin and pgadmin3 die with a
cryptic error message.
I've traced it to the following query to get information about the
database :
SELECT pdb.datname AS datname, pu.usename AS datowner,
pg_encoding_to_char(encoding) AS datencoding,
Why don't you try PG Lightning Admin and see if you get the same error.
http://www.amsoftwaredesign.com
I have been using it with 8.01 without issues.
T
---(end of broadcast)---
TIP 6: Have you searched our list archives?
PFC [EMAIL PROTECTED] writes:
I've traced it to the following query to get information about the
database :
SELECT pdb.datname AS datname, pu.usename AS datowner,
pg_encoding_to_char(encoding) AS datencoding,
(SELECT description FROM pg_description pd WHERE pdb.oid=pd.objoid) AS
I'm a refugee from MySQL due to license restrictions.
With MySQL, i was used to do GRANT ALL PRIVILEGES ON dbname.* TO
username to allow a certain user to do anything within a given
database. This is useful when using applications that run on a SQL
backend, e.g. a blog or a logging server or
On Sat, Apr 09, 2005 at 03:41:55PM -0700, Benjamin Smith wrote:
Ok, I have a stupid-simple table:
create table files (
id serial unique not null,
mime varchar not null,
name varchar not null
);
BTW, the hip kids use TEXT instead of VARCHAR :)
Idea being that I can save values
On Apr 10, 2005, at 3:10 PM, Florin Andrei wrote:
On PostgreSQL, i lost about half a day trying to figure it out. I'm
posting this message to help others in my situation. I googled for an
answer, but everything that i've found was unhelpful. Hopefully this
mailing list is indexed by Google.
The
On Sunday 10 April 2005 03:39, Andreas Seltenreich wrote:
You can concatenate values using \set. So using
\set importfile :importdir /test.sql
\i :importfile
you won't have to mess with $PWD.
Thanks for the tip, Andreas. But I have about a dozen sql files in the
import directory,
Over the past several weeks, Tom Lane has been working on replacing our
old Cache Management Alorithm (ARC) with a new, patent free one (2Q).
In order to reduce the number of 8.x deployments out there that are using
the old manager, we have just released 8.0.2, and encourage adminstrators
to
Hello *,
I run a Database of curently 120 GByte on a 3Ware S-ATA Raid-5 with
3x 147 GByte. Now it was a little bit bigger (around 190 GByte )
and I have tried to use vacuumdb...
Oops!!! I can not cacuumize my Database...
How many diskspace does vacuumdb need ?
OK, if I pgdumpall my
Hello,
I`m using postgresql 7.2.1. According to the following lines data in
my database gets encoded as unicode. Server and client communication
seems to use unicode as well:
woody=# select version();
version
---
PostgreSQL 7.2.1 on
I have a table with
an btree unique index over 4 varchar keys.
When I insert and if
one or more keys is null, postgres allows duplicate rows to be inserted into the
table.
Are there some
issues if index keys are null.
Thanks
Vinod
Viswanathan
In article [EMAIL PROTECTED],
Adam Siegel [EMAIL PROTECTED] wrote:
[...]
% We perform a vacuum full after each mass delete. This cycle can happen
% many times during over a couple of weeks. We are in a test lab
% environment and are generating a lot of data.
%
% One of the problems we have
I'm trying to download v8.0 for fedora core 3.
But the last page i see is :
Choose a download mirror
Downloading:
/binary/v8.0/linux/rpms/fedora/fedora-core-3/postgresql-server-8.0.0-1PGDG.i686.rpm
None of the mirrors work. The message at the status
bar says Connecting to remote host ... but
How to catch the notifications of PostgreSQL backend with
NpgsqlConnection.Notification event.
Please, example on VB.NET (if possible)
Thanks!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
i have a databse in postgresql 7.4 with some pdf files in a bytea column.
everything works fine but sometimes when i dump and restore i get
psql:../tmp/dump.sql:704022: ERROR: invalid input syntax for type bytea
CONTEXT: COPY dk_dokument, line 127, column dk_content:
Hi all,
I'm trying to use a limit clause with delete, but it doesn't work at the
moment (are there plans to add this - I could try to do up a patch ?).
eg.
delete from table where x='1' limit 1000;
Is there another way to approach this?
I'm trying to delete records through a webapp and if there
MICHAEL;
thanks alot for your help..
i used a trigger to get the job done..thanks again for helping me..
regards
chamil
university of colombo
Sri LankaMichael Fuhr [EMAIL PROTECTED] wrote:
[Reply-To set to pgsql-general]On Fri, Mar 25, 2005 at 11:11:19PM -0800, chamil wijenayake wrote:
Hola, antes que nada saludos
Quisiera que me pudieran resolver una duda, ya que
llevo varias dias sin salir del apuro
Tengo una base de datos sencilla en postgresql, el
php ya esta configurado, y ya corre el apache, estan instalados en una maquina
con Linux mandrake 9.2, ya esta
The command
UPDATE dok SET krdokumnr=NULL WHERE krdokumnr NOT in (select dokumnr from
dok);
runs forever. Postgres.exe process takes 90% of CPU time, disk LED is
flashing.
Platform: Win XP Prof SP2, Postgres 8
dok table has only 7651 rows
Killing client application does not help. Only killing
Florin Andrei wrote:
On MySQL, it's enough to do this:
GRANT ALL PRIVILEGES ON dbname.* TO username [IDENTIFIED BY 'password'];
On PostgreSQL, you have to give it privileges not only to the database,
but to all components within (tables, sequences and whatnot). The
following
Hi,
I hould like to know how cant I disable autocommit
using the windows version. I've tried set autocommit
to off in SQL but the message was : ERROR: SET
AUTOCOMMIT TO OFF is no longer supported. I've tried
\set autocommit off in the command-line, I have no
error but the autocommit its still
Fritz Bayer wrote:
I have a java program, which writes words containing german umlauts
like äöü into the database. As you probably know, those characters
belong to the ISO-8859-1 character encoding set.
In my java webapplication those umlauts (äöü) get displayed correctly.
So they
Vinod Viswanathan wrote:
I have a table with an btree unique index over 4 varchar keys.
When I insert and if one or more keys is null, postgres allows
duplicate rows to be inserted into the table.
Are there some issues if index keys are null.
NULLs don't count against UNIQUE constraints, even if
Tom Lane wrote:
David Parker [EMAIL PROTECTED] writes:
The best bet is to make sure that your postmaster start script
invokes the postmaster as
postmaster
no more. No path (set PATH beforehand instead). No
command-line switches (whatever you might want there can be
put into
25 matches
Mail list logo