On Aug 4, 2005, at 2:39 PM, [EMAIL PROTECTED] wrote:Both dig and nslookup are fast on all machines. 'psql' is fast on all machines, as long as I am using the version compiled with version 7.2. It is only 'psql' compiled with version 8.0 that is slow. I don't think DNS is the problem, but rather
Hi All,
Sorry to bring up the topic of PostgreSQL inheritance again, but
after going through the archives and Google results, I still don't
have a clear sense of whether my plan to implement a schema I'm
working on is the preferred way to go.
First, I'd like to find out if the way I'm thi
Not a free utility, but a good one:
http://www.datanamic.com/dezign/index.html
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
mes
Hy,
I'm using a type defined by me: output_mt, on the
function
CREATE OR REPLACE FUNCTION happy()
RETURNS SETOF output_mt AS
and when I want to initialize from another
function:
CREATE OR REPLACE FUNCTION msg() RETURNS
output_mt AS
as: output_mt=msg();
it gaves me:
WARNING: plpgs
[EMAIL PROTECTED] wrote:
Hi all,
I am sorry for a stupid easy question, but I'am PostgreSQL novice.
Our development team has encountered problem with trying to install and
maintain cluster (pgcluster) on our production database. So they have
decided to switch the entire solution to MySql datab
To anyone who tried before, the link is fixed.
http://www.metatrontech.com/wpapers/mysql2postgresql.pdf
Chris Travers wrote:
Hi;
I have just posted a MySQL to PostgreSQL migration guide at
http://www.metatrontech.com/wpapers and it is free for pretty much
any use (I do have a somewhat tone
I'd like to do something like this:
select array_explode(array_col) from table1 where col2 = 'something';
where array_explode returns the elements of array_col unpacked onto
separate rows.
I tried creating a function returning a setof type, but postgresql
produces a "set-valued function call
Hey Roman,
Thanks for your reponse's!
I made it happen in MicrosoftSQL using the first code below. The only
difference is I had to create variables. Which I'm having a hard time
trying to replicate it in psql.
__Microsoft Code___
USE test
GO
DECLARE @qty INT, @Length varchar(20
Christopher Kings-Lynne wrote:
PDF not found?
Argh Ok. Fixed.
It is about 12 pages. Table of contents entries are clickable. I am
not familiar enough with Docbook so I just wrote it in LaTeX (sources
available upon request).
Direct link is http://www.metatrontech.com/wpapers/mysql
I want to use postgres with python but I can't seem to get it working.
If I read things correctly I need python installed then I need postgres
installed. I did both on my Sun Solaris Opteron AMD 64 (Mandrake 10.1
os) using the --enable-shared and --with-python options. Both came back
with re
Hi,
I'd like to run some scripts against a postgres database but has more
than just standard SQL commands. I'd like to be able to use conditional
statements (i.e. if .. .then ... ) and such. I had a look and can see
that I could use pgplsql for this. However it seems that it must be part
of a
Hi all.
I want to install pg with readline. ./configure told me I have no
readline. I downloaded it and installed it, but ./configure still
outputing there is no readline. How can I solve it?
Thx! Bye!
---(end of broadcast)---
TIP 6: explain analy
Ou company just migrated in the opposite direction. We moved from
MySQL 4.1 to PostgreSQL 8. We had serious issues with MySQL and
foreign key support as well as data validation. For example: MySQL
will simply insert an empty string value for a required field that was
not supplied. We also incre
Dr NoName wrote:
Hi all,
I got another problem with postgres. This time it
refuses to use the indexes. Check this out:
If you would like help, first try posting queries and EXPLAIN ANALYZE dumps.
Also you may have better luck with the Performance list
([EMAIL PROTECTED]).
Best Wishes,
Chr
I'm sorry, but I know only the basics about DBMs, but I think is not
possible to put a image file INSIDE a database. You can put in a
database the path of the file...
(Maybe I'm wrong...)
See ya!
---(end of broadcast)---
TIP 3: Have you checked ou
Thanks Roman for sticking with me on this!
For whatever reason I cannot load another langage, I think it has to do
with recompiling the program and installing all the options. Not sure
though?? LANGUAGE plpgsql doesn't exist for me.
I still find this cursor limitation wacked. I find it hard to
On Aug 2, 2005, at 8:16 AM, Alvaro Herrera wrote:On Tue, Aug 02, 2005 at 10:01:50AM -0500, Dan Armbrust wrote: I shouldn't have to manually run Analyze to make the DB be capable of handling inserts involving tables with foreign keys correctly. My code that is doing the inserts is a java applicatio
CSN wrote:
Convenience! I want the email sent whether the member
is added via the web interface, directly in the
database, from the command line, etc. I don't see any
downside. It's only one user that'll be using this
function.
Well, there are three issues with doing complex things like se
Hello,
Forgive me if this is a dopey question. I'm running a web app with a
dB that takes me a half hour to regenerate. Instead of closing down
every day, I'd like insert the data into a temp table "stuff_tmp" and
then rename that to the permanent table "stuff", so the application is
not off-lin
On Thu, 4 Aug 2005, Piotr wrote:
> Hi,
> Im lookig for tool to regulary transfer data from dbf files into pgsql.
> Would be excellent if the tool would have data tranformation
> possibility.
>
A simplistic approach but workable would be to use the dbfinfo/dbfdump
programs which are part of the
Hello Sir,
I am using PostGreSql ,I want an oledb provider for the
postgre in order to connect through.net to a postgre Database, I installed the
pgoledb.dll and I registered it and in the connection string I am using the “Provider=PostgreSQL.1
. . . ,but the following error is occurring
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm getting this message when I try to access one of the databases in
my cluster:
FATAL: cache lookup failed for access method 6881280
I get the message any way I try to access it: remotely via TCP,
locally on the db server, as well as with a single
Hi Team Members,
Is it possible to write jobs in postgresql & if
possible how should I write .please help me.
Cheers,
---
Chiranjeevi Illa
Member - Software Development Team
PyroNetworks Pvt Ltd.,
I have asked my internet host to include postgresql as part of their
service but it seems that there are issues in getting it to work with
"cpanel" which is their support service for their clients. Is their a
reason why Postgresql is harder to host than mysql? Is their any docs I
can point the
On Thursday 04 August 2005 01:42 am, Piotr wrote:
You might to take a look at the following.
http://www.klaban.torun.pl/prog/pg2xbase/
> Hi,
> Im lookig for tool to regulary transfer data from dbf files into pgsql.
> Would be excellent if the tool would have data tranformation
> possibility.
>
> re
On Thu, Aug 04, 2005 at 06:29:46PM -0600, Michael Fuhr wrote:
> Anybody know if queries can be disabled in Linux? Lowell, if
> nobody answers here then you might need to seek help in a different
> forum. Or you could just hack the code and change AF_UNSPEC to
> AF_INET ;-)
Lowell, aside fro
On Thu, Aug 04, 2005 at 04:30:52PM -0600, Michael Fuhr wrote:
> The response to 7.2 has an ANCOUNT (number of records in the answer
> section) of 1 and an NSCOUNT (number of records in the authority
> section) of 2, whereas the response to 8.0 has an ANCOUNT of 0 and
> an NSCOUNT of 1. That dispar
On Thu, 4 Aug 2005, Michael Fuhr wrote:
On Thu, Aug 04, 2005 at 03:03:47PM -0700, Frank Miles wrote:
I have a python-based application which provides a user interface
to a Postgresql database. The latest version of the application suddenly
lost the inability to insert new data in some
On Thu, Aug 04, 2005 at 03:03:47PM -0700, Frank Miles wrote:
> I have a python-based application which provides a user interface
> to a Postgresql database. The latest version of the application suddenly
> lost the inability to insert new data in some of the tables. The SQL
> statement(s) u
On 8/4/05, Frank Miles <[EMAIL PROTECTED]> wrote:
> Hi everyone...
>
>I have a python-based application which provides a user interface
> to a Postgresql database. The latest version of the application suddenly
> lost the inability to insert new data in some of the tables. The SQL
> stat
On Thu, Aug 04, 2005 at 04:39:02PM -0500, [EMAIL PROTECTED] wrote:
> The difference must have to do with the functions that differ in the
> different versions of psql. In looking through the code for version 8.0
> in the file /interfaces/libpq/ip.c, the function that resolves hostname is
> "get
On Thu, Aug 04, 2005 at 04:01:43PM -0500, [EMAIL PROTECTED] wrote:
> I also performed the trace you suggested. The results are the same until
> this point, where the time for
> version 8.0 totals 0.025960 and for
> version 7.2 totals 0.009481
Those differences probably don't matter, but what co
Hi everyone...
I have a python-based application which provides a user interface
to a Postgresql database. The latest version of the application suddenly
lost the inability to insert new data in some of the tables. The SQL
statement(s) used still work if manually typed in psql, but it a
Your assessment is correct ... the
same version of
psql behaves the same on different machines, and different
versions of psql behave differently on the same machine.
The difference must have to do with
the functions that differ in the different versions of psql. In looking
through the code for
Both dig and nslookup are fast on all
machines. 'psql' is fast on all machines, as long as I am using the
version compiled with version 7.2. It is only 'psql' compiled with
version 8.0 that is slow. I don't think DNS is the problem, but rather
the way psql in version 8.0 attempts to get the DNS
nslookup isn't the easiest tool for use in diagnosing dns problems
as it goes through the whole messy nsswitch process, and doesn't
readily isolate much of anything.
the dig command focuses on dns only, skips nsswitch altogether,
and lets you rule dns problems in or out in one swell foop. if
dig i
Sorry to re-reply, but I had a much simpler idea. From the client machine
that is slow to connect, type the command "nslookup hostname1". If it
takes 15 seconds. If it does, DNS is the problem.
Rick
[EMAIL PROTECTED] wrote on 08/04/2005 03:01:31 PM:
> I'd start by comparing the /etc/nsswitch.
On Thu, Aug 04, 2005 at 03:01:31PM -0500, [EMAIL PROTECTED] wrote:
> I'd start by comparing the /etc/nsswitch.conf files on the various
> machines. If the second column contains "files" for passwd and hosts on
> the fast machines, and "dns" on the slow machine, then change the slow
> machine to "f
I'd start by comparing the /etc/nsswitch.conf files on the various
machines. If the second column contains "files" for passwd and hosts on
the fast machines, and "dns" on the slow machine, then change the slow
machine to "files" and see if it speeds up. That's an easy way to rule out
or condemn D
On Thu, Aug 04, 2005 at 12:04:27PM -0500, [EMAIL PROTECTED] wrote:
> Version 7.2 psql - /usr/bin/psql -d dbname -h machine1
> connection time instant
> Version 8.0 psql - /usr/local/pgsql/bin/psql -d dbname -h machine1
> conection time 15 seconds
> Version 8.0 psql - /usr/local/p
On 8/4/05 2:26 PM, "Andrew Stewart" <[EMAIL PROTECTED]> wrote:
> I'm sorry, I'm sure I should be asking this someplace more general, but
> apparantly the word 'port' is used in so many different contexts that a
> google search turns up fruitless ;)
>
> I'm just trying to access a remote postgresq
[EMAIL PROTECTED] wrote:
First, makes sure the PostgreSQL database is listening for TCP/IP
connections on the computer you're trying to connect to. On Mac OS X, run
this command in the a terminal, i.e. Terminal.app:
netstat -l
You should see a line like this somewhere in the output:
tcp6 0 0
First, makes sure the PostgreSQL database is listening for TCP/IP
connections on the computer you're trying to connect to. On Mac OS X, run
this command in the a terminal, i.e. Terminal.app:
netstat -l
You should see a line like this somewhere in the output:
tcp6 0 0 *.5432 *.* LISTEN
Second, t
What machine is remote? Linux? Solaris? or Mac? I couldn't tell if
the remote system or your workstation was a Mac.
I will assume the postgresql server is on a Mac, and that the Mac has
its firewall enabled. On my Mac, to open a firewall for something
like this, go to System Preferences, a
I'm just trying to access a remote postgresql database on port 5432,
which does not appear to be open on the remote computer. I'm on a
MacOSX and cannot figure out for the life of me how to open up this
port on the computer.
It's not clear what kind is the remote machine. Is it a Mac? If s
I'm sorry, I'm sure I should be asking this someplace more general, but
apparantly the word 'port' is used in so many different contexts that a
google search turns up fruitless ;)
I'm just trying to access a remote postgresql database on port 5432,
which does not appear to be open on the remot
Machine 1 is running version 8.0
Machine 2 is running version 7.2
Machine 3 has version 7.2 and version
8.0 installed, so both versions of "psql" are available for testing.
From machine 3 to machine 2
Version 7.2 psql - /usr/bin/psql
-d dbname -h machine2 connection time instant
Version
Just wanted to say thanks for all the great replies explaining why
Postgres does this.
Tony
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes
Hi there.
I am connecting to my Postgresql 7.4.7 sever with psql-odbc from my VB.NET
frontend. Right now I am using the Postgres server IP address in the odbc
connection string. My question, I want to use a DNS server, how will my
connection string change. Will I just specify the DNS address fo
On Thu, 2005-08-04 at 10:57, Benjamin Scherrey wrote:
> In Postgres 8, if a row attribute is defined as 'character varying'
> without specifying a size, what is its size limit? Is it a
> platform-specific/char encoding issue? Is this the same as declaring it
> a 'text' type? I don't find this sp
On Aug 4, 2005, at 8:13 AM, [EMAIL PROTECTED] wrote:I am changing from 7.2 to 8.0 and have both installed now on various Linux machines. When I use the psql command line interface with a -h hostname, the connection time from 7.2 is instant while the connection time from 8.0 is 15 seconds. My assu
On Thu, Aug 04, 2005 at 10:13:43AM -0500, [EMAIL PROTECTED] wrote:
> I am changing from 7.2 to 8.0 and have both installed now on various Linux
> machines. When I use the psql command line interface with a -h hostname,
> the connection time from 7.2 is instant while the connection time from 8.0
Am Donnerstag, den 04.08.2005, 10:13 -0500 schrieb
[EMAIL PROTECTED]:
>
> I am changing from 7.2 to 8.0 and have both installed now on various
> Linux machines. When I use the psql command line interface with a -h
> hostname, the connection time from 7.2 is instant while the connection
> time fro
In Postgres 8, if a row attribute is defined as 'character varying'
without specifying a size, what is its size limit? Is it a
platform-specific/char encoding issue? Is this the same as declaring it
a 'text' type? I don't find this specified in the documentation.
thanx & later,
Ben S
I am changing from 7.2 to 8.0 and have
both installed now on various Linux machines. When I use the psql
command line interface with a -h hostname, the connection time from 7.2
is instant while the connection time from 8.0 is 15 seconds. My assumption
is that 7.2 checks the /etc/hosts file first
On Thu, Aug 04, 2005 at 09:19:44AM -0500, Tony Caduto wrote:
> I just noticed this, if I do a update like this:
>
> update new_requests set name = 'tony' where request_id = 2
>
> If I do a select * from new_requests that record I just updated is now
> at the bottom , before the update it was at
On Thu, 2005-08-04 at 09:19 -0500, Tony Caduto wrote:
> Hi,
>
> I just noticed this, if I do a update like this:
>
> update new_requests set name = 'tony' where request_id = 2
>
> If I do a select * from new_requests that record I just updated is now
> at the bottom , before the update it was a
Tony Caduto <[EMAIL PROTECTED]> writes:
> Hi,
>
> I just noticed this, if I do a update like this:
>
> update new_requests set name = 'tony' where request_id = 2
>
> If I do a select * from new_requests that record I just updated is now
> at the bottom , before the update it was at the top?
>
> Wh
On Thu, Aug 04, 2005 at 09:19:44AM -0500, Tony Caduto wrote:
> Hi,
>
> I just noticed this, if I do a update like this:
>
> update new_requests set name = 'tony' where request_id = 2
>
> If I do a select * from new_requests that record I just updated is now
> at the bottom , before the update i
Joseph Shraibman writes:
> If I put the pg_xlog directory on its own disk, then that disk fails,
> does that mean the postgres is hosed or does it just mean that postgres
> no longer safe from a power outage?
The latter. The WAL is actually write-only during normal operation.
However you need
Hi,
I just noticed this, if I do a update like this:
update new_requests set name = 'tony' where request_id = 2
If I do a select * from new_requests that record I just updated is now
at the bottom , before the update it was at the top?
Why is Postgresql changing the ordering of the results a
Ok, may be the size/attachments in the mails. There is a restriction
on the size? because if I attach 2 files (80kb total) the mail don't
return from the list (without any warning), the only mail that arrives
was a mail with few chars.
I'll be watching on
http://archives.postgresql.org/pgsql-odbc/2
On Thu, Aug 04, 2005 at 12:03:03PM +0100, Oluwatope Akinniyi wrote:
> If I may ask, would it not be possible to add another advancement to the
> world's open source most advanced database. I wish we could make
> auditing semi-automatic. I was thinking of adding a parameter to CREATE
> TABLE command
Joseph Shraibman wrote:
If I put the pg_xlog directory on its own disk, then that disk fails,
does that mean the postgres is hosed or does it just mean that postgres
no longer safe from a power outage? Does pg detect a problem with the
wal and then call fsync() on the database files if wal isn
Tan Chen Yee wrote:
Hi,
I have backup a database in plain text format. I know I cannot use pgadmin
III to restore it.
What is other way to do the restoration ?
psql -f my_file ...
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP
Alejandro D. Burne wrote:
Hi, I'll be posting a lot of messages to [EMAIL PROTECTED]
without sucess. I try to unsuscribe/suscribe with the same results.
I'll be using this account.
Any clues? There is any restriction with gmail accounts? Thanks. Alejandro
At least one of your messages got throu
I must commend the efforts of the developers and users of PostgreSQL for
new innovations and development. Thank you for giving us such a
wonderful DB.
I really was impressed with the set of Trigger variables that make
internal workings of trigger accessible to users. Of note is an easier
way of pe
Hi,
Is there any easy way to explain analyze a query, which is inside an sql
stored procedure? I could of course copy the query out of the procedure, and
explain analyze it but this is a slower process. I would do this with a lot
of procedures, that's why it should be fast.
create function m
Hi, I'll be posting a lot of messages to [EMAIL PROTECTED]
without sucess. I try to unsuscribe/suscribe with the same results.
I'll be using this account.
Any clues? There is any restriction with gmail accounts? Thanks. Alejandro
---(end of broadcast)---
Peter,
There is a dbf2pg in the contrib library, I have tried to use it, but I had
some probems with it: I had a numeric field whose decimal length was 0.
Dbf2pg couldn't handle this situation, it said that it has an illegel number
format. So I had to generate manually a big convertion script,
Am Donnerstag, den 04.08.2005, 02:24 -0700 schrieb CSN:
>
> --- Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> > > Convenience! I want the email sent whether the
> > member
> > > is added via the web interface, directly in the
> > > database, from the command line, etc. I don't see
> > any
> >
> >
--- Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> > Convenience! I want the email sent whether the
> member
> > is added via the web interface, directly in the
> > database, from the command line, etc. I don't see
> any
>
> Well, I also do such things with a small script
> which
> basically LIST
Hi,
I have backup a database in plain text format. I know I cannot use pgadmin
III to restore it.
What is other way to do the restoration ?
Thanks !
TAn
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Am Donnerstag, den 04.08.2005, 01:35 -0700 schrieb CSN:
>
> --- Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> > > > > (The function uses mail(), so IIRC that
> > > > necessitates
> > > > > using plphpu).
> > > >
> > > > Sending mail from a database function (or doing
> > > > anything else that
> >
CSN wrote:
Why cant your application handle this?
Otoh, why dont you provide a function to send mail,
which takes some parameters and just let your users
use them? No need for everybody to write her own
mail function.
Convenience! I want the email sent whether the member
is added via the web i
You shoud run configure script in a root pgsql's source tree.
Supiah Mustaffa wrote:
Hi,
I want to install Tsearch2 and follow this command :
1.cd contrib/tsearch2
2. make; make install
It doesn't work and display this messages :
Makefile:5: ../../src/Makefile.global: No such file or director
Hi,
Im lookig for tool to regulary transfer data from dbf files into pgsql.
Would be excellent if the tool would have data tranformation
possibility.
regards
Peter
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
--- Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> > > > (The function uses mail(), so IIRC that
> > > necessitates
> > > > using plphpu).
> > >
> > > Sending mail from a database function (or doing
> > > anything else that
> > > involves external side-effects) is generally A
> Bad
> > > Idea, for
Am Mittwoch, den 03.08.2005, 21:29 -0700 schrieb CSN:
>
> --- Tom Lane <[EMAIL PROTECTED]> wrote:
>
> > CSN <[EMAIL PROTECTED]> writes:
> > > I'm using plphpu and I'd like to allow the regular
> > > database user to use it, but since it's
> > "untrusted" it
> > > requires users to be superusers.
79 matches
Mail list logo
