[GENERAL] postgres user with password read-only user without?

2016-01-12 Thread Ted Toth
Is there a way to configure authentication so that some users require a password and other users don't? Ted -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] 9.5rc1 RLS select policy on insert?

2016-01-06 Thread Ted Toth
I see the insert policy check running but also the select policy using on insert. I don't understand why the select policy is being run. Could it possibly be related to using a sequence on the table? Ted -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] RLS 9.5rc1 configuration changes?

2016-01-04 Thread Ted Toth
On Mon, Jan 4, 2016 at 4:54 PM, Tom Lane wrote: > Ted Toth writes: >> I had been using CrunchyDatas 9.4 with backported RLS but I decided >> since my ultimate target is 9.5 that I update to it. However now the >> function called for the SELECT policy is not being called. \d

[GENERAL] RLS 9.5rc1 configuration changes?

2016-01-04 Thread Ted Toth
ER TABLE FORCE ROW LEVEL SECURITY; in addition to the: ALTER TABLE ENABLE ROW LEVEL SECURITY; which I was already doing as I want RLS to be used even for the owner of the table. Are there any other additional configuration changes needed to get RLS to work again? Ted -- Sent via pgsql-gener

[GENERAL] native api or odbc?

2015-06-23 Thread Ted Toth
What are peoples experiences with either/both, pluses/minuses? Ted

[GENERAL] RLS policy issue

2015-05-21 Thread Ted Toth
I'm work on understanding and implementing RLS. Since I work on systems using SELinux (MLS policy) I'm using the sepgsql module that I've modified slightly i.e. I've added a function named sepgsql_check_row_perm that I'm using in the policy for example I have a 'reports' table that looks like:

[GENERAL] 9.5 RLS 'check policy' function arguments

2015-02-12 Thread Ted Toth
I'm contemplating writing a function for use with the CHECK POLICY statement. Where can I find documentation describing the arguments that will be passed to the function? Ted -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] sepgsql where are the security labels

2014-11-13 Thread Ted Toth
On 11/13/2014 05:58 AM, Ted Toth wrote: >> >> This table maintains information about the context of postgresql >> objects not the data in tables. > > > > > http://www.slideshare.net/kaigai/label-based-mandatory-access-control-on-postgresql > > Slide 23 > >

Re: [GENERAL] sepgsql where are the security labels

2014-11-13 Thread Ted Toth
This table maintains information about the context of postgresql objects not the data in tables. On Wed, Nov 12, 2014 at 5:56 PM, Adrian Klaver wrote: > On 11/12/2014 02:45 PM, Ted Toth wrote: >> >> I'm running selinux mls policy I've got labeled ipsec working and my &g

[GENERAL] sepgsql where are the security labels

2014-11-12 Thread Ted Toth
I'm running selinux mls policy I've got labeled ipsec working and my postgresql configured to load sepgsql. I've created a db, run the sepgsql.sql script on it, created tables and inserted data. How do I query the security labels on the data? As best I can tell there is no security_context column o

Re: [GENERAL] does postgresql works on distributed systems?

2008-06-03 Thread Ted Byers
nly to apps on localhost, or a specific IP on the LAN, with access to the DB mediated through middleware. You should probably look at a) how your server is configured and b) how your client is configured (including whether or not you actually have client software on your client machine). Cheers

Re: [GENERAL] No Return??

2008-04-13 Thread Ted Byers
; I have tried 'Return New' and 'Return Result' > without luck, and if I leave > off either of the two 'End If ' statements the > procedure returns an error. > Look at your flow control! Your return is within a conditional block. If the condition for your first returns false, flow goes to the very end of the function and reaches "end" without encountering a return statement. Cheers, Ted -- 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] (FAQ?) JOIN condition - 'WHERE NULL = NULL'

2008-04-02 Thread Ted Byers
l would work for you, but maybe it will help. Cheers, Ted -- 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] (FAQ?) JOIN condition - 'WHERE NULL = NULL'

