Re: [GENERAL] PostgreSQL on Windows x64

2008-08-19 Thread Dave Page
On 8/19/08, Goboxe <[EMAIL PROTECTED]> wrote: > Dave, > > Thanks for the link. np. > Our app now running using EnterpriseDB 8.2 on x86. > Plan to test them on x64 server once we got it. > > Do you know if jdbc, npgsql, PostgreSQL ANSI odbc drivers bundled in > En

Re: [GENERAL] temp schemas

2008-08-28 Thread Dave Page
em Objects option is turned on (it defaults to off). -- 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] temp schemas

2008-08-29 Thread Dave Page
that code is filtering out system objects client side for some reason. I'll look at that. -- 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] temp schemas

2008-09-01 Thread Dave Page
On Fri, Aug 29, 2008 at 2:07 PM, Dave Page <[EMAIL PROTECTED]> wrote: > On Fri, Aug 29, 2008 at 1:40 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote: > > Oh, that's weird - that code is filtering out system objects client > side for some reason. I'll look at that. I&#

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

2008-09-09 Thread Dave Page
cutable you've built. I'll look at a solution for the installer - it'll probably have to be the symlink unless anyone else has a better idea... -- 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] Automated Backup On Windows

2008-09-09 Thread Dave Page
uldn't have a problem getting an account there. The postgresqldocs site >> ended up being temporary and shutdown once the official Wiki was available. >> > Well I still can't create an account all it says is Login no create account > button or screen anywhere?

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

2008-09-09 Thread Dave Page
On Tue, Sep 9, 2008 at 2:23 PM, Benjamin Reed <[EMAIL PROTECTED]> wrote: > On Tue, Sep 9, 2008 at 3:46 AM, Dave Page <[EMAIL PROTECTED]> wrote: > >> I'll look at a solution for the installer - it'll probably have to be >> the symlink unless anyone else has a

Re: [GENERAL] Automated Backup On Windows

2008-09-09 Thread Dave Page
to me :-). PgAdmin should be pgAdmin though, but that's just me being picky :-p -- 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] OS X library path issues for libpq (ver 8.3)

2008-09-09 Thread Dave Page
ions here: > http://developer.apple.com/internet/opensource/postgres.html That's very old. I'd stick with the installer or MacPorts. > If that doesn't work for me, I'll fall back on macports. However, > both of these solutions involve building from source and they may

Re: [GENERAL] OS X library path issues for libpq (ver 8.3)

2008-09-09 Thread Dave Page
thing, or additional libraries from MacPorts (or Fink). You've also got the Tiger SDK and at least some of the iphone SDK there. > Looks like I've got my work cut out for me before I even begin to > develop anything. It's really not that difficult - unless you need universal

Re: [GENERAL] postgres user account on OSX

2008-09-11 Thread Dave Page
uite sure that the EDB binary installer sets /Library/PostgreSQL8 as the > home path, matching the install location. /Library/PostgreSQL/8.3 by default, but yes, that is essentially correct. > The /opt/local/. home path would indicate that you used macports or > similar at some

[GENERAL] "Healing" a table after massive updates

2008-09-11 Thread Gauthier, Dave
Hi: I have a job that loads a large table, but then has to "update" about half the records for various reasons. My perception of what happens on update for a particular recors is... - a new record will be inserted with the updated value(s). - The old record is marked as being obselete. - No

Re: [GENERAL] "Healing" a table after massive updates

2008-09-11 Thread Gauthier, Dave
I might be able to answer my own question... vacuum FULL (analyze is optional) Correct? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave Sent: Thursday, September 11, 2008 10:01 AM To: pgsql-general@postgresql.org Subject

Re: [GENERAL] Windows ODBC Driver

2008-09-11 Thread Dave Page
nd lots of dead links, but no drivers. Can someone > please help me locate a driver so I can connect? http://www.postgresql.org/ftp/odbc/versions/ -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

[GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Gauthier, Dave
Hi: Here's the problem... I have a read-only DB that gets reloaded from scratch every night. This takes several hours and I don't want any late night users to have to wait for this process to complete, so I have 2 DBs. The first DB is the one the users access. Call it "main_db". I load

Re: [GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Gauthier, Dave
andeling remote attaches if I do this? -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2008 3:03 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] connection timeouts and "killing" users On Thu, Sep 11, 2

Re: [GENERAL] connection timeouts and "killing" users

2008-09-11 Thread Gauthier, Dave
PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] connection timeouts and "killing" users On Thu, Sep 11, 2008 at 2:27 PM, Gauthier, Dave <[EMAIL PROTECTED]> wrote: > > How do I get the pids? Is there something specific I should look for in the > ex

[GENERAL] 8.3.3 stability ?

2008-09-17 Thread Gauthier, Dave
Time for an upgrade. How stable is 8.3.3 ? In a nutshell, what does it buy me over 8.2?

Re: [GENERAL] 8.3.3 stability ?

2008-09-18 Thread Gauthier, Dave
ECTED] Sent: Wednesday, September 17, 2008 3:39 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 8.3.3 stability ? On Wed, Sep 17, 2008 at 11:31 AM, Gauthier, Dave <[EMAIL PROTECTED]> wrote: > Time for an upgrade. How stable is 8.3.3 ? > > In a nutshell,

Re: [GENERAL] [HACKERS] macport for libpqxx

2008-09-20 Thread Dave Page
, esp. against the macport libraries. Never built libpqxx or a MacPort), but I'm used to building Postgres and other PG apps and the fu required to get universal binaries. What do you need? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-

Re: [GENERAL] [HACKERS] macport for libpqxx

2008-09-22 Thread Dave Page
On Sat, Sep 20, 2008 at 5:25 PM, Darren Weber <[EMAIL PROTECTED]> wrote: > Hi Dave, > > Thanks for getting back to me. Please find attached a draft Portfile > for libpqxx-2.6.9 (the stable version). It's easy to read the > Portfile to see what is going on. I think

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Dave Page
rent version is 8.3.4 and I'm wondering why there >> are no new rpm's for Opensuse ?!?! > > The answer is quite simply that no one is volunteering to do the work. Oh, I thought you were looking after that build. If it's not being maintained, we'll need to re

Re: [GENERAL] [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit

2008-09-23 Thread Dave Page
l look at doing that. We need the SUSE builds also. Great, thanks Simon. If you can commit to ongoing maintenance then we'll get you on the packagers list so you can get advance notice of releases and having input on the scheduling details. -- Dave Page EnterpriseDB UK: http://www.enterpr

[GENERAL] dynamic sql in PL-Pgsql ?

2008-09-26 Thread Gauthier, Dave
? Thanks -dave

[GENERAL] pl-pgsql, recursion and cursor contexting

2008-09-29 Thread Gauthier, Dave
or example, this was a no-no in Oracle. You had to stuff arrays with the resuts from looping in cursors, and then make the recursive call in a subsaquent loop on the arrays. Thanks -dave

Re: [GENERAL] pl-pgsql, recursion and cursor contexting

2008-09-29 Thread Gauthier, Dave
In all fairness, I believe in Oracle I was declaring explicit cursors (by name) and recursive calls would fail outright with complaints that the cursor was already open. There was (to the best of my knowledge) nothing like the "for in loop..." construct in Oracle's PLSQL l

[GENERAL] Running 2 versions of postgres on the same server at the same time ???

2008-09-30 Thread Gauthier, Dave
same time. Wil lthere be any problems if I start v8.3.4 while v8.2.5 is running? Thanks -dave

[GENERAL] pg_restore stalled ???

2008-10-01 Thread Gauthier, Dave
Hi: I did a pg_dump of a v8,2,5 db using... pg_dump -C -file=thedb.pgdump thedb I'm attempting to restore in v8.3.4 using pg_restore running under v8.3.4 using... pg_restore -f mydb.pgdump -i -C It doesn;t appear to be doing anything. ps shows no cpu usage. du shows no increas

Re: [GENERAL] pg_restore stalled ???

2008-10-01 Thread Gauthier, Dave
Ya, I aborted it and am successfully restoring the DB using psql. It's sure taking up cycles and disk space now :-) -dave -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 11:52 AM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Su

[GENERAL] Ideas on how to use external perl script

2008-10-01 Thread Gauthier, Dave
to proceed? Thanks -dave

[GENERAL] That was easy

2008-10-01 Thread Gauthier, Dave
I just ported my whole DB instance, 4 db's inside with roles, triggers, stored procedures, etc... from v8.2.5 to v8.3.4. After the initdb, I mimiced the mods I had in the postgres.conf and pg_hba.conf files to v83. Then I used pg_dumpall and psql to do the move. That was far and away the easiest D

Re: [GENERAL] W2K8

2008-10-02 Thread Dave Page
On Thu, Oct 2, 2008 at 1:25 PM, Howard Cole <[EMAIL PROTECTED]> wrote: > Hello all, > > Does postgres 8.3.* work on Windows w2k8 x64? I could not find any reference > to this on the website. It should work just fine. -- Dave Page EnterpriseDB UK: http://www.enterprisedb

Re: [GENERAL] W2K8

2008-10-02 Thread Dave Page
report that it *doesn't* work, I think you can >> safely >> assume that it works :-) >> > > Thanks Magnus, Dave. On those assertive confirmations I shall get one > ordered! I'll assume you'll pay the bill to revert to W2k3 if it doesn't ;) Probably not

