[HACKERS] index corruption?

003-02-13 16:21:42 [8843] ERROR: Index external_signstops_pkey is not a btree 2003-02-13 16:21:42 [8843] ERROR: current transaction is aborted, queries ignored until end of transaction block Any ideas? -- Laurette Cisneros, L.D. The Database Group (510) 420-3137 NextBus Informati

Re: [HACKERS] [ANNOUNCE] PostgreSQL v7.3.2 Released

I was trying from the postgresql.org download web page and following the mirror links there...and none of them that I was able to get to (some of them didn't work) showed 7.3.2. The second link you gave below works. Thanks, L. On Wed, 5 Feb 2003, Tom Lane wrote: > Laurette Cisneros

Re: [HACKERS] [ANNOUNCE] PostgreSQL v7.3.2 Released

/pub/source/v7.3.2 > > Please submit any bug reports for this release to > >[EMAIL PROTECTED] > > > > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive F

Re: [HACKERS] 7.3 pg_dump with -Fc option crashes

That did the trick...fixed pg_dump! And, pg_restore works on it too! Yay, I can go home now. Thanks very much for your help! On Fri, 10 Jan 2003, Tom Lane wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > This does not: > > pg_dump -h myhost -p 5432 -F

Re: [HACKERS] 7.3 pg_dump with -Fc option crashes

Thanks. I've nulled all the "comment on view"s but still get it... On Fri, 10 Jan 2003, Tom Lane wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > This does not: > > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > > Segmentation fault (

Re: [HACKERS] 7.3 pg_dump with -Fc option crashes

Oh goodness it's even worse as pg_restore can't read the archive from the first pg_dump: pg_dump -h myhost -p 5432 -f mydb.pgdmp mydb pg_restore -l mydb.pgdmp pg_restore: [archiver] input file does not appear to be a valid archive Thanks, L. On Fri, 10 Jan 2003, Laurette Cisn

[HACKERS] 7.3 pg_dump with -Fc option crashes

;, stack_end=0xb4bc) at ../sysdeps/generic/libc-start.c:129 Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. wwy.nextbus.com -- Life is an SQL old chum... ---(end of broadcast)--

Re: [HACKERS] Fwd: Re: [PERFORM] Odd Sort/Limit/Max Problem

d where date_resolve is > not null. In my simple tests on about 200,000 rows of ints where 50% are > null that sort of index cut the runtime on my machine from 407.66 msec to > 0.15 msec. > > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscrib

Re: [HACKERS] 7.3b5 contrib compile problem

but it's easy enough to just not include > the .h file. > > regards, tom lane > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- My other vehicle is my imagi

Re: [HACKERS] 7.3b5 contrib compile problem

bison --version > > --- > > Laurette Cisneros wrote: > > > > I saw this when compiling 7.3b4 as well and also with 7.3b5 > > > > cd contrib > > make > > ... > > make[1]: Leaving d

[HACKERS] 7.3b5 contrib compile problem

ware/postgres/postgresql-7.3b5/contrib/seg' make: *** [all] Error 2 Any ideas? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- My other vehicle is my imagination.

[HACKERS] disable a single trigger

s not work reliably". Will it ever be reliable? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- My other vehicle is my imagination. - bumper sticker ---(end of

Re: [HACKERS] 7.3b3 createuser error

Ugh. Path problem...sorry for jumping the gun. On Fri, 1 Nov 2002, Laurette Cisneros wrote: > 7.3b3 > > as postgres user > > createuser laurette > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new u

[HACKERS] 7.3b3 createuser error

any ideas? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- My other vehicle is my imagination. - bumper sticker ---(end of broadcast)--- TIP 6: Have y

Re: [HACKERS] pgsql 7.2.3 crash

Great. I am working my way toward 7.3 anyway... Thanks! L. On Mon, 14 Oct 2002, Tom Lane wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > Yeah I think that could have happened since I was running it several times and had > > cancelled it (ctrl-c) it a couple o

Re: [HACKERS] pgsql 7.2.3 crash

t, 12 Oct 2002, Tom Lane wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > I see triggers referenced here and it should be > > noted that for one of the tables the triggers were first disabled (update > > pg_class) and re-enabled after the inserts a

Re: [HACKERS] pgsql 7.2.3 crash

On Wed, 9 Oct 2002, Tom Lane wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > A core file was found in /base/326602604 > > and a backtrace shows: > > (gdb) bt > > #0 DeferredTriggerSaveEvent (relinfo=0x83335f0, event=0, oldtup=0x0, > > newt

[HACKERS] pgsql 7.2.3 crash

rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xb7cc) at ../sysdeps/generic/libc-start.c:129 Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- It's 10 o'clock... Do you know where y

Re: [HACKERS] pg7.3b1

gt; On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote: > > > > I am so glad that postgres now keeps track of relationships between rule, > > views, functions, tables, etc. I've had to re-do all my creation and drop > > scripts but this is definitely for the bett

Re: [HACKERS] pg7.3b1

I'll see if I can pare down my scripts (they are long) to reproduce this easier. L. On 26 Sep 2002, Rod Taylor wrote: > On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote: > > > > I am so glad that postgres now keeps track of relationships between rule, > > vie

[HACKERS] pg7.3b1

onfig/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0 What does this indicate? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com

Re: [HACKERS] timestamp column default changed?

