was
created with a too-low maximum value (see help on CREATE SEQUENCE for
options); the user now wants to raise it.
- J.
--
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant
---(end of broadcast
of the number.
... and, of course, you can round with:
joel@joel=# select round('2.000'::numeric);
round
---
2
(1 row)
joel@joel=# select round('2.000'::numeric,2);
round
---
2.00
(1 row)
--
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
)
Easy enough to make this into a function trim_as_much(numeric) or
somesuch.
--
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant
---(end of broadcast)---
TIP 4: Don't 'kill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Alessio
Bragadini
Sent: Thursday, May 30, 2002 9:04 AM
To: PostgreSQL Hackers
Subject: Re: [HACKERS] wierd AND condition evaluation for plpgsql
On Tue, 2002-05-28 at 16:09, Joel Burton wrote
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 10:44 AM
To: Joel Burton
Cc: Alessio Bragadini; PostgreSQL Hackers
Subject: Re: [HACKERS] wierd AND condition evaluation for plpgsql
Joel Burton [EMAIL PROTECTED] writes:
Actually
();
NOTICE: seeme
?column?
--
t
(1 row)
In your case, the problem is short-circuiting a test, it's that the full
statement must be parsed and prepared, and it's probably in this stage that
the illegal use of old. in an insert jumps up.
HTH.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 19, 2002 6:40 PM
To: Joel Burton
Cc: Joe Conway; Pgsql-Hackers@Postgresql. Org
Subject: Re: [HACKERS] Exposed function to find table in schema search
list?
Joel Burton [EMAIL PROTECTED] writes
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 1:33 PM
To: Joel Burton
Cc: Pgsql-Hackers@Postgresql. Org
Subject: Re: [HACKERS] Exposed function to find table in schema search
list?
At the moment regclass conversion raises an error
whenever we do this, and 7.3 could be as good a time as any.
- J.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
(s.foo) - oid of s.foo
I can write something in plpgsql (iterating over the array, checking each,
etc.), however, it would be nice if something was already there.
Any ideas?
Thanks!
- J.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology
-Original Message-
From: Joe Conway [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 19, 2002 5:25 PM
To: Joel Burton
Cc: Pgsql-Hackers@Postgresql. Org
Subject: Re: [HACKERS] Exposed function to find table in schema search
list?
Joel Burton wrote:
Is there a function already
or non-psql environments, however, but I don't know how common this is.
What do others think?
Thanks!
--
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
---(end of broadcast)---
TIP 5
Tom Lane [EMAIL PROTECTED] said:
Joel Burton [EMAIL PROTECTED] writes:
Given that 98% of my function defining is done is psql, this would be
fine for me and solve my frustrations. It wouldn't help people that
build functions in scripting languages or non-psql environments,
however
put together docs on this feature, I'll
volunteer to write this up.
Thanks!
- J.
--
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
---(end of broadcast)---
TIP 3: if posting
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 9:37 AM
To: Joel Burton
Cc: PostgreSQL Development
Subject: RE: [HACKERS] Updated CREATE FUNCTION syntax
Joel Burton writes:
Is there any standardized way of handling the single
language uses single quotes!), allowing another symbol
to be used, with that symbol be declared in the CREATE FUNCTION line?
Interbase uses a system like this: you can set the delimiter to anything you
want and use that instead of '.
- J.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim
a warning
that there were triggers/rules/RI or (better) requiring a FORCE parameter to
truncate when there are might make others feel safe, though.
- J.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
---(end
compromise.
But, please, don't take away the ability to TRUNCATE. Doing it when there
are triggers is one the strengths of TRUNCATE, IMNSHO.
- J.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
---(end
a record (with all the usual
rules/triggers/RI applying), but not let them bypass all that to TRUNCATE.
But I still wouldn't want to see hassle-free truncation disappear in the
name of security or idiot-proofing, if there are reasonable compromises.
- J.
Joel BURTON | [EMAIL PROTECTED
-Original Message-
From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 10:17 PM
To: Joel Burton; Tom Lane; Rod Taylor
Cc: Hackers List
Subject: RE: [HACKERS] TRUNCATE
I'm happy w/o the FORCE option (just let TRUNCATE do it), but if enough
people
to hackers: do not
implement this 20min connect, though. :) )
- J.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
without a cooperating jailmaster,
and it sounded like using the APR _might_ make this possible. (All of my
other projects use PG; I'd sure love to get this one switched over!)
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
-Original Message-
From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 7:36 AM
To: Joel Burton; Tom Lane; mlw
Cc: Marc G. Fournier; [EMAIL PROTECTED]
Subject: Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports
I forwarded the suggestion to my ISP
Joel Burton [EMAIL PROTECTED] writes:
Rather than propagating the SysV semaphore API still further, why don't
we kill it now? (I'm willing to keep the shmem API, however.)
Would this have the benefit of allow PostgreSQL to work properly in BSD
jails, since lack of really working SysV
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane
Sent: Friday, May 03, 2002 6:07 PM
To: mlw
Cc: Marc G. Fournier; [EMAIL PROTECTED]
Subject: Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports
Rather than propagating the SysV semaphore
@,$(configure_args),g \
Is there a reason to keep this change if it breaks this feature, or is there
an easy way to fix this? (I'm not a serious Makefile user, sorry!)
Thanks!
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
)
However, this works:
test=# select * from t2 where f='2'::char;
f
---
2
(1 row)
Is this a bug? Is this correct behavior? Am I misunderstanding this?
Thanks!
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology Consultant
-Original Message-
From: Alastair D'Silva [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 10:52 PM
To: 'Vince Vielhaber'; 'Joel Burton'
Cc: [EMAIL PROTECTED]
Subject: RE: [HACKERS] initdb dies during IpcSemaphoreCreate under BSD
jail
You need to get your provider to set
You need to get your provider to set the sysctl jail.sysvipc_allowed to
1 in the host environment. If they're not willing to do this for you, we
provide this feature on our servers, and also have a shared Postgres
database you can use.
My ISP responds to this point:
In the thread on the
knows of? Any hope of getting PG running in our jail? (Or,
alternatively, can PG run on the real machine's processes so that the
different jails can access it?)
Any help would be appreciated!
Thanks.
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Knowledge Management Technology
://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/arrays.html):
In the contrib/ directory are procedures to search arrays for values.
This may help.
--
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant
---(end
that is
exactly their value, so the first update to dbl does nothing.
The second time, w/o the ID10 restriction, it finds 1(a), and double
that, 2(b), and adds 10; getting confused about which record to edit.
Is this the best way to interpret this? Is this a bug?
--
Joel BURTON | [EMAIL
questions to pgsql-general or pgsql-novice and re-post
to pgsql-hackers only if you get no response w/in a week.
HTH,
--
Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant
---(end of broadcast
On Wed, 10 Oct 2001, Dmitry Chernikov wrote:
Hello,
In dump file statement which grants permissions on view exists before
statement which create view.
For tables and sequences permissions dumped in correct order.
--TOC Entry ID 124 (OID 150248)
GRANT ALL on my_view to group sales;
...
package. You'll need to install
CygIPC (easily found via google, a simple binary install). Whole thing is
pretty much of a snap nowadays.
Of course, would you want to run a serious database under Windows 98?
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center
On 25 Jul 2001, Turbo Fredriksson wrote:
Is there a way to debug a PL/pgSQL function? It's behaving very irradic!
It's crude, but you can output debugging statements w/ RAISE NOTICE
or catch flawed assumptions by RAISE EXCEPTION.
--
Joel Burton [EMAIL PROTECTED]
Director of Information
of notices, though -- so, keep it
short, and obviously titled. help!, for instance, should become Seeking
PostgreSQL DBAs in Toronto, Canada
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast
fields.
Look at the section on data types in the User's Manual for info.
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
anything terribly strange,
but this is my first C function I'm turning loose on the world.
If you have a chance, I'd appreciate any feedback/pointers.
If it looks good / If I don't hear otherwise, I'll send it out to
pgsql-announce and pgsql-general early next week.
Thanks!
--
Joel Burton [EMAIL
.
Collaborate w/Justin -- he has information about replication up at
techdocs.postgresql.org now.
Thanks,
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 6: Have you searched our
dump, change the field names, and re-slurp in the old dump.
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
.?
If people can point to some best practices/ideas, I'd be happy to turn
them into a HOWTO.
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thu, 26 Apr 2001, V. M. wrote:
ok for serials, now i can extract from psql (\d tablename).
But i'm not able to extract foreign keys from the schema.
Yes you can. Read my tutorial on Referential Integrity in the top section
at techdocs.postgresql.org.
--
Joel Burton [EMAIL PROTECTED
You're trying to change a value in
the table c, using information in table p, id, but...)
If you don't have this, yes, you can look at in
the tgargs, but, given that its a bytea field, it's hard to
programmatically dig anything out of it.
HTH,
--
Joel Burton [EMAIL PROTECTED]
Director
) The explicit-joins help suggests that manual structuring and
experimentation might help -- has anyone written (or could
anyone write) anthing about where to start in guessing what
join order might be optimal?
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center
querying the view w/the b.name WHERE clause, would we still see a
performance boost from the right arrangement? (ie, does our criteria get
pushed down early enough in the joining process?)
TIA,
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
s aren't very useful for this, an I can't coerce bytea into
text or anything like that.
Can anyone offer help on this? If I can get into the real args, I'll fix
up the script so that it can be run once by the people w/o tgconstrrelid,
and then, once Philip's done his work, we'll never lose it again!
.200012
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
-separated list. This function (which I find generally useful) is in
Roberto Mello's Cookbook, via techdocs.postgresql.org.
Anyway, here's hoping that someone fixes the dumping problem (emitting as
real constraints would be *much* nicer), but in the meantime, this stuff
may be useful.
--
Joel Burton
referenced from c
The problem is that I've use tools that examine tgconstrrelid to figure
reverse engineer which relationships exist.
Is this a bug? Am I misunderstanding a feature?
(This was run with 7.1RC4; it's possible that this bug doesn't exist in
the release 7.1. I haven't b
On Wed, 18 Apr 2001, Tom Lane wrote:
Joel Burton [EMAIL PROTECTED] writes:
tgconstrrelid (in pg_trigger) holds table references in a RI trigger.
The value in this field is not successfully recreated after a
dump/restore.
Yes, this problem was noted a couple months ago. AFAIK
this with
notice, or, as I fear, would it always be a pain, regardless of how much
advance notice the world rec'd?
Thanks,
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP
umpfile 21 | grep ERROR
so that I don't miss any errors among the all the NOTICEs
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 6: Have you searched our list archi
z for docs and for Postscript makes perfect
sense. Just make sure that it's *very* obvious where/how to get these, so
that the mailing lists are deluged w/ 'where are the docs'?
Just my .02,
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of
PLs to our PG
server? (Of course, adding alpha- or beta- quality PLs has clear problems,
I mean when this becomes production quality). Does each new PL bloat the
PG server? Does each new PL slow it down?
Thanks!
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support
On Tue, 27 Mar 2001, Tom Lane wrote:
Joel Burton [EMAIL PROTECTED] writes:
. add a command like ALTER FUNCTION foo(text) TO foo(text) returns text as
This is on the TODO list already, I believe.
Yikes. I should have read it more carefully. My apologies. There are so
many good
rror
above).
What could this be? Is there any hope?
Thanks!
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
I'm sorry, I should have included:
PostgreSQL 7.1beta4
Linux-Mandrake 7.1 (very simiiar RedHat 7)
Intel hardware
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 3
On Wed, 21 Mar 2001, Hiroshi Inoue wrote:
Joel Burton wrote:
Postmaster crashed on me, and on restart, pg_inherits cannot be found.
I can see it in pg_class (and it shows up w/ \dS), but any attempt to
modify anything fails with "pg_inherits: No such file or directory".
On Tue, 20 Mar 2001, Tom Lane wrote:
Joel Burton [EMAIL PROTECTED] writes:
and I could find a $PGDATA/base/18720/16567 file.
Could you find such a file ?
No. I do have the db directory, and all of the other file for the existing
classes, but not this.
Hm. You could make an empty
On Wed, 21 Mar 2001, Hiroshi Inoue wrote:
Joel Burton wrote:
On Wed, 21 Mar 2001, Hiroshi Inoue wrote:
Joel Burton wrote:
Postmaster crashed on me, and on restart, pg_inherits cannot be found.
I can see it in pg_class (and it shows up w/ \dS), but any attempt
is Zope *per se*, since Zope can only talk to the
database adapter, and I doubt the database adapter has the intentional
feature of delete-the-file-for-this-table in its protocol. It *could* be a
problem w/ZPoPy or PoPy; I'll send a message to their list as well.
Thanks!
--
Joel Burton [EMAIL
that tblFoo in dbA can be called as ToFoo in dbB
* other ways?
The second might be easier from a conversion view: the user wouldn't have
to understand that this was a 'link', but it might prove complicated when
there are many links to keep track of, etc.
--
Joel Burton [EMAIL PROTECTED]
Director
the door to remote access until we have a
two-phase transaction commit mechanism in place. Doing it any other way
is not a 'partial solution', it's a corrupt database waiting to happen.
What does '2-phase transaction commit mechanism' mean in this case?
--
Joel Burton [EMAIL PROTECTED]
Director
might vary, that way subexpressions can be
collapsed until an input becomes non-const.
There is "with (iscachable)".
Does
CREATE FUNCTION YESTERDAY(timestamp) RETURNS timestamp AS
'SELECT $1-''24 hours''::interval' WITH (iscachable)
work faster?
--
Joel Burton, Director of Informatio
. Also, I doubt we'd want
to impugn the perceived quality of 7.1beta b/c people don't
understand that its just the ODBC drivers that out-of-date.)
If there's no one official tasked w/this, I'd be happy to submit my
compiled version, at http://www.scw.org/pgaccess.
--
Joel Burton, Director
pgsql-docs listings.
--
Joel Burton, Director of Information Systems -*- [EMAIL PROTECTED]
Support Center of Washington (www.scw.org)
appreciate it.)
It should be in today's pgsql-docs listings.
Thanks!
Joel Burton
[EMAIL PROTECTED]
ion-relies-on-a-view kind of problem. If I ever see it again, I'll
save it.
Thanks!
--
Joel Burton, Director of Information Systems -*- [EMAIL PROTECTED]
Support Center of Washington (www.scw.org)
postmaster.
Rebooted machine, used just postgres, tried to vacuum, tried to
dump, etc. Always the same story.
--
Joel Burton, Director of Information Systems -*- [EMAIL PROTECTED]
Support Center of Washington (www.scw.org)
70 matches
Mail list logo