2008-04-02 Thread Ted Byers
thing to do when creating a join on columns that allow nulls is to exclude ALL rows, in either table, where the columns involved are null? Cheers, Ted -- 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] arrays of floating point numbers / linear algebra operations into the DB

2008-02-01 Thread Ted Byers
t to analyze data stored in the database using it. In the data I Do have, it changes daily, and some of the tables are well over 100MB, so I am a bit worried about how well it can handle such an amount of data, and how long it would take. Cheers, Ted ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] Sun acquires MySQL

2008-01-16 Thread Ted Byers
> brilliant > people. In fact, simply living in Pennsylvania > makes you smarter. > Does it count if I lived there for a year many many years ago? ;-) Ted ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] logging arguments to prepared statements?

2007-12-18 Thread Ted Byers
y SQL statement, including who is responsible for the statement and a timestamp. But if you don't need to support that kind of detailed audit, why bother when there are easier ways to address your issue? HTH Ted ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Efficiency vs. code bloat for SELECT wrappers

2007-12-17 Thread Ted Byers
--- Sam Mason <[EMAIL PROTECTED]> wrote: > On Mon, Dec 17, 2007 at 01:29:10PM -0500, Ted Byers > wrote: > > I routinely keep my SQL code distinct from my > Perl, > > java or C++ code. When a client program needs to > do > > something with the database, then e

Re: [GENERAL] Efficiency vs. code bloat for SELECT wrappers

2007-12-17 Thread Ted Byers
rom the database or from the user interface - in either case, they make interaction between a web based interface and the database back end MUCH simpler to code), and the relationships among the parts are easier to understand. Each kind of abstraction has its place. It is up to the analyst or architect to figure out how many layers and what abstractions are appropriate for a given project. HTH Ted ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] SQL design pattern for a delta trigger?

2007-12-10 Thread Ted Byers
And then follow that with something like: IF FOUND THEN INSERT INTO another_table (baz,quantity) VALUES (foo,q+NEW.quantity); ELSE INSERT INTO another_table (baz,quantity) VALUES (foo,NEW.quantity); END IF Thanks again, Ted ---(end of broadcas

Re: [GENERAL] SQL design pattern for a delta trigger?

2007-12-10 Thread Ted Byers
pointer to a solution that would work in the context of the problem at hand would be useful and appreciated. Thanks all. Ted ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] SQL design pattern for a delta trigger?

