Ashish Karalkar wrote:
Hello List,
I am having list of tables , what I want to do is to
filter this list of table for a particular value of
its column, the column which i will be searching is
common accross all tables in list
any clues??
Something like
SELECT * FROM
(
SELECT col1,co
Hello List,
I am having list of tables , what I want to do is to
filter this list of table for a particular value of
its column, the column which i will be searching is
common accross all tables in list
any clues??
With regards
Ashish Karalkar
Jeff Amiel <[EMAIL PROTECTED]> writes:
> We've downloaded/compiled pg_filedump, but are stumped as to what relation
> (or even what database) to start with.
Turn up log_min_messages to DEBUG2 and you'll be able to see which
table autovac is failing at. If I had to bet I'd bet on
template0.pg_sta
Jeff Amiel <[EMAIL PROTECTED]> writes:
> "PostgreSQL 8.1.2 on i386-portbld-freebsd6.0, compiled by GCC cc (GCC) 3.4.4
> [FreeBSD] 20050518"
> Jan 2 03:05:04 prod-app-1 postgres[8524]: [4-1] 8524 LOG: autovacuum:
> processing database "template0"
> Jan 2 03:05:05 prod-app-1 postgres[8524]: [5
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Thu, Jan 11, 2007 at 03:14:37PM -0500, Tom Lane wrote:
>> ... And anyway there should never
>> *be* a real permissions problem; if there is then the user's been poking
>> under the hood sufficient to void the warranty anyway ;-)
> Or some other "help
"Jeanna Geier" <[EMAIL PROTECTED]> writes:
> And log file shows the following (what I posted before was through pgAdmin):
> 2007-01-11 15:38:47 ERROR: relation "temp_measurement" does not exist
> 2007-01-11 15:38:47 ERROR: syntax error at or near "7094982" at character 1
> 2007-01-11 15:38:47 ERR
Looking backwards in the logs we see it a few other times this month...
(Autovacuum occurring just prior)...same transaction ID
How could it be the same transaction ID from several days prior?
Jan 2 03:05:04 prod-app-1 postgres[8524]: [4-1] 8524 LOG: autovacuum:
processing database "template0"
"PostgreSQL 8.1.2 on i386-portbld-freebsd6.0, compiled by GCC cc (GCC) 3.4.4
[FreeBSD] 20050518"
Started seeing this in the logs this afternoon...scaring the begeezus out of me.
Jan 11 19:20:19 prod-app-1 postgres[1752]: [5-1] 1752 ERROR: could not access
status of transaction 1924023481
Jan
Richard P. Welty wrote:
running 8.1 on a fedora core 5 linux box, up to date so far as
i know.
this page:
http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html
says the following:
Note: template1 and template0 do not have any special status beyond
the fact that the
On Thu, 2007-01-11 at 21:42 -0300, Alvaro Herrera wrote:
> Joshua D. Drake wrote:
>
> > > Please don't. At least not on the PostgreSQL web site nor in the docs.
> > > And no, I don't run my production servers on Windows either.
> >
> > It does seem like it might be a good idea to have FAQs based
You could have your program check to see if the lastname form field was
empty, and send different queries to the database depending on what they
entered.
I'm a perl person, not php, so my php syntax might not be perfect, but
you'll get the idea:
if ($lastname =="") {
$query="SELECT foo, baz,
On Thu, Jan 11, 2007 at 09:42:38PM -0300, Alvaro Herrera wrote:
>
> But we have per-platform FAQs. If there is information missing, the
> reason is that nobody has submitted an appropriate patch, nothing more.
>
where are these FAQs, and why were they not easily found when the original
poster s
Joshua D. Drake wrote:
> > Please don't. At least not on the PostgreSQL web site nor in the docs.
> > And no, I don't run my production servers on Windows either.
>
> It does seem like it might be a good idea to have FAQs based on each OS,
> yes? There are various things that effect each OS diff
On Thu, Jan 11, 2007 at 03:12:07PM -0800, Joshua D. Drake wrote:
> It does seem like it might be a good idea to have FAQs based on each OS,
> yes? There are various things that effect each OS differently. The most
> obvious to me being shared memory and wal_sync_method.
>
> If could be a good idea
> >
> >
> >
>
>
> Please don't. At least not on the PostgreSQL web site nor in the docs.
> And no, I don't run my production servers on Windows either.
It does seem like it might be a good idea to have FAQs based on each OS,
yes? There are various things that effect each OS differently. The
Richard Troy wrote:
On Thu, 11 Jan 2007, Tom Lane wrote:
...snip...
(You know, of course, that my opinion is that no sane person would run a
production database on Windows in the first place. So the data-loss
risk to me seems less of a problem than the unexpected-failures problem.
It's not
Mike Poe wrote:
SELECT foo, baz, bar FROM public.table WHERE lastname ~*
'$lastname' OR ssn='$ssn'"
I need to leave the last name a wildcard in case someone enters a
partial name, lower case / upper case, etc.
I want the SSN to match exactly if they search by that.
The way it's written, if
On Thu, 2007-01-11 at 14:20 -0500, Merlin Moncure wrote:
> I am looking into using pg_standby (v3) in a warm standby system. I'm
> going to double check it, but same machine replication seemed to work
> ok. When I tried to do remote server log shipping however, I had some
> issues.
>
> Initial
I am looking to have the select list passed into a function at runtime and
use this select list to build SQL to execute, for example:
CREATE or REPLACE FUNCTION "public"."test2"(
IN "_sfieldlist" varchar)
RETURNS SETOF "pg_catalog"."record" AS
$BODY$
DECLARE
v_feed RECORD;
v_sfi
On Wed, 2007-01-10 at 16:51, [EMAIL PROTECTED] wrote:
> The missing quote after Poster is a mistake I made when sanitzing the
> data for posting here. That error is NOT present in the actual data.
> There is a quote where needed in the data. So, with that in mind, why
> am I still getting the error
OK, so if there are several of these same types of errors (which I verified
by running the RESTORE from the command line vs. pgAdmin - some with "\" and
some with the OID; how come it exits out on that one particulat one?? Any
thoughts or ideas on that one?:
COPY profession_type (projectname,
The missing quote after Poster is a mistake I made when sanitzing the
data for posting here. That error is NOT present in the actual data.
There is a quote where needed in the data. So, with that in mind, why
am I still getting the error?
Also, there is no symbol we can expect to not be in the dat
Hello,
I've got a problem inserting binary objects into the postgres database.
I have binary objects (e.g. images or smth else) of any size which I
want to insert into the database. Funny is it works for files larger
than 8000 Bytes. If a file is less than 1000 Bytes I get the following
message:
E
Jonathan Hedstrom wrote:
> [EMAIL PROTECTED] wrote:
> > "SELECT replace(columname, 'chr(13)','') from tablename"
>
> Try using chr(13) without the single quotes:
>
> SELECT replace(columname, chr(13),'') from tablename
>
> or you could use '\r' to get the character:
>
> SELECT replace(columname,
I'm a rank newbie to Postgres & am having a hard time getting my arms
around this.
I'm trying to construct a query to be run in a PHP script. I have an
HTML form were someone can enter either a last name or a social
security number & then query the database based on what they entered.
My query l
[EMAIL PROTECTED] wrote:
> Outputting a SELECT statement's results to ascii file showed me a table
> with a bunch of embedded carriage return characters in the values. I
> want to remove the embedded returns, so I read the documentation and
> tried a few variations on "SELECT replace(columname, 'c
On Thu, 11 Jan 2007, Tom Lane wrote:
...snip...
>
> (You know, of course, that my opinion is that no sane person would run a
> production database on Windows in the first place. So the data-loss
> risk to me seems less of a problem than the unexpected-failures problem.
> It's not like there aren
And log file shows the following (what I posted before was through pgAdmin):
2007-01-11 15:38:17 LOG: could not load root certificate file "C:/Program
Files/PostgreSQL/8.0/data/root.crt": No such file or directory
2007-01-11 15:38:17 DETAIL: Will not verify client certificates.
2007-01-11 15:38:
On Thu, Jan 11, 2007 at 04:32:42PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Given that this could result in data loss, if this was to be done I'd
> > very much want to see a way to disable it in a production environment.
>
> Production environments are the same ones
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> I find it very unlikely that you would "during normal operations" end up
>> in a situation where you would first have permissions to create files in
>> a directory, and then lose them.
>> What could be is that you have a directory whe
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Where are the style guidelines? I looked before but can't find them.
http://developer.postgresql.org/pgdocs/postgres/error-style-guide.html
regards, tom lane
---(end of broadcast)
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Given that this could result in data loss, if this was to be done I'd
> very much want to see a way to disable it in a production environment.
Production environments are the same ones that won't be happy with
random checkpoint failures, either.
If we
running 8.1 on a fedora core 5 linux box, up to date so far as
i know.
this page:
http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html
says the following:
Note: template1 and template0 do not have any special status beyond
the fact that the name template1 is the def
Just a bit more info: Running Postgres 8.0
and the: 255454 3 WestSalem 2006-05-12 14:10:18.578-05 greg
clean it
2006-05-12 17:00:00-05 W6037 Ruth Lane OnalaskaWisconsin 54650
...
is a row (the first row) that should be inserted/restored into the
'workorder.w
On Thu, Jan 11, 2007 at 03:14:37PM -0500, Tom Lane wrote:
> The downside of this is that a real EACCES problem wouldn't get noted at
> any level higher than LOG, and so you could theoretically lose data
> without much warning. But I'm not seeing anything else we could do
> about it --- AFAIK we ha
Magnus Hagander <[EMAIL PROTECTED]> writes:
> I find it very unlikely that you would "during normal operations" end up
> in a situation where you would first have permissions to create files in
> a directory, and then lose them.
> What could be is that you have a directory where you never had
> per
Perfect! Thenx!
-R
On Thu, 2007-01-11 at 12:26 -0800, Adrian Klaver wrote:
> On Thursday 11 January 2007 10:26 am, Rafal Pietrak wrote:
> > On Thu, 2007-01-11 at 15:10 +0100, Alban Hertroys wrote:
> > > Rafal Pietrak wrote:
> > > > Hi!
> > > >
> > > > I'm re-posting this message again in hope som
Hi List!
I'm attempting to do a restore of a database and I'm getting the following
error the I'm not familiar with:
COPY workorder (work_order_id, projectname, request_date, requestor,
request_detail, request_completion_date, request_a...
pg_restore: restoring data for table "worksite"
pg_resto
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Updated wording:
>
> > test=> select * from test union select * from test order by x is null;
> > ERROR: A UNION/INTERSECT/EXCEPT ORDER BY cannot use expressions or
> > functions, only result column names
>
> This does not meet t
On Thu, Jan 11, 2007 at 20:07:29 +0100,
Marcus Engene <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> I'd like to generate the latest year dynamically with generate_series.
> This select works day wise:
>
> This works but looks grotesque:
>
> select distinct date_trunc ('month', now()::date + s.a)::
On Thursday 11 January 2007 10:26 am, Rafal Pietrak wrote:
> On Thu, 2007-01-11 at 15:10 +0100, Alban Hertroys wrote:
> > Rafal Pietrak wrote:
> > > Hi!
> > >
> > > I'm re-posting this message again in hope someone would have a look at
> > > the case again. .. it's pending.
> >
> > You were given
Bruce Momjian wrote:
> Here the column result is an expression, and you reference that.
> Updated wording:
>
> test=> select * from test union select * from test order by x is null;
> ERROR: A UNION/INTERSECT/EXCEPT ORDER BY cannot use expressions or
> functions, only result column names
Th
Thanks, everyone - I really appreciate everyone's inupt and responses!
Got this resolved and added the RULES to my .sql file. So far, so good.
-Jeanna
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bernd Helmle
Sent: Thursday, January 11, 2007 9:02 AM
To
Tom Lane wrote:
> "Patrick Earl" <[EMAIL PROTECTED]> writes:
>> In any case, the unit tests remove all contents and schema within the
>> database before starting, and they remove the tables they create as
>> they proceed. Certainly there are many things have been recently
>> deleted.
>
> Yeah, I
Tom Lane skrev:
Marcus Engene <[EMAIL PROTECTED]> writes:
I tried this but it didn't work:
select date_trunc ('month', now())::date + interval s.a || ' months'
from generate_series(0, 11) as s(a)
People keep trying that :-(. The "typename 'foo'" syntax is for a
*literal constant* only. In
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Updated wording:
> test=> select * from test union select * from test order by x is null;
> ERROR: A UNION/INTERSECT/EXCEPT ORDER BY cannot use expressions or
> functions, only result column names
This does not meet the style guidelines.
On Thu, Jan 11, 2007 at 18:51:57 +0100,
Jiří Němec <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I need to remove duplicates rows from a subquery but order these
> results by a column what is not selected. There are logically two
> solutions but no works.
>
> SELECT DISTINCT sub.foo FROM (SELECT ...)
"Patrick Earl" <[EMAIL PROTECTED]> writes:
> In any case, the unit tests remove all contents and schema within the
> database before starting, and they remove the tables they create as
> they proceed. Certainly there are many things have been recently
> deleted.
Yeah, I think then there's no ques
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Well, it can be an expression _if_ the expression _matches_ an existing
> > UNION column.
>
> You're mistaken. It has to be *an output column name*. Not anything else.
Yea, I was thinking of this:
SELECT *, state IS NULL A
There is no antivirus software running on the machine.
I'm not entirely sure how to determine which relation it is
complaining about. I see a folder that corresponds to the middle
number in the log, and I see numbers in the same range as the right
number from the log.
In any case, the unit test
Marcus Engene <[EMAIL PROTECTED]> writes:
> I tried this but it didn't work:
> select date_trunc ('month', now())::date + interval s.a || ' months'
> from generate_series(0, 11) as s(a)
People keep trying that :-(. The "typename 'foo'" syntax is for a
*literal constant* only. Instead use multip
Jonathan Hedstrom wrote:
> We downloaded the most recent stock FC6 kernel and rebooted to that.
> Hopefully this will take care of the issue.
We've been up and running for 2 days now on the stock kernel, and
haven't seen any of these errors. I'm thinking the issue is resolved.
Thanks again for al
Martijn van Oosterhout writes:
> On Thu, Jan 11, 2007 at 07:26:32PM +0100, Rafal Pietrak wrote:
>> So may be "SET CONSTRAINTS DEFERRED " should be used somehow
>> differently? I've never had any use for that construct, may be I miss
>> something?
> Only at the beginning of a transaction and
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Well, it can be an expression _if_ the expression _matches_ an existing
> UNION column.
You're mistaken. It has to be *an output column name*. Not anything else.
regards, tom lane
---(end of broadcast)-
On 1/11/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
Merlin Moncure wrote:
> On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a ?crit:
> > > I am working on a project where we are converting from MySQL to
> > > Postgres.
Merlin Moncure wrote:
> On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a ?crit:
> > > I am working on a project where we are converting from MySQL to
> > > Postgres. I figured the easiest way would be to export the MySQL
"Patrick Earl" <[EMAIL PROTECTED]> writes:
> We're getting the error as part of an automated test suite and it is
> seems to occur every time the suite is run. The platform is Win XP 64
> bit.
Hm. We've seen problems of this ilk caused by bogus antivirus software,
but if that were the explanatio
Mike Benoit wrote:
> That helps some, but I'm sure it could be even more clear.
>
> The main issue is that you can't order by an expression computed by
> unions, correct? So couldn't the error message by something like:
>
> "ORDER BY on a UNION/INTERSECT/EXCEPT result must match existing result
I am looking into using pg_standby (v3) in a warm standby system. I'm
going to double check it, but same machine replication seemed to work
ok. When I tried to do remote server log shipping however, I had some
issues.
Initial setup and launch is working ok, my archive command is:
'test ! -f /va
Hi list,
I'd like to generate the latest year dynamically with generate_series.
This select works day wise:
select date_trunc ('month', now())::date + s.a
from generate_series(0, 11) as s(a)
I tried this but it didn't work:
select date_trunc ('month', now())::date + interval s.a || ' months'
f
On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote:
Hi,
Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a écrit:
> I am working on a project where we are converting from MySQL to
> Postgres. I figured the easiest way would be to export the MySQL data
> as CSV.
If you are using pg 8.2+
On Thu, 2007-01-11 at 13:44 -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > Michael Glaesemann <[EMAIL PROTECTED]> writes:
> > > On Dec 26, 2006, at 18:39 , Mike Benoit wrote:
> > >> ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of
> > >> the result columns
> >
> > > Even th
We're getting the error as part of an automated test suite and it is
seems to occur every time the suite is run. The platform is Win XP 64
bit.
When running the same unit test suite from a remote machine, the error
does not occur. The error also does not occur when manually running
the create d
Tom Lane wrote:
> Michael Glaesemann <[EMAIL PROTECTED]> writes:
> > On Dec 26, 2006, at 18:39 , Mike Benoit wrote:
> >> ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of
> >> the result columns
>
> > Even though state is a column in both tables, the order by is using
> > an
On Thu, Jan 11, 2007 at 07:26:32PM +0100, Rafal Pietrak wrote:
> Well. I were, but probably I'm doing something wrong with 'deferring the
> trigger'. When I put:
>
> "SET CONSTRAINTS ALL DEFERRED ; "
>
> *before* the UPDATE statement *within* the trigger function (just after
> BEGIN statement t
On Thu, 2007-01-11 at 15:10 +0100, Alban Hertroys wrote:
> Rafal Pietrak wrote:
> > Hi!
> >
> > I'm re-posting this message again in hope someone would have a look at
> > the case again. .. it's pending.
>
> You were given a solution; defer the foreign key constraint.
Well. I were, but probab
Jiří Němec wrote:
Hello,
I need to remove duplicates rows from a subquery but order these
results by a column what is not selected. There are logically two
solutions but no works.
SELECT DISTINCT sub.foo FROM (SELECT ...) AS sub ORDER BY sub.bar
ERROR: for SELECT DISTINCT, ORDER BY expressions
"Patrick Earl" <[EMAIL PROTECTED]> writes:
> 2007-01-11 09:56:17 ERROR: could not open relation 1663/16403/16426:
> Permission denied
> 2007-01-11 09:56:17 ERROR: checkpoint request failed
> 2007-01-11 09:56:17 HINT: Consult recent messages in the server log
> for details.
> 2007-01-11 09:56:17
Hello,
I need to remove duplicates rows from a subquery but order these
results by a column what is not selected. There are logically two
solutions but no works.
SELECT DISTINCT sub.foo FROM (SELECT ...) AS sub ORDER BY sub.bar
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in sele
Hi all. I'm getting a checkpoint request failed message when I try to
execute a CREATE DATABASE command. Since it was a fresh install, I've
included the entire server log up to the point of the error. I
truncated the log output two lines after the error message.
Is there a way I can avoid this
Hi,
I will need to create a crosstab representation of my resultset.
The resultset looks like this: rowid, columnid, cellvalue
I don't know beforehand the number of columns and their id's but they
will be close to 200.
I have looked at the crosstab tablefunction but it seems that you have
to know
> Besides writing a script that looks through the DDL of all tables, and
> CLUSTERs all tables with PK constraints, is there a quicker way?
Is this really a sensible thing to do? As often as not, you want to cluster
on foreign keys...
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(
Bernd Helmle wrote:
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr <[EMAIL
PROTECTED]> wrote:
Either way. I like to create sql files with all of the DDL for creating
the view and rules.
Overtime, if I need to change my view or reconfigure the rules, I can edit
my sql file a
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr <[EMAIL
PROTECTED]> wrote:
>
> Either way. I like to create sql files with all of the DDL for creating
> the view and rules.
> Overtime, if I need to change my view or reconfigure the rules, I can edit
> my sql file and then
> cal
> So, herein probably lies my problem with the "Cannont insert into a view"
> error I'm getting anytime I'm attempting to access it from my program -
> there are no rules set up for them, right?
Correct, without insert rules you will not be able to add new records to the
underlying tables of
a v
[EMAIL PROTECTED] wrote:
> On Thursday 11 January 2007 12:34, Richard Huxton wrote:
>
>>> The query would run much faster with the filter reordered.
>>> Is there a way to tell the planner/optimizer that certain functions are
>>> more expensive than others, and should be postponed in lazy evaluatio
Once again, thanks for the help.
OK, so I did the Adam's suggestion: SELECT * FROM pg_rules
and got the following returned:
apt=# select * from pg_rules;
schemaname | tablename | rulename|
definition
+-+---+---
Rafal Pietrak wrote:
> Hi!
>
> I'm re-posting this message again in hope someone would have a look at
> the case again. .. it's pending.
You were given a solution; defer the foreign key constraint.
Alternatively, you may want to re-think your trigger function so that it
does things in the rig
On Thu, Jan 11, 2007 at 01:01:24PM +0100, Rafal Pietrak wrote:
> Hi!
>
> I'm re-posting this message again in hope someone would have a look at
> the case again. .. it's pending.
Well, I can't help with the details because I can't see what you're
trying to do, but I'm fairly sure you can't cha
How about this?
select item, very_expensive_function(item) as exp, cheap
from ( Select item, cheap_function(item) as cheap
From atable where cheap_function(item) > 0 ) sub
where very_expensive_function(item) > 0
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTEC
On Thu, Jan 11, 2007 at 12:37:32PM +0100, Alexander Farber wrote:
> May I ask you an off-topic question? I've read several
> docs on Unicode, but they are difficult to understand.
Have you read the Unicode FAQ?
http://www.cl.cam.ac.uk/~mgk25/unicode.html
> Do you think that an UTF8 string will e
On Thursday 11 January 2007 12:34, Richard Huxton wrote:
> > The query would run much faster with the filter reordered.
> > Is there a way to tell the planner/optimizer that certain functions are
> > more expensive than others, and should be postponed in lazy evaluation ?
> > Or is there a hook in
Hi!
I'm re-posting this message again in hope someone would have a look at
the case again. .. it's pending.
In postgres v7.2 I had a trigger function launched BEFORE INSERT, which
did everything I needed (like an UPDATE of other table inside of that
trigger function, and adjustment of the INSE
Hi Martijn,
On 1/11/07, Martijn van Oosterhout wrote:
If you need the string in UTF-8, why not just set the "client_encoding"
to "utf8" and then the server will only send you strings in utf8, not
conversion necessary.
actually you are right, because I need all my data in UTF8 anyway
(for a we
[EMAIL PROTECTED] wrote:
Now the query:
select item from aview where exp > 0 and cheap > 0;
will lead to a sequential scan on atable with filter:
very_expensive_function(item) > 0 and cheap_function(item) > 0
The query would run much faster with the filter reordered.
Is there a way to tell the
km wrote:
> I would like to know if there is a way to pass an argument to
> ./configure to consider compiling with a specific python version ?
configure PYTHON=/usr/bin/python2.5
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
> >
> >I would like to know if there is a way to pass an argument to ./configure
> >to consider compiling with a specific python version ? coz i have many
> >python versions in the system .I presume that configure would check for
> >the /usr/bin/python alone, but what if i want /usr/bin/python2.
Hello,
Given a table:
create table atable (
item integer;
);
and a view:
create view aview as select
item,
very_expensive_function(item) as exp,
cheap_function(item) as cheap
from atable;
Now the query:
select item from aview where exp > 0 and cheap > 0;
will lead to a sequential scan on
On Thu, Jan 11, 2007 at 11:46:17AM +0100, Andy Dale wrote:
> If the stats collector is 'lossy ' i will not be able to use it, can anyone
> confirm that it is ? So maybe my best option is to write a simple trigger
> that just increments a counter (value in a separate table) after an
> insert/update/
Sorry for being stupid, you can select the table info from the pg_class
table, so i can ignore the information schema.
If the stats collector is 'lossy ' i will not be able to use it, can anyone
confirm that it is ? So maybe my best option is to write a simple trigger
that just increments a count
On Thu, Jan 11, 2007 at 10:19:38AM +0100, Alexander Farber wrote:
> Hello PostgreSQL users!
>
> I have this data stored in WIN1251 encoding, which
> is being fetched by a libpq application I'm developing:
> phpbb=> select username, length(username), length(convert(username
> using windows_1251_
Besides writing a script that looks through the DDL of all tables, and
CLUSTERs all tables with PK constraints, is there a quicker way?
Thanks.
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Andy Dale wrote:
Hi,
I turned on the stats_row_level in the postgresql.conf file and now the the
calls to the stats functions work. I want to get the inserted, updated,
and
deleted numbers on a given database, so i have written a query to do so:
SELECT
sum(pg_stat_get_tuples_inserted(c.oi
Hi,
I turned on the stats_row_level in the postgresql.conf file and now the the
calls to the stats functions work. I want to get the inserted, updated, and
deleted numbers on a given database, so i have written a query to do so:
SELECT
sum(pg_stat_get_tuples_inserted(c.oid)) AS inserted,
km wrote:
Hi,
I would like to know if there is a way to pass an argument to ./configure
to consider compiling with a specific python version ? coz i have many python versions in the system .I presume that configure would check for the /usr/bin/python alone, but what if i want /usr/bin/python2.5
dcrespo wrote:
Good question. The only concern that I have is the date of the last
version (2005-3-7).
You will find that their website has not been updated for a while. If
you look in pgfoundry you will find that they have releases as recent as
a few days ago.
The different 1.x versions rel
And additional question please:
Can I still be sure that the data returned in the
convert(username using windows_1251_to_utf8)
column will be 0-terminated or should I fetch
the data length using PQgetlength and maintain
that value in my C-program?
Thank you
Alex
On 1/11/07, Alexander Farber <[E
Hello PostgreSQL users!
I have this data stored in WIN1251 encoding, which
is being fetched by a libpq application I'm developing:
phpbb=> show client_encoding;
-
WIN1251
(1 row)
phpbb=> \d phpbb_users;
username | character varying(25) | not null default '
Thank You Guys,
For your valuable suggestions.
Out of the suggestion to investigate in to PG_depane
was cumbersome , yes there is a view in information
schema called
information_schema.referential_constraints which gives
same details in terms of foreign keys and primary keys
and is usefull if u ha
Tomas Lanczos napisał(a):
Thanks. No complications due the move to the higher version (8.2)?
Tomas
Per usual remarks about upgrading found in installation instructions of
every release, you will need to use pg_dump that comes with the new
version to connect to the old database and run your
100 matches
Mail list logo
