[GENERAL] ORDER BY col is NULL in UNION causes error?

2006-12-26 Thread Mike Benoit
ompiled by GCC x86_64-mandriva-linux-gnu-gcc (GCC) 4.1.1 20060724 (prerelease) (4.1.1-3mdk) -- Mike Benoit <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

Re: [GENERAL] ORDER BY col is NULL in UNION causes error?

2007-01-11 Thread Mike Benoit
On Thu, 2007-01-11 at 13:44 -0500, Bruce Momjian wrote: > Tom Lane wrote: > > Michael Glaesemann <[EMAIL PROTECTED]> writes: > > > On Dec 26, 2006, at 18:39 , Mike Benoit wrote: > > >> ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of >

[GENERAL] Question - Query based on WHERE OR

2007-01-11 Thread Mike Poe
search by that. The way it's written, if I enter nothing for the last name, it returns all rows, regardless of what I enter for the ssn. I understand why it happens, but what can I do to return the desired results? Thank you. Mike ---(end of broadcast)-

[GENERAL] Replicating Binary Data from MS SQL 2000 to PG 8.2

2007-01-21 Thread Mike Poe
7;m getting... and my feeble attempts so far have failed to fix the problem. Thanks! Mike ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Timestamp/Timezone - does this make sense?

2007-02-13 Thread Mike Harding
mvh=> set time zone 'UTC'; SET mvh=> select now(); now --- 2007-02-13 03:37:35.660652+00 (1 row) mvh=> select timestamp with time zone '2007-01-01' at time zone 'America/Los_Angeles'; timezone - 2006-12-31 1

Re: [GENERAL] tsearch2: word position

2007-02-22 Thread Mike Rylander
the first 1000 bytes are more important, no? No, the first X aren't more important, but being able to determine word proximity is very important for partial phrase matching and ranking. The closer the words, the "better" the match, all else being equal. -- Mike Rylander [EMAIL

[GENERAL] disable/enable trigger hangs

2007-03-28 Thread Mike Charnoky
ggers = 0? I'm assuming the "alter table" approach is preferred, so I converted some scripts to use the new method. However, sometimes the enable/disable trigger command hangs when operating on certain tables. I use the syntax "ALTER TABLE mytable DISABLE TRIGGER ALL;".

Re: [GENERAL] disable/enable trigger hangs

2007-03-29 Thread Mike Charnoky
pg_locks.relation=pg_class.oid and pg_locks.database= (SELECT datid from pg_stat_database where datname = 'my_db_name'); Mike Tom Lane wrote: > Mike Charnoky <[EMAIL PROTECTED]> writes: >> First, a question: For a PG8.1 database, is it preferable to use the new >&

[GENERAL] cant get pg_dump/pg_restore to behave

