Hello !
I have to transfert data from MS-Access to
PostgreSQL 8.03 under Windows 2003 server.
Text fields may contain a carriage return
(CR-LF).
I use the copy instruction.
Under Pg-Admin III 1.21, I obtain an error message
for that carriage return and a hint : use \n.
If I use a filter on
Hello, Mike!
Your solution for audit trail is wonderfull! Easy and elegant !
It helped me a lot and I successfully implemented it, with small
modifications.
Thanky you very much!
- Original Message -
From: Mike Rylander [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc:
On Mon, May 30, 2005 at 07:33:04PM +1000, Philip Rhoades wrote:
People,
The following script works (I have confirmed it by doing two separate
views and doing a select on them) - but I don't understand why there
isn't a recursion problem with c1.policy and c2.policy - is there some
sort of
People,
The following script works (I have confirmed it by doing two separate
views and doing a select on them) - but I don't understand why there
isn't a recursion problem with c1.policy and c2.policy - is there some
sort of trick happening?
Thanks,
Phil.
SELECT c1.loc, c1.lob, c1.policy
Philip Rhoades wrote:
The following script works (I have confirmed it by doing two separate
views and doing a select on them) - but I don't understand why there
isn't a recursion problem with c1.policy and c2.policy - is there
some sort of trick happening?
The subquery is evaluated for each
Martijn,
On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote:
On Mon, May 30, 2005 at 07:33:04PM +1000, Philip Rhoades wrote:
People,
The following script works (I have confirmed it by doing two separate
views and doing a select on them) - but I don't understand why there
isn't
On Mon, May 30, 2005 at 08:32:15PM +1000, Philip Rhoades wrote:
Martijn,
On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote:
recursion problem ? It's called a correlated subquery. SQL is
declarative, you state what you want and the database figures out how
to get the answer for
Martijn,
On Mon, 2005-05-30 at 21:08, Martijn van Oosterhout wrote:
On Mon, May 30, 2005 at 08:32:15PM +1000, Philip Rhoades wrote:
Martijn,
On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote:
recursion problem ? It's called a correlated subquery. SQL is
declarative, you
I have a big problem to jump from 7.2 to 8.0.3
In my application I was doing a major use of int and float
And the difference between '0' and void NULL '' data content.
Now it seems to me that void is not allowed for an integer ?
What should I do ?
---(end of
On Mon, May 30, 2005 at 03:46:09PM +0200, Alexandre Lollini wrote:
I have a big problem to jump from 7.2 to 8.0.3
In my application I was doing a major use of int and float
And the difference between '0' and void NULL '' data content.
Now it seems to me that void is not allowed for an
Dear all,
I need some help to get postgres working under
windows.
I installed postgress using the .msi
I am able to start the pgadminiii and start the
database server with no problems.
Now I try to create a database as explained in the
documentation:
createdb mydb
The systems asks for a
Did you restart the service?
Did you change the postgresql.conf file to listen on tcp/ip all addresses?
listen_addresses = '*'
After that I made some changes to the pg_hba.conf file
and changed the method
hostall all 127.0.0.1/32 md5
INTO
hostall all
Tony,
I tried your suggestion but it is not helping me out.
Restarting the server is not helping either.
What I tried next is create the database in pgadminiii
and assign my userid as the owner.
But that is not working either. So I have run out of
options.
regards,
Danny
--- Tony Caduto
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I hope that you are well. Is anybody maintaining a Windows package for
the DBD::Pg driver for ActiveState Perl ? I don't have VC++ and bcc32
isn't going to compile based on the instructions for Win32.
There is an unofficial version you can try
Danny,
On May 30, 2005, at 10:13 AM, Danny Gaethofs wrote:
Now I try to create a database as explained in the
documentation:
createdb mydb
The systems asks for a password and when I enter the
password it comes back with:
could not connect to database template1: FATAL:
password
John,
The command you gave createdb.exe -h 127.0.0.1 -U
postgres mydb is working.
The system gives me the result CREATE DATABASE.
Looking into pgadminiii shows the database is created.
Doing the same with my user account is not working.
Thanks anyway it is making me understand postgres
Please reply to the list so everyone can follow the discussion:
On Mon, May 30, 2005 at 07:50:03PM +0200, Alexandre Lollini wrote:
Here is my query sample (exact):
snip
INSERT INTO sometable ( someint4field ) VALUES ( '' );
To work.
Sorry, an empty string is not an integer. If you want
Can someone in the community comment on this question? I don't know the
answer.
---
[EMAIL PROTECTED] wrote:
Hi, I was asking this question some time ago and was under impression
that this will be fixed in 8.x. In
Tom Lane wrote:
Has anyone bothered to actually look into the code?
regression=# select power(2::numeric,1000);
power
Bruce Momjian pgman@candle.pha.pa.us writes:
Can someone in the community comment on this question? I don't know the
answer.
I think it could be changed back without much work, but I have a feeling
that we'd deliberately decided on the change of behavior. Can anyone
recall a prior discussion,
Added to TODO:
* Prevent child tables from altering constraints like CHECK that were
inherited from the parent table
---
Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
Doing anything to
hi...
i have a postgres setup with an actual user. i can do a 'psql -Ugforge' and
give the password, and get into the app..
the problem i'm having is that i can't get into postrges as the default/root
user...
any ideas?
thanks
-bruce
[EMAIL PROTECTED]
---(end of
Hello,
I was not able to find any traces from the previous discussion trend,
but I believe that finished when I replaced GET DIAGNOSTIC with SELECT COUNT().
Perfectly fine workaround, but more I look at that more I see why GET
DIAGNOSTIC was so convenient not to mentioned that SELECT COUNT()
On Mon, 30 May 2005 21:47:43 +0300, Andrus wrote:
I installed Postgres 8 to Windows XP and added a line
hostall all 168.179.0.1/32 trust
I think you should probably make that 168.179.0.0/24 - the /32 means that
only the IP address 168.179.0.1 is covered by that
on 5/30/05 2:19 AM, [EMAIL PROTECTED] purportedly said:
I have to transfert data from MS-Access to PostgreSQL 8.03 under Windows 2003
server.
Text fields may contain a carriage return (CR-LF).
I use the copy instruction.
Under Pg-Admin III 1.21, I obtain an error message for that carriage
Ah, I didn't catch the fact that you where not doing it as the super
user (postgres)
For another account to work you need to grant that account the createdb
right.
Look up in the docs about the grant command.
Glad to hear you have it working.
Tony Caduto
http://www.amsoftwaredesign.com
Home
hi...
i've set up a postrges db, and i can get to it using a user/passwd. however,
when i su into the postgres user, and i try to do a 'psql -U postgres' it
prompts me for the password.. i have no idea what the password would be.. i
created everything, and thought i had just given it a blank
I found a discussion of this issue from December, 2004:
http://archives.postgresql.org/pgsql-general/2004-12/msg00070.php
The discussion trailed off with the idea that because no rows were
returned to the function, the row_count should be zero, but then there
was some discussion that
Alvaro Herrera wrote:
On Fri, May 20, 2005 at 01:03:08PM -0400, Tom Lane wrote:
Oh, and while at it, it would be nice to solve the modulo bug that still
lurks there:
alvherre=# select 12345678901234567890 % 123;
?column?
--
-45
(1 fila)
alvherre=# select
On Mon, May 30, 2005 at 11:29:48PM -0400, Bruce Momjian wrote:
test= select 12345678901234567890 / 123;
?column?
100371373180768845
(1 row)
Well, that's a bug, right?
--
Alvaro Herrera (alvherre[a]surnet.cl)
Industry suffers from
In my experience, there is no way to tell an embedded carriage return
from and end-of-record carriage return other than counting intervening
tabs.
What I do, is fix it in access with a query for (believe it or not)
* chr(13) *
which returns all records that contain a CR. I then just delete
Alvaro Herrera wrote:
On Mon, May 30, 2005 at 11:29:48PM -0400, Bruce Momjian wrote:
test= select 12345678901234567890 / 123;
?column?
100371373180768845
(1 row)
Well, that's a bug, right?
I don't think so. The fuller answer is
Bruce Momjian pgman@candle.pha.pa.us writes:
I found a discussion of this issue from December, 2004:
http://archives.postgresql.org/pgsql-general/2004-12/msg00070.php
That was the same complainant ;-)
I dug through the CVS history and determined that the behavior changed
at spi.c rev
33 matches
Mail list logo
