On Thu, Aug 11, 2005 at 01:59:56PM -0700, CSN wrote:
>
> Jeez, nevermind again! Turns out this was the problem
> in the plphp script:
>
> $sql="select * from table where id=123";
> $result=spi_exec_query($sqll);
If this is reproducable (ie, you can provide a script to trigger it),
please make su
Tom Lane <[EMAIL PROTECTED]> writes:
> Would it? My first thought on reading the OP was to recommend
> contrib/pgstattuple, but I refrained after thinking that if the table
> is all that big, the last thing you need is someone doing a seqscan of
> the whole table to see where you are. Much less
I have created a browser-based documentation tool for PostgreSQL. I
thought this might be interesting to some. More information can be had
at:
http://ccl.cens.nau.edu/MOLI/livepgdoc.html
--
Karim Nassar
Collaborative Computing Lab of NAU
Office: (928) 523 5868 -=- Mobile: (928) 699 9221
http://c
I just experienced some bad SQL causing quite unexpected results.
I used a statement like this:
SELECT t1.a, t1.b, t2.d FROM test1 t1, test2 t2 WHERE t1.a = test2.a;
Where I should have used this instead:
SELECT t1.a, t1.b, t2.d FROM test1 t1, test2 t2 WHERE t1.a = t2.a;
When I looked into it an
# [EMAIL PROTECTED] / 2005-08-12 10:17:50 +0200:
> I just experienced some bad SQL causing quite unexpected results.
>
> I used a statement like this:
> SELECT t1.a, t1.b, t2.d FROM test1 t1, test2 t2 WHERE t1.a = test2.a;
>
> Where I should have used this instead:
> SELECT t1.a, t1.b, t2.d FROM
Christian Laursen wrote:
When I looked into it and tried it from psql, I got this notice:
NOTICE: adding missing FROM-clause entry for table "test2"
Now, I understand that postgresql is adding "test2" to the list of
tables, I am selecting from as it is missing. However the result
is quite diffe
Hello,
I was wondering if it was possible to get a hold of the NEW and OLD
variables available in a Rule and pass them to a function? Maybe there
is another (better) way of accomplishing what I try to do, so I'll
sketch you my testing layout:
CREATE TABLE clients (
id SERIAL PRIMARY KEY,
Hi to all,
Actually I try to authenticate my Linux Postgres installation against Active
Directory, I find 3 solution to use:
1) LDAP
2) Pam and Kerberos
3) Kerberos alone
The first require the modification of the active directory schema, and I
prefer to avoid such responsibility.
For the 2 kerb
> Hi to all,
>
> Actually I try to authenticate my Linux Postgres installation
> against Active Directory, I find 3 solution to use:
>
> 1) LDAP
> 2) Pam and Kerberos
> 3) Kerberos alone
(3) is the one I've been using, and it works very well. I've been
working on a HOWTO, but it' snot done yet.
Just a simple question--is there a way to have analyze use a fixed
PROPORTION of rows rather than a fixed number?
Thanks,
Sean
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hello,
after months of flawless operations suddenly an error occurred.
The database is vacuumed every night. Beside the vacuum error message
the database works fine.
Here the vacuum output:
vacuumdb: vacuuming database "CLIX2"
vacuumdb: vacuuming of database "CLIX2" failed: ERROR: left link
I have a database with blobs, I dump it with the following command:
pg_dump\
--host=$SENSAGE_DB_HOST\
--port=$SENSAGE_DB_PORT\
-U $SENSAGE_DB_ROOT_USER\
--blobs\
--create\
--format=t\
--file="$upgrade_dump"\
$SENSAGE_DB_NAME
I then move the data directory to the side, install the new version in
hi
I am srikanth we are r using postgresql. we are getting the
fallowing error
com.ibm.ivj.eab.dab.DAException: SELECT_FAILED Unable to load DAMessages ResourceBundle.
Invalid character data
was found. This is most likely
caused by stored data containing characters that
Tom Lane wrote:
> Peter Fein <[EMAIL PROTECTED]> writes:
>
>>If I read my ACL's correctly, =UC/postgres means full access for PUBLIC.
>> Why is that happening?
>
>
> Because that's the way it's set up in template1. CREATE DATABASE just
> copies the source database, it doesn't editorialize on th
Frodo Larik <[EMAIL PROTECTED]> writes:
> PostgreSQL obviously complains about NEW not available, how can I make
> it available? Is this the way to do it?
No. You seem to have read something about trigger functions, but this
usage is not a trigger function. You need to do it more like this:
re
Peter Fein <[EMAIL PROTECTED]> writes:
> In particular, by writing TEMPLATE template0, you can create a virgin
> database containing only the standard objects predefined by your version
> of PostgreSQL.
> I guess I'm just surprised that template0 would have *any* ACLs set
PUBLIC is one of the sta
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> It remains unclear to me why the same DBI/DBD::Pg client code
> would deliver performance 2-3 orders of magnitude better on
> other roughly comparable or inferior boxes.
You need to see exactly what is going on to make things so slow.
You can try
I'm new with PostgreSQL and I have some doubts:
Need I use C to create a new type or can I use SQL
singularly?
When I use inheritance the new table inherited
Triggers from the super-table?
__
Converse com seus amigos em tempo real com o Yahoo! Mess
Greetings,
I have the following join, and in this join I am getting all of the
data except that which joins the pa table to the dao table. When I
try to join it using a left join, i get all of the data except this
table. When I use a right join, I get nothing at all. If I make
this a s
On Fri, Aug 12, 2005 at 08:34:23AM -0500, Peter Fein wrote:
> Ok. ;) A little further investigation revealed that template0 gives the
> same result. It's potentially confusing that template0 is initialized
> this way - I couldn't find any indication of such in the manual. In
> fact, from CREATE DA
Hi, thanks for the answer.
Below my comment
> -Messaggio originale-
> Da: Magnus Hagander [mailto:[EMAIL PROTECTED]
> Inviato: venerdì 12 agosto 2005 12.56
> A: Ronzani Dario; pgsql-general@postgresql.org
> Oggetto: RE: [GENERAL] Linux Postgres authentication against
> active directory
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> vacuumdb: vacuuming of database "CLIX2" failed: ERROR: left link
> changed unexpectedly
Hm, is this repeatable? When I wrote the code I thought it was
a can't-happen case, which is why the error message is so terse
(it was only pure paranoia that made
Martijn van Oosterhout wrote:
> On Fri, Aug 12, 2005 at 08:34:23AM -0500, Peter Fein wrote:
>
>>Ok. ;) A little further investigation revealed that template0 gives the
>>same result. It's potentially confusing that template0 is initialized
>>this way - I couldn't find any indication of such in th
Hi Tom,
Tom Lane wrote:
Frodo Larik <[EMAIL PROTECTED]> writes:
PostgreSQL obviously complains about NEW not available, how can I make
it available? Is this the way to do it?
No. You seem to have read something about trigger functions, but this
usage is not a trigger function. You
Christian Goetze <[EMAIL PROTECTED]> writes:
> pg_restore\
> --host=$SENSAGE_DB_HOST\
> --port=$SENSAGE_DB_PORT\
> -U $SENSAGE_DB_ROOT_USER\
> --create\
> --format=t\
> "$upgrade_dump"
You need "-d template1" in there as well. Without a -d, --host and
--port don't actually do anything, I bel
Hello Tom,
thanks for your fast answer. And yes it is reproducible. It started
during my vacation (of course!!!) and I get the message ever since
(approx. 6 weeks, vacuum daily).
We use
Fedora Linux Core 2
PostgreSQL 7.4.2
I'll try to get the information you asked for over the weekend.
Ulr
I have a database which over many years and clients has grown to about
140 tables with attendant triggers , rules and views. Having transferred
to the postgresql community from another database provider the design
did not include the use of schema.
During a recent review it struck me just how use
Hello.
I have an instance of postgreSQL 7.4.7 with one database called dbmedia. We
are moving to postgreSQL 8.1 running on windows2003 server. Can I just copy
the entire $PGDATA directory to the new 8.1 instance of postgreSQL? Using
PG_dump/restore?
I heard that I might run into problems becaus
On Fri, Aug 12, 2005 at 11:36:01PM +0800, Richard Sydney-Smith wrote:
> if a new command were available to transfer between schemas then the
> wishlist would eventually extend to ...
>
> transfer [table] [view] [rule] public.* to schema yyy;
>
> Where * would mean all entries of the selected typ
hi guys
i need advice for query optimization,take too long
time.
any coments are welcomed :).
best
MDC
SELECT c.actuacion_car AS c_actuacion,
c.comentario1 || ' ' || c.comentario2 || ' ' ||
c.comentario3 AS c_comentario
FROM caratult AS c INNER JOIN extractt AS t1 ON
Adam O'Toole wrote:
Hello.
I have an instance of postgreSQL 7.4.7 with one database called dbmedia.
We are moving to postgreSQL 8.1 running on windows2003 server. Can I
just copy the entire $PGDATA directory to the new 8.1 instance of
postgreSQL?
No. And 8.1 isn't out yet.
> Using PG_dump/r
marcelo Cortez wrote:
hi guys
i need advice for query optimization,take too long
time.
any coments are welcomed :).
Comment 1 - you'll need to post the output of "EXPLAIN ANALYSE", not
just EXPLAIN, otherwise people can't see how long it took.
Comment 2 - you provide the definition of o
Thanks for the feedback Richard and Andreas...
Ok, I am missing one thing here
my new instance is on a Windows server. How
will I import the dump from my old 7.4.7 instance running on Linux, into my
new 8.0.1 instance running on Windows 2003? How would you go about feeding a
Dump file into a
On Fri, Aug 12, 2005 at 10:52:03AM -0300, Luiz Siqueira wrote:
> I'm new with PostgreSQL and I have some doubts:
>
> Need I use C to create a new type or can I use SQL singularly?
You can use SQL for some types, and need C for others.
> When I use inheritance the new table inherited Triggers fro
Guys,
I'm getting started with PL/PGSQL but want to understand if the following
is even possible:
With PL/PGSQL, how would I roll through all tables in my database and
print the table name, along with the row count of that table?
Sorry if this is too simplistic. I've googled but must not be phr
On Fri, Aug 12, 2005 at 05:26:50PM -0400, John Wells wrote:
>
> With PL/PGSQL, how would I roll through all tables in my database and
> print the table name, along with the row count of that table?
You can get the schemas and tables from the system catalogs or from
the Information Schema (the latt
John Wells wrote:
Guys,
I'm getting started with PL/PGSQL but want to understand if the following
is even possible:
With PL/PGSQL, how would I roll through all tables in my database and
print the table name, along with the row count of that table?
I would assume you would do something like
On Thursday August 11 2005 6:20 pm, Michael Fuhr wrote:
> On Thu, Aug 11, 2005 at 03:29:29PM -0600, Ed L. wrote:
> > Michael, you nailed it again. My libpq test C program
> > delivered between 2400 QPS and 5000 QPS vs ~10 QPS for
> > DBI/DBD::Pg on this box.
> >
> > It remains unclear to me why th
On Fri, Aug 12, 2005 at 05:20:49PM -0600, Ed L. wrote:
> Well, just as I thought I had this one pinned, my test results
> have become wildly inconsistent, eroding all confidence in my
> prior conclusions about DBI slowness, etc. I've seen at least
> 1000+ QPS performance via DBI/DBD::Pg, Pg, an
On Friday August 12 2005 5:27 pm, Michael Fuhr wrote:
> On Fri, Aug 12, 2005 at 05:20:49PM -0600, Ed L. wrote:
> > Well, just as I thought I had this one pinned, my test
> > results have become wildly inconsistent, eroding all
> > confidence in my prior conclusions about DBI slowness, etc.
> > I'v
On Fri, Aug 12, 2005 at 05:37:22PM -0600, Ed L. wrote:
> On Friday August 12 2005 5:27 pm, Michael Fuhr wrote:
> > How consistent were the results before? I got the impression
> > that you saw consistently bad performance with DBD::Pg when
> > other methods performed well.
>
> Results were very c
Hello,
Wondering if somebody can help me out with upgrading a PostgreSQL 8.0.2 installation on Windows XP SP2.
I can´t seem to upgrade to 8.0.3 on a Windows XP Machine. The machine has a limited user account running the pgsql-8.0 service. The first installation was performed succesfully with th
On Friday August 12 2005 6:11 pm, Michael Fuhr wrote:
> Has anything changed on the system since the results were
> consistently slow? New hardware, new versions of anything,
> reboot, etc.? Did you do any profiling when DBD::Pg was
> consistently slow to see where the bottleneck was?
All good q
On Fri, Aug 12, 2005 at 06:20:27PM -0600, Ed L. wrote:
> On Friday August 12 2005 6:11 pm, Michael Fuhr wrote:
> > Has anything changed on the system since the results were
> > consistently slow? New hardware, new versions of anything,
> > reboot, etc.? Did you do any profiling when DBD::Pg was
> >
On Friday August 12 2005 6:29 pm, Michael Fuhr wrote:
> I meant profiling of DBD::Pg, as Greg Sabino Mullane
> suggested. Here's his message in case you missed it:
No, I didn't miss that, and will do that as a next step. Thanks,
Michael.
Ed
---(end of broadcast)---
How can I append to the current search_path?
How can I put $user (back) into the search path?
These commands all fail:
set search_path $user,public,gnova;
set search_path \$user,public,gnova;
set search_path '$user',public,gnova;
Ideally, I would like something like PATH=${PATH}:/usr/local/bi
On Fri, Aug 12, 2005 at 06:30:59PM -0700, TJ O'Donnell wrote:
> How can I append to the current search_path?
> How can I put $user (back) into the search path?
> These commands all fail:
> set search_path $user,public,gnova;
> set search_path \$user,public,gnova;
> set search_path '$user',publi
47 matches
Mail list logo
