Re: [GENERAL] Using tables in other PostGreSQL database

2008-04-01 Thread Pettis, Barry
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: pgsql-general@postgresql.org Subject: Re: [GENERAL] Using tables in other

Re: [GENERAL] Using tables in other PostGreSQL database

2008-04-01 Thread Pettis, Barry
. If not it's always fun to try. -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2008 8:30 AM To: pgsql-general@postgresql.org Cc: Pettis, Barry Subject: Re: [GENERAL] Using tables in other PostGreSQL database On Monday 31 March 2008 4:20 am

[GENERAL] Using tables in other PostGreSQL database

2008-03-27 Thread Pettis, Barry
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/misc.php?do=getsmilieseditorid

Re: [GENERAL] Using tables in other PostGreSQL database

2008-03-27 Thread Pettis, Barry
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 Pettis -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Thursday

Re: [GENERAL] Using tables in other PostGreSQL database

2008-03-27 Thread Pettis, Barry
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. Regards, Barry Pettis

[GENERAL] Make MS Access UPDATE PostGre SQL Table

2008-03-25 Thread Pettis, Barry
perspective. MSAccess ( 2003 ) PostGreSQL ( 8.1.8 ) Regards, Barry Pettis CSO Atmel Corp

Re: [GENERAL] Move database from Solaris to Windows

2007-08-06 Thread Barry C Dowell
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 pull me a long

[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

Re: [GENERAL] Move database from Solaris to Windows

2007-08-01 Thread Barry C Dowell
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 ask there :-) ), but I'm in search

Re: [GENERAL] Move database from Solaris to Windows

2007-08-01 Thread Barry C Dowell
: 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 suggest the proper one so I can ask there :-) ), but I'm

[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] 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 database? In

[GENERAL] Replication

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

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 wrote: Gaetano Mendola

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. -Barry John

[GENERAL] Problems setting shared_buffers to large value

2004-04-12 Thread Barry L. Geipel
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]

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

2003-11-11 Thread Barry C.Hawkins
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.allthingscomputed.com/blog

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

2001-09-26 Thread Barry Lind
, --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.. please Vic Vic Cekvenich wrote: I am

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

2001-09-12 Thread Barry Lind
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 Culley Harrelson wrote: I just finished rebuilding my

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Barry Lind
). 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 client app now fails

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

2001-09-11 Thread Barry Lind
-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 you mean how am I accessing

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 Uffink

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 comparison like

[GENERAL] Where is libpq-fe.h?

2001-06-08 Thread Barry Jeapes
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 posting/reading through Usenet, please send

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: Dunno

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 started OK - but postmaster -i fails

[GENERAL] Indexing of geometric data

2000-07-05 Thread Barry Brown
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

[GENERAL] Arguments not being passed to a function

2000-05-28 Thread Barry Lind
t 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] How do you rebind/reexecute a query without reparsing it?

2000-05-22 Thread Barry Lind
that 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