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 table
Rick Schumeyer wrote:
I think this is a common task, but Im 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. Im
not concerned about the list changing after the initial query.
Im accessing this via
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
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
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
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 wherever
INSERT INTO real_table
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
dont know until
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 be in
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
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 dont know
On Sun, 2005-01-30 at 21:24 -0500, Rick Schumeyer wrote:
I think this is a common task, but Im 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. Im
not concerned about the list changing after
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
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
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 +0700,
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 stick
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.
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 personal
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 files
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
-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
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 incorporated
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 increasing and
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 cause the
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 to
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
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
On Jan 30, 2005, at 9:24 PM, Rick Schumeyer wrote:
Im accessing this via a php web page. Im 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 script.
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
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
Egyd 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 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
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
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 Egyd
-Original
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
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
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
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?id=113231
Steve Wampler [EMAIL PROTECTED] writes:
-gunzip atst.logdb.out.gz | psql -q
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
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
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' pgsql-general@postgresql.org
Sent: Monday, January 31, 2005 2:33 PM
Subject: Re: [GENERAL] Postgresql and Athlon64 ?
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 series.
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
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] :=
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' pgsql-general@postgresql.org
Sent: Monday, January 31, 2005 2:33 PM
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 on
Tom Lane wrote:
Steve Wampler [EMAIL PROTECTED] writes:
-gunzip atst.logdb.out.gz | psql -q
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?
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 'sbw';
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
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
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 with
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
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
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] :=
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,
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: Egyd
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 now
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
granted f
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
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.
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
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
[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
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,
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
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 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
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:
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
grab
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 the arrays
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
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
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 a cursor
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 waiting a very
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
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
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 = 'newlength + 4' WHERE typname = 'domain
name';
command to achieve this. I'd prefer not to dump/reload the database. I
remember seeing 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
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
[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 lane
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:
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 updating the
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;
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
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 location_for_dump -Fc -v dbname
I want to restore these databases on a different
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
86 matches
Mail list logo