Re: [Sqlrelay-discussion] problem with sqlrelay 0.35-10 when I use INSERT query

[Firstworks/4access <dav...@fi...>]

That's very strange.

Are you sure you're not using a different user to log in when using psql
than is in the connection's parameter string in your sqlrelay.conf file,
or a different database maybe?

David Muse
dav...@fi...

On Tue, 2005-08-23 at 09:28 +0200, RAVELSON Tanjona wrote:
> Hi,
> 
> i'm trying to use sqlrelay with postgresql : here is
> the output when i launch the command as root
> ('sqlr-start -id pg_registry -config ./sqlrelay.conf')
> 
> Starting listener:
>   sqlr-listener -id pg_registry -config
> ./sqlrelay-config.conf
> 
> Starting 3 connections to pg_registry :
>   sqlr-connection-postgresql -id pg_registry
> -connectionid pg_registry -config
> ./sqlrelay-config.conf
>   sqlr-connection-postgresql -id pg_registry
> -connectionid pg_registry -config
> ./sqlrelay-config.conf
>   sqlr-connection-postgresql -id pg_registry
> -connectionid pg_registry -config
> ./sqlrelay-config.conf
> 
> Starting scaler:
>   sqlr-scaler  -id pg_registry -config
> ./sqlrelay-config.conf
> 
> Starting cache manager:
>   sqlr-cachemanager
> 
> 
> Thanks to MP3.com for sponsoring:
>         Clustered/Replicated database support.
>         Perl API.
> 
> and i think it run very well. I also use 'sqlrsh -id
> pg_registry' to connect to the instance (it's ok) and
> i test with some SELECT and UPDATE QUERIES (it's also
> ok). Whereas i'm running an INSERT QUERIE command,
> there is an issue (the  postgres's user, that sqlrelay
> use for his connection,  don't have permission to
> launch the sql command from sqlrelay) : 
> 
> sqlrsh -id pg_registry
> SQLRShell - Version 0.22
>         Connected to: localhost:9000 as pgtest
> 
>         type help; for a help.
> 0> insert into hosts(name) values('srv.nic.mg');
> ERROR:  permission denied for sequence
> objects_global_id_seq
> 
> Attempted Query:
> insert into hosts(name) values('srv.nic.mg')
>         Rows Returned   : 0
>         Fields Returned : 0
>         System time     : 50000
> 
> On the other hand, it's ok when i use psql with the
> same user as sqlrelay use for connection.
> 
> why the execution of UPDATE goes well whereas the
> INSERT is not?
> 
> thanks.
> 
> Note : i use the lastest version of debian (sarge) and
> postgresql 7.4.3-3