[SQL] recursive query

hy with each level of the hierarchy present for aggregation etc. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <http://www.wazagua.com/> www.wazagua.com Powered by Wazagua Providing

Re: [SQL] High level discussion for design of using ACL to retrieve Data

ldistrict.districtid;   Any ideas would be great!       Joel Fradkin     -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joel Fradkin Sent: Thursday, November 10, 2005 3:19 PM To: pgsql-sql@postgresql.org Subject: [SQL] High level discussion for des

[SQL] High level discussion for design of using ACL to retrieve Data

a problem I have thought about a lot, but I have not figured out a way that will give fast access. I could do groups of access rights and do unions with distinct to get data, but I fear that would be really slow.   Any one have ideas on this subject?   Thanks in advance.   Joel Fradkin      

Re: [SQL] SQLException - SET AUTOCOMMIT TO OFF is no longer supported

I am getting ready to start using jboss with postgres (newer to jboss then postgres). Is there a mailing list for java postgres support? Can you post the connection elements for JBOSS or is that something documented in the JDBC driver?   Joel Fradkin   Wazagua, Inc. 2520

[SQL] nevermind answered my own question by looking at my question what a DOH!

select * from viwEmpIncCube where clientnum ='MSI' and Incidentdate::timestamp between '01/01/2005' and '08/18/2005 23:59' woks fine.   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EM

[SQL] dates and selection

as I hallucinating).   Many thanks for all the help.   Joel Fradkin    

[SQL] encoding question

writing. I tried using encoding =UNICODE and did not get the error, but the data looked different stored in the field, so I am guessing it messed it up. I am using NpgsqlConnection. Any one know the proper way to convert using a .net app?   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr

Re: [SQL] getting duplicate number is there a

another location. I appreciate the ideas, I could probably safely lock the numbering table as I would be afraid of locking the case table. Joel Fradkin I'd be tempted to have a case_numbers table with (year,location,max_num) and lock/read/insert to that. Makes everything explicit, and mean

[SQL] getting duplicate number is there a

h, but 5 6 times a day is still an issue for me. I use the count as a segment of my case number so each time a new case is entered the count goes up for that location for that year.   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305  

[SQL] encoding

. I can move forward using SQL_ASCHII, but would prefer to have encoding set properly, but I ma not sure what I am missing.   Any ideas would be much appreciated.   Joel Fradkin      

Re: [SQL] Function or Field?

You could also make a table with just that data in it so you don't have the field in all the records and you don't have to check all the records to see what is next. I am assuming this is some kind of a flag values used in a batch, if you just need the last id I use max(id)+1. Jo

[SQL] odd error

AIL status. /app/searchlist.asp, line 1113     Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. © 2004. WAZ

Re: [SQL] trying to do an update a bit confused.

run in 3 secs with merge joins off which is pretty fast, but now I have others that seem pretty simple to me and yet run very slow.     You're most probably missing a Where clause after the parentensis. see: -Original Message- From: Joel Fradkin [mailto:[EMAIL PROTECTED]

[SQL] trying to do an update a bit confused.

wants to do a sum on all the records in tblcase instead of just the one being updated, what am I doing wrong?   Joel Fradkin      

Re: [SQL] getting count for a specific querry

hardware issue for us. Joel Fradkin Do you run your 2650s with hyperthreading on? I found that slowed mine down under load, but we never had more than a couple dozen users hitting the db at once, so we may well have had a different load profile than what you're s

Re: [SQL] getting count for a specific querry

I will also look at doing it the way you describe, they do have wide liberty. Thanks so much for the ideas. Sorry I did not do a perusal of the archives first (I normally try that, but think I am brain dead today). Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941

Re: [SQL] getting count for a specific querry

