> Any help in getting function argument names is appreciated. Thank you
take a look at pg_catalog.pg_get_function_arguments(oid)
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pg
Hi Dmytrii,
just as short idea, put "fsync = off" in your postgres.conf. That turns off
that after a commit data is forcilby written to disk - if the database crashes
there might be dataloss.
Von meinem iPhone gesendet
Am 23.02.2012 um 06:13 schrieb Dmytrii Nagirniak :
> Hi guys,
>
> I wonde
ven the fastest
DDR3-2133 has cycle times of 4ns.
I have seen a database monster in action - 43 trillion (academic)
transactions per day, but that's only 5*10^8 transactions per second,
under a quarter of 2^31 per second.
So, I can't answer your question - but you triggered my curiosity :-
c.media_media_id_seq | 8192 bytes
public.vmedia | 0 bytes
public.vmedia2| 0 bytes
(15 rows)
There is a difference of about 163 GB (which is from the toast of
public.media)
relation |size
-+----
pg_t
On Apr 20, 2009, at 7:35 PM, Alvaro Herrera wrote:
Jan Otto wrote:
If you have big toast tables you get wrong results with the query
suggested
at http://wiki.postgresql.org/wiki/Disk_Usage because it takes the
toasted
values not into account.
Now a fixed query which gets the sizes of the
Hi,
I have a problem of plpgsql usage. When I iterate through dynamic query, like
this:
FOR my_/record/ IN EXECUTE /text_expression/ LOOP
/statements/
END LOOP;
I am not able to construct expression, which can get value for each 'item' of
my_record, something like my_record[3] or get_item(my
I think that sql-functions may serve as parametrized views for you...
http://www.postgresql.org/docs/8.0/static/xfunc-sql.html
Cristian Prieto wrote:
I want to create a view or a sp which returns NULL if nothing is found
and a recordset if the user is found
I wrote something like:
CREATE sp_ge
hanks a lot for your help...
- Original Message - From: "Jan Poslusny"
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 23, 2005 6:44 AM
Subject: Re: [GENERAL] Help with a very newbie question...
I think that sql-functions m
On 2/6/2005 4:31 PM, Greg Stark wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
No, Peter.
Posting a vulnerability on a public mailing list "before" there is a known fix
for it means that you put everyone who has that vulnerability into jeopardy.
Vulnerabilities are a special breed
forwarding with compression. Works quite well.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break th
nly a superuser, but one with usecatupd set to true as well.
Jan
Sincerely,
Joshua D. Drake
UPDATE pg_class SET reltriggers = 0 WHERE relname = 'ic'
I get:ERROR: permission denied for relation pg_class
I do that on my dev env. The only difference I saw beetween users is
that my DEV use
r and doing direct heap_ access.
So how does plperl manage that?
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break t
Hi
Is possible use SELECT NUM_ROWS, a, b, c FROM blabla WHERE x =id; I mean
it's much more faster than
SELECT a, b, c FROM blabla WHERE x =id; and then
SELECT count(*) FROM blabla WHERE x =id;
John
---(end of broadcast)---
TIP 6: Have you searc
ROTECTED]>
wrote:
On May 18, 2005, at 3:07 AM, Jan Sunavec wrote:
Hi
Is possible use SELECT NUM_ROWS, a, b, c FROM blabla WHERE x =id; I
mean it's much more faster than
SELECT a, b, c FROM blabla WHERE x =id; and then
SELECT count(*) FROM blabla WHERE x =id;
Can you do this on the cl
e does the m'th root need to produce a finite
result, which I think is not guaranteed for arbitrary numbers.
I'm not advocating to do that, just saying it is theoretically possible
for a subset of possible inputs.
Jan
--
#==
Hi,
my colleague unfortunately ran some database dump in template1 on our
production server, pg7.3.5. Can we drop template1, dump template0 and
rebuild template1 from this dump? Or does exist some better way how to
repair template1 without any affect of living database instances?
Thanks,
paj
exes, etc.) and a second part that adds all the
constraints and indexes after the data is loaded.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's bre
CHECK constraint, I think
pg_dump should add the check constraints in the same manner as it does
triggers.
Bruce, do we have a TODO item for this?
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for b
well to a large number of tables.
Offhand I don't see an easy solution ... Jan, any ideas?
PostgreSQL itself doesn't work too well with tens of thousands of
tables. I don't see much of an easy solution either. The best workaround
I can offer is to move that horror-DB to a
On 7/28/2005 2:28 PM, Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
On 7/28/2005 2:03 PM, Tom Lane wrote:
Well, there's the problem --- the stats subsystem is designed in a way
that makes it rewrite its entire stats collection on every update.
That's clearly not going
lly is vacuum_tabstats which is probably
not executed often enough to be helpful.
Or maybe we could just filter the data on the reading side: ignore
anything the stats collector reports that doesn't correspond to a
live backend according to the PGPROC array.
Jan, any thoughts?
The reset call is s
g pl/pgsql added to template1
was done in no time. I only had to put a binary cvs executable there so
that I can develop somewhere else and deploy the changes via cvs update.
Jan
--
#==#
# It's easier to get forgiveness
s bee beaten to death
before, and was allways rejected for good reasons.
Which Postgres version is this? Everything pre-8.0 will suffer from
complete cache eviction on sequential scans of huge tables.
Have you thought about replicating the database to a "reporting sla
esponding "UPDATE" queries. If that is
the case, you shouldn't really have much of a problem. If not, I am not
even sure a synchronous replication system under MVCC can guarantee
consistency for you.
Jan
--
#==
h is Table_Column_fkey
instead of . This is stored in the pg_trigger.tgconstrname.
What you could do is to dump the database, edit the dump and restore it.
If it's a big database, you might want to take separate schema- and
data-dumps.
Jan
Constraint triggers execute functions to imp
On 9/27/2005 3:27 PM, Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
On 9/27/2005 12:20 AM, George Essig wrote:
We have a database with about 30 tables and some RI. The RI constraints,
however, were not named upon creation of the database 2-3 years ago and
now when we get an er
ready.
This does not work since there are some triggers on the contact table
and the trigger function selects the contact table and I don't want to
give the user access to that.
You want the trigger functions to be declared SECURITY DEFI
I have an AMD64 Fedora Core 3 server with Postgresql 8.0.1 that I want
to upgrade to the latest version. Since 8.0.2 incremented the libpq
version I can't install the official RPM packages. I found a
message[1] to this list which had a compat-postgresql-libs[2] RPM, but
that's an i686 package. Wher
that the pluggable storage engine design is an advantage ... I
think one storage engine that supports the full feature set is better.
Jan
CSN wrote:
Just so I know (and am armed ;) ), are there any new
comparable features in MySQL 5.0 that aren't in
PostgreSQL up to the forthcoming 8.1?
eally good position when talking to Oracle, MySQL will need
to brush up on the BDB support, and that pretty quick.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break th
On 10/8/2005 12:13 PM, Bruce Momjian wrote:
Jan Wieck wrote:
To have a really good position when talking to Oracle, MySQL will need
to brush up on the BDB support, and that pretty quick.
What about the patents InnoDB might hold? It would be easier to enforce
a patent based on the fact that
acle while Oracle has their hand on that
drain plug Innobase?
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being
On 10/3/2005 5:38 PM, Chris St Denis wrote:
Can anyone suggest good forums software to use with postgresql? I want to
integrate the forums users into my website's user base with a view.
phpBB2 ... works just fine including upgrade procedures.
Jan
I know of FudForums but it doesn&#
ion
in the MySQL fan club if Oracle releases the next GPL version of InnoDB
and MySQL AB announces that they ripped out InnoDB support and favor
something with half the feature set instead?
Jan
---
On Tue, Oct 11,
developers could join the project and see
that as a path to high salary jobs??
Wow, what a twisted way to look at it ... not entirely inaccurate, but
twisted :)
Oracle could even develop an exceptional interest in keeping PostgreSQL
alive as it's "future DB engineer forg
d be
reduced to a third party tool/application problem accessing the system
catalog in a database that has this new config option selected.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right.
nderstood
what that contract was about, maybe someone from MySQL AB can explain
that, but to my knowledge SAP AG did not transfer the copyright.
They could also go back to NuSphere, aka Multera, aka PeerDirect and ask
what happened to the Progress storage e
ot; :)"
You mean "their eventually someday to be patent".
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.
to the standard ... a feature I'm missing so far in all the proposals.
Jan
Note to implementor: In 'SELECT 1 as "Title"', the quoted string should
not be lowercased, even if you are lowercasing everything else...
You don't get to have that, I think, because th
On 10/17/2005 10:16 AM, Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
What is bad about leaving pg_catalog all lower case and expect everyone
to query the catalog quoted?
The fact that it will break every nontrivial client currently in
existence. Those quotes aren't t
On 10/19/2005 3:46 PM, Dann Corbit wrote:
Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
'Dann Corbit'?
I would.
wieck=# select 'Jan'::varchar(20) = 'Jan'::char(20);
?column?
--
t
(1 row)
wieck=# select '
They must have buried that "bow to COBOL" so deep in the code that they
had no choice but to abuse their power and stuff this cruft into the
standard.
Jan
--
#==#
# It's easier to get forgiveness for being w
teness sake; Because of lazy evaluation, that boils down to:
if (OLD.value IS NULL OR NEW.value IS NULL OR OLD.value <> NEW.value)
That would result in TRUE if both, OLD and NEW are NULL. Is that what
you intended?
Jan
The last part of the expression is only evaluated if both OLD.val
ren't really
looking for open source, they are looking for cheap or free. With the
control over InnoDB, Oracle has an influence on what XE is competing
against. Both offers compete with MS SQL Express as well, so they hit
On 11/1/2005 8:49 AM, Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
On 10/31/2005 1:14 PM, Chris Browne wrote:
The fact that it appears "a joke" to people wanting to deploy big
databases doesn't prevent it from taking a painful bite out of, oh,
say, certain vendo
s still slow.
Using REPLACE INTO at one place and creating duplicates on purpose in
another seems to make zero sense to me. Until one can explain the reason
for that to me, I claim that a UNIQUE constraint on such
data (what if we have a statement
that does a select deletefile('type', 'hash'); and then it needs to
roll back? answer: we're hosed). I'd be happy to hear any
suggestions for solutions to the above problems.
-jan-
--
Jan L. Peterson
<[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Is there a utility that could update/merge functions/views from a postgresql dump to an existing db?
Thank you...I supposed I'll try this one if it could suits my needs.It's really hard to maintain views and functions updates.On 10/11/06, A. Kretschmer
<[EMAIL PROTECTED]> wrote:
am Wed, dem 11.10.2006, um 7:37:11 -0300 mailte Jorge Godoy folgendes:> "Jan Cruz&quo
On 10/14/06, Jan Cruz <[EMAIL PROTECTED]> wrote:
Thank you...I supposed I'll try this one if it could suits my needs.It's really hard to maintain views and functions updates.I have downloaded and read the instruction for pgdiff but I am not familiar with aol_server and it's ki
ne got any ideas? I just don't understand why it's sorting the values
while the index should already be sorted...
Oh, btw, I'm on 7.4 (sarge stable version). Could this behaviour change if I
just upgrade to 8.1?
any input is appreciated - it's not a critical project but jus
host, this would obviously not
work, since the ssh tunnel and the postgres server cannot
listen on the same port.
I am not sure if the error message you are seeing is the same
one you would get when a connection is impossible. To me it
looks like a connection was initiated by the serv
I am looking for some documentation or info how to do this and how to deal
with such things.
Thanks
Jan Mura
[EMAIL PROTECTED]
Rather simple question, of which I'm not sure of the answer.
If I have a multiple column index, say:
Index index1 on tableA (foo,bar)
and I then:
Select * from "tableA" where foo =
Will index1 be used, or am I looking at a seqscan in all circumstanc
If I have an index that's composed of 2 columns:
Index index1 on tableA (foo,bar)
and I then:
Select cola, colb from tableA where foo=
Will index1 still be used, or am I looking at a seqscan under all
circumstances in this case?
TIA
-jan m
---(end of broa
On 21 Jan 2007 at 15:11, Jim C. Nasby wrote:
> On Sun, Jan 21, 2007 at 12:27:41PM -0500, Jaime Casanova wrote:
> > On 1/21/07, mbneto <[EMAIL PROTECTED]> wrote:
> > >Hi,
> > >
> > >I have a dumpall file generated from a 8.0 version that I need to impor
On 22 Jan 2007 at 16:10, Sim Zacks wrote:
> How good is postgresql security?
> For example, If I have data that I do not anyone to see, including the
> programmer/dba, is it enough
> to change the password to the only user?
> If they have access to the raw files is there a
On 22 Jan 2007 at 10:15, Ron Johnson wrote:
> On 01/22/07 09:55, Jan Muszynski wrote:
> > On 22 Jan 2007 at 16:10, Sim Zacks wrote:
> >
> >> How good is postgresql security? For example, If I have data
> >> that I do not anyone to see, including the programmer
Hello,
I would like to ask for a hint for a good SQL textbook. I don't want just a
reference manual but real textbook with a theoretical background so I could
to design my databases following the general rules as normal forms and so
on.
I mean something on the net of course.
Thank you
Jan
y locked shared buffers you will have in
the system, with the locking processes currently not getting the CPU
because of their low priority.
Jan
Benjamin
Magnus Hagander wrote:
Most likely, you do not want to do this. You *can* do it, but you are
quite likely to suffer from priority
On 2/16/2007 4:56 PM, Benjamin Arai wrote:
Hi Jan,
That makes sense. Does that mean that a low-priority "road-block" can
cause a deadlock or just an very long one lock?
It doesn't cause any deadlock by itself. Although the longer one holds
one lock, before attempting to
connection pools
with pgpool, one for reading having many physical connections, each
shared for just a few clients, another having few physical connections
shared by all writers. That way you will have a limited number of
writers active at the same time.
Jan
Benjamin
Jan Wieck wrote:
On 2/16
On 2/16/2007 1:10 AM, Tom Lane wrote:
extra points, use *only one* test case. Perhaps this paper can be
described as "comparing an F-15 to a 747 on the basis of required
runway length".
Oh, this one wasn't about raw speed of trivial single table statements
like all the
serious DB consultant
would even bother testing anything using MyISAM any more. It is a table
handler only considered for "disposable data".
Jan
--
#==#
# It's easier to get forgiveness for being wrong than f
I found this thread (I'm posting here because I'm not subscribed to
Hackers)
http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg85241.html
which seems to be talking about this issue. I'm just wondering what the
current status on this is. Someone I know is getting this error -(I'm not
1
On 2 Mar 2007 at 16:33, [EMAIL PROTECTED] wrote:
> Quoting Bill Moran <[EMAIL PROTECTED]>:
>
> > In response to [EMAIL PROTECTED]:
> >> "Your local 'Administrators' group contains 'Authenticated Users'.
> >> This is a common configuration error that causes security issues. For this
> >> reason,
?
I know that I should keep base backup AND all wal logs after
pg_start_backup, but my question is NOT about safe archiving, but about
log shipping.
Jan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Thanks Alvaro
I checked out the files from: pgsql/src/pl/plperl/sql/ and
pgsql/src/pl/plperl/expected and compared the results
I still found a difference in 2 functions :
Function 1 - Expected:
CREATE OR REPLACE FUNCTION perl_spi_prepared(INTEGER) RETURN
Hello,
I am a little bit off Postgres but would like to know about some good
Oracle mailing lists.
I am looking something about backups and recovery things in Oracle I am not
familiar with
Thank you
Jan Mura
[EMAIL PROTECTED]
---(end of broadcast
Hello,
We're building database system with replication. Slony-I seems to be a quite
good solution for the replication, but beside the replication
(master-to-multiple slaves), we need load balancing aswell - multiple users
will access the database at the same time=multiple queries.
Is Slony-I ca
On 5/1/07, Jan Bilek <[EMAIL PROTECTED]> wrote:
Is Slony-I capable of load balancing and how to set it up? We searched
the
web and some people mentioned that Slony-I could do load balancing, but
haven't found how to make Slony-I to do it.
Slony does not do load balancing. Pe
Connect to PostgreSql as Postgres user (default database user):
psql yourdb -U Postgres
then you will be asked for password selected during the installation.
Hope this will help.
JB
- Original Message -
From: Suresh Nimbalkar
To: pgsql-general@postgresql.org
Sent: Tuesday, M
much info about it
pg docs. So, does any document describing detailed index usage or do you
have any personal recomendations when to use which index?
Thanks for you answers.
Regards,
Jan
---(end of broadcast)---
TIP 3: Have you checked our exte
"sometimes"? Unless i know how to use the indexes, then
they are useless for me - am i right?
Note: We are using gin with tsearch2 vectors, but here we had no choice -
tsearch2 works only with gin and gist.
Regards,
Jan
Am Montag, 7. Mai 2007 16:09 schrieb Jan Bilek:
I would need more in
et internal postgre variables
(like search_path etc.) from Java2 enviroment using JDBC?
Thanks for any hints.
Regards,
Jan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
Hi,
is there a way to invoke a trigger only if the current transaction is
committed?
The problem is that my trigger does some kind of logging outside the
database and therefore must not be invoked if the transaction is rolled
back.
Thanks in advance
Jan
---(end of
Hello,
I've got following problem:
I use this simple query:
select * from mytable where creation_time > (CURRENT_TIMESTAMP - interval '7
days');
---> it selects all rows from mytable, which were created before one week or
sooner (creation_time is column in mytable).
I would like to use this
Got it!
"Jan Bilek" <[EMAIL PROTECTED]> writes:
I would like to use this query in java PreparedStatement, where age of a
=
row would be one of its parameters:
PreparedStatement could look like this:
select * from mytable where creation_time > (CURRENT_TIMESTAMP - ?)
catalog, so when I manually removed Slony I had some
rogue rules floating around. PostgreSQL didn't know it needed to
drop the rules but it was being restricted from dropping the table
by unknown deps in pg_depend.
Yes, this is the ugly bit of catalog scrbbling Slony-I 1.0 does. We h
On 10/18/2004 12:49 AM, Ed L. wrote:
I *think* I'm seeing "vacuum analyze" queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?
Are you running Slon
c
spoil the reputation of our mailing lists.
If Eric doesn't care about windows, he can ignore discussions related to
it. If he doesn't want to see messages related to it, maybe he can show
his capabilities to RTFM by setting up appropriate procmail filters. Or
does thi
ilosophy is a little different. That is why we have
only one, tightly integrated and not very easy to replace storage engine.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let'
from the
Slony-I project leadership position in order to fully focus on the
multimaster replication project Afilias has decided to put forward.
Jan
On 10/21/2004 5:55 PM, Chris Browne wrote:
The Slony-I team is proud to present the 1.0.4 release of the most
advanced replication solution for the
On 10/22/2004 11:29 AM, Ed L. wrote:
Wow. First, thanks again for all your efforts, Jan. Second, I'm
disappointed to hear the slony author and lead developer is leaving the
slony leadership. When is that going to happen? And what does that mean
with respect to your future involveme
ll be easier to add this later instead of doing it right in the
initial design phase, but my way of solving problems is not the way
MySQL plans their features.
Jan
I appreciate any input you can provide.
Thanks,
JB
---(end of broadcast)---
TIP 1: subscri
upted files, as
those repair operations might introduce breakage of referential
integrity of your data.
Jan
Thank you.
Tim
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [
these will be reduced to hooks and APIs
that will be more general and open to discussion to provide the
infrastructure requited by the majority of replication extensions.
Jan
--
#==#
# It's easier to get forgiveness for b
On 10/25/2004 2:42 PM, Andrew Sullivan wrote:
On Mon, Oct 25, 2004 at 01:15:33PM -0400, Jan Wieck wrote:
On 10/25/2004 11:53 AM, [EMAIL PROTECTED] wrote:
>Is this true?
From a functional point of view, the two appear to do the same thing.
Well, except for one difference. InnoDB will allow
ger procedures for UPDATE/DELETE, or you can check inside the
trigger for which event it was actually fired and return NEW/OLD
accordingly.
Jan
end;
'
LANGUAGE 'plpgsql' VOLATILE;
~~
Any he
able for NEW is initialize to NULL and
returning NULL from a BEFORE trigger silently suppresses the operation
on the original row that it was fired for.
Jan
Anyway, setting the trigger AFTER DELETE works ok.
On Mon, 2004-10-25 at 15:56, Naeem Bari wrote:
Hi,
I am using postgres 7.4.5 on Redhat E
ain not work for the UPDATE case (not with the
same internal consequences though).
Jan
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
s, one for update and one for delete...
I would change the trigger to fire on "after" rather than before as Jan
Weick suggests, but does that mean that if the trigger fails, the
transaction would be committed anyways?
The variable TG_OP contains a string of 'INSERT', 'UPDATE
lore-phase into a design and develop according to that.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's bre
ps used to be very much on
the level of politeness and respect, our mailing lists reflect. If this
is what we can expect if we encourage more ISP's to carry our lists,
then I am strictly for "discouraging". Maybe our goal should not be to
make the PostgreSQL lists a
Tell me please, what is the problem?
Windows XP has some basic firewall functionality. Could it be that this
is blocking inbound access on the Guest side?
Jan
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
possibility.
A sequence and converting the blob identifier to int8 would be one ...
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's bre
On 11/16/2004 6:32 AM, Holger Klawitter wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A little bit OT, but:
is there a way of removing duplicate rows in a table without OIDs?
There is still the CTID.
Jan
Mit freundlichem Gruß / With kind regards
Holger Klawitter
- --
lists
ly
because of people with this attitude. And I don't consider it much of a
loss if we lose the "message" to these people.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right
utors that use newsgroups, the way major members of the
PostgreSQL community are treated here does IMHO more harm to the project
than any single NSP carrying any of there groups is worth.
Jan
--
#==#
# It's easier to get forgi
On 11/29/2004 11:53 PM, Gary L. Burnore wrote:
Stay out of my email.
This ia a PostgreSQL related topic discussed on PostgreSQL mailing lists
and you react like this to a mail from a PostgreSQL CORE team member?
Rethink your attitude.
Jan
At 11:50 PM 11/29/2004, you wrote:
On 11/23/2004 4:46
101 - 200 of 570 matches
Mail list logo
