On Wed, May 03, 2006 at 11:45:31PM -0700, Don Y wrote:
> Martijn van Oosterhout wrote:
> >Unfortunatly there is no way to ensure the user declares the function
> >in SQL in the way your code expects. I remember a discussion once about
> >allowing you to declare the essential function details in the
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
Is there any way to prevent them from *adding* these functions
(i.e. build them into template) so they have to use them the
way *I* have already defined them?
Only if you think you can deny your users superuser privileges on
their own databases
Martijn van Oosterhout wrote:
On Wed, May 03, 2006 at 11:45:31PM -0700, Don Y wrote:
Martijn van Oosterhout wrote:
Unfortunatly there is no way to ensure the user declares the function
in SQL in the way your code expects. I remember a discussion once about
allowing you to declare the essential
On Thu, May 04, 2006 at 12:19:12AM -0700, Don Y wrote:
> I'm not designing for the "traditional" role that you're
> used to so I can do whatever makes sense for this product
> and just *define* that as it's behavior. Since there are
> no other products that compete with it, users don't
> really ha
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
First, if the function is defined to return an INT16,
then returning a NULL doesn't make any sense -- since the
caller doesn't know how to deal with a NULL (it expects
an INT16, for example).
Really? That would be a caller bug, if it's calling
On Thu, May 04, 2006 at 12:23:07AM -0700, Don Y wrote:
> I don't want to hide the function; just ensure that no one
> *redefines* the SQL interface to it in a manner that is
> inconsistent with its implementation. If I can make the
> implementation robust enough that it could protect itself
> agai
On Thu, May 04, 2006 at 12:29:30AM -0700, Don Y wrote:
> OTOH, if the function could *abort* it's invocation, then
> I don't have to worry about return values. It is a closer
> model to the STRICT behavior -- instead of aborting the
> function invocation BEFORE (which STRICT essentially does),
> I
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:19:12AM -0700, Don Y wrote:
I'm not designing for the "traditional" role that you're
used to so I can do whatever makes sense for this product
and just *define* that as it's behavior. Since there are
no other products that compete with it
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:29:30AM -0700, Don Y wrote:
OTOH, if the function could *abort* it's invocation, then
I don't have to worry about return values. It is a closer
model to the STRICT behavior -- instead of aborting the
function invocation BEFORE (which STRI
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:23:07AM -0700, Don Y wrote:
I don't want to hide the function; just ensure that no one
*redefines* the SQL interface to it in a manner that is
inconsistent with its implementation. If I can make the
implementation robust enough that it co
> > Looks that way to me. You could try setting enable_sort off as well,
> > which will penalize the seqscan+sort plan another 100million cost units.
> > And maybe try reducing random_page_cost to make the indexscan look
> > cheaper. However, if there's a 100million delta between the two plans,
>
On Thu, May 04, 2006 at 10:09:33AM +0200, Csaba Nagy wrote:
> Well, I guess that's it then... I will let the query run with the
> seqscan+sort. It will still run 1-2 days, yesterday I stopped it after 6
> hours ;-) Actually it would be nice to have some kind of feedback on
> what is it doing so I c
> There are a number of ways you can (indirectly) see how far it has got.
> If it's in the first phase (the seq scan), by looking at which file it
> has open you should be able to see how far along the table it is. Once
> it's in the sort stage you should be able to see from the tape files
> approi
Javier de la Torre wrote:
Great! Then there will be no problems.
I would use COPY but I think I can not. While moving from MySQL to
PostgreSQL I am also transforming a pair of fields, latitude,
longitude, into a geometry field, POINT, that is understood for
Potgis. I though I will not be able to
Hi, our 8.1.3 system on quad Xeon has been happily chugging away for
weeks with no stability problems until yesterday:
/var/log/syslog:May 4 11:57:17 cayenne kernel: postmaster[19291]:
segfault at rip 2b5e8c00 rsp 7fffd418
error 4
/var/log/syslog.0:May 3 09:3
On Thu, May 04, 2006 at 12:22:01PM +0100, Gavin Hamill wrote:
> Hi, our 8.1.3 system on quad Xeon has been happily chugging away for
> weeks with no stability problems until yesterday:
>
> /var/log/syslog:May 4 11:57:17 cayenne kernel: postmaster[19291]:
> segfault at rip 2
Hi I am new to postgre sql I am trying to execute
the sample c code which are connecting to postgre data base
It is postgre web site, I am not bale to
compile that code it is generating linker error
Could any body tell how to set lib and
dill which are required to exec cute the following
On Thu, May 04, 2006 at 06:03:11PM +0530, srinivasa.n wrote:
> Hi I am new to postgre sql I am trying to execute the sample c code which
> are connecting to postgre data base
>
> It is postgre web site, I am not bale to compile that code it is generating
> linker error
>
> Could any body tell ho
You need to link with wsock32.lib.
//Magnus
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of srinivasa.n
> Sent: Thursday, May 04, 2006 2:33 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] linker
>
> Hi I am new to postgre sql I am tryi
I searched the archives looking for something definitive
related to Postgresql on Windows XP with Intel Duo.
We loaded postgresql 8.0.3 on a Dell with T2600 processor,
Intel Duo at 2.16 GHz. It wasn't long after a copy
of our production DB was loaded that numerous
connection and "not a socket" e
hello all
we are using psql 7.3.10
ILIKE seems not to work properly with german umlaut. i already saw some
previous posts
(http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php)
about this problem and there seems to be a patch around that fixes the
problem for LATIN5 but i didn't find
Hi!How do you know that the database exists?
I know it exists, because I created it when I installed PostgreSQL.Speaking of databases: I can't even create a new database. If I run the command createdb databasename
from the PostgreSQL cmd, the following error shows up:createdb: could not connect to
Geoffrey wrote:
How do folks handle the death of the postmaster in their applications?
Assuming the postmaster dies after an application has connected to the
database, but before it makes a request. What should I look for?
Currently our application that's in development does not handle the
si
Martijn van Oosterhout wrote:
> On Thu, May 04, 2006 at 12:22:01PM +0100, Gavin Hamill wrote:
>> Hi, our 8.1.3 system on quad Xeon has been happily chugging away for
>> weeks with no stability problems until yesterday:
>>
>> /var/log/syslog:May 4 11:57:17 cayenne kernel: postmaster[19291]:
>> seg
I have a foreign key constraint that I'd like to alter. I'd rather not
drop and re-create it due to the size of the table involved. All I need
to do is add an ON UPDATE CASCADE.
Is it ok to set confupdtype to 'c' in pg_constraint (and will this be
all that's needed) or is it safer to drop and rec
On Thu, 4 May 2006, Rich Doughty wrote:
> I have a foreign key constraint that I'd like to alter. I'd rather not
> drop and re-create it due to the size of the table involved. All I need
> to do is add an ON UPDATE CASCADE.
>
> Is it ok to set confupdtype to 'c' in pg_constraint (and will this be
hi,I made a proposal to the "Google summer of Code 2006" http://code.google.comYou can find my Proposal here:
http://www.webbase-design.de/summerofcode/summerofcode.pdfIts about making a Rich Client Admin Tool for basically PostgresSQL with Drag and Drop, Query Builder, et cetera... it should be e
No response from the pgsql-admin list so I though I would try cross
posting here:
pgsql-sql@postgresql.org
pgsql-general@postgresql.org
I just know I am not the first to try and do this
Jim
*
Can anyone point me in a direction that may help me populate in real
time a table
Current_user
Timestamp
"The Select Statement Submitted by the User"
http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE
might be close to what you want.
Regards,
Ben K.
Developer
http://benix.tamu.edu
---(end of broadcast)
by the was the email in the news-section is wrong i thinkit should be: [EMAIL PROTECTED].com not [EMAIL PROTECTED].orgregards
sebastian2006/5/4, Sebastian Wagner <[EMAIL PROTECTED]>:
hi,I made a proposal to the "Google summer of Code 2006" http://code.google.com
You can find my Proposal here:
http
On Sat, Apr 29, 2006 at 06:39:21PM -0400, Tom Lane wrote:
> "Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> > The general problem seems to be that a transaction has no way to promise
> > never to touch a specific table. Maybe some kind of "negative lock"
> > would help here - you'd do "exclude t
On Sat, Apr 29, 2006 at 12:00:15AM +0200, Dany De Bontridder wrote:
> Hello, I would like to dump all my functions and only the functions from a
> database, how can I do that ??
>
> So far, I can only get it with
>
> pg_dump -s dossier1|awk '/CREATE FUNCTION/,/LANGUAGE/ { print $0;}'
There's
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> I'd actually been thinking about this recently, and had come up with the
> following half-baked ideas:
> Allow a transaction to specify exactly what tables it will be touching,
> perhaps as an extension to BEGIN. Should any action that transaction
> tak
On Sun, Apr 30, 2006 at 12:33:04PM +0200, Martijn van Oosterhout wrote:
> On Sat, Apr 29, 2006 at 07:05:35PM -0700, Steve Atkins wrote:
> > >Just kidding... once you delete your records... they are gone.
> >
> > That's not true.
> >
> > Deleted (or modified) records don't go away until the sp
On Sun, Apr 30, 2006 at 12:32:53PM -0700, Tony Lausin wrote:
> >[ rotfl... ] MySQL will fall over under any heavy concurrent-write
> >scenario. It's conceivable that PG won't do what you need either,
> >but if not I'm afraid you're going to be forced into Oracle or one
> >of the other serious-mon
On Mon, May 01, 2006 at 09:41:57AM -0700, Tony Lausin wrote:
> Thanks for the suggestions, everyone. This is what I have so far:
>
> I require an open source DBMS because I want to avoid being locked
> into a particular vendor, especially one that will send me a big bill.
> That leaves me with MyS
Hi Jim,
I'm settled on sticking with PostgreSQL since MySQL is just to
incompatible with my needs and desires. I just wanted to be
open-minded to some of the MySQL advocacy I've heard.
My project is essentially a CMS, but there are features that are
commonly found in social networking sites like
On Mon, May 01, 2006 at 04:46:33PM +0200, SunWuKung wrote:
> We had a discussion with my friend about whether to use an array or an
> attached table and I was in favor of the attached table while he was
> concerned about the the performance of the select/insert as the number
> or records in the
You might try asking on -interfaces, but I don't think there is one.
Want to develop one? :)
On Tue, May 02, 2006 at 06:27:41PM +0200, Ottavio Campana wrote:
> Is there a libpq for palm os?
>
> That would be great to develop applications.
>
> --
> Non c'? pi? forza nella normalit?, c'? solo mon
On Wed, May 03, 2006 at 04:28:10PM +0200, Leif B. Kristensen wrote:
> However, I'm wondering if there's a practical limit to how many rows you
> can insert within one transaction?
I believe transactions are limited to 4B commands, so the answer would
be 4B rows.
--
Jim C. Nasby, Sr. Engineering
On Wed, May 03, 2006 at 04:43:15PM +0200, Javier de la Torre wrote:
> Yes,
>
> Thanks. I am doing this now...
>
> Is definetly faster, but I will also discover now if there is a limit
> in a transaction side... I am going to try to insert into one single
> transaction 60 million records in a tabl
On Wed, May 03, 2006 at 04:11:36PM +0200, Javier de la Torre wrote:
> It is inserts.
>
> I create the inserts myself with a Python programmed I hace created to
> migrate MySQL databases to PostgreSQL (by th way if someone wants
> it...)
Have you looked at http://pgfoundry.org/projects/my2postgres
Tom Lane wrote:
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
I'd actually been thinking about this recently, and had come up with the
following half-baked ideas:
Allow a transaction to specify exactly what tables it will be touching,
perhaps as an extension to BEGIN. Should any action that tra
On Thu, May 04, 2006 at 03:30:34PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > I'd actually been thinking about this recently, and had come up with the
> > following half-baked ideas:
>
> > Allow a transaction to specify exactly what tables it will be touching,
> > perh
On Tue, May 02, 2006 at 09:58:56AM -0400, David Brain wrote:
> I have a cron job that vacuums one of my dbs daily (Postgres 7.3.11)-
> using 'vacuumdb -a -f -z -q -U postgres'. Currently I get an email
> containing the folowing error messages:
>
> NOTICE: number of page slots needed (38320) e
Jim C. Nasby wrote:
You might try asking on -interfaces, but I don't think there is one.
Want to develop one? :)
I think Palm supports both ODBC and JDBC... you might be better off
going that route.
Sincerely,
Joshua D. Drake
On Tue, May 02, 2006 at 06:27:41PM +0200, Ottavio Campana wrot
On Thursday 04 May 2006 22:30, Jim C. Nasby wrote:
>On Wed, May 03, 2006 at 04:28:10PM +0200, Leif B. Kristensen wrote:
>> However, I'm wondering if there's a practical limit to how many rows
>> you can insert within one transaction?
>
>I believe transactions are limited to 4B commands, so the answ
On Thu, May 04, 2006 at 01:15:25PM -0700, Tony Lausin wrote:
> My project is essentially a CMS, but there are features that are
> commonly found in social networking sites like MySpace and CampusHook.
> I prefer to call it a web-based BBS inspired by my Citadel days that
> borrows features from soc
On Thu, May 04, 2006 at 10:58:24PM +0200, Leif B. Kristensen wrote:
> On Thursday 04 May 2006 22:30, Jim C. Nasby wrote:
> >On Wed, May 03, 2006 at 04:28:10PM +0200, Leif B. Kristensen wrote:
> >> However, I'm wondering if there's a practical limit to how many rows
> >> you can insert within one tr
On Thu, 2006-05-04 at 16:06, Jim C. Nasby wrote:
> On Thu, May 04, 2006 at 10:58:24PM +0200, Leif B. Kristensen wrote:
> > I know that there is one hard-wired limit due to the OID wrap-around
> > problem, at 2^31 commands in one transaction. But the practical limit
> > due to hardware resources
On Thu, May 04, 2006 at 02:42:29PM -0500, Jim C. Nasby wrote:
> There is? The only time travel capability I know of is
> http://www.varlena.com/GeneralBits/122.php. There is also the idea of
> having vacuum move old tuples to some form of secondary storage instead
> of sending them to the bit-bucke
On Thursday 04 May 2006 23:06, Jim C. Nasby wrote:
>On Thu, May 04, 2006 at 10:58:24PM +0200, Leif B. Kristensen wrote:
>> On Thursday 04 May 2006 22:30, Jim C. Nasby wrote:
>> >I believe transactions are limited to 4B commands, so the answer
>> > would be 4B rows.
>>
>> That is definitely not the
On 4/30/06, Tony Lausin <[EMAIL PROTECTED]> wrote:
Hello all,
I'm working on a CMS which requires an open source database capable of
handling hundreds of thousands of users simultaneously, with a high
rate of database writes, and without buckling. We're talking somewhere
between nerve.com/catch2
Hi Jim,
I'm settled on sticking with PostgreSQL since MySQL is just too
incompatible with my needs and desires. I just wanted to be
open-minded to some of the MySQL advocacy I've heard.
My project is essentially a CMS, but there are features that are
commonly found in social networking sites lik
I highly suggest reading the manuals, specifically the first link to the windows installation instructions:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
http://www.postgresql.org/docs/8.1/interactive/index.html
You are getting an error because either you entered in the wrong pas
55 matches
Mail list logo
