On Sat, Jul 21, 2007 at 04:54:24AM +, Walter Roeland wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3476
> Logged by: Walter Roeland
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.2.4
> Operating system: Windows XP Professional
> Descr
On Mon, Jan 08, 2007 at 10:27:15AM -0500, Tom Lane wrote:
> "Jonathan Hull" <[EMAIL PROTECTED]> writes:
> > The key feature for the error is that when a result structure (eg : pg_foo)
> > is defined with a domain type that is not null, only PG 8.2 errors if the
> > result is an empty set.
>
> The
That's a pgadmin bug; please report it to them.
On Tue, Nov 14, 2006 at 03:42:53PM +, scoanda wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2758
> Logged by: scoanda
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.1.4
> Operating system
On Fri, Oct 20, 2006 at 09:49:47AM +0100, Heikki Linnakangas wrote:
> Alvaro Herrera wrote:
> >Tom Lane wrote:
> >>"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> >>>I just noticed that freezing a tuple (in vacuumlazy.c) is not
> >>>WAL-logged.
> >>The theory is that this doesn't matter because
On Thu, Oct 19, 2006 at 10:34:30AM +0300, Cristian Ionescu wrote:
> My name is Cristian. I am from Romania.
> I try to install postgresql from tar.gz . I extract from archive all
> file. I enter in postgresql folder and run " ./configure". I receive
> this message:
> "
> *** Could not execute a s
On Thu, Oct 05, 2006 at 09:04:50PM -0500, Jim Nasby wrote:
> On Sep 28, 2006, at 3:54 PM, Harry Hehl wrote:
> >Bug reference: 2661
> >Logged by: Harry Hehl
> >Email address: [EMAIL PROTECTED]
> >PostgreSQL version: 8.1.3
> >Operating system: Linux
> >Description:select
On Sat, Sep 30, 2006 at 03:45:09AM +, how to cluster wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2666
> Logged by: how to cluster
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 7.4.13
> Operating system: i586
> Description:how
s...
You haven't given us nearly enough information. What kind of hardware is
this? RAID? What changes have you made to postgresql.conf?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.ne
if i changed the name of the fields in the database to:
>
> "productid"
>
> It would work fine.
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Jim C. Nasb
ves.postgresql.org/ says I can subscribe for a digest of the
> above lists.
> [
>
> -----------(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
>
--
Jim C. Nasby, Sr. Engineering Consultant
', SQLSTATE;
> RETURN -1; /* blad danych */
> END;
> RAISE WARNING ' mask=%',rowvar.mask;
> RETURN 1;
> END;
> $$ LANGUAGE 'plpgsql' VOLATILE;
>
> ---(end of broadcast)---
> TIP 4: Have
ductive implicit
> transaction, it'd take very little space and a lot less time). :(
Huh? What implicit transaction? Do you have an example that illustrates
this problem?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
cessyear = '2006'
> and processmonth = '05'
> and processbatch = '1') as b
> ON b.empno = a.empno ) as count_result
> -
> or just create the view and use inner join then count :b
>
>
>
>
describe a table? How to you get the system to give a listing of
> all the table that a user has in his scheme? Thanks again for all the help.
>
> PAT
>
>
> >From: "
the checking though, ISTM it'd be better to
remove the external PID file on shutdown...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
rust access. Then connect
and change the password and change pg_hba.conf back. You'll need to
reload the config after each pg_hba.conf change.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http:
On Wed, May 24, 2006 at 05:29:34PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > I know domain support is pretty broken, so maybe this is a known issue...
>
> What are you concerned about exactly? It looks perfectly reasonable
> to
version
---
PostgreSQL 8.1.2 on powerpc-apple-darwin8.4.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 20041026 (Apple Computer, Inc.
we need
> > another theory.
>
> It's pg_ctl
>
> command=${prefix}/bin/pg_ctl
http://lnk.nu/freebsd.org/9fu.tmpl is the file in ports CVS.
http://jim.nasby.net/010.pgsql.sh.txt is the file as it exists on one of
my systems.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTE
. (Hm, actually it might
> work to do "su -c 'exec pg_ctl ...'" ... I have not tried that.)
Except that the shell that's running su would be root, not pgsql, at
least in the case of FreeBSD. The guts of the current port's rc.d file
are:
su -l ${postgresql_use
lity that allowed reading from an on-disk file
as if it was a table... I know Oracle has that ability, maybe
EnterpriseDB has it as well...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net
> insert_adv_exrate(2,1,2); it is giving error as
>
>
> ERROR: SELECT query has no destination for result data
> HINT: If you want to discard the results, use PERFORM instead.
> CONTEXT: PL/pgSQL function "insert_adv_exrate" line 5 at SQL statement
>
or OOD. We need a way to stop runaway
> queries from happening in the first place.
Well, the question still remains, had they been trying this with a 100TB
table, would it have actually worked, or is there some kind of overflow?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
On Tue, Apr 11, 2006 at 09:04:49AM -0700, Richard Dunne wrote:
> I have installed PostGreSql on a flash memory drive. How do I start the
> shell command?
Uhm... psql?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwor
On Mon, Mar 27, 2006 at 09:50:38AM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Sun, Mar 26, 2006 at 08:34:46PM -0500, Tom Lane wrote:
> >> The question is whether doing either one is really a material
> >> improvement, seein
ere a server equivalent to PQstatus? If there were one, couldn't
the server periodically ping the client?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/perv
p_index"
>
> which seems to have been fixed with a REINDEX on that table. It seems that's
> a rare hard to reproduce one.
>
> Thank you for your input!
> Alexis Wilke
>
> ---(end of broadcast)---
> TIP 1: if posting/reading thro
ion(DatabaseManager.java:
> 447)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:777)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:71)
>
>
> BUILD FAILED
> /opt/project/dspace/d
needs to start the reverse scan, but it
can't do this with IS NOT NULL. Is this due to NOT NULL not being an
operator?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
---(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
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
P
On Fri, Jan 06, 2006 at 02:48:59PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Is caching of results for STABLE/IMMUTABLE functions called with a
> > constant something that would be reasonable to add?
>
> I tend to think not: th
(SELECT foo(21))
so presumably some kind of query transform logic similar to what was
done for min/max might work.
I don't see anything about this on the TODO...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vc
fore or while processing the request.
The backend didn't actually crash, though.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---
On Fri, Dec 16, 2005 at 05:10:11PM -0500, Tom Lane wrote:
> We need to fix plpgsql to ensure that what it returns is of the expected
> record type.
Should a test be added to regression for this? That's something I should
be able to do...
--
Jim C. Nasby, Sr. Engineering Consultant
le, we can add it.
Would it be possible to rely on setting umask in the shell instead of
hardcoding 077? I guess that would end up being dependant on different
startup scripts though, so it's probably not a good idea.
An alternative is to just use syslog. Or I believe you could use a
log-rotat
all
> the nasty quirks that may get into the way (for example the documentation
> says that the trigger must return `trigger' but it is impossible to declare
> such a SQL function).
>
> ---(end of broadcast)---
>
and port. how we can check the host name and port .
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
> message
> >>
> >>When I try to start recovery process on windows I'm getting the following
> >>error:
> >>
> >>FATAL: incorrect checksum in control file
> >>
> >>thank you
> >>
> >>
> >>---
2 bit
>
> When I try to start recovery process on windows I'm getting the following
> error:
>
> FATAL: incorrect checksum in control file
>
> thank you
>
>
> ---(end of broadcast)---
> TIP 5: don't for
rd would largely be appreciated !!!
>
> Thanks,
> Kishore Negi
>
>
>
>
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
-
issue is that PostgreSQL gets it's timezone data from somewhere
else; see http://lnk.nu/developer.postgresql.org/69i. Now, why it's
comming from a machine at the National Cancer Institute I don't know...
presumably it's a project for someone who works there. You should take a
look
s_reset_on_server_start = on
> >autovacuum = on
> >autovacuum_analyze_scale_factor = 0.1
> >
> >I've removed the 'NOWAIT' for the time being, but thought I should mention
> >the issue.
> >
> >Thanks,
> >Joel
> >
> >
, but
> it's not possible, to make it visible. And when I view the table there ist
> no data inside.
> Any Help would be great. Thanks!
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
On Thu, Oct 13, 2005 at 04:24:23PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Thu, Oct 13, 2005 at 01:30:56PM -0400, Tom Lane wrote:
> >> Basically, DECLARE introduces a new name scope that wouldn't be there
> >>
On Thu, Oct 13, 2005 at 01:30:56PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Based on all that, I would certainly be in favor of throwing a warning
> > if you over-define something, since 99% of the time it's a mistake. Is
> &g
t, I would certainly be in favor of throwing a warning
if you over-define something, since 99% of the time it's a mistake. Is
that possible with the current checking we do at compile time?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasi
; a Debian sid with all required build dependencies, gdb, and the like
> for debugging.
>
> Thanks and have a nice day!
>
> Martin
>
> --
> Martin Pitthttp://www.piware.de
> Ubuntu Developer http://www.ubuntu.com
> Debian Developer http://www.debian.org
>
>
ents that
> will run on MySQL, PostgreSQL and Oracle without the need for conversion.
>
> Tony Marston
>
> http://www.tonymarston.net
>
>
>
> > -Original Message-
> > From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
> > Sent: 10 October 2005 18:
acters.
> >
> > --
> > Bruce Momjian| http://candle.pha.pa.us
> > pgman@candle.pha.pa.us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup.| Newtown
want to define it as accepting
an array; I think that would allow you to accept any number of
parameters.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 5
ourself (or
pay someone to do it). Even then I suspect -hackers might reject it.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
rity breach is blocked by witholding
> this information?
>
> -----------(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software h
f the next day. Negative leap seconds are also
possible should the Earth's rotation become slightly faster; in that
case, 23:59:58 would be followed by 00:00:00."
Obviously, trying to comply with that to the letter would be a heck of a
lot harder. Unfortunately, if we ever do have a n
in 8.1 WRT using the postgres database
fix this particular case, but is there a bigger issue with there being a
race condition here? Presumably dropdb returns before the connection is
actually closed from the database's standpoint...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTE
gt; We are using Windows 2000 Server, Service Pack 4.
>
> Thanks
> Jean-Pierre Pelletier
> e-djuster
>
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index s
here other compatability issues as well? The warning on \connect
seems like a good idea to me. Of course nothing says we can't do both...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softwarehttp://pervasive.com512-569-9461
---
ile permissions.
FWIW, this is exactly what Oracle does. A DBA has to configure what
directories you can bulk copy to/from.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softwarehttp://pervasive.com512-569-9461
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Mon, Aug 15, 2005 at 10:34:59AM -0700, Darcy Buskermolen wrote:
> On Sunday 14 August 2005 21:30, Bruce Momjian wrote:
> > Jim C. Nasby wrote:
> > > I believe that thread safety isn't supported on *BSD. I know that
> > > there's issues with building in
: undefined reference to
> `pthread_mutex_unlock'
> ../../../src/interfaces/libpq/libpq.so: undefined reference to
> `pthread_mutex_lock'
> ...
>
> Possible help me ?
>
> Regards
> Rmkml
>
> -----------(end of broadcast)
e if that would just be masking something that's
actually a problem.
Is this still considered a bug? Should I leave octopus as-is or try and
fix my configuration?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team
kern.sysv.shmall=65536
>
> here is my responce from the terminal
>
> postgres$ sysctl kern.sysv.shmmax
> kern.sysv.shmmax: 33554432
>
> postgres$ sysctl kern.sysv.shmall
> kern.sysv.shmall: 65536
>
>
> It looks like my settings in /etc/sysctl.conf are
>
didn't understand your comment
>
> "It appears that you can shrink shmmax but not expand
> it."
>
> I did not comment out the kern.sysv.shmmax line and
> it appears that my larger setting is sticking. Or is
> it? What is that command to return the currrnt v
Is that tool on OSX Server? I don't have a copy, though I could probably
find out from a friend.
On Fri, Apr 29, 2005 at 11:57:54PM -0400, Bruce Momjian wrote:
>
> Are they still running on the default PostgreSQL port number for their
> remote administration tool?
--
Jim C. N
I hope this implys that the issue is resolved..
>
> Ted
>
> __
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---(end of broadcast)--
anything else.
>
> -Neil
>
>
>
> -------(end of broadcast)---
> TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
--
Jim C. Nasby, Database Consultant [EMAIL PRO
)));
I'm not a C coder, but doesn't atoi just take a text value and convert
it to an int? Shouldn't all the stats counters be stored as reals?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Member: Triangle Fraternity, Sports Car Club of America
Give your com
stats=# select 1*10, 1*10::bigint;
?column? |?column?
+
1316134912 | 10
(1 row)
Shouldn't the first expression throw an error instead of rolling over
silently?
Version 7.4.2 if it matters...
--
Jim C. Nasby, Dat
67 matches
Mail list logo