"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 http://www.lfix.co.uk/
"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
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 to
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."
Wha
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
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 Re
> select a,b,c from a where d=2 order by e limit 10;
> select count(*) from a where d=2;
>
> The point is that I want to know the total number
> of matches and I also want to use "limit". And
> I don't want to do two queries.
>
Perhaps GROUP BY will get you where you want to go:
select count(*
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 recre
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: Mond
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 debug
Mark McWilliams <[EMAIL PROTECTED]> writes:
> Can someone tell me how to recover a PostgreSQL online backup?
> There is nothing in the documentation, and this is the only thing
> keeping me from using Oracle over PostgreSQL. Assuming of
> course using WAL (write ahead logging).
You don't have to
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 1&2 and my VB
program. Can someone tell me what i did... Thanks..
PostgreSQL said
"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.
-
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 o
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, unfortunately,
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 VM
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
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
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
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
identif
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
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
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
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 Cli
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: [
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
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) Re
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
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).
Can
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 t
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 logging
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 \
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 broadcast)
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.
"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 f
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 try
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 com
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,
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
misleadin
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 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]
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
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?
http://www.postgre
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 comp
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
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 libpq++
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 approp
> 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
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 PROTECTED
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
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
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 validat
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 's
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 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
---
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
I wonder if anyone can help... (I'm running version 7.1.2)
I am trying to rebuild my database after a database corruption
(apparently from a VACUUM ANALYZE). I moved the old PGDATA directory
aside, but now I can't even run `initdb`. I don't understand how I
wouldn't be able to run initdb.
--
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
>
>
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 broadcast
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 resu
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 lis
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 nam
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
> 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
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?
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'...
>create function numeric_eq(numeric,float8)
>returns bool
>as ''
>language 'internal';
>
>create operator = (
>leftarg=numeric,
>righ
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
67 matches
Mail list logo
