I am trying a simple
access of a table and get an out of
memory error. How do I avoid this issue. It seems I
have some configuration set wrong.
Our system has 24GB of memory and is dedicated to the postgres
database.
B
on the client machine. Both
machines are 64bit.
Thanks Don
On 8/30/2011 10:25 AM, Pavel Stehule wrote:
Hello
if table is large, then client can raise this exception too
try to set FETCH_COUNT to 1000
http://www.postgresql.org/docs/8.4/interactive/app-psql.html
Regards
Pavel Stehule
2011
factor ?
On 8/31/2011 8:57 AM, Scott Ribe wrote:
On Aug 31, 2011, at 9:51 AM, Don wrote:
Both machines are 64bit.
Are all your server & client builds 64-bit?
32M rows, unless the rows are <50 bytes each, you'll never be able t
Hi all,
I just want to check my understanding of schemas, search paths and roles in
implementing my database design.
Scenario:
A database with various "modules" (groups of tables & views, etc.), some of
which are shared in common across a given organization, but others are
specific to a given dep
L will naturally assume lowercase for all
> objects
> unless they are quoted. So probably you want schema names to be common,
> facilities, etc.
>
>
Thanks. I was just capitalizing for the e-mail. I never actually use
upper or camel case in my code.
> On Sat, Jan 9, 2016 at
On Sat, Jan 9, 2016 at 10:22 AM, Tom Lane wrote:
> Don Parris writes:
> > I *think* I want to set the search path on the group roles so that the
> > Facilities team can see the COMMON and FACILITIES schemas:
> > ALTER ROLE fm_users search_path=common, facilities, accoun
he web that using views to insert/update is
a bit tricky - and still requires a procedure with a rule on the view.
Thanks,
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/ <https://www.xing.com/profile/Don_Parris&g
On Wed, Jan 27, 2016 at 4:25 PM, Joshua Berkus wrote:
>
>
> > Am I on the right track, or is there some better way to set this up? My
> > understanding is that views really aren't meant for insert/update
> > operations, and I have seen on the web that using views to insert/update
> is
> > a bit
On Wed, Jan 27, 2016 at 6:24 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, Jan 27, 2016 at 4:03 PM, Don Parris wrote:
>
>
> Parameter passing and variables are client-side considerations. You
> haven't told us how you plan to execute
Definitely putting this on my calendar. I have not been aware of other
PostgreSQL users here - would love to meet some other users.
Don
On Wed, Feb 17, 2016 at 10:39 AM, Boyan Botev wrote:
> If you live near or around Charlotte, please join us for the inaugural
> meeting of the Charlot
good day webmaster.
>
> i want to ask some help from you. my problem is this. i have
already
> installed postgres on a certain computer. i have already created
tables and
> put necessary data in it. one day, my operating system bugged down (i
am
> using windows xp). how could i possible retire
alternative.
I was hoping the members of this group may have some comments or
suggestions as to the direction we should look at.
Thank you and appreciate any comments/suggestions
Don
alternative.
I was hoping the members of this group may have some comments or
suggestions as to the direction we should look at.
Thank you and appreciate any comments/suggestions
Don
SouthEast LinuxFest.
http://dcparris.net/2013/06/11/southeast-linuxfest-what-you-missed/
Anyway, here's hoping you'll enjoy this and find it useful as the few
attendees who sat in did. I hope it helps in some small way.
Regards,
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister
ny thanks in advance,
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/
<https://www.xing.com/profile/Don_Parris><http://www.linkedin.com/in/dcparris>
GPG Key ID: F5E179BE
On Thu, Jul 18, 2013 at 5:01 PM, Joshua D. Drake wrote:
>
> On 07/18/2013 01:44 PM, Don Parris wrote:
>
> Maybe I really need something like macros and BASIC or Python to make such
>> a thing work? If anyone knows a good tutorial on this subject, I can
>> certainly re
opportunity
to showcase a small project using LibreOffice Base as a front-end to
PostgreSQL.
http://dcparris.net/2013/07/22/ill-call-it-ldinero/
In any case, I hope these will be of some use to others here. Please enjoy
and let me know if you need any clarification of any of my points.
Regard
nsion, but I still got a
"permission denied" error.
I did create a password for my postgres user (hence the -W option). And
this is on a local box.
How can I run my script?
Thanks!
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Ad
On Thu, Aug 8, 2013 at 5:44 PM, Thomas Kellerer wrote:
> Don Parris wrote on 08.08.2013 23:13:
>
> And to be able to run it from the Bash prompt (as securely as possible).
>>
>> I thought I could add the commands and run the create script by doing:
>> sudo -u postg
On Thu, Aug 8, 2013 at 5:45 PM, Rob Sargent wrote:
> On 08/08/2013 03:13 PM, Don Parris wrote:
>
>Hi all,
>
> I have a database that uses the ltree extension. I typically create a
> new database like so (as a normal user), using my script file:
>
> CREATE DAT
On Thu, Aug 8, 2013 at 6:30 PM, John R Pierce wrote:
> On 8/8/2013 2:13 PM, Don Parris wrote:
>
>> I thought I could add the commands and run the create script by doing:
>> sudo -u postgres psql -U user -W -d mydb --file=/home/user/dev/mydb_**
>> create.sql
>>
On Thu, Aug 8, 2013 at 8:42 PM, Tom Lane wrote:
> Don Parris writes:
> > When I try a simple psql -U postgres -W - just to initiate the psql
> > session, I get:
> > psql: FATAL: Peer authentication failed for user "postgres"
>
> > It's like my reg
On Fri, Aug 9, 2013 at 11:49 AM, Quentin Hartman <
qhart...@direwolfdigital.com> wrote:
> A bit of an aside, but you also might want to change that "CREATE
> EXTENSION ltree;" to
>
> "CREATE EXTENSION IF NOT EXISTS ltree;"
>
> That way your script won't error out if the extension is already enable
core issue - being able to create new databases
and use the ltree data type.
Two related points remain a bit confusing, but I will read up more and
re-post if I cannot figure them out.
Thanks all!
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software
connections (despite resetting the hba and postgres.conf files as they
should be).
Thanks!
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/
<https://www.xing.com/profile/Don_Parris><http://www.linkedin.com/in/dcpa
On Wed, Aug 21, 2013 at 10:08 AM, Tom Lane wrote:
> Don Parris writes:
>
>
> initdb will absorb locale/encoding from its environment, unless told
> otherwise through a --locale switch. So the usual expectation would be
> that it'd work like you want. Perhaps the Ubu
On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote:
> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris wrote:
>
> > I did run pg_dropcluster, pg_createcluster (setting locale to C.UTF8) -
> and
> > that seemed to work, except that I could not thereafter make remote
>
On Thu, Aug 22, 2013 at 11:29 AM, Don Parris wrote:
> On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote:
>
>> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris wrote:
>>
>>
> you install the PostgreSQL packages, it runs pg_createcluster for you.
>> If you don&
On Thu, Aug 22, 2013 at 5:12 PM, Vincent Veyron wrote:
> Le jeudi 22 août 2013 à 11:29 -0400, Don Parris a écrit :
>
> > Still, how could I have made UTF-8 the default encoding at install
> > time?
>
> I did several recent installations of Postgresql on Debian Wheez
bd-sillage.info.
>
> It appears that the second one is a process forked off from the first
> one. That looks normal to me.
>
>
> Because of the reference to 17769 in the second entry?
>
>
--
Don Seiler
www.seiler.us
put that down. Oracle
DBAs have a similar rule of thumb with anything less than .2 (Oracle starts
at .1).
Don.
--
Don Seiler
www.seiler.us
On Wed, Oct 18, 2017 at 4:17 PM, Vik Fearing
wrote:
> On 10/18/2017 08:17 PM, Don Seiler wrote:
>
> > I disagree with this. It isn't my company's business to test the
> > Postgres software in development, as much as it would be needed and
> > appreciated by the
On Tue, Oct 24, 2017 at 8:12 AM, basti wrote:
>
>
> Is there a way to allow only the above query and deny all other?
>
Probably easiest to just configure your HBA to restrict all
connections/uses except the one that does your xlog query checks.
Don.
--
Don Seiler
www.seiler.us
Hi all,
I believe this may be pertinent here. Last year I wrote a tutorial on
connecting LibreOffice to the powerful PostgreSQL database server. Now
there is an updated driver that allows read-write access. So I've updated
my tutorial, complete with screenshots this time. The actual connection
s
You're welcome! Heaven knows, I ask plenty of questions - it's good to be
able to offer an answer now and again. :-)
Don
On Mon, Jul 9, 2012 at 6:04 PM, Willy-Bas Loos wrote:
> thx for sharing!
>
>
> On Fri, Jul 6, 2012 at 9:13 PM, Don Parris wrote:
>
>> Hi a
Hello all,
I have C code which defines some user defined postgres functions. This
code has been used with Postgres version 7.4 and it uses the
VARATT_SIZEP macro.
I updated to Postgres version 8.3 and attempted to compile my C code and
noticed that the VARATT_SIZEP macro (which my code use
ting down
DEBUG: database system is shut down
Am I close? or is this approach doomed? Suggestions gratefully
accepted.
Don Doumakes
Email: doumakes at loganet dot net
Do not reply to [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading
the name of your old database.
Woohoo! Thanks a million; I've got my data back.
Don Doumakes
Email: doumakes at loganet.net
Do not reply to [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
y
understanding of POSIX re's is they are always greedy. So, why do I get
only SE instead of NE NE SE? Pilot error, probably, but would someone
please enlighten me? Thank you very much.
Don
p.s. The target string can have from 1 to 6 of the 2 char strings, not
j
Tom Lane wrote:
Don Isgitt <[EMAIL PROTECTED]> writes:
gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+');
substring
---
SE
(1 row)
The pg docs say that this form of substring uses POSIX re's, and my
understanding o
Michael Fuhr wrote:
On Tue, Apr 19, 2005 at 12:39:52PM -0400, Alvaro Herrera wrote:
On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote:
On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote:
Thanks, Tom. Interestingly enough, neither my original query or your
away from INFORMIX.
--
Don Laurine
NOAA, Northwest River Forecast Center
voice: (503) 326-7291 (ext. 323)
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHer
ate master
operator field iff opr_match.oldopr=master.operator; if no match, just
update to self. Fine.
What am I doing wrong that gives me the 261 null operator fields after
the update?
Thank you very much for your assistance.
Don
p.s. The "operator is not null" where clause is needed for
Tom Lane wrote:
Don Isgitt <[EMAIL PROTECTED]> writes:
gds2=# update master set operator=(select
coalesce(newopr,master.operator) from opr_match where state=master.state
and oldopr=master.operator limit 1) where state='NM' and operator is not
null;
I think what y
thus,
select lseg # lseg
and the result is the intersection point.
Don
---(end of broadcast)---
TIP 6: explain analyze is your friend
able, and then try again. If
that doesn't give you a more accurate row estimate, though, it won't help.
Don
---(end of broadcast)---
TIP 1: 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
In the postgres log I am getting the following:
ERROR: type "i" does not exist
What is the cause of this error and/or how do I track it down?
I am running postgres ver 8.1.4 under redhat 4
Thanks for any help
Don
begin:vcard
fn:Don Laurine - DOH
n:Laurine;Don
org:Northwest Rive
this is a
nice community!
Thanks,
Don
Begin forwarded message:
From: [EMAIL PROTECTED]
Date: March 4, 2007 9:28:30 AM EST
To: Don Lavelle <[EMAIL PROTECTED]>
Subject: Majordomo results
Reply-To: [EMAIL PROTECTED]
subscribe-digest pgsql-general
The subscribe command did
e
XP. (I'm not a MS Windows user, myself, unless I have to be. My
development boxes are a 1.1 GHz Athlon with 512 RAM with XP and a
dual-processor G4 with MacOS 10.4.)
Are there ballpark requirements for what such a database will need to
run?
Thanks!
Don
will have many, many more questions as
I continue the development process.
Cheers!
Don
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
seeking. Can someone point me in
the right direction? It would be very much appreciated.
Best regards,
Don Kelloway
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
calculating
Outliers, here is one of them...
http://cc.uoregon.edu/cnews/spring2000/outliers.html
Hi Robert,
You may want to consider the R language interface (pl/R); R (the
language) has great tools for detecting and operating on outliers.
Don
---(end of broadcast
Hello,
I have received no posts from GENERAL since yesterday morning; is the
list broken? Thank you.
Don
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHer
llist.
regards
David Potts.
We use perl and R to produce nice land grid maps from the polygon and
point data we have stored in our database. Soon, we will use Pl/R
directly to replace the perl machinations.
Don
---(end of broadcast)---
TIP 9
Hello All,
Does anybody have a live cluster with 2 or more computers running
PostgreSQL, connected to single database on shared storage or to
replicated database with load balancing between them?
--
Best regards,
Yury mailto:[EMAIL PROTECTED]
-
Hello CG,
Monday, February 7, 2005, 10:28:24 PM, you wrote:
C> Return-Path: <[EMAIL PROTECTED]>
C> Delivered-To: [EMAIL PROTECTED]
C> Received: (qmail 15486 invoked from network); 7 Feb 2005 17:36:10 -
C> Received: from svr4.postgresql.org (66.98.251.159)
C> by ns.vpcit.ru with SMTP; 7 Feb
M> Hi,
M> I'm getting some errors in log file saying "invalid character at
M> position
M> #20..." I know that this is most likely that query is wrong.
M> Is it possible to capture all queries that get send or at least the
M> invalid queries?
M> I'm using postgresql 7.4.3 on Red Hat 9
M> Thanks,
I saw a posting about not being able to backup/WALs on different architectures for 8.0.6. Is this still true for the current release?
Don HayesDatabase AdministratorTualatin Hills Parks & Recreation DistrictPhone: (503) 614-1219FAX: (503) 629-5398
if this was part
of the error reporting routines).
If necessary, I could post the source and .sql files but
they may waste a fair bit of bandwidth (about 20KB) -- mainly
due to embedded commentary, etc.
Thanks for any pointers. And, apologies if this was the
*wrong* list for this post! :-(
--don
sure could use a few extra).
Three for a quark... keep the charge! [sic] :>
--don
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Martijn van Oosterhout wrote:
On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote:
[snipped questions and answers]
Thanks!
- Wish list item: errdetail(va_list arg) et al. functions (Yeah,
I can write my own... but it would be nice if this was part
of the error reporting routines
Tom Lane wrote:
Martijn van Oosterhout writes:
On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote:
- Can *_in() be ever invoked with a NULL argument? Or, can I
safely assume that the pointer I am passed is valid?
You can't get a NULL there. Yes, the pointer is valid cstring.
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
Yeah, I was hoping someone would have built a template for
new types that trimmed everything down to a single page/file
instead of having to snoop the source tree. :-(
The various new types in contrib/ are there in part to serve as
types of problems and
based on the result, let the *application* prompt the
user for confirmation. Then, *if* confirmed, do the real
INSERT.
Is there a more elegant way?
Thanks,
--don
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Bernhard Weisshuhn wrote:
Don Y wrote:
[snip]
For example, the title may match an existing entry -- but
the author may be different (e.g., misspelled, or some
"other" author listed on a book having multiple authors, etc.).
Ideally, I would like the database to suspend the INSER
are off-the-wall and
I can undoubtedly come up with kludges to implement them
but I was hoping for something "slicker"... :>)
Thanks!
--don
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
This topic was originally posted to the OpenFTS-general list on April 24,
2006. There were no replies in about 22 hours so I'm reposting to this more
active list.
I'm investigating OpenFTS and tsearch2 to see if they provide enough
full-text searching features to be used in a new application. I've
What is the preferred way of issuing errors of the form:
"Delimiter expected after character #3"
(where "3" obviously varies).
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I'm new to using tsearch2 and am trying to understand why I would want to
use an ISpell dictionary before the stemming dictionary. I'd originally
hoped that ISpell would suggest corrections for misspelled words as the
documents that I will be indexing will contain a lot of spelling mistakes.
From w
deal with
misspellings in English and/or French?
2.2 Are there any clever linguistic algorithms that can partly solve the
same problem?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Don Walker
Sent: April 28, 2006 15:11
To: pgsql-general@postgresql.org
Su
just casts)?
Thanks!
--don
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I'm wrong about the use of English ISpell, then what would be the best
sequence, e.g. French ISpell, English ISpell, English stemmer?
-Original Message-
From: Teodor Sigaev [mailto:[EMAIL PROTECTED]
Sent: May 1, 2006 10:31
To: Don Walker
Cc: pgsql-general@postgresql.org
Subject: Re: [
r types return
references but this type fits in an int4 so value seems
more economical).
I don't see anything in the documentation that suggests that
I can NOT do this... :-/
Below, snippets of the implementation and associated SQL.
Thanks for any pointers!
--don
typedef
Richard Huxton wrote:
Don Y wrote:
Hi,
I have a set of functions for a data type that return
small integers (i.e. [0..12]). I can, of course, represent
it as a char, short or long (CHAR, INT16 or INT32).
re there any advantages/drawbacks to chosing one particular
PG_RETURN_ type over another
Martijn van Oosterhout wrote:
On Tue, May 02, 2006 at 08:43:03AM -0700, Don Y wrote:
Richard Huxton wrote:
Don Y wrote:
Hi,
I have a set of functions for a data type that return
small integers (i.e. [0..12]). I can, of course, represent
it as a char, short or long (CHAR, INT16 or INT32).
re
Martijn van Oosterhout wrote:
On Tue, May 02, 2006 at 10:06:19AM -0700, Don Y wrote:
The type as declared determines the storage required to store it. That
Yes, but for a function returning a value that does not exceed
sizeof(Datum), there is no *space* consequence. I would assume
most modern
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
Nearest I can tell, the problem is related to my attempt to
return an int "by value"
If that's what you intend, try cluing in CREATE TYPE (see
PASSEDBYVALUE).
Thanks! That did the trick!
--don
---
voids this
issue by creating an "internal" function that is used by
other functions -- and *wrapped* in the PG_FUNCTION_INFO_V1
framework under another name (i.e. that name is never used
directly in the rest of the code)
--don
---(end of broadcast)
Martijn van Oosterhout wrote:
On Tue, May 02, 2006 at 11:24:34AM -0700, Don Y wrote:
Hi,
If I define:
Datum barcode_checksum(PG_FUNCTION_ARGS)
PG_FUNCTION_INFO_V1(barcode_checksum)
and now want to *use* that function within some other
(related) function, how can I invoke it? The
s in the future (e.g., forgetting STRICT in
the function declarations when adding a function to
a database, etc)
Thanks!
--don
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
Is there any way of mimicking the IS STRICT behavior
*without* declaring the function as "STRICT"?
Are you looking for PG_RETURN_NULL()? If not, this seems a bit
nonsensical.
No.
First, if the function is defined to retur
Martijn van Oosterhout wrote:
On Wed, May 03, 2006 at 11:02:26PM -0700, Don Y wrote:
(sigh) Sorry to be picking nits. I'm just trying to
sort out how to protect against folks making careless
mistakes in the future (e.g., forgetting STRICT in
the function declarations when adding a functi
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
Is there any way to prevent them from *adding* these functions
(i.e. build them into template) so they have to use them the
way *I* have already defined them?
Only if you think you can deny your users superuser privileges on
the
Martijn van Oosterhout wrote:
On Wed, May 03, 2006 at 11:45:31PM -0700, Don Y wrote:
Martijn van Oosterhout wrote:
Unfortunatly there is no way to ensure the user declares the function
in SQL in the way your code expects. I remember a discussion once about
allowing you to declare the essential
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
First, if the function is defined to return an INT16,
then returning a NULL doesn't make any sense -- since the
caller doesn't know how to deal with a NULL (it expects
an INT16, for example).
Really? That would be a cal
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:19:12AM -0700, Don Y wrote:
I'm not designing for the "traditional" role that you're
used to so I can do whatever makes sense for this product
and just *define* that as it's behavior. Since there are
no other p
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:29:30AM -0700, Don Y wrote:
OTOH, if the function could *abort* it's invocation, then
I don't have to worry about return values. It is a closer
model to the STRICT behavior -- instead of aborting the
function invocation BEF
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:23:07AM -0700, Don Y wrote:
I don't want to hide the function; just ensure that no one
*redefines* the SQL interface to it in a manner that is
inconsistent with its implementation. If I can make the
implementation robust enough th
uld I also PG_RETURN_NULL()? I note the
cast of int4's to int2's signal similar errors -- *but*
returns "(int2) value".
Is the return value just *ignored* when the error is
signaled?
Thanks!
--don
---(end of broadcast)---
TIP
;t support more than a single namespace for functions,
this just won't work.
What am I failing to see, here?
Thanks!
--don
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
I'm writing a set of casts to/from various user defined
types. As is unexpected, there are cases where one
data type doesn't neatly map to another (for certain
values). In these cases I emit an INVALID_PARAMETER_VALUE
or OU
Martijn van Oosterhout wrote:
On Tue, May 16, 2006 at 10:29:27AM -0700, Don Y wrote:
Given a user defined type foo...
I've created several casts to/from foo and built-in types.
I had adopted a naming convention of:
baz foo_to_baz(foo);
foo foo_from_baz(baz);
But:
I don't see
routine inverse(foo) that computes 1/x for any value of
x without testing for x==0?
Am I being clear enough about the question I am
asking? :-/
Thanks!
--don
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi,
Is it possible to have one of my user defined data types
reviewed/critiqued to see if there are things that I am
not doing properly? Or, other things that I should be
including? Or, should I just contribute it and hope
for the best? (if so, how do I do that?)
Thanks!
--don
Martijn van Oosterhout wrote:
On Tue, May 16, 2006 at 08:12:05PM -0700, Don Y wrote:
Hi,
Is it possible to have one of my user defined data types
reviewed/critiqued to see if there are things that I am
not doing properly? Or, other things that I should be
including? Or, should I just
Hi,
It doesn't appear that there is a way to rename a sequence
(ideally with a "cascade" action).
Nor does there appear to be a way to change the owner of
a sequence.
Obviously, I can DROP and recreate... *but*, how prudent
(foolish?) would it be just to change the entries in the
system tables
Bruce Momjian wrote:
Don Y wrote:
Hi,
It doesn't appear that there is a way to rename a sequence
(ideally with a "cascade" action).
Uh, the ALTER SEQUENCE manual page says:
Uh, the 8.0.3 man page for ALTER SEQUENCE makes no mention of this.
Nor does "\h ALTER SEQUENC
Bruce Momjian wrote:
Don Y wrote:
Bruce Momjian wrote:
Don Y wrote:
Hi,
It doesn't appear that there is a way to rename a sequence
(ideally with a "cascade" action).
Uh, the ALTER SEQUENCE manual page says:
Uh, the 8.0.3 man page for ALTER SEQUENCE makes no mention of thi
Jim C. Nasby wrote:
On Wed, May 17, 2006 at 03:00:48PM -0700, Don Y wrote:
I see the documentation mention added August 1, 2005 byt Tom Lane.
Date tag on the bottom of my man pages is "2005-01-17" -- so that
explains *that*! :>
This is a very minor reason why you should be run
Tom Lane wrote:
Tim Allen <[EMAIL PROTECTED]> writes:
Don Y wrote:
So, I'll deploy them and get feedback on which features I
may need to add (some of the data types are probably a bit
too exotic for most users). I figure I can always contribute
them just before a release...
Ju
1 - 100 of 140 matches
Mail list logo
