Title: RE: [GENERAL] [PATCH] Better way to check for getaddrinfo function.
That was very much situation specific.
But the bottomline is the default test does not include in the test code.
So, pg uses getaddrinfo.c.And the getaddrinfo.c does not work for me.
Ipv6 client authenciation fa
"tschak" <[EMAIL PROTECTED]> writes:
> Can I explicitly store 4 Bit (FIXED lenght) in a column without
> "wasting" space?
No. There is no provision in Postgres for data types occupying less
than a byte. You'll need to think about merging those columns together.
> Alright... so I do not need the
> Orlando Giovanny Solarte Delgado wrote:
>> I am designing a system that it takes information of several databases
>> distributed in Interbase (RDBMS). It is a system web and each user can
>> to do out near 50 consultations for session. I can have simultaneously
>> around 100 users. Therefore I ca
Hi,
I am getting following strange errors while executing queries.
1)
ERROR: xlog flush request 0/108EA5F8 is not satisfied --- flushed only
to 0/1813C60
CONTEXT: writing block 2 of relation 17142/16653
WARNING: could not write block 2 of 17142/16653
DETAIL: Multiple failures --- write error
Exact message of my second problem is:
WARNING: relation "rawlog" page 0 is uninitialized --- fixing
-Original Message-
From: Mavinakuli, Prasanna (STSD)
Sent: Monday, January 16, 2006 9:28 AM
To: pgsql-general@postgresql.org
Subject: Strange error while executing query from front end
When I try to do vacuum then also I am getting same error,warning
rather.
LOGARCHDB=# vacuum;
WARNING: relation "rawlog" page 2 is uninitialized --- fixing
WARNING: relation "rawlog" page 3 is uninitialized --- fixing
WARNING: relation "rawlog" page 2 is uninitialized --- fixing
WARNING: rel
> If you don't need an OID, don't include it. IIRC, bit(4) will be 8
> bytes due to being variable length. If you want to store small numbers,
> maybe smallint (2 bytes) is more useful.
What I acually meant was the OID... Is smallint(2) the smalles size I
can allocate? If I cannot allocate 4Bit o
I am accessing PostgreSQL through MS Access.
Everything works Ok if I manually connect through Access using the ODBC
Dialog.
However I wrote a VB function that opens the database and connects to it.
This works provided there is no int8 column in the PostgresSQL table.
When I use the ODBC interface
On Mon, Jan 16, 2006 at 02:20:23PM -0700, Michael Fuhr wrote:
> On Mon, Jan 16, 2006 at 12:17:26PM -0800, [EMAIL PROTECTED] wrote:
> > The following query is working when this is used by static cursor. This
> > will return all the properties within the distance of 20 miles
> [...]
> > But When I a
On Sat, Jan 14, 2006 at 04:51:44PM -0700, Peter Michaux wrote:
> Option 1 - would have many join tables and each would require a class in my
> ORM.
>
> categories_images
> - category_id
> - image_id
>
> images_products
> - product_id
> - image_id
>
> Option 2 - have a one generic join table and
Well p/cluster is not OSS. Sequioa is but is query based and doesn't
correctly deal with things like now().
I was speaking directly about OSS replication.
Correct me if I'm wrong, but AFAIK Slony is the only OSS replication
that isn't statement based, which as Josh mentioned has some se
"Marcin" <[EMAIL PROTECTED]> wrote
>
> I suffer from huge increase in number of disk writes after migration
> from 8.0.3 to 8.1.2. The average number of sectors written increased 10
> times and transfer stays at 20MB of writes per second during work hours
> (with 20% cpu time wasted in iowait). Th
On Fri, Jan 13, 2006 at 05:30:49PM -0800, Joshua D. Drake wrote:
> >Why would you only recommend Slony? How does it compare to Sequoia or
> >p/cluster?
>
> Well p/cluster is not OSS. Sequioa is but is query based and doesn't
> correctly deal with things like now().
>
> I was speaking directly a
On Sat, Jan 14, 2006 at 04:28:39AM +, Sally Sally wrote:
> Yes a backend gets spewed. Actually it did connect me finally (I am not
> sure exactly how long it took). I checked back after about four hours and I
> was connected. I have also noticed in the past that after running vacuum
> the cl
On Mon, Jan 16, 2006 at 12:13:15PM -0500, Chris Browne wrote:
> What you seem to be after, here, would confine your telno formatting
> to telephone numbers for Canada and the United States, and would break
> any time people have a need to express telephone numbers outside those
> two countries.
>
On Mon, Jan 16, 2006 at 09:21:55AM +0100, H.J. Sanders wrote:
> Thanks for you answer. I've looked for the stats but I could not find
> it in our 7.4 , but I will look further (perhaps SUSE didn't
> install them).
How did you look? You shouldn't have to install anything extra;
statistics collecti
On Mon, Jan 16, 2006 at 12:17:26PM -0800, [EMAIL PROTECTED] wrote:
> The following query is working when this is used by static cursor. This
> will return all the properties within the distance of 20 miles
[...]
> But When I am trying to build the dynamic sql string to a refcursor it is
> not abl
Hi
The following query is working when this is used by static cursor. This will
return all the properties within the distance of 20 miles
v_point is a local variable. 'POINT(' || v_rec.lon || ' ' || v_rec.lat ||
')'
SELECT property_rating_id
, property_id
, property_name_fixed
Tom Lane wrote:
> The above is a pretty bad idea in any case --- think about what happens
> when you have some data in the table. It'll set *every row* to id = 1
> and data = 'test'.
Your right, DUH, I forgot my where clause in my example. It is in the
real query though, perhaps I didn't get e
Hello,
By using -E to see the outputs, figure out a way by myself:
select distinct g.groname, u.usename from pg_catalog.pg_user u,
pg_catalog.pg_group g WHERE u.usesysid = ANY(g.grolist) order by
groname, usename;
Do you have a simpler way such as \d???
Thanks,
Emi
Greetings,
May I ask
Greetings,
May I ask is there a simple way like \dg+ to get all users' names under
all groups please? If no, which sys tables should I use to get it?
I am expecting something like :
Group name | Users
--
g1 | u1, u2, u3
g2 | u1
g3 | u6
Than
Matthew Schumacher <[EMAIL PROTECTED]> writes:
> update test set id = 1, data = 'test';
The above is a pretty bad idea in any case --- think about what happens
when you have some data in the table. It'll set *every row* to id = 1
and data = 'test'. The reason nothing happens when there is nothin
Tom Lane wrote:
> Matthew Schumacher <[EMAIL PROTECTED]> writes:
>
>>I'm having trouble getting the rule system to work on updates that do
>>not match the where clause.
>
>
> You did not say what you mean by "doesn't work", but what I suspect you
> are getting bit by is that ON UPDATE rules fire
Hi,
I suffer from huge increase in number of disk writes after migration
from 8.0.3 to 8.1.2. The average number of sectors written increased 10
times and transfer stays at 20MB of writes per second during work hours
(with 20% cpu time wasted in iowait). The number of queries lasting more
than 300m
"rlee0001" <[EMAIL PROTECTED]> writes:
>> > example. For example:
>> > In: 123 456-7890
>> > Out: (123) 456-7890
>> > Stored As:
>> >PHONE = (Virtual Function, with Regexp input parser)
>> >AREA_CODE = 123
>> >PREFIX = 456
>> >
"R, Rajesh (STSD)" <[EMAIL PROTECTED]> writes:
> Just thought that the following patch might improve checking for
> getaddrinfo function (in configure.in)
Since AC_TRY_RUN tests cannot work in cross-compilation scenarios,
you need an *extremely* good reason to put one in. "I thought this
might im
Matthew Schumacher <[EMAIL PROTECTED]> writes:
> I'm having trouble getting the rule system to work on updates that do
> not match the where clause.
You did not say what you mean by "doesn't work", but what I suspect you
are getting bit by is that ON UPDATE rules fire before the original
query is
Orlando Giovanny Solarte Delgado wrote:
> I am designing a system that it takes information of several databases
> distributed in Interbase (RDBMS). It is a system web and each user can
> to do out near 50 consultations for session. I can have simultaneously
> around 100 users. Therefore I can have
I don't really know what you're trying to accomplish here, but dropping and
creating thousands of tables is never a good idea with any database system.
You can certainly do that, just don't expect any query to run at their best
performance. You'd need to at least do a vacuum before starting to qu
Not directly related to PostgreSQL, but an interesting read:
http://www.informationweek.com/news/showArticle.jhtml?articleID=175801775
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/p
I am designing a system that it takes information of several databases
distributed in Interbase (RDBMS). It is a system web and each user can to do
out near 50 consultations for session. I can have simultaneously around 100
users. Therefore I can have 5000 consultations simultaneously. Each
con
I am designing a system that it takes information of several databases distributed in Interbase (RDBMS). It is a system web and each user can to do out near 50 consultations for session. I can have simultaneously around 100 users. Therefore I can have 5000 consultations simultaneously. Each consult
thanks.
- Original Message -
From:
Michael
Schmidt
To: pgsql-general@postgresql.org ;
Zlatko Matić
Sent: Sunday, January 15, 2006 11:40
PM
Subject: Re: [GENERAL] visual query
builder for Postgres?
A Visual Query Builder is available in PG Lightning Ad
Thanks
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>;
Sent: Monday, January 16, 2006 3:01 PM
Subject: Re: [GENERAL] visual query builder for Postgres?
Zlatko Matić wrote:
Is there any visual tool for creating queries in PostgreS
On Mon, Jan 16, 2006 at 11:57:35AM +0100, Francesco Formenti - TVBLOB S.r.l.
wrote:
> Jim C. Nasby wrote:
>
> >On Thu, Jan 12, 2006 at 06:11:32PM +0100, Francesco Formenti - TVBLOB
> >S.r.l. wrote:
> >
> >
> >>I put an ACCESS EXCLUSIVE LOCK on the table of objects at the beginning
> >>of the s
Zlatko Matić wrote:
Is there any visual tool for creating queries in PostgreSQL?
Zlatko
PG Lightning Admin has a visual query builder plus
lots more(modern tabbed MDI interface,printing,import/export etc) and
it's super inexpensive.
--
Tony Caduto
AM Software Design
Home of PG Lightning Ad
Title: [PATCH] Better way to check for getaddrinfo function.
Just thought that the following patch might improve checking for getaddrinfo function (in configure.in)
I was forced to write 'coz getaddrinfo went unnoticed in Tru64 Unix.
(displaying attached patch)
$ diff -r configure.in
> Sure, but it still means installing an external tool, which requires
> PHP, which isn't trivial to install in it's own right. And afaik there's
> still no way to find out how much IO each query did, how much CPU was
> spent, if any sorts overflowed, etc., etc.
Exactly my point, and thus the reas
In Postgres 8.1.1, Win XP, I tried to create some
temporary tables by using pgAdmin. For example, I executed :
CREATE TEMP TABLE privremena() INHERITS
(plants)WITHOUT OIDSTABLESPACE pg_default;ALTER TABLE privremena
OWNER TO matalab;
Although query was successfully executed, I just
can't f
I'm having trouble getting the rule system to work on updates that do
not match the where clause. Perhaps I'm doing this wrong, but I can't
find any docs that explain this very clearly.
Here what I would like to do:
CREATE OR REPLACE RULE
insertAcctUpdate
AS ON UPDATE TO
accounting_tab
WHERE
40 matches
Mail list logo