2007-12-10 Thread Ted Byers
es appropriately without relying on a trigger. :-( Thanks for everyone's help. Ted === DECLARE id BIGINT; q DOUBLE PRECISION; BEGIN SELECT assets.id INTO id, assets.quantity INTO q FROM assets WHERE assets.asset_type_id = NEW.asset_type_i

Re: [GENERAL] Simpler dump?

2007-12-10 Thread Ted Byers
Thanks All. I learned plenty this morning. --- Douglas McNaught <[EMAIL PROTECTED]> wrote: > On 12/10/07, Ted Byers <[EMAIL PROTECTED]> > wrote: > > > OK. A worry. How is template_postgis > constructed? > > Is it just a handy reference to template1? Or &

Re: [GENERAL] Simpler dump?

2007-12-10 Thread Ted Byers
Thanks Richard. --- Richard Huxton <[EMAIL PROTECTED]> wrote: > Ted Byers wrote: > > Amyway, when I look at the server using pgadmin, I > > don't see either template0 or template1. I see > only > > template_postgis. Should I be able to see > template0 &g

Re: [GENERAL] Simpler dump?

2007-12-10 Thread Ted Byers
rather than template_postgis, and then modify things so that the default is the normal template1 rather than template_postgis, but leaving the latter in place so I can use it when I need it? Thanks Ted ---(end of broadcast)--- TIP 9: In versions

Re: [GENERAL] Simpler dump?

2007-12-10 Thread Ted Byers
--- Richard Huxton <[EMAIL PROTECTED]> wrote: > Tino Wildenhain wrote: > > Hi Ted, > > > > Ted Byers wrote: > >> Thanks Uwe > >> > >> This is a great start. It reduces the dump from > 2 MB > >> down to 167K, but out of 6833 li

Re: [GENERAL] Simpler dump?

2007-12-10 Thread Ted Byers
--- Tom Lane <[EMAIL PROTECTED]> wrote: > Ted Byers <[EMAIL PROTECTED]> writes: > > It seems the public schema is > > automagically created by Postgres every time I > create > > a new database on a given server, and it has over > a > > dozen typ

Re: [GENERAL] Simpler dump?

2007-12-10 Thread Ted Byers
--- Tom Lane <[EMAIL PROTECTED]> wrote: > Ted Byers <[EMAIL PROTECTED]> writes: > > Is there a way to tell pg_dump to just dump the > SQL > > statements required to create the tables, > sequences, > > indeces, keys, &c.? > > pg_dump -s

Re: [GENERAL] Simpler dump?

2007-12-10 Thread Ted Byers
s the stuff in public even though that stuff seems to be created, and therefore present, in every database I create on a given server instance? Isn't that duplication a waste of space, and it's presence in the dump a waste of CPU cycles? Thanks again. Ted --- "Uwe C. Schroed

[GENERAL] Simpler dump?

2007-12-09 Thread Ted Byers
something that will save me a little time. I've created the core of the DB already on my development machine, using pgAdmin, but I can recreate it in about a day using Emacs to create a SQL script that preproduces what I did in pgAdmin. Any information would be appreciated. Thanks Ted

Re: [GENERAL] SQL design pattern for a delta trigger?

2007-12-07 Thread Ted Byers
--- Erik Jones <[EMAIL PROTECTED]> wrote: > > On Dec 6, 2007, at 2:36 PM, Ted Byers wrote: > > [snip] > What you want to do here for handling the update v. > insert is called > an "UPSERT". Basically, what you do is run the > update as if the row

Re: [GENERAL] SQL design pattern for a delta trigger?

2007-12-06 Thread Ted Byers
--- Ted Byers <[EMAIL PROTECTED]> wrote: > IS there such a thing? I can be the first to > consider > this. > OOPS. The mind is faster than the fingers. That should have been "I can NOT be the first to consider this. Ted -

[GENERAL] SQL design pattern for a delta trigger?

2007-12-06 Thread Ted Byers
tself? Thanks Ted ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] stored procedures and dynamic queries

2007-12-04 Thread Ted Byers
verything working first. > Richard, could you possibly clarify what you mean by a "clean design"? Is it different from what I normally do with regard to ensuring all the requisite data is available, properly normalized, with a suitable suite of indeces, keys, &c., and as simple as practicable? (That is, over-simplification is avoided.) I also tend to ensure that all user access to the data is through either a stored procedure or a read only view (perhaps with a little paranoia thrown in ;). Ted ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Need help with complicated SQL statement

2007-11-19 Thread Ted Byers
t (and can usefully invoke it on any stock_id in the database), but the problem remains as to how to construct a record set by applying the procedure to each id in a set of ids returned, e.g., by SELECT stock_id FROM stocks; Ted === test data = EXPLAIN SELECT A1.stock_id,

Re: [GENERAL] Need help with complicated SQL statement

