Re: [HACKERS] [GENERAL] Where do they find the time??? GreatBridge

2001-09-16 Thread Martijn van Oosterhout
On Mon, Sep 17, 2001 at 02:51:10PM +1000, Justin Clift wrote: > I wonder if it would really be possible to do? Well, it seems to me you could do it at serveral levels: 1. Have a proxy running on whatever port MySQL uses that simply translates the queries coming in and emulates the protocol. Prob

Re: [GENERAL] pg_dump error - LOCALIZATION PROBLEM

2001-09-16 Thread Tom Lane
>> Hmm. Given that we expect the lexer to have downcased any unquoted >> words, this seems like a workable solution --- where else are we using >> strcasecmp() unnecessarily? Wait a minute --- I spoke too quickly. The lexer's behavior is to downcase unquoted identifiers in a *locale sensitive*

Re: [GENERAL] pg_dump error - LOCALIZATION PROBLEM

2001-09-16 Thread Peter Eisentraut
Tom Lane writes: > Hmm. Given that we expect the lexer to have downcased any unquoted > words, this seems like a workable solution --- where else are we using > strcasecmp() unnecessarily? I've identified several other such places. However, in reality we have to consider every single strcasecm

[GENERAL] sequences: log_cnt?

2001-09-16 Thread Bolt Thrower
Apologies if this shows up twice. Can someone explain what the log_cnt attribute of a sequence is for? I couldn't find anything in the documentation regarding it. Thanks, -- Steve Chadsey <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: Have y

Re: [GENERAL] pg_dump error - LOCALIZATION PROBLEM

2001-09-16 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Untested, but try this: > Edit src/backend/commands/variable.c, look for the function > parse_XactIsoLevel(). Change the code that looks like this: > if (strcasecmp(value, "SERIALIZABLE") == 0) > XactIsoLevel = XACT_SERIALIZ

Re: [GENERAL] Questions about tuning on FreeBSD...

2001-09-16 Thread Tom Lane
[ very late comment on this thread ] Philip Hallstrom <[EMAIL PROTECTED]> writes: > As I understand there are two major tuneable parameters: > > - shared buffer cache: which I can think of as a sort of RAM-based > disk cache of recently accessed tables (or parts of tables). Ideally this > would

[GENERAL] PostgreSQL jobs page updated (included Red Hat's search for Database Engineers)

2001-09-16 Thread Justin Clift
Hi all, Just updated PostgreSQL jobs page to include a direct submission from the guys at Red Hat. Mentioning it here on the list, as it might be a really good opportunity for the ex GreatBridge people, (as well as others of course) : http://techdocs.postgresql.org/jobs.php :-) Regards and be

Re: [GENERAL]

2001-09-16 Thread Justin Clift
Hi Haifa, It sounds like you have a weird version of gcc installed. The most common versions of gcc to install on Solaris are available as packages from www.sunfreeware.com. Please note though, I haven't used the versions of gcc which are bundled with Solaris 8 nowdays, so if you're using one o

Re: [GENERAL] Problem with database: FATAL 1: cannot find attribute 24

2001-09-16 Thread Justin Clift
Hi Tauren, Have you found the solution for this yet? It really sounds like part of your customer's database has been deleted or gone missing. Which version of PostgreSQL are you using, and which operating system is it on? :-) Regards and best wishes, Justin Clift Tauren Mills wrote: > > S

Re: [GENERAL] adding a superuser

2001-09-16 Thread Arne Weiner
Karl Babcock wrote: > > Hi, I have just installed PostgreSQL 7.1 and am having a hard time adding > users. I am trying to add a superuser but I keep getting errors with the > createuser script. > > I am user 'root' on the Linux system when I run: > > lightning:/# createuser -d -a root > psql: F

[GENERAL] non fatal casting?

2001-09-16 Thread hubert depesz lubaczewski
hi is there any way to make non-fatal casts (text -=> date and so on?) it would be just perfect if i could do something like: try: my_date := my_text::date; except: return -1; end: return 0; i'd like to use it in plpgsql functions. anyway to do it? depesz -- hubert depe