I have seen a steady progressive rise in the number of postgresql
related jobs and the quality of those jobs. Major companies are
apparently rolling out critical infrastructure on postgresql...Vonage
is one example:
On 9/21/06, Alvaro Herrera [EMAIL PROTECTED] wrote:
I wonder if we could replace the elephant logo with a female elephant
logo. That could work wonders ... among the elephant community at
least. Are there many elephants among decision makers?
our elephant isn't female? that changes
On 10/4/06, Guy Rouillier [EMAIL PROTECTED] wrote:
TIJod wrote:
I need to store a large number of images in a
PostgreSQL database. In my application, this
represents a few hundreds of thousands of images. The
size of each image is about 100-200 Ko. There is a
large turnover in my database,
On 10/5/06, Alexander Staubo [EMAIL PROTECTED] wrote:
On Oct 5, 2006, at 16:18 , Merlin Moncure wrote:
i'm wondering if anybody has ever attempted to manage large
collections of binary objects inside the database and has advice here.
We have a production system containing 10,000 images (JPEG
On 10/5/06, Jean-Christophe Roux [EMAIL PROTECTED] wrote:
Why would I set a bytea column (containing picures) as a primary key?
Because I want to be sure that the same image is inserted only once (that
requirement comes from a real project) and using a primary key for that
purpose makes sense
On 10/8/06, Jean-Gerard Pailloncy [EMAIL PROTECTED] wrote:
I want to create a function in PL/SQL as
CREATE OR REPLACE FUNCTION f_do (text, double precision[]) RETURNS
double precision AS '
DECLARE
f text := $1;
p double precision[] := $2;
res double precision;
BEGIN
SELECT
On 10/9/06, Michael Fuhr [EMAIL PROTECTED] wrote:
On Sun, Oct 08, 2006 at 05:49:11PM +0200, Jean-Gerard Pailloncy wrote:
I try EXECUTE f || ' ( ' || p || ' );' INTO res
But is does not work too.
There is no function to convert double precision[] to text.
You could use the types' input and
On 10/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I am writing a plpgsql (PostgreSQL 8.x) trigger function that should do
something on a number of records. The records are in a very simple table
with two columns - 'parent_id' and 'child_id'. A 'child' can be as well
a 'parent' to one or
On 10/7/06, Tomi NA [EMAIL PROTECTED] wrote:
I was just reading http://www.opencrx.org/faq.htm where RDBMS engines
are one of the questions and see pgsql bashed sentence after sentence.
Can anyone offer any insight as to weather it's fact or FUD?
FUD
postgresql in particular is an enormous
On 10/10/06, Jonathan Greenberg [EMAIL PROTECTED] wrote:
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
functions are found someplace else:
1) How do I skip an arbitrary # of header lines
On 10/10/06, Arnaud Lesauvage [EMAIL PROTECTED] wrote:
Hi List !
I need to add a column to a view, which would contain an automatically
generated sequence.
An automatic row numbering would do the trick (I only need unique
numbers, that's all), but I don't even know how to achieve this.
Does
http://www.zabbix.com/manual/v1.1/install.php
in section PostgreSQL vs MySQL :
[quoting]
Regarding the choice between PostgreSQL and MySQL, MySQL is
recommended for several reasons:
* MySQL is faster
recent benchmarks using ZABBIX clearly show that PostgreSQL
(7.1.x) is at least 10
On 10/10/06, Joshua D. Drake [EMAIL PROTECTED] wrote:
Merlin Moncure wrote:
http://www.zabbix.com/manual/v1.1/install.php
in section PostgreSQL vs MySQL :
Well they may be right that far back. But 7.1 is years and years old.
Joshua D. Drake
no excuse. that would be like postgresql
On 10/10/06, Peter Eisentraut [EMAIL PROTECTED] wrote:
Merlin Moncure wrote:
http://www.zabbix.com/manual/v1.1/install.php
in section PostgreSQL vs MySQL :
[quoting]
Regarding the choice between PostgreSQL and MySQL, MySQL is
recommended for several reasons:
I don't see any fear
On 10/11/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I think you should have a look at the ltree contrib package. It
implements tree-like structures, and probably makes your problem much
simpler.
I have never used contrib modules with PostgreSQL - are they easy to
handle - I mean,
On 10/11/06, Uwe C. Schroeder [EMAIL PROTECTED] wrote:
Well, SELECT * is only evil if your application relies on a specific column
order to function. The moment you change the table layout and you're using
select * your application will cease functioning.
My app uses tons of select *, but then I
I got the error mesage,
ERROR: could not find relation 19693 among query result relations,
from a strange interaction between inser, foreign keys and a udf.
After a but of trial and error, I came up with a test case:
create or replace function explode_array(in_array anyarray) returns
setof
On 10/12/06, Jeff Davis [EMAIL PROTECTED] wrote:
assumed column ordering is the real enemy. Here is another place
where select * is imo better style than non select *:
select q.*, bar from
(
select a, b,c from foo
) q;
What is bar?
bar is somthing else, a constant, field from
On 11 Oct 2006 07:54:52 -0700, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hello,
I'm author and maintainer of ZABBIX and the manual. I would like to add
some comments to the thread.
just so you know, I brought this up after taking a look at the zabbix
software, which is in my opinion very
On 10/10/06, adam lawrence [EMAIL PROTECTED] wrote:
But now I need to loop through the whole array, not just the one element. I
want to do something like:
FOR j in LOOP
FOR i IN array_lower(arrayvar,1) .. array_upper(arrayvar,1) LOOP
currentvalue:=arrayvar[j][i];
RAISE NOTICE
On 10/9/06, Christian Kasprowicz [EMAIL PROTECTED] wrote:
PROCEDURE MyProcedure(Value1 int, Value2 text, Value3 varchar(30))
BEGIN
---check if something is valid
---compute something
---store values I got via THIS query and put them in table A, B and C
---see wether everything is ok
On 10/12/06, Marco Serantoni [EMAIL PROTECTED] wrote:
I'm evaluating of use postgresql but for local law requirements is
needed for the access of some kind of data (sensitive) a log of the
accesses (Auditing) is a feature available in many databases but i've
seen that lacks in PostgreSQL,
On 10/12/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote:
When I start PostgreSQL service, the below error message is displayed and
finally service didn't started.
The PostgreSQL Database Server 8.0 service of a local
On 10/13/06, Ron Johnson [EMAIL PROTECTED] wrote:
Hi,
I've gotten preliminary approval to buy a server and load a *lot* of
data into it. One table will eventually have 4.5Bn 330 bytes rows,
the other 9Bn 300 byte rows. Other will only have a billion rows.
They are easily partitioned by
On 10/13/06, Jean-Christophe Roux [EMAIL PROTECTED] wrote:
Thanks for the ctid trick. The code below worked fine
for rec in select * from fromemail_trades loop
update fromemail_trades set recordid = row where ctid = rec.ctid;
row := row -1;
end loop;
The first line is a
On 10/13/06, Roman Neuhauser [EMAIL PROTECTED] wrote:
# [EMAIL PROTECTED] / 2006-10-10 14:16:19 -0400:
FUD from another open source project is really poor form, particulary
when not in competing segements where a little bit of competitive
rivalry is expected.
OMG WTF what FUD???
please
On 10/13/06, Tom Lane [EMAIL PROTECTED] wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Is that really true? In theory block n+1 could be half a revolution
after block n, allowing you to commit two transactions per revolution.
Not relevant, unless the prior transaction happened to end
On 10/13/06, AgentM [EMAIL PROTECTED] wrote:
No to mention if you are *that* concerned you could buy a generator
for
500 bucks that will keep the machine alive if you absolutely have to.
There is nothing wrong with write back cache as long as you have the
infrastructure to support it.
Why
On 10/14/06, Chris Mair [EMAIL PROTECTED] wrote:
Ok,
I did some tests at last on this using the above 3 suggestions.
I ran on 8.1.4 on Linux with fsync=off and did 300k updates bundled
into 100 updates / 1 transaction (100 turned out to be a sweeter
spot than 1000).
My postgresql 'magic
On 10/14/06, Chris Mair [EMAIL PROTECTED] wrote:
The interesting part is the graph that shows updates / sec real time
vs. running total of updates:
http://www.1006.org/misc/20061014_pgupdates_bench/results.png
one small thing: the variances inside the trendline are caused by
using integer
On 10/16/06, Alban Hertroys [EMAIL PROTECTED] wrote:
Merlin Moncure wrote:
for server side browsing use cursors or a hybrid pl/pgqsl loop. for
client side, browse fetching relative to the last key:
select * from foo where p p1 order by p limit k;
This does require some way for the client
On 10/18/06, Martijn van Oosterhout kleptog@svana.org wrote:
Binary may be slightly faster because the datum parsing can be
partially skipped, but that's hardly much benefit over a text copy.
I tested binary quite a bit and only found it to be a win if moving
blobs in and out of the database.
On 10/18/06, Ilja Golshtein [EMAIL PROTECTED] wrote:
I've tried to play with batches and with peculiar constructions
like INSERT (SELECT .. UNION ALL SELECT ..) to improve performance, but not
satisfied with the result I've got.
postgresql 8.2 (beta) supports the 'multiple insert' syntax, so
On 10/18/06, Jan Harders [EMAIL PROTECTED] wrote:
and, as guessed, takes forever. tried to ANALYZE the table but no change.
Anyone 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
On 10/18/06, Najib Abi Fadel [EMAIL PROTECTED] wrote:
Hi,
i need to move my postgres users with their passwords from one postgres
version (7.3) to a newer one (8.1) .
Is there an automatic way to do that without having to recreate the users
with their passwords ??
did you try pg_dumpall?
On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote:
I tested binary quite a bit and only found it to be a win if moving
blobs in and out of the database. On 'normal' tables of mixed fields
types of small size, it can actually be slower. Binary is a bit
faster for native types and bytea, and
On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 09:47, Merlin Moncure wrote:
On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote:
I tested binary quite a bit and only found it to be a win if moving
blobs in and out of the database
On 10/20/06, Jean-Christophe Roux [EMAIL PROTECTED] wrote:
Hello,
I have a table like this:
create table dummy (value integer primary key);
and I insert a row like this
insert into dummy values(0);
then I want to insert three rows:
insert into dummy values(0);
insert into dummy values(1);
insert
On 10/20/06, John Sidney-Woollett [EMAIL PROTECTED] wrote:
We're looking to upgrade from 7.4 - should we go to 8.1.5 or 8.2?
We have two databases; 7.4.6 and 7.4.11 in a master slave config using
Slony. Both databases use the C locale with UTF-8 encoding on unix.
We've dumped and loaded the
My previous employer contacted me today. Apparently they are having
an increasing frequency of occurances where they disocover violations
of the primary key constraint not being caught by the database. This
system is an ISAM emulation system, and it relies heavily on the
database throwing
On 10/27/06, Alvaro Herrera [EMAIL PROTECTED] wrote:
Do they vacuum enough? I have seen problems with PostgreSQL (albeit not
since 7.3) where a unique constraint would not enforce because of index
bloat.
Huh?? This would qualify as a serious bug. Failure to vacuum should
bring performance
On 10/27/06, J S B [EMAIL PROTECTED] wrote:
Can I have a function (language sql) returning SETOF more than one table?
Thanks,
Jas
no, but you can return a record of refcursors. note this is plpgsql.
if you are willing to bend on the language, you will find refcursors
to be pretty cool, you
On 10/31/06, Adam [EMAIL PROTECTED] wrote:
I recently saw a Hard Disk Drive that is really 4GB of RAM with and SATA
1.5Gb/s serial interface. It's basically a hard disk drive that uses RAM.
It also has a battery backup, so if you loose power, you don't loose your
data.
Has anyone tried using
On 10/31/06, Alan Hodgson [EMAIL PROTECTED] wrote:
On Tuesday 31 October 2006 11:48, Merlin Moncure [EMAIL PROTECTED]
wrote:
you are talking about the gigabyte i-ram. in the database world, you
can achieve same thing (actually better) by sticking those ram sticks
directly on the motherboard
On 10/31/06, Devrim GUNDUZ [EMAIL PROTECTED] wrote:
Hi,
On Tue, 2006-10-31 at 09:31 -0800, Richard Broersma Jr wrote:
I heard that reiser4 is not yet stable. And that there is a chance
that it wont be since its author is in detention.
Here are the links:
On 10/31/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
How widespread is the use of PostgreSQL on Solaris? I am beginning to sense
that community support is not currently very strong on this platform, and that
pgsql may not be the best candidate for my current project -- installing LXR on
a
On 11/3/06, Magnus Hagander [EMAIL PROTECTED] wrote:
Is there any way to count how many hits I got in a cursor
in PL/pgsql?
I have a function that will window through the result of
a (large)
query based on two parameters, but I also want to return
the number of
hits to the client.
On 11/3/06, Richard Troy [EMAIL PROTECTED] wrote:
On Fri, 3 Nov 2006, Merlin Moncure wrote:
I can deal with materializing the resultset, but I want to get away from
the loop-a-thousand-times-doing-plus-one...
i dont think its possible. note that you can make a refcursor inside
your
On 11/6/06, CSN [EMAIL PROTECTED] wrote:
Anybody know of a script that dumps all databases into corresponding dump
files, e.g.
$ ./dump
template0 - template0.sql
template1 - template1.sql
db1 - db1.sql
db2 - db2.sql
...
Also, would this approach add up to equal the output of pg_dumpall, or
On 11/6/06, Matthew Peter [EMAIL PROTECTED] wrote:
I have DB1 and DB2 pg_databases... I then have a function in DB2 that wants
some results from DB1, is it possible to query another db? Like how \! lets
you hit the command line... but I need it in plpgsql if possible.
Also, I know functions
On 11/6/06, Richard Broersma Jr [EMAIL PROTECTED] wrote:
check out dblink contrib module for starters. Maybe take a look at
pl/sh, which looks pretty neat.
Is there really such a thing as PL/SH? or are you refering to piping sql
queries into psql?
http://plsh.projects.postgresql.org/
It
On 11/6/06, Just Someone [EMAIL PROTECTED] wrote:
I have a database with multiple schemas all with the same structure
(but of course different data...).
I want to create a view that will be created in a shared schema, and
when executed will be executed against the current schema. Whenever I
try
On 11/6/06, Alain Roger [EMAIL PROTECTED] wrote:
Hi,
Finally, i've come to the following solution for my stored procedure :
---
-- Function: SP_U_001(TypeOfArticle varchar)
-- DROP FUNCTION SP_U_001(TypeOfArticle varchar);
CREATE OR REPLACE FUNCTION
On 11/7/06, Alain Roger [EMAIL PROTECTED] wrote:
Hi,
I' still with my stored procedure :
-- Function: SP_U_001(typeofarticle varchar)
-- DROP FUNCTION SP_U_001(typeofarticle varchar);
CREATE OR REPLACE FUNCTION SP_U_001(IN typeofarticles VARCHAR)
RETURNS SETOF active_articles AS
$BODY$
On 11/8/06, novnov [EMAIL PROTECTED] wrote:
I'm new to pgsql, mostly coming from MSSQL. It sounds like it's simplest to
keep field names lowercase with pgsql, so I will have to change some habits
I've developed over the years. I would like to glean whatever collective
wisdom I can here from
On 11/9/06, Richard Ollier [EMAIL PROTECTED] wrote:
Hello,
For a project I have a table containing products and flags.
The columns of this table are of 2 kinds :
- Not null data (id, column1, column2)
- Flags (100 different flags set to 1 or 0)
Over the time the number of flag will increase
On 11/10/06, Sandro Dentella [EMAIL PROTECTED] wrote:
Do I understad correctly that i cannot point a Foreign Key to a view? Which
is the rationale of this?
Blame the sql standard. Foreign keys are required to reference a
table with a unique constraint, and you can't add a unique constraint
to
On 11/11/06, novnov [EMAIL PROTECTED] wrote:
I agree with what you say. And I'd still be interesting in hearing of first
hand experience with the speed of the two databases from someone who is
'good' at both. The article commentor was obviously not a pgsql expert. I've
heard recently that pgsql
On 11/13/06, Igor Shevchenko [EMAIL PROTECTED] wrote:
Hi All,
I've got a problem w/ one of pgsql installations. It can't start:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
PANIC: failed to re-find parent key in 23724
Aborted
This is PostgreSQL 8.1.5 compiled from
On 11/22/06, John McCawley [EMAIL PROTECTED] wrote:
I'm not really sure what switching development platforms for the tool
would buy me. Are you saying that the wire-protocol used by vb.net and
C# etc. is substantially faster than what is available in VB? Regarding
no, the wire protocols are
On 11/23/06, Gopal [EMAIL PROTECTED] wrote:
I have a postgres installation thats running under 70-80% CPU usage while
an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
i somehow doubt ms sql server is 35x faster than postgresql in
production environments, even on
On 11/25/06, Ritesh Nadhani [EMAIL PROTECTED] wrote:
Hello all
Let me introduce myself first. I am the ex-lead developer of SQLyog
(one of the most popular GUI for MySQL which is Windows only and runs
on Linux through WINE, more info at http://www.webyog.com).
===
New Project: wxWidgets
On 11/27/06, Sim Zacks [EMAIL PROTECTED] wrote:
I am buying a new gentoo server for postgresql and I was wondering if a 64 bit
CPU would make any
difference in performance. I am not planning on using 64 bit integers.
a 64 bit server will allow the computer to use more memory. This can
be a
We are getting a backend crash after issueing a load command. It's
pretty easy to recreate -- so easy that I'm not sure that there is
something being overlooked. This is on pg 8.2 roughly two weeks old.
Basic m.o. is:
1. create pic .so
2. load .so and call a function in it (from psql).
3.
On 11/28/06, Olexandr Melnyk [EMAIL PROTECTED] wrote:
2006/11/28, Tony Caduto [EMAIL PROTECTED]:
Mono 1.2 only fully supports .net 1.1 (for winforms)
Yes. But it already supports most of the .NET 2.0 features (not talking of
WinForms here) including the ones metioned above and has a C# 2.0
On 11/28/06, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
We are getting a backend crash after issueing a load command.
No crash from your example here (on Fedora Core 5). What platform and
gcc are you using exactly? Can you provide a stack trace from the crash
On 11/28/06, Tom Lane [EMAIL PROTECTED] wrote:
Martijn van Oosterhout kleptog@svana.org writes:
On Tue, Nov 28, 2006 at 03:23:36PM -0500, Tom Lane wrote:
I'd suggest putting together a simple stand-alone test case and filing
a bug report against glibc.
How can glibc do anything about this?
On 11/28/06, Tony Caduto [EMAIL PROTECTED] wrote:
Thomas Kellerer wrote:
And who cares if my bytecode knows something about Generics as long as
the application runs at a good speed?
I totally agree about generics, nice to have but not really needed.
I dont like generics as much as c++
On 11/29/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see
On 11/28/06, Tom Lane [EMAIL PROTECTED] wrote:
This is at variance with what Merlin reported --- so I'm asking again
just what platform he's on. He might want to strace cp to see whether
it's doing an unlink or not in his scenario.
this is centos 32 bit.
[EMAIL PROTECTED] esilo]# uname -a
On 11/29/06, Bernd Helmle [EMAIL PROTECTED] wrote:
no, queries using * are expanded when the plan is created. for views,
the plan is created when you create the view (also the original query
string to create the view is not stored). however, you could however
create a function that returns
On 11/30/06, John McCawley [EMAIL PROTECTED] wrote:
I can't speak for wxPython etc., but regarding using QT from C++, your
speed of development depends on your C++ skills. I wrote a
full-featured Point of Sale system in Visual Basic that has been in
active use for about 4 years. The original
On 12/1/06, John DeSoi [EMAIL PROTECTED] wrote:
On Dec 1, 2006, at 12:36 PM, Antonios Katsikadamos wrote:
Hi all. I have a big .sql file written in postgres and i was
wondering if someone knows a tool to produce documentation from
postgres.
http://www.rbt.ca/autodoc/
although it's a
On 7 Dec 2006 14:02:53 -0800, BigSmoke [EMAIL PROTECTED] wrote:
I'm facing a particular task for which I need any procedural language
but PL/PgSQL. I can't use PL/PgSQL because it doesn't allow me to use
local variables such as new and old from a dynamic command.
could you clarify what you are
On 12/8/06, Joshua D. Drake [EMAIL PROTECTED] wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
much a
On 12/12/06, Andrew Chernow [EMAIL PROTECTED] wrote:
Our Company:
eSilo is a privately held Storage Service Provider, providing offsite
backup and storage management solutions to businesses of all sizes.
eSilo built its backup technology in house and continues to expand and
innovate. For more
On 12/13/06, Kevin Murphy [EMAIL PROTECTED] wrote:
I'd like to have a function that acts as a row filter (that can
optionally expand each row into multiple rows), but I don't know how to
wangle this such that the output is not enclosed in parentheses, i.e.
what I'm getting now is a single column
On 12/4/06, Bob Pawley [EMAIL PROTECTED] wrote:
Your missing the point.
I am creating a design system for industrial control.
The control devices need to be numbered. The numbers need to be sequential.
If the user deletes a device the numbers need to regenerate to again become
sequential and
On 12/14/06, Scott Marlowe [EMAIL PROTECTED] wrote:
On Thu, 2006-12-14 at 11:28, dev wrote:
Hello friends,
we have some strange problem, postmaster (pg 8.1 /win32)
suddenly shutdown because of no reason.
The interesting thing is that this occurs always at
almost same time
On 1/6/07, Jorge Godoy [EMAIL PROTECTED] wrote:
Andrew Chernow [EMAIL PROTECTED] writes:
I mean, how do you handle integrity with data
outside the database?
You don't, the file system handles integrity of the stored data. Although,
one must careful to avoid db and fs orphans. Meaning, a
On 1/9/07, Jeanna Geier [EMAIL PROTECTED] wrote:
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the
On 1/10/07, Dimitri Fontaine [EMAIL PROTECTED] wrote:
Hi,
Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a écrit:
I am working on a project where we are converting from MySQL to
Postgres. I figured the easiest way would be to export the MySQL data
as CSV.
If you are using pg 8.2+,
I am looking into using pg_standby (v3) in a warm standby system. I'm
going to double check it, but same machine replication seemed to work
ok. When I tried to do remote server log shipping however, I had some
issues.
Initial setup and launch is working ok, my archive command is:
'test ! -f
On 1/11/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Merlin Moncure wrote:
On 1/10/07, Dimitri Fontaine [EMAIL PROTECTED] wrote:
Hi,
Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a ?crit:
I am working on a project where we are converting from MySQL to
Postgres. I figured
On 1/16/07, richard lavoie [EMAIL PROTECTED] wrote:
Hi!
I'm not sure about the English terminology for that so I'm sorry if I made a
mistake on the subject and on this message.
I've a table with 50 colums. I want to copy a certain row using PL and change
only 2 values. The way to do it with
On 1/17/07, Richard Huxton dev@archonet.com wrote:
Toni Casueps wrote:
I have a set of tables with one-to-many relationships between them:
T1 -- T2 -- T3 -- T4
I need to copy some rows of these tables to another set of tables which
have the same fields.
There's no shortcut.
BEGIN;
On 1/19/07, Guy Fraser [EMAIL PROTECTED] wrote:
I feel that all @en25.com and @enterprisedb.com should be
considered for banning from the PostgreSQL mailing lists without
a better apology than has been given to date:
Thats a bit harsh IMO. Many of the enterprisedb people are active
On 1/18/07, Scott Ribe [EMAIL PROTECTED] wrote:
Is there a way to force a flush of all cached plans? Particularly, to force
re-evaluation of immutable stored procedures? Don't worry, it's a testing
development thing, not something I want to do during production ;-)
Also, somebody correct me
On 1/19/07, Garth Keesler [EMAIL PROTECTED] wrote:
I have a primary key made up of two varchar(128) columns, typically less
than 16 chars each. Concatenating the two columns would still be unique.
Would it make sense to concat the two columns, using a unique separator
like '~' and index on that
On 1/19/07, Scott Ribe [EMAIL PROTECTED] wrote:
Also, somebody correct me if I'm off my rocker here, but immutable
procedures are re-evaluated for each execution...they are just folded
into a constant during plan phase.
You would need to actually create an immutable function in order to test
On 19 Jan 2007 12:12:34 -0800, Karen Hill [EMAIL PROTECTED] wrote:
Alan Hodgson wrote:
On Thursday 18 January 2007 15:54, Steve Atkins [EMAIL PROTECTED] wrote:
Anyone else get spam from EnterpriseDB today, talking about
Postgresql Support Services?
yep. You really would think that even
On 1/23/07, Erick Papadakis [EMAIL PROTECTED] wrote:
Doesn't work:
- psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
- psql -U postgres -W
psql: FATAL: Ident authentication failed for user postgres
that is saying you need to have the password to login to
can anybody think of of a way to sneak these into dollar quoted
strings for substitution into create function?
would i would ideally like to do is (from inside psql shell)
\set foo 500
create function bar() returns int as
$$
declare
baz int default :foo;
[...]
that would eliminate the
On 1/23/07, Jasbinder Singh Bali [EMAIL PROTECTED] wrote:
I have created the following function :
CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text)
RETURNS bool AS
$BODY$
INSERT INTO tbl_xyz
(unmask_id,email_from)
VALUES ($1,$2)
$BODY$
LANGUAGE 'sql' VOLATILE;
when i try to
On 1/23/07, Martijn van Oosterhout kleptog@svana.org wrote:
On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote:
I am not speaking of exotic platforms like some obscure fork of POSIX
or something. I am speaking of Cpanel/WHM with Linux (CentOS in my
case) which must be hosted on
On 1/23/07, Laurent Manchon [EMAIL PROTECTED] wrote:
Hi,
I have a slow response of my PostgreSQL database 7.4 using this query below
on a table with 80 rows:
select count(*)from tbl;
PostgreSQL return result in 28 sec every time.
although MS-SQL return result in 0.02 sec every time.
On 24 Jan 2007 00:21:44 +0100, Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Merlin Moncure [EMAIL PROTECTED] writes:
can anybody think of of a way to sneak these into dollar quoted
strings for substitution into create function?
Can't you put the psql call
On 23 Jan 2007 13:05:41 -0800, slawosz [EMAIL PROTECTED] wrote:
Hello,
I have to relpace string
http://example.com/index.php?module=articlesid= to string /module/ in
whole column in table. How exacly use replace? I noob in postgres, I
think it could be quite easy.
Please, help
try replace
On 1/25/07, Weslee Bilodeau [EMAIL PROTECTED] wrote:
Where I work I'm in charge of more then a few PostgreSQL databases.
I understand why idle in transaction is bad, however I have some
developers who I'm having a real difficult time fully explaining to them
why its bad.
Oh, and by bad I mean
On 1/25/07, Neal Clark [EMAIL PROTECTED] wrote:
I was wondering...I currently have indexes on the primary key id and
foreign key id's for tables that resemble the following. Is this a
good idea/when would it benefit me? I don't want waste a lot of
unnecessary space on indexes.
CREATE TABLE
1 - 100 of 2101 matches
Mail list logo
