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 broadcast)-
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 */
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
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
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
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
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 sa
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).
>
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 financia
"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 o
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 try
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 ve
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 pass
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 them
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 pro
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
und
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, mos
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 s
> 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);
>
>
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 ('pg_cat
"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
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 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 JDB
> 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
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 ge
> 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 enou
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 fo
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 pg_start_backup
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 ot
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 mean
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
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 ca
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 ta
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
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 --
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 pre-existi
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
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
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
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
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 l
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 th
Sorry
.pgpass
:-(
Anton
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
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 ps
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 tha
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 thre
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
yes
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 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, the
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
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: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
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 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
"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 a
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 u
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
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
techn
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 fi
take a look inside the rpm and see what it installed:
rpm -ql
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 failing to
[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
>
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: [GENE
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;
my_que
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?
h
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 w
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
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 like
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
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 =
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 " v
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
(http://www.postgresql.org/docs/8.2/intera
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 possible
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
PRODUCTIO
"Thomas F. O'Connell" 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, or is it possibly a resource issue?
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 (assumin
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 ac
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 postgr
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) ?
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?
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 o
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 tabl
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 tha
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
84 matches
Mail list logo
