Thanks for putting me straight - I thought I remembered a previous post
from Tom about nulls not being indexed but it was probably referring to
partial indexes not indexing values that are null...
Coalescing null values might still be helpful to ensure that they are
ordered in the index at a
Alexander Scholz wrote:
Yes, we have the same problem! Refer to the thread with the subject
Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore.
They seem to have change the old behaviour of the commandline tools,
which worked well since 8.0! I don't understand why the
Is there a data type for ean codes for postgresql 7.4? I found the isbn
data type, and I would appreciate something similar for ean codes.
Thank you
signature.asc
Description: OpenPGP digital signature
On Tue, Jun 06, 2006 at 09:05:30PM -0300, Rodrigo Gonzalez wrote:
I dont know the answer to your question, but I think that you forgot
somethingmost linux distributions have postgresql included.so,
(I dont know the number) some people that use it, didnt download from
postgresql site
Hi,
My requirement is to archive records from main DB to the archive DB after
certain period. Using Dblink facility, I'm able to perform any kind of activity
on the archive DB, except copying from Table of MainDb to a Table of ArchiveDb.
Is it possible to move the selective records using
I dont succeed with writing my rules proper.
I need the following rules:
when I INSERT/UPDATE to a table and a certain condition is true then a
special field in this data-row should be updated to.
I came as far:
# \d testa
Table public.testa
Column | Type | Modifiers
i have a cloumn in my table which is date type
i parse a file to get the date from
there,
and then i form a call to the stored procedure,
with the above data as the parameter.
but however it seems that when i form this call,
something is messing up, and the value for the birth date, getting
am 07.06.2006, um 13:23:09 +0200 mailte peter pilsl folgendes:
I dont succeed with writing my rules proper.
I need the following rules:
when I INSERT/UPDATE to a table and a certain condition is true then a
special field in this data-row should be updated to.
I came as far:
#
If short: adding index to table change execution plans on query which dont
use new index.
More detailed info:
tv2=# \d tv_events
Table public.tv_events
Column |Type |
Modifiers
On 6/7/06, Ottavio Campana [EMAIL PROTECTED] wrote:
Is there a data type for ean codes for postgresql 7.4? I found the isbn
data type, and I would appreciate something similar for ean codes.
If there isn't you can create your own:
http://www.postgresql.org/docs/8.1/static/sql-createtype.html
(group dupe)
05 Jun 2006 12:53:57 -0400, Greg Stark [EMAIL PROTECTED]:
But the closest partial solution suggested so far is the pg_xfrm function that
has been implemented and posted at least three times by three different
posters to the postgres mailing lists. In the interest of avoiding a
Bjørn T Johansen wrote:
Have you tried Druid (http://druid.sourceforge.net/index.html) ?
It does anything a good ERD designer do and it's free...
Thanks Bjorn. I have downloaded it but not tested it yet. I will test
it in the next few days. DIA doesn't seem like a good choice.
Did somebody say
Hi..
Im Daniel and need soem help in importing data from MS SQL Server
to Postgresql DB. Is there a bulit in option for importing from
Postgresql? Help me out!!
Regards,
Daniel.
---(end of broadcast)---
TIP 5: don't forget to increase your
What about OpenOffice Draw 2.0? Can this do ER / UML diagrams that one
can then use to forward engineer DDL statements?
How does DIA compare to Draw, and wouldn't it be better to roll DIA
into OpenOffice? I love OpenOffice and use it as an MS Word / MS Excel
replacement. Works great, since it can
List,
This is a general question for my own education. Something I
read earlier today triggered some ideas in my head, and out of curiosity Im
researching and learning.
What characteristics of data sets lend themselves to
reasonable user-defined data types? Are there characteristics
I'm trying to make sense of Section 22.1.3 (Preventing transaction ID
wraparound failures) in the on-line docs to make sure the DB's
autovacuum settings are adequate and are having an effect.
The docs state:
The age column measures the number of transactions from the cutoff
XID to the current
Hi all,
this is my first time posting here because I've been running pgsql without
problem on a couple of Linux boxes for a while now.
I'm migrating to a new MacBook, and while I finally got it to compile, initdb,
and start a postmaster, any time I try createdb or createuser, I get a message
Hello all.
I am brand new to creating my own data types in postgres. I first created a
type called indices, containing two integers. Now, I want to create
another type, called progress, which should contain one timestamp and an
array of indices. However, I cannot figure out how to get postgres
Hi, it's possible to read the list of the tables modified during the transaction? -- __Claudio Tognolo
[EMAIL PROTECTED]www.claudio.tognolo.nameL'informatica è come la fisica. La differenza è che
Hi..
Im Daniel and need soem help in importing data from MS
SQL Server to Postgresql DB. Is there a bulit in option for
importing from Postgresql? Help me out!!
You can easily use the DTS tool in SQL Server to export data to
PostgreSQL through the ODBC driver.
//Magnus
You can use the DTS of SQL Server and there use the ODBC driver for PostgreSQL for making a connection to the target PostgreSQL database./ShoaibOn 7 Jun 2006 05:13:15 -0700,
Daniel [EMAIL PROTECTED] wrote:
Hi..Im Daniel and need soem help in importing data from MS SQL Serverto Postgresql DB. Is
Take a look at http://www.databaseanswers.com/modelling_tools.htm
I have used Case Studio 2 (fine, weak on documentation generation), and
PowerDesigner by Sybase (truly excellent! but $$$)
John
[EMAIL PROTECTED] wrote:
Bjørn T Johansen wrote:
Have you tried Druid
List,
This is a general question for my own education. Something I
read earlier today triggered some ideas in my head, and out of curiosity
Im researching and learning.
What characteristics of data sets lend themselves to
reasonable user-defined data types? Are there characteristics
On Wednesday 7. June 2006 06:26, Robert Treat wrote:
On Tuesday 06 June 2006 18:44, Leif B. Kristensen wrote:
The reason why the generation of eg. the family sheet is faster in
the MySQL web context than in my production environment, is that I'm
really comparing apples and potatoes here. The
Hi Jonathon,
does the following command succeed?
# psql template1 -c CREATE DATABASE test;
The database 'postgres' is a system table which has been added in 8.2
(or 8.1 already, dunno). It should exist if you used the correct initdb
and postmaster.
What does psql -l say?
And did you
Our software will be using PostGreSQL as a database. Now I was wondering, if
the database is installed on lets say an entry level Celeron, with 256MB of
Ram, will it slow down the PC at all?
I'm not taking any queries into account here, just generally, does
installing the database slow down ones
May be this is not a full explanation, but at least a recepiet, that
works for me:
CREATE TABLE testa (x1 text, x2 text);
CREATE VIEW testb AS SELECT * from testa;
CREATE RULE r0 AS ON INSERT TO testb DO INSTEAD INSERT INTO testa
(x1,x2) VALUES (new.x1,new.x2);
CREATE RULE r1 AS ON INSERT TO
On Tue, Jun 06, 2006 at 11:40:05AM -0600, Jessica M Salmon wrote:
I am brand new to creating my own data types in postgres. I first created a
type called indices, containing two integers. Now, I want to create
another type, called progress, which should contain one timestamp and an
array of
Our software will be using PostGreSQL as a database. Now I
was wondering, if the database is installed on lets say an
entry level Celeron, with 256MB of Ram, will it slow down the
PC at all?
I'm not taking any queries into account here, just generally,
does installing the database
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
I'm trying to make sense of Section 22.1.3 (Preventing transaction ID
wraparound failures) in the on-line docs to make sure the DB's
autovacuum settings are adequate and are having an effect.
...
I don't see numbers larger than 1 billion in my
Jonathon McKitrick [EMAIL PROTECTED] writes:
I'm migrating to a new MacBook, and while I finally got it to compile, initdb,
and start a postmaster, any time I try createdb or createuser, I get a message
that the database 'postgres' cannot be found.
It sounds to me like you're trying to use PG
Claudio Tognolo [EMAIL PROTECTED] writes:
it's possible to read the list of the tables modified during the
transaction?
No, because there is no such list.
Depending on what you want to do, looking at your own transaction's
locks in pg_locks might be a workable substitute.
Daniel wrote:
Hi..
Im Daniel and need soem help in importing data from MS SQL Server
to Postgresql DB. Is there a bulit in option for importing from
Postgresql? Help me out!!
Regards,
Daniel.
---(end of broadcast)---
TIP 5: don't forget to
Tim Hart [EMAIL PROTECTED] writes:
I've reviewed the PostgreSQL documentation on user defined data types. It
seems that data types that can't be ordered or compared for equality would
be bad candidates. After all, if a data type can't be indexed or used in a
where clause, what value does a
If it was commited to HEAD, it will appear in 8.1.5, right?
On 5/30/06, Bruce Momjian pgman@candle.pha.pa.us wrote:
Patch applied to CVS HEAD and 8.1.X. Thanks.
---
Marko Kreen wrote:
On 5/9/06, Joe Kramer [EMAIL
Boguk Maxim [EMAIL PROTECTED] writes:
If short: adding index to table change execution plans on query which dont
use new index.
Exactly which PG version is this?
regards, tom lane
---(end of broadcast)---
TIP 3: Have you
HEAD only appears in 8.2, but 8.1.X means it will appear in 8.1.5.
---
Joe Kramer wrote:
If it was commited to HEAD, it will appear in 8.1.5, right?
On 5/30/06, Bruce Momjian pgman@candle.pha.pa.us wrote:
Patch
Hello list,
I upgraded to postgres-8.1.4 and saw all of the backslash escape changes
and understand why, but I can't figure out how to put a literal \' in
the database. If \ is no longer escaping shouldn't I be able to use \”
and have postgres ignore the \ and use standard sql syntax to escape
On 7 Jun 2006 05:13:15 -0700, Daniel [EMAIL PROTECTED] wrote:
Hi..
Im Daniel and need soem help in importing data from MS SQL Server
to Postgresql DB. Is there a bulit in option for importing from
Postgresql? Help me out!!
as others suggest, you definately want to go 'dts' on anything
Matthew Schumacher [EMAIL PROTECTED] writes:
I upgraded to postgres-8.1.4 and saw all of the backslash escape changes
and understand why, but I can't figure out how to put a literal \' in
the database.
You use the SQL-standard way, which is to repeat the quote mark:
'Meet at Joe''s
Tom Lane wrote:
Matthew Schumacher [EMAIL PROTECTED] writes:
I upgraded to postgres-8.1.4 and saw all of the backslash escape changes
and understand why, but I can't figure out how to put a literal \' in
the database.
You use the SQL-standard way, which is to repeat the quote mark:
Matthew Schumacher [EMAIL PROTECTED] writes:
Thanks for the reply Tom, however I don't think you understand my issue.
I'm not using addslashes and I am using the SQL standard way to
escape a single quote. The problem is that I want to put a literal \'
inside the database. So if \ is no
Hi Jonathon,
Jonathon McKitrick wrote:
: # psql template1 -c CREATE DATABASE test;
CREATE DATABASE
is the result.
Looks good. Can you connect to that database then?
: What does psql -l say?
FATAL: database 'postgres' does not exist
As Tom said: check if you are really calling you
Could custom types benefit significantly from custom operators as well? Do
custom C functions stand a good chance of introducing speed benefits over
their raw SQL or pl/sql counterparts? Or is the field too broad to speculate
on the general case?
The scenario that inspired this question was about
Boguk Maxim [EMAIL PROTECTED] writes:
If short: adding index to table change execution plans on query which dont
use new index.
After some experimentation I was able to create a similar misbehavior
here. I think what is happening is that the added index is capturing
the bitmap scan plan, even
On Wed, May 31, 2006 at 10:50:46AM -0400, Charles Comiskey wrote:
PostgreSQL 8.1.4 appears to have 2 GPL licensed files according to
licenses embedded in the source. In both cases, the files have had a
I should like to point out (in addition to Peter E's comments) that
these are both files
Andrew Sullivan [EMAIL PROTECTED] writes:
At the same time, it strikes me that at least the userlock stuff, and
maybe dbmirror as well, are candidates for pgfoundry rather than
contrib/
We'd already agreed to move dbmirror to pgfoundry, but it just didn't
get done for 8.1. I had not thought
Tom Lane wrote:
Andrew Sullivan [EMAIL PROTECTED] writes:
At the same time, it strikes me that at least the userlock stuff, and
maybe dbmirror as well, are candidates for pgfoundry rather than
contrib/
We'd already agreed to move dbmirror to pgfoundry, but it just didn't
get done for
PGLA now works great on Linux with WINE!!!
I tested with the latest version of wine 0.9.14 and Ubuntu 6.06.
Before today PGLA sort of worked on WINE, it would get AV in several
locations and would raise a AV when closing.
I am happy to say these AVs have been eliminated. I did some debugging
In version 7.4, could someone please tell me the start and end points
are for measuring the execution time of a query when log_duration is
enabled? I need to know exactly what gets measured in this time.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
On Wed, Jun 07, 2006 at 12:40:49AM +0400, Nikolay Samokhvalov wrote:
I were looking forward to this feature... So many troubles in my
projects would be vanished...
What is 'lack of interest'? Interest from community, or major
developers, or your personal one?
Kind of all three, feeding off
On 6/7/06, Martijn van Oosterhout kleptog@svana.org wrote:
Kind of all three, feeding off eachother. There's just not enough
interest from any front to really get it moving. It's a fairly invasive
change and without significant support and interest from somewhere,
chances of completion let
Martijn van Oosterhout kleptog@svana.org writes:
On Wed, Jun 07, 2006 at 12:40:49AM +0400, Nikolay Samokhvalov wrote:
What is 'lack of interest'? Interest from community, or major
developers, or your personal one?
Kind of all three, feeding off eachother. There's just not enough
interest
On Wed, Jun 07, 2006 at 12:57:15PM -0500, Tim Hart wrote:
Could custom types benefit significantly from custom operators as
well?
Yes.
Do custom C functions stand a good chance of introducing speed
benefits over their raw SQL or pl/sql counterparts? Or is the field
too broad to speculate on
Newbie here .. RH EL4 Apache 2.0.48
Apologies if this isn't the right place for this post!
Trying to get PHP5 support running in PG 8.1.4 and regardless that I
have postgresql-libs-8.1.4-1PGDG.i686.rpm loaded and freshened on the
machine, when I try to bring up httpd, it complains that
Hi All,
Can you help a colleague? [EMAIL PROTECTED]
He is looking for the following:-
Okay here goes with a v brief requirement:
+ A web based rewards management system (a points scheme like
mypoints, ipoints, rpoints),
+ Versatile content management system + community,
+ CRMS / email
bob gmx wrote:
Hi All,
Can you help a colleague?
There is something called a search engine which would help you with this.
--
Postgresql php tutorials
http://www.designmagick.com/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Dave Felt [EMAIL PROTECTED] writes:
Trying to get PHP5 support running in PG 8.1.4 and regardless that I
have postgresql-libs-8.1.4-1PGDG.i686.rpm loaded and freshened on the
machine, when I try to bring up httpd, it complains that libpq.so.4
isn't loaded.
libpq.so.4 definitely is in that
One thing I have noticed with my install (may be something carrying over
from an old version or howto I followed way back) is that the main user is
pgsql but the default db is postgres I find I need to use
#psql -U pgsql -d postgres
By default psql tries to connect to the database of the same
surabhi.ahuja wrote:
i have a cloumn in my table which is date type
i parse a file to get the date from there,
and then i form a call to the stored procedure, with the above data as
the parameter.
but however it seems that when i form this call, something is messing
up, and the value for
I'm using DBMail running against PostgreSQL as my mailstore for our
company network. I recently converted our company database from
SQL_ASCII to UTF8 as I thought this would be a *good thing*.
The problem now is that I think I'm loosing emails because in my
postgresql logs I get this:
61 matches
Mail list logo