Hello PostgreSQL developers,
I received a request to support system-wide root certificates in
libpq. Right now it only looks in ~/.postgresql/root.crt, but since
such certificates are usually set up system wide and be maintained by
the sysadmins, it would be very convenient if there was a fallback
Josh Berkus writes:
> However, given that the issue has existed for a year or more and I'm the
> first one to report it formally, it clearly isn't that huge of an issue.
Longer than that.
> Any idea what version this got broken in?
Presumably, when we added ALTER SEQUENCE OWNED BY, which seems
> We could in theory back-patch this, since CreateSeqStmt won't ever go to
> disk in stored rules. However, tweaking DefineRelation's API in stable
> branches seems fairly hazardous to third-party code. Does it seem
> sufficient to fix the problem in 9.0 and up?
Might be worth asking a few inte
Mariusz Majer writes:
> I am using postgresql-8.2-504.jdbc3.jar driver.
> When I add one row from psql:
> - in net_source I got null value,
> while adding new order from application using JDBC
> - in net_source I got 'UL' value
> ...so in my opinion it might be issue with JDBC (maybe too old JD
Great!
Thanks a lot!
2010/8/16 Mike Fowler
> On 16/08/10 15:03, Felipe Lopes wrote:
>
>> I would like to run a line command (psql) with the supplied password
>> without pausing the command, but this option is not available:
>> psql --username=root --password=root my_bd < "script.sql"
>> Th
Felipe Lopes writes:
> I would like to run a line command (psql) with the supplied password without
> pausing the command, but this option is not available:
> psql --username=root --password=root my_bd < "script.sql"
This is intentionally not supported. If it were supported it would be
insecure
On 16/08/10 15:03, Felipe Lopes wrote:
I would like to run a line command (psql) with the supplied password
without pausing the command, but this option is not available:
psql --username=root --password=root my_bd < "script.sql"
The pass only can be informed after execution, pausing the command:
I would like to run a line command (psql) with the supplied password without
pausing the command, but this option is not available:
psql --username=root --password=root my_bd < "script.sql"
The pass only can be informed after execution, pausing the command:
psql --username=root --password my_bd
I am using postgresql-8.2-504.jdbc3.jar driver.
I altered table ecom2_orders using psql (not JDBC to exclude its influence):
ALTER TABLE ecom2_orders ALTER COLUMN net_source SET DEFAULT NULL;
Now when you enter command:
\d ecom2_orders
you got:
net_source | character varyin