. I am just frustrated, maybe Monday I will have better strength to figure it all out.   Joel Fradkin     CREATE OR REPLACE VIEW viwcasecube as /*customer 1*/ select c.clientnum,c.casenum,c.casereferencenum, coalesce ((select sum(quantity * amount) as

Re: [SQL] getting count for a specific querry

a count on demand if they have a specific query. Our screens have several criteria fields in each application. Joel Fradkin -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, April 08, 2005 2:28 PM To: Bob Henkel Cc: Scott Marlowe; Joel Fradkin; Andrew Sullivan;

Re: [SQL] getting count for a specific querry

Believe me I just spent two months converting our app, I do not wish to give up on that work. We do a great deal more then count. Specifically many of our queries run much slower on postgres. As mentioned I purchased a 4 proc box with 8 gigs of memory for this upgrade (Dell may have been a poor cho

Re: [SQL] getting count for a specific querry

tgres and it is not live yet, but if I am going to get results back slower then my 2 proc box running MSSQL in 2 gig and 2 processor I cant see any reason to move to it) The Postgres is on a 4 proc Dell with 8 gigs of memory. I thought I could analyze our queries and our config to optimize.

[SQL] getting count for a specific querry

ideas here. I have tried playing with various settings and have not seen my times change much, I will persue this on the performance mailing list.       Joel Fradkin      

Re: [SQL] delphi access question?

har values. Have no idea off hand *why* this would be ... character encoding differences maybe ? Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Joel Fradkin [mailto:[EMAIL PROTECTED] Sent: Wed 3/30/2005 12:15 PM To: pgsql-sql@postgresql.org Cc: [EMAIL PROTECTE

[SQL] delphi access question?

result. Any ideas? Joel Fradkin     ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] definative way to place secs from epoc into timestamp

amptz instead of timestamp). Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved

Re: [SQL] psql encoding problem

some of the routines like upper not work properly on extended chars. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. ©

Re: [SQL] diference in dates in minutes

Sorry you are correct again it is TimeStamp not date. So maybe that is why it appeared to work ok. I will do as you suggest and play around with it before I accept it is a perfect solution, but it appeared to do what I was looking for (figure the difference in minutes). Joel Fradkin Wazagua

Re: [SQL] diference in dates in minutes

the proper calculations. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZA

Re: [SQL] diference in dates in minutes

You probably want to convert the dates to timestamps, subtract them to get an interval, extract the epoch to get timme in seconds and then divide by 60 to get time in minutes. The converting date to timestamp part isn't trivial. You need to decide on what you mean when you do this. If you really h

[SQL] diference in dates in minutes

the docs and did not see it. Anyone have a example of using it to get the minutes between two date functions, or another method? Joel Fradkin   ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [SQL] How do you compare contents of two tables using 2 pk

Couldn’t you do a select * from t1 where not in uniquevar (select uniquevar from t2)? Or do a join and select on a value in t2 being null. Joel Fradkin   ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [SQL] Postgres 8 - Database access, new install.

I had a good install, but I did not install 7.4 when I installed redhat. It asked for the cd’s a couple times when I loaded the RPMS 8.0.1 I also did not use any fire wall or security (it is in a secure environment).   Joel Fradkin

Re: [SQL] Speeds using a transaction vrs not

project after actually getting the data and views has gone very smooth. Everyone has been so helpful on the lists and that is the only reason I am where I am so far so thanks again to everyone who has bothered to answer my noob questions. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota

Re: [SQL] Speeds using a transaction vrs not

of insert 'myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')" myCommand.CommandText = insertsqltext myCommand.ExecuteNonQuery() myTrans.Commit() .net driver: Dim cmd As New NpgsqlCommand(insertsqltext, cnn) cmd.ExecuteNonQuery() cm

[SQL] Speeds using a transaction vrs not

, so I am assuming it is because I am using a transaction on my odbc test. I can run again without it or with it on .net driver, but thought I would ask. We only use transaction on important multiple table updates in our system now, so should not be a huge thing, but was curious. Joel Fradkin

Re: [SQL] problem inserting local characters ...

sql_aschii so both my inserts and backup and restore work, realizing I am giving up some functionality. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based

[SQL] RE: [SQL] RE: [SQL] trrouble inserting stuff like é

with Unicode. Worst case I will just use SQL_ASCHII, I am guessing the ODBC driver does not have a encoding command like the .net one does. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua

[SQL] RE: [SQL] trrouble inserting stuff like é

PROTECTED] Sent: Friday, February 18, 2005 10:25 AM To: Joel Fradkin Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] trrouble inserting stuff like é Hi, I use LATIN1 encoding and it works fine with accented characters. So try creating your db with -E LATIN1 switch. Or even initdb -E LATIN1 if you wan&#

