[GENERAL] Replication

2005-09-12 Thread barry
ftware available which can replicate a large and dynamic number of tables? Cheers, Barry ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Make MS Access "UPDATE" PostGre SQL Table

2008-03-25 Thread Pettis, Barry
Thoughts on whether to do it from a .net perspective. MSAccess ( 2003 ) PostGreSQL ( 8.1.8 ) Regards, Barry Pettis CSO Atmel Corp

[GENERAL] Using tables in other PostGreSQL database

2008-03-27 Thread Pettis, Barry
I don't want to have to replicate his/her work. I just want to purloin his finished product... Though I think that that's the whole point. Also to respond in the thread... Do I just reply to the message? Regards, Barry Pettis http://www.ozgrid.com/forum/m

Re: [GENERAL] Using tables in other PostGreSQL database

2008-03-27 Thread Pettis, Barry
t work } ) knowledge. So maybe as my experience grows things will become clearer. It's just right now I had to make my own data loader and store this data that I know is being done by another... From a business productivity point of view I see this as a waste of money. Regards, Barry Pet

Re: [GENERAL] Using tables in other PostGreSQL database

2008-03-27 Thread Pettis, Barry
basic that within a said postgre server, that as along as you have access to a said database you should be able to say use the data stored here. And that that ability should be a rudimentary ability not an addon. Reason why I don't' have ability to install addon's onto the database.

Re: [GENERAL] Using tables in other PostGreSQL database

2008-03-31 Thread Pettis, Barry
e same questions about MSft's SQL server. But I thank the forum here for all the input. Regards, Barry Pettis CSO Atmel Corp Project Tech -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Verite Sent: Monday, March 31, 2008 3:36 AM To: pg

Re: [GENERAL] Using tables in other PostGreSQL database

2008-04-01 Thread Pettis, Barry
derstand. So when the question is posed there is a disconnect between poster and responder. So I'm hoping that I've been able to adequately clear the air. If not it's always fun to try. -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 200

[GENERAL] Separating function privileges from tables

2007-05-03 Thread Barry Brown
Hi all, It's nice that privileges on views are separate from the privileges on its underlying tables. For example, if view V queries tables A and B, I only need to grant SELECT on the view to another user; tables A and B can have that privilege revoked and the view works. Are there plans

Re: [GENERAL] Change query priority

2004-10-19 Thread Barry S
Thats fine, but you do understand that nice (linux) will have *no* effect on I/O? For any non-trivial table (that can't be held entirely in memory), re-nice will almost certainly have no effect. -Barry In article <[EMAIL PROTECTED]>, Gaetano Mendola wrote: > Tom Lane wrot

Re: [GENERAL] Can I read data load files without loading in db?

2006-08-26 Thread barry conner
Thanks for your reply Martijn.   I do not know for certain that its in pg_dump format, not having dealt with it specificly before.   I will examine the files more closely to look for COPY statements.   If not in that format, what else could it be that could be shoved right into a postgresql databas

Re: [GENERAL] Hardware recommendations

2004-10-01 Thread Barry S
Gentoo, in my opinion, makes a poor production platform. Others have had success with it, but I would recommend 1 of the big 3 'stable' linux platforms out there: * RHES * SUSE * Debian As far as hardware goes, IBM has some nice x86 intro servers that fit into that price catagory. -

Re: [GENERAL] [ADMIN] initdb on postgresql 7.1.2 running under cygwin on win 2000

2001-08-14 Thread Barry Lind
My guess is that you don't have the ipc-daemon running before you run initdb. --Barry Steve SAUTETNER wrote: > Hello ! > > I've got a little problem with launching initdb on postgresql 7.1.2 under > cygwin : > > when i launch it, it says : > > $ initdb -d -

Re: [GENERAL] Comparing fixed precision to floating

2001-08-22 Thread Barry Lind
When the parameter is bound, the resulting statement sent to the server will be: select * from foo where bar = 123.456::numeric which should work correctly. thanks, --Barry Mike Finn wrote: > I am using numeric(p,s) fields in a database schema. > Using queries that contain a compariso

Re: [GENERAL] Error Codes, JDBC, SQLExceptions

2001-08-24 Thread Barry Lind
Wieger, The server does not have a concept of error codes currently (it is on the TODO list). Therefore the JDBC driver has no error code to report since it doesn't get one from the backend. When the server supports error codes the JDBC driver will as well. thanks, --Barry Wieger U

Re: Fwd: Re: [GENERAL] unicode in 7.1

2001-09-11 Thread Barry Lind
pgsql-jdbc mail list. You might also want to check the mail archives. thanks, --Barry Culley Harrelson wrote: > The was corrupted in the process of the upgrade. > > Is there some way to tell what the configuration options were when it > was installed? I am assuming by API

Re: Fwd: Re: [GENERAL] unicode in 7.1

2001-09-12 Thread Barry Lind
ouldn't be parsed. I noticed that the code snipit you sent below seems to have an error in it. You select 'TEST' as test, but then later you do a getString("title") which should fail since there isn't a selected column called "title". thanks, --Barry Cu

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Barry Lind
abase). Also you might want to look at this message from the archives: http://archives.postgresql.org/pgsql-jdbc/2001-03/msg00168.php Which discusses this bug. thanks, --Barry Graham Leggett wrote: > Hi all, > > While moving a database installation from one machine to another, the &g

