Bruce Momjian 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 1.87:
2003-03-09 22:53
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
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 del
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 ()
"Industry suffers from the managerial
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 12
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 FOU
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 passw
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 o
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 carriag
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 t
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() is
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 broa
Bruce Momjian 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, or want to vote with
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 res
Tom Lane wrote:
> Has anyone bothered to actually look into the code?
>
> regression=# select power(2::numeric,1000);
>
> power
> -
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 gener
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):
> INSERT INTO sometable ( someint4field ) VALUES ( '' );
>
> To work.
Sorry, an empty string is not an integer. If you want NUL
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
better.
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 authentication
-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
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 <[EMA
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
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 pas
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 in
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 broadcast)--
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
> > > d
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
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
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 eac
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
FROM
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
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
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
33 matches
Mail list logo