2007-04-19 Thread Mike Frysinger
F c -s -d database-server mydb > mydb.schema $ psql -d mydb < mydb.schema $ grep users_idx mydb.schema INSERT INTO users_idx ( UPDATE users_idx SET ... -- Name: users_idx; Type: TABLE; ... CREATE TABLE users_idx (... err, shouldnt that CREATE be first ? -mike -

Re: [GENERAL] cant get pg_dump/pg_restore to behave

2007-04-20 Thread Mike Frysinger
On 4/20/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Mike Frysinger" <[EMAIL PROTECTED]> writes: > $ pg_dump -F c -s -d database-server mydb > mydb.schema > $ psql -d mydb < mydb.schema > pg_dump -Fc does not produce a file that psql can read directly. Is t

Re: [GENERAL] cant get pg_dump/pg_restore to behave

2007-04-20 Thread Mike Frysinger
On 4/20/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Mike Frysinger" <[EMAIL PROTECTED]> writes: > i was experimenting with using pg_dump/pg_restore and pg_dump/psql ... > when using psql to import, i didnt use -Fc ... but the errors were the > same regardless of wh

[GENERAL] Additional debugging of idle sessions?

2007-04-24 Thread Mike Goldner
I am experiencing a blocking situation in my database (Postgresql 8.1.8 on Redhat). When I do a "ps -ef|grep postgres" I see two processing that are "idle in transaction" and they stay there indefinitely. I'm running JBoss (the problem is in JBossMQ) and I'm having trouble pinpointing the locatio

Re: [GENERAL] cant get pg_dump/pg_restore to behave

2007-05-03 Thread Mike Frysinger
s which get triggered on events If there's not anything confidential about your schema, could you send me the output of "pg_dump -s" on the problem database? Maybe seeing a fuller picture will yield a clue. the schema shouldnt be a problem ... just the data :) thanks for any insight ..

Re: [GENERAL] cant get pg_dump/pg_restore to behave

2007-05-04 Thread Mike Frysinger
ge.schema SET SET SET COMMENT CREATE LANGUAGE SET psql:gforge.schema:31: ERROR: could not access file "$libdir/tsearch2": No such file or directory psql:gforge.schema:34: ERROR: function public.gtsvector_in(cstring) does not exist psql:gforge.schema:42: ERROR: type gts

Re: [GENERAL] cant get pg_dump/pg_restore to behave

2007-05-04 Thread Mike Frysinger
s --version postgres (PostgreSQL) 8.1.8 -mike ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] cant get pg_dump/pg_restore to behave

2007-05-04 Thread Mike Frysinger
On 5/4/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Mike Frysinger" <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] 0 ~]$ psql -d gforge5 -f gforge.schema > ... > psql:gforge.schema:31: ERROR: could not access file > "$libdir/tsearch2": No such file or

[GENERAL] PSQL undesired transaction behavior when connection is lost.

2004-10-07 Thread Mike Benoit
mand fail in this case, not just the begin? If I had a syntax error in the first delete command, I definitely would not want the second delete to succeed, which had the potential to happen in the above case. (Luckily it didn't) BTW: I had restarted the server manually, so it didn't c

[GENERAL] SSL connection between PHP4 & PostgreSQL ???

2004-10-05 Thread Mike Morris
.g., "requiressl=true", etc... If not possible in PHP4, is it in PHP5? Any help greatly appreciated! MikeM Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) Your Free Historical Quote: Above all

Re: [GENERAL] SSL connection between PHP4 & PostgreSQL ???

2004-10-05 Thread Mike Nolan
o() if you're not sure. Second, what are you using for a connect statement? Here's a sanitized version of one that works for me: DB::connect("pgsql://foobar:[EMAIL PROTECTED]/dbnm?requiressl=true"); -- Mike Nolan ---(end of broadcast)--

Re: [GENERAL] How do I recover from>> pg_xlog/0000000000000000 (log

2004-10-19 Thread Mike Nolan
e last two weeks of backups contained > no data (a guy with OpenACS or something). Also, if you don't routinely test your backups every now and then, how can you be sure they'll work when you NEED them to? -- Mike Nolan ---(end of broadcast)--

Re: [GENERAL] OID's

2004-10-23 Thread Mike Nolan
y large to avoid virtually all wraparound issues would probably mean going to a 64 bit field, which would certainly be a non-trivial task. -- Mike Nolan ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Bug or stupidity

2004-10-25 Thread Mike Mascari
) I want the same thing to happen the first time the code is deployed. This particular error may be less than obvious even during crude testing because the number of tuples in the relation in question may be zero or one, so the cross-product wouldn't produce anything unusual.

[GENERAL] Any plans on allowing user-defined triggers to be deferrable?

2004-10-26 Thread Mike Mascari
ted goal in the server? Must I rely on the application to enforce consistency? Mike Mascari ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that yo

Re: [GENERAL] Any plans on allowing user-defined triggers to be deferrable?

2004-10-26 Thread Mike Mascari
to enforce consistency without deferrable triggers and without relying on the application to maintain consistency, which is not its job. Mike Mascari ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Any plans on allowing user-defined triggers to be deferrable?

2004-10-26 Thread Mike Mascari
Stephan Szabo wrote: On Tue, 26 Oct 2004, Mike Mascari wrote: I'd like to ensure that the creation of a department also implies the creation of two to eight projects; no more, no less: Is there no way to achieve the above stated goal in the server? Must I rely on the application to en

Re: [GENERAL] primary key and existing unique fields

2004-10-26 Thread Mike Mascari
he system from such problems." The surrogate key isn't solving the underlying logical inconsistency problem. It is being used as a work-around to cover one up. I suspect the author of being a MySQL user. Mike Mascari ---(end of broadcast)--

Re: [GENERAL] primary key and existing unique fields

2004-10-26 Thread Mike Mascari
that when I deviate from "purist DB lore" I get punished in long run. Could be wrong, though. :-) Mike Mascari ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EM

[GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-06 Thread Mike Cox
Since we have the discussion going, someone mentioned that the group name should be comp.databases.postgresql. I think this is a good name and I'd like to see what everyone thinks of it. There is also the issue of the charter. I would like to get some feed back on what the best charter could be

[GENERAL] Trying to get postgres to use an index

2004-11-06 Thread Mike Wertheim
Hi, I'm using PostgreSQL 8. I have two tables that I am doing a join on, and the join executes very slowly. The table called Notification has a text field called NotificationID, which is its primary key. The Notification table also has an int4 field called ItemID, and it has an index on the It

Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-06 Thread Mike Cox
Woodchuck Bill wrote: > Mike Cox <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED] > berlin.de: > >> Since we have the discussion going, someone mentioned that the group name >> should be comp.databases.postgresql. I think this is a good name and I'd >>

Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-06 Thread Mike Cox
Devin L. Ganger wrote: > On Sat, 06 Nov 2004 11:11:09 -0800, Mike Cox <[EMAIL PROTECTED]> > wrote: > >> Since we have the discussion going, someone mentioned that the group >> name >> should be comp.databases.postgresql. I think this is a good name and

Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-06 Thread Mike Cox
Polarhound wrote: > Mike Cox wrote: > >> There is resistance in the mailing lists however, even though the groups >> are >> already on usenet and are in the managed "big 8" name space without RFD >> and CFV. > > This now brings up the question of t

Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-06 Thread Mike Cox
Woodchuck Bill wrote: > Mike Cox <[EMAIL PROTECTED]> wrote in > news:[EMAIL PROTECTED]: > >> I cannot handle the volume of email that a mailing list would place >> on my >> inbox. > > Ever heard of a digest version? > I don't care. Its too muc

Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-06 Thread Mike Cox
Devin L. Ganger wrote: > On Sat, 06 Nov 2004 18:03:57 -0800, Mike Cox <[EMAIL PROTECTED]> > wrote: > >> Devin L. Ganger wrote: > >> > I think you're pursuing this backwards, Mike. You should contact the >> > current owner of the present m

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

2004-11-07 Thread Mike Cox
He wants to be in the big 8. He would like to be under the comp.databases.* domain and will not to move it to something like postgresql.*. So he seems to agree with what was my original intention, which was to make the current groups proper members of the big 8. I also offered to let him take

Re: [GENERAL] RFD: comp.databases.postgresql.general

2004-11-07 Thread Mike Cox
Andy wrote: > "Stephan Szabo" wrote: > > (politely snipped) > > Hi Stephan. As Robert tried to explain, this Mike Cox character is > proposing that only the general list become an official Big-8 > newsgroup. No that is not what I'm proposing. Each g

Re: [GENERAL] RFD

2004-11-07 Thread Mike Cox
> Bruno Wolff III wrote: > >> I saw a post indicating a request for discussion on the creation of an >> official big 8 newsgroup comp.databases.postgresql.general. According to >> the notice this newsgroup already exists in google groups and is actively >> being used. The discussion will be in ne

Re: [GENERAL] RFD

2004-11-07 Thread Mike Cox
Bruno Wolff III wrote: > I saw a post indicating a request for discussion on the creation of an > official big 8 newsgroup comp.databases.postgresql.general. According to > the notice this newsgroup already exists in google groups and is actively > being used. The discussion will be in news.groups

[GENERAL] Making this group a part of the official comp.* hierarchy.

2004-11-07 Thread Mike Cox
Hi. As most of you know, comp.databases.postgresql.general is a wonderful resource. What you may not know is that it has not gone through a process that would enable it to be listed on hundreds of usenet servers worldwide by default. Normally groups that are under the comp.* hierarchy go through

[GENERAL] ALERT This mailing list may be voted into a newsgroup

