[GENERAL] Weird behavior of 'default user'

Hello! Look at this: -- adb=> create table hh (dd char(2) default user, ff int4); CREATE adb=> insert into hh (ff) values (5); INSERT 572034 1 adb=> select * from hh; dd |ff +-- leon| 5 (1 row) -- How can I understand that? Column dd is of type char(2), wher

[GENERAL] Cannot compile JDBC.

I download PostgreSQL-6.5 and want to compile jdbc, I'm using JDK1.1.7, while running make jdbc1 in /interfaces/jdbc directory, I got the error: postgres% make jdbc1 javac postgresql/Connection.java postgresql/Connection.java:7: Class postgresql.Field not found in import. import postgresql.Field;

Re: [GENERAL] Weird behavior of 'default user'

Leon wrote: > > Hello! > > Look at this: I, after a short investigation, I found that it is a BUG!!! Now I logged in as Postgres. Consider: --- adb=> select * from hh; dd |ff +-- leon| 5 le | 7 (2 rows) adb=> insert into hh (ff) values (9); INSERT 572224 1 adb=> select * from h

[GENERAL] If frontend dies?

Hi! It's me again. One more question: Suppose you begin a transaction, create a table and then your frontend dies. Backend still thinks that transaction is in progress and doesn't allow creation of table with the same name to other frontends. Restarting postmaster doesn't help. So here is the q

Re: [GENERAL] Weird behavior of 'default user'

> Hello! > > Look at this: > > -- > adb=> create table hh (dd char(2) default user, ff int4); > CREATE > adb=> insert into hh (ff) values (5); > INSERT 572034 1 > adb=> select * from hh; > dd |ff > +-- > leon| 5 > (1 row) > -- > > How can I understand that?