2007-11-17 Thread Ted Byers
--- Shane Ambler <[EMAIL PROTECTED]> wrote: > Ted Byers wrote: > > Please consider the following statement (it > becomes > > obvious if you remember the important thing about > the > > table is that it has columns for each of stock_id, > > price_da

[GENERAL] Need help with complicated SQL statement

2007-11-16 Thread Ted Byers
please at least give me a hint. Thanks Ted ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Optimal time series sampling.

2007-11-09 Thread Ted Byers
--- Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Nov 9, 2007 11:47 AM, Ted Byers > <[EMAIL PROTECTED]> wrote: > > > > --- Tom Lane <[EMAIL PROTECTED]> wrote: > > > > > Ted Byers <[EMAIL PROTECTED]> writes: > [snip] > Which is

Re: [GENERAL] Optimal time series sampling.

2007-11-09 Thread Ted Byers
--- Tom Lane <[EMAIL PROTECTED]> wrote: > Ted Byers <[EMAIL PROTECTED]> writes: > > OK, it is challenging to present it in plain text, > but > > here is the HTML exported by MySQL Query Browser. > > Why are you asking this list for help with a MySQL > perf

Re: [GENERAL] Optimal time series sampling.

2007-11-09 Thread Ted Byers
--- Gregory Stark <[EMAIL PROTECTED]> wrote: > "Ted Byers" <[EMAIL PROTECTED]> writes: > > > As a prelude to where I really want to go, please > > consider the following SELECT statement. > > > > SELECT close_price FROM stockprices A >

[GENERAL] Optimal time series sampling.

2007-11-08 Thread Ted Byers
benchmark testing? Thanks, Ted ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] young guy wanting (Postgres DBA) ammo

2007-11-03 Thread Ted Byers
n, and finding good information is not the same thing, and I am wary of 99% of what I find using google. Since you know what a DBA needs to know, I ask you where I can learn what you believe a good DBA needs to know. Or am I OK just relying on the documentation that comes with a given RDBMS (Postgres, MySQL, MS SQL, &c.)? Ted ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Design Question (Time Series Data)

2007-10-04 Thread Ted Byers
--- Michael Glaesemann <[EMAIL PROTECTED]> wrote: > > On Oct 4, 2007, at 9:30 , Ted Byers wrote: > > > I do not know if PostgreSQL, or any other RDBMS, > > includes the ability to call on software such as > "R" > > See PL/R: > > http://w

Re: [GENERAL] Design Question (Time Series Data)

2007-10-04 Thread Ted Byers
ppropriate data from the database and either does the analysis in custom code I have written (usually in C++, as some of my favourite analyses have not made it into commonly available open source or commercial statistical software) or invokes the appropriate functions from stat

Re: [GENERAL] How to avoid: 9.50184e+06

2007-09-28 Thread Ted Byers
the data really requires use of floating point numbers, then use the libraries provided by whatever language you're using to develop your client to produce the format you want. HTH Ted ---(end of broadcast)--- TIP 3: Have you checked our extensive

Re: [GENERAL] Audit-trail engine inner-workings

2007-08-21 Thread Ted Byers
ss, so there is no useful concept of session without help from other technologies). HTH Ted ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] [RESEND] Transaction auto-abort causes grief with Spring Framework