2004-11-07 Thread Mike Cox
Andy M wrote: > ALERT > > There is a person by the name of Mike Cox who's trying > to turn this mailing list into a Big-8 newsgroup. No, I'm trying to get teh postgresql groups which are already ON usenet to follow proper usenet guidelines. In order to be under the comp.

Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-08 Thread Mike Cox
Brian {Hamilton Kelly} wrote: > On Saturday, in article <[EMAIL PROTECTED]> > [EMAIL PROTECTED] "Mike Cox" wrote: > >> Woodchuck Bill wrote: >> >> > Mike Cox <[EMAIL PROTECTED]> wrote in >> > news:[EMAIL PROTECTED]: >> >

[GENERAL] I'm about to release the next postgresql RFD. Comments wanted.

2004-11-09 Thread Mike Cox
Obviously, there cannot be 21 postgresql groups in the comp.* hierarchy. Many of the 21 are not used that often, and would not be of much popularity to those on usenet. I did a check on news.postgresql.org to see which newsgroups are the most popular and also the ones which cover the relevant pos

Re: [GENERAL] I'm about to release the next postgresql RFD. Comments wanted.

2004-11-09 Thread Mike Cox
Brian Mailman wrote: > [EMAIL PROTECTED] wrote: > >> I am affiliated with a network of over 60 PostgreSql users/developers, >> and I will e-mail each one of those people a ballot... > > You should not do that. > > Those ballots will be invalidated since only the official ballots that > are post

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

2004-11-09 Thread Mike Cox
[EMAIL PROTECTED] wrote: > The lists are not bogus and your suggestion is not acceptable. Many of > the list subscribers have no connection to Usenet. They will be mailed > the ballots, regardless of what you or anyone else say. They are the > people who will be directly affected by this. > You

Re: [GENERAL] I'm about to release the next postgresql RFD. Comments

2004-11-09 Thread Mike Cox
Woodchuck Bill wrote: > [EMAIL PROTECTED] ("Marc G. Fournier") wrote in > news:[EMAIL PROTECTED]: > >> As a side note ... if/when the CFV is called and those 4 are >> approved/rejected, that will not change what is available on >> news.postgresql.org, it will only improve the propogation of those

Re: [GENERAL] Trying to get postgres to use an index

2004-11-09 Thread Mike Wertheim
I have some more info on my indexing situation, and a new question. In my previous email, I told about 2 tables: Notification and Item, which join on a field called ItemID. The joining query didn't execute as quickly as I thought it should. I now notice that I have another table, Folder, which jo

[GENERAL] These Lists Are Being Cut To FOUR

2004-11-09 Thread Mike Cox
Hello. My name is Mike Cox. I am in charge of the changing of these postgresql lists. I have decided that we are going to drop most of the lists from the vote. We will only be making 4 lists into real Usenet newsgroups if we win the election. The rest of the lists are crap and they take up too

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

2004-11-09 Thread Mike Cox
Joseph Daniel Zukiger wrote: > It looks like I'm may have to finally subscribe through my isp and > learn how to configure a newsreader in order to vote in favor, instead > of posting through google all the time. That should speed my access to > usenet up quite a bit. Oh, well. > > JouDanZuki Y

[GENERAL] I have had enough

2004-11-10 Thread Mike Cox
her was. I quit. Find another sucker to fix this shit. Blow it out your diarrhea-coated unwiped smelly butt-fucked asshole, Marc you fucko. Mike Cox [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregist

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

2004-11-10 Thread Mike Nolan
hat > might be interesting. If it isn't already in mailman, it would be an interesting option to add to mailman's web interface to give subscribers the option to include or exclude posts being gatewayed from USENET. (I could use that feature on some li

[GENERAL] Postgresql future changes

2004-11-10 Thread Mike Cox
I am proposing some new changes for this list. 1) Black spook jiggaboo watermelon-eating niggers may not post 2) Penny-pinching Jewish kikes may only post if they contribute money 3) Slant-eyed Asian chinks and gooks may post as much as they like 4) Hairy dago greaseball Italians may only post rec

Re: [GENERAL] need simple strategy for universal extension table

2004-11-13 Thread Mike Rylander
EATE TRIGGER sometable_remove_entity_trig BEFORE DELETE ON someschema.sometable FOR EACH ROW EXECUTE PROCEDURE func.remove_entity_entry(someschema); I am supplying the schema name to the trigger because the relation name passed in as TG_RELNAME is the schema unqualified table na

