Simpler is better ;o)
Thanks for the input...
On Thursday 01 December 2005 10:31 pm, David Fetter saith:
On Thu, Dec 01, 2005 at 12:32:02PM -0500, Terry Lee Tucker wrote:
List,
I have a simple function:
I have a simpler one :)
CREATE OR REPLACE FUNCTION split_to_rows(TEXT, TEXT) /*
Matias Silva wrote:
Hi everyone, I'm totally new here and I got a little issue.
I just got done installing PostgreSQL 8.1. I have configured PostgreSQL
to start automatically upon system start via an init script. Problem
is that when CentOS boots it halts on Starting PostgeSQL. I have
to
Cott Lang wrote:
Within 5 minutes, one server would not accept new remote connections. I
could log in fine w/ psql locally.
This is pretty bizarre ... offhand I would not have thought that the
postmaster depended on DNS service at all. Were you maybe using DNS
names instead of IP addresses in
I'm new to PostgreSQL and I'm a litle
confused.
I have 2 questions about using user_write_lock
functions:
1. if a user set a write lock and then, for some
reason (bad connections, app chashes, etc), disconect from server without releasing, what happened with the lock ? It will be
still
Hi all,
I have a problem about deadlock. I have several stored procedures; only
one of them uses ACCESS EXCLUSIVE LOCK on a table; however, all the
stored procedures can access to that table, using SELECT, INSERT or UPDATE.
The stored procedures are called by different processes of an external
On 12/1/05, marcelo Cortez [EMAIL PROTECTED] wrote:
i have problems with encodings
PostgreSQL case conversion functions is a little bit buggy.
(Especially for Latin-N and Unicode encodings.) I've prepared a patch
[1] to fix a similar problem for Latin5 encoding. It wasn't tested so
much but
Hi!
Is this the expected behaviour?
select ID
, USK_RATING AS USK
from (
select ID
, USK_RATING
from MAIN_SONY_PS2_GAME
where ID = 101400
limit 1
)
as PRODUCT_LIST
limit 1;
id | usk_rating
+
101400 |
(1 row)
Note the column-header being
Matias Silva [EMAIL PROTECTED] writes:
How do I fix this?
I check the PostgreSQL logs and the only thing that stands out is
Do you want to choose a different one? [n]Your default context is
user_u:system_r:unconfined_t.. However when I search Google, I find
nothing.
Dunno the actual
This might be a bit off-topic, but I'm curious what folks would do with this
situation:
I have about 6 different tab-delimited file types, all of which store
similar information (microarray gene expression). However, the files come
from different manufacturers, so each has slightly different
Perhaps this is not a postgresql solution, but you could;
1. first design a common data structure in postgresql.
2. then convert each type of the tab-delimited file to a basic xml
structures.
3. map the structures to the common data structure using xslt.
I hope this helps,
This might be a bit
Hi Sean,
We use something similar to approach 1) to store our microarray data.
We have a data table that has a few specific columns (signal median, bkg
median etc) as these exist in all the file formats... Plus also some generic
columns for the rest of the data fields.
Then we have a
Hi everyone, I have a problem with corrupt UTF-8 sequences in my 8.0.4
dump which is preventing me from upgrading to 8.1 - which spots the
errors and refuses to import the data. Is there some SQL command that I
can use to fix or cauterise the sequences in the 8.0.4 database before
dumping to
Cott Lang [EMAIL PROTECTED] writes:
What exactly does
would not accept mean --- what was the exact error message,
and was there anything in the postmaster log?
There was nothing in the postmaster log indicating a problem.
The only thing I saw strange was multiple postmasters spawning and
Francesco Formenti - TVBLOB S.r.l. [EMAIL PROTECTED] writes:
I have a problem about deadlock. I have several stored procedures; only
one of them uses ACCESS EXCLUSIVE LOCK on a table; however, all the
stored procedures can access to that table, using SELECT, INSERT or UPDATE.
The stored
Markus Wollny [EMAIL PROTECTED] writes:
Is this the expected behaviour?
No, it's a bug introduced in 8.1. It's fixed in CVS tip.
regards, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Sean Davis wrote:
This might be a bit off-topic, but I'm curious what folks would do
with this
situation:
I have about 6 different tab-delimited file types, all of which store
similar information (microarray gene expression). However, the files
come from different manufacturers, so each
On 12/2/05 10:21 AM, Guy Rouillier [EMAIL PROTECTED] wrote:
Sean Davis wrote:
This might be a bit off-topic, but I'm curious what folks would do
with this
situation:
I have about 6 different tab-delimited file types, all of which store
similar information (microarray gene expression).
And InnoDB is actually quite a bit worse than PostgreSQL (ignoring the
slight difference in row numbers)
InnoDB:
olp_live select count(*) from team_players;
+--+
| count(*) |
+--+
| 465004 |
+--+
1 row in set (1.54 sec)
PostgreSQL:
olp_live=# select count(*) from
I answer here so each one can help you.
Cannot understand what you meanindex is numbered? Are you talking
about autoincrement as called in mysql? use sequences please
Best regards
Rodrigo
Poul Møller Hansen wrote:
Rodrigo Gonzalez wrote:
Poul,
2 thingsfirst, why do you think it
Using custom output format instead of tar output (-Fc instead if -Ft)
appears to work without error. My initial tests with the backup db
seem to match the original db.
The compressed output files are also a lot smaller ;)
Note that the problematic tar files were never transfered between
Greetings,
I am new to PostgreSQL and come from an DB2
background. I currently have v8.0.3 up and running.
So far, it looks great!
One area I am confused about is how to set up
databases and users. I can currently create
databases, but I am having difficulty in assigning
mutiple users to
Postgres' users are not specific to a database, they are shared across
all databases on a particular server.
At the database level, you can assign creation and other permissions to
users, but (AFAIK) you cannot deny users to a database. However, you can
effectively control users' access to a
On 12/1/05, Uwe C. Schroeder [EMAIL PROTECTED] wrote:
On Thursday 01 December 2005 10:24, Jaime Casanova wrote:
On 12/1/05, Uwe C. Schroeder [EMAIL PROTECTED] wrote:
Hi everyone,
in 8.1 by default tables have no OID's anymore. Since OID's are 4 byte
it's probably a good idea to
There is a patch under consideration for 8.2 that would reduce the
storage requirement for numeric values by two bytes, but also reduce the
range of allowed numeric values to 508 digits. The current specified
maximum NUMERIC length is 1000 (NUMERIC(1000,0)), and the maximum
computational length
I am making rules for a table and I want to know what values or variables
can I use apart from the new... and old... fields, for example I would
like to read the SQL query that the user wrote that caused this rule to
execute. Can this be done?
---(end of
Bruce Momjian
Sent: Friday, December 02, 2005 9:39 AM
There is a patch under consideration for 8.2 that would reduce the
storage requirement for numeric values by two bytes, but also reduce the
range of allowed numeric values to 508 digits.
...
Is that an acceptable tradeoff (reduced size,
Tom Lane wrote:
Francesco Formenti - TVBLOB S.r.l. [EMAIL PROTECTED] writes:
I have a problem about deadlock. I have several stored procedures; only
one of them uses ACCESS EXCLUSIVE LOCK on a table; however, all the
stored procedures can access to that table, using SELECT, INSERT or
Rodrigo Gonzalez wrote:
I answer here so each one can help you.
Cannot understand what you meanindex is numbered? Are you talking
about autoincrement as called in mysql? use sequences please
Sorry, forgot that your email address was in the reply-to field.
I was seeking a solution on
Is there any case when PostgreSQL adds an order by
to a view *definition* in 7.4? I have evidence
that
create view
results in
create view ORDER BY ...
as shown by \d viewname.
The view does a five way ordinary join.
Any definitive answer would be very helpful.
Thanks,
No problem at all.
MyISAM stores the row count in it's header (.frm file).
You can do something like this using a table that has for example
tablename, rowcount.
On the other hand, MySQL with MyISAM does not have row locking, so this
problem is not considered.
Maybe if you tell what you
We're migrating from 7.3.4 to 8.1.0, and I'm seeing different behavior
with the createuser command. What we are wanting is to streamline our
product installs, to require minimal user interaction, so we basically
embed the password like this in our bourne-shell wrapper script:
Toni Casueps wrote:
I am making rules for a table and I want to know what values or
variables can I use apart from the new... and old... fields, for
example I would like to read the SQL query that the user wrote that
caused this rule to execute. Can this be done?
No. And there's isn't
Gary Horton wrote:
...and in 7.3.4, this works just fine, with the shell consuming the
stdin and redirecting it to the createuser command, which subsequently
doesn't bother the user with the prompt (i.e. the prompts are responded
to automatically). However, this doesn't work at all in 8.1.0 --
On 12/2/05, Poul Møller Hansen [EMAIL PROTECTED] wrote:
Rodrigo Gonzalez wrote:
I answer here so each one can help you.
Cannot understand what you meanindex is numbered? Are you talking
about autoincrement as called in mysql? use sequences please
Sorry, forgot that your email
--- Eric E [EMAIL PROTECTED] wrote:
At the database level, you can assign creation and
other permissions to
users, but (AFAIK) you cannot deny users to a
database. However, you can
effectively control users' access to a particular
database by granting
or denying them access to a schema
On 12/2/2005 2:02 PM, Jaime Casanova wrote:
so the way to do it is create a trigger that record in a table the
number of rows...
Neither, because now you have to update one single row in that new
table, which causes a row exclusive lock. That is worse than an
exclusive lock on the original
Hello,
im using postgresql 8 under SLES 9 and RH 3.x - under
both OS i encountered the following problem :
Lets say i have a table, which has no reference to any
other table - and i create one entry for each day of
the year within this table (PK). During a day, i
update the values within that
On Fri, 2 Dec 2005, Harakiri wrote:
im using postgresql 8 under SLES 9 and RH 3.x - under
both OS i encountered the following problem :
Lets say i have a table, which has no reference to any
other table - and i create one entry for each day of
the year within this table (PK). During a day,
Richard Huxton wrote:
Gary Horton wrote:
...and in 7.3.4, this works just fine, with the shell consuming the
stdin and redirecting it to the createuser command, which
subsequently doesn't bother the user with the prompt (i.e. the
prompts are responded to automatically). However, this
Hi, thanks for the response ,
It's hard to say with just the above. Are you doing
other things in the
transactions besides a single update of that table
and/or is the order of
in each transaction i do basically the same stuff :
insert 1 row into table A, B, C (B and C have a
foreign key
Bruce Momjian pgman@candle.pha.pa.us writes:
There is a patch under consideration for 8.2 that would reduce the
storage requirement for numeric values by two bytes, but also reduce the
range of allowed numeric values to 508 digits. The current specified
maximum NUMERIC length is 1000
Roger Hand [EMAIL PROTECTED] writes:
I would be in favor of this change. What's the plan for anyone who
may be currently using 508 digits (if there is anyone!)?
You could store your data as text columns and do whatever arithmetic
you had in mind on the client side.
Francesco Formenti - TVBLOB S.r.l. [EMAIL PROTECTED] writes:
Tom Lane wrote:
Probably you have been careless about avoiding lock upgrade
situations.
Unfortunately, the first operation I do after the BEGIN declaration is
the LOCK TABLE in access exclusive mode, and is the only explicit lock
On 12/2/05, Toni Casueps [EMAIL PROTECTED] wrote:
I am making rules for a table and I want to know what values or variables
can I use apart from the new... and old... fields, for example I would
like to read the SQL query that the user wrote that caused this rule to
execute. Can this be done?
Gary Horton wrote:
Richard Huxton wrote:
Gary Horton wrote:
...and in 7.3.4, this works just fine, with the shell consuming the
stdin and redirecting it to the createuser command, which
subsequently doesn't bother the user with the prompt (i.e. the
prompts are responded to
elein [EMAIL PROTECTED] writes:
Is there any case when PostgreSQL adds an order by
to a view *definition* in 7.4?
I believe SELECT DISTINCT (or DISTINCT ON) will do that.
I have a vague recollection that GROUP BY might have done
so at one time as well, but it seems not to anymore.
Gary Horton [EMAIL PROTECTED] writes:
We're migrating from 7.3.4 to 8.1.0, and I'm seeing different behavior
with the createuser command. What we are wanting is to streamline our
product installs, to require minimal user interaction, so we basically
embed the password like this in our
Hi,
I'm trying to make sure I understand what I'm doing.
Where is new.* and old.* documented, as regards
using them as arguments to functions called from
rules? If it's not documented then can I rely
on this syntax continuing to work?
(It's tough searching on these strings. :-)
TIA
Karl
Is it possible to access backup and restore functionality
from SQL or Java? I am attempting to allow some this functionality from a
webapp.
The best I have so far is the following Java code.
Runtime runtime = Runtime.getRuntime();
String[] cmd = { cmd,
/c,
Hi,
I messed up and updated my beta3 to 8.1 and didn't realize a initdb was
required.
Is there anyway I can get at the data? It's on Gentoo and the
/var/lib/postgresql/data dir is still intact.
I tried to install beta4 but got the this error:
FATAL: database files are incompatible with
On Fri, 2005-12-02 at 16:03 -0600, Tony Caduto wrote:
Hi,
I messed up and updated my beta3 to 8.1 and didn't realize a initdb was
required.
Is there anyway I can get at the data? It's on Gentoo and the
/var/lib/postgresql/data dir is still intact.
Install beta3, backup, install 8.1
TODO?
%Add default_index_tablespace GUC and database parameter.
On Thu, Dec 01, 2005 at 11:48:28AM -0600, Kelly Burkhart wrote:
On 12/1/05, Alexander M. Pravking [EMAIL PROTECTED] wrote:
PostgreSQL 8.0 brought a great tablespaces feature. However, it's still
a real pain for one who wants
Jim C. Nasby [EMAIL PROTECTED] writes:
TODO?
%Add default_index_tablespace GUC and database parameter.
That was part of the original tablespace proposal and was rejected for
(what seemed at the time) good reasons. It'd be nice if this thread
betrayed any awareness whatsoever of the previous
On Thu, Dec 01, 2005 at 10:25:48AM -0200, William Leite Ara?jo wrote:
Hi, I'm trying alter a table schema on 'PostgreSQL 8.0.2 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-5)'.
On 8.1, by documentation, has the commant ALTER TABLE table SET
SCHEMA new_schema.
On Fri, Dec 02, 2005 at 06:06:25PM -0500, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
TODO?
%Add default_index_tablespace GUC and database parameter.
That was part of the original tablespace proposal and was rejected for
(what seemed at the time) good reasons. It'd be nice if
hi
i think i've encountered a bug in postgresql 8.1.
yet - i'm not reallty info submitting it to -bugs, as i have no way to
successfully redo it again.
basically
i have server, with dual opteron, 4g of memory, 2gb of swap.
everything working under centos 4.2.
...
what i say is that
On Thu, Dec 01, 2005 at 07:18:10PM -0800, Uwe C. Schroeder wrote:
Why not have something like the rowid in oracle?
http://www.postgresql.org/docs/8.1/interactive/datatype-oid.html, search
on ctid. And
http://www.postgresql.org/docs/8.1/interactive/ddl-system-columns.html.
From the 2nd URL:
ctid
Thanks, Tom, that explains
it. I'm using Richard Huxton's suggested workaround and it's
working just fine -
-gh
Tom Lane wrote:
Gary Horton [EMAIL PROTECTED] writes:
We're migrating from 7.3.4 to 8.1.0, and I'm seeing different behavior
with the createuser command. What we are
Jim C. Nasby [EMAIL PROTECTED] writes:
Maybe the docs should be changed to just say that you should never reuse
a ctid outside of the transaction you obtained the ctid in?
That's not a sufficient rule either: someone else could still delete or
update the row while your transaction runs. You'd
I wrote:
The actual effective limit on NUMERIC is presently 10^128K, which is
probably enough to count the femtoseconds remaining until the heat death
of the universe, and then multiply that by the number of elementary
particles therein ;-).
Should have done my research first. A little
On Fri, Dec 02, 2005 at 06:58:39PM -0500, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
Maybe the docs should be changed to just say that you should never reuse
a ctid outside of the transaction you obtained the ctid in?
That's not a sufficient rule either: someone else could
On Fri, Dec 02, 2005 at 06:58:39PM -0500, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
Maybe the docs should be changed to just say that you should never reuse
a ctid outside of the transaction you obtained the ctid in?
That's not a sufficient rule either: someone else could
Joshua D. Drake wrote
.
Install beta3, backup, install 8.1 restore.
That's what I wanted to do but I can't seem to find a beta3 tar.gz
anywhere, the downloads only go to beta4 :-(
Tony
---(end of broadcast)---
TIP 1: if
Tony Caduto [EMAIL PROTECTED] writes:
Install beta3, backup, install 8.1 restore.
That's what I wanted to do but I can't seem to find a beta3 tar.gz
anywhere, the downloads only go to beta4 :-(
If you don't find a tarball, you could pull the beta3 tag from CVS.
See
Tom Lane wrote:
If you don't find a tarball, you could pull the beta3 tag from CVS.
See http://developer.postgresql.org/docs/postgres/cvs.html
The tag you want is REL8_1_0BETA3 ... too lazy to check the cvs
man page, but I think you would add -r REL8_1_0BETA3 to the
normal cvs checkout command.
Marian Naghen [EMAIL PROTECTED] wrote
1. if a user set a write lock and then, for some reason (bad
connections, app chashes, etc), disconect from server without releasing,
what happened with the lock ? It will be still holding ?
When the connection is lost, server will release all its
Karl O. Pinc [EMAIL PROTECTED] schrieb:
Hi,
I'm trying to make sure I understand what I'm doing.
Where is new.* and old.* documented, as regards
using them as arguments to functions called from
rules? If it's not documented then can I rely
67 matches
Mail list logo