2007-08-17 Thread Ted Byers
ularity of error handling logic. That is the only way to have a chance of getting one statement to execute regardless of whether or not a preceding statement throws an exception. I have a special interest in this because I am just beginning to look at Spring (I downloaded it just a few d

Re: [GENERAL] How best to represent relationships in a database generically?

2007-07-27 Thread Ted Byers
ago. Yes, I'd love to have more computing power at my disposal, but that doesn't stop me from doing useful stuff now! Modern ecological models are, at present, much more limited by the availability of good data, both for parameterizing models and for validating models, than they are b

Re: [GENERAL] Will partial index creation use existing index?

2007-07-24 Thread Ted Byers
etting your partial indeces to work well for you. HTH Ted Steve Crawford <[EMAIL PROTECTED]> wrote: Does PostgreSQL use an existing index, if possible, when creating a partial index? By way of background, we have some nightly bulk processing that includes a couple of 15-30 m

Re: [GENERAL] COPY to/from non-local file

2007-06-27 Thread Ted Byers
learned using the languages I know can be applied in some fashion to programming in Ruby. HTH Ted Jaime Silvela <[EMAIL PROTECTED]> wrote: I've been looking around for this functionality: Is it possible to use COPY with a file that doesn't reside in the DB's file

Re: [GENERAL] Temporal Units

2007-05-03 Thread Ted Byers
and Python? How would you compare them to the other options (such as C++, Java, Perl, &c.)? Cheers, Ted Rich Shepard <[EMAIL PROTECTED]> wrote: On Mon, 30 Apr 2007, Ted Byers wrote: > I am not sure I see why it would be good to do this using SQL, but I do > know

Re: [GENERAL] Temporal Units

2007-04-30 Thread Ted Byers
nefit over my more usual Perl functions. Cheers, Ted Rich Shepard <[EMAIL PROTECTED]> wrote: On Mon, 30 Apr 2007, Brent Wood wrote: > If I'm following this correctly, then interval & extract timepart can be > used to provide all the required functionality: Thank

Re: [GENERAL] Design / Implementation problem

2007-03-18 Thread Ted Byers
roposed solution would ensure that customers used their oldest points first. Maybe it does, and you didn't describe that aspect well, but that is something you'll have to be careful about if you want to avoid upset customers. Unit testing, followed by integration tests

Re: [Bulk] Re: [GENERAL] quoted identifier behaviour

2007-03-14 Thread Ted Byers
tion specific code is well separated from standard compliant code and that it is well documented. That way, when the technology evolves in a way that will likely break your code (as the coming demise of MFC will certainly do to countless WIN32 applications), it becomes easier to replace what is brok

Data validation - was Re: [GENERAL] OT: Canadian Tax Database

2007-03-09 Thread Ted Byers
n his potential return, he should rationally move on to easier targets. Cheers Ted ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Setting week starting day

2007-03-09 Thread Ted Byers
- Original Message - From: "Omar Eljumaily" <[EMAIL PROTECTED]> To: "Ted Byers" <[EMAIL PROTECTED]> Cc: Sent: Friday, March 09, 2007 5:00 PM Subject: Re: [GENERAL] Setting week starting day Ted, my reason for asking the question that I believe prec

Re: [GENERAL] Setting week starting day

2007-03-09 Thread Ted Byers
u just want a function call, I'd suggest you create a function that just dispatches a call to the Perl function that best meets your needs. In a sense, you are not really rolling your own. You're just dispatching the call to a function in a Perl package. Cheers Ted ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] security permissions for functions

2007-03-08 Thread Ted Byers
into Linux as a mere mortal, start a bash shell providing credentials for an admin account, do my admin type stuff and then close the shell). Or have I misunderstood you here WRT user ID context? Ted ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] security permissions for functions

2007-03-08 Thread Ted Byers
out granting permissions to roles or groups rather than to individual users. I mean the obvious statement, for the fine tuning he appears to me to want to do, would be to follow the REVOKE statement you show with a GRANT statement for a specific user.At least that is what I'd infer from

Re: [GENERAL] OT: Canadian Tax Database

2007-03-08 Thread Ted Byers
f our present society that is bound to degenerate into a flame war, launched by the politically correct, so we ought to say little, or even leave it alone. Those in power tend to be vicious, especially when there are no effective checks on their conduct and no consequences for what they do.

Re: [GENERAL] OT: Canadian Tax Database

2007-03-08 Thread Ted Byers
- Original Message - From: "Alan Hodgson" <[EMAIL PROTECTED]> To: Sent: Thursday, March 08, 2007 11:32 AM Subject: Re: [GENERAL] OT: Canadian Tax Database On Thursday 08 March 2007 08:15, "Ted Byers" <[EMAIL PROTECTED]> wrote: They would have satis

Re: [GENERAL] OT: Canadian Tax Database

2007-03-08 Thread Ted Byers
here things were done right, to provide a cure for the depressing and discouraging nature of what this thread has turned out to be? Cheers Ted ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] OT: Canadian Tax Database

