I need to figure out a way to allow users to only be able to update a
certain column in a table. Does anyone have any ideas to start with?
David
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Sun, Aug 19, 2001 at 08:46:55PM +, omid omoomi wrote:
hi all,
I have pg 7.0.3 installed. I can use ascii() to get the ascii code of a
character but I can not use chr() to reverse the function... is it a matter
of the pg version I have? If so, is there any other way to get the text
On Sun, 19 Aug 2001 10:23:39 +0200, Johann Zuschlag wrote:
I get the following error: Unable to identify an operator '=' for types 'numeric' and
'float8'...
snip
create function numeric_eq(numeric,float8)
returns bool
as ''
language 'internal';
create operator = (
leftarg=numeric,
G'day all.
I have a cron job which vacuums etc all of my databases but it does not
work with 7.1.2 because of the change in structure of .../data/base.
It currently says:
for q in /usr/local/pgsql/data/base/*; do
blaa
blaa
done
How does one get an equivalent list of all databases from 7.1.2?
I have a cron job which vacuums etc all of my databases but it does not
work with 7.1.2 because of the change in structure of .../data/base.
It currently says:
for q in /usr/local/pgsql/data/base/*; do
blaa
blaa
done
How does one get an equivalent list of all databases from 7.1.2?
Stephen Davies wrote:
G'day all.
I have a cron job which vacuums etc all of my databases but it does not
work with 7.1.2 because of the change in structure of .../data/base.
It currently says:
for q in /usr/local/pgsql/data/base/*; do
blaa
blaa
done
How does one get
Out of curiosity, whats wrong with vacuumdb -a? (Vacuum all
databases.)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of
Stephen Davies
Sent: Monday, 20 August 2001 7:33 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Finding database names for
Quoting Stephen Davies:
I have a cron job which vacuums etc all of my databases but it does not
work with 7.1.2 because of the change in structure of .../data/base.
It currently says:
for q in /usr/local/pgsql/data/base/*; do
blaa
blaa
done
How does one get an equivalent list of all
On Sun, Aug 19, 2001 at 01:49:00PM -0400,
[EMAIL PROTECTED] wrote:
Hello
I have statements (highly simplified just to get
the point across) like
select a,b,c from a where d=2 order by e limit 10;
Now I think that because of order by the above query
already knows the result of the
On Mon, Aug 20, 2001 at 07:44:56AM -0500,
Bruno Wolff III [EMAIL PROTECTED] wrote:
Shouldn't:
select a,b,c, count(*) from a where d=2 order by e limit 10;
do what you want?
Upon further review, I see that this construct isn't valid.
---(end of
I have one word for you, alavoor, aka Al Dev.
I can't say more or I would have to kill you. :-)
I'm sorry Christ tjis appears to be a careful, appropriately worded and
reasoned post. What on earth were you thinking off we want ill-informed
unsubstantiated claims or we want nothing
--
Corey Minter [EMAIL PROTECTED] writes:
I don't understand how I
wouldn't be able to run initdb.
How much free disk space have you got?
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Can anyone please help (before I go insane).
In learning C++, QT and PostgreSQL I have created a very simple
program to connect to my database but I cannot compile it. I really
cannot see what I am doing wrong.
Postgress is running and was fully installed when I installed Redhat
7.1. The
Can a user who does not own a table be set up to run COMMENT commands
for a table?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
Is there an equivalent to '\i' that will load up the query buffer but not
run the query?
(I have a query stored in a file that I want to modify on the fly, but
not overwrite the query file.)
--
Jeff Boes vox 616.226.9550
Database Engineer
given a timestamp data, e.g. 2001-08-18 06:01:23+08
How can I check that is it lie between 00:00:00 and 08:00:00 and ignore the
date?
--
content-type:kiss/hug
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Hi, I'm working with 7.0.2, so this might be an old bug. I saw some
other bugs mentioned in this newsgroup involving to_char were said to
be resolved for 7.1.0, but I just thought I'd volunteer it anyway...
db1=# select flastpostdate, to_char(flastpostdate, 'hh:mi:ss mon-dd-yy
am') from tThreads
Hi all,
My question is:
Is this library thread safe???
Has anybody ever tried to use objects from this lib in multiple threads???
Regards
Hicnar
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
how do spool my results to a file.
I know there is a command spool on and off. How do I use it?
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hi,
when we try insert into a table, the inset is failing with cach look
up failure error.
Below is the complete statement and error generated.
DEPG= insert into EXTRANET_SECTION (ID, section_name,
parent,extranetname) values (255,' Main',0, 'test');
ERROR: fmgr_info: function 19464: cache
You need to declare the variable ret, i.e. add a line before BEGIN like:
DECLARE ret integer;
Your function will not work without that.
You may still get an error for some other unknown reason, or you may not.
I have found that plpgsql errors can be highly uninformative, or downright
misleading.
On Fri, Aug 17, 2001 at 02:09:33PM +0600, Ivan Babikov wrote:
In this case, however, I think he may be understating too much. I read
the original question as PostgreSQL is not useful for production systems.
Call me melodramatic if you like: you are probably right.
The point, I guess,
Does Postgres support multiple table indexes? I want to update one table
with data from another, but it's very slow because I have a rather bulky
WHERE clause. I was wondering if I could index the two tables together to
make execution faster.
---(end of
Hi Bill,
Have you solved this yet?
When the psql prompt becomes a ' it means you've started a text string
and not ended it. i.e. :
psql# INSERT INTO foo (stringfield) VALUES ('blah blah blah);
psql'#
You need to type another ' then press enter to finish the string. Once
on a new line, type
Hi, this is my first message to the list.
I've been looking for some documentation regarding WAL
configuration. Particulary, i want to know if there's
a way to inhibit WAL for a certain table or for
certain periods of time (i.e., during batch loads,
when i don't really care for transaction
On Friday 17 August 2001 15:09, Ivan Babikov wrote:
In this case, however, I think he may be understating too much. I read
the original question as PostgreSQL is not useful for production systems.
Call me melodramatic if you like: you are probably right.
The point, I guess, is this: it
If orf is not associated with a primary key or unique
index, the possible combinations might well exceed
14,000. For example, if 3 records in yeast1 and 4
records in temp share the same orf value, the query
will update yeast1 12 times (i.e. the 3 yeast1 records
will be updated 4 times each).
On Mon, Aug 20, 2001 at 02:41:05PM -0400, [EMAIL PROTECTED] wrote:
Does it help if you drop and recreate the indexes, in addition to the vacuuming
you're doing now? I think this was suggested not long ago on this list.
I reduced the number of times vacuum was run with analyze, and run a
I think someone pointed out not long ago that that naming convention isn't
always 100% reliable. How about creating the sequence dynamically (using that
naming convention even), then create the table dynamically and have it
explicitly use the sequence you just created. That way you *know* the
Hi,
Thanks to everyone who answered my questions.. I got the problem solved.
Thanks
Ryan
-Original Message-
From: Fernando Schapachnik [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 12:28 PM
To: Ryan C. Bonham
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [ODBC]
Hi Ivan,
I was running a database with ~27GB of info (admittedly in large, very
simple tables) on PostgreSQL 7.0.3 a while ago for a few months.
Didn't have any real problems with it, apart from having to accept that
a lot of data takes time to process. :-/
Regards and best wishes,
Justin
Michelle Murrain wrote:
I'm trying to isolate a problem - using Cold Fusion, and sending to pg
a large text block, I'm getting an error:
ODBC Error Code = 08S01 (Communication link failure)
Error while executing the query; Query string is too long
Is this a Cold Fusion problem, or a
Hi Ivan!
Well, I don't have a 10 Gb database _yet_; but my
server manages 3 databases that currently total over
17 Gb without a problem. (Also, linking tables from
different databases by querying via ODBC and MS Access
works like a charm!)
I used MySQL for a while; and considered Interbase. I
On Tue, 14 Aug 2001, Sheldon Hearn wrote:
I've been having trouble with a slow query on a table that has a primary
key (which I understand is supported in PostgreSQL by a UNIQUE non-NULL
index). It's a SELECT COUNT(*) without a WHERE clause; really simple
stuff.
I would have thought the
Does it help if you drop and recreate the indexes, in addition to the vacuuming
you're doing now? I think this was suggested not long ago on this list.
Erwin Lansing [EMAIL PROTECTED] on 08/14/2001 04:38:59 AM
To: [EMAIL PROTECTED]
cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: Re:
Hi,
You could do something along the lines of :
SELECT foo, bar FROM baz WHERE date_part('hour', foo) 0 AND
date_part('hour', foo) 8;
Simple, but effective. Only works for whole hours like in your example
though.
:-)
Regards and best wishes,
Justin Clift
Cefull Lo wrote:
given a
orf is a primary key. It is a unique string that links the tables.
Essentially, the setup is this: I am presented with data called
transcription profiles. These contain two columns: orf, which is a unique
representation of a biological gene, and induction, which is a number.
Now,
Hicnar [EMAIL PROTECTED] writes:
Hello,
I was trying to install PostgreSQL ver 7.1.2, for RH 6.2, but some packages
depend on ssl.so.0 and crypto.so.0 libraries.
The question is: what packages contain those libs???
openssl.
--
Trond Eivind Glomsrød
Red Hat, Inc.
Hi,
Ok i am lost.. I added a filed to a table, now when i try to do a select on
that table, or open a view based on that table i get teh following message.
I get the following message in both phpPGAdmin and PGAdmin 12 and my VB
program. Can someone tell me what i did... Thanks..
PostgreSQL
Adam Kornick [EMAIL PROTECTED] writes:
I have a moderately complex query running on small views (10-30
records) which used to work, but is now dying unexptecedly.
Sounds like a backend core dump. Please look for the core file
(should be under $PGDATA/base/yourdbnumber/) and send us a debugger
I believe if you throw decent hardware at it (the sort of hardware you
need to throw at 10GB database to make it perform well) then it is
definitely worth giving it a go.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Ivan Babikov
Sent: Monday,
Hi,
Hello, I'm new in using postgreSQL, I'm now tring to use RedHat 7.1 ,
Jserv with postgresql, but there've got an error:
An error occured while getting the authentication request
as I've try to createuser 'simon' with password, create user db as
'simon' .
the above error is using
I got this cd from GreatBridge that has 7.0.3 on it, so I tried to do a
configure on my AIX 4.2.1.0.06 machine. I have egcs and gnu make installed
from the bull archives.
configure says that xlc is not installed, and gcc(egcs) cant create
executables.
I wrote a simple hello program and it
On Mon, 20 Aug 2001 18:19:49 + (UTC), Killian May [EMAIL PROTECTED]:
Hi,
I'm a little new to postgres, and I'm having trouble droping a sequence.
I get the following error:
ERROR: mdopen: couldn't open scotty_scottyid_seq: No such file or
directory
when I try to recreate the
Hi. I've created some stored procedures. For example:
create function validate_user(varchar, varchar)
RETURNS integer AS '
BEGIN
SELECT count(*) INTO ret
FROM users
WHERE userid = $1 and passwd = $2;
RETURN ret;
END;
'
LANGUAGE 'plpgsql';
When I try to call it with the command, select
Hi,
Been trying to download the latest ODBC driver for two days now but keep
getting max connection rejects.
Alternatives?
Thanks, -km
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Thanks for the suggestion. I may wait a few weeks until I can selectively
search one set of documentation at a time, instead of all the indexed
documents. That's why I've only indexed PSQL docs for now.
Matt
Colin 't Hart [EMAIL PROTECTED] wrote in message
news:9l0qin$1phr$[EMAIL
William D. Tallman [EMAIL PROTECTED] writes:
When I am entering values into a table, and make a mistake, sometimes
there is an error message, and sometimes the equal sign in the prompt
becomes a single quote. Error messages I can puzzle out, but I have not
discovered how to recover from the
On Monday 20 August 2001 18:09, Trond Eivind Glomsrød wrote:
I am not talking just about PostgreSQL now. It is not nice to provide
support for a number of customers without Unix and Linux culture and
having to recompile everything from sources. :-(
If you want newer packages, get Red Hat
On Mon, 20 Aug 2001 22:08:22 + (UTC), [EMAIL PROTECTED]:
orf is a primary key. It is a unique string that links the tables.
Essentially, the setup is this: I am presented with data called
transcription profiles. These contain two columns: orf, which is a unique
representation of a
On Mon, Aug 20, 2001 at 04:56:29PM -0700, Tony Reina wrote:
Perhaps GROUP BY will get you where you want to go:
select count(*), a, b, c from a where d=2 group by a, b, c order by e limit 10;
Here count(*) doesn't give total count i.e. grand total
count if there is no limit.
What
Folks,
I have a moderately complex query running on small views (10-30
records) which used to work, but is now dying unexptecedly. The query
is via aolserver, but also creates the same response when using pgsql.
Within pgsql, I get:
pqReadData() -- backend closed the channel unexpectedly.
how can i use unix timestamp as a data type?
the datetime data type should work. you can find info about it at
http://www.postgresql.org/idocs/index.php?functions-datetime.html
http://www.postgresql.org/idocs/index.php?datatype-datetime.html
here is some example code
CREATE TABLE test
The documentation is non-existent. Can someone tell me or point me to
how to do a recovery? This is the only thing keeping me from using
PostgreSQL over Oracle.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
Is there a way to access the execution plan of a query using the DBI
interface?
Since EXPLAIN seems to write to STDERR, there is no way to use
prepare-execute-fetch ...
Does anybody know, what to do best - I don't want to use a system call
from inside Perl.
Hans
Mark McWilliams [EMAIL PROTECTED] writes:
The documentation is non-existent. Can someone tell me or point me to
how to do a recovery? This is the only thing keeping me from using
PostgreSQL over Oracle.
What do you mean by recovery? I can think of at least three
possibilities:
(1) Restore
On Mon, 20 Aug 2001 [EMAIL PROTECTED] wrote:
On Mon, Aug 20, 2001 at 04:56:29PM -0700, Tony Reina wrote:
Perhaps GROUP BY will get you where you want to go:
select count(*), a, b, c from a where d=2 group by a, b, c order by e limit 10;
Here count(*) doesn't give total count
Jova wrote:
how do spool my results to a file.
I know there is a command spool on and off. How do I use it?
In psql, use \o. There is also the command-line option -o.
Check the manpage for psql for full details.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of
mike wrote:
Is there any GUI application mode for Unix that can run PostgreSQL?
Thank you in advance.
pgaccess (which is included with PostgreSQL source).
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
Hi Folks,
Is there any GUI application mode for Unix that can run PostgreSQL?
Thank you in advance.
--
Best Regards,
Mike
Web Programmer
TKO Systems, Ltd.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
Look at the startup script you used.
Sodom wrote:
Hi,
Hello, I'm new in using postgreSQL, I'm now tring to use RedHat 7.1 ,
Jserv with postgresql, but there've got an error:
An error occured while getting the authentication request
as I've try to createuser 'simon' with password, create
I have many DBI-based query sequences that look like this:
*** begin transaction ***
query #1: select ...
query #2: update ...
query #3: select ...
*** end transaction ***
If query #2 fails due to an exception (say, a duplicate key error), I can
On Sunday 19 August 2001 22:10, Fernando Lozano wrote:
Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using
the older glibc and rpm format?
Yes, once I have enough hard drives to have another system image installed.
Due to several other issues, I won't be using either a
The field is, indeed, a char(17) field. This particular database is actually
a copy of the same schema we use in our Informix applications. The
definitions for that system were almost completely correct for creating the
PostgreSQL version, thus many fields are defined as char(x). I shall
Stephen Davies writes:
I have a cron job which vacuums etc all of my databases but it does not
work with 7.1.2 because of the change in structure of .../data/base.
vacuumdb --all
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of
65 matches
Mail list logo