Re: [BUGS] BUG #1794: inheritance removes permissions from the parent table

2005-07-28 Thread Michael Fuhr
On Thu, Jul 28, 2005 at 03:56:14PM +0100, Sean Burlington wrote: > Michael Fuhr wrote: > > On Thu, Jul 28, 2005 at 12:48:35PM +0100, Sean Burlington wrote: > > > >>Description:inheritance removes permissions from the parent table > > > > I think a more accurate description would be "permi

Re: [BUGS] BUG #1790: coredump in postgres

2005-07-28 Thread Tom Lane
"Dmitry Karasik" <[EMAIL PROTECTED]> writes: > The following bug has been logged online: > Bug reference: 1790 > Logged by: Dmitry Karasik > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1-devel > Operating system: freebsd 5.4 > Description:coredump in postg

Re: [BUGS] BUG #1795: mirroring

2005-07-28 Thread Richard Huxton
kam k wrote: The following bug has been logged online: mirroring capability - replication. There are no adequate facilities for redundancy and replication. Plenty of options on the various unix platforms. If you want to speed progress on Windows ports, please feel free to assist the dbmirr

Re: [BUGS] Insert statement changes timestamp value from MS Access

2005-07-28 Thread Richard Huxton
David Dabney wrote: The more I thought about this I realized it's not a bug and I'm sorry to have perstered the list. The fact that the data logger was deployed before and after a time change and it was not setup to update itself created this problem. I just have to push forward all the times

Re: [BUGS] Insert statement changes timestamp value from MS Access

2005-07-28 Thread David Dabney
The more I thought about this I realized it's not a bug and I'm sorry to have perstered the list. The fact that the data logger was deployed before and after a time change and it was not setup to update itself created this problem. I just have to push forward all the times after the change an

Re: [BUGS] krb5 authentication and multihomed server hosts

2005-07-28 Thread Tom Lane
[EMAIL PROTECTED] (pod) writes: > I don't have time right now to investigate this behaviour further but I > will be revisiting this issue in relation to another project RSN. I will > endeavour to remember to report back if you so wish. Yes, please do. The krb_server_hostname functionality is new

Re: [BUGS] BUG #1796: UNION ALL of NULL <=> type = text so mimack pb

2005-07-28 Thread Michael Fuhr
On Thu, Jul 28, 2005 at 02:05:30PM +0100, Mansion wrote: > > on the table rien with the column "ordre" (int type) > When i write : > INSERT INTO rien (ordre) SELECT NULL UNION ALL SELECT NULL > i have the error : > column "ordre" is of type integer but expression is of type text The complete er

Re: [BUGS] BUG #1794: inheritance removes permissions from the parent table

2005-07-28 Thread Michael Fuhr
On Thu, Jul 28, 2005 at 12:48:35PM +0100, Sean Burlington wrote: > > Description:inheritance removes permissions from the parent table I think a more accurate description would be "permissions not inherited by children," and that isn't necessarily a bug. > If you create a new table that i

Re: [BUGS] Insert statement changes timestamp value from MS Access

2005-07-28 Thread David Dabney
Tom, Thanks for the quick reply and I'm sorry I wasn't explicit enough in my description. At the top of the attachment there is this section which is the piece of data from DD5 that is causing the problem: MS Access Details: DATA TO IMPORT FROM LOCAL MSACCESS Table into lin

Re: [BUGS] [postgres] Concat in Postgre

2005-07-28 Thread André Laugks
Hallo! von Stefan Miefert <[EMAIL PROTECTED]> am 28.07.2005: > Wie kann man eine Art Concat in Postgres bewerkstelligen? SELECT vorname || nachname || strasse || ort AS spalten FROM tabelle; -> HansMustermannMusterwegMusterleben SELECT vorname || ' ' || nachname || ' ' || strasse || ' ' || or

[BUGS] BUG #1793: ODBC crashs without C:\

2005-07-28 Thread H. Schumacher
The following bug has been logged online: Bug reference: 1793 Logged by: H. Schumacher Email address: [EMAIL PROTECTED] PostgreSQL version: psqlodbc Operating system: Windows Description:ODBC crashs without C:\ Details: I have installed the following packages psqlo

[BUGS] [postgres] Betrifft: Teilstring auslesen

2005-07-28 Thread marco_0160
--- In [EMAIL PROTECTED], Stefan Miefert <[EMAIL PROTECTED]> schrieb: > Hallo, > > wie kann ich in Postgre etwas ähnliches auslesen wie z.b: mit: > > LEFT(feldname,10) AS neuerwert > > Ich möchte aus einem Datumsfeld nur das Jahr auslesen. > > Eine zweite Frage wäre wie ich ein Datum das i

Re: [BUGS] [postgres] Teilstring auslesen

2005-07-28 Thread André Laugks
Hallo! von Stefan Miefert <[EMAIL PROTECTED]> am 27.07.2005: > wie kann ich in Postgre etwas ähnliches auslesen wie z.b: mit: > LEFT(feldname,10) AS neuerwert > Ich möchte aus einem Datumsfeld nur das Jahr auslesen. SELECT to_char(feldname, '') FROM tabelle; > Eine zweite Frage wäre wie

[BUGS] BUG #1794: inheritance removes permissions from the parent table

2005-07-28 Thread Sean Burlington
The following bug has been logged online: Bug reference: 1794 Logged by: Sean Burlington Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Debian GNU/Linux Description:inheritance removes permissions from the parent table Details: Hi, I'm

[BUGS] BUG #1792: Encoding vovels

2005-07-28 Thread Josef Springer
The following bug has been logged online: Bug reference: 1792 Logged by: Josef Springer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Win2k Description:Encoding vovels Details: I work an application using PostgreSQL via the ODBC driver

[BUGS] BUG #1795: mirroring

2005-07-28 Thread kam k
The following bug has been logged online: Bug reference: 1795 Logged by: kam k Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: WINDOWS XP Description:mirroring Details: mirroring capability - replication. There are no adequate facilities f

[BUGS] BUG #1796: UNION ALL of NULL <=> type = text so mimack pb

2005-07-28 Thread Mansion
The following bug has been logged online: Bug reference: 1796 Logged by: Mansion Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: windows XP Description:UNION ALL of NULL <=> type = text so mimack pb Details: on the table rien with the co

Re: [BUGS] krb5 authentication and multihomed server hosts

2005-07-28 Thread pod
> "TL" == Tom Lane <[EMAIL PROTECTED]> writes: TL> Well, actually, the subtext of my question is that we now support TL> what's effectively multiple VirtualHosts (see the listen_addresses TL> parameter), and I was wondering if that means that TL> krb_server_hostname needs to ha