Re: [GENERAL] Good way to insert/update when you're not sure of duplicates?

2003-09-25 Thread Shridhar Daithankar
Richard Huxton wrote: On Thursday 25 September 2003 02:23, Curtis Stanford wrote: I'm in a situation where I need to load an ASCII file into a database. No sweat so far right? The records are indexed by date and I have a unique index on date. The ASCII can overlap, meaning it can contain duplicat

Re: [GENERAL] MySQL-to-PostgreSQL

2003-09-25 Thread Marek Lewczuk
I suggest you to do it manualy I'm mean the structure only... Then you can make mysqldump only with inserts... Belive me that this is much faster > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Yevgeny Ioffe > Sent: Thursday, September 25, 2

[GENERAL] about catalog!

2003-09-25 Thread zhuangjifeng
hello,i am sorry if you could tell how and where template1 database and catalog in it were created.thanks! == 263电子邮件－信赖邮自专业

Re: [GENERAL] sequence's plpgsql

2003-09-25 Thread Tom Lane
Tim McAuley <[EMAIL PROTECTED]> writes: > I see from a previous email on the list that someone was able to get > decent debug out of the locks, i.e. > Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR: deadlock detected > Aug 10 14:19:36 thunder postgres[18735]: [2-2] DETAIL: Proc 18735 wait

[GENERAL] non local access to database

2003-09-25 Thread Dennis Gearon
Is it possible to allow access to the database only to: from NON localhost, and specific IP ranges, and tunneled through SSH? Does anybody know if there are libraries to do this on ASP for Windblows, (in case I get asked)? This is pretty easy on Linux, right, using libraries in PERL, PHP, Pytho

Re: [GENERAL] vacuum full failing in 7.3

2003-09-25 Thread Tom Lane
Dmitry Tkach <[EMAIL PROTECTED]> writes: > I am getting a weird failure, trying to vacuum a table in 7.3 - it says > "ERROR: Index pg_toast_89407_index is not a btree". That says the first page of the index was corrupted (version number field didn't contain the right thing). > Does it ring a be

Re: [GENERAL] MySQL-to-PostgreSQL

2003-09-25 Thread Martin Marques
This scripts don't do the job completly, but give you a boost. I normally pass my MySQL dumps throught these scripts and then open them with my editor and do the changes that were missing. You will always have to make changes in things like MySQLs inconsistencys (dates that don't exist, an so o

[GENERAL] vacuum full failing in 7.3

2003-09-25 Thread Dmitry Tkach
Hi, everybody! I am getting a weird failure, trying to vacuum a table in 7.3 - it says "ERROR: Index pg_toast_89407_index is not a btree". Does it ring a bell to anyone? Any ideas what's wrong? Is it my database screwed up? I just created it today... I tried dropping and recreating it... and it

Re: [GENERAL] MySQL-to-PostgreSQL

2003-09-25 Thread Bruce Momjian
Have you tried src/contrib/mysql scripts? --- Yevgeny Ioffe wrote: > Hello, > > I am working on transferring MySQL dumps to > PostgreSQL. I have tried the scripts I found in > relevant section of PostgreSQL documentation we

Re: [GENERAL] Client authentication

2003-09-25 Thread Nigel J. Andrews
On Thu, 25 Sep 2003, Claudio Lapidus wrote: > Hello > > We need to deny access to the database for regular users, while allowing > access to admins and a variety of application scripts. > > If we use passwords, everything is fine while interactive, but could not > devise a way for scripts to han

[GENERAL] Client authentication

2003-09-25 Thread Claudio Lapidus
Hello We need to deny access to the database for regular users, while allowing access to admins and a variety of application scripts. If we use passwords, everything is fine while interactive, but could not devise a way for scripts to handle them. We also tried to set up ident authentication, bu

Re: [GENERAL] career in SQL/Database administration

2003-09-25 Thread Rick Seeger
> (Anybody with suggestions on what to do with people like this please > feel free to chime in. :-D) In situations where the client is not tech saavy or the scope is ambiguous, we bid high and ask for a 50% deposit. I think the best scenario is to get the client to pay for a detailed spec so the

Re: [GENERAL] career in SQL/Database administration

2003-09-25 Thread Jonathan Bartlett
> Are you serious??? How do you possibly make any money? Maybe > I am just naive but here at CMD a flat rate quote is a minimum of 2.5x > what we would normally charge JUST IN CASE the client (which will happen) > decides to change direction midstream. > We _plan_ for revisions. We even have a fo

[GENERAL] A conditional DROP TABLE function

2003-09-25 Thread David Link
Hi All, Here's a Conditional drop_table func for those interested. There was a thread on this a long time back. We do this all the time : DELETE TABLE sales; CREATE TABLE sales (...); But nobody likes ERROR: table "sales" does not exist which we see all the time in the logs. I want t

[GENERAL] MySQL-to-PostgreSQL

2003-09-25 Thread Yevgeny Ioffe
Hello, I am working on transferring MySQL dumps to PostgreSQL. I have tried the scripts I found in relevant section of PostgreSQL documentation website, but they all give me various parsing errors. What am I to do? Thanks! ---(end of broadcast)-