[BUGS] column check mistake or not?

2011-05-09 Thread Rodriguez Fernando
Yesterday i did a mistake executing one query, i use a column daes not exists in the table the result was all rows of the table. Platform Fedora 14 32 bits Version Postgresql 9.0.2 The column id_documento not exists in t_log_modificar_deuda, this behavior is correct or not? query select * fro

[BUGS] BUG #6016: Documentation makes inappropriate reference to boolean logic

2011-05-09 Thread
The following bug has been logged online: Bug reference: 6016 Logged by: Email address: asuffi...@acunu.com PostgreSQL version: 9 (all) Operating system: documentation Description:Documentation makes inappropriate reference to boolean logic Details: Documentation s

Re: [BUGS] column check mistake or not?

2011-05-09 Thread Tom Lane
Rodriguez Fernando writes: > Yesterday i did a mistake executing one query, i use a column daes not > exists in the table the result was all rows of the table. > Platform Fedora 14 32 bits > Version Postgresql 9.0.2 > The column id_documento not exists in t_log_modificar_deuda, this > behavior

[BUGS] BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected

2011-05-09 Thread pedro mg
The following bug has been logged online: Bug reference: 6017 Logged by: pedro mg Email address: pe...@tquadrado.com PostgreSQL version: 8.4.8 Operating system: Ubuntu Linux 10.10 Description:COPY from CSV file, WITH CSV HEADER fields order not respected Details: Do

Re: [BUGS] BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected

2011-05-09 Thread Euler Taveira de Oliveira
Em 09-05-2011 15:07, pedro mg escreveu: # COPY test1 FROM '/tmp/test1.csv' WITH CSV HEADER Why don't you specify the columns? COPY test1 (key, c2, c1) FROM '/tmp/test1.csv' WITH CSV HEADER -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, De

Re: [BUGS] BUG #6016: Documentation makes inappropriate reference to boolean logic

2011-05-09 Thread Bruce Momjian
asuffi...@acunu.com wrote: > > The following bug has been logged online: > > Bug reference: 6016 > Logged by: > Email address: asuffi...@acunu.com > PostgreSQL version: 9 (all) > Operating system: documentation > Description:Documentation makes inappropriate referenc

Re: [BUGS] BUG #5800: "corrupted" error messages (encoding problem ?)

2011-05-09 Thread Robert Haas
On Thu, Apr 28, 2011 at 6:31 AM, Carlo Curatolo wrote: > Same test but with the 32bits version of PG9 > > The problem do NOT occurs... > > Everything works paerfectly everywhere... > > Where I have to post my problem to have a solution ? The problem isn't that you are posting in the wrong place,

Re: [BUGS] BUG #5992: The database cluster initialisation failed

2011-05-09 Thread Robert Haas
On Thu, Apr 21, 2011 at 11:16 AM, Nathan M. Davalos wrote: > I've had the same problem with server 2003. I usually create the folder where > PostgreSQL is going to install into first, then change the permissions for > "\users" to full control before attempting to install. > > -Original Messa

Re: [BUGS] Upgrading from 1.10 to 1.12 - cannot set up server

2011-05-09 Thread Robert Haas
On Fri, Apr 22, 2011 at 3:29 PM, Bryant, Alex wrote: > We are moving from PGAdmin III 1.10 on Windows XP Pro 32 bit to PG Admin III > on Windows 7 Enterprise 64-bit. PG Admin III installed without issue and the > computer is running all other database programs normally. > > When we open up PG Admi

Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

2011-05-09 Thread Robert Haas
On Tue, Apr 26, 2011 at 5:36 AM, Li Hongbing wrote: > I am trying to create a 64-bit postgresql 8.4 database server which can > retrieve data from Oracle(10gR2) at an other server by DBI-LINK. > > DBI-LINK works good on postgresql server site when I connect to linux by > telnet.When I connect to p