I have added /usr/sbin to my path (bash) and /usr/sbin/useradd does exist
(and the command works when I type the command from any directory).
However I still get the same error when running rpm -i ..etc.
I don't remember having issues like this with the PostgreSQL 7.x rpm's..
Maybe because I use
Thanks very much for the information. I had very similar results on my
machine. I will take your advice and use the double-precision values,
since it doesn't affect the probability significantly anyway. As far as
the constraint trigger, I will see if it becomes a problem before I
worry about its pe
"Andrew Hall" <[EMAIL PROTECTED]> writes:
> We haven't been able to isolate what causes it but it's unlikely to be
> hardware as it happens on quite a few of our customer's boxes.
Okay, then not hardware; but it seems like you ought to be in a position
to create a test case for other people to p
It sounds like a mess, all right. Do you have a procedure to follow to
replicate this havoc? Are you sure there's not a hardware problem
underlying it all?
regards, tom lane
We haven't been able to isolate what causes it but it's unlikely to be
hardware as it happens on quite a few of our custom
On Mon, Feb 14, 2005 at 06:15:56PM -0800, Jeff Davis wrote:
>
> * Am I right to use NUMERIC for the chance attribute?
I ran tests with numeric, real, and double precision; double precision
was consistently about 10% faster than the others. I used the
sample data you posted and the PL/pgSQL functi
"Andrew Hall" <[EMAIL PROTECTED]> writes:
> Here is the data you requested. It took little while to gather it as this
> kind of corruption doesn't happen all the time.
It sounds like a mess, all right. Do you have a procedure to follow to
replicate this havoc? Are you sure there's not a hardwar
Tom,
Here is the data you requested. It took little while to gather it as this
kind of corruption doesn't happen all the time.
The first sign that we know something is wrong is our application freezing
when communicating with the DB.
If we then issue a vacuum, here's the output:
sonar=# VACUUM
I did some research on this and it turns out it is one of our TODO
items. It is:
o Allow COPY FROM ... CSV to interpret newlines and carriage
returns in data
This would require major refactoring of the copy source code.
We are actually careful to warn people who dum
Added to TODO:
* Add xpath_array() to /contrib/xml2 to return results as an array
---
John Gray wrote:
> On Mon, 24 Jan 2005 16:53:47 -0800, Ron Mayer wrote:
>
> > Short summary:
> >
> >I want something like
I am trying to retrieve a random record (according to a chance
attribute) from a small set of records, each with a "chance" attribute.
This may eventually be somwhat of a performance concern, so I'd like to
make sure I'm doing this right.
Here's what I have so far:
create table r1 (
i int,
On Thu, Feb 10, 2005 at 10:31:40AM -0700, Michael Fuhr wrote:
>
> UPDATE tablename SET col1 = , col2 = , ...
> WHERE keycol =
> AND (col1 IS DISTINCT FROM OR
>col2 IS DISTINCT FROM ...)
You could also do this with a trigger. If all columns in the old
and new rows are identical, then
James --
I am not sure if anyone answered this yet, but you might try:
GRANT USAGE ON SCHEMA sma_apps TO sma_user;
as the same user as createdthe schema ...
HTH,
Greg Williamson
DBA
GlobeXplorer LLC
-Original Message-
From: James Moe [mailto:[EMAIL PROTECTED]
Sent: Mon 2/14/2005 10:
On Mon, 14 Feb 2005 15:47:06 -0600, Cristian Prieto
<[EMAIL PROTECTED]> wrote:
> > why don't you use a serial? that way you don't have to insert it? i
> > usually let postgresql take care of it, and you can use currval to
> > return a value.
>
> That's the trouble, I need a sp that returns the use
On Mon, Feb 14, 2005 at 11:59:33AM -0700, James Moe wrote:
>
> When logged in as sma_user, it is denied access to the schema:
> ERROR: permission denied for schema sma_apps
See "Schemas and Privileges" in the documentation, as well as the
documentation for GRANT:
http://www.postgresql.org/docs/8
On Mon, Feb 14, 2005 at 15:12:56 -0600,
Cristian Prieto <[EMAIL PROTECTED]> wrote:
>
> And it is working fine, but when I get a Unique_Violation (cuz there is a
> iduser already) the sequence still advance to the next value. There is any
> way to rollback or avoid holes in the sequence? I've r
The manual is correct. There is no way to roll back a nextval.
There are a variety of workarounds suggested in the archives. Take a
look. One example is precalculating a large sequence and storing it in
a table.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
htt
Hello, thanks a lot for your help and sorry for my
newbie questions...
I have the following SP:
It is indexed by iduser (a primary
key)
CREATE FUNCTION store_users(name varchar, lastname
varchar) RETURNS integer AS
$body$
DECLARE
userid INTEGER :=
nextval('this_is_a_sequence');
BEGIN
On Mon, 2005-02-14 at 14:03 -0600, Cristian Prieto wrote:
> in the page http://www.postgresql.org/docs/whatsnew it's mentioned new
> features in PostgreSQL 8, I've readed the PgSQL 8 manual and found
> nothing about the use of SavePoints, Point-in-Time, etc...
>
> Where could I get more info abou
Has anybody had any experience using PG with OpenSSI (Single System Image) for
a high-availability cluster?
http://openssi.org/cgi-bin/view?page=openssi.html
Is this feasible? Possible? Easier/harder than other PG clustering solutions?
-Ben
--
"The best way to predict the future is to inven
On Mon, Feb 14, 2005 at 02:03:37PM -0600, Cristian Prieto wrote:
> in the page http://www.postgresql.org/docs/whatsnew it's mentioned
> new features in PostgreSQL 8, I've readed the PgSQL 8 manual and
> found nothing about the use of SavePoints, Point-in-Time, etc...
The Index has references to b
On Fri, Feb 11, 2005 at 09:26:22AM -0500, Jan wrote:
>
> I've never seen that syntax. Is that ANSI standard?
If you're referring to IS DISTINCT FROM, it's defined in SQL:1999
and SQL:2003.
> The last SQL database I used did not require that syntax to return the
> "affected" count I needed.
Tha
On Mon, 2005-02-14 at 18:41 +, mike wrote:
> Is it possible to have a placeholder on the left side of a select
> criteria?
yes
> eg:
>
> SELECT CASE WHEN date_part('dow',?::date)=5
>
> this bit is fine
>
> THEN CASE WHEN ? = 2 OR ? =3 OR ?=6 OR ?=7 OR ?=8 OR ?=12 THEN '7:00'
>
> here th
in the page http://www.postgresql.org/docs/whatsnew it's
mentioned new features in PostgreSQL 8, I've readed the PgSQL 8 manual and found
nothing about the use of SavePoints, Point-in-Time, etc...
Where could I get more info about
it?
Tom Lane wrote:
> Bruce Momjian writes:
> > What this brings up is that we have no way to create indexes that have
> > mixed ascending/descending column specifications.
>
> > Should this be a TODO? I am unsure.
>
> I thought we already had a TODO to provide reverse-sort operator classes
> in th
Bruce Momjian writes:
> What this brings up is that we have no way to create indexes that have
> mixed ascending/descending column specifications.
> Should this be a TODO? I am unsure.
I thought we already had a TODO to provide reverse-sort operator classes
in the standard distribution. (In th
On Mon, 2005-02-14 at 12:55, Bruce Momjian wrote:
> Neil Dugan wrote:
> > On Sun, 2005-02-13 at 20:40 -0800, Stephan Szabo wrote:
> > > On Mon, 14 Feb 2005, Neil Dugan wrote:
> > >
> > > > I am using PostgreSQL 7.4.7
> > > > I have a table with serveral fields two of these are a serialno
> > > > (
Neil Dugan wrote:
> On Sun, 2005-02-13 at 20:40 -0800, Stephan Szabo wrote:
> > On Mon, 14 Feb 2005, Neil Dugan wrote:
> >
> > > I am using PostgreSQL 7.4.7
> > > I have a table with serveral fields two of these are a serialno
> > > (bigserial) and name(varchar). I have created two indexs on thes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
~ I created a schema, database, tables, users and a user group.
create user sma_user password 'x';
create group sma_user_group;
alter group sma_user_group add user sma_user;
create table sma_apps.ordr_dat ( ... );
grant select,delete,insert
Is it possible to have a placeholder on the left side of a select
criteria?
eg:
SELECT CASE WHEN date_part('dow',?::date)=5
this bit is fine
THEN CASE WHEN ? = 2 OR ? =3 OR ?=6 OR ?=7 OR ?=8 OR ?=12 THEN '7:00'
here the ? is being read as NULL ie, output from LOG
SELECT CASE WHEN date_part(
"Bogdan Tomchuk" <[EMAIL PROTECTED]> writes:
> My question is: if we imagine that input of UpdateAccount has no =
> filtration or this filtration incorrect does exist any way to modify =
> other then authorized parameters of Accounts table or records of other =
> user? Is there any injection techn
Am Samstag, 12. Februar 2005 23:32 schrieb Preston Landers:
> If the postgresql encoding "WIN" is intended to be Cyrillic 1251, then
> it should be labeled as such in the docs to avoid confusion.
Well, isn't it? You pointed to the place in the documentation yourself.
--
Peter Eisentraut
http://
Richard Huxton writes:
> [EMAIL PROTECTED] wrote:
>> pg_dump: WARNING: owner of table "atecu91" appears to be invalid
>> pg_dump: WARNING: owner of table "letture24btdom" appears to be invalid
> Who owns tables "atecu91" and "letture24btdom" on the FreeBSD box?
Evidently nobody. Postgres doesn'
>> Additional Trigger Syntax (ie Oracle):
>I'm not seeing anything there more than syntactic sugar that PostgreSQL
>doesn't support, but no, it doesn't take that syntax.
Milla's syntax doesn't show that Oracle allows column level triggers.
That's the only difference I've noted. Column triggers a
On Fri, Feb 11, 2005 at 08:12:50PM -0500, Milla Erdee wrote:
> First, I appreciate PostgreSQL's extensive support for SQL and its
> feature set greatly, which is why I use it, because of its extensive and
> powerful features not found on some other SQL implementations and I hope
> that the capabili
On Mon, 2005-02-14 at 09:28, Peter Eisentraut wrote:
> Am Freitag, 11. Februar 2005 13:37 schrieb Marques Johansson:
> > A recent Slashdot thread on MySQL performance
> > (http://developers.slashdot.org/article.pl?sid=05/02/11/038232&from=rss)
> > contains a comment mentioning the following Fermila
Am Freitag, 11. Februar 2005 13:37 schrieb Marques Johansson:
> A recent Slashdot thread on MySQL performance
> (http://developers.slashdot.org/article.pl?sid=05/02/11/038232&from=rss)
> contains a comment mentioning the following Fermilab report from May 2003:
They were apparently testing with Po
On Mon, 2005-02-14 at 15:18 +0100, Fred Blaise wrote:
> Hello
>
> I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
> is a failover. I would like to implement a master-slave replication
> process.
>
> I believe replication has been included in the base package since 7.3.x.
>
Hello,
You can use function translate
testdb011=# select
translate('XY1X234X','qwertyuioplkjhgfdsazxcvbnmQWERTYUIOPLKJHGFDSAZXCVBNM','');
translate
---
1234
(1 row)
Regards
Pavel Stehule
---(end of broadcast)---
TIP 9: the planner wil
Hello
I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
is a failover. I would like to implement a master-slave replication
process.
I believe replication has been included in the base package since 7.3.x.
Do you have any good pointers/how-to to direct me to?
Thanks for th
On Friday 11 Feb 2005 6:07 pm, Marques Johansson wrote:
> A recent Slashdot thread on MySQL performance
> (http://developers.slashdot.org/article.pl?sid=05/02/11/038232&from=rss)
> contains a comment mentioning the following Fermilab report from May 2003:
>
> http://www-css.fnal.gov/dsg/external/fr
Suppose I have some tables and views like so for dog breeds and
breeders and their inventory where I also have a 'human' view of dog
inventory where the breed and breeder names are displayed instead of
the numerical IDs. I've gotten inserts working but I'm stymied by
updates and deletes... any hel
My database table holds phone numbers that may contain characters other than
digits (that's not a problem in itself).
I want to be able to apply a regular expression (to ignore all characters except digits) to the attribute 'phone' first and then for the ILIKE to compare
the result to $telephone.
Alle 11:57, lunedì 14 febbraio 2005, Richard Huxton ha scritto:
> [EMAIL PROTECTED] wrote:
> > Context:Postgresql 7.4.6 under linux gentoo
> >
> > To move a postgres DB from a FreeBSD box to al linux box I pg_dumped the
> > archive from the FreeBSD box and pg_restored into the linux box: Now
> > w
I have one
question that I cannot figure out 100% sure answer.
Lets say that
in schema Main I have following table:
CREATE TABLE Accounts
(
UID char(43)
PRIMARY KEY CHECK ( UID <> '' ),
Login varchar(320)
UNIQUE NOT NULL CHECK ( Login <> '' ),
Password char(32) N
First, I appreciate PostgreSQL's extensive support for SQL and its
feature set greatly, which is why I use it, because of its extensive and
powerful features not found on some other SQL implementations and I hope
that the capabilities of it will continue to be expanded and improved.
Does PostGRESQL
--On fredag, februari 11, 2005 19.08.54 -0500 Sven Willenberger
<[EMAIL PROTECTED]> wrote:
On Fri, 2005-02-11 at 18:35 -0500, Tom Lane wrote:
Sven Willenberger <[EMAIL PROTECTED]> writes:
> it looks like the sed line is stripping out pgac_tmp2 from the
> pgac_tmp1 leaving the system to use the d
--On fredag, februari 11, 2005 18.35.45 -0500 Tom Lane <[EMAIL PROTECTED]>
wrote:
Sven Willenberger <[EMAIL PROTECTED]> writes:
it looks like the sed line is stripping out pgac_tmp2 from the pgac_tmp1
leaving the system to use the default perl libperl.so.
when I modified perl_embed_ldflags to no
The PG documents on database character set encodings, such as here:
http://www.postgresql.org/docs/8.0/interactive/multibyte.html#CHARSET-TABLE
say that the "WIN" encoding in Postgresql means cp1251, which according
to Microsoft:
http://www.microsoft.com/globaldev/reference/wincp.mspx
cp1251 is
Hello there,
Currently, we r using, Postgresql v 7.3, on RedHat 9
machines.
We provide a hot standby at all times for the Primary
server.
So, we have to maintain a duplicate of the entire
database.
The problem arises, when the standby boots.
I wanted to know, whenever the standby boots up, wh
On Fri, Feb 11, 2005 at 04:41:55PM -0500, Sven Willenberger wrote:
> On Fri, 2005-02-11 at 21:35 +0100, Anton Berezin wrote:
> > On Fri, Feb 11, 2005 at 11:10:15AM -0500, Sven Willenberger wrote:
> > > On Fri, 2005-02-11 at 16:46 +0100, Palle Girgensohn wrote:
> > > > --On fredag, februari 11, 2005
On Fri, Feb 11, 2005 at 11:09:35PM +0100, Anton Berezin wrote:
> On Fri, Feb 11, 2005 at 04:41:55PM -0500, Sven Willenberger wrote:
> > On Fri, 2005-02-11 at 21:35 +0100, Anton Berezin wrote:
> > > On Fri, Feb 11, 2005 at 11:10:15AM -0500, Sven Willenberger wrote:
> > > > On Fri, 2005-02-11 at 16:4
Michael,
I've never seen that syntax. Is that ANSI standard?
The last SQL database I used did not require that syntax to return the
"affected" count I needed.
Is there any industry standard concerning the implementation of "affected"?
Thanks
- Original Message -
From: "Michael Fuhr"
A recent Slashdot thread on MySQL performance
(http://developers.slashdot.org/article.pl?sid=05/02/11/038232&from=rss)
contains a comment mentioning the following Fermilab report from May 2003:
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
With the release of PostgreSQL 8.0,
[EMAIL PROTECTED] wrote:
Context:Postgresql 7.4.6 under linux gentoo
To move a postgres DB from a FreeBSD box to al linux box I pg_dumped the
archive from the FreeBSD box and pg_restored into the linux box: Now when
I pg_dump the archive I get the following warnings for every table in the
archive:
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: 13 February 2005 02:45
> To: Bruce Momjian
> Cc: Russell Smith; pgsql-general@postgresql.org;
> [EMAIL PROTECTED]
> Subject: Re: [pgsql-www] [GENERAL] Website Documentation
>
> Br
Context:Postgresql 7.4.6 under linux gentoo
To move a postgres DB from a FreeBSD box to al linux box I pg_dumped the
archive from the FreeBSD box and pg_restored into the linux box: Now when
I pg_dump the archive I get the following warnings for every table in the
archive:
...
In article <[EMAIL PROTECTED]>,
Martijn van Oosterhout writes:
> There's one corner case you need to make sure you handle. In the plan
> that started this thread there's a query node marked (never executed).
> That will affect yout regex a bit. an that case you should probably
> return NULLs. (It
Hi,
Citing Rey Arqueza <[EMAIL PROTECTED]>:
> after running: rpm -i ./postgresql-server-8.0.1-1PGDG.i686.rpm, I get the
> following error:
>
> error: Failed dependencies:
> /usr/sbin/useradd is needed by postgresql-server-8.0.1-PGDG
>
> I would guess that /usr/sbin needs to be in my path? if I
after running: rpm -i ./postgresql-server-8.0.1-1PGDG.i686.rpm, I get the
following error:
error: Failed dependencies:
/usr/sbin/useradd is needed by postgresql-server-8.0.1-PGDG
I would guess that /usr/sbin needs to be in my path? if I guessed correctly,
how do I do that? If this is not the ca
59 matches
Mail list logo
