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
http://www.postgresql.org/docs/8.1/int
""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 it
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.
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 http://developer.post
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 posting/re
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
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
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 go
"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. Y
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
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:
cti
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 postmaster
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
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 SET
> SCHEMA ". Any solut
"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 previo
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 wh
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 re
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 serv
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",
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 <[
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
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 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
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
"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
"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.
Bruce Momjian 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 (NUMERIC(1000,0)), and the
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 k
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 doesn
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
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 spe
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 ta
--- 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
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
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 --
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 neces
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:
$POSTGRESQL_HOME/
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 wa
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,
El
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
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 UP
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 s
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 broadcast)-
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
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
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 p
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 those
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
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 i
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 t
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
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
"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
"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 stor
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 spaw
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 8.
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 definition
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
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 fiel
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 act
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 labe
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 w
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
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
h
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
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 pre
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, T
67 matches
Mail list logo