Re: [GENERAL] failed to install posgrest

2008-10-03 Thread Dave Page
27;s found, your existing data directory is from PostgreSQL 8.2. You should therefore install the latest 8.2 RPM (or build from source), as the one-click installer is not available for the 8.2 series. Why you have a PG 8.2 data directory under /usr/local/postgresql_8.3 is another question entir

Re: [GENERAL] failed to install posgrest

2008-10-03 Thread Dave Page
On Fri, Oct 3, 2008 at 10:13 PM, Joshua Drake <[EMAIL PROTECTED]> wrote: > On Fri, 3 Oct 2008 22:12:08 +0100 > "Dave Page" <[EMAIL PROTECTED]> wrote: > >> On Fri, Oct 3, 2008 at 9:31 PM, Joshua Drake <[EMAIL PROTECTED]> >> wrote: >> &g

Re: [GENERAL] failed to install posgrest

2008-10-03 Thread Dave Page
(as sponsored by Command Prompt), or Fink, or MacPorts, or FreeBSD Ports or Debian/Ubuntu APT, or the SUSE download site... So what's your point exactly? Do we only offer support for source, Win32, Solaris and PGDG RPM builds downloaded form ftp.postgresql.org here now? -- Dave

Re: [GENERAL] failed to install posgrest

2008-10-03 Thread Dave Page
9(!) locales it found on your system is presumably es_ES. Scroll your terminal back up until you find it and enter it's number. Or, just select the default option (1) which will setup the locale to whatever initdb finds you are already running, which presumably is Spanish. -- Dave Page Enter

Re: [GENERAL] failed to install posgrest

2008-10-04 Thread Dave Page
On Sat, Oct 4, 2008 at 12:36 AM, Joshua Drake <[EMAIL PROTECTED]> wrote: > Easy Dave. I was simply trying to figure out where the .bin came from, > which in turn came with a recommendation which I stand by that no one > should be using anything but operating supported packages (in

Re: [GENERAL] failed to install posgrest

2008-10-04 Thread Dave Page
as getting at was why the OP appears to have an 8.2 data directory under a directory called 'postgresql_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] Standalone Windows Installation

2008-10-04 Thread Dave Page
s, where it's far, far less common to use a myriad of dependencies from different sources, it's handled by merge modules and the installer, which are used to ensure consistent deployment of dependencies, whilst keeping the installer self-contained and free of user visible dependencies.

Re: [GENERAL] Standalone Windows Installation

2008-10-04 Thread Dave Page
with PostgreSQL 8.0, in which we installed completely un-versioned SSL libraries as well as libpq.dll in %SYSTEM32%. Suffice it to say, we fixed this. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] Standalone Windows Installation

2008-10-04 Thread Dave Page
t have been that libraries in the PG lib directory weren't correctly finding the runtimes in the bin directory (which would usually work for regular DLLs). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] failed to install posgrest

2008-10-04 Thread Dave Page
fferent than it is of supporting most of the other packages that are out there. My point is, that being on ftp.postgresql.org doesn't mean anything in terms of our ability to support a given package. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mail

Re: [GENERAL] postgres/postgis

2008-10-06 Thread Dave Page
need to build them yourself from source for use with that package at the moment. We're working on an installer, but it's not ready yet. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

