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

extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Laurette Cisneros, L.D. The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- No man is wise enough by himself -- Titus Maccius Plautus (254 Bc - 184 BC

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 [EMAIL

[HACKERS] 7.3 pg_dump with -Fc option crashes

_dl_fini, 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] 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 Cisneros wrote

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

Thanks. I've nulled all the comment on views 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 (core dumped) If you have any comments on views

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 -Fc -f mydb.cpgdmp mydb Segmentation

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

and unsubscribe commands go to [EMAIL PROTECTED] --- -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- There's more to life than just SQL

Re: [HACKERS] 7.3b5 contrib compile problem

. regards, tom lane -- 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

[HACKERS] 7.3b5 contrib compile problem

] 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. - bumper sticker ---(end of broadcast

Re: [HACKERS] 7.3b5 contrib compile problem

--- Laurette Cisneros wrote: I saw this when compiling 7.3b4 as well and also with 7.3b5 cd contrib make ... make[1]: Leaving directory `/nfs/visor/u/software/postgres/postgresql-7.3b5/contrib/rtree_gist' make[1

[HACKERS] disable a single trigger

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 broadcast

[HACKERS] 7.3b3 createuser error

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 users? (y/n) y ERROR: 'autocommit' is not a valid option name createuser: creation of user laurette failed any ideas? Thanks, -- Laurette

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 users? (y/n) y ERROR: 'autocommit

Re: [HACKERS] pgsql 7.2.3 crash

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 are done (or it takes forever). Did that happen

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 of those times. Could

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 datadir/base/326602604 and a backtrace shows: (gdb) bt #0 DeferredTriggerSaveEvent (relinfo=0x83335f0, event=0, oldtup=0x0, newtup=0x8348150) at trigger.c:2056 Hm. Line

[HACKERS] pgsql 7.2.3 crash

=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 your bus is? ---(end of broadcast

Re: [HACKERS] pg7.3b1

: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 better. During my testing of my scripts, I have come across

[HACKERS] pg7.3b1

/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 --- NextBus say

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, views, functions, tables, etc. I've had

[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.nextbus.com

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: coltimestamp In 7.2.x

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 sure you all have discussed this ad

Re: [HACKERS]

lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com -- A wiki we will go

[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]

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 following error: pg_restore -U nbadmin -h lnc

Re: [HACKERS]

to 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 server I get the following error

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 database to 7.3b1. However, when

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] wrote: I

[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

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, Sorry to interrupt your

[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 unregister

[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, please

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] writes: The archives search

Re: [HACKERS] pg_dump 2GB limit?

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 unknown That's an old and buggy kernel, BTW--you should

[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 that using tochar

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 / microsecond format: # select

Re: [HACKERS] Timestamp, fractional seconds problem

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 Passenger Information Everywhere

[HACKERS] Timestamp, fractional seconds problem

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 [EMAIL PROTECTED