Re: [ADMIN] Create relation

On Sat, May 28, 2005 at 02:23:05PM +0530, Vamsi Krishna G wrote: > i am new postgress.i need some help.i have pgs-8.0.3 source code. > i want to study pgs source code.can any body help which files should i > study and form where should i start .first of all i want to know how > CREATE RELA

Re: [ADMIN] who can create schema?

Richard Hayward <[EMAIL PROTECTED]> writes: > I'm trying to investigate why users can create new schema within a > database, without being explicitly being granted create permission on > that database. By default, they can't. Perhaps you granted create permission on the database to PUBLIC? Also,

[ADMIN] \x89\xBD\x82\xC5\x82\xE0\x8C\xA9\x95\xFA\x91\xE8\x82\xBE\x82\xA9\x82\xE7H\x82\xC8\x89\xE6\x91\x9C\x82\xE0\x81H

„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª (B (B[EMAIL PROTECTED] (B (B„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª„ª (B[EMAIL PROTECTED] (B (B‚±‚̃`ƒ…[ƒi[‚P‘ä‚ŃAƒ_ƒ‹ƒgŽO–†AƒXƒ|[EMAIL PROTECTED] (B (B[EMAIL PROTECTED]@‚©‚çiŒÀ’è30‘äj (B (Bš‘å”——́š5.1chƒTƒ‰ƒEƒ“ƒhƒVƒ

Re: [ADMIN] How stable is version 8.0.3

Gourish Singbal wrote: How stable is Release 8.0.3 as compared to Release 8.0.2, Release 8.0.1 and Release 8.0 ?. Since it been only a few days its been released has anybody faced any drastic issues with this release. All clear in production. -- Wbr, Sergey Moiseev -

[ADMIN] ERROR: CREATE DATABASE: source database "template1" is being accessed by other users

Hi all, Please could you explain me why PostgreSQL doesn't allow to create a database while some user is accessing other databases? template1-# create database vet; ERROR: CREATE DATABASE: source database "template1" is being accessed by other users I can find nothing about it in documen

[ADMIN] Major flood of mail to lists ...

Do to moderator error (namely, mine), several hundred messages (spread across all the lists) were just approved ... Sorry for all the incoming junk :( Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

[ADMIN] who can create schema?

PostgreSQL 7.3.2 I'm trying to investigate why users can create new schema within a database, without being explicitly being granted create permission on that database. I cant find a command that lists what privileges users have been granted within a database. Can they create new schema or not?

[ADMIN] new antidote discovered

binZGFcxNcYGN.bin Description:

Re: [ADMIN] who can create schema?

On Sat, 28 May 2005 11:13:48 +0100, Richard Hayward <[EMAIL PROTECTED]> wrote: >PostgreSQL 7.3.2 >And then, within a given schema, how could I list who can create new >objects? ok, I've found the answer to this bit: Upgrading to 8.0.3 gives the psql \dn+ command. However \l+ does not return th

[ADMIN] Create relation

hello, i am new postgress.i need some help.i have pgs-8.0.3 source code. i want to study pgs source code.can any body help which files should i study and form where should i start .first of all i want to know how CREATE RELATION is happening in pgsql.In which file i can find this. th

[ADMIN] Create relation

hello, i am new postgress.i need some help.i have pgs-8.0.3 source code. i want to study pgs source code.can any body help which files should i study and form where should i start .first of all i want to know how CREATE RELATION is happening in pgsql.In which file i can find this. thanx,

Re: [ADMIN] Question of Table Design and Foreign Keys

Hi Jason, many thanks Jason for your reply. On Tuesday, May 31, 2005, at 11:25 AM, Jason Minion wrote: I think the way you want to look at it is: if a record exists in sample_attributesjoin, then it needs to reference both samples and attributes. You don't need to worry about samples or attribu

Re: [ADMIN] RHE v3

Hi, On Tue, 31 May 2005, Jamie Bohr wrote: All I can say if duh! I went down the 1.2.1 tree which does not have RPM's for RHE or FC? It's compeletely my fault -- missed 1.2.1 release news. Not kidding. -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr ht

Re: [ADMIN] RHE v3

All I can say if duh!  I went down the 1.2.1 tree which does not have RPM's for RHE or FC?  1.20 RPM tree does.  I should have looked, sorry, http://www.postgresql.org/ftp/pgadmin3/release/v1.2.0/ Thank you again, JamieOn 5/29/05, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED ME

Re: [ADMIN] Question of Table Design and Foreign Keys

I think the way you want to look at it is: if a record exists in sample_attributesjoin, then it needs to reference both samples and attributes. You don't need to worry about samples or attributes being "off" because they don't have "enough" references, instead you want to ensure that if a record ex

[ADMIN] error in installation

Hello,   I get the following error when I try to install postpresql 8.0.3 on a Unix Solaris 8 machine.   > ./configure checking build system type... sparc-sun-solaris2.8 checking host system type... sparc-sun-solaris2.8 checking which template to use... solaris checking whether to build with 64-b

[ADMIN] Question of Table Design and Foreign Keys

I have a few tables that I want to join. My example is below. What I am trying to figure out is what is better to do for data integrity. I will be joining the samples table with the sample_attributes table to obtain the attributes of a sample. The attribute id will reference an attribute in

[ADMIN] Starting postgres server second time using admin rights...

I have installed postgres server 8.0. When i start the server it works fine,but when i stop the server and then restart the server,it gives me an message that admin cannot start the server. I also attempted to start the server from net.exe in postgres where i wrote start pg-sql8.0 It gave me t

Re: [ADMIN] Starting postgres server second time using admin rights...

Am Dienstag, 31. Mai 2005 10:43 schrieb rohan rasane: > I have installed postgrest server. > When i start the server it works fine,but when i stop the server and > then restart the server,it gives me an message that admin cannot > start the server. > Can anyone suggest me a solution No, but you c

[ADMIN] Starting postgres server second time using admin rights...

I have installed postgrest server. When i start the server it works fine,but when i stop the server and then restart the server,it gives me an message that admin cannot start the server. Can anyone suggest me a solution -- Regards Rohan Rasane ---(end of broadcast)--