Matthew T. O'Connor schrieb:
Well, to answer my own question, I hacked the source code of DBMail and
had it set the client encoding to LATIN1 immediately after database
connect, this seems to have fixed the problem.
You could also just have set the client_encoding as an user-option
in postgr
Well, to answer my own question, I hacked the source code of DBMail and
had it set the client encoding to LATIN1 immediately after database
connect, this seems to have fixed the problem.
Sorry for the noise,
Matt
Matthew T. O'Connor wrote:
I'm using DBMail running against PostgreSQL as my m
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:
2006-0
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
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 name
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
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
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 /
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 libpq.
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 speculat
Martijn van Oosterhout 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 from any front
On 6/7/06, Martijn van Oosterhout 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 alone acceptance are p
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
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.
--
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
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
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 thoug
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
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, ev
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
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 self
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 n
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:
> 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
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
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 the
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 wrote:
> >
> > Patch applied to CVS HEAD
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 y
If it was commited to HEAD, it will appear in 8.1.5, right?
On 5/30/06, Bruce Momjian wrote:
Patch applied to CVS HEAD and 8.1.X. Thanks.
---
Marko Kreen wrote:
> On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
> > O
"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 doe
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
"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.
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
"[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 i
> 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 databa
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
> arra
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 testb
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
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 rech
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
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
I’m researching and learning.
What characteristics of data sets lend themselves to
reasonable user-defined data types? Are there characteristic
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 (http://druid.sourceforge.
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 D
> 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
--
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 me
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 postg
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
tha
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
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 I’m
researching and learning.
What characteristics of data sets lend themselves to
reasonable user-defined data types? Are there characteristic
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
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 f
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 sa
(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 fo
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
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
+-+-
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 fa
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, gettin
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
+--+
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 follo
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 s
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
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 c
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 s
63 matches
Mail list logo
