I have a lock on a table that won't release. I know this seems very unusual
but there appears to be a severe deadlock and pgsql has not release the
lock.
I've tried everything including recreating the db and trying to delete the
old one. psql wouldn't even let me delete the old db. It says that o
Thanks all, it's working great now.
Cheers. :-)
[EMAIL PROTECTED] wrote:
> As per the documentation at:
> http://postgresql.planetmirror.com/users-lounge/docs/7.0/user/c40874113.htm#AEN4207
>
> When using SELECT in a PL/PGSQL function, you must either SELECT .. INTO or
> use the PERFORM query i
On 7 Feb 2001, Gunnar R|nning wrote:
> It is really not based on the FTI code in PostgreSQL, since with we started
> out with a Progress database last year before porting to PostgreSQL. The
> idea is the same though, a separate lookup table containing the words for
> exact matching. Last time I ha
Yes. You need to remove the row on pg_relcheck and then change the
value of relchecks for the row in pg_class for the relation the check
constraint is on.
On Wed, 7 Feb 2001, Tamsin wrote:
> Hello,
>
> Is it possible to drop a check constraint in any way without
> dropping/recreating the tabl
Hi Tom, Jeorg,
Thanks for the help - I thought I might be being a bit vague...
Jeorg's suggestion solved my problem - I need to create an index across
both columns:
'create index foo on bar ( baz, bang )'
Like what Jeorg said I should :-)
Appreciated,
Crispin
Jan Wieck <[EMAIL PROTECTED]> writes:
> Ian Lance Taylor wrote:
> >
> > I have a patch which adds support for cursors in PL/pgSQL. If anybody
> > is interested, I can provide that patch against either 7.0.3 or the
> > current CVS sources. I have sent it to the maintainers, and they will
> > con
"Mark Alliban" <[EMAIL PROTECTED]> writes:
> 530MB of swap. top reports that the backends use around 17-19MB on average.
> Are you saying then, that if I have 500 concurrent queries, I will need 8GB
> of swap space?
Something like that. You weren't expecting to support 500 concurrent
queries on
> "Mark Alliban" <[EMAIL PROTECTED]> writes:
> > I have increased file-max to 16000. However after about 24 hours of
running,
> > pgsql crashed and errors in the log showed that the system had run out
of
> > memory. I do not have the exact error message, as I was in a hurry to
get
> > the system u
From: "Shahab Asgharzadeh" <[EMAIL PROTECTED]>
> Access will write the sql as:
> delete from "tablename" where "col1" = 1234 AND "col2" = 'text' AND "col3"
=
> 100.200
>
> ERROR: Unable to identify an operator '=' for types 'numeric' and
'float8'
> You will have to retype this query usin
"Mark Alliban" <[EMAIL PROTECTED]> writes:
> I have increased file-max to 16000. However after about 24 hours of running,
> pgsql crashed and errors in the log showed that the system had run out of
> memory. I do not have the exact error message, as I was in a hurry to get
> the system up and runn
i've browsed the archive and see that there is a way in using triggers to
achieve automatic modification time stamp. i'm porting a mysql
application, and need that same functiona. pgsql's timestamp is for
date+time[+zone]. however, for mysql it's used to stamp the time when the
record was inserted
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> > I've been using a variant of the FTI system in an application, but this is
> > far from sufficient when it comes to matching. Speed is OK, but the
> quality
> > of the results could have been a lot better.
>
> Really? How are you using it? If it's
At 14:47 07.02.01 +, you wrote:
>Hi,
>I have a table with about 8million tuples in it. I need to do a search
>on two of the table's columns, so I've created a couple of indices, one
>for each column.
>Then I've run VACUUM ANALYZE. The query planner still wants to do a
>sequential scan on the d
Crispin Miller <[EMAIL PROTECTED]> writes:
> Then I've run VACUUM ANALYZE. The query planner still wants to do a
> sequential scan on the database. Any idea where I'm going wrong?
Not providing enough detail to let anyone help you ;-)
Let's see the table schema (pg_dump -s -t table is a useful w
Hi,
I have a table with about 8million tuples in it. I need to do a search
on two of the table's columns, so I've created a couple of indices, one
for each column.
Then I've run VACUUM ANALYZE. The query planner still wants to do a
sequential scan on the database. Any idea where I'm going wrong?
C
Hi all,
Is it possible to set quotas for each user of my DBMS ?
I run a web server and I gave the users the opportunity to have a personal
database for their homepage but I don't want them to put large objects
such as files in the DBMS, so I want to apply quotas.
Thanks in advance for your help
Jamie Bumsted wrote:
>
> Hi All,
> I am new to pgsql, I have inherited a database with no documentation, i.e.
> nobody knows the passwords for any of the database accounts. Anybody have
> any ideas on how to change the passwords without first knowing the
> passwords?
> If this is a stupid questi
FYI: Here are the table definitions:
CREATE TABLE TBLPEMDRUGLINK
(
DRUGID VARCHAR(10) NOT NULL,
MONOGRAPHID VARCHAR(10) NOT NULL,
CONSTRAINT PK_TBLPEMDRUGLINK PRIMARY KEY (DRUGID, MONOGRAPHID)
);
CREATE TABLE TBLFDBMONO
(
VERSIONID
Greetings,
I am a newcomer to postgresql and so far so good. Although some may argue
with
the use of Access in developing front-end clients, I have created one.
Everything
works well except when a table contains numeric datatype, one can not delete
rows
or update them from access.
I am using Pos
DaVinci wrote:
>On Tue, Feb 06, 2001 at 10:26:12AM +, Oliver Elphick wrote:
>> DaVinci wrote:
>> > I have tried to install experimental Debian packages of Postgresql
>> > 7.1beta4, but get a dependency error with libssl09.
>
>> libssl09 is a separate package, from unstable (n
I have a locked table that won't unlock.
I do not appear to be able to select from the table.
I suppose it's a deadlock, but I don't know how to release it.
thanks,
Matt Friedman
I installed (with some minor worries) 7.1beta4 Debian packages (a thousand
thanks, Oliver !). On the whole, it looks *very* good.
I have some problems with the ODBC interface, that seems partially broken (see
the ODBC list).
My present problem is with views : There seems no way to retrieve a vie
> "Mark Alliban" <[EMAIL PROTECTED]> writes:
> > I am having problems with the number of open files on Redhat 6.1. The
value
> > of /proc/sys/fs/file-max is 4096 (the default), but this value is
reached
> > with about 50 ODBC connections. Increasing the file-max value would only
> > temporarily im
On Wed, Feb 07, 2001 at 06:53:13AM -0600, Jamie Bumsted wrote:
> Hi All,
> I am new to pgsql, I have inherited a database with no documentation, i.e.
> nobody knows the passwords for any of the database accounts. Anybody have
> any ideas on how to change the passwords without first knowing the
>
On Wed, 7 Feb 2001, Jamie Bumsted wrote:
> Hi All,
> I am new to pgsql, I have inherited a database with no documentation, i.e.
> nobody knows the passwords for any of the database accounts. Anybody have
> any ideas on how to change the passwords without first knowing the
> passwords?
As syst
Hmm... very suspicious...
However, if you have root on that machine, try this:
su - root
su - postgres
cd /var/lib/pgsql/data
vi pg_hba.conf
add:
local databasename trust
Restart postgres, Switch back to your user, then try:
psql databasename postgres
Bingo, you're in as the DB admin. GRANT
Hi All,
I am new to pgsql, I have inherited a database with no documentation, i.e.
nobody knows the passwords for any of the database accounts. Anybody have
any ideas on how to change the passwords without first knowing the
passwords?
If this is a stupid question I apologize in advance.
Thanks!
Hello,
Is it possible to drop a check constraint in any way without
dropping/recreating the table? I've managed to drop foreign key constraints
by dropping the associated triggers, but check constraints don't seem to
create triggers and there isn't an alter table drop constraint command. Is
the
Greetings, Joseph!
At 07.02.2001, 13:13, you wrote:
JS> I noticed that people are ignoring the time created part of my
JS> proposal. How can a read only field be implemented? A trigger that
JS> causes and error if that field is updated?
Well, why not just do something like
new.time_created_fiel
Greetings, Culley!
At 06.02.2001, 13:11, you wrote:
CH> Any suggestions on how to select a random record from
CH> any given table?
SELECT * FROM any_given_table ORDER BY random() LIMIT 1;
--
Yours, Alexey V. Borzov, Webmaster of RDW
Replying to my own post as I think things through.
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
> Maybe what we need is some sort of module system for these things so you
> could do something like:
>
> USE MODULE auto_timestamp ON foo (last_modified)
>
> which coul
On 6 Feb 2001, at 14:24, Chuck Esterbrook wrote:
> At 01:10 PM 2/6/2001 -0600, John Burski wrote:
> >interactively, via psql, via the Perl Pg module, or via PHP. If you
> >attempt to drop a database that doesn't exist, PostgreSQL will issue an
> >error message. If you're running interactively
Ian Lance Taylor wrote:
> Camm Maguire <[EMAIL PROTECTED]> writes:
>
> > Greetings! Just read that this functionality is planned for the
> > future. Can 7.1 have cursors in pgsql functions, for example?
>
> No, it can't.
>
> I have a patch which adds support for cursors in PL/pgSQL. If anybody
33 matches
Mail list logo