Thanks Neil,
I will just have to hassle EMS to upgrade :)
Cheers
Johan Wehtje
Neil Conway wrote:
On Tue, 2004-11-30 at 17:54 +1100, Johan Wehtje wrote:
I am getting the error "Column n.nsptablespace does not exist" in my
application when I connect using my Administrative tool. This only
happen
On Tue, 2004-11-30 at 17:54 +1100, Johan Wehtje wrote:
> I am getting the error "Column n.nsptablespace does not exist" in my
> application when I connect using my Administrative tool. This only
> happens with Version 8, but it does crash my application, does anyone
> have any ideas ?
You need
I am getting the error "Column n.nsptablespace does not exist" in my
application when I connect using my Administrative tool. This only
happens with Version 8, but it does crash my application, does anyone
have any ideas ?
Cheers
Johan Wehtje
---(end of broadcast)---
I got this going with a dump/reload.
Beware however, 8.0b5 and the JDBC driver don't seem to work with UNICODE
encoding for the database. You have to use b4 or HEAD.
Hunter
> From: Kris Jurka <[EMAIL PROTECTED]>
> Date: Tue, 30 Nov 2004 01:34:46 -0500 (EST)
> To: Hunter Hillegas <[EMAIL PROTECTE
On Fri, 26 Nov 2004, Hunter Hillegas wrote:
> When I SELECT from a certain table, I see this JDBC exception:
>
> "Invalid character data was found. This is most likely caused by stored
> data containing characters that are invalid for the character set the
> database was created in. The most
On Tue, Nov 30, 2004 at 11:16:39AM +0530, Nageshwar Rao wrote:
> I would like to change the column length from varchar(10) to varchar(30).How
> this can be done.
Changing a column's type is discussed in the FAQ:
http://www.postgresql.org/docs/faqs/FAQ.html#4.4
In PostgreSQL 8.0 you'll be able t
On Thursday 25 November 2004 19:00, Gaetano Mendola wrote:
> Hi all,
> how I already wrote, the RSS feed report as date:
> 1 jan 1970 for all entries.
>
We just made some changes to some of the feeds. If you're still having
trouble, can you send an email with specific urls of the feeds with the
I would like to change the column
length from varchar(10) to varchar(30).How this can be
done.
Thx for help
In preparation for the upcoming 8.0 release, and beyond ... especially
with the upcoming Native Windows support, this FAQ is meant to let new
users know of venues for community support available to them ...
Mailing Lists & Usenet
==
There are currently 29 active mailing lists
Hi all,
Hope someone might know the answer.
Trying to install 7.4.5 ('cause its what I have) from source on SCO OpenServer
5.0.7
The compile succeeds, all be it with warnings...
gmake install -- OK
create the data directories -- OK
/usr/local/pgsql/bin/initdb - D /usr/local/pgsql/data -- OK
/
On Mon, Nov 29, 2004 at 07:35:57PM -0600, Todd P Marek wrote:
> I am curious if there is a way to select and return multiple columns
> from multiple tables without having to first create a view.
You could use CREATE TYPE to create a composite type with the desired
fields and return SETOF that t
>>> Every 5th page of the manual says that I should use vacuum analyze
>>> frequently. There are two command line tools for this and another one in
>>> the contrib. I think none of them cares of empty tables.
>>
>> This issue need to be fixed.
> What issue? I don't see an issue in the least.
H
金更达 wrote:
>hi,pgsql-genera
>
>I am chinese user, I have installed thd PostGreSQL 8.0 for win in my
> computer, it's very good.
>but I find a problem, when I use "select * from dcvalue where
>text_value='中文'" to search record,
>the system return "no results",
>
seems like your locale setti
i was wondering, how to create dynamic table like
temporary table but create from function and the result from function toocos
i want count same calculation from other table migh be a multiple table so i
need looping and join table...
thnax
nurdin
Andrew - Supernews <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> On 2004-11-29, Russ Allbery <[EMAIL PROTECTED]> wrote:
>> Marc G Fournier From: <[EMAIL PROTECTED]> writes:
>>> Stanford is now carrying the groups ... Russ got me to fix a problem
>>> with my checkgroups message to deal wi
On 11/23/2004 4:37 PM, Woodchuck Bill wrote:
[EMAIL PROTECTED] (Patrick B Kelly) wrote in news:E55E257B-3D95-11D9-
[EMAIL PROTECTED]:
The list has been deluged with
countless angry process oriented messages filled with vitriol and
devoid of any content regarding the purpose of this forum, we ha
On 11/23/2004 4:46 PM, Gary L. Burnore wrote:
It's ok. Mysql's better anyway.
This is the attitude I've seen from many of the pro-usenet people. If I
don't get it my way I will bash your project and try to do harm.
I am too one of those who have left usenet many years ago. Partly
because of people
Hello-
I have been trying for a while to write a function that would return multiple rows and columns in a similar fashion as SQL server stored procedures.
I can get my functions to return multiple rows and columns but only from a single table. I worked around this by creating a view that ties
Uhmmm... analyze or vacuum on an empty table is fairly pointless.
Those utilities are supposed to be used on tables that have data.
So the answer is, use them on tables that have data.
Every 5th page of the manual says that I should use vacuum analyze
frequently. There are two command line tool
4. Isn't ANALYZE on a totally empty table really a special case? The
presumption should be that the table will not remain empty. To optimize
the performance assuming that there will be zero (or close to zero) rows
seems somewhat pointless. However, there are valid reasons why a table
might be e
Joshua D. Drake wrote:
In any case, it is hard to see how the present behaviour can be seen as
desirable. It obviously causes problems at least for new Postgres
users, and we
all hope there will be many more of these folks in the future. Thanks
for considering this. Mark
Uhmmm... analyze or vac
On Mon, Nov 29, 2004 at 02:57:28PM -0800, Mark Dexter wrote:
> 1. Why run VACUUM on an empty table?
Another approach: you run VACUUM on an empty table to empty it. If you
had a table with a lot of tuples, and ran DELETE on it, it will empty
after that, but it will be full of dead tuples. So y
Hmm... it seems that we're maybe not understanding one another here.
I'm going to try to be more clear. Below are the questions that were
raised and my attemp to answer them clearly.
1. Why run VACUUM on an empty table?
This is a good question, but perhaps there is a valid answer. Our
product
> >In any case, it is hard to see how the present behaviour can be seen as
> >desirable. It obviously causes problems at least for new Postgres
> >users, and we
> >all hope there will be many more of these folks in the future. Thanks
> >for considering this. Mark
>
> Uhmmm... analyze or vacuum
Marc G. Fournier wrote:
>
> The WWW folks just put up a survey asking:
>
> "If there was an official newsgroup for postgresql, would you switch to
> using Usenet from using the mailing lists?"
Switch no, use in addition yes.
I subscribe to several of the mailing lists that I find most
interesting,
On Mon, 29 Nov 2004, Chris Green wrote:
On Mon, Nov 29, 2004 at 05:00:19PM -0400, Marc G. Fournier wrote:
As a side note, for those that do vote 'yes', please note that there is an
official pgsql.* hierarchy gated from the mailing lists, that is available
at news.postgresql.org, if you do wish to u
On Mon, Nov 29, 2004 at 05:00:19PM -0400, Marc G. Fournier wrote:
>
> As a side note, for those that do vote 'yes', please note that there is an
> official pgsql.* hierarchy gated from the mailing lists, that is available
> at news.postgresql.org, if you do wish to use a news reader vs a mail
>
The WWW folks just put up a survey asking:
"If there was an official newsgroup for postgresql, would you switch to
using Usenet from using the mailing lists?"
The Poll can be found at http://www.postgresql.org ... we're curious as to
what sort of interest there is by the 'General Users' ...
As
On Mon, Nov 29, 2004 at 11:48:37AM -0800, Mark Dexter wrote:
> 1. Provide an option with ANALYZE to force it to work as if a table had
> a minimum number of rows (e.g., ANALYZE MINIMUM 1000 would analyze
> tables as if they all had at least 1000 rows).
> 2. Provide an option during table creation
"Mark Dexter" <[EMAIL PROTECTED]> writes:
> Several recent postings appear to confirm that there is an issue with
> the use of VACUUM or ANALYZE on empty tables. Specifically, if you
> VACUUM or ANALYZE a table that is empty and then insert a large number
> of rows into this table, you will experi
In any case, it is hard to see how the present behaviour can be seen as
desirable. It obviously causes problems at least for new Postgres
users, and we
all hope there will be many more of these folks in the future. Thanks
for considering this. Mark
Uhmmm... analyze or vacuum on an empty table is
Title: VACUUM and ANALYZE Follow-Up
Several recent postings appear to confirm that there is an issue with the use of VACUUM or ANALYZE on empty tables. Specifically, if you
VACUUM or ANALYZE a table that is empty and then insert a large number of rows into this table, you will experience ve
Hi,
Is there going to be full support for inheritance (tables)
in future ?
Are there going to be any improvements about inheritance ?
Regards,
Tatu Salminen
Software Developer
hi,pgsql-genera
I am chinese user, I have installed thd PostGreSQL 8.0 for win in my
computer, it's very good.
but I find a problem, when I use "select * from dcvalue where
text_value='中文'" to search record,
the system return "no results", moreover when I use "select * from dcvalue
where t
Hi.
I want to use a table
CREATE TABLE stats (
upd TIMESTAMP,
crt TIMESTAMP DEFAULT NOW()
);
with inheritance
CREATE sometable (
)
INHERITS stats
to automatically maintain update dates. However the obviuos trigger
CREATE OR REPLACE
FUNCTION stat_upd()
RETURNS TRIGGER
AS '
BEGIN
On Mon, 2004-11-29 at 12:57 -0500, Tom Lane wrote:
> Scott Cain <[EMAIL PROTECTED]> writes:
> > After dropping a database, recreating it and trying to add a table to
> > it, I am getting this message:
>
> > ERROR: could not access status of transaction 210
> > DETAIL: could not open file "/opt/p
Scott Cain <[EMAIL PROTECTED]> writes:
> After dropping a database, recreating it and trying to add a table to
> it, I am getting this message:
> ERROR: could not access status of transaction 210
> DETAIL: could not open file "/opt/postgres/data/pg_clog/": No such file
> or directory
> The
Hello,
After dropping a database, recreating it and trying to add a table to
it, I am getting this message:
NOTICE: CREATE TABLE will create implicit sequence
"tableinfo_tableinfo_id_seq" for "serial" column "tableinfo.tableinfo_id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
Tom Lane <[EMAIL PROTECTED]> writes:
> The basic issue is that the current setup encourages
> reply-to-author-and-list, while adding Reply-To encourages
> reply-to-list-only
It also makes it impossible to reply to the author personally. Normally there
are two actions possible on a message, "foll
unsubscribe pgsql-hackers
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Mon, 29 Nov 2004 02:36:10 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> The basic issue is that the current setup encourages
> reply-to-author-and-list, while adding Reply-To encourages
> reply-to-list-only (at least when the replier is using one of the mail
> clients I'm used to).
[narrowed to p
On Mon, Nov 29, 2004 at 07:35:41AM -0500, Jim Seymour wrote:
>
> Chris Green <[EMAIL PROTECTED]> wrote:
> >
> > On Sun, Nov 28, 2004 at 07:34:28PM -0400, Marc G. Fournier wrote:
> > >
> > > What is the general opinion of this? I'd like to implement it, but not
> > > so
> > > much so that I'm
Chris Green <[EMAIL PROTECTED]> wrote:
>
> On Sun, Nov 28, 2004 at 07:34:28PM -0400, Marc G. Fournier wrote:
> >
> > What is the general opinion of this? I'd like to implement it, but not so
> > much so that I'm going to beat my head against a brick wall on it ...
> >
> Personally I'm against
:)
Dangerous Attachment has been Removed. The file "Joke.scr" has been removed
because of a virus. It was infected with the "W32/Bagle.BC-mm" virus. File
quarantined as: "".
http://www.fortinet.com/VirusEncyclopedia/search/encyclopediaSearch.do?method=quickSearchDirectly&virusName=W32%2FB
Pgadmin is very good, PhpPgAdmin (phppgadmin.sourceforge.net) is a very
capable Webbased tool if you have PHP +Apache. Both tools are OS. Both
allow Table/Database/View creation, Drop, browse, alter and arbitary
query creation.
I use both as well as EMS-Hitech's PgManager and PgUtils
(ems-hite
Checkout http://www.pgadmin.org
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Nageshwar Rao
Sent: Monday, November 29, 2004
10:20 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] tool for
postgresql
Hi,
Any tool available for Postgresql for admin activities li
Jamie Deppeler wrote:
Hi,
Just doing some testing at the moment and trying to make a trigger that
consists of a insert statement which as a result of an sql querty!
Look into using EXECUTE - it accepts a string expression and executes
it. Don't forget to use the quote_xxx() functions to quote ide
Adam Ernst wrote:
How can I get the table schema for a database or the field schema for a
table? I'm connected remotely via a socket, so I can't just dump it an
inspect the result.
Even if I could just verify the existence of a table/field, that would
work.
If you start psql with the -E flag th
Hi,
Any tool available for Postgresql
for admin activities like TOAD ( which is used for
oracle database).Appreciate if somebody let me know.
Thanks in advance.
On Sun, Nov 28, 2004 at 11:06:38PM -0800, Uwe C. Schroeder wrote:
> The "unhandy" part is maybe a personal perception. I like stored procs, but
> in
> this case the calculation is repeated over and over again (ok, it would be
> the same with views). Basically the part I don't like is that the
On Sun, Nov 28, 2004 at 07:34:28PM -0400, Marc G. Fournier wrote:
>
> What is the general opinion of this? I'd like to implement it, but not so
> much so that I'm going to beat my head against a brick wall on it ...
>
Personally I'm against it because it means that I'll often get two
replies wh
Am Sonntag, den 28.11.2004, 23:06 -0800 schrieb Uwe C. Schroeder:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Sunday 28 November 2004 10:43 pm, Michael Fuhr wrote:
> > On Sun, Nov 28, 2004 at 06:41:50PM -0800, Uwe C. Schroeder wrote:
> > > I need to search a lot of locations based on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
> where sqrt(pow((lat1 - lat2),2) + pow((long1 - long2),2)) >= 50
I assume that you dont want to deal with distances > 1000km?!
> of the records that aren't in question anyways. How do you come to the
> lat/long values for the max differenc
53 matches
Mail list logo
