[SQL] Problem on CREATE/ALTER USER

hello i've got a problem on CREATE USER and ALTER USER when i have many users connected. i have prosgresql 7.1 running on Redhat 7.0 is this a bug in postgres? pls let me know. thanks richard. ---(end of broadcast)--- TIP 4: Don't 'kill -9'

[SQL] help

help me pls. i got an error like this when i do an insert to a table, my table dont have bpchar type of field. ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar' You will have to retype this query using an explicit cast it seems 1 field in my table has bpchar t

[SQL] help

help me pls. i got an error like this when i do an insert to a table, my table dont have bpchar type of field. ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar' You will have to retype this query using an explicit cast ---(end of broad

Re: [SQL] Multicolumn primary keys and multicolumn foreign keys

On Sun, 28 Jan 2001, Ferruccio Zamuner wrote: > Hi, > > I've found a trouble and I've tried to avoid it without success: > > --- > create table companies ( >id serial not null primary key, >firm_name text not null, >activity text > ); > > create table customers ( >

[SQL] plpgsql language

hello, i got this error when i tried to create a function "unrecognized language specified in CREATE FUNCTION: 'plpgsql'" why is that?

[SQL] retrieving user's groups

hello, how will i retrieve group names of a certain user? using sql. richard