use the .net provider
http://npgsql.projects.postgresql.org/
I'm not sure of a 64bit build. although a 32bit version should run on 64 bit
windows without any problems.
Message from mailto:drewtimm...@gmail.com Andrew Timmins
drewtimm...@gmail.com at 06-29-2009 05:36:58 PM --
Is ther
over the last 3 years i can't recall it being included in the msi installer
Now the MSI installers from Enterprise DB is a One Click installer i'm not sure
whats all included. I have it installed on one or 2 machines but never really
dug into what's all included to tell you what all in the new i
On 4/29/2010 12:07 PM, David Wall wrote:
>
>
> Big downside for the DB is that all large objects appear to be stored
> together in pg_catalog.pg_largeobject, which seems axiomatically
> troubling that you know you have lots of big data, so you then store
> them together, and then worry about run
On 4/29/2010 1:51 PM, David Wall wrote:
>
>> Put it another way: bytea values are not stored in the pg_largeobject
>> catalog.
>
> I missed the part that BYTEA was being used since it's generally not a
> good way for starting large binary data because you are right that
> BYTEA requires escaping
On 4/29/2010 3:18 PM, Tom Lane wrote:
> Alvaro Herrera writes:
>
> However, that toast limit is per-table, whereas the pg_largeobject limit
> is per-database. So for example if you have a partitioned table then
> the toast limit only applies per partition. With large objects you'd
> fall ove
On 5/12/2010 11:45 AM, Richard Broersma wrote:
> Can anyone advise me if either PostgreSQL 8.3 or 8.4 is ready for
> special case of production use?
>
> I'm considering using the windows version PostgreSQL in the following
> conditions:
> at least 10 years of up time (with periodic power failur
On 5/12/2010 12:33 PM, Richard Broersma wrote:
> On Wed, May 12, 2010 at 9:18 AM, Justin Graf wrote:
>
>
>> I would do a plain text file something like XML. Given this is for
>> industrial use 10 years is a good number for warranty and support, but
>> this stuff w
On 5/17/2010 12:52 AM, Yan Cheng CHEOK wrote:
> The pgadmin result seems different with my machine. My friend and I are using
> Windows machine. Are you using Linux machine?
>
> Thanks and Regards
> Yan Cheng CHEOK
>
>
> **snip**
I use both windows and Linux using pgadmin, and on occasion use
On 5/24/2010 3:18 PM, Hector Beyers wrote:
> Yes, I mean hide. I am approaching the problem out of the perspective
> of a malicious user / hacker.
>
> **snip***
First hiding data is not a solution to secure or block access to
information. This only slows people down it does not stop them, neve
On 5/25/2010 2:58 AM, Hector Beyers wrote:
>
> No, I have not considered encrypting or decrypting data. The reason
> for this is that I am trying to /secure a database/ by thinking like a
> /malicious user / criminal/. I want to hide (for example) fraudulent
> data on a database where it is not
On 5/27/2010 9:04 AM, Nikolas Everett wrote:
> Say I have a table that stores state transitions over time like so:
> id, transitionable_id, state1, state2, timestamp
>
> I'm trying to write a query that coalesces changes in state2 away to
> produce just a list of transitions of state1. I guess it
On 5/27/2010 9:45 AM, Nikolas Everett wrote:
> Sorry. Here is the setup:
> CREATE TABLE test (id BIGSERIAL PRIMARY KEY, state1 INT NOT NULL,
> state2 INT NOT NULL, timestamp TIMESTAMP);
> INSERT INTO test (state1, state2, timestamp) VALUES (1, 1, now() -
> interval '12 hours');
> INSERT INTO tes
On 5/29/2010 1:05 PM, Dennis Gearon wrote:
> Is it possible to create a complex schema object in one transaction,
I'm not sure i understand what you mean by schema object
> using prepared statements to protect(somewaht) against SQL injection?
>
In short no
Prepared statements do not pro
On 5/29/2010 6:26 PM, Bob Pawley wrote:
> Found it in XP it doesn't seem to exist in Windows 7. I can't even
> find Doc and Settings in 7.
>
> It's a large file. I'm not sure what is needed but here is the latter
> part of the file.
>
> Bob
>
***Snip***
Windows 7 and vista move lots of things ar
On 6/3/2010 5:43 AM, Jamie Lawrence-Jenner wrote:
>
> Hi All
>
> In SQL Server I could copy sql code out of an application and paste it
> into SSMS, declare & assign vars that exist in the sql and run.. yay
> great debugging scenario.
>
> e.g. (please note I am rusty and syntax may be incorrect)
On 6/8/2010 9:23 AM, Peter Hunsberger wrote:
> On Tue, Jun 8, 2010 at 4:04 AM, John Gage wrote:
>
>> Unix is a text-based operating system with unbelievably helpful text
>> manipulation tools.
>>
>> Postgres is a creature of Unix which happens to have unbelievable text
>> searching and manipul
***SNIP***
> 2) Its also available in chm windows help file format. Which i find
> allot
> more useful
> http://www.postgresql.org/docs/manuals/
> you could print chm to a text file.
>
> --I'll have to boot over to XP, ugh. Will do.
There are linux chm readers
http://www.linux.com/news/sof
On 6/10/2010 4:12 AM, Thom Brown wrote:
> Does anyone know if ms2pg is available from somewhere other than
> http://edoceo.com/creo/ms2pg ? Attempts to download it result in "not
> found". Unless someone knows of an alternative attempt to automate
> migration of MSSQL to PostgreSQL?
>
> Thanks
>
On 7/1/2010 11:08 AM, Mike Christensen wrote:
> I'd like to convert a small database to UTF8 before it becomes too
> large. I'm running on 8.3.x on Windows. It doesn't seem that pgAdmin
> has any native way of doing this, what's the easiest way to go about
> doing this? Thanks!
>
> Mike
>
Thisis the same problempostgresql has whendoing sorting when runonwindows vs.
linux. Postgresql relies on the OS tohandlecollating aka sort orders.
to Quote
PostgreSQL uses the standard ISO C and POSIX locale facilities provided by the
server operating system
http://www.postgresql.org/docs
On 2/8/2010 7:09 PM, Fredric Fredricson wrote:
> Hi!
> New to the list with a question that I cannot find the answer to in
> the manual or on the internet but I suspect is trivial. If somebody
> could point me in the correct direction I would be greatful.
>
> This is what I do (condensed, of cour
On 2/9/2010 12:47 PM, Asher wrote:
> Hello.
>
> I'm putting together a database to store the readings from various
> measurement devices for later processing. Since these things (water
> pressure monitors attached to very large water pipes) take readings at
> 200Hz and are typically deployed ove
On 2/9/2010 4:41 PM, Asher Hoskins wrote:
>
> Thanks for that, it looks like partitioning is the way to go. I'm
> assuming that I should try and keep my total_relation_sizes less than
> the memory size of the machine?
This depends on what the quires look like. As other have stated when
partitio
On 2/10/2010 7:15 PM, paul e wrote:
> Before Installed postgresql Windows7 went straight to my user account.
> Now when it boots I have to go to a selection page where I choose
> between my user account and a postgresql user account. Is there any
> way to bypass this so it boots directly to my us
On 3/3/2010 3:40 PM, Michael Gould wrote:
> On my machine the UUID that is returned is 16 bytes and I cannot make
> out any relevant numbers from the UUID key in the citystateinfo
> table. I've tried this in a Windows XP machine and a Windows 7 64 bit.
>
> Now here is the weird thing. I did a c
On 3/3/2010 5:16 PM, Michael Gould wrote:
> One thing I've noticed is that on my machines, when I install the odbc
> driver I get no error messages but when I look in the ODBC administrator I
> do not see any entry for PostGres in the drivers list.
>
> I do know that it somehow is working because t
On 3/4/2010 3:51 AM, Richard Huxton wrote:
> On 04/03/10 01:35, Craig Ringer wrote:
>>
>> http://support.microsoft.com/kb/942976/en-us
>
> Classy. Even better - according to the linked page, the 64 bit version
> is in the "System32" folder - yippee!
>
> "* The 32-bit version of the Odbcad32.ex
On 3/4/2010 10:00 AM, Greg Stark wrote:
> On Thu, Mar 4, 2010 at 2:14 PM, Justin Graf wrote:
>
>> To pretty much anyone outside MS, a sane human would think 64 bit apps
>> in SysWoW64 and 32Bit apps in System32. :'(
>>
>>
> Ah, but you all a
On 3/9/2010 12:07 AM, Sam Carleton wrote:
> I would like to thank both John and Scott for the help. It is very
> clear to me that PostgreSQL isn't the ideal solution for my current
> model. The conversation has gotten me thinking of ways the model
> could be modified to work with PostgrSQL (an
On 3/10/2010 8:16 PM, Chris Travers wrote:
> Hi all;
>
> One of my applications currently has over 60 stored procedures and
> future versions will likely have several hundred. I am wondering what
> folks find to be helpful naming conventions for managing a large
> number of stored procedures. We
On 3/10/2010 11:52 PM, Chris Travers wrote:
>
> There are two major limitations here of schemas:
>
> 1) They can't be nested leading again to possible namespace ambiguity.
> 2) there are a number of requests to try to get the application to
> install into an arbitrary, nonpublic schema.
>
> If sc
On 3/15/2010 2:40 PM, Rob Richardson wrote:
> Greetings!
>
> Our database monitors the progression of steel coils through the
> annealing process. The times for each step are recorded in wallclock
> time (US eastern time zone for this customer) and in UTC time. During
> standard time, the differe
On 3/16/2010 3:35 PM, Vick Khera wrote:
> On Tue, Mar 16, 2010 at 3:03 PM, Jamie Kahgee wrote:
>
>> I'm curious what people consider best practice (or how do you do it) to
>> help ensure these name collisions don't happen.
>>
> Do not mix data from multiple applications in one database.
On 3/18/2010 12:52 PM, Scott Mead wrote:
> xtuple ERP does and the latest version of GNUCash can use postgres as
a backend too.
>
> --Scott M
>
> On Thu, Mar 18, 2010 at 1:11 PM, Garry Saddington <
ga...@schoolteachers.co.uk> wrote:
>
> Does anyone know of a web based accounting(finance) pa
On 3/26/2010 12:12 PM, Tom Lane wrote:
> "Gaietti, Mauro \(SELEX GALILEO Guest,
> Italy\)" writes:
>
>> This query:
>> select round(0.5), round(0.5::integer), round(0.5::bigint), round(
>> 0.5::float ), round( 0.5::double precision ),round(cast(0.5 as double
>> precision )),round(cast(0.5::do
On 4/8/2010 9:30 AM, Bill Moran wrote:
> In response to Ognjen Blagojevic:
>
>>
>> Is this:
>> a. Lookup table
>> b. Classifier
>> c. Cypher(er)?
>>
>> I'm looking for the appropriate term in English.
>>
> I try to make it an ENUM when it's very unlikely to change, i.e. day of
> the week
On 4/14/2010 9:20 AM, Satish Burnwal (sburnwal) wrote:
> Index Scan using repcopy_index on repcopy a (cost=0.00..87824607.17
> *rows=28* width=142) (actual time=11773.105..689111.440*rows=1* loops=1)
> Index Cond: ((dm_user)::text = 'u3'::text)
> Filter: ((report_status = 0) AND (repor
On 4/14/2010 9:42 AM, Bill Moran wrote:
>
> Man, it's hard to read your emails. I've reformatted, I suggest you
> improve the formatting on future emails, as I was about to say "to
> hell with this question" because it was just too difficult to read,
> and I expect there are others on the list who
38 matches
Mail list logo