Re: [SQL] Comments on subquery performance

(and joins when reporting). Joel Fradkin ---(end of broadcast)--- TIP 8: explain analyze is your friend

[SQL] RE: [SQL] trrouble inserting stuff like é

its Unicode? Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. © 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc

[SQL] trrouble inserting stuff like é

runs ok, so it only gives an error using .net ODBC. Any one have any clues for me to follow? Here is an example of a SQL line that did not run in .net. insert into tblSuspectedActivity(ClientNum,ID,Value,IsDeleted,PresentationID) values('FREN',4,'Paiement à account',Fa

Re: [SQL] postgres 8 data directory other then default?

ng the whole process from install to finished working project. You all think this be a good idea, just post it here? Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with

[SQL] postgres 8 data directory other then default?

which are in tar files do I need to get those as well to get to 8.1 if so what is the procedure other then copying the files to my system (I have the .tar.bz)     Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com

[SQL] postgres 8 data directory other then default?

ok).   On the 8.1 files which are in tar files do I need to get those as well to get to 8.1 if so what is the procedure other then copying the files to my system (I have the .tar.bz)     Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305

[SQL] 8 rpms for red hat

I think it was just because we installed 7 with OS the first time, 8 ran fine but some rpm's failed to load. Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the l

[SQL] Did a good restore

default it seems unless from command line) and run my app to copy my data over to see if I can then backup and restore ok with UNICODE. I have the feeling I will be better off using it as we do anticipate foreign language users.     Joel Fradkin        

[SQL]