2007-03-08 Thread Ted Byers
27;training' programmers doesn't help). It is s easy to get cynical, and very discouraged, when I think about this. :-( Maybe I should have myself lobotomized and become one of the mindless grunts at Canada post. Cheers Ted ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] php professional

2007-02-22 Thread Ted Byers
t not with sets and SQL programming. Cheers, Ted ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] backup database by cloning itself

2007-02-15 Thread Ted
trikes me as sufficient for what you say you need. If you require more, which would imply you want more than the simple backup you say you're after, then defining a suitable suite of triggers and audit tables may serve. Neither should adversely affect your users. especially if your "datab

Re: [GENERAL] backup database by cloning itself

2007-02-14 Thread Ted Byers
nd who knew what when. Historical reconstructions were required, e.g., only when something went awry and there was a need to know if a good decision was made based on bad data or a bad decision was made based on good data, or, e.g., during an audit of the business proce

Re: [GENERAL] backup database by cloning itself

2007-02-14 Thread Ted Byers
store the relevant details in an audit table including especially who made the edits and when. This strikes me as being much less work than developing code that processes so many backups. Cheers Ted ---(end of broadcast)--- TIP 1: if posting/readi

Re: [GENERAL] Having a problem with my stored procedure

2007-02-14 Thread Ted
rd party app. You can edit these functions from within pgAdmin. I have done so myself on trigger functions I created myself. This would make the OP's task almost trivially simple. Don't you just hate when you see the obvious solution only after spending time o

Re: [GENERAL] Having a problem with my stored procedure

2007-02-13 Thread Ted
rrect. So far, I see nothing preventing you from writing two trigger functions or requiring you to use so many temporaries. How does not touching the third party application affect the triggers you add to the database? Cheers Ted ---(end of broadcast)

Re: [GENERAL] Having a problem with my stored procedure

2007-02-13 Thread Ted
t;news_content" already exists > psql:archive_news_articles.sql:80: ERROR: trigger "update_archives" for > relation "news_content" already exists > > So, I thought perhaps it couldn't be done. > > > > > > Ted Byers wrote: > > Would it not be simpler to jus

Re: [GENERAL] Having a problem with my stored procedure

2007-02-13 Thread Ted Byers
pdate values directly from the NEW or OLD record into the target table rather than copying the values first into the temporaries and then from the temporaries into their final destination? HTH Ted - Original Message - From: William Leite Araújo To: Laura McCord Cc: pgsql-ge

Re: [GENERAL] Postgres SQL Syntax

2007-02-09 Thread Ted Byers
ecture for my code that should make it as easy as possible, and similarly, for moving data around, I developed my approach to be as easy and reliable as possible, even if it is not the most elegant or efficient. Cheers, Ted ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] SQL textbook

2007-02-08 Thread Ted Byers
it is good. Here are some specific suggestions. Do you have any URLs for the books that are available for download? Cheers Ted ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] Problem with result ordering

2007-01-26 Thread Ted Byers
Hi Ted, Hi Thorsten, Am Donnerstag, 25. Januar 2007 19:53 schrieb Ted Byers: The question I'd ask before offering a solution is, "Does the order of the id data matter, or is it a question of having all the results for a given id together before proceeding to the next id?"

Re: [GENERAL] Problem with result ordering

2007-01-25 Thread Ted Byers
never just assume that it is best to do all the processing in the RDBMS backend to my apps. HTH Ted - Original Message - From: "Thorsten Körner" <[EMAIL PROTECTED]> To: Sent: Thursday, January 25, 2007 10:45 AM Subject: [GENERAL] Problem with result ordering Hi,

Re: [GENERAL] MSSQL/ASP migration

2007-01-22 Thread Ted Byers
be, my first choice; that is unless I find a public domain framework in Perl or PHP that is competitive with .NET. That said, I've not had an opportunity to see how it performs in a production setting, so YMMV. HTH Ted - Original Message - From: "Robert Fitzpatrick" &