[GENERAL] Black African NIGGERS SUCK COCKS and SWALLOW CUM

2004-11-14 Thread Mike Cox
Black African NIGGERS SUCK COCKS and SWALLOW CUM!! Vote *YES* *YES* *YES* for Usenet! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast

[GENERAL] CUM SWALLOWING FAGGOT COCKSUCKER Marc

2004-11-14 Thread Mike Cox
CUM SWALLOWING FAGGOT COCKSUCKER Marc ! Blow my smelly cock and balls! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 3: if

[GENERAL] SUCK MY DICK, BALLS, and ASSHOLE and CUM

2004-11-14 Thread Mike Cox
SUCK MY DICK, BALLS, and ASSHOLE and CUM!!! These lists belong to me now, motherfuckers! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast

[GENERAL] FUCK YOU BITCHES and COCK SUCKING FAGGOTS

2004-11-14 Thread Mike Cox
FUCK YOU BITCHES and COCK SUCKING FAGGOTS Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] EAT MY ASSHOLE with your TONGUE

2004-11-14 Thread Mike Cox
EAT MY ASSHOLE with your TONGUE! Clean the crap out of my bung hole! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 7: don&#

[GENERAL] CUM on my ASSHOLE, LIPS, and TEETH

2004-11-14 Thread Mike Cox
CUM on my ASSHOLE, LIPS, and TEETH Fire away! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 2: you can get off all lists at once

[GENERAL] SHIT ON MY COCK when I FUCK YOUR ASSHOLE

2004-11-14 Thread Mike Cox
SHIT ON MY COCK when I FUCK YOUR ASSHOLE! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet

[GENERAL] SCENT of my PENIS CHEESE gets you HORNY

2004-11-14 Thread Mike Cox
SCENT of my PENIS CHEESE gets you HORNY! Suck away! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 9: the planner will ignore

[GENERAL] Rebecca whORE is a CUNT SLUT WHORE BITCH

2004-11-14 Thread Mike Cox
Rebecca whORE is a CUNT SLUT WHORE BITCH Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] LICK MY FORESKIN CHEESE on the HEAD OF MY COCK

2004-11-14 Thread Mike Cox
LICK MY FORESKIN CHEESE on the HEAD OF MY COCK! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 9: the planner will ignore your

[GENERAL] FUCK MY TIGHT ASSHOLE with your COCK

2004-11-14 Thread Mike Cox
FUCK MY TIGHT ASSHOLE with your COCK I want it! Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

[GENERAL] FUCK my ANUS with CUM from your COCK

2004-11-14 Thread Mike Cox
FUCK my ANUS with CUM from your COCK Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

[GENERAL] ASIAN GOOKS can SUCK MY COCK

2004-11-14 Thread Mike Cox
ASIAN GOOKS can SUCK MY COCK Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an

[GENERAL] HISPANIC SPICS go FUCK YOURSELVES

2004-11-14 Thread Mike Cox
HISPANIC SPICS go FUCK YOURSELVES Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 6: Have you searched our list archives

[GENERAL] SUCK MY SMELLY PENIS and ASSHOLE

2004-11-14 Thread Mike Cox
SUCK MY SMELLY PENIS and ASSHOLE Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] FUCK MY SHITTY ASSHOLE with your COCK

2004-11-14 Thread Mike Cox
FUCK MY SHITTY ASSHOLE with your COCK Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] ANAL SEX FUCK my WHITE ASSHOLE

2004-11-14 Thread Mike Cox
ANAL SEX FUCK my WHITE ASSHOLE Mike Cox __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [GENERAL] How the function written on pl/pgsql can be called by the function written on plperl.

2004-11-16 Thread Mike Rylander
function from plperl.. > > Anatoly Okishev > > ---(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 > -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] MIKE COX is a CUM SUCKING FAGGOT

2004-11-16 Thread Mike Rylander
Mike Cox is responsible for all this Usenet crap! Mike Rylander [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] You are all ungrateful CUNTS!

2004-11-16 Thread Mike Cox
All that I'm doing for you fucking people. Be grateful! Mike Cox Mike Cox [EMAIL PROTECTED] ---(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

