Re: [BUGS] BUG #1848: Segfault with pg_dump when database name omitted

2005-08-25 Thread Michael Fuhr
On Thu, Aug 25, 2005 at 07:41:59PM +0100, Eric Boutin wrote: > > [EMAIL PROTECTED] ~]$ pg_dump -U appserv -t tbl_dossiers -s > pg_dump: [archiver (db)] connection to database "Segmentation Fault (core > dumped) This might already be fixed in CVS: http://archives.postgresql.org/pgsql-committers/2

[BUGS] BUG #1848: Segfault with pg_dump when database name omitted

2005-08-25 Thread Eric Boutin
The following bug has been logged online: Bug reference: 1848 Logged by: Eric Boutin Email address: [EMAIL PROTECTED] PostgreSQL version: 8 Operating system: Solaris 10 amd64 Description:Segfault with pg_dump when database name omitted Details: Short example that te

[BUGS] auto type casting bug

2005-08-25 Thread Matthew Manuel
Hello, I found a strange error which occurs when I run a query from PHP4, where if there is a column which has strings arbitrarily defined text for all rows of a sub-select, and you attempt to sort by that column, it cannot determine the type for that column in order to do the sort.  - If you

Re: [BUGS] BUG #1844: Failed to start service 'PostgreSQL Database Server 8.0'

2005-08-25 Thread Gennadiy . Donchyts
No I didn't, thanks for pointing it, there are few other good advices. I've googled for my specific problem but cound not find any answer. However after reboot of machine it suddenly installed smoothly which is strange :(. I will make more extensive testing of PostgreSQL installation during testi

Re: [BUGS] PQconnectdb SSL (sslmode)

2005-08-25 Thread Michael Fuhr
On Thu, Aug 25, 2005 at 06:20:52PM -0700, vishal saberwal wrote: > > I am not sure if this is a bug. If you're not sure then it would be better to post to another mailing list like pgsql-general or one of the more specific lists. That would expose your question to a larger pool of expertise, and

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-25 Thread vishal saberwal
I have the answer for one of the two questions i asked: (a) all clients for a server will have same postgresql.key and .crt. (b) I still don't know: Machine A needs to talk (replicate for example: pgreplicator) to machine B. They both are servers on the same network with certificates from the sam

[BUGS] PQconnectdb SSL (sslmode)

2005-08-25 Thread vishal saberwal
hi, I am not sure if this is a bug. My PG_HBA.CONF local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.0.0/16 trust hostssl dbm all 192.168.200.201 255.255.255.255 md5 int ret=PQconnectdb("hostaddr=192.168.200.10 dbname=dbm user=postg

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-25 Thread vishal saberwal
thanks tom for the list on updates on 8.0.4, quick questions, Do all my clients have to have same postgresql.key and postgresql.crt, or can i have different keys and certificates on each client authenticating with the same server? Also, in case of multi master replication with multiple servers,

Re: [BUGS] BUG #1847: Error in some kind of UNION query.

2005-08-25 Thread Michael Fuhr
On Thu, Aug 25, 2005 at 09:53:26AM +0100, THIBAULT Jean-Jacques wrote: > > this query work : > select null UNION 1; Please show the *exact* query. The above produces a syntax error: test=> select null UNION 1; ERROR: syntax error at or near "1" at character 19 LINE 1: select null UNION 1;

Re: [BUGS] BUG #1847: Error in some kind of UNION query.

2005-08-25 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > You probably mean > SELECT NULL > UNION > SELECT NULL > UNION > SELECT 1 This has come up a couple of times before. It'd probably be possible to resolve the type across all the union'd selects at once, using the same rules as we do for CASE. The thing

Re: [BUGS] BUG #1847: Error in some kind of UNION query.

2005-08-25 Thread Andreas Pflug
THIBAULT Jean-Jacques wrote: The following bug has been logged online: Bug reference: 1847 Logged by: THIBAULT Jean-Jacques Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux (Mandrake) Description:Error in some kind of UNION query. De

[BUGS] BUG #1846: PostgreSQL oledb driver

2005-08-25 Thread Jim Alley
The following bug has been logged online: Bug reference: 1846 Logged by: Jim Alley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Windows Operating system: Windows XP Description:PostgreSQL oledb driver Details: When checking values of boolean fields thr

Re: [BUGS] Problemas durante a instalacao do postgresql 8.0.3 no suse sles 9

2005-08-25 Thread Elmival Sousa
thank you very much. I don't have very deep to know on BD, but your orientation was excellent. but once, thank you. Elmival. 2005/8/24, Alvaro Herrera <[EMAIL PROTECTED]>: > On Tue, Aug 23, 2005 at 05:55:25PM -0300, Elmival Sousa wrote: > > Estou tentando instalar o postgresql 8.0.3 no linux sus

[BUGS] BUG #1845: pg_dump data only COPY wrong order

2005-08-25 Thread Carlos Chávez
The following bug has been logged online: Bug reference: 1845 Logged by: Carlos Chávez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3-1 Operating system: Fedora Cora 4 kernel-2.6.12-1.1398 Description:pg_dump data only COPY wrong order Details: Hello to

[BUGS] BUG #1847: Error in some kind of UNION query.

2005-08-25 Thread THIBAULT Jean-Jacques
The following bug has been logged online: Bug reference: 1847 Logged by: THIBAULT Jean-Jacques Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux (Mandrake) Description:Error in some kind of UNION query. Details: this query work : sel