Re: [GENERAL] Hardware related question: 3ware 9500S

2006-04-12 Thread Ted Byers
- Original Message - From: "Scott Marlowe" <[EMAIL PROTECTED]> To: "Ted Byers" <[EMAIL PROTECTED]> Cc: "Merlin Moncure" <[EMAIL PROTECTED]>; "Janning Vygen" <[EMAIL PROTECTED]>; "pgsql general" Sent: Wednesda

Re: [GENERAL] Hardware related question: 3ware 9500S

2006-04-12 Thread Ted Byers
ase PostgreSQL), or located in a network appliance dedicated to storing the data managed by the RDBMS? If you were asked to design a subnet that provides the best possible performance and protection of the data, but without gold-plating anything, what would you do? How much redundancy

Re: [GENERAL] [Slightly OT] data model books/resources?

2006-03-31 Thread Ted Byers
at from the chaff, and I do not want to waste a pile of money on evaluating the range of books that are available. I'd therefore like accounts of books to avoid, and why, as well as books that are essential in any respectable collection, and why. I'm interested both in text books, with exer

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

2006-03-29 Thread Ted Byers
rward to. There is a reason I don't do much with XML even though I know how. Ted - Original Message - From: "Steve Atkins" <[EMAIL PROTECTED]> To: "pgsql general" Sent: Wednesday, March 29, 2006 12:21 PM Subject: Re: [GENERAL] PostgreSQL's XML

Re: [Bulk] [GENERAL] General advice on database/web applications

2006-03-27 Thread Ted Byers
ch machine individually. You have some legal responsibilities to protect your clients' data. I'm told, by folk who ought to know, that you could face major problems if you fail to exercise due diligence in protecting your clients' data. Cheers, Ted

[GENERAL] Double checking my logic?

2006-03-20 Thread Ted Byers
us put into a stored procedure, or should I look at doing some of it in a Perl script or java application?  I suppose I will have to have at least a basic Java application, or perl script, if only to connect to the database and invoke any functions I have created to do this.   Any suggestions wo

Re: [Bulk] Re: [GENERAL] Tool

2006-02-10 Thread Ted Byers
;s C++ Builder and Microsoft's Visual C++).  And I have no idea what the corresponding tools would be on unix/Linux (if anyone knows of such tools for Linux, I'd appreciate hearing about them as one of my computers will soon have Windows XP removed and replaced by Suse linux).  

Re: [GENERAL] Primary keys for companies and people

2006-02-02 Thread Ted Byers
tions I am designing. Any insights you, or others, may have on these questions would be greatly appreciated. Cheers, Ted R.E. (Ted) Byers, Ph.D., Ed.D. R & D Decision Support Solutions http://www.randddecisionsupportsolutions.com/ ---(end of broadcast)-

Re: [GENERAL] Logging statements and parameter values

2006-01-30 Thread Ted Powell
> No. I am with Simon Riggs today at my house and I asked him, hoping he > can get it done for 8.2. I don't think it is very hard. Various things have been pushed on my stack since I posted about this. When it gets near the top again, I'll check back. Thanks for the response.

Re: [GENERAL] Logging statements and parameter values

2006-01-30 Thread Ted Powell
On Mon, Jan 30, 2006 at 04:31:29PM -0500, Bruce Momjian wrote: > > I assume it is this TODO: > > * Allow protocol-level BIND parameter values to be logged > > > --- > > Ted Powell wrote

[GENERAL] Logging statements and parameter values

2006-01-27 Thread Ted Powell
ter? Is there a utility log routine somewhere that I can simply feed a Datum to? -- Ted Powell <[EMAIL PROTECTED]> http://psg.com/~ted/ GPL code ... It's the difference between owning your own home and just renting. --PJ ---(end of broadcast)---