Re: [GENERAL] JDBC update wont, plz help.

2001-09-26 Thread Barry Lind
m. thanks, --Barry Vic Cekvneich wrote: > I downloaded the 7.13 src and did a JDBC build using J2EE 13, to get the > sqlX package. > The build failed with errors. > > Is there someone who can make a build with sqlX java (must have J2EE SDK > enviroment) ? > Help.. plea

[GENERAL] Failure of make for 7.3.4 on Mac OS 10.3 Panther

2003-11-11 Thread Barry C.Hawkins
d 3 warning messages regarding OpenSSL during the configure process, but make still produces the same results. I had 7.3.4 installed on Mac OS 10.2.8 without issue. Any advice? Thanks in advance. Regards, -- Barry C. Hawkins All Things Computed site: www.allthingscomputed.com weblog: www.allthi

Re: [GENERAL] (Solved) Failure of make for 7.3.4 on Mac OS 10.3 Panther

2003-11-11 Thread Barry C.Hawkins
On Nov 11, 2003, at 9:17 PM, Bruce Momjian wrote: Please try 7.4RC2. We have that fixed there. --- Barry C.Hawkins wrote: List, Hello. I am trying to get PostgreSQL 7.3.4 installed after moving to Mac OS 10.3

[GENERAL] Arguments not being passed to a function

2000-05-28 Thread Barry Lind
insert happens (but if I use a parameter in the insert, i.e. $1, it is always null).  However if I run the function from a select, (ie. select testcall(5); ) it works correctly. Can anyone shed some light on this? thanks, --Barry

[GENERAL] Indexing of geometric data

2000-07-05 Thread Barry Brown
low. So my questions are: what data structure is used to index a set of points? Is it a spatially-oriented structure, such as a quadtree, that would make queries like the example above very fast? Can Postgres be adapted to use integers instead of floats to store point coordinates? Thanks! Barry

Re: [GENERAL] win2000: problems starting postmaster

2001-02-20 Thread Barry Lind
the problem for me. thanks, --Barry Peep Krusberg wrote: > hello! > > That's my very first day with postgres, so please be kind... > > - cygwin installed OK > - it seems that postgres compiled & installed OK > - initdb created db structures > - ipc-daemon start

Re: [GENERAL] Question on Bizarre Sorting (ORDER BY in 7.1) (fwd)

2001-04-25 Thread Barry Lind
, or rebuild postgresql without locale support enabled. I think there is a contrib program that you can use to see what locale your database was created with. Once your database is created you can't change the locale, you will need to re-initdb. thanks, --Barry Justin Clift wrote: >

[GENERAL] Where is libpq-fe.h?

2001-06-08 Thread Barry Jeapes
m theyve managed to get round? Any help would be appreciated. I also tried installing the Pg module (as apposed to the DBD-Pg module) and found the same problem. Any help would be very much appreciated. Barry ---(end of broadcast)--- TIP 3: if postin

[GENERAL] How do you rebind/reexecute a query without reparsing it?

2000-05-22 Thread Barry Lind
t the Front End/Back End protocol can support this type of functionality. Is there anyway I can avoid the overhead of reparsing the statements when all I want to do is rebind/reexecute the same statements over and over again? (Again I need this from the JDBC interface) thanks, --Barry

[GENERAL] Move database from Solaris to Windows

2007-08-01 Thread Barry C Dowell
Please forgive me if this question is being asked in the wrong area (and please suggest the proper one so I can ask there :-) ), but I'm in search of assistance in moving a database from a Solaris system over to a Windows system. Solaris 5.8, postgreSQL 8.01, to Windows Server 2003, postgreSQL 8.0

Re: [GENERAL] Move database from Solaris to Windows

2007-08-01 Thread Barry C Dowell
esday, August 01, 2007 3:35 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Move database from Solaris to Windows On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote: > Please forgive me if this question is being asked in the wrong area > (and please suggest the proper one so I can a

Re: [GENERAL] Move database from Solaris to Windows

2007-08-01 Thread Barry C Dowell
ral@postgresql.org Subject: Re: [GENERAL] Move database from Solaris to Windows On Aug 1, 2007, at 2:34 PM, Steve Atkins wrote: > > On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote: > >> Please forgive me if this question is being asked in the wrong area >> (and please sugge

Re: [GENERAL] Move database from Solaris to Windows

2007-08-06 Thread Barry C Dowell
ipate more. Bcd -Original Message- From: Barry C Dowell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 4:40 PM To: 'pgsql-general@postgresql.org' Subject: RE: [GENERAL] Move database from Solaris to Windows Ok, if you can forgive the possible stupid answer and help p

[GENERAL] Problems setting shared_buffers to large value

2004-04-12 Thread Barry L. Geipel
mean a 4GB max. This is failing at much lower values.   Sorry that I do not have a logfile output. Perhaps someone could help me turn my logfile on. I am passing –l logfile at startup, but my logfile remains empty.   Thanks in advance   Barry ([EMAIL PROTECTED]