so is 'SQL_ASCII' or 'UNICODE' the correct choice? I was able to move all my data over to the 'SQL_ASCII' database, so I may be again answering my own question. Values like d`Appréhension show up ok in the table. Am I guessing correctly to just make the database I am restori

[SQL] Red hat 3 AS when uptodate is it running 2.6 Kernel?

Any one running Redhat 3 AS? Is it using the new Kernel when it is up to date? Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & adva

[SQL] specifying different location for data and wal on fedora core 3 /backup question again

_restore: ERROR:  invalid byte sequence for encoding "UNICODE": 0xe9   Do I have to specify ENCODING = 'SQL_ASCII'; some how? If so can anyone give me the backup and restore syntax. It gives no errors backing up, just restoring.     Joel Fradkin      

[SQL] postgres8 install on fedora core 3 (or redhat4 beta AS)

Any help? I got the 8 rpms for fedora and it keeps asking for 7.4 rpm’s, I down load the specific 7.4 stuff and it says already installed?   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com

[SQL] Assoclist is still slow and I am not seeing it

33.082 rows=5662 loops=1)" "    Filter: (1 = presentationid)" "  ->  Sort  (cost=39859.63..40122.06 rows=104970 width=53) (actual time=6763.992..7160.587 rows=99139 loops=1)" "    Sort Key: (a.clientnum)::text, a.jo

Re: [SQL] problem with backup and restore (probaly stupit newb thing)

obviously not doing it correctly). Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights rese

[SQL] problem with backup and restore (probaly stupit newb thing)

ore: creating VIEW viwsnapshot pg_restore: creating VIEW viwtendercube pg_restore: creating VIEW viwtnwincident pg_restore: creating VIEW viwusma_count pg_restore: restoring data for table "tbl_i2an_default_values" pg_restore: restoring data for table "tblaction" pg_restore: ERROR:  invalid byte sequence for encoding "UNICODE": 0xe9 CONTEXT:  COPY tblaction, line 1799, column value: "Chargé" pg_restore: [archiver (db)] error returned by PQendcopy pg_restore: *** aborted because of error   Process returned exit code 1.   Joel Fradkin     ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [SQL] pg_restore problem

was very complex view) on postgres, my guess is I still have stuff to do. I did try changing the cost to a lower number in config and redid my analyze, but it was still trying to do a seq scan.   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext

Re: [SQL] MSSQL versus Postgres timing

leted from tblassociate a left outer join tbljobtitle jt on a.jobtitleid = jt.id and jt.clientnum = a.clientnum and 1= jt.presentationid inner join tbllocation l on a.locationid = l.locationid and l.clientnum = a.clientnum ; Joel Fradkin Wazagua,

Re: [SQL] MSSQL versus Postgres timing

--- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:07 PM To: Joel Fradkin Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] MSSQL versus Postgres timing On Tue, Feb 01, 2005 at 11:54:11AM -0500, Joel Fradkin wrote: > > A table with 645,000 records for associates

Re: [SQL] MSSQL versus Postgres timing

-Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:07 PM To: Joel Fradkin Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] MSSQL versus Postgres timing On Tue, Feb 01, 2005 at 11:54:11AM -0500, Joel Fradkin wrote: > > A tabl

Re: [SQL] MSSQL versus Postgres timing

With seq scan on. -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:07 PM To: Joel Fradkin Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] MSSQL versus Postgres timing On Tue, Feb 01, 2005 at 11:54:11AM -0500, Joel Fradkin wrote: >

Re: [SQL] MSSQL versus Postgres timing

333.26 rows=85611 width=52) (actual time=20667.645..21031.627 rows=99139 loops=1)" " Sort Key: (a.clientnum)::text, a.jobtitleid" "-> Seq Scan on tblassociate a (cost=0.00..31105.34 rows=85611 width=52) (actual time=14.768..16024.395 ro

[SQL] MSSQL versus Postgres timing

an index on clientnum (there is one on clinetnum, associateID in MSSQL). I did an analyze. I did a set seq scan off   Is there a possibility postgres is this much slower, or (my hope) I am missing some key concept. Be glad to provide the view and tables etc.   Joel Fradkin    

[SQL] hardware mod based on feedback from the list

processors) will not be a issue, but hopefully adding the additional drive systems will help the most for IO is what I am told is the big issue and hopefully utilizing the recommendation will help minimize the bottleneck. Joel Fradkin     ---(end of broadcast

[SQL] Hardware for best performance was same question little different test MSSQL vrs Postgres

uggestions I would be very appreciative. I know that's a lot to ask so if you don't have time that's cool, thanks so much for bringing this up so that my next purchase I will seriously look at quad Opteron technology if it is a tried and true solution for this OS and Postgres. Joel

Re: [SQL] same question little different test MSSQL vrs Postgres

so if you don't have time that's cool, thanks so much for bringing this up so that my next purchase I will seriously look at quad Opteron technology if it is a tried and true solution for this OS and Postgres. Joel Fradkin -Original Message- From: Andrew Hammond [mailt

Re: [SQL] same question little different test MSSQL vrs Postgres

inal message, including attachments. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 11:50 AM To: Joel Fradkin Cc: 'Richard Huxton'; [EMAIL PROTECTED]; pgsql-sql@postgresql.org; [EMAIL PROTECTED]; Steve Goldsmith Subject:

Re: [SQL] same question little different test MSSQL vrs Postgres

night). The 117 was before I forced the seq off so even doing a seq I am getting results now that are better then MSSQL. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the l

Re: [SQL] same question little different test MSSQL vrs Postgres

all I ever saw it use). I guess the swap buffers and cache are the important settings (least that seems to be what is affecting the memory). Not sure exactly what would cause it to use seq vrs index, but I will try the force and see if it helps the speed. Joel Fradkin Wazagua, Inc. 2520 Trailmate

Re: [SQL] same question little different test MSSQL vrs Postgres

can learn what is needed to get the maximum performance. I have seen much information available and this list has been a huge resource. I really appreciate all the help. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 > QUERY PLAN > "

Re: [SQL] same question little different test MSSQL vrs Postgres

QUERY PLAN "Seq Scan on tblcase (cost=0.00..30066.21 rows=37401 width=996) (actual time=0.344..962.260 rows=22636 loops=1)" " Filter: ((clientnum)::text = 'SAKS'::text)" "Total runtime: 1034.434 ms" Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Saraso

[SQL] Sorry I see my first question did not get posted (maybe because of the attatchments)

seconds on my MSSQL system. Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. © 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,

[SQL] same question little different test MSSQL vrs Postgres

indexed search.   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. © 2004. WAZAGUA, Inc. All rights reserved. WAZ

Re: [SQL] datediff is there something like it?

Yes I am using datepart, but not seeing how with a datediff. Maybe I just need to do the date math and put a date part on the result. I will play around a bit when I hit one not looking for days. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305

[SQL] datediff is there something like it?

Hi all working my way through our views and all is going very well. We use datediff in MSSQL a bit and I read about the field1::date – field2::date to return the days numerically. Is there any way to get months and years besides guessing days / 30 for months etc?   Joel Fradkin

Re: [SQL] editors with colum positioning for debugging?

could use 8 for development and 7 for production I guess. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZ

[SQL] editors with colum positioning for debugging?

as also able to add the view that had given me the row too large error. Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. ©

Re: [SQL] still having pg_user error

resource and I appreciate all the ideas comments and help it has made the difference for me. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology

Re: [SQL] still having pg_user error

nd am more then a little worried about administering the production (we ordered a 4 processor Dell with Red HAT, I believe I will also need to install it). Again thank you for that piece of advice, I can always re-install Linux and verify the SELinux option is off, maybe I messed up again. Jo

[SQL] still having pg_user error

, but I guess I will just have to try again tomorrow.   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. ©

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

for each use of function and feel it will be better to just convert the SQL (the hit was only milisecs on first number I guess the prepare part, but still might as well have it be as fast as possible). Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

using postgres is this a limit of mysql also? I hate to think I have to consider staying on MSSQL as it is not in our budget. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with

[SQL] pg_user relationship does not exist

Not sure this is the correct place to ask, but when I log in with pgadminIII I get that message.   Any ideas how to fix? Do I need to redo my data base or something?   Joel Fradkin   Wazagua, LLC 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

, maximum size 8136 Joel Fradkin Wazagua, LLC 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, LLC. All rights reserved. WAZAGUA, LLC

[SQL] ERROR: row is too big: size 9856, maximum size 8136

I get ERROR:  row is too big: size 9856, maximum size 8136 when inserting a view?   Help   Joel Fradkin   Wazagua, LLC 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest

[SQL] Conversion ideas (Views/procedures)

how to that alerted me to the datefiff being date_diff and to watch out for the yy needing to be 'year' etc. he mentioned to use coalesce() instead of isnull also. Any other common ones I should be aware of? Joel Fradkin   Wazagua, LLC 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  94

[SQL] postgres stored procedures

Any advice on converting my mssql to postgres? Points of reference would be great! All 290 tables moved over ok, some data loss, and I will look at that much closer next time I run my conversion app. Now Views and Stored procedures. Joel Fradkin   Wazagua, LLC 2520 Trailmate Dr Sarasota

[SQL] I am writing a MS SQL server conversion utility and am having an issue with timestamp

time to timestamp?   Joel Fradkin   Wazagua, LLC 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. © 2004. WAZAGUA, LLC. All rights rese