Re: [GENERAL] postgres user account on OSX

2008-10-14 Thread Dave Page
using a binary installer and I have no idea > how to get rid of that "CFPreference". % sudo dscl . delete /users/postgres will delete the user account that the binary installer created. I assume the MacPort will recreate it as it likes. -- Dave Page EnterpriseDB UK: http://www.

Re: [GENERAL] Annoying Reply-To

2008-10-17 Thread Dave Coventry
lt reply-to to go to the list, but I'm not really bothered about it. My 2 cents. Disclaimer: If we are not talking about the default 'reply-to' behaviour of this list, please ignore this post; I came upon the thread late and it is possible that I am at cross purposes. Kind reagards

[GENERAL] statement_timeout by host?

2008-10-21 Thread Dave Fry
Hello. Is it possible to set a statement_timeout by host, such that requests from only that host will be limited?

Re: [GENERAL] Annoying Reply-To

2008-10-23 Thread Dave Coventry
made by Bill that 'only one person' might feel that the reply-to configuration could be improved, and I feel compelled to say that, while I might not be driven to complain about the list behaviour myself, I do feel that the OP does have a point. And that's all that I'm going to sa

[GENERAL] Escape wildcard problems.

2008-10-24 Thread Gauthier, Dave
cont\_%'; name -- cgidvcontrol x8idvcontrol etc I would expect to NOT see these because the "cont" is not preceded by and followed by an underscore (because I escaped them with \). Please advise. Thanks -dave

Re: [GENERAL] stackbuilder updates

2008-10-24 Thread Dave Page
ange it during install). Hmmm, that's perhaps an oversight in how ApachePHP is registered in StackBuilder. I'll look at that. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] statement_timeout by host?

2008-10-25 Thread Dave Fry
That's definitely an option, and that's what I had slated to use as my backup plan. But I wanted to make sure there wasn't the ability to do it by host before I went down that path, as it would be a somewhat cleaner fit in our setup. Thanks! Dave On Tue, Oct 21, 2008 at 1:57

Re: [GENERAL] using plpgsql debuggers

2008-10-29 Thread Dave Page
ly great but I haven't figured out how to use it yet? > > I can't figure out how to invocate the server (target) side in order to then > get the proxy to connect to it. Run pgAdmin with the plugin enabled in your database, and right-click a function and select one of the debugging

Re: [GENERAL] using plpgsql debuggers

2008-10-29 Thread Dave Page
ow just by reading. My colleague posted an example of the API usage a while back - you can find it at http://archives.postgresql.org/pgsql-hackers/2007-09/msg00241.php -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] dumbofs - a postgresql filesystem

2008-11-04 Thread Dave Page
though. > > more info at http://yiannnos.com/dumbofs Neat. No idea what I'd use it for, but it's an interesting idea! BTW, there's a typo on the webpage: here's a list of this that *could* go into dumbofs should be here's a list of things that *could* go into dumbofs

Re: [GENERAL] Trying Compile libpq.dll with VC++ 9.0, but need help

2008-11-17 Thread Dave Page
tools) That's the easiest way of all: ./configure --with-openssl cd src/interfaces/libpq make all should do the trick. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: ht

Re: [GENERAL] Scheduling backup via PgAgent

2008-11-20 Thread Dave Page
nt of my work for the sake of > knowledge share. I think you forgot the attachment. It would be useful if you could add it to the wiki though: http://wiki.postgresql.org/ -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgre

Re: [GENERAL] Password and Installation

2008-11-21 Thread Dave Page
ere? Can my old password > somehow be retrieved? No - it's a Windows user account, so the password cannot be retrieved any more than your Administrator password can. I don't know what the equivalent on Vista is, but on XP, open the Computer Management tool under Administrative Too

Re: [GENERAL] pgAdmin error

2008-11-22 Thread Dave Page
the data directory. iirc, it does that by insisting that all paths are relative, and don't contain .. I assume your data is not in /etc/postgresql/8.3/main - just your config? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (p

Re: [GENERAL] Password and Installation

2008-11-24 Thread Dave Page
Hi Andrew, On Mon, Nov 24, 2008 at 12:10 AM, Andrew Maeng <[EMAIL PROTECTED]> wrote: > Thanks Dave. I can't seem to find the SQL user in the user accounts though. > All i can see is the asp.net machine account. Look for a user called 'postgres', not SQL. > I&#

