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
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
Thom
On 6/8/2010 9:23 AM, Peter Hunsberger wrote:
On Tue, Jun 8, 2010 at 4:04 AM, John Gagejsmg...@numericable.fr 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
***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
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 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
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 around
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 test
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, never
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/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 psql
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 failures= 1
On 5/12/2010 12:33 PM, Richard Broersma wrote:
On Wed, May 12, 2010 at 9:18 AM, Justin Grafjus...@magwerks.com 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 will hang around
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 running
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 across
On 4/29/2010 3:18 PM, Tom Lane wrote:
Alvaro Herreraalvhe...@commandprompt.com 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
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
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 did
On 4/8/2010 9:30 AM, Bill Moran wrote:
In response to Ognjen Blagojevicogn...@etf.bg.ac.rs:
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 3/26/2010 12:12 PM, Tom Lane wrote:
Gaietti, Mauro \(SELEX GALILEO Guest,
Italy\)mauro.gaie...@guests.selexgalileo.com 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
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) package
On 3/16/2010 3:35 PM, Vick Khera wrote:
On Tue, Mar 16, 2010 at 3:03 PM, Jamie Kahgeejamie.kah...@gmail.com 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
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 difference
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 schemas
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 tried
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 (and
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.exe file is
On 3/4/2010 10:00 AM, Greg Stark wrote:
On Thu, Mar 4, 2010 at 2:14 PM, Justin Grafjus...@magwerks.com 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 are forgetting that the 32 here is to
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
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 the
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 user
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 over
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
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 course):
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
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
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
38 matches
Mail list logo