Re: [Bulk] Re: [GENERAL] Best programming language / connectivity for best performance

2006-01-10 Thread Ted Byers
t work to show a client where their project was heading, but in virtually every case, I replaced them for one reason or another. They just didn't provide the feature set I required and it was just less work to use the basic controls than it was to fight with broken bound controls. Cheers,

[GENERAL] another problem with stored procedures

2005-12-29 Thread Ted Byers
y servlet that processes user data.  After all, I have bitten the bullet to learn about stored procedures and functions precisely because of my studies of ways to make distributed applications secure. Thanks,   Ted   R.E. (Ted) Byers, Ph.D., Ed.D.R & D Decision Support Softwarehttp://www.randddecisionsupportsolutions.com/

Re: [Bulk] Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
further qualify the table references, what is the correct qualification of the table references within the SQL in the function definition? Thanks, Ted ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
uggestions? - Original Message - From: Jonel Rienton To: 'Ted Byers' ; pgsql-general@postgresql.org Sent: Wednesday, December 28, 2005 4:16 PM Subject: Re: [GENERAL] Final stored procedure question, for now anyway yup, just use lowercase all the ti

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
Did you find a fix for it? - Original Message - From: Jonel Rienton To: 'Ted Byers' ; pgsql-general@postgresql.org Sent: Wednesday, December 28, 2005 1:24 PM Subject: RE: [GENERAL] Final stored procedure question, for now anyway it's

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Ted Byers
ing software to all relevant people/sites. If you faced this problem, what would you do, and why? Cheers, Ted R.E. (Ted) Byers, Ph.D., Ed.D. R & D Decision Support Software http://www.randddecisionsupportsolutions.com/ ---(end of broadcast)-

[GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
To correct that, I had to add "OR REPLACE" after "CREATE" to make the correction.   I am puzzled though that I can't find it when I go back to the pgAmin main window and search through the whole database (after pressing to refresh the contents of the windows).   Than

Re: [GENERAL] Stored procedure

2005-12-22 Thread Ted Byers
rting new data into foo, autoincrementing id in foo and providing the value of id to the insert into foo2. However, for the first block, there is no way to know where 'text' is located in the table, so it is necessary to get the value of id from the SQL statement used as t

[GENERAL] Stored procedure

2005-12-22 Thread Ted Byers
ed procedure, placing the index in a variable that has scope local to the procedure, and use that variable in the second insert?   Thanks,   Ted   R.E. (Ted) Byers, Ph.D., Ed.D.R & D Decision Support Softwarehttp://www.randddecisionsupportsolutions.com/

Re: [GENERAL] To Postgres or not

2005-07-14 Thread Ted Slate
To everyone, Thanks very much for your replies, and if these responses are any indication of Postgres quality then I'd be in good hands. Ted _ Don’t just search. Find. Check out the new MSN Search! http://search.msn.

[GENERAL] To Postgres or not

2005-07-13 Thread Ted Slate
Hello Everyone, I considering moving a product to Solaris/Linux and trying to find a good DB. Oracle is out due to cost so as far as i know the only reasonable alternatives are Postgres or Codebase or MySQL. Does anyone here have any experience using Codebase or MySql? If I stick with a tru

Re: [GENERAL] Level of replication support?

2004-10-13 Thread Ted Shab
l strenght. We aren't TCL experts though, so maybe that would have helped. --Ted --- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > Hello, > > There are two heavily supported and active > replication projects. > > 1. Slony - http://www.slony.info > 2.

Re: [GENERAL] LISTEN/NOTIFY for lightweight replication

2004-10-13 Thread Ted Shab
Thanks. I was thinking iirc was the transport protocol :-) Looks like dblink is the best bet here. --Ted --- Richard Huxton <[EMAIL PROTECTED]> wrote: > Ted Shab wrote: > > Richard, > > > > Thanks for the response. > > > > I'll look into both th

  1   2   >