I understand. Thanks for pointing that out. L. On Wed, 11 Sep 2002, Bruce Momjian wrote: > > I think the SQL standards required the change. > > --- > > Laurette Cisneros wrote: > > I'm sur

Re: [HACKERS] timestamp column default changed?

I'm sure you all have discussed this ad-nauseum but this sure does create a pain in the butt when converting. Ok, I had my say. Thanks for all your hard work, L. On Wed, 11 Sep 2002, Bruce Momjian wrote: > Laurette Cisneros wrote: > > > > If you define a column as:

[HACKERS] timestamp column default changed?

If you define a column as: coltimestamp In 7.2.x didn't it default to timestamp with timezone? And now in 7.3(b1) it defaults to timestamp without timezone? Is this right? -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbu

Re: [HACKERS]

D 0C1C > > > > "Draw near to God and he will draw near to you. > > Cleanse your hands, you sinners; and purify your > > hearts, you double minded." James 4:8 > > > > > > --

Re: [HACKERS]

Ok, I made the changes in the compressed pg_dump file. Now pg_restore crashes: pg_restore: [archiver] out of memory *sigh* L. On 9 Sep 2002, Oliver Elphick wrote: > On Mon, 2002-09-09 at 21:34, Laurette Cisneros wrote: > > > > I am trying move my development da

Re: [HACKERS]

restore full database dumps. Thanks, L. On 9 Sep 2002, Oliver Elphick wrote: > On Mon, 2002-09-09 at 21:34, Laurette Cisneros wrote: > > > > I am trying move my development database to 7.3b1. > > > > However, when I try to restore from a 7.2.2 dump to the 7.3.b1 ser

Re: [HACKERS]

Thanks! On 9 Sep 2002, Oliver Elphick wrote: > On Mon, 2002-09-09 at 21:34, Laurette Cisneros wrote: > > > > I am trying move my development database to 7.3b1. > > > > However, when I try to restore from a 7.2.2 dump to the 7.3.b1 server I get > > the follow

[HACKERS]

plpgsql_call_handler() does not return type language_handler Any ideas? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- A wiki we will go... ---(end of broadcast

Re: [HACKERS] source code indexer

Thanks to everyone who made suggestions. I have found Source Navigator to be very close and useful for what I was looking for! Thanks again, L. On Fri, 30 Aug 2002, Manfred Koizar wrote: > On Fri, 30 Aug 2002 11:57:17 -0700 (PDT), Laurette Cisneros > <[EMAIL PROTECTED]> wro

Re: [HACKERS] source code indexer

Ah. Great! I had download lxr and was starting to dig in to insatall it and thought I would check with the pgers to see what they recommended. Glad to see someone has done this. Thanks, L. On Fri, 30 Aug 2002, Joe Conway wrote: > Laurette Cisneros wrote: > > HI all, > >

[HACKERS] source code indexer

HI all, Sorry to interrupt your busy list. I was wondering if you could recomend a good source code db/indexer that could be used to search through the postgresql code? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com

[HACKERS] pgsql_data/base mapping

, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Where's mybus? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "

Re: [HACKERS] pg_dump 2GB limit?

s and uncompressed dump. Thanks for the help! L. On 28 Mar 2002, Doug McNaught wrote: > Laurette Cisneros <[EMAIL PROTECTED]> writes: > > > Hi, > > > > I'm on Red Hat. Here's the uname info: > > Linux visor 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 un

Re: [HACKERS] pg_dump 2GB limit?

Hi, I'm on Red Hat. Here's the uname info: Linux visor 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown What do I need to do to "turn on large file support" in the compile? Thanks, L. On 28 Mar 2002, Doug McNaught wrote: > Laurette Cisneros <[EMAIL PROTECTED]>

[HACKERS] pg_dump 2GB limit?

in pg_dump? Is it scheduled to be fixed? Thanks, -- Laurette Cisneros Database Roadie (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Where's my bus? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, p

[HACKERS] Interval bug

Howdy hackers, Should I file a bug or is this known (or fixed)? Thanks! Laurette ([EMAIL PROTECTED]) Here's the psql ready test and description: -- -- BUG Description: -- A float with zeros on the right of the decimal -- fails conversion to an interval. -- interval ( int ) works -- interval (

Re: [HACKERS] Timestamp, fractional seconds problem

Thanks Thomas...at least there will be a way to specify more than 2. we are looking forward to this release... L. On Thu, 4 Oct 2001, Thomas Lockhart wrote: > Laurette Cisneros wrote: > > > > Could I get some more specific information on how this is fixed. Keep in mind >

Re: [HACKERS] Timestamp, fractional seconds problem

me and timestamp are > > less precise than the internal representation. > > Fixed (as of yesterday) in the upcoming release. > >- Thomas > -- Laurette Cisneros (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Passe

Re: [HACKERS] Timestamp, fractional seconds problem

This is very good news. Thanks to all for the response. L. On Thu, 4 Oct 2001, Karel Zak wrote: > On Wed, Oct 03, 2001 at 05:02:59PM -0700, Laurette Cisneros wrote: > > > A work around for display might be to use to_char(). > > In 7.2 is possible use millisecond /

[HACKERS] Timestamp, fractional seconds problem

egrity bug with unacceptable workarounds. Thanks! Laurette Cisneros ([EMAIL PROTECTED]) Elein Mustain NextBus Information Systems ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [