Re: [GENERAL] Universal libpq.a ?

2008-02-05 Thread Dave Page
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

Re: [GENERAL] Universal libpq.a ?

2008-02-05 Thread Dave Page
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

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-05 Thread Dave Page
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 --

[GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Dave Livesay
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

Re: [GENERAL] Is PG a moving target?

2008-02-10 Thread Dave Livesay
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

Re: [GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Dave Livesay
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

Re: [GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Dave Livesay
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

Re: [GENERAL] ERROR: expected just one rule action

2008-02-11 Thread Dave Page
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

Re: [GENERAL] ERROR: expected just one rule action

2008-02-11 Thread Dave Page
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

Re: [GENERAL] WINDOWS INSTALLATION TIPS

2008-02-12 Thread Dave Page
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

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
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

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
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

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
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

[GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
| 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

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-13 Thread Dave Page
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

Re: [GENERAL] performance issues on windows with 8.3.0?

2008-02-15 Thread Dave Page
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

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Dave Page
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

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-18 Thread Dave Page
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

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-18 Thread Dave Page
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

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-18 Thread Dave Page
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, >

Re: [GENERAL] Analogue to SQL Server UniqueIdentifier?

2008-02-18 Thread Dave Page
> 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-

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-19 Thread Dave Page
, 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

Re: [GENERAL] MS library files

2008-02-19 Thread Dave Page
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?

Re: [GENERAL] MS library files

2008-02-19 Thread Dave Page
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

Re: [GENERAL] UUID-OSSP for windows.

2008-02-27 Thread Dave Page
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 -

Re: [GENERAL] PostgreSQL Docs - Community Documentation

2008-03-03 Thread Dave Page
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

Re: [GENERAL] PostgreSQL Docs - Community Documentation

2008-03-03 Thread Dave Page
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

[GENERAL] PostgreSQL UK Conference 2008

2008-03-05 Thread Dave Page
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

[GENERAL] cache lookup failed for relation X

2008-03-08 Thread Dave Wurtz
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

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

2008-03-08 Thread Dave Page
.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

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

2008-03-08 Thread Dave Page
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: >

[GENERAL] Database OID xxxxx now seems to belong to "foo"

2008-03-11 Thread Gauthier, Dave
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

Re: [GENERAL] Database OID xxxxx now seems to belong to "foo"

2008-03-11 Thread Gauthier, 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

Re: [GENERAL] Database OID xxxxx now seems to belong to "foo"

2008-03-11 Thread Gauthier, Dave
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

Re: [GENERAL] Database OID xxxxx now seems to belong to "foo"

2008-03-11 Thread Gauthier, Dave
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

[GENERAL] Array load from remote site through Perl/DBI

2008-03-11 Thread Gauthier, Dave
inux Thanks -dave

[GENERAL] PostgreSQL user documentation wiki open for business

2008-03-12 Thread Dave Page
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

[GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-12 Thread Gauthier, Dave
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

Re: [GENERAL] pain of postgres upgrade with extensions

2008-03-12 Thread Dave Potts
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

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-13 Thread Gauthier, Dave
'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

Re: [GENERAL] postgre vs MySQL

2008-03-14 Thread Dave Page
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

Re: [GENERAL] postgre vs MySQL

2008-03-14 Thread Dave Page
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.

[GENERAL] Loging of postgres requests

2008-03-15 Thread Dave Potts
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

Re: [GENERAL] Loging of postgres requests

2008-03-15 Thread Dave Potts
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

[GENERAL] Catch-22

2008-03-17 Thread Gauthier, 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

Re: [GENERAL] Catch-22

2008-03-17 Thread Gauthier, 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

Re: [GENERAL] Catch-22

2008-03-17 Thread Gauthier, Dave
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

[GENERAL] begin-end blocks in psql

2008-03-21 Thread Gauthier, Dave
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

Re: [GENERAL] IBM investing in EnterpriseDB

2008-03-26 Thread Dave Page
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

Re: [GENERAL] simple update queries take a long time - postgres 8.3.1

2008-04-03 Thread Dave Page
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

Re: [GENERAL] edb-debugger, debugging pl/pgsql

2008-04-07 Thread Dave Page
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

Re: [GENERAL] edb-debugger, debugging pl/pgsql

2008-04-07 Thread Dave Page
> 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

Re: [GENERAL] edb-debugger, debugging pl/pgsql

2008-04-07 Thread Dave Page
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

Re: [GENERAL] edb-debugger, debugging pl/pgsql

2008-04-07 Thread Dave Page
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

Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

2008-04-09 Thread Dave Page
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

Re: [GENERAL] Custom C function - is palloc broken?

2008-05-06 Thread Dave Page
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

Re: [GENERAL] Custom C function - is palloc broken?

2008-05-06 Thread Dave Page
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@

[GENERAL] PG -v- MySQL

2008-05-13 Thread Gauthier, Dave
the-cuff" comments would be welcome, especially if you have used both DBs. Thanks in Advance -dave

Re: [GENERAL] PostgreSQL 8.3.x Win32-Releases - always without psqlODBC?

2008-05-15 Thread Dave Page
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

Re: [GENERAL] Installing debugger

2008-05-16 Thread Dave Page
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.

Re: [GENERAL] Help with remote connection to remote Postgresql 8.3 Server...

2008-05-29 Thread Dave Page
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

Re: [GENERAL] [ANNOUNCE] PostgreSQL Software Catalogue

2008-06-10 Thread Dave Page
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

Re: [GENERAL] pgAdmin complains about vacuuming required after fresh 8.1 install

2008-06-12 Thread Dave Page
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

Re: [GENERAL] pgAdmin complains about vacuuming required after fresh 8.1 install

2008-06-12 Thread Dave Page
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://

[GENERAL] Controlling write access to a table

2008-06-18 Thread Dave Coventry
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

Re: [GENERAL] Controlling write access to a table

2008-06-18 Thread Dave Coventry
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

[GENERAL] migrating from mysql: need to convert empty string to null

2008-06-18 Thread Dave Lee
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

Re: [GENERAL] migrating from mysql: need to convert empty string to null

2008-06-18 Thread Dave Lee
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

Re: [GENERAL] migrating from mysql: need to convert empty string to null

2008-06-18 Thread Dave Lee
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

Re: [GENERAL] Windows Crash

2008-06-27 Thread Dave Page
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,

[GENERAL] Foreign Key question

2009-06-01 Thread Dave Clarke
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

[GENERAL] non-owner superuser needs to be able to vacuum

2009-06-03 Thread Gauthier, Dave
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

Re: [GENERAL] Foreign Key question

2009-06-03 Thread Dave Clarke
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 &

[GENERAL] Server admin for Clients ?

2009-06-07 Thread Gauthier, Dave
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

Re: [GENERAL] Can postgresql store its data on raw device now?

2009-06-09 Thread Dave Page
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

Re: [sfpug] [GENERAL] "Rails and PostgreSQL" now up on media.postgresql.org

2009-06-11 Thread Dave Page
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

Re: [sfpug] [GENERAL] "Rails and PostgreSQL" now up on media.postgresql.org

2009-06-11 Thread Dave Page
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

Re: [GENERAL] Rounding incompatibility

2009-06-15 Thread Dave Page
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

[GENERAL] Loading long lat values converting degrees to decimal values

2009-06-21 Thread Dave Potts
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

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread Dave Page
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

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread Dave Page
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

Re: [GENERAL] [BUGS] Integrity check

2009-06-23 Thread Dave Page
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

Re: [GENERAL] Explaining functions.

2009-06-23 Thread 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

Re: [GENERAL] just curious

2009-06-24 Thread Dave Page
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:

Re: [GENERAL] 8.4 RC1 on ubuntu 9.04 jaunty, problems after install

2009-06-24 Thread Dave Page
/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

Re: [GENERAL] 8.4 RC1 on ubuntu 9.04 jaunty, problems after install

2009-06-24 Thread Dave Page
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

Re: [GENERAL] 8.4 RC1 on ubuntu 9.04 jaunty, problems after install

2009-06-25 Thread Dave Page
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

Re: [GENERAL] JDBC prepared statements & server-side prepared statements

2009-06-25 Thread Dave Cramer
amed statements. The driver always uses prepared statements Dave

Re: [GENERAL] [JDBC] Postgres 8.3.7 -- EOF on client connection

2009-06-25 Thread Saurabh 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

Re: [GENERAL] Vacuum on the database versus individual tables.

2009-06-25 Thread Dave Page
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

Re: [GENERAL] masking the code

2009-06-30 Thread Dave Page
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

Re: [GENERAL] Documentation - PgAdmin

2009-07-06 Thread Dave Page
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

Re: [GENERAL] Windows installer for pg-8.4 confusion

2009-07-06 Thread Dave Page
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

Re: [GENERAL] pg_dump PostgreSQL 8.4

2009-07-09 Thread Dave Page
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

Re: [GENERAL] 8.4.0 installer for Windows from EnterpriseDB does not seem to include pgagent

2009-07-23 Thread Dave Page
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

[GENERAL] Getting linux $USER (and perhaps other env vars) in PL/pg-sql?

2009-08-07 Thread Gauthier, Dave
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

[GENERAL] GUI to edit a table's content

2009-08-27 Thread Gauthier, 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

Re: [GENERAL] GUI to edit a table's content

2009-08-28 Thread Gauthier, Dave
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

[GENERAL] Update /src/tools/msvc to VC++ 2008

2009-08-28 Thread Dave Huber
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

[GENERAL] binary format of array stored as text

2009-09-02 Thread Dave Huber
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,

<    1   2   3   4   5   6   7   8   9   10   >