[GENERAL] Show me FUCKING RESPECT!

2004-11-16 Thread Mike Cox
BITCHES! All that I'm doing for you fucking people. Be grateful! Mike Cox Mike Cox [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROT

[GENERAL] EAT SHIT AND FUCK YOURSELVES

2004-11-16 Thread Mike Cox
EAT SHIT AND FUCK YOURSELVES Mike Cox Mike Cox [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] SUCK MY PENIS

2004-11-16 Thread Mike Cox
Suck my big penis! Mike Cox Mike Cox [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to

[GENERAL] A couple serious errors

2004-11-18 Thread Mike Richards
but if this isn't enough to go on, just tell me what to uncomment and/or change I'll get you more info. Thanks, Mike ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] A couple serious errors

2004-11-18 Thread Mike Richards
On Thu, 18 Nov 2004 10:17:21 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Mike Richards <[EMAIL PROTECTED]> writes: > > Over the past couple days I started seeing errors like this in my server > > logs: > > WARNING: terminating connection because of crash of anot

Re: [GENERAL] A couple serious errors

2004-11-18 Thread Mike Richards
On Thu, 18 Nov 2004 10:56:59 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Mike Richards <[EMAIL PROTECTED]> writes: > > PANIC: XX000: stuck spinlock (0x4035a0a0) detected at lwlock.c:242 > > ... > > LOG: 0: server process (PID 20195) was terminated by signa

Re: [GENERAL] SERIAL error

2004-11-27 Thread Mike Mascari
ue up once. This is FAQ item number 4.15.4: http://www.postgresql.org/docs/faqs/FAQ.html#4.15.4 HTH, Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...

2004-11-30 Thread Mike Cox
Woodchuck Bill wrote: >> ppl like PeterE, TomL, JoshuaD, etc ... the thread can be seen: >> >> http://archives.postgresql.org/pgsql-hackers/2004-11/msg01110.php > > Trying to sway the vote? > > Well, you have to admit that for _developers_, email is probably better. But remember develop

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2004-12-02 Thread Mike Cox
Marc G. Fournier From: wrote: > Mike Cox <[EMAIL PROTECTED]> writes: > >>Marc G. Fournier From: wrote: > >>> The pgsql.* hierarchy is a not a private one, it is a public one carried >>> by several of the large usenet servers. > >>Doesn't &

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2004-12-02 Thread Mike Cox
Marc G. Fournier From: wrote: > Mike Cox <[EMAIL PROTECTED]> writes: > >> REQUEST FOR DISCUSSION (RFD) >> unmoderated group comp.databases.postgresql > >>This is a formal Request For Discussion (RFD) for the creation of &

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2004-12-03 Thread Mike Cox
Jan Wieck wrote: > On 12/3/2004 3:32 PM, Woodchuck Bill wrote: > >> [EMAIL PROTECTED] ("Joshua D. Drake") wrote in >> news:[EMAIL PROTECTED]: >> >>> So the current state of affairs is that we have the gated, official pgsql.* newsgroups, and the comp.* stuff is not gated in either

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2004-12-03 Thread Mike Cox
Mike Cox wrote: > Jan Wieck wrote: > >> On 12/3/2004 3:32 PM, Woodchuck Bill wrote: >> >>> [EMAIL PROTECTED] ("Joshua D. Drake") wrote in >>> news:[EMAIL PROTECTED]: >>> >>>> >>>>> So the current state of

[GENERAL] Preview of Fourth PostgreSQL RFD.

2004-12-04 Thread Mike Cox
N: This RFD has been posted to the following newsgroups: news.announce.newgroups, news.groups, comp.databases, comp.unix.bsd.freebsd.misc, pgsql.general Proponent: Mike Cox <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: you can get off all

Re: [GENERAL] [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread Mike Rylander
#x27;re merrie than you know. :) > -alex > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing l

Re: [GENERAL] postgresql and javascript

2004-12-10 Thread Mike Rylander
There is this from Mozilla: http://www.mozilla.org/projects/sql/ On Tue, 7 Dec 2004 10:27:05 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Does anyone know how to connect javascript to a postgresql database > > Please send example if anyone has done it > -- Mi

[GENERAL] Google not carrying the pgsql.* hierarchy.

2004-12-11 Thread Mike Cox
Hi. It seems that when google did its beta update, the pgsql.* hierarchy went missing. Is there anyway to restore it? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] WAL/pg_xlog on Another Disk: Redundancy?

