On 7/10/19 4:31 PM, Ryan Lambert wrote:
My exact situation was a deployment via sqitch, It appears that uses
psql under the hood based on the error message I get.
Yes it does:
https://sqitch.org/docs/manual/sqitch/
"Native scripting
Changes are implemented as scripts native to your selected d
My exact situation was a deployment via sqitch, It appears that uses psql
under the hood based on the error message I get.
Running just "sqitch deploy" I get an error due to a non-fully qualified
name and a missing search path (my mistakes). The error I get:
+ 004 .. psql:deploy/004.sql:72: E
> On Jul 10, 2019, at 7:38 PM, Bruce Momjian wrote:
>
> On Wed, Jul 10, 2019 at 09:08:30AM -0600, Roger Pack wrote:
>> I learned today there are "two" wiki pages for GUI clients:
>>
>> https://wiki.postgresql.org/wiki/PostgreSQL_Clients
>>
>> https://wiki.postgresql.org/wiki/Community_Guide_
On 7/10/19 1:19 PM, Ryan Lambert wrote:
I had a similar problem and was able to being the command with the
search_path to work around it. I did this on Linux and it looks like
you are on Windows but I maybe you can do something similar that will work?
PGOPTIONS='-c search_path=staging, transi
I had a similar problem and was able to being the command with the
search_path to work around it. I did this on Linux and it looks like you
are on Windows but I maybe you can do something similar that will work?
PGOPTIONS='-c search_path=staging, transient, pg_catalog'
*Ryan Lambert*
RustProof
On Wed, Jul 10, 2019 at 09:08:30AM -0600, Roger Pack wrote:
> I learned today there are "two" wiki pages for GUI clients:
>
> https://wiki.postgresql.org/wiki/PostgreSQL_Clients
>
> https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
>
> I'd like to DRY them up so there aren
Thanks Tom and Ian,
Tom, I wasn't sure if that would work (-c), so I just tried assuming it would
throw an error, but it didn't so I assumed it worked until I started checking
the tables and noticed it was still being created on data2. I tried originally
with just -f, but that didn't work so I
We have one database with several schemas. We have several groups of
developers that have the need to be able to collaborate including creating
and dropping tables.
I noticed it became difficult to manage because when one developer creates
a table, he is now the owner. All the other developers n
I learned today there are "two" wiki pages for GUI clients:
https://wiki.postgresql.org/wiki/PostgreSQL_Clients
https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
I'd like to DRY them up so there aren't two lists which confuses
newcomers. Any objections? If not I'll proba
On 7/10/19 5:09 AM, Weatherby,Gerard wrote:
My insert has a "returning clause," I don't think execute batch supports that.
Well it will execute, it just will not return the values to you:(
What is your query and what are you doing with it?
--
Gerard Weatherby| Application Architect
NMRbox |
Ian Barwick writes:
> On 7/10/19 2:56 AM, Alex Williams wrote:
>> 3. Restore the database with this command:
>> zcat /var/backup/db/mydatabase.gz | sudo -H -u postgres psql
>> --quiet -e -c 'SET default_tablespace = pg_default;' -f - mydatabase_test >
>> /tmp/mydatabase_test.log
My insert has a "returning clause," I don't think execute batch supports that.
--
Gerard Weatherby| Application Architect
NMRbox | Department of Molecular Biology and Biophysics | UConn Health
263 Farmington Avenue, Farmington, CT 06030-6406
Phone: 860 679 8484
uchc.edu
__
12 matches
Mail list logo
