There is an article on General Bits about this.
The article contains a view to pull out the
code in a readable format (with newlines).
http://www.varlena.com/GeneralBits/39.php
[EMAIL PROTECTED]
On Fri, Aug 29, 2003 at 11:27:38AM -0700, Seth wrote:
> How do I view the arguments and deta
How do I view the arguments and details of a user defined function?
---(end of broadcast)---
TIP 8: explain analyze is your friend
In article <[EMAIL PROTECTED]>,
Sander Smeenk <[EMAIL PROTECTED]> wrote:
>Hi,
>
>After a very recent postgresql update, the postmaster failed to start
>because of this:
>
>| PANIC: The database cluster was initialized with LC_CTYPE
>| '[EMAIL PROTECTED]', which is not recognized by setlo
In the last exciting episode, [EMAIL PROTECTED] (Stephen Frost) wrote:
> Would it make sense for vacuum to keep a list of 'last vacuumed' or
> similar so that it doesn't vacuum a table which hasn't changed since
> the last time it was vacuum'd? Seems to me that would be a pretty
> simple o
I am running into problems when attempting to connect to the database.
The server(version 7.3.2-1PGDG) starts just fine.
Running to some permission problems:
psql dbuser
ERROR: _mdfd_getrelnfd: cannot open relation pg_type: Permission denied
psql: ERROR: _mdfd_getrelnfd: cannot open relation p
I am using Delphi7 and PostgeSQL 7.3
My DB table is as such
Create Table files (
emalid varchar(80),
memocolumn text,
savedfile OID );
I cannot post Blobs to the DB that are larger than a typical
icon. If the Blob is small, it goes through just fine. When I try to send a
larger object
>Now I want to know if it is possible (when yes the how?) in Postgresql
>To set dynamically the Localization?
>For example in Oracle you can set the Localization for dates like this
>Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America
SET DATESTYLE TO NonEuropean;
>
>This example
On Fri, Aug 29, 2003 at 08:13:55AM -0400, Andrew Rawnsley wrote:
>
> It appears in my case that the ers_addtable is failing to add
> everything it needs to the slave tables, with a:
>
> DBD::Pg::st execute failed: execute on disconnected handle at
> /db/erserver/lib/eRServer.pm line 54, line 2
about 5% of b are null.. any idea on how to word a query like what I'm
looking for? I have no idea in SQL how to use the results of one select
in another (I usually just do all of it in perl).
Travis
-Original Message-
From: Jeffrey Melloy [mailto:[EMAIL PROTECTED]
Sent: Friday, August
>For example in Oracle you can set the Localization for dates like this
>Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America
SET DATESTYLE TO NonEuropean;
>This example would set the Date-Localization to American but only for the actual
>session.
This one too I think so.
>Is so
On Thu, Aug 28, 2003 at 01:48:31PM +0200, Colin Mangiagalli wrote:
> Hi
>
> I was just wondering if someone could tell me if postgresql supports
> some kind of database replication or mirroring and if so, how easy
> is it to set up.
There is rserv abd dbmirror, and now erserver as well. All (?)
On Thu, Aug 28, 2003 at 03:57:54PM +0800, Keow Yeong Huat Joseph wrote:
> Hi,
>
> the error msg from config.log shows:
> configure: error:
> *** Could not execute a simple test program. This may be a problem
> *** related to locating shared libraries. Check the file 'config.log'
> *** for the e
My observations are completely subjective and without means of proof or raw data that I can throw around.
As a result of a sql statement that 7.4 knows how to optimize I have setup 7.4 on my redhat 9.x beta box (it installz, etc but segfaults on my gentoo box).
I am sure some of what I a s
Quoting Tom Lane ([EMAIL PROTECTED]):
> > The [EMAIL PROTECTED] locale I used 'back then' is incorrect. It's not a
> > real locale, and the newer versions of libc6 and locales that I have
> > installed now don't support the generation of this faulty locale.
> If you believe that your new locale is
Greg Stark <[EMAIL PROTECTED]> writes:
> This is the same thing someone else pointed out a while ago. The consequences
> of guessing wrong and favouring a full table scan instead of index lookups
> with nested loops are simply much more severe than the reverse.
It is easy to demonstrate cases wher
Sander Smeenk <[EMAIL PROTECTED]> writes:
> Quoting Tom Lane ([EMAIL PROTECTED]):
>>> To make a long story short: i can't activate that locale again,
>> Why not? Undoing whatever you did to the locale setup seems a lot
>> easier task than any other option that's open to you.
> The [EMAIL PROTECT
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme:
"If we are setting a table level lock
both the blockId and tupleId (in an item pointer this is called
the position) are set to invalid, if it is a page level lock the
blockId is valid, while the tuple
It would be helpful to see the code that you
actually wrote. Just the part that initiates the transfer of the blob
though.
Derrick Betts wrote:
I am using Delphi7 and PostgeSQL 7.3.2
My DB table is as such
Create Table files (
emalid varchar(80),
memocolumn text,
Take a look at:
http://www.datanamic.com/
the two products you'll need are the importer and dezign
Bart wrote:
Hello
I am looking for something like visual database structure browser. I
need to see all tables and relations beetween them. Something like
"Relations" window in Microsoft d
On Fri, 29 Aug 2003, Jenny - wrote:
> >select for update will get you row level write locks. It won't block
> >normal selects.
> there are no row level read locks in postgresql right?
Not currently.
---(end of broadcast)---
TIP 6: Have you searc
I am looking for something like visual database structure browser. I
need to see all tables and relations beetween them. Something like
"Relations" window in Microsoft database products (ex. msaccess)
Hi,
Try dbVisualizer: http://www.minq.se/products/dbvis/
You can view the relations, but canno
> And doing the explicit cross join statement on o_kat_prod instead of
> ot_kat_prod gives the expected performance to me ( 7.42 msec instead
> of 7324.49 msec with EXPLAIN ANALYZE).
>
> Do i've any chance to get the same performance on the view?
I've had this problem and it was due to improper ty
http://developer.postgresql.org/ftpsite/binary/v7.3.4/RPMS/
Robert Treat
On Thu, 2003-08-28 at 11:18, Marie G. Tuite wrote:
> Same issue - are there rpms anywhere for 7.3.4?
>
> Thanks.
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
>
btw.. thanks for all the help.
Travis
-Original Message-
From: Jeffrey Melloy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 12:32 AM
To: Williams, Travis L, NEO
Cc: Thomas A. Lowery; [EMAIL PROTECTED]
Subject: Re: [GENERAL] Join question
On Thursday, August 28, 2003, at 09:03
Performace wise would I be better off just doing 2 query's.. i.e. select
a,b from table1.. then in perl I can check if b is not null and if is
isn't then I do a second query?
Travis
-Original Message-
From: Jeffrey Melloy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 12:32 AM
To
On Thursday, August 28, 2003, at 09:03 PM, Williams, Travis L, NEO
wrote:
I have a table1 with 2 col (a & b) where b can sometimes be null. I
need a query that if B is null I get back the contents of A.. but if B
is not null I do a "select d from table2 where d like '%b%'" There is
nothing to jo
Greg Stark <[EMAIL PROTECTED]> writes:
> Now, uh, there are 37 tables involved in this query. That's kind of a lot.
> Postgres has to consider 37 factorial different ways of combining these
> tables. or about 13,763,750,000,000,000,000,000,000,000,000,000,000,000,000
> different combinations.
Of
see contrib/dbmirror ... triggered by updates on the primary. Don't know if it would
work for you ... not sure about the second part (see the differences). It uses a table
it creates called "Pending" to store transactions.
Greg W.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED
On Thu, Aug 28, 2003 at 08:22:47 -0700,
Dennis Gearon <[EMAIL PROTECTED]> wrote:
> if one gives a value for the seirial field, the trigger for the serial
> on that table doesn't generate another value?
Serials are implemented using a default function, not a trigger.
---
On Thu, 2003-08-28 at 16:53, Stephen Frost wrote:
> Would it make sense for vacuum to keep a list of 'last vacuumed' or
> similar so that it doesn't vacuum a table which hasn't changed since
> the last time it was vacuum'd? Seems to me that would be a pretty
> simple optimization which wou
Hi,
I saw some replication projects but think this might be an overkill for
my intentions.
I have two databases, Primary / Secondary where the Secondary is
readyonly for
users. I need to mirror tables when changes occur on that table. That
may happen a few times a day.
Tables are in the area of
Alex wrote:
Joe, that is good news.
When will be 7.4 availbable?
Beta2 is just starting. There isn't a firm date for the 7.4 release that
I'm aware of, but start looking for it in mid-September.
Also,
what i actually wanted is to ckeck that if lets say ARRAY[1,2,3]
is inserted but 1,2 or 3 (the
On Thu, 2003-08-28 at 17:52, Dennis Gearon wrote:
> Are these clusters physically together using dedicate LAN lines or
> are they synchronizing over the Interwait?
There have been multiple methods over the years. In order:
1. Cluster Interconnect (CI) : There's a big box, called the CI,
On Thu, Aug 28, 2003 at 20:08:33 -0700,
Jenny - <[EMAIL PROTECTED]> wrote:
> hi ,
> coudl some one tell me how to acquire row-level and page level locks in
> postgresql.
> iam aware that table level locks can be acquired by the command:
> "lock table *tablename* in *locktype* mode;
select for u
hi ,
coudl some one tell me how to acquire row-level and page level locks in
postgresql.
iam aware that table level locks can be acquired by the command:
"lock table *tablename* in *locktype* mode;
thanks
_
Enter for your chance to I
On Thu, 28 Aug 2003 22:23:18 -0400
"Browne, George (AT-Atlanta)" <[EMAIL PROTECTED]> wrote:
> I am really new to postgresql. I have seen developers work in a sql
> environment before so I do understand some concepts. We are currently
> working with opennms an open source network management syste
On Thu, Aug 28, 2003 at 21:10:19 +0530,
Shridhar Daithankar <[EMAIL PROTECTED]> wrote:
>
> Actually I have no idea if you can insert specific value in a serial field. I
> wouldn't be surprised if it works as intended but don't have a postgresql
> installation handy here. (Working in windows ri
On Thu, Aug 28, 2003 at 23:09:44 +0900,
Alex <[EMAIL PROTECTED]> wrote:
> Hi,
> is there an easy way to get the Difference between 2 dates in Days... as
> an integer?
>
> age('date1','date2') results in x years y days or something similar.
> but I would like to
> have the result in number of
Please unsubscribe my email from this newsgroup. Thanks
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
I am really new to postgresql. I have seen developers work in a sql
environment before so I do understand some concepts. We are currently
working with opennms an open source network management system which is a web
application. My question is how does the web application (ie opennms)
communicate
On Thu, Aug 28, 2003 at 02:52:57PM +0200, Bo Lorentsen wrote:
> On Thu, 2003-08-28 at 10:02, Dennis Björklund wrote:
>
> > Yes, never use the oid at all is my suggestion.
> Hmm, will oid's not change so that they are unique regardless, or will
> oid be removed.
OIDs have never beebn unique, it's
Yeah.. so that's why I didn't know if I could do it all in the same
statement.
Travis
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 8:54 PM
To: Williams, Travis L, NEO
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Join question
On Thu
On Thu, Aug 28, 2003 at 09:46:34PM -0400, Williams, Travis L, NEO wrote:
> That would probably work great.. except I screwed my question up.. Let
> me try again and this time think before I write
>
> I have a table1 with 2 col (a & b) where b can sometimes be null. I
> need a query that if B is n
That would probably work great.. except I screwed my question up.. Let
me try again and this time think before I write
I have a table1 with 2 col (a & b) where b can sometimes be null. I
need a query that if B is null I get back the contents of A.. but if B
is not null I do a "select d from table
Joe, that is good news.
When will be 7.4 availbable?
Also,
what i actually wanted is to ckeck that if lets say ARRAY[1,2,3]
is inserted but 1,2 or 3 (the the entire array) is not present in the
reference table.
Will that be available too ?
Alex
Joe Conway wrote:
Alex wrote:
a) index array f
Sure.. if it works.. I'm just trying to not have to make multiple calls
to the DB.. I'll try it out..
Thanks,
Travis
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 8:06 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Join question
D
> Perhaps the optimizer thinks the tables are just small enough
> to not make them
> worthwhile.
>
> Which columns actually have indexes, are they all the same
> data type as the
> value they're being compared against?
Yup, this was my guess. Many of the tables being joined in are not excessi
Mike Mascari <[EMAIL PROTECTED]> writes:
> > 1) Our database is highly normalized.
If anything I was worried it was "excessively" normalized. Sometimes people go
overboard, taking columns that really could be simple attributes and make them
reference tables. But that usually doesn't cause perfor
You can download readline from ftp://ftp.gnu.org/pub/gnu/readline
or you can keep the include --without-readline as option.
regards
-Original Message-
From: jason dang [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 6:21 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Install Postgre
Does using a union count as one query?
select a from tst_1 where b is null
union
select d from tst_2 t2 join tst_1 t1 on (t1.b = t2.c)
where t1.b is NOT null
On Thu, Aug 28, 2003 at 05:55:27PM -0400, Williams, Travis L, NEO wrote:
> Question,
>
> I have a table (1) with 2 col (a & b) where b ca
> You need to extract the current val first and explicitly use it in insert
> statement. That way you won't have to produce work-arounds later..
This statement is wrong. If you were going to use this method (
getting the value first - then setting it), I believe you would need
to call nextval not
Hi,
I am trying to install postgreSQL on the AIX 5.1 platform but I ran into
a few problems. It stated that readline is not found. Does anyone have
any suggestions on what I can do or hints on where I should look into
for more information. Any help is much appreciated.
regards,
jaSon
--
52 matches
Mail list logo