Re: [GENERAL] mail list traffic

2008-11-24 Thread Dave Page
ions? Didn't I send you a copy of the prototype code I'd written to do that? The biggest issue for third party code is that we need to preserve our existing URLs. /D -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] [pgadmin-support] Separate Sessions?? (View data <-> Query tool)

2008-11-28 Thread Dave Page
e difference is actually very small). > You probably get some annoying error when you try to edit a normal select > view from access, though. Yeah, it's actually pretty hard to do in pgAdmin, because we have no easy way of telling what the effects of the update are. *thinks* - I wonder i

Re: [GENERAL] concurrent users

2008-12-03 Thread Dave Page
oad/pgagent.php -- 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] two postgres server seeing the same data

2008-12-03 Thread Dave Page
ook for a different solution (Slony? Bucardo?) -- 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] Job scheduling in Postgre

2008-12-04 Thread Dave Page
but I haven't seen much push > in that direction. It would need to be ported to C first (it's currently wxWidgets/C++). We are packaging it separately now though. http://www.pgadmin.org/docs/1.8/pgagent.html http://www.pgadmin.org/download/pgagent.php -- Dave Page Enterp

Re: [GENERAL] Job scheduling in Postgre

2008-12-04 Thread Dave Page
atabases on alternate servers - a feature required for use with hot standby servers. Each job can have one or more schedules attached to it. Schedules are defined in a vaguely cron-like way, and include date/time based exception rules (so you can do things like 'run every day except for the 25/

Re: [GENERAL] Application Stack Builder - proxy error

2008-12-05 Thread Dave Page
ovide. You can grab the installer manually from http://pgfoundry.org/frs/?group_id=1000256&release_id=1266 and copy that around in whatever way you need. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

Re: [GENERAL] Application Stack Builder - proxy error

2008-12-05 Thread Dave Page
On Fri, Dec 5, 2008 at 3:56 PM, Lee Keel <[EMAIL PROTECTED]> wrote: > -Original Message- >>> You can grab the installer manually from >>> http://pgfoundry.org/frs/?group_id=1000256&release_id=1266 and copy >>> that around in whatever way you need

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-12 Thread Dave Page
's lightning talk ;)  : http://vimeo.com/7561950 Meh - that one could have gone better. Possibly if I was slightly less hungover for example (whose idea was it to have Cognac after beer, red wine and scotch anyway?) :-) Do you have any more videos? -- Dave Page EnterpriseDB UK: http:

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 8:44 AM, Magnus Hagander wrote: > On Thu, Nov 12, 2009 at 09:41, Dave Page wrote: >> On Thu, Nov 12, 2009 at 12:18 AM, Thom Brown wrote: >> >>> I second that.  I wasn't sure quite what to expect, but it was very >>> well organised a

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-12 Thread Dave Page
2009/11/12 Alvaro Herrera : > Devrim GÜNDÜZ escribió: >> On Thu, 2009-11-12 at 08:41 +0000, Dave Page wrote: >> > (whose idea was it to have Cognac after beer, red >> > wine and scotch anyway?) >> >> **Perfect** idea -- but it was not me ;) > > May

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-12 Thread Dave Page
t; Whoever your are... Cheers Mate! ;) > > BR, > Pedro > > > On 11/12/2009 05:24 PM, Dave Page wrote: >> 2009/11/12 Alvaro Herrera : >>> Devrim GÜNDÜZ escribió: >>>> On Thu, 2009-11-12 at 08:41 +, Dave Page wrote: >>>>> (whose idea w

[GENERAL] column aliases?

2009-11-13 Thread Gauthier, Dave
Hi: Does PG support the notion of a colum alias? I'm not talking about "select foo as fii", I'm thinking more along the lines of supporting 2 different names for the same column. For example, a tablle has a column named "social_security_number". Queries may ask for this column as define

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-14 Thread Dave Page
On Sat, Nov 14, 2009 at 9:59 AM, Thom Brown wrote: > 2009/11/12 Dave Page >> >> On Thu, Nov 12, 2009 at 12:18 AM, Thom Brown wrote: >> >> > I second that.  I wasn't sure quite what to expect, but it was very >> > well organised and executed.  And tha

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-14 Thread Dave Page
th a bunch of memory cards for next year, and record everything. I know other PUGs/conferences series have done that with good results. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-14 Thread Dave Page
On 11/14/09, Andreas 'ads' Scherbaum wrote: > On Sat, Nov 14, 2009 at 10:52:22AM +, Dave Page wrote: >> >> I think we should spend some money and buy some inexpensive cameras >> and tripods along with a bunch of memory cards for next year, and >>

Re: [GENERAL] [pgeu-general] pgday.eu

2009-11-16 Thread Dave Page
;> from password-protected to completely private. Fixed now. >> >> Thom >> > > Koen Marten's lightning talk video now given the go-ahead: > http://vimeo.com/7603429 > > Thom > -- 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

[GENERAL] specifying a password on the cmd line for db connect

2009-11-16 Thread Gauthier, Dave
Hi: Is there a way to require and specify a password at the cmd line for a connect? At first glance... --username foo --password fee would seem to be what I want. But it just prompts me for a password (after interpreting "fee" as the DB name). Thanks In Advance

[GENERAL] column does not exist error

2009-11-18 Thread Dave Coventry
Tearing my hair out, can anyone see what I'm doing wrong? SELECT title FROM node WHERE type=client; ERROR: column "client" does not exist LINE 1: SELECT title FROM node WHERE type=client; Yet this works: SELECT type FROM node; type client client client client client (5 rows)

[GENERAL] Out of sync Primary Key Index

2009-11-18 Thread Dave Coventry
I have deleted a record from a table and am now getting errors: INSERT INTO content_node_field (field_name, type, global_settings, required, multiple, db_storage, module, db_columns, active, locked) VALUES ('field_client_name', 'text', 'a:4:{s:15:"text_processing";s:0:"";s:10:"max_length";s:0:"";

Re: [GENERAL] Books, the lulu.com scam

2009-11-21 Thread Dave Coventry
2009/11/21 Yordan Radunchev : > Postgre have such a great (and helpful and wiling to share knowledge) > community and great on-line documentation for free. +1 > Books (content) tent to get old and more useless with every Postgre > update. If some one offers a book with lifetime support meaning th

[GENERAL] limiting resources to users

2009-11-25 Thread Gauthier, Dave
Hi: Is there a way in Postgres to limit how much cpu, memory, other resources a certain DB gets? A MySQL DB that I'm now replacing with PG has been having problems with run-away users that pound one DB with intense processes running periodically in cron jobs. The effect is that it takes up al

Re: [GENERAL] limiting resources to users

2009-11-25 Thread Gauthier, Dave
quot; reports and they're not squemish about refreshing very often. What I'd like to see is that they get their 3% of the server's attention to di this and no more, leaving the other 97% free for non-abusive users. Thanks for all the help on this !! -dave -Original Me

Re: [GENERAL] how to install just client libraries on windows?

2009-12-01 Thread Dave Page
Postgres Plus Standard Server, not the PostgreSQL one-click installer. The easiest way to just get libpq and the supporting libraries would be from the tarball distros: http://www.enterprisedb.com/products/pgbindownload.do Just extract, and grab the DLLs. -- Dave Page EnterpriseDB UK: http://www.

Re: [GENERAL] limiting resources to users

2009-12-01 Thread Gauthier, Dave
I think I'm just going to have to run the priority DB on a different server (linux) to make sure it doesn't get abused. I can see no other way. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alban Hertroys Sent: Tue

Re: [GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-02 Thread Dave Page
t it to work Israel, please report back to the list. I tried briefly and failed completely at building a 3 way binary on one machine. My next attempt was going to involve multiple build machines and lipo... -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general

Re: [GENERAL] how to install just client libraries on windows?

2009-12-02 Thread Dave Page
enerally need more than just the client libraries - for example, they'll need headers and import libraries as well. The closest thing we have to a client installer is probably pgAdmin, which will install libpq and it's dependencies, as well as psql, pg_dump/pg_dumpall/pg_restore, and

Re: [GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-02 Thread Dave Page
10.6 machine. The command line I am using is as follows: > > 10.6 is intel only, so why do you even bother with PPC ? 10.6 supports building of PPC binaries (in theory at least) for use on older OSs, -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing l

[GENERAL] postgre...@fosdem 2010 - Call for talks

2009-12-03 Thread Dave Page
FOSDEM (http://www.fosdem.org/2010/) is a major Free and Open Source event held annually in Brussels, Belgium, and attended by around 4000 people. As in recent years, the PostgreSQL project will have a devroom where we will be presenting a number of talks. The event will be held on the 6 - 7th Febr

Re: [GENERAL] postgre...@fosdem 2010 - Call for talks

2009-12-03 Thread Dave Page
On Thu, Dec 3, 2009 at 12:32 PM, Greg Stark wrote: > On Thu, Dec 3, 2009 at 10:48 AM, Dave Page wrote: > >> We will have a number of 45 minutes slots, and may split one or more >> into 3 back-to-back 15 minute slots if we receive suitable proposals. > > I would like

[GENERAL] code example for PQgetCopyData

2009-12-03 Thread Dave Huber
Does anybody have a snippet where they use PQgetCopyData? I must be calling it wrong as it keep crashing my program. I've attached my code below. I am writing this for a Code Interface Node in LabVIEW. Thanks, Dave MgErr CINRun(LStrHandle conninfo, LStrHandle copystr, TD1Hdl resultV

Re: [GENERAL] code example for PQgetCopyData

2009-12-03 Thread Dave Huber
> Where is it blowing up? I'm sorry, I wasn't clear. It bombs on the PQgetCopyData call. If I comment out the entire while loop, the program runs fine. If I simply comment out the contents of the while loop...kablooey! Dave This electronic ma

Re: [GENERAL] code example for PQgetCopyData

2009-12-03 Thread Dave Huber
// get the data int i = 0; while (nLen = PQgetCopyData(pConn, &buffer, false) > 0) { ... Thanks again. Dave Tom wrote: One thing you're missing is that you should check that the resul

Re: [GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-03 Thread Dave Page
had been mis-compiled (in postgres, not by gcc) as it was treating my ppc box as a little-endian platform. Of course, the build worked fine on an intel box. So it's entirely possible that libpq may be working OK, whilst the server is broken horribly. -- Dave Page EnterpriseDB UK: http://www

[GENERAL] PostgreSQL Release Support Policy

2009-12-04 Thread Dave Page
: Version EOL Date PostgreSQL 7.4 July 2010 (extended) PostgreSQL 8.0 July 2010 (extended) PostgreSQL 8.1 November 2010 PostgreSQL 8.2 December 2011 PostgreSQL 8.3 February 2013 PostgreSQL 8.4 July 2014 -- Dave Page PostgreSQL Core Team -- Sent via pgsql-general mailing list (pgs

[GENERAL] New PostgreSQL Committers

2009-12-07 Thread Dave Page
re for EXPLAIN and a new implementation of VACUUM FULL. Congratulations! -- Dave Page PostgreSQL Core Team -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] how to allow a sysid to be a superuser?

2009-12-08 Thread Gauthier, Dave
ch that when psql is invoked in a session of that user, he/she automatically has "all" (wothoug havng to enter "-user theuid")? Thanks -dave

Re: [GENERAL] how to allow a sysid to be a superuser?

2009-12-08 Thread Gauthier, Dave
It comes back... role "joetheplumber" does not exist The user is a sys uid on linux. -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Tuesday, December 08, 2009 1:26 PM To: Gauthier, Dave Cc: pgsql-general Subject: Re: [GENERAL] how to allow a s

Re: [GENERAL] Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.

2009-12-11 Thread Dave Page
oing higher we saw performance dropping off again as well. -- 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

[GENERAL] FOSDEM dinner

2009-12-11 Thread Dave Page
7;t booked your travel yet), please let me know off-list. I'll firm up the number closer to February. Thanks! -- 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.pos

Re: [GENERAL] Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.

2009-12-11 Thread Dave Page
On Fri, Dec 11, 2009 at 3:11 PM, Greg Smith wrote: > Dave is talking about Greg Stark here, lest anyone credit me for something I Err, yes indeed. Sorry. Keep forgetting that postgresql.org is the only place in the world with more Gregs than Daves... > wasn't involved in.  I just

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