Re: [GENERAL] ctid access is slow

2005-08-23 Thread Jeff Eckermann
Ilja Golshtein [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello! On Tue, Aug 23, 2005 at 09:15:42AM -0400, Robert Treat wrote: On Tuesday 23 August 2005 08:39, Ilja Golshtein wrote: select ctid from aaa where ctid in (select ctid from aaa limit 10); Aside from that, ctid is

Re: [GENERAL] ctid access is slow

2005-08-23 Thread Jeff Eckermann
--- Jim C. Nasby [EMAIL PROTECTED] wrote: On Wed, Aug 24, 2005 at 09:26:10AM +0930, Jeff Eckermann wrote: The ctid value can be useful in a multi user application, to check whether a record has been changed by another user, before committing changes. Whenever a record is updated

Re: [GENERAL] ctid access is slow

2005-08-23 Thread Jeff Eckermann
--- Tom Lane [EMAIL PROTECTED] wrote: Jim C. Nasby [EMAIL PROTECTED] writes: I believe that's not necessarily true. If you select a tuple and it's ctid and it's updated more than once with a vacuum in-between I believe it could end up back in the same position, which would mean the same

Re: [GENERAL] download binary version for Win32

2005-08-21 Thread Jeff Eckermann
Ulises Poirier [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello: I can't to download this version..can you help me? What did you do, and what happened? A copy-and-paste of a terminal session would be ideal. regards, Ulises ---(end of

Re: [GENERAL] linking access using ODBC driver with geometric data

2005-08-07 Thread Jeff Eckermann
Jeff D. Hamann [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sorry for the seemingly novice posting, but I could find a solution for this on the web so far... I've been developing a database using postgresql (and loving it) and have started running into problems with attempting to

Re: [GENERAL] For Tom Lane

2005-06-01 Thread Jeff Eckermann
Scott Marlowe [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Fri, 2005-05-27 at 09:57, [EMAIL PROTECTED] wrote: Thanks for answer Tom Consider what happens when the user leaves for lunch Well, I've already thought about it.But I'm working with VS2003 and disconnected

Re: [GENERAL] double quotes inside VBA string ?

2005-05-18 Thread Jeff Eckermann
Zlatko MatiƦ [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello. I have a problem when working with MS Access/PostgreSQL. Namely, as PostgreSQL syntax uses doble quotes for table names and field names, when I write it as a string of a pass-through query or Command text of ADO

Re: [GENERAL] Delphi 2005, Postgresql, ZEOS optimistic locking

2005-05-13 Thread Jeff Eckermann
Philippe Lang [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, Yes, I'm sure this kind of feature is application-based. There is nothing in the driver itself. If I'm not wrong, MS Access uses a timestamp column to check if the record was updated meanwhile, or the column values

Re: [GENERAL] MS-Access and Stored procedures

2005-05-13 Thread Jeff Eckermann
Zlatko Matic [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I was using ADO command object and both refresh method and method with creating parameter object while working with Access Project...but I didn't try to use it with PostgreSQL... I would rather like to have all queries on

Re: [GENERAL] Adventures in Quest for GUI RAD

2005-05-06 Thread Jeff Eckermann
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] It is just too bad that there is not a better, more user friendly, well documented front-end tool for Postgresql in open source. It really is kind of a marketing issue, in a way. I mean, if someone could really put together some

Re: [GENERAL] Howto prevent write based on date

2005-05-05 Thread Jeff Eckermann
Fmiser [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm a newbie to database admin, but I'm not afraid to try - but this one has me stumped. I'm using SQL-Ledger as a front end to postgresql 7.4.2. on (mostly) Debian Testing, i386. My fiscal year is over and I would _like_ to

Re: [GENERAL] [INTERFACES] calculated identity field in views, again...

2005-05-04 Thread Jeff Eckermann
--- Zlatko Matic [EMAIL PROTECTED] wrote: I asked this question several weeks ago, but nobody proposed a solution, so I am repeating the same question again... I have an MS Access front-end for a database on PostgreSQL. I could use pass-through queries as record sources for reports and it

Re: [GENERAL] [ODBC] Adventures with P2P and Scripts in Windows

2005-04-30 Thread Jeff Eckermann
--- [EMAIL PROTECTED] wrote: I DID Succeed in doing the sort of things I want in VBA script in MSAccess, but that does me no good at work because we cant get the money to purchase copies of Access. I own a copy of Visual Basic, and if I could find a good example of accessing

Re: [GENERAL] Calculated bigserial column in a view

2005-04-26 Thread Jeff Eckermann
Bruno Wolff III [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Please keep replies copied to the list so that other people can learn from and comment on the discussion unless to have a good reason to make the thread private. On Mon, Apr 25, 2005 at 21:46:20 +0200, Zlatko Matic

Re: [GENERAL] artificial keys or not?

2005-04-25 Thread Jeff Eckermann
Scott Ribe [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ..so the only question is: drop the the serials as PKs and just use short text handles? our database size is arround 290 mb. there shouldn't be speed issues as long as proper indexes exit, right? some of the conditions are

Re: [GENERAL] Playing with PostgreSQL and Access VBA

2005-04-25 Thread Jeff Eckermann
Tony Caduto [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In a real application that uses a client/server type database you should NEVER construct queries that return a million rows. You have to keep in mind that each record has to be sent accross the wire via TCP/IP and it is

Re: [GENERAL] psqlodbc MSAccess and Postgresql

2005-04-22 Thread Jeff Eckermann
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thanks for the help with /dt... Mike, your post helped me to discover psql command window, I had been trying out the pgAdmin ... I found an interesting article regarding MSAccess as a front end to Postgresql, so I downloaded the

Re: [GENERAL] Postgresql Windows ODBC

2005-04-22 Thread Jeff Eckermann
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Tonight I shall install the Postgresql ODBC driver which I downloaded, and experiment. Is anyone using ODBC? I was looking at Realbasic standard edition (not professional), and thinking of downloading the demo and trying it with the

Re: [GENERAL] ADO and PostgreSQL functions

2005-04-18 Thread Jeff Eckermann
Zlatko MatiƦ [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello. While I was working with Access Projects (Access front-end with MSDE) I was able to call stored procedures by using ADO command and parameters object. Now I am trying to migrate my database from MSDE to Postgre

Re: [GENERAL] Crystal reports 9 fails to recognise data on upgrade to 8.0.1

2005-04-12 Thread Jeff Eckermann
Looks like your ODBC settings might have changed in the switch. In particular, look at the text as longvarchar setting. If you cannot find a solution, try posting to the pgsql-odbc list. Kristina Magwood [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, We are updating from

Re: [GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters

2005-02-11 Thread Jeff Eckermann
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, How do I call a StoredProcdure, written in PlPqSql which returns a set of records (or tableWhatever) and wants parameters, from ADO while using adCmdStoredProc ? I don't believe that works (anyone who thinks I'm wrong, please

Re: [GENERAL] Certifications in military environment

2004-11-17 Thread Jeff Eckermann
--- Marco Bizzarri [EMAIL PROTECTED] wrote: Hi all. I would like to know if postgresql has any certification for the military environment. There are no official certifications, nor are there likely to be. But certifications may be offered by individual companies, like Red Had does with

Re: [GENERAL] PostgreSQL certification

2004-11-17 Thread Jeff Eckermann
--- Konstantin Danilov [EMAIL PROTECTED] wrote: Hello everyone! I have a question.. Does PostgreSQL have official certification? If yes, where can I find certification courses to get a certificate? There are no official certifications. Anyone who wants to can offer their own certifications,

Re: [GENERAL] Last value inserted

2004-11-16 Thread Jeff Eckermann
--- Jerry III [EMAIL PROTECTED] wrote: Which means that sometimes they do not return the correct value - if you have a trigger that inserts another record you will not get the right value. If you are new to PostgreSQL, as you say, then why are you so sure of this? Perhaps you may profit

Re: [GENERAL] OID's

2004-11-16 Thread Jeff Eckermann
--- Joolz [EMAIL PROTECTED] wrote: Thanks. Btw what's going on on the list??? I seems someone is posting a lot of obscene nonsense, using my email address. I saw this happen before with someone else. Is there anything I can do about it? This is the down side of free will. Human

Re: [GENERAL] I spoke with Marc from the postgresql mailing list.

2004-11-12 Thread Jeff Eckermann
--- Brian {Hamilton Kelly} [EMAIL PROTECTED] wrote: Which only confirms my opinion that he's a fuckwit. Evidently some of the nastiness out there on Usenet is propagating into our lists in advance of any change. __ Do you Yahoo!? Check out

Re: [GENERAL] Important Info on comp.databases.postgresql.general

2004-11-11 Thread Jeff Eckermann
--- William Yu [EMAIL PROTECTED] wrote: ??? As a longstanding reader of the pgsql- mailinglists, (including via news.postgresql.org on occasion), all I see is some outsiders trying to help us fix a problem that does not exist. And yes, I have read most of the messages that have

Re: [GENERAL] Important Info on comp.databases.postgresql.general

2004-11-10 Thread Jeff Eckermann
--- Gary L. Burnore [EMAIL PROTECTED] wrote: On 9 Nov 2004 15:51:24 -0800, [EMAIL PROTECTED] wrote: This is a very unfair limitation. Stop top posting. If there is a ballot, it should be posted to each of the individual mailing lists. That's not how it works. When/if a ballot

Re: [GENERAL] Lost databases

2004-11-10 Thread Jeff Eckermann
--- Liviu BURCUSEL [EMAIL PROTECTED] wrote: Hi ! I'm in the ultimate state of dispair. Over the night some of my databases just disapeared. But they did not dissaper totally. I can still connect to them but I cannot dump them. When doing a select * from pg_database I see only 2

Re: [GENERAL] Rows created by a stored proc prompt Access' dreaded write conflict

2004-11-02 Thread Jeff Eckermann
--- Sim Zacks [EMAIL PROTECTED] wrote: After the stored procedure is run, call requery on the form that was updated. We are in the middle of moving Access implementations to PostGreSQL. I'd be happy to trade war stories, if you'd like. I hope that you do it on the list, so that the rest

Re: [GENERAL] ERROR: parser: unterminated quoted string

2004-09-09 Thread Jeff Eckermann
--- Daniel Secomb [EMAIL PROTECTED] wrote: Hi, I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the following error when I try and run a SQL query on a script: Error - /usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php -- Line: 33 PostgreSQL said:

Re: [GENERAL] Single Row Table?

2004-08-31 Thread Jeff Eckermann
--- Scott Marlowe [EMAIL PROTECTED] wrote: On Sun, 2004-08-29 at 15:30, Bruno Wolff III wrote: On Fri, Aug 27, 2004 at 13:32:07 +0530, Yateen Joshi [EMAIL PROTECTED] wrote: Hi, I have got a table which is supposed to contain only one row. It does not have any primary keys

Re: [GENERAL] Replication options?

2004-08-11 Thread Jeff Eckermann
--- Tom Lane [EMAIL PROTECTED] wrote: Jeff Eckermann [EMAIL PROTECTED] writes: That probably won't impress your bosses. If you need a track record, then erServer might be what you need. erServer is a commercially produced product that was (is still?) used by Afilias, the provider

Re: [GENERAL] New to Postgres

2004-08-06 Thread Jeff Eckermann
--- Darkcamel [EMAIL PROTECTED] wrote: Hello all, I am new to postgres and don't really understand how the database is set-up. I am very fluent with mysql and sql2000, but postgres is new to me. If anyone can point me to some good links I would appreciate it very

Re: [GENERAL] Getting started with replication

2004-07-15 Thread Jeff Eckermann
Slony seems to be moving to the head of the pack of replication solutions. Still too new to say definitively. Slony author Jan Wieck has said repeatedly that replication is used in practice to meet various needs, and there is no one replication solution that can be ideal for all of them. For

Re: [GENERAL] Training and certification

2004-07-09 Thread Jeff Eckermann
I recall an extended discussion of certifications and training some time back. You may recall it, too. The outcome (if it may be so called) was the view that, given the nature of the PostgreSQL project, there exists no entity that can bless a certification and thereby make it official, any more

Re: [GENERAL] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

2004-05-30 Thread Jeff Eckermann
--- Paul Thomas [EMAIL PROTECTED] wrote: On 28/05/2004 20:46 Jeff Eckermann wrote: I had a thought that the ODBC driver could be stripping the trailing spaces, but the test I just did (using MS Access via ODBC) worked fine. But that's using a different ODBC driver so won't show

Re: [GENERAL] insert/update

2004-05-27 Thread Jeff Eckermann
--- Tom Allison [EMAIL PROTECTED] wrote: Jeff Eckermann wrote: --- Tom Allison [EMAIL PROTECTED] wrote: I seemed to remember being able to do this but I can't find the docs. Can I run a sql query to insert new or update existing rows in one query? So I have to watch out

Re: [GENERAL] insert/update

2004-05-26 Thread Jeff Eckermann
--- Tom Allison [EMAIL PROTECTED] wrote: I seemed to remember being able to do this but I can't find the docs. Can I run a sql query to insert new or update existing rows in one query? Otherwise I have to run a select query to see if it's there and then another one to update/insert.

Re: [GENERAL] eval in plpgsl

2004-04-08 Thread Jeff Eckermann
--- Mage [EMAIL PROTECTED] wrote: Bruce Momjian wrote: Uh, we have EXECUTE, but I don't know if will allow you to set a local variable. Maybe you can do: execute doesn't support select into It does, if you use the for variablename in execute ... syntax. Which may seem like

Re: [GENERAL] Native Win32 port - PLEASE!

2004-03-26 Thread Jeff Eckermann
--- Rick Gigger [EMAIL PROTECTED] wrote: So can I quietly beg the Win32 group to expedite this port. I believe you will be utterly astonished at the demand. Please. I'm sure quietly begging certain developers with your pocekt book probably wouldn't hurt your cause either. :)

Re: [GENERAL] check date validity

2004-01-16 Thread Jeff Eckermann
--- Harald Fuchs [EMAIL PROTECTED] wrote: In article [EMAIL PROTECTED], LitelWang [EMAIL PROTECTED] writes: I need this function : CheckDate('2002-02-29') return false CheckDate('2002-02-28') return true Why would you want to do that? Just try to insert '2002-02-29' into your DATE

Re: [GENERAL] what we need to use postgresql in the enterprise

2004-01-12 Thread Jeff Eckermann
--- [EMAIL PROTECTED] wrote: I write this to tell you why we won't use postgresql even though we wish we could at a large company. Don't get me wrong I love postgresql in many ways and for many reasons , but fact is fact. If you need more detail I can be glad to prove all my points. Our

Re: [pgsql-advocacy] [GENERAL] Is my MySQL Gaining ?

2003-12-30 Thread Jeff Eckermann
--- Bret Busby [EMAIL PROTECTED] wrote: On Mon, 29 Dec 2003, Jeff Eckermann wrote: Isn't this what books are supposed to be for? i.e. to fill in the gaps or provide the coverage, tips, howtos etc. etc. that no-one really expects formal documentation to cover. There are quite a few

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-29 Thread Jeff Eckermann
This has been an interesting thread, with lots of well considered contributions. The consensus seems to be PostgreSQL is plenty good enough and more, we just need more people to know it, and an easier learning path. What bothers me a little here is an apparent lack of awareness of the work of

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Jeff Eckermann
Chris, Your persistence and your ideas suggest that you have something to contribute in this area. Why not sign up on the pgsql-advocacy list, and carry your ideas forward there? That would be an appropriate forum for this kind of discussion. The arguments on both sides (if there are only two

Re: [GENERAL] Export CSV from psql

2003-11-24 Thread Jeff Eckermann
--- Craig O'Shannessy [EMAIL PROTECTED] wrote: As it's very unlikely that there are tab's in your strings, tab makes a much safer field separator. Probably, but I wouldn't bet the farm on it. I have found plenty of instances of unexpected tabs, especially with data generated from

Re: [GENERAL] plpgsql: return multiple result sets or temp table

2003-10-22 Thread Jeff Eckermann
--- Oksana Yasynska [EMAIL PROTECTED] wrote: Jeff, thank you for the time and suggestion. I'm also trying to use SETOF custom_type as a solution I don't believe that works in 7.2. But if you do make it work, be sure to tell me how ;-) That will work with 7.3, but I am assuming that, as

Re: [GENERAL] plpgsql: return multiple result sets

2003-10-18 Thread Jeff Eckermann
--- Oksana Yasynska [EMAIL PROTECTED] wrote: Hi all, I'm running Postgres 7.2.1 and I need to return multiple row sets from plpgsql function. I'm new in plpgsql but according documentation and everything I could find in the mailing list I need to switch to 7.3 to get at least SETOF

Re: [GENERAL] PG tools

2003-10-14 Thread Jeff Eckermann
--- G Lam [EMAIL PROTECTED] wrote: Hi, I am new to postgresql. I have done some small applications with MS Access. Are there some PG tools out there that can build applications like MS Access does out there? MS Access works well with PostgreSQL via ODBC. Check here:

Re: [GENERAL] Migrating Access to Postgres

2003-10-03 Thread Jeff Eckermann
--- Fabrizio Mazzoni [EMAIL PROTECTED] wrote: Hello .. i did the migration and my advice is that you forget about the automatic translation tools... I have used the migration wizard that comes as a plugin for PgAdminII, and was very happy with the result. Yes, you can do everything by hand,

Re: [GENERAL] Picture with Postgres and Delphi

2003-09-10 Thread Jeff Eckermann
This discussion provides an opportunity to capture the essentials of how to store and retrieve images using PostgreSQL, and the issues (performance, administration etc.) associated with each possible method. A discussion article on Techdocs (or even General Bits?) would be a fine thing. My

Re: [GENERAL] Picture with Postgres and Delphi

2003-09-09 Thread Jeff Eckermann
--- Jonathan Bartlett [EMAIL PROTECTED] wrote: I'm a big fan of bytea. In every case where I've done the filesystem method I wished I hadn't. For the education of me and maybe others too, why was that? i.e. what problems did you run into, that bytea avoids?

Re: [GENERAL] Trunc in Postgres

2003-09-03 Thread Jeff Eckermann
Look at the trim function. While you are about it, looking over the other available functions would be worth your while too (look under Functions and Operators in the docs). --- Amin Schoeib [EMAIL PROTECTED] wrote: Hi, Is there an equivalent for the trunc function of Oracle in Postgres???

Re: [GENERAL] Oracle decode Function in Postgres

2003-09-03 Thread Jeff Eckermann
--- Amin Schoeib [EMAIL PROTECTED] wrote: Hi, Like I see there is no equivalent to the Oracle decode Function In Postgres.Is there maybe somebody who wrote decode as a Function? The problem for any such body is that there is no one function possible in PostgreSQL that will cover all of the

Re: [GENERAL] Case sensitivity issue

2001-09-14 Thread Jeff Eckermann
use ILIKE instead of LIKE or use a regular expression match: ~* 'red' - Original Message - From: Michael Gay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 09, 2001 11:02 PM Subject: [GENERAL] Case sensitivity issue If I am doing a command such as select * from

Re: [GENERAL] joinning tables

2001-09-14 Thread Jeff Eckermann
Outer joins are supported in PostgreSQL, but not before version 7.1. If you are using version 7.1, please post your failing query, and someone will be able to help you. Emmanuel SARACCO [EMAIL PROTECTED] wrote in message 9nnjc3$68p$[EMAIL PROTECTED]">news:9nnjc3$68p$[EMAIL PROTECTED]... hi,

Re: [GENERAL] error while generating and EXECUTEing a query dynamically

2001-09-14 Thread Jeff Eckermann
Your function worked fine for me (I copied and pasted). What PostgeSQL version are you running? EXECUTE is a new feature for version 7.1. - Original Message - From: Gaurav Priyolkar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 12, 2001 1:15 PM Subject: [GENERAL]

Re: [GENERAL] COPY command with timestamp and NULLs

2001-09-10 Thread Jeff Eckermann
COPY expects NULL to be represented by \N by default. Probably easiest to explicitly specify on the command line what you want COPY to recognize as a NULL: copy table from wherever with null as 'something'; - Original Message - From: Dwayne Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: [GENERAL] SQL Loader?

2001-09-10 Thread Jeff Eckermann
COPY is the command used for bulk loading in PostgreSQL (check the SQL Commands in the Reference Manual part of the docs). COPY is not intelligent about interpreting varying data formats. Your flexibility is limited to specifying the data delimiter and whatever string you want to represent NULL.

Re: [GENERAL] template0 and template1 databases

2001-09-06 Thread Jeff Eckermann
No. template0 is new for version 7.1. No doubt a developer can tell you exactly why dropping template0 would be a very bad idea; I am just getting in quickly to make sure you don't do so in the interim :-) - Original Message - From: Andrew Gould [EMAIL PROTECTED] To: J.H.M. Dassen

Re: [GENERAL] Regarding Vacuumdb

2001-08-31 Thread Jeff Eckermann
Before doing anything so drastic, you may want to check the archives for recent messages on a similar error. IIRC, this problem can be caused by rolling back a drop table command. The effect is that the table structure in the database remains, but the physical file is gone. The fix is to

Re: [GENERAL] Newbie ...Function error (Stored Procedure)?

2001-08-31 Thread Jeff Eckermann
I think you need to double the single quotes around the sequence name: (''seq1''). Statements inside function definitions go through an extra level of parsing, which strips off one set of single quotes. - Original Message - From: Ron S [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

[GENERAL] Re: problems transfering databases

2001-08-24 Thread Jeff Eckermann
cause real problems with any app that tries to use those fields, and a headache to debug. - Original Message - From: Rob Arnold To: Jeff Eckermann ; Miroslav Koncar Cc: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 6:32 PM Subject: Re: problems transfering

Re: [GENERAL] problems transfering databases

2001-08-24 Thread Jeff Eckermann
I think we may be using too many words in this discussion. Perhaps there is a message in this thread that I have not seen. Miroslav, have you tested for carriage returns in your data, and if so, what did you find? If that is the problem, the carriage returns are easily edited out, and speculation

Re: [GENERAL] problems transfering databases

2001-08-23 Thread Jeff Eckermann
Looks like you already have the answer. The error message is a dead giveaway. Some field, in this case having a null value (represented as '\N') contains a carriage return character, like: '\NCR'. PostgreSQL cannot make sense out of this combination, so it returns an error. The CR contained

RE: [GENERAL] Calling stored procedures.

2001-08-20 Thread Jeff Eckermann
You need to declare the variable ret, i.e. add a line before BEGIN like: DECLARE ret integer; Your function will not work without that. You may still get an error for some other unknown reason, or you may not. I have found that plpgsql errors can be highly uninformative, or downright misleading.

RE: [GENERAL] Large OR query

2001-06-12 Thread Jeff Eckermann
I would load the 1000 values into a temporary table, and join on the ID field. I usually find that approach gives much faster results. -Original Message- From: Zak McGregor [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 7:42 AM To: [EMAIL PROTECTED] Subject: [GENERAL]

RE: [GENERAL] pg_dump pg_dumpall problem.

2001-05-31 Thread Jeff Eckermann
I was bitten by the same problem recently. It means that the owner of the pgsql call handler no longer exists. To find out the id of the owner, do a select like: select * from pg_proc where proname like 'plpg%'; Then create a user having that id. You may need to edit pg_shadow to get the

RE: [GENERAL] MS SQL 7.0 to PostgreSQL 7.1

2001-05-09 Thread Jeff Eckermann
Also: * Watch out for embedded tabs and carriage returns in your data: these will cause problems during or after your COPY into PostgreSQL. * Check the value used in the exported file to represent NULL values (could be an empty string, or NULL, or something else), and use that in your

RE: [GENERAL] Improve a query...

2001-05-02 Thread Jeff Eckermann
Try: SELECT DISTINCT ON (org_id) rpt_id, org_id, period,... FROM reports ORDER BY period DESC; -Original Message- From: Eric G. Miller [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 4:04 AM To: PostgreSQL General Subject: [GENERAL] Improve a query... Looking for the

RE: [GENERAL] Data Export from PostGreSQL

2001-04-26 Thread Jeff Eckermann
I got good results in a test case, just using a standard PostgreSQL dump file created with INSERT statements (pg_dump -d). All it needed was a little editing to change some of the data types in the table definition, e.g. from text and varchar to varchar2 (if your Oracle table is set up, you

RE: [GENERAL] pg_dump failure: handler procedure for language plpgsql not foun d

2001-04-24 Thread Jeff Eckermann
, please let me know. In any case, pg_dump is now working for me. Thank you once again for your valuable help. Regards -Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 6:23 PM To: Jeff Eckermann Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL

RE: [GENERAL] PL/pgSQL problems

2001-04-19 Thread Jeff Eckermann
Have you dropped and recreated the function since creating the trigger? Try dropping and recreating the trigger. Errors like this happen because database objects (tables, functions etc) are referenced by object ids (oids) behind the scenes. Recreating an object (like a function) will give it a

RE: [GENERAL] Re: Load Text File into DB

2001-04-16 Thread Jeff Eckermann
COPY expects tab delimiters by default, so specifying them is not strictly necessary in this case. Specifying "null as xxx" is a good idea, because COPY interprets an empty field as an empty string, which will cause failure for non text-type fields. A couple of other things to watch out for when

[GENERAL] Backend sent D message without prior T

2001-04-14 Thread Jeff Eckermann
My main server is down, so I am using my backup copy on a different database. Based on past posts I have read, this error is usually associated with running out of memory for the query result. Problem is, I am only expecting about 30 lines of moderate length to be returned I see nothing in

RE: [GENERAL] dynamic field names in a function.

2001-03-30 Thread Jeff Eckermann
In my experience, the best way to find out answers like this is to try it out and see. Usually I find that I need to fiddle around with the syntax a bit (I believe it's called debugging) before getting something to work. Postgresql is very powerful; the capability to utilize that power comes at

RE: [GENERAL] converting .xls to delimited file

2001-01-10 Thread Jeff Eckermann
Excel can do this for you, if you use File - Save As... You will find various file types available. The list will vary according to the completeness of your Excel installation. I believe that at minimum you should have "tab delimited text" available, and probably csv as well (don't use csv,

[GENERAL] Cluster means tangle for me

2001-01-09 Thread Jeff Eckermann
I would appreciate any advice on getting out of this strange situation. My table now doesn't exist, but I can't recreate it either (at least under that name). jeffe@kiyoko= psql -V psql (PostgreSQL) 7.0.0 jeffe@kiyoko= uname -a FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu

RE: [GENERAL] Help with SQL Function

2001-01-08 Thread Jeff Eckermann
:[EMAIL PROTECTED]] Sent: Saturday, January 06, 2001 3:41 PM To: Jeff Eckermann Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Help with SQL Function Jeff Eckermann [EMAIL PROTECTED] writes: extracts=# create function testfunc(text) returns int4 as ' extracts'# select count

RE: [GENERAL] Off topic? - Solution for a delimiter problem

2000-12-21 Thread Jeff Eckermann
Isn't this overkill? Something like: sed -e 's/\" \"/^I/g' -e 's/\"//g' file would do the job nicely. I'm sure people on this list can suggest even simpler ways (note: the "^I", or tab character, in the example is created by typing Ctrl-V then Ctrl-I). Sed has been (and is) my friend for

[GENERAL] String substitution with translate function

2000-11-15 Thread Jeff Eckermann
I have been trying to use the translate function to delete a specific string from entries in a particular column, as in "translate(column, 'string', '')". What I find is that "translate" is treating the nominated string as a character class, and is deleting every instance of every character in

[GENERAL] String substitution with translate function

2000-11-15 Thread Jeff Eckermann
(My first attempt at posting didn't make it to my mailbox, so I am reposting. Apologies to any who get this twice.) I have been trying to use the translate function to delete a specific string from entries in a particular column, as in "translate(column, 'string', '')". What I find is that

RE: [GENERAL] Index on substring?

2000-10-12 Thread Jeff Eckermann
To: Jeff Eckermann Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Index on substring? Jeff Eckermann [EMAIL PROTECTED] writes: extracts=# create index c_namesum_i on customers (substr(bill_company,1,5)); ERROR: parser: parse error at or near "1" The functional-index s

[GENERAL] Index on substring?

2000-10-11 Thread Jeff Eckermann
I thought this was possible, but searching the archives docs I can't find any reference to it... Am I doing something wrong? jeffe@kiyoko= psql -V psql (PostgreSQL) 7.0.0 jeffe@kiyoko= uname -a FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu Apr 27 10:44:07 CDT 2000

RE: [GENERAL] Query bombed: why?

2000-05-09 Thread Jeff Eckermann
--Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 09, 2000 12:35 PM To: Jeff Eckermann Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Query bombed: why? Jeff Eckermann [EMAIL PROTECTED] writes: After about 25 minutes of running a query with a "w

[GENERAL] Memory leak in FreeBSD?

2000-01-11 Thread Jeff Eckermann
We upgraded to version 6.5.2 recently, running on FreeBSD 3.0. Now we are having problems with moderately complex queries failing to complete (backend terminating unexpectedly; last one crashed the server). The most likely explanation appears to be a memory leak. Is there any known problem

RE: [GENERAL] Memory leak in FreeBSD?

2000-01-11 Thread Jeff Eckermann
FreeBSD port: I don't know enough to know what difference that might make. Any suggestion you have would be appreciated: thanks. -Original Message- From: admin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 11, 2000 12:18 PM To: Jeff Eckermann Cc: '[EMAIL PROTECTED]' Subject

RE: [GENERAL] Memory leak in FreeBSD?

2000-01-11 Thread Jeff Eckermann
Maxusers is set to 128. RAM is 256Mg. Do you think this could be the problem? -Original Message- From: admin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 11, 2000 12:50 PM To: Jeff Eckermann Cc: '[EMAIL PROTECTED]' Subject: RE: [GENERAL] Memory leak in FreeBSD? What