tch reduces the per-connection desktop heap usage from
arount 9.7KB to 3.2KB which is back in line with 8.2.
Regards, Dave
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Harald Armin Massa wrote:
> Dave,
>
>> It's coming from direct dependencies on user32.dll (from which we use
>> wsprintf()) and shell32.dll (from which we use SHGetSpecialFolderPath())
>> and is allocated when ResumeThread() is called to kickstart the new
>> b
Harald Armin Massa wrote:
> Replying to myself
>> Postgres is definitely NOT started as LocalSystem account; so using a
>> "logical not" on Microsofts Words that could indicate the reason why
>> our service-backends consume that memory? Add to this that MS SQL runs
>> as LocalSystem; and as muc
Use "union" ???
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stefan
Schwarzer
Sent: Wednesday, October 24, 2007 9:09 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] "Concatenate" two queries - how?
Hi there,
I have two queries, which I would li
this feature that is rather common in other database
> development tools will ever be added to pgAdmin.
pgAdmin II had change control. No-one ever really used it though so we never
bothered to implement it in pgAdmin III.
Regards, Dave
---(end of broadcast)--
> --- Original Message ---
> From: Gregory Stark <[EMAIL PROTECTED]>
> To: "Dave Page" <[EMAIL PROTECTED]>
> Sent: 25/10/07, 19:06:12
> Subject: Re: subversion support?
>
> The situation is complicated somewhat by the SQL "ALTER TABLE&quo
y wanted to keep it, nor did anyone complain about it
being missing in pga3.
Unless there are a decent number of people that would actually use it
now, I'm reluctant to spend the time on a feature that would simply add
to the maintenance burden.
Regards, Dave
---(end
e the heap for
>> all
>> non-interactive window stations to 1024KB.
>
> This part should go in the FAQ, I think. It's valid for 8.2 as well,
> from what I can tell, and it's valid for 8.3 both before and after the
> patch I just applied.
>
> Dave, you
Hi Tino
Tino Wildenhain wrote:
> Hi Dave,
>> pgAdmin II had change control. No-one ever really used it though so we
>> never bothered to implement it in pgAdmin III.
>
> But it was implemented differently then the proposal above.
I'm not sure the detail of how it
> --- Original Message ---
> From: Rainer Bauer <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: 26/10/07, 18:09:26
> Subject: Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit
>
> Dave could you add that it's the third
When I run a query, and the number of lines exceeds what the screen can
hold, the results seem to get piped into "more" (or "less"). How can I
turn that off and just have everything stream out without stopping? I
tried -echo-all, but that doesn't seem to do the trick.
Thanks in Advance !
You know the old saying, tell a lie often enough and it becomes the
truth.
There are perceptions about databases out there that may not stand the
test of analysis. But that really doesn't matter. If you want to bring
down the perception, you need to use a different tact. And that has
nothing to
vanish when the script/program
ends.
Probably not, but if not, then this would be (IMO) a great addition to
have, something that'd really make it distinct from MySQL . I'd use
SQLite, but I want to have stored functions and other "real" database
features that it just doesn't have.
Thanks
-dave
t;? Is it
(gulp) just a "rm -r" ?
I do have access to scratch disks which, in effect, could be used as a
temporary storage area. IOW, if something goes wrong, and I don't get
to delete a db that was created on the scratch disk, it'll get cleaned
up for me overnight. It'
orary) DB for small apps that can reap all the wonderful
features of PG would make it very attractive for some users. Just
something to think about for future development.
One question I had earlier that I don't think got answered was how to
undo an "initdb". "dropdb" drops
g this other than trying to do something with
the table (select, insert, delete...) and trapping a failed attempt? The
contents of pg_tables appears to be the same from both the owning and
non-owning sessions.
Thanks in Advance for any help.
v8.2.0 on 64-bit suse-linux
-dave
Is there a function that'll return the position of the last occurance of
a char in a string?
For Example, in the string 'abc/def/ghi' I want the position of the 2nd
'/'.
Thanks in Advance.
. Kretschmer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] reverse strpos?
On Mon, Nov 12, 2007 at 05:19:25PM +0100, A. Kretschmer wrote:
> am Mon, dem 12.11.2007, um 10:54:53 -0500 mailte Gauthier, Dave
folgendes:
> > Is there a function that?ll return the position of the last
>
Hi:
I have a situation where I will be inserting thousands of records into a
table but leaving 2 of it's columns null. Later on, I will be updating
most of those records and putting real values in place of those 2
nulls. As for the ones that do not get updated, I want to leave them
null. My
load.
Thanks for the advanced warning about problems with vaccuum !
-dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
Sent: Wednesday, November 14, 2007 11:13 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] reserving space
> --- Original Message ---
> From: Richard Huxton <[EMAIL PROTECTED]>
> To: "Joshua D. Drake" <[EMAIL PROTECTED]>
> Sent: 14/11/07, 19:01:04
> Subject: Re: [GENERAL] PLpgsql debugger question
>
> Joshua D. Drake wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Wed
Tony Caduto wrote:
> I dont' have a c/c++ compiler on my PCs as I am a Delphi guy.
>
> Anyone have it compiled for win32 and willing to share?
>
> Actually I do have CodeGear C++, but it's unlikely to work with that.
Just download and install the win32 distro of
ECTED]
Sent: Friday, November 16, 2007 1:16 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pl-pgsql "return set of..." "return next..."
performance question
Hello
>
> I noticed that it takes a long time to return the set of records. But
if I
Hi:
I have PL-PgSQL function that returns a set of records. It builds up 2
temp tables and then queries them to generate the set of records to be
returned a-la
for rrec in
select t1.x, t2.x from t1, t2 where
loop
return next rrec;
end loop;
I noticed that it takes a
this is just a wish list / suggestion matter
at this point.
-dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michelle
Konzack
Sent: Saturday, November 17, 2007 11:48 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Temporary, In-memory P
"\i create_try.sql;"
psql --dbname mydb -c "select trythis('foo');"
psql --dbname mydb -c "drop function trythis(varchar);"
-dave
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas
Kretschmer
Sent: Wednesd
Is there such a thing as an opensource schema printer for postgres ?
Dave.
begin:vcard
fn:David Potts
n:Potts;David
x-mozilla-html:FALSE
version:2.1
end:vcard
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
p://www.enterprisedb.com/products/enterprisedb_replication.do
Regards. Dave.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
inly falls into the "near real time" replication category.
I don't know how modified it might be, but I should also note that there's
another tool for synchronising data with Oracle which is not based on Slony.
Iirc, it's intended more for tasks like regular updating of
There's probably some way to pull all the field names from the metadata
tables and build a query on-the-fly that selects all but the offensive
one.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matt Doughty
Sent: Wednesday, November 28, 2007 11
Seems odd that you'd know specifically which column you don't want, but
not know what columns you do want. And then not care what order those
desired columns happen to be be returned in.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Fetter
Sent: We
That could be an issue with Hibernate or the other code you're running,
but yes, if it's opening lots of connections and keeping them open that
could be what's wrong and I would suggest checking the FAQ above.
Regards, Dave
---(end of broadcast)
I've recently installed Postgres 8.2.x on a RedHat Linux system. Everything
seems fine and normal. I can start and stop the server without errors.
When the server is running, everything appears normal. The problem is that
about every 2 to 3 hours I find the server is just not running anymore.
I'
hey are the OpenSSL libraries that your libpq was built against. If you're
developing with libpq you should really do so against a build rather than the
source tree - using the windows installer will get you all the headers, dlls
and import libraries you need provided you o
What's a good way to start the postmaster, send the log info to a
logfile somewhere, and return the linux prompt?
v8.2.0 on suse64
Thanks
-dave
t; all seem to fail.
"postmaster -d myplace/db -l logfile start" (as was in the message right
after the initial db create) doesn't seem to work.
I'll request v8.2.5. Thanks for the advise.
-dave
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent:
Is there something like a freeware windows client app that does DBA
stuff for a remote server? Sort of like TOAD for Oracle?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erik Jones
Sent: Tuesday, December 04, 2007 1:34 PM
To: Konrad Neuwirth
Cc: Postgr
EMAIL PROTECTED]
Sent: Friday, November 30, 2007 8:22 PM
To: Dave Horn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres shutting down by itself...why?
"Dave Horn" <[EMAIL PROTECTED]> writes:
> I've recently installed Postgres 8.2.x on a RedHat Linux system.
Eve
Hi:
if...
create table coords (id int, x float, y float);
then...
insert into coords (id,x,y) values (1,1.000,2.001)
and then...
select * from coords
i get...
1,1,2.001
i want...
1.1.000,2.001
while retaining the numeric nature of the x,y data
Both work (to_char and casting to numeric)
Thanks !
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas
Kretschmer
Sent: Thursday, December 06, 2007 1:46 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] reformatting floats ?
Gauthier, Dave
Future Enhancement?
If the column's new value can fit in the space already being used by the
existing value, just change the column value in place and leave the
record alone. Would reduce the need for vacuum in many cases.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTE
Sometimes breaking the query down using nested cursors can help,
especially if the query has many joins. It usually makes behavior more
predicatable anyway.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Merlin Moncure
Sent: Thursday, December 06, 2007 2
any one help
It might be tucked away in the app bundle (can't check right now I'm afraid) -
if not, you'll need to build from source unfortunately.
Regards, Dave
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, plea
saction, instead --- that's
> the closest match to the old behavior of pg_locks.transaction.
>
> > Anyone have any idea as to what is generating this statement?
Sounds like a now-fixed bug in pgAdmin 1.8.0's server status monitor.
Regards, Dave
---(en
Values is optional. We support insert into select
Dave
On 9-Dec-07, at 11:05 AM, Alain Roger wrote:
Hi,
i would like to understand why the following INSERT INTO statement
works :
INSERT INTO mytable
SELECT nextval('my_sequence'),
'myname',
'myfirstna
Joshua D. Drake wrote:
* Is there a project to create MySQL compatibility for Postgresql? I
No. Thank god.
Just think of all those potential customers you could be missing JD :-)
http://pgfoundry.org/projects/mysqlcompat/
/D
---(end of broadcast)-
e done some PL-pgsql and know about
statement blocks in that context. But I don't want to have to create a
function, use it, then delete it. Was wondering of something else could
be done.
Thanks
-dave
work out of the box with Excel and
OpenOffice - if not, check the copy delimiter/quoting options under
file->options.
Regards, Dave
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Joshua D. Drake wrote:
> On Wed, 19 Dec 2007 12:20:32 +0900
> Paul Lambert <[EMAIL PROTECTED]> wrote:
>
>> I'm just disappointed that I finish up work with my current employer
>> on Friday and where I am going I won't get to work with PG anymore
>> and thus won't have as much opportunity to intera
ctl service runs
under, eg. MYPC\postgres
The values are split into two sets of keys (with some duplication) to
allow easy cross-referencing from service to installation and vice
versa. Obviously and in the key paths should
be replaced with the actual values.
Regards, Dave.
--
Harald Armin Massa wrote:
> HKLM\Software\PostgreSQL\Services\\Service Account
>
> Where:
>
> [...]
> Service account is the Windows user account that the pg_ctl service runs
> under, eg. MYPC\postgres
>
>
> I guess that would be "service account that was assigned to the pos
aller if you're will to run
8.3 beta until the full release:
http://postgres.enterprisedb.com/download.do
It works pretty well even if (as the author) I do say so myself :-)
Regards, Dave
---(end of broadcast)---
TIP 9: In versions below 8
> --- Original Message ---
> From: Chuck <[EMAIL PROTECTED]>
> To: Dave Page <[EMAIL PROTECTED]>
> Sent: 22/12/07, 18:51:09
> Subject: Re: [GENERAL] installation on Mac OS X 10.5.1
>
> Thanks. If I take this approach will it be straightforward to upg
> --- Original Message ---
> From: Chuck <[EMAIL PROTECTED]>
> To: "Dave Page" <[EMAIL PROTECTED]>
> Sent: 22/12/07, 19:21:21
> Subject: Re: [GENERAL] installation on Mac OS X 10.5.1
>
> Yes, thanks for the reminder. I'm using this as a
Hi
I created a database instance and a database takign whatever defaults
were in effect with regard to defining a superuser and password. What
are those defaults? How do I change the password for the superuser?
Thanks
-dave
r that I wanted to grant "all" to and that seemed to
work...
create user foo password 'foopass';
grant all on database mypgdb to foo;
And I can connect using the "foo" user (psql -U foo mypgdb). But it
doesn't seem to require the password. Would you know why? I
t into that new column the value in "temp"
- alter table, drop "temp"
- recreate all the indexes
Thanks
-dave
the only reason it might fail that I can think of. In
1.6 it'll use the first version it finds. In 1.8, you can select the
path yourself if you like.
Regards, Dave
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
If MySQL goes the way of Java, maybe there isn't too much to worry
about.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Weslee Bilodeau
Sent: Wednesday, January 16, 2008 10:56 AM
To: Russ Brown
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sun
2 out of 7 - which would be Bruce & I.
Regards, Dave
On 1/16/08, Dirk Riehle <[EMAIL PROTECTED]> wrote:
>
> > The main company, MySQL AB was all that was left to effectively give
> > them control of MySQL.
> >
> > PostgreSQL obviously doesn't have this
assume they can be overridden)? I don't know if you'd
see exactly the same symptoms you have, but changing settings like
integer datetimes will break things in a similar way.
Regards, Dave
---(end of broadcast)---
TIP 9: In versions below 8.0
On 18/01/2008, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Am Freitag, 18. Januar 2008 schrieb Dave Page:
> > It got figured out when someone who knew what they were looking for
> > peeked at the byte ordering in a file which for all we knew at the
> > time mig
On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> Hm? integer_datetimes is encoded separately and there's a very specific
> error message if it's wrong. The case I think you are remembering was
> caused by a width-of-time_t discrepancy, which should be fixed but it's
> got nothing to do with a
On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > Note to the other hackers - is it worth having initdb dump the
> > architecture details and configure options used into the cluster in a
> > human readble
On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> uname is a separate executable. If you do system("uname") you'll get
> results that reflect how uname was built, not how Postgres was built.
Right, I realise it's a seperate executable, but doesn't configure
rely on it anyway? Meaning if someon
On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> Ah. That would work better than what I thought you were suggesting, but
> I still don't trust it a
nd configure options used into the cluster in a
human readble form so we can pickup on this sort of thing more easily
in the future?
Regards, Dave.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
ostgresql-8.3-dev1.txt ', it just might mean
> something to you 'cos it does not mean anything to me.
Please try 8.3RC2. 8.3-dev1 is a *very* old test build and not
something anyone should actually be using. Where did you find it
anyway?
Regards, Dave.
---(en
On Jan 29, 2008 6:16 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> I try to be reasonable (no laughing people :)).
Oh it's hard, so very, very hard!
:-)
/D
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Jan 30, 2008 11:35 AM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 30/01/2008 11:27, Gregory Stark wrote:
>
> > In fact I think most of the features you'll look for examples of will be
> > from
> > the last 1-2 years. When 8.3 comes out people will be looking for whole
> > books
> > on X
;'t wish to use the online help.
Regards, Dave.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On Jan 30, 2008 1:34 PM, Peter Wilson <[EMAIL PROTECTED]> wrote:
>
> Dave Page wrote:
>
> On Jan 30, 2008 12:45 PM, Peter Wilson <[EMAIL PROTECTED]> wrote:
>
>
>
> Has anyone else generated a Windows Help version of the manual?
>
> We distribute it
enting at the conference.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
those particular ones have
an unusual ACL on them which caused our pre-installation actions to go
haywire. If such a problem occurs with the installation path, you
should get a regular "permission denied" error.
Regards, Dave.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitte
y won't be, unless
> you remember to do it. Eventually that's gonna bite ya.
>
> Of course the best fix would be for EDB to ship a build of Postgres
> that actually follows the platform-standard naming convention for this
> library. I'm still wondering why they'
What are the pros/cons of using Slony vs the nre streaming replication in v9?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Singer
Sent: Thursday, October 07, 2010 12:58 PM
To: slony1-general; pgsql-general@postg
d you can create databases implies that
the server is at least installed and running.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
the same,
> except for replacign the Mongo guy with MySQL and the MySQL guy with
> PostgreSQL. That might be more apopros all around ;)
Someone did indeed do that:
http://nigel.mcnie.name/blog/mysql-is-a-database (also nsfw, iirc)
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @
tely close to the ease with which you can plugin a different
storage engine in MySQL, and would take a significant amount of
engineering expertise and effort.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgr
On Wed, Oct 13, 2010 at 1:11 PM, Thom Brown wrote:
> On 13 October 2010 12:35, Dave Page wrote:
>> On Wed, Oct 13, 2010 at 12:29 PM, Ron Mayer
>> wrote:
>>> Pavel Stehule wrote:
>>>> 2010/10/8 Carlos Mennens :
>>>>> I know that MySQL uses MyI
I think it's incorrect to expect a query to return column in any specific order
if you do something like "select * from...". You may see columns returned in
the order you created them, but I don't believe it's guaranteed. If you want a
specific order, then "select col1, col3, col5, col2, .
Think of it this way...
A person has many properties... age, nationality, eye_color, weight, etc...
Does it maks sense to put these properties in a particular "order" ?
Neither does a relational DB require them to be in any order. The fact that
"select *" consistently shows them in one particu
to believe that there should be a "Jobs" tree
> in pgAdmin created.. But I see nothing. Thanks!
Did you setup the database per the part of the docs prior to that section?
The "next steps" are most certainly there - see the index page at
http://www.pgadmin.org/docs/1.12/pg
;ll need to put together a startup script for your OS, if the
debian/ubuntu packager hasn't done so already. I'd suggest copying one
from /etc/init.d and tweaking it as required.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterpri
On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen wrote:
> On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote:
>> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen
>> wrote:
>>> Sorry, it looks like it defaulted to the wrong DB. I created the
>>> schema in
o, what user account will it find the
> .pgpass file under? Thanks!
Have the script start pgagent under the postgres account eg;
su - postgres -c 'p/path/to/pgadmin'
Then it should be able to use postgres' pgpass file. Don't put the
password in the connection string!
On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen wrote:
> On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote:
>> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen
>> wrote:
>>> Okay I found one that I can use..
>>>
>>> One question.. Should th
ay32.dll
>>
>> How to update them so that they match with linux server ?
>
> Oh, interesting. So we install SSL with our Win32 install, and I assume
> that is a new/correct version of ssl.
>
> Dave, this person says they are getting disconnected regularly and we
> thoug
Hi:
Is there something like a pg_xxx view that I can use to get the column names
and data types of a table, similar to what I see with \d ? I need to run this
is a script, so \d isn't viable. I did a \df and looked around, but nothing
popped out.
Thanks in Advance !
2bit unless you're using the 32bit
Postgres build (it's built along with the rest of the server, so...).
What version of Python do you have? A quick glance at the build script
shows we're using 2.6, and we always use the ActiveState builds.
--
Dave Page
Blog: http://pgsnake.blog
ing Postgres.
It's not a PostgreSQL issue - the underlying library ossp-uuid doesn't
support 64 bit Windows.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general maili
o already, head on over to the website and
register your attendance at the conference. You won't regret it!
Website: http://2010.pgday.eu/
Schedule: http://2010.pgday.eu/schedule
Registration: http://2010.pgday.eu/register
See you in Stuttgart!
--
Dave Page
PostgreSQL Core Team
http://www.
t have any idea how or why it works as it does. We
just know we need the runtimes it installs.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (pgsql-genera
he
> scrollbar.
That is basically how it works (MVC), albeit without using cursors;
for both the reason you state and because part of the point of the
tool is to tune queries and using cursors to do that completely messes
up any timings we might get.
--
Dave Page
Blog: http://pgsnak
I mean that the tool was developed to help tune application
queries, in which the data transfer time can be just as important as
the query execution time. With cursors, you lose that information.
Of course, patches to make optional use of cursors would be interesting to us.
--
Dave
This is a longshot, but here goes...
Is there a way to require that a check constraint be checked on insert but not
update?Worth knowing is that my check constraint runs a PLPgsql proc which
returns a yes/no kinf of flag which the constraint proper checks.
Thanks !
ction server), I will note that Hiroshi
Saito has ported ossp-uuid to Win64 now, and we're working on getting
it included in the next update of PG 9.0.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Compa
normally because it's not
in compliance with a security policy on the system - almost always
related to password complexity, or age/reuse. You could try creating
the account manually in advance.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.en
he tarballs coincided with PGWest, so I couldn't do
them then and now have to catch up on a bunch of work. To make matters
worse, the pgAdmin build has changed somewhat on Windows and requires
some effort to update the installers to work again.
--
Dave Page
Blog: http://pgsnake.blog
Think upgrades
-Original Message-
From: Andy [mailto:angelf...@yahoo.com]
Sent: Tuesday, November 09, 2010 12:02 PM
To: pgsql-general@postgresql.org; Gauthier, Dave
Subject: Re: [GENERAL] Why facebook used mysql ?
--- On Tue, 11/9/10, Gauthier, Dave wrote:
> A different slant
101 - 200 of 1235 matches
Mail list logo
