Re: Patch to allow setting schema/search_path in the connectionURL

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Patch to allow setting schema/search_path in the connectionURL
Дата
Msg-id 542103B8.1080208@hogranch.com
обсуждение исходный текст
Ответ на Re: Patch to allow setting schema/search_path in the connectionURL  (stagirus <mamasa@stagirus.com>)
Ответы Re: Patch to allow setting schema/search_path in the connectionURL
Список pgsql-jdbc
On 9/22/2014 10:17 PM, stagirus wrote:
> Your above response almost gave a hope. But not too long.
> All DDLs are going to the public schema. I get the errors as follows:
>
>   Error executing SQL CREATE TABLE public.databas...
> Caused by: org.postgresql.util.PSQLException: ERROR: schema "public" does
> not exist

huh.  works in SQL.


$ psql
psql (9.3.5)
Type "help" for help.

postgres=# create database test;
CREATE DATABASE
postgres=# \c test
You are now connected to database "test" as user "postgres".
test=# create schema myschema;
CREATE SCHEMA
test=# set search_path to myschema;
SET
test=# drop schema public;
DROP SCHEMA
test=# create table stuff (id serial primary key, val text);
CREATE TABLE
test=# \d
                List of relations
   Schema  |     Name     |   Type   |  Owner
----------+--------------+----------+----------
  myschema | stuff        | table    | postgres
  myschema | stuff_id_seq | sequence | postgres
(2 rows)

test=#



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: stagirus
Дата:
Сообщение: Re: Patch to allow setting schema/search_path in the connectionURL
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Patch to allow setting schema/search_path in the connectionURL