On Tue, Feb 01, 2005 at 12:11:06AM -0700, Pritesh Shah wrote:
>
> Is there any way of copying/dumping/restoring the user and group
> information and permissions from the old machine to the new one so
> that i do not have to do a createuser everytime??
You can dump just users and groups with "pg_du
hi,
I'm trying to make some hardware upgrades (increasing disk capacity)
to the machine where the database server is running. So, I've backed
up all the existing databases using the following command:
pg_dump -f -Fc -v
I want to restore these databases on a different machine. I've got the
post
Michael Fuhr <[EMAIL PROTECTED]> writes:
> I've noticed that in PostgreSQL 7.4, successive commands in a
> transaction get cmin values that increment by 1, but in other
> versions cmin increments by 2. Example:
Not sure about pre-7.4, but 8.0 is doing this because of a faulty
translation of list-
I've noticed that in PostgreSQL 7.4, successive commands in a
transaction get cmin values that increment by 1, but in other
versions cmin increments by 2. Example:
CREATE TABLE foo (x integer);
BEGIN;
INSERT INTO foo VALUES (1);
INSERT INTO foo VALUES (2);
INSERT INTO foo VALUES (3);
COMMIT;
Res
Niederland wrote:
> postgres does not seem to pick up
> the following parameter in the postgresql.conf
>
> add_missing_from = false
>
> Setting the parameter via psql, functions properly
> SET add_missing_from TO FALSE
>
> Using: winxp, Postges 8.0
> (note: I did restart the service after updati
In order to address a potential security hole recently identified with the
"LOAD" option, the PostgreSQL Global Development Group is announcing the
release of new versions of PostgreSQL going back to the 7.2.x version.
As always, these releases are available on all mirrors, as listed at:
[EMAIL PROTECTED] (Bradley D. Snobar) writes:
> I tried to change this section of code to reflect my desire.
> /usr/local/pgsql/include/server/pg_config_manual.h
Did you do a *full* recompile afterwards? (make distclean and start
again would be my advice)
regards, tom lan
If I have posted this question to the wrong mailing list, I apologize (I am new
to the postgres community) and I ask that someone please respond with the
correct place to get my question answered.
I ran into a probelm during initdb after I tried to change the maximum number
of functions in an a
Shawn Harrison wrote [01/28/05 3:53 PM]:
I have a table like this:
create table objects (
id serial primary key,
name varchar not null,
parent integer references objects(id) default 1 not null,
urivarchar not null
) without oids;
The uri column is a denormalization f
I need to increase the length of one of my domains from 16 -> 20 characters.
How wise/unwise would it be for me to issue an
UPDATE pg_type SET typtypmod = '' WHERE typname = '';
command to achieve this. I'd prefer not to dump/reload the database. I
remember seeing a thread on this a few months ba
Hi All,
false alarm... I found the problem. I tried to reuse an
insertStatement. can't do it.
Phil
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi All,
I'm getting the following from an "insertStatement.executeUpdate();"
error message:
postgresql.stat.result
[EMAIL PROTECTED]
Does anybody know why?
thanks,
Phil
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
On Mon, 2005-01-31 at 16:08, Ragnar Hafstaà wrote:
> On Mon, 2005-01-31 at 15:38 -0600, Scott Marlowe wrote:
> > On Mon, 2005-01-31 at 09:28, Alban Hertroys wrote:
> > > John DeSoi wrote:
> > > > I think there are much better ways to do this. If the result set is
> > > > large, the user could be w
On Mon, 2005-01-31 at 15:38 -0600, Scott Marlowe wrote:
> On Mon, 2005-01-31 at 09:28, Alban Hertroys wrote:
> > John DeSoi wrote:
> > > I think there are much better ways to do this. If the result set is
> > > large, the user could be waiting a very long time. Two possibilities are
> > > (1) use
On Mon, Jan 31, 2005 at 11:43:45AM -0800, Si Chen wrote:
> Thanks, Michael, for the input. Is there anyway in PostgreSQL to force
> some transactions to close (rollback if necessary)? I notice there is no
> way to release a LOCK manually.
I'm not aware of a way to terminate a transaction in ano
dale wrote:
PostgreSQL users,
What are the restrictions on naming tables or columns in tables
other than uniqueness (assuming ascii characters)? For instance, are
names case sensitive. What special characters can be used
(`_`,`-`,` `). I looked at the docs in the tutorial part in the
Sven Willenberger <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I think we changed this in 8.0. Before 8.0, trying to assign to an
>> element of a NULL array yielded a NULL result array, but I think now
>> we let you produce a one-element array that way.
>>
> Using a 8.0 testbox I find that th
On Mon, 2005-01-31 at 09:28, Alban Hertroys wrote:
> John DeSoi wrote:
> > I think there are much better ways to do this. If the result set is
> > large, the user could be waiting a very long time. Two possibilities are
> > (1) use a cursor or (2) use limit and offset in your select statement
>
On Mon, Jan 31, 2005 at 03:05:52PM -0600, dale wrote:
>
> What are the restrictions on naming tables or columns in tables
> other than uniqueness (assuming ascii characters)?
See "Identifiers and Key Words" in the "SQL Syntax" chapter of the
documentation:
http://www.postgresql.org/docs/8.0/stat
> I looked at the docs in the tutorial part in the beginning and in the
> description of CREATE TABLE but could not find naming restriction info.
> Could someone point me in the right direction?
Try section 4.1.1: Identifiers and Key Words.
In general PostgreSQL's SQL syntax is case-insens
PostgreSQL users,
What are the restrictions on naming tables or columns in tables other
than uniqueness (assuming ascii characters)? For instance, are names
case sensitive. What special characters can be used (`_`,`-`,` `).
I looked at the docs in the tutorial part in the beginning and i
I really can't find such file in contrib dir. Nor files containing 'icount'
pattern. Sorry.
I use Pg8.0 final on windows XP.
On the http://www.sai.msu.su/~megera/postgres/gist/ url I can find only a
patch. Where can I download the whole package from?
Thank you.
-- Csaba
-Original Message--
Tom Lane wrote:
Sven Willenberger <[EMAIL PROTECTED]> writes:
The problem stems from being unable to assign values to an array without
first initializing the array in plpgsql.
I think we changed this in 8.0. Before 8.0, trying to assign to an
element of a NULL array yielded a NULL result array,
[bcc to -hackers, -general]
Folks,
I'm happy to announce that PostgreSQL will have a home at LinuxWorld in two weeks after
all. My company, OpenMFG, is teaming up with SRA America to wave the elephant flag at
booth #1411 - right next door to the ".org Pavillion", two booths up from the
Intel sp
Thanks, Michael, for the input. Is there anyway in PostgreSQL to force
some transactions to close (rollback if necessary)? I notice there is no
way to release a LOCK manually.
Si
Michael Fuhr wrote:
On Mon, Jan 31, 2005 at 10:13:26AM -0800, Si Chen wrote:
Hello everyone. I am trying to do an
contrib/intarray
On Mon, 31 Jan 2005 20:00:06 +0100, Együd Csaba <[EMAIL PROTECTED]> wrote:
Hi,
this function is part of GiST which is not installed on my server.
Should I
install the whole GiST or there is a single package to implement only
this
feature?
thank you,
-- Csaba
-Original
k, where are you seeing the cgi-bin link referenced? it hasn't been there
for *ages* ... should just be:
http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org
Just tested from here to make sure ...
On Mon, 31 Jan 2005, Steve Crawford wrote:
On Friday 28 January 2005 5:05 pm, Marc G. Four
On Friday 28 January 2005 5:05 pm, Marc G. Fournier wrote:
...
> > Put something informative at
> > http://webmail.postgresql.org/cgi-bin/mj_wwwusr/domain=postgresql
> >.org
>
> change the webmail to be just mail, and everything should work as
> expected ...
Like
http://mail.postgresql.org/cgi-bi
On Mon, Jan 31, 2005 at 10:13:26AM -0800, Si Chen wrote:
> Hello everyone. I am trying to do an ALTER TABLE, but it hangs
> indefinitely. I think the table is locked from a transaction, and in
> pg_locks I found:
> relation 75907
> database 74861
> pid 29604
> mode AccessExclusiveLock
> grant
Sven Willenberger <[EMAIL PROTECTED]> writes:
> The problem stems from being unable to assign values to an array without
> first initializing the array in plpgsql.
I think we changed this in 8.0. Before 8.0, trying to assign to an
element of a NULL array yielded a NULL result array, but I think
Hi,
this function is part of GiST which is not installed on my server. Should I
install the whole GiST or there is a single package to implement only this
feature?
thank you,
-- Csaba
-Original Message-
From: PFC [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 5:16 PM
To: Együd
Shawn Harrison wrote [01/31/05 12:56 PM]:
Shawn Harrison wrote [01/28/05 3:53 PM]:
create or replace rule objects__update as on update to objects
do instead (
update objects_data set
name = new.name,
typename = new.typename,
parent = new.parent,
Tom Lane wrote:
Sven Willenberger <[EMAIL PROTECTED]> writes:
I am having an issue with trying to dereference a 2-dimensional array in
plpgsql. The idea is to have an setup like:
DECLARE
myarray varchar[][];
myvar char;
BEGIN
--stuff
myarray[1] := ''{value1,value2,value3}'';
myarray[2] := ''{v
PFC wrote [01/28/05 7:08 PM]:
First you should use a ltree type for the uri field :
Yes, it would be very good if I could use ltree rather than rolling my
own, but ltree doesn't meet my use requirements.
- you write it foo.bar instead of /foo/bar
That is the problem: The point is to make look
Andrey V. Semyonov wrote [01/29/05 12:45 PM]:
isn't it possible to restrict UPDATE by access rights based on the DB's
user?
Create table with owner set to the administrator of the database (NOT
PostgreSQL SERVER!!!) and grant only the needed rights (or none of them)
to the user from which the u
Marian POPESCU <[EMAIL PROTECTED]> writes:
> I put up a testcase at
> http://perso.netpratique.fr/softexpert/pgsql/unicodetest.data.gz
After experimenting, the only case in which I could get that failure was
to deliberately force a database encoding incompatible with the locale,
namely initdb wit
Hello everyone. I am trying to do an ALTER TABLE, but it hangs
indefinitely. I think the table is locked from a transaction, and in
pg_locks I found:
relation 75907
database 74861
pid 29604
mode AccessExclusiveLock
granted f
Is there a way to release this lock? Or does the database need to
It looks as though you need to create your database users.
Try using the "createuser" command.
For more information:
http://www.postgresql.org/docs/7.4/interactive/user-manag.html
Eddy
Mike-Olumide Johnson wrote:
Hello,
Have RADIUS setup and working properly.
While executing SQL got the following
Steve Wampler <[EMAIL PROTECTED]> writes:
> In fact, now that I look more at the dump file, it's kinda interesting.
> Near the top are the lines:
> \connect "atst.logdb" atst
> SET client_encoding = 'SQL_ASCII';
> SET check_function_bodies = false;
> SET SESSION AUTHORIZATION
Tom Lane wrote:
Steve Wampler <[EMAIL PROTECTED]> writes:
->gunzip
I see all the permission denied messages, but why? How can a user
create a dump that they cannot load back in (the user has createdb *and*
createuser permissions)?
Which part of "must be superuser" are you not following? The dat
NTPT wrote:
> Will I have some advantages, better performance etc using postgres
> 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are
> there asome benchmark available or someone personal experience ?
>
>
> Or should I stay in 32 bit platform for a while ?
PG 8 works fine o
NTPT wrote:
So postgresql can have benfit from 64 bit architecture ?
Yes quite.
Sincerely,
Joshua D. Drake
- Original Message - From: "P.J. "Josh" Rovero"
<[EMAIL PROTECTED]>
To: "NTPT" <[EMAIL PROTECTED]>
Cc: "'PgSql General'"
Sent: Monday, January 31, 2005 2:33 PM
Subject: Re: [GENERAL
Sven Willenberger <[EMAIL PROTECTED]> writes:
> I am having an issue with trying to dereference a 2-dimensional array in
> plpgsql. The idea is to have an setup like:
> DECLARE
> myarray varchar[][];
> myvar char;
> BEGIN
> --stuff
> myarray[1] := ''{value1,value2,value3}'';
> myarray[2] := ''{va
Hello,
Have RADIUS setup and working properly.
While executing SQL got the following error:
'psql: Warning: The -u option is deprecated. Use -U. User name: Password:
/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_pos
tgresql.sql: Permission denied'
Below is further oup
On Mon, Jan 31, 2005 at 09:45:16 -0700,
Steve Wampler <[EMAIL PROTECTED]> wrote:
> Steve Wampler wrote:
> >
> >I realize 7.2.4 is long in the tooth, but it's an old system that's been
> >running for several years now. Someday we'll upgrade...
There are more recent releases even within the 7.2.x
So postgresql can have benfit from 64 bit architecture ?
- Original Message -
From: "P.J. "Josh" Rovero" <[EMAIL PROTECTED]>
To: "NTPT" <[EMAIL PROTECTED]>
Cc: "'PgSql General'"
Sent: Monday, January 31, 2005 2:33 PM
Subject: Re: [GENERAL] Postgresql and Athlon64 ?
It runs fine, and
Steve Wampler wrote:
I realize 7.2.4 is long in the tooth, but it's an old system that's been
running for several years now. Someday we'll upgrade...
However, part of the upgrade will involve dumping and restoring the
tables. I've just did a little playing with pg_dump on one of
the databases and
Steve Wampler <[EMAIL PROTECTED]> writes:
> ->gunzip ERROR: permission denied to set session authorization
> ERROR: permission denied for language c
> ERROR: must be superuser to create procedural language
> I see all the permission denied messages, but why? How can a user
> create a dump tha
Marian POPESCU <[EMAIL PROTECTED]> writes:
> I want to report a bug on PG 8.0 (linux : Fedora Core 3)
> A LIKE '%langage C%' in the WHERE clause of my SELECT statement gives
> "invalid multibyte character for locale" error.
> I thought the bug
> https://bugzilla.redhat.com/bugzilla/show_bug.cgi?i
RTFM.
You have: tempK(1)
You want: tempC
-272.15
--
greg
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
icount( array )
Hi Seven,
it would be better for me if it returned the number of elements as an
integer even if the array is empty (in this case it returns with NULL).
No
metter this is easily can be worked around, but it would have been more
confortable.
Thank you very much.
-- Csaba Együd
Hi,
I have been running a 2Gb database for about 3 months now on my AMD64
bit and have been very happy with the peformance and stability. I am
running it under Gentoo.
I don't have any particular benchmarks and only my own testing of our
company scripts. I have been very impressed with the perfor
Hi Seven,
it would be better for me if it returned the number of elements as an
integer even if the array is empty (in this case it returns with NULL). No
metter this is easily can be worked around, but it would have been more
confortable.
Thank you very much.
-- Csaba Együd
-Original Messag
John DeSoi wrote:
I think there are much better ways to do this. If the result set is
large, the user could be waiting a very long time. Two possibilities are
(1) use a cursor or (2) use limit and offset in your select statement
grab only the rows you need to display.
Someone correct me if I'm w
I am having an issue with trying to dereference a 2-dimensional array in
plpgsql. The idea is to have an setup like:
DECLARE
myarray varchar[][];
myvar char;
BEGIN
--stuff
myarray[1] := ''{value1,value2,value3}'';
myarray[2] := ''{valuea,valueb,valuec}'';
--If I then:
myvar := array[1][1];
--I
Együd Csaba wrote:
Hi,
how can I determin the number of elements of an array? I saw function
array_dims() which returns a string value representing the dimensions of the
array. Is there a function which returns only the number of elements as an
integer.
-- Csaba
array_upper(arrayname,dimension)
I realize 7.2.4 is long in the tooth, but it's an old system that's been
running for several years now. Someday we'll upgrade...
However, part of the upgrade will involve dumping and restoring the
tables. I've just did a little playing with pg_dump on one of
the databases and discovered that I ca
Rick Apichairuk wrote:
On Sun, 30 Jan 2005 21:12:08 -0500, Sven Willenberger <[EMAIL PROTECTED]> wrote:
I assume you added these variables to either the GENERIC or a custom
kernel in /usr/src/sys/i386/conf. If you created a custom kernel called
CUSTOM, then you would:
That's what I did.
cd /u
On Jan 30, 2005, at 9:24 PM, Rick Schumeyer wrote:
I’m accessing this via a php web page. I’m thinking that maybe
the best way to do this, other than re-running the query each time,
is to put the results into a temporary table. I think this will work
if I never call “disconnect” from the php scri
Rick Schumeyer wrote:
I think this is a common task, but I'm not sure how to do it.
I want to run a query that can return many records, display them
10 at a time, and be able to go forward/backward in the list. I'm
not concerned about the list changing after the initial query.
I'm accessing this v
Frans wrote:
I'm using Fedora Core 2, apache 2.0 and postgresql 7.4.6.
Recently, the application is slowing down. When I check the process
using "top", sometimes postmaster process time is increasing and the
process is never end, I think this cause the application slowing down
and sometimes this pr
Frans wrote:
I'm using Fedora Core 2, apache 2.0 and postgresql 7.4.6.
Recently, the application is slowing down.
You don't say what the application is.
> When I check the process
using "top", sometimes postmaster process time is increasing and the
process is never end,
The postmaster is supposed t
On Mon, Jan 31, 2005 at 08:28:28AM +0700, Frans wrote:
>
> I'm using Fedora Core 2, apache 2.0 and postgresql 7.4.6.
> Recently, the application is slowing down. When I check the process
> using "top", sometimes postmaster process time is increasing and the
> process is never end, I think this caus
How often are you running vacuumdb ?
On Mon, 31 Jan 2005 08:28:28 +0700, Frans <[EMAIL PROTECTED]> wrote:
> I'm using Fedora Core 2, apache 2.0 and postgresql 7.4.6.
> Recently, the application is slowing down. When I check the process
> using "top", sometimes postmaster process time is increasin
Hi,
I want to report a bug on PG 8.0 (linux : Fedora Core 3)
A LIKE '%langage C%' in the WHERE clause of my SELECT statement gives
"invalid multibyte character for locale" error.
I thought the bug
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=113231 was fixed
and the patch was incorporate
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
That option was already turned off, and I already have an unconditional
update rule on the view.
On Jan 27, 2005, at 1:51 AM, Sim Zacks wrote:
I don't know how this works for a view, but in the ODBC driver settings
there is an option on page 2 to show
Hello,
I started work on "light" version dblink for mysql. I have problems: I
can't use header files mysql and postgresql together.
/usr/local/include/mysql/my_list.h:32: error: conflicting types for
`list_delete'
/usr/local/pgsql/include/server/nodes/pg_list.h:210: error: previous
declaration
On Mon, Jan 31, 2005 at 01:20:39PM +0700, Frans wrote:
> last vacuumdb was 5 or 6 months ago, but the transactions is not big
> (about 500-1000 transaction a day). The postmaster did not eating up
> memory, but eating up processor process.
There's your problem. If you don't vacuumdb, then the fil
It runs fine, and is quite "peppy" an Fedora Core 2 for AMD 64.
I have not run into any problems.
NTPT wrote:
Will I have some advantages, better performance etc using postgres 7.4
or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there
asome benchmark available or someone persona
Hi,
how can I determin the number of elements of an array? I saw function
array_dims() which returns a string value representing the dimensions of the
array. Is there a function which returns only the number of elements as an
integer.
-- Csaba
--
No virus found in this outgoing message.
Checke
On Mon, Jan 31, 2005 at 11:57:41AM +0100, Alban Hertroys wrote:
> Greg Stark wrote:
> >That's the program I suggested writing a function to hand this work off to
> >(presumably in the form of a dynamic library). Keep the postgres code
> >agnostic
> >about the semantics of the units. As long as you
last vacuumdb was 5 or 6 months ago, but the transactions is not big
(about 500-1000 transaction a day). The postmaster did not eating up
memory, but eating up processor process.
On Sun, 30 Jan 2005 22:13:49 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Jan 31, 2005 at 08:28:28AM +070
IF you use pg_pconnect(), never close your script, and this page always
shows the same data to all users, then the temp table would work,
although it is not necessarily quicker than selecting ALL the rows
(i.e., don't bother with a temp table at all; just run the whole select
every time.)
The
On Mon, 31 Jan 2005 13:18:38 +0100, Mark Battersby wrote:
> When looking at PostGres through the eyes of an Oracle Developer I was
> wondering if PostGres supports a feature called Dynamic SQL. Of course even
> better would be the ability to run PostGress/PL dynamically too.
PostgreSQL does not c
On Sun, 2005-01-30 at 21:24 -0500, Rick Schumeyer wrote:
> I think this is a common task, but I’m not sure how to do it.
> I want to run a query that can return many records, display them
> 10 at a time, and be able to go forward/backward in the list. I’m
> not concerned about the list changing af
Mark Battersby wrote:
When looking at PostGres through the eyes of an Oracle Developer I was
wondering if PostGres supports a feature called Dynamic SQL. Of course
even better would be the ability to run PostGress/PL dynamically too.
Dynamic SQL and Dynamic PL/SQL are useful when you don’t know
Yes, it does. And it's a lot easier than DBMS_SQL too!
Look at the EXECUTE command in the pl/pgsql programming language.
See http://www.postgresql.org/docs/7.4/interactive/plpgsql-statements.html
John Sidney-Woollett
Mark Battersby wrote:
Hi
When looking at PostGres through the eyes of an Oracle
> I've installed this version on my Win2K machine and can
> connect using pgAdminIII just fine.
>
> I then installed libpqxx 2.4.2 via (i.e., for and under)
> cygwin and find that no matter what I do I cannot get the
> most basic test routine (test001.cxx) to execute. The problem
> appears to
Hi
When looking at PostGres through the eyes of an
Oracle Developer I was wondering if PostGres supports a feature called Dynamic
SQL. Of course even better would be the ability to run PostGress/PL dynamically
too.
Dynamic SQL and Dynamic PL/SQL are useful when you
don’t know until
Inserting into all the columns doesn't change the sequence, as you
discovered. The usual solution to this problem is to create a table
that exactly matches your to-be-COPYed-data, do the copy.
CREATE TEMP temp_table (columns from data...)
\copy temp_table from
INSERT INTO real_table (columns...)
Will I have some advantages, better performance etc
using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro
?Are there asome benchmark available or someone personal experience ?
Or should I stay in 32 bit platform for a
while ?
Thanx for help
No need to worry about visibility problems. Trying to insert a record from the
notify receiver sends the application into a tail spin that ends in a core
dump. It won't work. I guess there is nothing to do but write all this crap
in C. I can prompt the user easy enough, but I can't get anything
Greg Stark wrote:
You mean like the traditional units program available on virtually all Unix
machines?
$ units
2084 units, 71 prefixes, 32 nonlinear units
You have: 1 lightyear/fortnight
You want: m/s
* 7.8213711e+09
/ 1.2785482e-10
That's the program I sugg
Rick Schumeyer wrote:
I think this is a common task, but I’m not sure how to do it.
I want to run a query that can return many records, display them
10 at a time, and be able to go forward/backward in the list. I’m
not concerned about the list changing after the initial query.
I’m accessing this v
Hi,
I have a problem with the SEQUENCE generation. I have a column in a table which auto increments by 1 every time there is a entry and I am strictly prohibited to use only PostgreSQL 7.2 version. Now the problem is with the COPY command, I will have to copy entire columns present in the tab
86 matches
Mail list logo