2004-12-15 Thread Mike Rylander
-- > Thomas F. O'Connell > Co-Founder, Information Architect > Sitening, LLC > http://www.sitening.com/ > 110 30th Avenue North, Suite 6 > Nashville, TN 37203-6320 > 615-260-0005 > > ---(end of broadcast)--- > TIP 8:

[GENERAL] 4th RFD: comp.databases.postgresql

2004-12-14 Thread Mike Cox
his RFD has been posted to the following newsgroups: news.announce.newgroups, news.groups, comp.databases, comp.unix.bsd.freebsd.misc, pgsql.general Proponent: Mike Cox <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 3: if posting/read

Re: [GENERAL] NewsForge Poll: Favorite open source database?

2004-12-18 Thread Mike Mascari
or of voting for you. Not good Mike Mascari ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: RES: [GENERAL] NewsForge Poll: Favorite open source database?

2004-12-20 Thread Mike Mascari
Marcelo Cid wrote: http://www.newsforge.com/pollBooth.pl?qid=54 I see strange line below results: "(You've already voted.)" I don't believe such results because I do know I didn't been here :) Marcel's link did the favor of voting for you. Not good Mike Mascari N

Re: [GENERAL] nice work on the new site

2004-12-22 Thread Mike Mascari
Ned Lilly wrote: To everyone who put in what's clearly a lot of time in building the new website, well done! I think the combination of the 8.0 release and a dramatically more professional website will do wonders for PostgreSQL. Kudos! Amen. Mike Mascari ---(e

Re: [GENERAL] pgsql question

2004-12-28 Thread Mike Rylander
gt; > TIA > > Groeten, > > Joost Kraaijeveld > Askesis B.V. > Molukkenstraat 14 > 6524NB Nijmegen > tel: 024-3888063 / 06-51855277 > fax: 024-3608416 > e-mail: [EMAIL PROTECTED] > web: www.askesis.nl > > ---(end of broadcast)

[GENERAL] Postgresql website issues.

2004-12-30 Thread Mike Cox
Am I the only one who has trouble reading the website? Some of the fonts are way too small, especially the " Mirrors | Donate | Contact" set. The other problem is that it is too light. My eyes strain to read the text as the background is white, and the text is also a light color. Also, on the n

Re: [GENERAL] function in postgres

2005-01-03 Thread Mike Mascari
vinita bansal wrote: Hi, The function "CHAR in db2" returns a fixed length character string representation of an integer number.What is the corresponding function in Postgres? Regards, Vinita Bansal http://www.postgresql.org/docs/7.4/interactive/functions-string.html Mi

Re: [GENERAL] Postgresql website issues.

2005-01-03 Thread Mike Nolan
f font colors is also questionable IMHO. When combined with the reduced type size some things are so faint they're unreadable. -- Mike Nolan ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Cursor bug?

2005-01-13 Thread Mike G.
thank you. I use the cursor because I really do an update against a different table based on a value from the select in the original table. I am eagerly awaiting 8.0 and the ability to issue an Update Table1 Set Table1.col = Table2.col Using (Select y from Table2) Mike On Thu, Jan 13, 2005

Re: [GENERAL] pgpsql help

2005-01-16 Thread Mike G.
Maybe it is because 'name' is a sql 92/99 non-reserved / key word? On Mon, Jan 17, 2005 at 05:46:20AM +0100, LENGYEL Zoltan wrote: > Hi, > > I have a pgpsql function: > > create or replace function new_uri(varchar,varchar,varchar) returns > integer as ' > declare > src alias for $1; > tit a

Re: [GENERAL] Cursor bug?

2005-01-16 Thread Mike G.
On Fri, Jan 14, 2005 at 01:28:47PM +0100, Martijn van Oosterhout wrote: > On Thu, Jan 13, 2005 at 04:35:04PM -0600, Mike G. wrote: > > thank you. > > > > I use the cursor because I really do an update against a different > > table based on a value from the select i

<    3   4   5   6   7   8   9   10   11   12   >