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
__
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
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 |
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
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
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
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
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 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
> 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_
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 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
12 matches
Mail list logo
