On Feb 5, 2008 1:24 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > # Fixup the makefiles
> > echo "Post-processing Makefiles for Universal Binary build"
> > find . -name Makefile -print -exec perl -p -i.backup -e 's/\Q$(LD)
> > $(LDREL) $(LDOUT)\E (\S+) (.+)/\$(LD) -arch ppc \$(LDREL) \$(L
On Feb 5, 2008 3:07 PM, Larry Rosenman <[EMAIL PROTECTED]> wrote:
>
> On Tue, 5 Feb 2008, Dave Page wrote:
>
> > Another option which may be doable for someone with more knowledge of
> > make would be to build binaries for all architectures seperately (you
> > can
rary/ms235290.aspx) - it makes
the point that the installation will fail for non-administrators, and
the dependent apps then won't work. I don't suppose you have power
user rights but not full administrator rights in user account you're
using?
Regards,. Dave
--
Can anyone interpret this error message?
It appears in response to each of the following queries in one
instance of PostgreSQL 8.3:
SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN
pg_postmaster_start_time() ELSE NULL END as upsince FROM pg_user
WHERE usename=current_user ;
SELECT rolc
I noticed that, in one of the third-party databases I have installed
on my server, one foreign key constraint could not be implemented.
(The key columns are of incompatible types.) In previous upgrades I
had seen a warning concerning this constraint, and had passed this
information along to
r your help!
On Feb 10, 2008, at 12:42 PM, Tom Lane wrote:
Dave Livesay <[EMAIL PROTECTED]> writes:
Can anyone interpret this error message?
Something's whacked out about your ON SELECT rules for these views.
Further than that is harder to say --- have you tried looking at
\d outp
On Feb 10, 2008, at 2:21 PM, Tom Lane wrote:
Dave Livesay <[EMAIL PROTECTED]> writes:
This is the first version of PostgreSQL provided by a certain very
helpful fellow, who has been making PostgreSQL binaries available for
us Mac users for years, since he upgraded to Mac OS X 10.5 (aka
L
On Feb 11, 2008 4:28 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > If the endianess isn't corrected for the non-native platform at build
> > time, I've seen initdb leave a cluster with a completely broken
&g
figured out a really nice
> way to do it.
If the endianess isn't corrected for the non-native platform at build
time, I've seen initdb leave a cluster with a completely broken
pg_rewrite (iirc).
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database
reating a restricted
security token from which all administrative group memberships are
removed and then re-execs itself using that token. The child process
doesn't have the privileges to re-elevate itself which is what makes
it safe.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Orac
On 12-Feb-08, at 1:02 PM, Gregory Stark wrote:
"Dave Cramer" <[EMAIL PROTECTED]> writes:
On 12-Feb-08, at 10:37 AM, Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Dave Cramer wrote:
reindex table user_profile;
ERROR: deadlock detected
DETAIL: P
On 12-Feb-08, at 5:05 PM, Tom Lane wrote:
Dave Cramer <[EMAIL PROTECTED]> writes:
The other process is inserting into the user_profile table.
Did either transaction do anything else in the same transaction
previously?
It would appear that the insert is running before the reindex
On 12-Feb-08, at 10:37 AM, Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Dave Cramer wrote:
reindex table user_profile;
ERROR: deadlock detected
DETAIL: Process 32450 waits for AccessExclusiveLock on relation
194689112 of database 163880909; blocked by process 31236.
P
| i |1
| 0 | 0 |0 |0 | 0 | f
| f | f | f |0 ||
This is 100% repeatable
Dave
---(end of broadcast)---
TIP 5: don't forg
On Feb 13, 2008 3:05 PM, Hermann Muster <[EMAIL PROTECTED]> wrote:
> Dave Page schrieb:
> > On Feb 5, 2008 7:52 AM, Hermann Muster <[EMAIL PROTECTED]> wrote:
> >> I also checked the folder C:\Program Files\Common Files\Merge Modules
> >> Microsoft_VC80_C
On Thu, Feb 14, 2008 at 7:56 PM, Dan Armbrust
<[EMAIL PROTECTED]> wrote:
> On Thu, Feb 14, 2008 at 1:31 PM, Dave Page <[EMAIL PROTECTED]> wrote:
>
> > You must have enabled the debugger when you installed (or didn't
> > disable it). You can turn it back
de in the way most compatible with the new server,
effectively doing some of the upgrade process as part of the dump
operation.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Feb 18, 2008 10:05 AM, Hermann Muster <[EMAIL PROTECTED]> wrote:
> Hi Dave,
>
> after testing several combinations I can tell you following, because
> maybe I couldn't make clear what my problem is. The msvcr80.dll is
> correctly installed in the
> C:\WIND
ent or
server) or any part of the server will need the correct version of the
runtimes to be installed.
You can avoid this by building your own libpq.dll using mingw/msys if
you like - that will work just fine with a VC++ built server.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.co
On Feb 18, 2008 3:38 PM, Tony Caduto <[EMAIL PROTECTED]> wrote:
> Dave Page wrote:
> >
> > You can avoid this by building your own libpq.dll using mingw/msys if
> > you like - that will work just fine with a VC++ built server.
> >
> >
>
> Hi Dave,
>
> CoCreateGUID() ?
> >
> > or does uuid-ossp do this for me?
>
> I'm no expert on this topic, but since nobody else has responded ...
>
> I'm unsure why you would do anything other than install uuid-ossp.
> Anything else is going to be a hack, and uuid-
, bundling such utilities would be a big no-no. Imagine the
docs - pgAdmin supports SSL encryption and Kerberos authentication,
but if you wish to back or restore your databases you'll need to turn
off those requirements in the server.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
led now, so no need for special versions
of the import libraries any more.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On Feb 19, 2008 6:33 PM, Josue Gomes <[EMAIL PROTECTED]> wrote:
> On 2/19/08, Dave Page <[EMAIL PROTECTED]> wrote:
> > On Feb 19, 2008 1:16 PM, Josue Gomes <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > I'm just wondering why lib
g
uuid-ossp wasn't ported to Windows.
citext is not part of core PostgreSQL or something we have any
intention to include in the Windows distribution at this time.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The HOT PostgreSQL Company
-
gt; an account right away (done). Regarding "where it lives", what is the
> constraint that prevents it from residing on the main site? Space? Money?
A postgresql.org wiki to replace techdocs is being worked on, per
recent discussion on -www, however it takes a little more effort t
On Mon, Mar 3, 2008 at 6:13 PM, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Dave Page wrote:
>
> > A postgresql.org wiki to replace techdocs is being worked on, per
> > recent discussion on -www, however it takes a little more effort than
> > a standalone one as we
PostgreSQL in the UK.
* Dave Page, pgAdmin lead developer and PostgreSQL Core Team member -
discussing how the PostgreSQL project works.
* Chris Fewtrell, Claranet - describing Claranet's Postgres-based
order management and invoicing system, Messina.
* Duncan Beeby, EnterpriseDB - discussing
I found some posts be developers discussing this issue last Jan. and Nov.. See
link below.
http://search.postgresql.org/search?m=1&q=cache+lookup+failed+for+relation&l=&d=&s=
But have not been able to find any suggestion on how an end user can use to get
around this problem. Basically, we have
.org, as all our sites are, (with
the exception of pgFoundry)
> I was just surprised to get an email booting me off the aggregator.
I've certainly seen requests to keep introductory paragraphs to a
reasonable length in the past - did you not get them as well?
--
Dave Page
EnterpriseDB UK L
omain names, or even
site names as far as is practical. The only exceptions are pgFoundry,
and some backend infrastructure.
Other sites, such as planetpostgresql an postgresqldocs, are not run
as part of the PostgreSQ
On 3/8/08, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Dave Page wrote:
>
might have caused this problem and how can I avoid/prevent it in
the future
Q: Can I salvage my foo and foo_standby DBs?
Thanks
-dave
Of Gauthier, Dave
Sent: Tuesday, March 11, 2008 9:31 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Database OID x now seems to belong to "foo"
Hi:
Trying (and failing) to attach to my DBs. Getting...
database "foo_standby" has disappeared form
I'm running 8.2.0 on Linux.
The postgres.conf has...
#autovacuum = off
(commented out) which lead me to believe that by default, it's on. And
I'm assuming that it's vacumming the system tables. Are these
assumptions right?
Thanks
-dave
-Original Message-
Fr
Sent: Tuesday, March 11, 2008 12:51 PM
To: Alvaro Herrera
Cc: Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database OID x now seems to belong to "foo"
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Gauthier, Dave wrote:
>> I'm running 8.2.0 on
inux
Thanks
-dave
ed a PostgreSQL Community logon. If
you do not already have an account, you can register one at
http://www.postgresql.org/community/signup
--
Dave Page
PostgreSQL Core Team
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
--
Sent via pgsql-general mailing list (pgsql-general@pos
V8.2.0 on Linux
Can't rename a db, complains that it doesn't exist. Yet psql -l shows
that it does and I can connect to it ???
mmdcc228_SETUP(120)% psql stdb2 -c "alter database stdb rename to
stdb_tmp"
ERROR: database "stdb" does not exist
mmdcc228_SETUP(121)% psql -l
List of
projects in the contrib directory.
Dave
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200803121533
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkfYMBMACgkQvJuQZxSWSsjmmwCg1JvB0G2py
'm thinking of dumping all the problem DBs, deleting them,
recreating and reloading.
-dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dean Gibson (DB
Administrator)
Sent: Thursday, March 13, 2008 12:45 PM
To: pgsql-general
Subject: Re: [GENERAL] Can
ne you can get round the second one by building your software
so it supports PostgreSQL as well - that way you don't 'require
customes to install MySQL'.
As for the hardware one, well, that just confirms everything I
previously thought about MySQL that is unrepeatable where minors
s the user's choice what DBMS he
uses. That way you aren't 'requiring them to install MySQL'. MySQL
cannot hold you liable if a customer chooses to use your closed source
Java/JDBC app with their DBMS if you didn't require it.
--
Dave Page
EnterpriseDB UK Ltd: http://www.
there is a problem with the
desgin of the database tables.
Dave.
begin:vcard
fn:David Potts
n:Potts;David
x-mozilla-html:FALSE
version:2.1
end:vcard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
log_min_duration_statement to 0,
then it will log ALL statements, which could also give you what you
want if you want to see all SQL statements.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Dave
have a backup and want to delete the DB, but can't because the
"dropdb" tool says the DB does not exist.
v8.2.0 on Linux (and yes, I've requested an upgrade to 8.2.6)
-dave
oes not exist
STATEMENT: DROP DATABASE stdb;
dropdb: database removal failed: ERROR: database "stdb" does not exist
mmdcc228>
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 11:33 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql
9882 1663 524
"cells" 16384 1663 524
mmdcc228> ls base/
1 10818 10819 16384 16460 19810 19882 597974 823888
-Original Message-
From: Erik Jones [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 12:20 PM
To: Gauthier, Dave
Cc: Tom Lane; pgsql-general@postgresq
le (theint,thestr) values (x.s);
- end
I can do it in a formal declaration of a procedure, and then execute the
procedure. But is there a less formal way?
Thanks
-dave
people from the
company you see working on PostgreSQL. Startups need VC funding to
operate until they become big enough to look after themselves -
without it, we'd be looking for jobs elsewhere and maybe only working
on PostgreSQL in our spare time.
--
Dave Page
Enterpri
On Thu, Apr 3, 2008 at 9:18 AM, Leif B. Kristensen <[EMAIL PROTECTED]> wrote:
> On Wednesday 2. April 2008, Tomasz Ostrowski wrote:
>
> >Go for it. Even 64 (I like round numbers) would not be too much.
>
> Geek test: Do you find the above statement odd?
Sadly, no.
--
D
ich compiler I have to use?
> I don't need to install anything on the client side where is my pgadmin,
> right?
>
It ships with the binary distro of PG 8.3 for Windows.
And, no, you don't need anything except pgAdmin 1.8+ on the client side.
--
Dave Page
EnterpriseDB UK: http
> Do I need to config anything?
No, but where did you get rev 7050 from? That's quite a few revisions
after 1.8.2 was tagged.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
2%2Fpgadmin3-1.8.2-2.zip
>
> Is this version wrong?
No, I forgot it got re-rolled.
Can you supply a debug log showing pgAdmin hanging after you start
debugging? Look under File -> Options -> Logging.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-gener
ers window appears,
> if I click cancel it freezes.
Yeah, there is a known issue when doing that. There is a patch being
tested at the moment.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
s the debugger plugin.
Regardless of that, the files should still have been installed, so
checkout the README for details of how to setup the debugger in the
server:
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/edb-debugger/server/README.pldebugger?rev=1.1
--
Dave Page
Enterprise
On Tue, May 6, 2008 at 5:02 AM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> WIN32 is defined by all Microsoft build tools EXCEPT Visual Studio
> Express Edition 2005's default win32 project, which is why 2005 wasn't
> working but 2008 was.
It certainly is defined o
now that the FAQ appears to be out of date. Magnus, Dave? Can we get
> the Installer FAQ updated?
>
> http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
Will do.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@
the-cuff" comments would be welcome, especially if you
have used both DBs.
Thanks in Advance
-dave
eleases without having to
involve the server packagers.
The reason the msvclibs are no longer present is that the entire
server is built with MS VC++ from 8.3, so the libraries in the lib
directory are the MS VC++ ones. What is no longer shipped is the mingw
libraries.
--
Dave Page
EnterpriseDB UK: htt
ls you how to modify
postgresql.conf to preload the libraries at server start (which you
must do). Once you've done that, just run the pldbgapi.sql script
that's also included to load the api functions into the database you
wish to debug.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.
I hasn't been supported in years and will
almost certain barf on 8.3.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
uld fit more appropriately in the Professional Service list at
http://www.postgresql.org/support/professional_support. I don't know
what moderation criteria is being used there however; Magnus would be
able to tell you if such an entry would be accepted.
Regards, Dave.
--
Dave Page
Ente
and rows is the number of rows actually counted in the table,
if rowsCounted is true (which will be the case if you've forced a
count from the menu, or the row count threshold (under File ->
Options) is >= estimatedRows) .
Suggestions for improvements are welcome.
--
Dave Page
Enterpr
On Thu, Jun 12, 2008 at 9:30 AM, Guillaume Lelarge
<[EMAIL PROTECTED]> wrote:
>
> They don't use the same algorithms.
>
Which, it should be noted, is intentional, so pgAdmin has a chance to
warn you if your autovac settings are screwy.
--
Dave Page
EnterpriseDB UK: http://
ave been
unable to find anything helpful on google.
Can anyone assist me?
Would it be preferable to create a separate database for this information?
Regards,
Dave Coventry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
On Wed, Jun 18, 2008 at 1:11 PM, David <[EMAIL PROTECTED]> wrote:
> Hi Dave.
>
> Did you intentionally mail me off-list? On-list is generally better so
> other people can give suggestions.
No, sorry.
I've just joined the list and am a little unused to it's mecha
es the question, if I run:
SELECT '123'::int;
What conversion is actually happening here?
Any answers are much appreciated,
thanks
Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lls into int4in,
and then dynamically load this function, and finally update the
corresponding rows in pg_proc? Is this even possible?
thanks for your explanation Tom,
Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
epts. Maybe it's only useful to former MySQL users
thanks,
Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Jun 27, 2008 at 3:37 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 26/06/2008 17:43, Ludwig Kniprath wrote:
>>
>> As far as I know pgadmin uses gtk,
>
> Correct me if I'm wrong, but I don't think PgAdmin uses gtk on Windows.
No,
s to be able to join PurchaseOrder
and WorkOrder to get the set of PurchaseOrder's that have been
assigned WorkOrderRef's. As I understand it, FK's are generally used
for 1 to many relationships where as this is expressing a 1 to 1
relationship.
I would be very grateful for any assi
Hi:
A superuser cannot vacuum tables. The error message is "WARNING: skipping
"thetable" --- only table or database owner can vacuum it"
The superuser was defined like this...
create role cover_super SUPERUSER LOGIN;
grant allon database cover to cover_super;
grant all privileges
On Jun 3, 1:04 am, wmo...@potentialtech.com (Bill Moran) wrote:
> In response to Dave Clarke :
>
>
>
>
>
> > I have a table that I'm trying to refactor and I'm by no means a SQL
> > expert (apologies if I'm posting to the wrong group). The table in
&
as a super user BTW) that is bogged
down trying to load the DB. So the high priority job is just 1 out of 7
contenders for the DB. I'd like it to be more like the DB loader gets 50% of
the resources while the reports get 50% altogether.
Can this be controlled in PG?
Thanks.
-dave
thing as
reliable, performant and well tested would take a significant amount
of effort for little, if any, gain.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
nk of it.
Please move the index page to the wiki or pugs site. The media server
is *only* supposed to host the files - we don't want any HTML content
on there.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
On Thu, Jun 11, 2009 at 7:13 PM, Josh Berkus wrote:
> Dave,
>
>> Please move the index page to the wiki or pugs site. The media server
>> is *only* supposed to host the files - we don't want any HTML content
>> on there.
>
> Oh, ok. I'll put a plac
stem-supplied rint() function
> does.
If they are our packages, then 8.2 was built with mingw/msys, and 8.3 with VC++.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Hi List
I am trying to load some data points stored as lat/long values
Q. Do I convert the degree values (0-59.59) to a decimal value in range
0-100, or is setting the right srs value good enough?
Dave.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
y they tend to
want you to be able to prove to them that your backups are good.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it's good not to agree with the premises underlying a
> question, and I believe this is one of those times.
Auditors can be a funny breed.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
ten done by finance people who will
simply box-tick 'verified backups' before reporting to the board or
regulator, unlike an IT auditor who will look at the systems as a
whole and judge the processes based on their technical merit.
Anyway - this is pre-beer conference talk...
--
Dave Page
ofiler. That would help
> automate the first part of this, at least. Anybody know the status
> of that project?
There is a profiler in the debugger source tree. Iirc, it dumps it's
data out to an XML in a not-so-friendly manner. I haven't ever tested
it, so it may have been broken since
e members were behind the sarin gas attacks on
the Tokyo subway.
The turtle was the original logo at Berkeley I believe.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
/opt/PostgreSQL/8.4/lib/libuuid* to somewhere else (create a backup
directory somewhere), and run ldconfig, everything should return to
normal. You'll probably need to reboot to get the theme back.
I get a fix sorted out.
Thanks for the report!
--
Dave Page
EnterpriseDB UK: http://www.enter
On Wed, Jun 24, 2009 at 8:09 PM, Dave Page wrote:
> I get a fix sorted out.
It seems my colleagues in India are one step ahead of us all :-)
http://git.postgresql.org/gitweb?p=edb-installers.git;a=commit;h=de100d9f27628a69d5f94529ce1ad0cb10f183f9
--
Dave Page
EnterpriseDB UK: h
y
things would suddenly break 'after a few hours'
> What shoud I do and how can I be notified when the installers will be
> updated?
8.4.0 is due to be released on Monday.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-ge
amed statements. The driver always uses prepared
statements
Dave
Hi CMJ,
If you are using WebNMS framework with hibernate, can you check if you have
done this:
*ConfigReader configReader = ConfigReader.getInstance();
configReader.modifyHbmToDdl(true);
*
Thanks,
Saurabh
On Wed, Jun 24, 2009 at 6:06 PM, CM J wrote:
> Hi ,
>
> I
able and the value in
pg_class.reltuples. i forget the exact algorithm off-hand, but it
takes the size of the table into account, and is looking for a %age
difference between the value, not a set number of rows.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-gene
e engineering or are just not interested in the first place.
>
> Someone I know used to work at a nuclear power and research facility
> (No Dave, someone else) and told me an interesting story.
Yet bizarrely it's almost identical in meaning to a story I did tell
you not so l
ing with many database objects on PostgreSQL servers.
Similar options are present for EnterpriseDB, Greenplum and Slony help.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
he old beta/rc directories. The
changes should show up in the next few hours.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e, otherwise pg_dump 8.3 should have complained about be used
with 8.4.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ucts/postgres_plus/overview.do#ui-tabs-6
>> 8
>
> That page refers to the Postgres Plus product. The community product
> packaged by enterprisedb is something different. I thought we had
> pgagent as a stackbuilder application, but it seems I was mistaken.
> Dave?
pgAgent
Hi:
Running 8.3.4 on Linux.
>From inside a stored procedure, is there a way to capture the linux user
>(environment var = $USER) that is attached to the DB?
A simplistic (though meaningless) example would be echo $USER from something
like "select get_linux_user()".
Thanks
-dave
Are there any GUI apps out there that can be used to edit (insert, update,
delete) table data? SOmething with enough smarts to sniff out constraint
violations and report accordingly. Also, ability to eval constraints at commit
time inside a transaction (option to rollback of course).
Thanks f
general-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Thursday, August 27, 2009 5:32 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI to edit a table's content
Gauthier, Dave wrote on 27.08.2009 23:17:
> Are there any GUI apps out there that can be used to edit
have saved
me this work?
2. Can I submit my scripts and have the msvc tools reviewed/updated?
Thanks,
Dave Huber
This electronic mail message is intended exclusively for the individual(s) or
entity to which it is addressed. This message, together with any attac
0023 0004
0023
I can make some assumptions to interpet " 0004 0023" as a 32-bit
length followed by length bytes (length = 4, data = 0x23 = 35), but I have no
clue how to interpret the leading 20 bytes of this data.
I appreciate any help I can get.
Thanks,
301 - 400 of 1235 matches
Mail list logo