Islam Hegazy wrote:
Hi all
I created a function that returns a set of records. This function returns an
integer and a float as the record fields. I have a problem in this function, it
truncates the output. e.g. 1342 is displayed as 134, 456.46 is displayed as
456. In other words, it displays
On 6/7/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
Hello,
Is anyone going to try for this? If not I can have our designer do it,
but I would prefer it be a community deal.
We are looking to have new signage for the shows that PostgreSQL
attends. The signage that we
Hi,
as I understood, when you create a table which inherits some other
table, the constraints and indexes do not go to the child table hence
you have to create a separate ones in there. That means you cannot
depend that you won't have duplicate IDs in both tables. Right?
BUT...what if child
David Gardner wrote:
As someone who would greatly benefit from this feature, is there
something I can do to help out in development/testing of this feature? I
have a test server I could install a cvs release of pgsql and know my
way around a makefile.
Hi David,
At the moment it's just a case
Sebastjan Trepca wrote:
Hi,
as I understood, when you create a table which inherits some other
table, the constraints and indexes do not go to the child table hence
you have to create a separate ones in there. That means you cannot
depend that you won't have duplicate IDs in both tables. Right?
Hi postgresql-listmembers,
for a backup-scenario I need to have access to the pgdata-directory as a
different shell-user, but postgresqul refuses to start if chmod is not
700 on the directory.
Is there a way to prevent postgres to check the data-dirs chmod 700 on
startup (and while running)
On fim, 2007-06-07 at 10:38 +0200, Johannes Konert wrote:
Hi postgresql-listmembers,
for a backup-scenario I need to have access to the pgdata-directory as a
different shell-user, but postgresqul refuses to start if chmod is not
700 on the directory.
Is there a way to prevent postgres to
use sudo in your backup scenario, or run you backup as postgres
Thanks for your quick reply.
Unfortunaltelly runing backup via sudo is not an option due to sercurity
issues and using postgres-user is not feasable because other data as
well is backuped where postgres-user should not have
Richard Huxton wrote:
I'm no guru myself...
Don't underestimate yourself, after all you found the code where it goes wrong
Looks OK to me, except you'll not get any error message on the last row
- the insert will be called after the fetch.
I do get an error message on the last row (assuming
Ragnar wrote:
are you planning a filesystem-level backup?
are you aware that you cannot just backup the postgres data directories
fro under a running server, and expect the
backup to be usable?
gnari
As war as I understood the docu of psql 8.2.4
i set the auto vacuum option to enable. but my database size(hard-disk
space) still increased from 420MB to 440MB in 8 hours. most of the
operations in this database are the Select query command, just few
of Update or Insert.
why it can be increased so strongly?
after i executed the command
I have been using postgres 7.0.3 (Solaris 2.9) for the past 4 years
without any major problems, until about a month ago. We are now
experiencing crashes on the backend (connection lost to backend) while
running queries (inserts, etc). Anyway I don't want to make this too
technical but I'd just
Thomas F. O'Connell tf ( at ) o ( dot ) ptimized ( dot ) com writes:
I'm dealing with a database where there are ~150,000 rows in
information_schema.tables. I just tried to do a \d, and it came back
with this:
ERROR: cache lookup failed for relation [oid]
Is this indicative of corruption,
Hello,
(sorry for my poor english)
It's my first post here, and my doubt is very simple (I guess). I have a
function to populate a table, into WHILE I have the follow piece of code:
--Jump Weekend
IF (SELECT TO_CHAR(CAST(PRODUCTION_DATE as date),'Day')) = 'Saturday' THEN
This is just an example isolating the problem.
Actual queries contain more tables and more joins and return
reasonable amount of data.
Performance of big indices however is appalling, with planner always
reverting to seqscan with default settings.
I tried to pre-filter the data as much as
Richard Huxton wrote:
PFC wrote:
NULL usually means unknown or not applicable
Andrew Sullivan wrote:
Aaaargh! No, it doesn't. It means NULL. Nothing else.
If it meant unknown or not applicable or anything else, then
SELECT * FROM nulltbl a, othernulltbl b
WHERE a.nullcol =
hie i am a newbie to Postgresql. I installed Postgresql using an rpm. my
problem is that when i issue the service postgresql start command the
database is failing to start. Where can i get the error logs for the
database so that i can see what is the problem. Is there a another way of
starting it
Dear all,
With the below transaction we got an out of memory error.
BEGIN;
ANALYZE referenceAuthorLnkTemp;
INSERT INTO referenceAuthor (author)
SELECT DISTINCT ON (author) author
FROM referenceAuthorLnkTemp;
ANALYZE referenceAuthor;
UPDATE referenceAuthorLnkTemp
SET
Hello everyone -
I'm moving from MySQL to Postgres and I am in a situation where I am
trying to use subselects properly.
I have a table of projects, users, and user_projects. The table
user_projects creates a many-to-many relationship between users and
projects.
I'm creating a select list on a
Is there any way of getting at the last time a table was analyzed (by
autovacuum) in 8.1 or is that only recorded (in pg_stat_*_tables) since 8.2?
TIA
Julian
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Hi there.
Is there any way of determining the actual structure of a record
variable? E. g. I've written a small script to do some calculations
over some fields with a dinamically generated query. It looks like this:
create function foo(text) returns void as
$$
declare
a_record record;
check under $PGHOME/data/pg_log directory.
Usually $PGHOME=/usr/local/pgsql if u have not changed this path during
installation
With Reagrds
Ashish...
- Original Message -
From: phillip
To: pgsql-general@postgresql.org
Sent: Thursday, June 07, 2007 2:21 PM
Subject:
[EMAIL PROTECTED] wrote:
I'm creating a select list on a web form for adding a new user to a
project. I want to select users from the user table, who aren't
already listed in the join table under that project.
Here's my select:
SELECT * FROM users
WHERE user_id $current_user_id
AND
take a look inside the rpm and see what it installed:
rpm -ql rpmname
On Thu, Jun 07, 2007 at 10:51:59AM +0200, phillip wrote:
hie i am a newbie to Postgresql. I installed Postgresql using an rpm. my
problem is that when i issue the service postgresql start command the
database is
Hello
it isn't possible in plpgsql. Try other plperl or plpython
Regards
Pavel Stehule
2007/6/6, Diego Sanchez [EMAIL PROTECTED]:
Hi there.
Is there any way of determining the actual structure of a record variable?
E. g. I've written a small script to do some calculations over some
ARTEAGA Jose wrote:
I have been using postgres 7.0.3 (Solaris 2.9) for the past 4 years
without any major problems, until about a month ago. We are now
experiencing crashes on the backend (connection lost to backend) while
running queries (inserts, etc). Anyway I don't want to make this too
Richard Huxton wrote:
ARTEAGA Jose wrote:
I have been using postgres 7.0.3 (Solaris 2.9) for the past 4 years
without any major problems, until about a month ago. We are now
experiencing crashes on the backend (connection lost to backend) while
running queries (inserts, etc). Anyway I don't
Hi,
I am very new to postgres. So, if I am asking stupid question please
forgive me. I installed the postgres, imported the required databases
and created the necessary users. When users login using psql, they are
required to supply the database name.
We are trying to access a postgres database
Lew [EMAIL PROTECTED] writes:
Where NULL differs is that (NULL = NULL) is FALSE, and (NULL != NULL) is
FALSE.
No, that's not true. NULL=NULL is NULL. And NULL!=NULL is NULL as well. Ie,
it's exactly as your table describes.
The confusion comes because WHERE clauses treat NULL the same as
On Thu, Jun 07, 2007 at 03:38:15PM +0200, Samatha Kottha wrote:
We are trying to access a postgres database using a data integration
tool. This data integration tool have options to specify the hostname,
port, userid, and passwd of a database. But there is no way to supply
the database name.
Alexander,
I tried to find the original vector graphics for the PostgreSQL
elephant logo, but couldn't find it anywhere. I think that's a
prerequisite. I would not mind having a stab at it.
www.pgfoundry.org/projects/graphics
look under docs, there are AI files.
--Josh
On Sun, Jun 03, 2007 at 11:29:07PM -0700, Sergei Shelukhin wrote:
I wonder what exactly makes index perform 100+ times slower than
seqscan - I mean even if it's perfromed on the HD which it should not
be given the index size, index and table are on the same HD and index
is smaller and also
Hi,
I have a table with one column as real[]. Now if I want to make cubes
out of each of
these arrays, is there a way in postgre I can do it. I guess cube
operator is not defined
for real[] but can I create cubes if the column was integer[]. If yes
please may I know
how.
Thanks
Abhang
On Sun, Jun 03, 2007 at 11:11:01PM -0300, Ranieri Mazili wrote:
Hello,
(sorry for my poor english)
It's my first post here, and my doubt is very simple (I guess). I have a
function to populate a table, into WHILE I have the follow piece of code:
To get a proper answer I think you're going
On Mon, Jun 04, 2007 at 04:15:12AM -0700, [EMAIL PROTECTED] wrote:
after i executed the command vaccumdb -f -z testdb, but the size
just decreased 1 or 2MB...
what's the problem?
vacuumdb -f does a FULL vacuum, which is blocking and compacts the
tables. If it only compacted 1 or 2 M, then
On Wed, Jun 06, 2007 at 02:40:08PM -0500, ARTEAGA Jose wrote:
I have been using postgres 7.0.3 (Solaris 2.9) for the past 4 years
without any major problems, until about a month ago. We are now
experiencing crashes on the backend (connection lost to backend) while
running queries (inserts,
On Jun 7, 2007, at 10:27 , ABHANG RANE wrote:
I have a table with one column as real[]. Now if I want to make
cubes out of each of
these arrays, is there a way in postgre I can do it. I guess cube
operator is not defined
for real[] but can I create cubes if the column was integer[]. If
Hi,
Check this out:
http://thread.gmane.org/gmane.comp.db.postgresql.bugs/14175
It's a thread that started on pgsql-bugs and that I later moved to
pgsql-patches and later pgsql-hackers (and pgsql-bugs wasn't copied).
The cool thing is that it kept the link properly, so you can see the
whole
Greetings,
I've got a PostgreSQL-8.1.x database on a Linux box. I have a need to
determine which rows in a specific table are less than 24 hours old.
I've tried (and failed) to do this with the age() function. From what
I can tell, age() only has granularity down to days, and seems to
assume
Hi,
I have never given postgres a password before, but one of my clients
put one on his postgres user - I suppose so he could use the postgres
user from phppgadmin (not my choice !).
But now I can't see how to get my backup scripts to work... can I put
the password for tools like pg_dumpall (or
Sorry
.pgpass
:-(
Anton
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Interesting issue --
I have usually solved this by adding a specific field to each table with a
default timestamp of NOW()...
When you:
CREATE TABLE tbl (
blah...
blah
create_dt TIMESTAMP NOT NULL DEFAULT NOW()
);
each and every record now has a timestamp of exactly when
Anton Melser wrote:
Hi,
I have never given postgres a password before, but one of my clients
put one on his postgres user - I suppose so he could use the postgres
user from phppgadmin (not my choice !).
But now I can't see how to get my backup scripts to work... can I put
the password for tools
Unfortunately, its too late now. The database (and its tables) have
been around for a while, so even if I added this column, it wouldn't
help me for the thousands of pre-existing rows. Thanks though.
On 6/7/07, codeWarrior [EMAIL PROTECTED] wrote:
Interesting issue --
I have usually solved
Can anyone suggest how one might be able to do this? I want to be able
to generate an 8 character random password for users in their password
field. Perhaps through the default setting of the field or a trigger
function. I found the following, but is there anything that can be used
on both Windows
Robert Fitzpatrick wrote:
Can anyone suggest how one might be able to do this? I want to be able
to generate an 8 character random password for users in their password
field. Perhaps through the default setting of the field or a trigger
function. I found the following, but is there anything
Robert Fitzpatrick wrote:
Can anyone suggest how one might be able to do this? I want to be able
to generate an 8 character random password for users in their password
field. Perhaps through the default setting of the field or a trigger
function. I found the following, but is there anything that
Lonni J Friedman wrote:
Unfortunately, its too late now. The database (and its tables) have
been around for a while, so even if I added this column, it wouldn't
help me for the thousands of pre-existing rows. Thanks though.
Please don't top-post.
Assuming that the majority of the
On Tue, 2007-06-05 at 16:51 -0400, Andrew Sullivan wrote:
On Tue, Jun 05, 2007 at 07:29:02PM +0100, Peter Childs wrote:
Unfortunately you still need to store them somewhere, and all systems can
be hacked.
Yes. I agree, in principle, that don't store them is the best
advice -- this is
Lonni J Friedman escribió:
Unfortunately, its too late now. The database (and its tables) have
been around for a while, so even if I added this column, it wouldn't
help me for the thousands of pre-existing rows. Thanks though.
The answer to your original question is you can't. That info
Lonni J Friedman wrote:
I have a need to
determine which rows in a specific table are less than 24 hours old.
I've tried (and failed) to do this with the age() function.
And on the suggestion of a timestamp column with DEFAULT NOW():
Unfortunately, its too late now. The database (and its
Guy Fraser wrote:
On Tue, 2007-06-05 at 16:51 -0400, Andrew Sullivan wrote:
Yes. I agree, in principle, that don't store them is the best
advice -- this is standard _Translucent Databases_ advice, too. For
the least-stealable data is the data you don't have.
But if there is a business
veejar [EMAIL PROTECTED] writes:
Hello!
I have such field in my table:
field1
---
1
2
3
4
5
I want to get such result from select:
'1,2,3,4,5' - join all values in field1 with ','
// result must be varchar.
No sense in writing your own func for this; the feature is
On Thu, 2007-06-07 at 09:44 +0100, Richard Huxton wrote:
Sebastjan Trepca wrote:
Hi,
as I understood, when you create a table which inherits some other
table, the constraints and indexes do not go to the child table hence
you have to create a separate ones in there. That means you
On Thu, 2007-06-07 at 12:57 +0200, Johannes Konert wrote:
use sudo in your backup scenario, or run you backup as postgres
Thanks for your quick reply.
Unfortunaltelly runing backup via sudo is not an option due to sercurity
issues and using postgres-user is not feasable because other
Johannes Konert wrote:
Ragnar wrote:
are you planning a filesystem-level backup?
As war as I understood the docu of psql 8.2.4
(http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
section 23.3.2) you can copy the files while postgres is running
(respecting
Does anyone have a trick to list all columns in a db ?
I need to audit a few dbs to make sure column table names are
adhering to our standard semantic syntax.
i figure there has to be an old pg-admin trick out there to display
a db like
%(tname)s . %(cname)
or some similar
George Pavlov wrote:
From: Tom Lane [mailto:[EMAIL PROTECTED]
George Pavlov [EMAIL PROTECTED] writes:
to 977ms! If I go the other way and SET STATISTICS 1 (or 0) I can bring
down the list to one entry (setting to 0 seems equivalent and still
keeps the one most common entry!?) and I will get
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
In those rare cases wouldn't it make more sense to just set
enable_seqscan to off; run query; set enable_seqscan to on;
1. these cases are not that rare (to me);
2. setting enable_seqscan (in JDBC, say) from the application makes the
whole
From: Tom Lane [mailto:[EMAIL PROTECTED]
George Pavlov [EMAIL PROTECTED] writes:
I am curious what could make the PA query to ignore the
index. What are
the specific stats that are being used to make this decision?
you don't have the column's statistics target set high enough to
track
George Pavlov wrote:
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
In those rare cases wouldn't it make more sense to just set
enable_seqscan to off; run query; set enable_seqscan to on;
1. these cases are not that rare (to me);
I find that surprising.
2. setting enable_seqscan (in
Jonathan Vanasco ha escrito:
Does anyone have a trick to list all columns in a db ?
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
George Pavlov [EMAIL PROTECTED] writes:
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
In those rare cases wouldn't it make more sense to just set
enable_seqscan to off; run query; set enable_seqscan to on;
1. these cases are not that rare (to me);
It strikes me that you probably need to
Jonathan Vanasco wrote:
Does anyone have a trick to list all columns in a db ?
No trickery, just exploit the availability of the SQL standard
information_schema views:
select table_schema, table_name, column_name
from information_schema.columns
where table_schema not in
From: Tom Lane
George Pavlov [EMAIL PROTECTED] writes:
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
In those rare cases wouldn't it make more sense to just set
enable_seqscan to off; run query; set enable_seqscan to on;
1. these cases are not that rare (to me);
It strikes me that
George Pavlov wrote:
From: Tom Lane
George Pavlov [EMAIL PROTECTED] writes:
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
In those rare cases wouldn't it make more sense to just set
enable_seqscan to off; run query; set enable_seqscan to on;
1. these cases are not that rare (to me);
It
Thanks for the info
Ron Coffin, Lab Manager
School of Computer and Engineering Technologies
Miami Dade College, North Campus
11380 N.W. 27th Avenue
Miami, Florida 33167
Email: [EMAIL PROTECTED]
Phone: 305 237-1054
Fax: 305 237-1531
Please Note: Due to Florida's very broad public records law,
Richard P. Welty wrote:
Guy Fraser wrote:
Have you thought about setting up an account with PayPal, and having
people pay through PayPal?
Let PayPal deal with the security, and credit card info, after all it's
what they do.
at the day job, when we switched from paypal (who we found very
Guy Rouillier wrote:
Richard P. Welty wrote:
Guy Fraser wrote:
Paypal has a perception issue - they are perceived as being tightly
linked with eBay. That's a problem in the corporate arena. If my stock
broker were to tell me they do all their financial transactions through
Paypal, I'd
On Jun 7, 2007, at 4:03 PM, Richard P. Welty wrote:
at the day job, when we switched from paypal (who we found very
undependable)
to authorize.net, we were very pleased to discover that
authorize.net would take
care of the credit card numbers for us, so we didn't have to try to
secure
Hi,
I have a table with one column as real[]. Now if I want to make cubes
out of each of
these arrays, is there a way in postgre I can do it. I guess cube
operator is not defined
for real[] but can I create cubes if the column was integer[]. If yes
please may I know
how.
Actually I would
I tried the patch and it has no effect whatsoever -- even with the
patch, under the correct load the corrupted entries are coming fast and
furious (I found a load profile on my app that reproduces these very
clearly).
Here are a few other observations for what they are worth: The problem
seems
John DeSoi wrote:
On Jun 7, 2007, at 4:03 PM, Richard P. Welty wrote:
at the day job, when we switched from paypal (who we found very
undependable)
to authorize.net, we were very pleased to discover that authorize.net
would take
care of the credit card numbers for us, so we didn't have to
George Pavlov [EMAIL PROTECTED] writes:
I tried the patch and it has no effect whatsoever -- even with the
patch, under the correct load the corrupted entries are coming fast and
furious (I found a load profile on my app that reproduces these very
clearly).
What are the total lengths of the
Joshua D. Drake wrote:
Guy Rouillier wrote:
Richard P. Welty wrote:
Guy Fraser wrote:
Paypal has a perception issue - they are perceived as being tightly
linked with eBay. That's a problem in the corporate arena. If my stock
broker were to tell me they do all their financial
Tom Lane wrote:
George Pavlov [EMAIL PROTECTED] writes:
I tried the patch and it has no effect whatsoever -- even with the
patch, under the correct load the corrupted entries are coming fast and
furious (I found a load profile on my app that reproduces these very
clearly).
What are the
Alvaro Herrera wrote:
My bank is also not a bank (they say they are not FDIC insured
which I think is the actual problem at hand). Do I have to be worried?
Depends what you use it for. If this is an online bank that you use
only for online transactions and you maintain a balance of say
On Thu, Jun 07, 2007 at 06:36:07PM -0400, Jon Sime wrote:
select n.nspname as table_schema, c.relname as table_name,
a.attname as column_name
from pg_catalog.pg_attribute a
join pg_catalog.pg_class c on (a.attrelid = c.oid)
join pg_catalog.pg_namespace n on
At 5:57p -0400 on 07 Jun 2007, Michael Glaesemann wrote:
It is a bit tricky. Datetime math is inherently so.
So one wonders why the whole world doesn't migrate to a single timezone.
There would be no more confusion between EST, CEST, GMT, +1100, etc.
The trade off, of course, would be that now
Kevin Hunter [EMAIL PROTECTED] writes:
At 5:57p -0400 on 07 Jun 2007, Michael Glaesemann wrote:
It is a bit tricky. Datetime math is inherently so.
So one wonders why the whole world doesn't migrate to a single timezone.
Or at least get rid of daylight savings, which has to be one of the
Tom Lane wrote:
Kevin Hunter [EMAIL PROTECTED] writes:
At 5:57p -0400 on 07 Jun 2007, Michael Glaesemann wrote:
It is a bit tricky. Datetime math is inherently so.
So one wonders why the whole world doesn't migrate to a single timezone.
Or at least get rid of
Joshua D. Drake wrote:
Guy Rouillier wrote:
Richard P. Welty wrote:
Guy Fraser wrote:
Paypal has a perception issue - they are perceived as being tightly
linked with eBay. That's a problem in the corporate arena. If my
stock broker were to tell me they do all their financial transactions
Hi,
I have a problem calling a C function
from another C function - DirectFunctionCall*
cannot be used since some parameters may be NULL.
This dies:
FunctionCallInfoData fcinfo1;
InitFunctionCallInfoData(fcinfo1, NULL, 7, NULL, NULL);
/* arg[] and arnull[] are filled with correct values */
Zoltan Boszormenyi [EMAIL PROTECTED] writes:
FmgrInfo flinfo1;
MemSet(flinfo1, 0, sizeof(flinfo1));
This is certainly not the approved way to set up an FmgrInfo.
Use fmgr_info().
regards, tom lane
---(end of
84 matches
Mail list logo