Re: [GENERAL] Table Lock issue

2004-04-15 Thread Tom Lane
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes: > On Thursday 15 April 2004 04:20 pm, Tom Lane wrote: >> ... The problem is that the SELECT >> doesn't get the right result. The SELECT actually sees two row versions >> as being valid: the one you just created by UPDATE, and whichever one >> was curr

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

2004-04-15 Thread Christopher Kings-Lynne
I always ran one of the 2 scripts (can't remember which one) and after that started checking the dump file, because there were things that didn't get changed correctly[1]. [1]: I always remember the first conversion I did. I found out that MySQL accepted dates like 30/2/2000 or 0-0-. Very o

Re: [GENERAL] Basix for Data General / Basix for Sco Unix

2004-04-15 Thread Greg Stark
[EMAIL PROTECTED] (Jim Seymour) writes: > Andrew Ayers <[EMAIL PROTECTED]> wrote: > > > > What is "Basix" - didn't DG at one time make a PICK system (?) - Perhaps he means this? http://www.ctan.org/tex-archive/support/basix/ \Abstract An interpreter for the \basic\ language is developed ent

Re: [GENERAL] Table Lock issue

2004-04-15 Thread Uwe C. Schroeder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 15 April 2004 04:20 pm, Tom Lane wrote: > "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes: > > I use a stored proc to get the next identifier: > > > > CREATE OR REPLACE FUNCTION ib_nextval (character varying) RETURNS > > character varying > >

Re: [GENERAL] Basix for Data General / Basix for Sco Unix

2004-04-15 Thread Jim Seymour
Andrew Ayers <[EMAIL PROTECTED]> wrote: > [snip] > > What is "Basix" - didn't DG at one time make a PICK system (?) - There was a Pick operating system. Still is, actually. It had nothing to do with Data General. "Basix," I don't recall. >

Re: [GENERAL] User permission

2004-04-15 Thread Tom Lane
"C G" <[EMAIL PROTECTED]> writes: > I have a user_info table that has trigger which creates a user and > switches session authorization to the new user, but it doesn't seem to > work as I expect. > mydb1=> select * from user_info ; > usename | password > -+-- > user1 | *** > (1 r

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

2004-04-15 Thread Martin Marques
El Mié 14 Abr 2004 22:22, Christopher Kings-Lynne escribió: > > ... on projects.postgresql.org, or similar.They really aren't doing > > any good in /contrib. > > > > I've already set up a category "conversion tools" on pgFoundry, and my > > idea was one project per target system. > > I reckon t

Re: [GENERAL] SQL script

2004-04-15 Thread Richard Huxton
On Thursday 15 April 2004 09:22, [EMAIL PROTECTED] wrote: > good day toall.. > imm running postgreSQL on linux. > my main goal is to create a script that will dump a data from our server > too my local PC. the content of the script would be execute sql command > in one shot: 1. dump data > 2. upd

[GENERAL] SQL script

2004-04-15 Thread vickr1z
good day toall.. imm running postgreSQL on linux. my main goal is to create a script that will dump a data from our server too my local PC. the content of the script would be execute sql command in one shot: 1. dump data 2. update and insert some rows to selected table. how can i accommplish th