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 column
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,
(SE
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?
http://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)
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 some
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 valu
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 lis
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 direct
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 up
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 Database,
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 i686
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 ha
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:
"%PDF-1.4\015%\342\34
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 a
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 w
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 pos
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
> followin
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 sti
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
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 mu
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 ca
25 matches
Mail list logo
