Editing problem for bool fields with not null
| От | Vladimir Kokovic |
|---|---|
| Тема | Editing problem for bool fields with not null |
| Дата | |
| Msg-id | 46EE7E33.2070609@a-asoft.com обсуждение исходный текст |
| Ответы |
Re: Editing problem for bool fields with not null
(Dave Page <dpage@postgresql.org>)
|
| Список | pgadmin-support |
Hi, I've tried to edit BOOL NOT NULL field which have value TRUE within 'Edit Data' window, but error dialog appeared with text "ERROR: null value in column "vazeci" violates not-null constraint" even field has DEFAULT TRUE clause ! My OS is kubuntu 7.10 (gutsy) --------------------------------------------------- uname -a Linux vladakk-asoft 2.6.22-11-generic #1 SMP Fri Sep 7 05:07:05 GMT 2007 i686 GNU/Linux My pgadmin3 build ---------------------------------------------- 1. svn 6646 2. sh bootstrap 3. ./configure > configure-out.log 2>&1 4. make > make-out.log 2>&1 5. make install > make-install-out.log 2>&1 Best regards, Vladimir Kokovic, DP senior, Belgrade, Serbia checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes checking how to create a ustar tar archive... gnutar checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for style of include used by make... GNU checking dependency style of gcc... gcc3 checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... gcc3 checking whether to use precompiled headers... yes checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking arpa/inet.h usability... yes checking arpa/inet.h presence... yes checking for arpa/inet.h... yes checking netdb.h usability... yes checking netdb.h presence... yes checking for netdb.h... yes checking netinet/in.h usability... yes checking netinet/in.h presence... yes checking for netinet/in.h... yes checking for stdlib.h... (cached) yes checking for stdbool.h that conforms to C99... yes checking for _Bool... yes checking for an ANSI C-conforming const... yes checking for size_t... yes checking whether time.h and sys/time.h may both be included... yes checking for working strtod... yes checking for gethostbyname... yes checking for inet_ntoa... yes checking for memmove... yes checking for memset... yes checking for strchr... yes checking for PQexec in -lpq... yes checking for SSL_connect in -lpq... yes checking for krb5_free_principal in -lpq... yes checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes checking PostgreSQL in /usr... ok checking for PQgetOutResult in -lpq... no checking wxWidgets version... ok checking wxWidgets in /usr... ok checking libxml2 in /usr... ok checking libxml2 version... ok checking libxslt in /usr... ok configure: creating ./config.status config.status: creating Makefile config.status: creating branding/Makefile config.status: creating i18n/Makefile config.status: creating pgadmin/Makefile config.status: creating pkg/Makefile config.status: creating pkg/debian/Makefile config.status: creating pkg/mac/Makefile config.status: creating pkg/mandrake/Makefile config.status: creating pkg/redhat/Makefile config.status: creating pkg/slackware/Makefile config.status: creating pkg/src/Makefile config.status: creating pkg/suse/Makefile config.status: creating pkg/win32/Makefile config.status: creating xtra/Makefile config.status: creating xtra/pgaevent/Makefile config.status: creating xtra/pgagent/Makefile config.status: creating xtra/wx-build/Makefile config.status: creating config.h config.status: executing depfiles commands PostgreSQL directory: /usr PostgreSQL pg_config binary: /usr/bin/pg_config PostgreSQL version: PostgreSQL 8.2.4 PostgreSQL SSL support: Present wxWidgets directory: /usr wxWidgets wx-config binary: /usr/bin/wx-config wxWidgets version: wxWidgets 2.8.4 libxml2 directory: /usr libxml2 xml2-config binary: /usr/bin/xml2-config libxml2 version: libxml2 2.6.29 libxslt directory: /usr libxslt xslt-config binary: /usr/bin/xslt-config libxslt version: libxslt 1.1.21 Building a debug version of pgAdmin: No Statically linking pgAdmin: No Building a Mac OS X appbundle: No pgAdmin configuration is now complete. You can now compile and install pgAdmin using 'make; make install'.
В списке pgadmin-support по дате отправления: